Discussion: Asterisk cdr mysql

It should be obvious with a minor amount of testing, but this value is in seconds.

RE: Sharon- Failed to connect

Check your sock definition in the cdr_mysql.conf file. You may need to change it to /var/lib/mysql/mysql.sock

I have installed Asterisk, mysql and asterisk-addons according this page correctly, cdr_mysql.conf is also configured too. However I come across a fatal problem, when I start asterisk, there will appear a message which describes the failure to connect to mysql. Error like the followings: ERROR[24245]: cdr_addon_mysql.c:437 my_load_module: Failed to connect to mysql database mysql on XX(mysql server IP).
By the way, my software versions are asterisk-1.2.7.1, asterisk-addons-1.2.2, mysql-5.0.21.
I cann’ t find out the reason for this problem, can someone tell me why? In advance thanks.

Is it possible to extract more informations in the Master.csv for statistic?

to compile and install addon under FreeBSD you have to edit Makefile:

CFLAGS+=-Iinclude -I/usr/local/include

ASTLIBDIR=$(INSTALL_PREFIX)/usr/local/lib/asterisk

and use gmake instead of make while compiling.
tested under FreeBSD 5.4 stable

Which Asterisk version do you use? Mine is 1.0.7, and i can't get the cdr_mysql application to write to the database using this table definition.

It seems that the table definition should look like this:

CREATE TABLE `cdr` (
`uniqueid` varchar(32) NOT NULL default '',
`userfield` varchar(255) NOT NULL default '',
`accountcode` varchar(20) NOT NULL default '',
`lastdata` varchar(80) NOT NULL default '',
`calldate` datetime NOT NULL default '0000-00-00 00:00:00',
`amaflags` int(11) NOT NULL default '0',
`enddate` datetime NOT NULL default '0000-00-00 00:00:00',
`callerid` varchar(80) NOT NULL default '',
`callednumber` varchar(80) NOT NULL default '',
`ani` varchar(80) NOT NULL default '',
`calledcontext` varchar(80) NOT NULL default '',
`sourcechannel` varchar(80) NOT NULL default '',
`destinationchannel` varchar(80) NOT NULL default '',
`lastapplication` varchar(80) NOT NULL default '',
`callduration` int(11) default NULL,
`billableduration` int(11) default NULL,
`calldisposition` varchar(80) NOT NULL default '',
`destinationDescription` varchar(80) NOT NULL default '',
`callcost` int(11) default NULL,
`handlingsystem` varchar(80) NOT NULL default ''
) ;

when i try to do "make", i get errors for res_config_mysql.c file.

res_config_mysql.c:177 error: storage size of 'ra' isn't known

in res_config_mysql.c, the code is like below.

struct ast_realloca ra;
struct ast_variable *var=NULL;
struct ast_config *cfg=NULL;

wtf?

in Mysql 5.02 the only working command for creating a new database is

create database asteriskcdrdb

Not create asteriskcdrdb as written on this page.

Are

The field duration is in minutes or seconds ?

TIA