Dear Warren;
Thanks a lot for the reply and kindly help.
I ran the below commands and now I have the database asteriskcdrdb and the
table cdr, also I did the configuration in the cdr_mysql.conf but until now I
do not see entries in the database (still the table is free).
The asterisk version I am running is 1.8.4.2 and actually I selected the
cdr_mysql from the menuselect while doing the installation, but I do not see
cdr_mysql.so in the /usr/lib/asterisk/modules , so it is not added?
I checked the cdr.conf file and I found the following sentence (I am surprise,
because in asterisk 1.8, it should come with it without need for the addon to
be downloaded separately ..):
;(also, mysql is available via the asterisk-addons, due to licensing
; requirements)
So, the licesne is required? Well, why I did not see the cdr_mysql it in the
/usr/lib/asterisk/modules/?
From the other side, do I have to add for the /etc/asterisk/modules.conf this
line:
load = cdr_addon_mysql.so
Or it is required only for old asterisk version?
Appreciate ur kindly help.
Regards
Bilal
--
The following script will generate an asterisk database
with a table named
CDR that will work with asterisk 1.8. Be sure to
change 'PASSWORD' with
whatever password you want to use.
SET SQL_MODE=NO_AUTO_VALUE_ON_ZERO;
CREATE DATABASE `asterisk` DEFAULT CHARACTER SET latin1
COLLATE
latin1_swedish_ci;
USE `asterisk`;
CREATE TABLE IF NOT EXISTS `cdr` (
`recid` mediumint(8) unsigned NOT NULL auto_increment
COMMENT 'Record ID',
`calldate` datetime NOT NULL default '-00-00
00:00:00',
`clid` varchar(80) NOT NULL default '',
`src` varchar(80) NOT NULL default '',
`dst` varchar(80) NOT NULL default '',
`dcontext` varchar(80) NOT NULL default '',
`channel` varchar(80) NOT NULL default '',
`dstchannel` varchar(80) NOT NULL default '',
`lastapp` varchar(80) NOT NULL default '',
`lastdata` varchar(80) NOT NULL default '',
`duration` int(11) NOT NULL default '0',
`billsec` int(11) NOT NULL default '0',
`disposition` varchar(45) NOT NULL default '',
`amaflags` int(11) NOT NULL default '0',
`accountcode` varchar(20) NOT NULL default '',
`uniqueid` varchar(32) NOT NULL default '',
`userfield` varchar(255) NOT NULL default '',
PRIMARY KEY (`recid`),
KEY `calldate` (`calldate`),
KEY `dst` (`dst`),
KEY `accountcode` (`accountcode`),
KEY `src` (`src`),
KEY `disposition` (`disposition`),
KEY `uniqueid` (`uniqueid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE USER 'asterisk'@'localhost' IDENTIFIED BY
'PASSWORD';
GRANT FILE ON * . * TO 'asterisk'@'localhost' IDENTIFIED BY
'PASSWORD'
WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
GRANT INSERT ON `asterisk`.`cdr` TO
'asterisk'@'localhost';
If you're going to be running the mysql database on the
same server as the
asterisk box, the following cdr_mysql.conf should also work
for 1.8:
[global]
hostname=localhost
dbname=asterisk
table=cdr
password=PASSWORD
user=asterisk
port=3306
sock=/var/lib/mysql/mysql.sock
userfield=1
loguniqueid=yes
--
Thanks,
--Warren Selby, dCAP
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
