[Asterisk-Users] Asterisk CDR - Mysql

[Rick Baranowski]

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