Hi there, what do I need to take into consideration if I want Asterisk to talk to a MySQL database on a different host to store CDR records? The cdr_addon_mysql module does not want to load and Asterisk claims that it "cannot open shared object". It compiled fine, however. Any ideas? Cheers, Oliver.
Oliver Breidenbach wrote:> Hi there, > > what do I need to take into consideration if I want Asterisk to talk > to a MySQL database on a different host to store CDR records? > > The cdr_addon_mysql module does not want to load and Asterisk claims > that it "cannot open shared object". > > It compiled fine, however. > > Any ideas? > > Cheers, > > Oliver. > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >i am use mysql on another host. my cdr_mysql.conf: [global] hostname=www.XXXXXXX.com dbname=asterisk password=XXXXXX user=asterisk ;port=3306 sock=/var/lib/mysql/mysql.sock ;userfield Bye Carlos
Carlos, thanks for the answer. You sure that you need the sock=/var/lib/mysql/mysql.sock directive? Regards, Oliver. On 07.09.2004, at 23:00, Carlos Gabriel Drach wrote:> Oliver Breidenbach wrote: > >> Hi there, >> >> what do I need to take into consideration if I want Asterisk to talk >> to a MySQL database on a different host to store CDR records? >> >> The cdr_addon_mysql module does not want to load and Asterisk claims >> that it "cannot open shared object". >> >> It compiled fine, however. >> >> Any ideas? >> >> Cheers, >> >> Oliver. >> >> _______________________________________________ >> Asterisk-Users mailing list >> Asterisk-Users@lists.digium.com >> http://lists.digium.com/mailman/listinfo/asterisk-users >> To UNSUBSCRIBE or update options visit: >> http://lists.digium.com/mailman/listinfo/asterisk-users >> > i am use mysql on another host. > > my cdr_mysql.conf: > > [global] > hostname=www.XXXXXXX.com > dbname=asterisk > password=XXXXXX > user=asterisk > ;port=3306 > sock=/var/lib/mysql/mysql.sock > ;userfield> > Bye > > Carlos > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
sock(s) are only used when connecting to a mysql server that is located on the same machine. So if you are connecting to a MySQL server on another host then you do not need the sock= directive. Matthew ----- Original Message ----- From: "Oliver Breidenbach" <oliver.b@gebe.net> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Sent: Tuesday, September 07, 2004 4:28 PM Subject: Re: [Asterisk-Users] MySQL on another host?> Carlos, > > thanks for the answer. > > You sure that you need the sock=/var/lib/mysql/mysql.sock directive? > > Regards, > > Oliver. > > On 07.09.2004, at 23:00, Carlos Gabriel Drach wrote: > > > Oliver Breidenbach wrote: > > > >> Hi there, > >> > >> what do I need to take into consideration if I want Asterisk to talk > >> to a MySQL database on a different host to store CDR records? > >> > >> The cdr_addon_mysql module does not want to load and Asterisk claims > >> that it "cannot open shared object". > >> > >> It compiled fine, however. > >> > >> Any ideas? > >> > >> Cheers, > >> > >> Oliver. > >> > >> _______________________________________________ > >> Asterisk-Users mailing list > >> Asterisk-Users@lists.digium.com > >> http://lists.digium.com/mailman/listinfo/asterisk-users > >> To UNSUBSCRIBE or update options visit: > >> http://lists.digium.com/mailman/listinfo/asterisk-users > >> > > i am use mysql on another host. > > > > my cdr_mysql.conf: > > > > [global] > > hostname=www.XXXXXXX.com > > dbname=asterisk > > password=XXXXXX > > user=asterisk > > ;port=3306 > > sock=/var/lib/mysql/mysql.sock > > ;userfield> > > > Bye > > > > Carlos > > > > _______________________________________________ > > Asterisk-Users mailing list > > Asterisk-Users@lists.digium.com > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
Clive
2005-Jan-06 11:12 UTC
[Asterisk-Users] capi help please..(capi not installed - No such device or address (6) )
Hi I wonder if anyone has had a similar trouble. I have googled and no solutions. Asterisk wont load because capi wont load. When I do "capiinfo" I get: capi not installed - No such device or address (6) I have a eicon 4bri card installed, with the patched kernel with the melware.de files. No irq conflicts., and the dmesg shows this: capifs: Rev 1.1.4.1 CAPI-driver Rev 1.1.4.1: loaded capi20: started up with major 68 kcapi: capi20 attached capi20: Rev 1.1.4.2: started up with major 68 (middleware+capifs) I have modprobed capi with no error messages. If anyone has any suggestions, they will be appreciated. Thanks Clive
Philipp Ebneter
2005-Jan-09 04:39 UTC
[Asterisk-Users] capi help please..(capi not installed - No such device or address (6) )
Hi Clive, I ran into a similar problem: I also have a eicon 4bri and tried to install it on a dell server with redhat as 3. The problem I have is that I always got a error message when doing "modprobe capi". The module is compiled in the kernel (it shows up with "lsmod"). I have not found any solution so far - in the end I had to install asterisk on a different machine. I guess there must be some interrupt problem and maybe this is also the root of your problem. regards philipp Clive wrote:>Asterisk wont load because capi wont load. >When I do "capiinfo" I get: >capi not installed - No such device or address (6) > >I have a eicon 4bri card installed, with the patched kernel with the >melware.de files. No irq conflicts., and the dmesg shows this: > >capifs: Rev 1.1.4.1 >CAPI-driver Rev 1.1.4.1: loaded >capi20: started up with major 68 >kcapi: capi20 attached >capi20: Rev 1.1.4.2: started up with major 68 (middleware+capifs) > >I have modprobed capi with no error messages. > >
Clive
2005-Jan-09 05:19 UTC
[Asterisk-Users] capi help please..(capi not installed - No such device or address (6) )
Yay, I got it working.! I added CAPI verbose reason reporting to the kernel, and modprobed as follows: capi, kernelcapi, divacapi, divas and then loaded divactrl and it works!!, yay....now to figure out how to get Asterisk to load with capi...my .conf files seem to be wrong Thanks for everyones help. regards Clive On 9 Jan 2005 at 12:39, Philipp Ebneter wrote:> Hi Clive, > > I ran into a similar problem: I also have a eicon 4bri and tried to > install it on a dell server with redhat as 3. > The problem I have is that I always got a error message when doing > "modprobe capi". The module is compiled in the kernel (it shows up with > "lsmod"). > I have not found any solution so far - in the end I had to install > asterisk on a different machine. I guess there must be some interrupt > problem and maybe this is also the root of your problem. > > regards > philipp > > Clive wrote: > > >Asterisk wont load because capi wont load. > >When I do "capiinfo" I get: > >capi not installed - No such device or address (6) > > > >I have a eicon 4bri card installed, with the patched kernel with the > >melware.de files. No irq conflicts., and the dmesg shows this: > > > >capifs: Rev 1.1.4.1 > >CAPI-driver Rev 1.1.4.1: loaded > >capi20: started up with major 68 > >kcapi: capi20 attached > >capi20: Rev 1.1.4.2: started up with major 68 (middleware+capifs) > > > >I have modprobed capi with no error messages. > > > > > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users