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 >>> <[email protected]> >>> Date: Tue, 03 May 2005 12:03:17 +1000 >>> To: Asterisk Users Mailing List - Non-Commercial Discussion >>> <[email protected]> >>> 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 >>>>> <[email protected]> >>>>> Date: Tue, 03 May 2005 11:35:52 +1000 >>>>> To: <[email protected]> >>>>> 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 >>>>> [email protected] >>>>> 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 >>>> [email protected] >>>> 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 >>> [email protected] >>> 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 >> [email protected] >> 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 >> [email protected] >> 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 > [email protected] > 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 > [email protected] > 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 [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
