[Asterisk-Users] Asterisk CDR - Mysql

Rick Baranowski azfhasterisk at qwest.net
Wed May 4 08:13:53 MST 2005 

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

More information about the asterisk-users mailing list