I have been battling with this for the last month now and tried everything i could find on the web to rectify it to no avail.
I have managed to actually break the webadmin interface on a few occasions trying to rectify the CDR problem.
We are runing
FreePBX 2.10
Asterisk 1.8.11.0-digiumphones1
Modules we have installed and enabled.
Backup and Restore
Custom Applications
Digium Addons
Feature Code Admin
Online Support
Recordings
Call Forward
Call Recording
Call Waiting
Conferences
Core
IVR
Info Services
Paging and Intercom
Queues
Ring Groups
Time Conditions
We have 1 trunk offering 8 channels and all calls go through this.
The switchboard is working like a charm except that is is not logging and calls to the CDR table in the Mysql DB.
/etc/asterisk/cdr_mysql.conf
[global]
hostname = localhost
dbname=asteriskcdrdb
password = ****
user = freepbx
userfield=1
;port=3306
;sock=/tmp/mysql.sock
These details are correct. After logging in into the MySQL db with the details.
mysql> show tables;
±------------------------+
| Tables_in_asteriskcdrdb |
±------------------------+
| cdr |
±------------------------+
1 row in set (0.00 sec)
mysql> select * from cdr
-> ;
Empty set (0.00 sec)
not sure if this will help.
from /var/log/asterisk/full
[2012-05-30 09:08:14] VERBOSE[18110] pbx.c: == Setting global variable ‘AMPDBENGINE’ to ‘mysql’
from /var/log/asterisk/freepbx.log
[2012-May-30 09:08:13] [INFO] (core/functions.inc.php:1795) - Added to globals: AMPDBENGINE = mysql
any advice or something i need to check would be greatly appreciated.
I really need to get call logs working.
Not sure why i just left this.
found directory asterisk-addons-1.6-2.3 would not compile
chan_ooh323.c:3144: error: âAST_CAUSE_FAILUREâ undeclared (first use in this function)
chan_ooh323.c:3146: error: âAST_CAUSE_NORMALâ undeclared (first use in this function)
chan_ooh323.c: At top level:
chan_ooh323.c:3161: error: expected â)â before string constant
make[1]: *** [chan_ooh323.o] Error 1
make[1]: Leaving directory `/root/asterisk-addons-1.6.2.4/channels’
make: *** [channels] Error 2
downloaded 1.6.2.4 sam error.
searching now to see why im getting this.
why are u using 1.6 add-ons with 1.8? 1.8 comes with it already, you just need to make menuselect (or make menuconfig) straight off the 1.8 source dir.
Not sure but i must have missed something during installation.
You led me to the right fix though.
for anyone else having similar issues ill post my fix as ive seen this on a few forums and you are the first to help me rectify it.
/etc/yum.conf - removed the exclude freepbx and asterisk entry so yum could search the repos again.
yum install asterisk-addons-mysql
It showed it would clash with digium phones addon which i removed as we dont use digium phones.
this ran through after that went into asterisk -r
ran module load cdr_mysql.so
and all calls started logging in the db perfectly.
Hi mark,
I am using freepbx 2.10 and asterisknow 1.8.12 and also having the same problem of no CDR record. In my /etc/yum.conf file there is no string to remove the exclude freepbx and asterisk entry. could you clarify it a bit more?
i place the line
exclude=freepbx* asterisk* digium*
in my /etc/yum.conf file to avoid yum updating asterisk or components which has broken my freepbx before. I find it easier to do it manually through the web interface.
running the command. yum list asterisk18*
will list all the asterisk1.8 packages that you may install.
running yum list asterisk-addons*
will list only addon packages.
you will need asterisk-addons-core and asterisk-addons-mysql
so the command yum install asterisk-addons-mysql will inform you that asterisk-addons-core is required and you can accept this.
it will then check conflicts and so on and if all is in order will procede to install the addons-core and addon-mysql
after this to load the module do the
asterisk -r
module load cdr_mysql.so
and the module should happily load and you will find your cdr table being populated on the next call.
hello
thanks for your reply. i followed as per your instruction but when i execute the command to list asterisk-addons, it replies with no matching packages to list. hence there are no module loaded in asterisk cli named cdr_mysql.so
still in the gloomy situation…