[asterisk-users] Asterisk CDR MySQL
I'm attempting to setup Asterisk 1.4.0 CDRs to use MySQL. Modules show like cdr_mysql.so tells me it is loaded. Reload cdr with MySQL started or stopped makes no difference in the errors. Ideas? ___ --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
Re: [asterisk-users] Asterisk CDR MySQL
Mike Hammett wrote: I’m attempting to setup Asterisk 1.4.0 CDRs to use MySQL. Modules show like cdr_mysql.so tells me it is loaded. Reload cdr with MySQL started or stopped makes no difference in the errors. Ideas? ___ --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 do you have cdr_mysql.conf well configured and write permmission granted to sql user.? give a verbose and debug to ur logger to know whether asterisk is attempting login or not. goksie ___ --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
Re: [Asterisk-Users] Asterisk cdr mysql
hum, may be a mismatching between the asterisk source and the mysql module source. Where are you getting the sources and please explain how are you starting the compilation. Best RegardsOn 11/27/05, Abdul Lateef Khan [EMAIL PROTECTED] wrote: Hi all,Did anyone installed asterisk-addons successfull? Becuase i am gettingsome error in installation.Error:cdr_addon_mysql.c: In function `my_load_module':cdr_addon_mysql.c:292: warning: assignment makes pointer from integer without a castcc -shared -Xlinker -x -o cdr_addon_mysql.so cdr_addon_mysql.o-lmysqlclient -lz-L/usr/lib/mysqlcc -fPIC -I../asterisk -D_GNU_SOURCE-I/usr/include/mysql -c -oapp_addon_sql_mysql.o app_addon_sql_mysql.c app_addon_sql_mysql.c:164:64: macro AST_LIST_REMOVE requires 4arguments, but only 3 givenapp_addon_sql_mysql.c: In function `del_identifier':app_addon_sql_mysql.c:164: `AST_LIST_REMOVE' undeclared (first use in this function)app_addon_sql_mysql.c:164: (Each undeclared identifier is reported only onceapp_addon_sql_mysql.c:164: for each function it appears in.)make: *** [app_addon_sql_mysql.o] Error 1rm app_saycountpl.o Please help me how i can load this mysql cdr module?--Best Regards,Abdul Lateef KhanComputer ProgrammerMobile No. : +974 - 5405022ICQ : 276-994-704YM! : [EMAIL PROTECTED]MSN : [EMAIL PROTECTED]Google Talk : [EMAIL PROTECTED]___ --Bandwidth and Colocation provided by Easynews.com --Asterisk-Users mailing listTo UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users-- Su nombre es GNU/Linux, no solamente Linux, mas info en http://www.gnu.org ___ --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
[Asterisk-Users] Asterisk cdr mysql
Hi all, Did anyone installed asterisk-addons successfull? Becuase i am getting some error in installation. Error: cdr_addon_mysql.c: In function `my_load_module': cdr_addon_mysql.c:292: warning: assignment makes pointer from integer without a cast cc -shared -Xlinker -x -o cdr_addon_mysql.so cdr_addon_mysql.o -lmysqlclient -lz -L/usr/lib/mysql cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o app_addon_sql_mysql.o app_addon_sql_mysql.c app_addon_sql_mysql.c:164:64: macro AST_LIST_REMOVE requires 4 arguments, but only 3 given app_addon_sql_mysql.c: In function `del_identifier': app_addon_sql_mysql.c:164: `AST_LIST_REMOVE' undeclared (first use in this function) app_addon_sql_mysql.c:164: (Each undeclared identifier is reported only once app_addon_sql_mysql.c:164: for each function it appears in.) make: *** [app_addon_sql_mysql.o] Error 1 rm app_saycountpl.o Please help me how i can load this mysql cdr module? -- Best Regards, Abdul Lateef Khan Computer Programmer Mobile No. : +974 - 5405022 ICQ : 276-994-704 YM! : [EMAIL PROTECTED] MSN : [EMAIL PROTECTED] Google Talk : [EMAIL PROTECTED] ___ --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
RE: [Asterisk-Users] Asterisk CDR - Mysql
We seem to be having the same problem. The cdr command is not found, so we tried to do a make and install on the add-ons but it can't see to find the files when we run 'make clean make make install'. We have downloaded from CVS and the files look to be there but it still can't find the files. Could someone help? Thanks Rick [EMAIL PROTECTED] asterisk-addons]# make clean make make install rm -f *.so *.o .depend make -C format_mp3 clean make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' rm -f *.o *.so *~ make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' ./mkdep -fPIC -I../asterisk -D_GNU_SOURCE `ls *.c` app_addon_sql_mysql.c:31:19: mysql.h: No such file or directory cdr_addon_mysql.c:33:19: mysql.h: No such file or directory cdr_addon_mysql.c:34:20: errmsg.h: No such file or directory make -C format_mp3 all make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o common.o common.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o dct64_i386.o dct64_i386.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o decode_ntom.o decode_ntom.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o layer3.o layer3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o tabinit.o tabinit.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o interface.o interface.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o format_mp3.o format_mp3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6 -shared -Xlinker -x -o format_mp3.so common.o dct64_i386.o decode_ntom.o layer3.o tabinit.o interface.o format_mp3.o make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' for x in format_mp3/format_mp3.so ; do install -m 755 $x /usr/lib/asterisk/modules ; done [EMAIL PROTECTED] asterisk-addons]# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Monday, May 02, 2005 7:03 PM To: Asterisk Users Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql If you enabled it in logger.conf, it should be at /var/log/asterisk/debug What does cdr mysql status do? If it says no such command then you haven't loaded the cdr module. Did you do make install inside the asterisk-addons dir? Do you have autoload = yes in your modules.conf? -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 12:03:17 +1000 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql Which Debug log ? Where is it located ? I can't see anything obvious that shows this info. Cheers, Callum (P.S. I'm not seeing a connection on the mySQL DB from the asterisk machine, and I assumed that there should be one... what am I missing here ? ) Matthew Boehm wrote: What is in your debug log? It will show the exact SQL that is being executed. -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 11:35:52 +1000 To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] Asterisk CDR - Mysql Hi All, We have configured our Asterisk Server (CVS Head) to use mysql for CDR's, following the guidelines located at http://www.voip-info.org/wiki-Asterisk+cdr+mysql . When Asterisk starts up there are no errors, when we make a call there are no errors, however I am not seeing records in the database. Any idea how what I should be looking for here? I'm a bit lost. Cheers, Callum ___ 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 ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http
Re: [Asterisk-Users] Asterisk CDR - Mysql
If cdr mysql status is 'command not found' then that means you haven't loaded the module. Check your module path to make sure it really is there. (/usr/lib/asterisk/modules/) If it is indeed there, do load cdr_addon_mysql.so from CLI* You might want to check modules.conf and make sure you have an autoload in there. -Matthew Rick Baranowski wrote: We seem to be having the same problem. The cdr command is not found, so we tried to do a make and install on the add-ons but it can't see to find the files when we run 'make clean make make install'. We have downloaded from CVS and the files look to be there but it still can't find the files. Could someone help? Thanks Rick [EMAIL PROTECTED] asterisk-addons]# make clean make make install rm -f *.so *.o .depend make -C format_mp3 clean make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' rm -f *.o *.so *~ make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' ./mkdep -fPIC -I../asterisk -D_GNU_SOURCE `ls *.c` app_addon_sql_mysql.c:31:19: mysql.h: No such file or directory cdr_addon_mysql.c:33:19: mysql.h: No such file or directory cdr_addon_mysql.c:34:20: errmsg.h: No such file or directory make -C format_mp3 all make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o common.o common.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o dct64_i386.o dct64_i386.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o decode_ntom.o decode_ntom.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o layer3.o layer3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o tabinit.o tabinit.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o interface.o interface.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o format_mp3.o format_mp3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6 -shared -Xlinker -x -o format_mp3.so common.o dct64_i386.o decode_ntom.o layer3.o tabinit.o interface.o format_mp3.o make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' for x in format_mp3/format_mp3.so ; do install -m 755 $x /usr/lib/asterisk/modules ; done [EMAIL PROTECTED] asterisk-addons]# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Monday, May 02, 2005 7:03 PM To: Asterisk Users Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql If you enabled it in logger.conf, it should be at /var/log/asterisk/debug What does cdr mysql status do? If it says no such command then you haven't loaded the cdr module. Did you do make install inside the asterisk-addons dir? Do you have autoload = yes in your modules.conf? -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 12:03:17 +1000 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql Which Debug log ? Where is it located ? I can't see anything obvious that shows this info. Cheers, Callum (P.S. I'm not seeing a connection on the mySQL DB from the asterisk machine, and I assumed that there should be one... what am I missing here ? ) Matthew Boehm wrote: What is in your debug log? It will show the exact SQL that is being executed. -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 11:35:52 +1000 To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] Asterisk CDR - Mysql Hi All, We have configured our Asterisk Server (CVS Head) to use mysql for CDR's, following the guidelines located at http://www.voip-info.org/wiki-Asterisk+cdr+mysql . When Asterisk starts up there are no errors, when we make a call there are no errors, however I am not seeing records in the database. Any idea how what I should be looking for here? I'm a bit lost. Cheers, Callum ___ 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
RE: [Asterisk-Users] Asterisk CDR - Mysql
Matthew, Thank you very much for the help. We know that the module is not loading because we can't do the make and make install successfully for the add-ons. It's telling us that it can't find the files necessary when we do a make(print out listed below). We have renamed the add-ons dir and downloaded again from the CVS but we are still getting this error. Any thoughts? Thanks Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Wednesday, May 04, 2005 6:38 AM To: [EMAIL PROTECTED]; Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql If cdr mysql status is 'command not found' then that means you haven't loaded the module. Check your module path to make sure it really is there. (/usr/lib/asterisk/modules/) If it is indeed there, do load cdr_addon_mysql.so from CLI* You might want to check modules.conf and make sure you have an autoload in there. -Matthew Rick Baranowski wrote: We seem to be having the same problem. The cdr command is not found, so we tried to do a make and install on the add-ons but it can't see to find the files when we run 'make clean make make install'. We have downloaded from CVS and the files look to be there but it still can't find the files. Could someone help? Thanks Rick [EMAIL PROTECTED] asterisk-addons]# make clean make make install rm -f *.so *.o .depend make -C format_mp3 clean make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' rm -f *.o *.so *~ make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' ./mkdep -fPIC -I../asterisk -D_GNU_SOURCE `ls *.c` app_addon_sql_mysql.c:31:19: mysql.h: No such file or directory cdr_addon_mysql.c:33:19: mysql.h: No such file or directory cdr_addon_mysql.c:34:20: errmsg.h: No such file or directory make -C format_mp3 all make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o common.o common.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o dct64_i386.o dct64_i386.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o decode_ntom.o decode_ntom.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o layer3.o layer3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o tabinit.o tabinit.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o interface.o interface.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o format_mp3.o format_mp3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6 -shared -Xlinker -x -o format_mp3.so common.o dct64_i386.o decode_ntom.o layer3.o tabinit.o interface.o format_mp3.o make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' for x in format_mp3/format_mp3.so ; do install -m 755 $x /usr/lib/asterisk/modules ; done [EMAIL PROTECTED] asterisk-addons]# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Monday, May 02, 2005 7:03 PM To: Asterisk Users Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql If you enabled it in logger.conf, it should be at /var/log/asterisk/debug What does cdr mysql status do? If it says no such command then you haven't loaded the cdr module. Did you do make install inside the asterisk-addons dir? Do you have autoload = yes in your modules.conf? -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 12:03:17 +1000 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql Which Debug log ? Where is it located ? I can't see anything obvious that shows this info. Cheers, Callum (P.S. I'm not seeing a connection on the mySQL DB from the asterisk machine, and I assumed that there should be one... what am I missing here ? ) Matthew Boehm wrote: What is in your debug log? It will show the exact SQL that is being executed. -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 11:35:52 +1000 To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] Asterisk CDR - Mysql Hi All, We
RE: [Asterisk-Users] Asterisk CDR - Mysql
From your make output it looks like maybe you don't have the mySQL development package installed on this box? The one with the associated header files, etc. On the RPM-based Linux systems I've used (like Redhat, Mandrake, CentOS, Suse) the package is usually named [packagname]-devel.version.rpm, so you might search your install CD's for a mysql-devel-#.#.#.#.rpm file and try installing that (rpm -ivh [pacakgename]), then try compiling again. Brent -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rick Baranowski Sent: Wednesday, May 04, 2005 10:14 AM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: RE: [Asterisk-Users] Asterisk CDR - Mysql Matthew, Thank you very much for the help. We know that the module is not loading because we can't do the make and make install successfully for the add-ons. It's telling us that it can't find the files necessary when we do a make(print out listed below). We have renamed the add-ons dir and downloaded again from the CVS but we are still getting this error. Any thoughts? Thanks Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Wednesday, May 04, 2005 6:38 AM To: [EMAIL PROTECTED]; Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql If cdr mysql status is 'command not found' then that means you haven't loaded the module. Check your module path to make sure it really is there. (/usr/lib/asterisk/modules/) If it is indeed there, do load cdr_addon_mysql.so from CLI* You might want to check modules.conf and make sure you have an autoload in there. -Matthew Rick Baranowski wrote: We seem to be having the same problem. The cdr command is not found, so we tried to do a make and install on the add-ons but it can't see to find the files when we run 'make clean make make install'. We have downloaded from CVS and the files look to be there but it still can't find the files. Could someone help? Thanks Rick [EMAIL PROTECTED] asterisk-addons]# make clean make make install rm -f *.so *.o .depend make -C format_mp3 clean make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' rm -f *.o *.so *~ make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' ./mkdep -fPIC -I../asterisk -D_GNU_SOURCE `ls *.c` app_addon_sql_mysql.c:31:19: mysql.h: No such file or directory cdr_addon_mysql.c:33:19: mysql.h: No such file or directory cdr_addon_mysql.c:34:20: errmsg.h: No such file or directory make -C format_mp3 all make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o common.o common.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o dct64_i386.o dct64_i386.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o decode_ntom.o decode_ntom.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o layer3.o layer3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o tabinit.o tabinit.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o interface.o interface.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o format_mp3.o format_mp3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6 -shared -Xlinker -x -o format_mp3.so common.o dct64_i386.o decode_ntom.o layer3.o tabinit.o interface.o format_mp3.o make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' for x in format_mp3/format_mp3.so ; do install -m 755 $x /usr/lib/asterisk/modules ; done [EMAIL PROTECTED] asterisk-addons]# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Monday, May 02, 2005 7:03 PM To: Asterisk Users Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql If you enabled it in logger.conf, it should be at /var/log/asterisk/debug What does cdr mysql status do? If it says no such command then you haven't loaded the cdr module. Did you do make install inside the asterisk-addons dir? Do you have autoload = yes in your modules.conf? -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 12:03:17 +1000 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject
Re: [Asterisk-Users] Asterisk CDR - Mysql
Doh. I didn't read close enough. app_addon_sql_mysql.c:31:19: mysql.h: No such file or directory cdr_addon_mysql.c:33:19: mysql.h: No such file or directory cdr_addon_mysql.c:34:20: errmsg.h: No such file or directory That means you don't have mysql installed. Or rather, you don't have mysql headers/libraries stored in default locations. mysql.h should be located (by default) in /usr/local/include/mysql/ other common locations: /usr/include/ /usr/include/mysql/ -Matthew Rick Baranowski wrote: Matthew, Thank you very much for the help. We know that the module is not loading because we can't do the make and make install successfully for the add-ons. It's telling us that it can't find the files necessary when we do a make(print out listed below). We have renamed the add-ons dir and downloaded again from the CVS but we are still getting this error. Any thoughts? Thanks Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Wednesday, May 04, 2005 6:38 AM To: [EMAIL PROTECTED]; Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql If cdr mysql status is 'command not found' then that means you haven't loaded the module. Check your module path to make sure it really is there. (/usr/lib/asterisk/modules/) If it is indeed there, do load cdr_addon_mysql.so from CLI* You might want to check modules.conf and make sure you have an autoload in there. -Matthew Rick Baranowski wrote: We seem to be having the same problem. The cdr command is not found, so we tried to do a make and install on the add-ons but it can't see to find the files when we run 'make clean make make install'. We have downloaded from CVS and the files look to be there but it still can't find the files. Could someone help? Thanks Rick [EMAIL PROTECTED] asterisk-addons]# make clean make make install rm -f *.so *.o .depend make -C format_mp3 clean make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' rm -f *.o *.so *~ make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' ./mkdep -fPIC -I../asterisk -D_GNU_SOURCE `ls *.c` app_addon_sql_mysql.c:31:19: mysql.h: No such file or directory cdr_addon_mysql.c:33:19: mysql.h: No such file or directory cdr_addon_mysql.c:34:20: errmsg.h: No such file or directory make -C format_mp3 all make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o common.o common.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o dct64_i386.o dct64_i386.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o decode_ntom.o decode_ntom.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o layer3.o layer3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o tabinit.o tabinit.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o interface.o interface.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o format_mp3.o format_mp3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6 -shared -Xlinker -x -o format_mp3.so common.o dct64_i386.o decode_ntom.o layer3.o tabinit.o interface.o format_mp3.o make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' for x in format_mp3/format_mp3.so ; do install -m 755 $x /usr/lib/asterisk/modules ; done [EMAIL PROTECTED] asterisk-addons]# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Monday, May 02, 2005 7:03 PM To: Asterisk Users Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql If you enabled it in logger.conf, it should be at /var/log/asterisk/debug What does cdr mysql status do? If it says no such command then you haven't loaded the cdr module. Did you do make install inside the asterisk-addons dir? Do you have autoload = yes in your modules.conf? -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 12:03:17 +1000 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql Which Debug log ? Where is it located ? I can't see anything obvious that shows this info. Cheers, Callum (P.S. I'm
RE: [Asterisk-Users] Asterisk CDR - Mysql
Thanks guys, it's working now. I must have missed the mysql-devel on my last build Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brent DeShazer Sent: Wednesday, May 04, 2005 9:04 AM To: [EMAIL PROTECTED]; Asterisk Users Mailing List - Non-Commercial Discussion Subject: RE: [Asterisk-Users] Asterisk CDR - Mysql From your make output it looks like maybe you don't have the mySQL development package installed on this box? The one with the associated header files, etc. On the RPM-based Linux systems I've used (like Redhat, Mandrake, CentOS, Suse) the package is usually named [packagname]-devel.version.rpm, so you might search your install CD's for a mysql-devel-#.#.#.#.rpm file and try installing that (rpm -ivh [pacakgename]), then try compiling again. Brent -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rick Baranowski Sent: Wednesday, May 04, 2005 10:14 AM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: RE: [Asterisk-Users] Asterisk CDR - Mysql Matthew, Thank you very much for the help. We know that the module is not loading because we can't do the make and make install successfully for the add-ons. It's telling us that it can't find the files necessary when we do a make(print out listed below). We have renamed the add-ons dir and downloaded again from the CVS but we are still getting this error. Any thoughts? Thanks Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Wednesday, May 04, 2005 6:38 AM To: [EMAIL PROTECTED]; Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql If cdr mysql status is 'command not found' then that means you haven't loaded the module. Check your module path to make sure it really is there. (/usr/lib/asterisk/modules/) If it is indeed there, do load cdr_addon_mysql.so from CLI* You might want to check modules.conf and make sure you have an autoload in there. -Matthew Rick Baranowski wrote: We seem to be having the same problem. The cdr command is not found, so we tried to do a make and install on the add-ons but it can't see to find the files when we run 'make clean make make install'. We have downloaded from CVS and the files look to be there but it still can't find the files. Could someone help? Thanks Rick [EMAIL PROTECTED] asterisk-addons]# make clean make make install rm -f *.so *.o .depend make -C format_mp3 clean make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' rm -f *.o *.so *~ make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' ./mkdep -fPIC -I../asterisk -D_GNU_SOURCE `ls *.c` app_addon_sql_mysql.c:31:19: mysql.h: No such file or directory cdr_addon_mysql.c:33:19: mysql.h: No such file or directory cdr_addon_mysql.c:34:20: errmsg.h: No such file or directory make -C format_mp3 all make[1]: Entering directory `/usr/src/asterisk-addons/format_mp3' gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o common.o common.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o dct64_i386.o dct64_i386.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o decode_ntom.o decode_ntom.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o layer3.o layer3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o tabinit.o tabinit.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o interface.o interface.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6-c -o format_mp3.o format_mp3.c gcc -pipe -fPIC -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -D_REENTRANT -D_GNU_SOURCE -O6 -shared -Xlinker -x -o format_mp3.so common.o dct64_i386.o decode_ntom.o layer3.o tabinit.o interface.o format_mp3.o make[1]: Leaving directory `/usr/src/asterisk-addons/format_mp3' for x in format_mp3/format_mp3.so ; do install -m 755 $x /usr/lib/asterisk/modules ; done [EMAIL PROTECTED] asterisk-addons]# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Monday, May 02, 2005 7:03 PM To: Asterisk Users Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql If you enabled it in logger.conf, it should be at /var/log/asterisk/debug What does cdr mysql status do? If it says no such command then you haven't loaded the cdr module. Did you do make install inside
[Asterisk-Users] Asterisk CDR - Mysql
Hi All, We have configured our Asterisk Server (CVS Head) to use mysql for CDR's, following the guidelines located at http://www.voip-info.org/wiki-Asterisk+cdr+mysql . When Asterisk starts up there are no errors, when we make a call there are no errors, however I am not seeing records in the database. Any idea how what I should be looking for here? I'm a bit lost. Cheers, Callum ___ 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
Re: [Asterisk-Users] Asterisk CDR - Mysql
What is in your debug log? It will show the exact SQL that is being executed. -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 11:35:52 +1000 To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] Asterisk CDR - Mysql Hi All, We have configured our Asterisk Server (CVS Head) to use mysql for CDR's, following the guidelines located at http://www.voip-info.org/wiki-Asterisk+cdr+mysql . When Asterisk starts up there are no errors, when we make a call there are no errors, however I am not seeing records in the database. Any idea how what I should be looking for here? I'm a bit lost. Cheers, Callum ___ 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
Re: [Asterisk-Users] Asterisk CDR - Mysql
Which Debug log ? Where is it located ? I can't see anything obvious that shows this info. Cheers, Callum (P.S. I'm not seeing a connection on the mySQL DB from the asterisk machine, and I assumed that there should be one... what am I missing here ? ) Matthew Boehm wrote: What is in your debug log? It will show the exact SQL that is being executed. -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 11:35:52 +1000 To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] Asterisk CDR - Mysql Hi All, We have configured our Asterisk Server (CVS Head) to use mysql for CDR's, following the guidelines located at http://www.voip-info.org/wiki-Asterisk+cdr+mysql . When Asterisk starts up there are no errors, when we make a call there are no errors, however I am not seeing records in the database. Any idea how what I should be looking for here? I'm a bit lost. Cheers, Callum ___ 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 ___ 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
Re: [Asterisk-Users] Asterisk CDR - Mysql
If you enabled it in logger.conf, it should be at /var/log/asterisk/debug What does cdr mysql status do? If it says no such command then you haven't loaded the cdr module. Did you do make install inside the asterisk-addons dir? Do you have autoload = yes in your modules.conf? -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 12:03:17 +1000 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [Asterisk-Users] Asterisk CDR - Mysql Which Debug log ? Where is it located ? I can't see anything obvious that shows this info. Cheers, Callum (P.S. I'm not seeing a connection on the mySQL DB from the asterisk machine, and I assumed that there should be one... what am I missing here ? ) Matthew Boehm wrote: What is in your debug log? It will show the exact SQL that is being executed. -Matthew From: Callum McGillivray [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 03 May 2005 11:35:52 +1000 To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] Asterisk CDR - Mysql Hi All, We have configured our Asterisk Server (CVS Head) to use mysql for CDR's, following the guidelines located at http://www.voip-info.org/wiki-Asterisk+cdr+mysql . When Asterisk starts up there are no errors, when we make a call there are no errors, however I am not seeing records in the database. Any idea how what I should be looking for here? I'm a bit lost. Cheers, Callum ___ 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 ___ 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
