[Asterisk-Users] Asterisk CDR - Mysql

Matthew Boehm mboehm at cytelcom.com
Wed May 4 08:58:44 MST 2005 

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: asterisk-users-bounces at lists.digium.com
> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Matthew
> Boehm Sent: Wednesday, May 04, 2005 6:38 AM
> To: asfhasterisk at qwest.net; 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
>>
>>  [root at switch1 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
>> [root at switch1 asterisk-addons]#
>>
>> -----Original Message-----
>> From: asterisk-users-bounces at lists.digium.com
>> [mailto:asterisk-users-bounces at lists.digium.com] 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 <callummc at ains.net.au>
>>> Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion
>>> <asterisk-users at lists.digium.com>
>>> Date: Tue, 03 May 2005 12:03:17 +1000
>>> To: Asterisk Users Mailing List - Non-Commercial Discussion
>>> <asterisk-users at 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 <callummc at ains.net.au>
>>>>> Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion
>>>>> <asterisk-users at lists.digium.com>
>>>>> Date: Tue, 03 May 2005 11:35:52 +1000
>>>>> To: <asterisk-users at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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

More information about the asterisk-users mailing list