Asterisk CDR Tables: Difference between revisions

From KlavoWiki
Jump to navigationJump to search
Line 9: Line 9:
Once the databse is created and we have selected it for use, we can now create the required tables(s).
Once the databse is created and we have selected it for use, we can now create the required tables(s).
<pre>
<pre>
CREATE TABLE server1 (
CREATE TABLE cdr (
   calldate datetime NOT NULL default '0000-00-00 00:00:00',
   calldate datetime NOT NULL default '0000-00-00 00:00:00',
   clid varchar(80) NOT NULL default '',
   clid varchar(80) NOT NULL default '',

Revision as of 05:37, 17 February 2009

Call Detail Records

The following information is based on Asterisk 1.6.x.
The first thing required is to create a database for the CDR to be stored, then we need to create a tables.

mysql
create database asteriskcdr;
use asteriskcdr;

Once the databse is created and we have selected it for use, we can now create the required tables(s).

CREATE TABLE cdr (
  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 ''
);

Once the database is created you then need to edit the asterisk mysql.conf file to use the databse.
edit the file /etc/asterisk/cdr_mysql.conf and make the required changes.

You can then reload asterisk and make sure that it recognises mysql byt typing in:

cdr mysql status

You should get a responce like

Connected to databse-name@localhost, port 3306 using table table-name for 2 seconds.

Make sure you have a look at CDR Analyser so you can view your CDR via a WEB page.