Has anyone experienced an unstable Asterisk server when using CDR MySQL. Asterisk keeps crashing or answering the incoming lines with a fax/modem sound when I use the cdr_mysql module. When I remove it, I have no problems. Tim -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20030806/6ad71b96/attachment.htm
Good day all What do i need,and need to do,from the beginig to get the cdr into a database I installed asteris,mysql and mysl-dev.. I got the asterisk-addons I made a make and it said it could not find asterisk.h so I copyed asteris.h from my installed file to /user/include I then followed theis howto http://www.voip-info.org/wiki-Asterisk+cdr+mysql and chane the conf files with the same usernames ens.But this is the error I get" Nov 12 13:52:04 ERROR[79866800]: cdr_addon_mysql.c:122 mysql_log: cdr_mysql: cannot connect to database server 192.168.21.127. Call will not be logged" Please Help
Did you checkout permissions, mysql running? Guido Rebert Network Manager GrupoPyD - +54 11 55554800 -----Mensaje original----- De: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] En nombre de Altus Snyman Enviado el: Viernes, 12 de Noviembre de 2004 08:30 a.m. Para: Asterisk Users Mailing List - Non-Commercial Discussion Asunto: [Asterisk-Users] cdr mysql Good day all What do i need,and need to do,from the beginig to get the cdr into a database I installed asteris,mysql and mysl-dev.. I got the asterisk-addons I made a make and it said it could not find asterisk.h so I copyed asteris.h from my installed file to /user/include I then followed theis howto http://www.voip-info.org/wiki-Asterisk+cdr+mysql and chane the conf files with the same usernames ens.But this is the error I get" Nov 12 13:52:04 ERROR[79866800]: cdr_addon_mysql.c:122 mysql_log: cdr_mysql: cannot connect to database server 192.168.21.127. Call will not be logged" Please Help _______________________________________________ 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004
Dear Tomislav & Colleagues, I read your post in the Astersik-list about you can not compile the cdr_mysql on Asterisk 1.2 Well, I have a similar problem. I compiled the cdr_mysql module, but when i start Asterisk the following error appears: Dec 12 18:03:33 WARNING[7237]: loader.c:325 __load_resource: /usr/lib/asterisk/modules/cdr_addon_mysql.so: undefined symbol: ast_load Dec 12 18:03:33 WARNING[7237]: loader.c:554 load_modules: Loading module cdr_addon_mysql.so failed! And Asterisk stops. Any ideas? Thank you in advance, Juanjo -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051212/25c44d08/attachment.htm
What does your /etc/asterisk/cdr_mysql.conf look like? On 12/12/05, Juanjo Portela <juanjo.portela@gmail.com> wrote:> > Dear Tomislav & Colleagues, > > I read your post in the Astersik-list about you can not compile the > cdr_mysql on Asterisk 1.2 > Well, I have a similar problem. > I compiled the cdr_mysql module, but when i start Asterisk the following > error appears: > > Dec 12 18:03:33 WARNING[7237]: loader.c:325 __load_resource: > /usr/lib/asterisk/modules/cdr_addon_mysql.so: undefined symbol: ast_load > Dec 12 18:03:33 WARNING[7237]: loader.c:554 load_modules: Loading module > cdr_addon_mysql.so failed! > > And Asterisk stops. > > Any ideas? > > Thank you in advance, > Juanjo > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051212/6f4728a1/attachment.htm
My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as follow [global] hostname=localhost dbname=dbasterisk password=dbpassword user=dbuser userfield=1 Any ideas? Thank you in advance, Juanjo
Is your mysql server running locally the same time your starting asterisk? On 12/12/05, Juanjo Portela <juanjo.portela@gmail.com> wrote:> > My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as > follow > [global] > hostname=localhost > dbname=dbasterisk > password=dbpassword > user=dbuser > userfield=1 > Any ideas? > Thank you in advance, > Juanjo > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051212/e0ad8b26/attachment.htm
I believe you are missing 2 variables in your conf file: table=cdr (the table your cdrs should be stored) sock=/var/lib/mysql/mysql.sock (the location to your mysql.sock) try something like this: [global] hostname=localhost dbname=dbasterisk table=cdr password=dbpassword user=dbuser sock=/var/lib/mysql/mysql.sock userfield=1 On 12/12/05, Juanjo Portela <juanjo.portela@gmail.com> wrote:> > My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as > follow > [global] > hostname=localhost > dbname=dbasterisk > password=dbpassword > user=dbuser > userfield=1 > Any ideas? > Thank you in advance, > Juanjo > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051212/6838e228/attachment.htm
Thank you Traci, I put this two variables in my .conf file and it works!!! Well, It seems that this variables are not necessaries in old versions, but in newest ones. Thank you again, Juanjo>I believe you are missing 2 variables in your conf file: > > >table=cdr >(the table your cdrs should be stored) > >sock=/var/lib/mysql/mysql.sock >(the location to your mysql.sock) > >try something like this: > >[global] >hostname=localhost >dbname=dbasterisk >table=cdr >password=dbpassword >user=dbuser >sock=/var/lib/mysql/mysql.sock >userfield=1-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051213/5c90c63b/attachment.htm