[resolved] MySQL CDR

Asterisk Asterisk Support
1

I have built a new asterisk server and cannot get MySQL CDR to work. I have configured the cdr_mysql.conf file as shown below, but a reload from the CLI console doesn’t show that file being read. What am I missing - we pretty much copied the configuration of our other asterisk server.

[global]
hostname=<ip.adddress.of.sqlserver>
dbname=asteriskcdrdb
password=@st3r1sk
user=asterisk
;port=3306
sock=/var/lib/mysql/mysql.sock
;userfield=1
table=cdr
2

Did you do the modules.conf thing according to http://www.voip-info.org/wiki-Asterisk+cdr+mysql? The instructions also mention to restart asterisk, not just reload.

3

I just discovered that running make in the asterisk addons directory does not compile the cdr_addon_mysql.c file, so the cdr_addon_mysql.so file is not being created. I tried running make clean first, but that didn’t help. Any ideas?

4

I just discovered that running make in the asterisk addons directory does not compile the cdr_addon_mysql.c file, so the cdr_addon_mysql.so file is not being created. I tried running make clean first, but that didn’t help. Any ideas?[/quote]

I had a copy of cdr_addon_mysql.so from my 1.2.9 version of asterisk and a diff on the source showed they were the same, so I just used it and everything is fine. I’m still not sure why the files doesn’t compile, but I don’t have an hour to figure out “make” and all the dependencies. Thanks for your help.