[Asterisk-Users] Asterisk CDR - Mysql

Rick Baranowski azfhasterisk at qwest.net
Wed May 4 10:31:53 MST 2005


Thanks guys, it's working now. I must have missed the mysql-devel on my last
build

Rick

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Brent DeShazer
Sent: Wednesday, May 04, 2005 9:04 AM
To: asfhasterisk at qwest.net; 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: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com]On 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: 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


_______________________________________________
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