No cdr data = ***solved***

General Help
1

I know there is a thread regarding this further down but i didnt want to hijack it.

I am also not getting any cdr data. My installation is:

Fedora 7
Asterisk 1.2.2
FreePBX 2.2.2
Latest asterisk sounds and addons

according to the other thread i should make menuconfig and make sure cdr is selected but i dont have that option from my /usr/src/asterisk-addons folder. Does this mean i have to download it again and find one that does?

Secondly, i have noticed that when a call is made, i can see the following on the asterisk box:

– Executing Macro(“SIP/102-08376de0”, “hangupcall”) in new stack
– Executing ResetCDR(“SIP/102-08376de0”, “w”) in new stack
– Executing NoCDR(“SIP/102-08376de0”, “”) in new stack
– Executing GotoIf(“SIP/102-08376de0”, “1?skiprg”) in new stack
– Goto (macro-hangupcall,s,6)
– Executing GotoIf(“SIP/102-08376de0”, “1?theend”) in new stack
– Goto (macro-hangupcall,s,9)
– Executing Wait(“SIP/102-08376de0”, “5”) in new stack

Does this have anything to do with it.

Back to the asterisk addons, when i do a make on asterisk addons i get:

[root@asterisk asterisk-addons]# make
./mkdep -fPIC -I…/asterisk -D_GNU_SOURCE ls *.c
app_addon_sql_mysql.c:23:19: error: mysql.h: No such file or directory
cdr_addon_mysql.c:38:19: error: mysql.h: No such file or directory
cdr_addon_mysql.c:39:20: error: errmsg.h: No such file or directory
res_config_mysql.c:53:19: error: mysql.h: No such file or directory
res_config_mysql.c:54:27: error: mysql_version.h: No such file or directory

Any ideas how i can fix these?

2

for the benefit of other users this is how i fixed not having any cdr. basic really, i hadnt installed mysql development tools so i ran:

yum install mysql-devel

and then i had to reinstall asterisk-addons

then add the following to your /etc/asterisk/modules.conf file

load => cdr_addon_mysql.so

then do an amportal stop and then amportal start

thats was it!

3

How do you do a reinstall of asterisk-addons?

4

Something like this…

[code:1]# cd /usr/src

wget http://ftp.digium.com/pub/telephony/asterisk/asterisk-addons-1.2.7.tar.gz

tar -xzvf asterisk-addons-1.2.7.tar.gz

cd asterisk-addons-1.2.7

make clean

make

make install

[/code:1]