asterisk cdr cvs mysql

• http://192.168.1.x/phpmyadmin
• phpadmin のsql欄に下記をペーストして実行

CREATE DATABASE asteriskcdrdb;
 
 GRANT INSERT
   ON asteriskcdrdb.*
   TO asterisk@localhost
   IDENTIFIED BY 'yorifuji';

 USE asteriskcdrdb;

 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 '',
 `userfield` varchar(255) NOT NULL default '',
 `uniqueid` VARCHAR(32) NOT NULL default '',
 `linkedid` VARCHAR(32) NOT NULL default '',
 `sequence` VARCHAR(32) NOT NULL default '',
 `peeraccount` VARCHAR(32) NOT NULL default ''
 );
 ALTER TABLE `cdr` ADD INDEX ( `calldate` );
 ALTER TABLE `cdr` ADD INDEX ( `dst` );
 ALTER TABLE `cdr` ADD INDEX ( `accountcode` );

• cp /var/log/asterisk/cdr-csv/Master.csv /home/ckenko25
• vi /home/ckenko25/importcdr.php

Usage  
Where filename is the path to the Asterisk csv file to import (Master.csv)
This script is safe to run multiple times on a growing log file as it only imports records that are newer than the database