eduardo@garnier.inf.br
2005-Feb-27 16:53 UTC
[Asterisk-Users] CDR's are not stored in mysql
Hi guys, I would llike to ask for your help on a problem I'm having with the cdr functionality. I installed asterisk 1.0.4, and asterisk-addons-1.0.4 and followed the procedures for installation and mysql configuration. Everything seems fina. The cdr_mysql module is loaded, and I get no error messages. But the cdr's are not going to the mysql database, they are going to a csv file in /var/ log/asterisk/cdr. The cdr table in mysql remains empty. What should I do to store the cdr data in the mysql database instead of the csv file? Thank you very much.
Have you checked the debug log? It will show you the actual mysql query used and any possible errors. -Matthew> From: <eduardo@garnier.inf.br> > Reply-To: <eduardo@garnier.inf.br>, Asterisk Users Mailing List - > Non-Commercial Discussion <asterisk-users@lists.digium.com> > Date: Sun, 27 Feb 2005 20:53:17 -0300 > To: <asterisk-users@lists.digium.com> > Subject: [Asterisk-Users] CDR's are not stored in mysql > > Hi guys, > > I would llike to ask for your help on a problem I'm having with the cdr > functionality. I installed asterisk 1.0.4, and asterisk-addons-1.0.4 and > followed the procedures for installation and mysql configuration. Everything > seems fina. The cdr_mysql module is loaded, and I get no error messages. But > the > cdr's are not going to the mysql database, they are going to a csv file in > /var/ > log/asterisk/cdr. > > The cdr table in mysql remains empty. What should I do to store the cdr data > in > the mysql database instead of the csv file? > > Thank you very much. > _______________________________________________ > 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
Just check wether you have running mysql with the user name and host and database provided in cdr_mysql.conf. Thanks & Regards Ritesh Jalan ----- Original Message ----- From: <eduardo@garnier.inf.br> To: <asterisk-users@lists.digium.com> Sent: Monday, February 28, 2005 5:23 AM Subject: [Asterisk-Users] CDR's are not stored in mysql> Hi guys, > > I would llike to ask for your help on a problem I'm having with the cdr > functionality. I installed asterisk 1.0.4, and asterisk-addons-1.0.4 and > followed the procedures for installation and mysql configuration.Everything> seems fina. The cdr_mysql module is loaded, and I get no error messages.But the> cdr's are not going to the mysql database, they are going to a csv file in/var/> log/asterisk/cdr. > > The cdr table in mysql remains empty. What should I do to store the cdrdata in> the mysql database instead of the csv file? > > Thank you very much. > _______________________________________________ > 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