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
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-
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: R
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 &qu
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 >> >> Date: Tue, 03 May 2005 12:03:17 +1000 >> To: Asterisk Users Mailing List - Non-Commercial Discussion >> >> 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, >> >> Callu
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 >> >> Date: Tue, 03 May 2005 12:03:17 +1000 >> To: Asterisk Users Mailing List - Non-Commercial Discussion >> >> 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 >>>> >>>> Date: Tue, 03 May 2005 11:35:52 +1000 >>>&g
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 > > Date: Tue, 03 May 2005 12:03:17 +1000 > To: Asterisk Users Mailing List - Non-Commercial Discussion > > 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 >>> >>> Date: Tue, 03 May 2005 11:35:52 +1000 >>> To: >>> 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 U
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 > > Date: Tue, 03 May 2005 12:03:17 +1000 > To: Asterisk Users Mailing List - Non-Commercial Discussion > > 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 >>> >>> Date: Tue, 03 May 2005 11:35:52 +1000 >>> To: >>> 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
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 Date: Tue, 03 May 2005 11:35:52 +1000 To: 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
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 > > Date: Tue, 03 May 2005 11:35:52 +1000 > To: > 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