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 '0000-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
