bizarre... ca ne marche pas plus
J'avais trouvé le script ici : http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql
Code:
mysql> show tables
-> ;
+--------------------+
| Tables_in_asterisk |
+--------------------+
| cdr |
+--------------------+
1 row in set (0.00 sec)
mysql> drop table `cdr`;
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
Empty set (0.00 sec)
mysql> CREATE TABLE `cdr` (
-> `id` int(10) unsigned NOT NULL auto_increment,
-> `calldate` timestamp 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 (`id`)
-> );
Query OK, 0 rows affected (0.03 sec)
mysql> ALTER TABLE `cdr` ADD INDEX ( `id` );
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE `cdr` ADD INDEX ( `calldate` );
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE `cdr` ADD INDEX ( `dst` );
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE `cdr` ADD INDEX ( `accountcode` );
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> select * from cdr
-> ;
+----+---------------------+--------------------+------+------+----------+-------------------+------------+---------+----------+----------+---------+-------------+----------+-------------+--------------+-----------+
| id | calldate | clid | src | dst | dcontext | channel | dstchannel | lastapp | lastdata | duration | billsec | disposition | amaflags | accountcode | uniqueid | userfield |
+----+---------------------+--------------------+------+------+----------+-------------------+------------+---------+----------+----------+---------+-------------+----------+-------------+--------------+-----------+
| 1 | 0000-00-00 00:00:00 | "SoftPhone" <1001> | 1001 | **34 | Interne | SIP/1001-00000000 | | Hangup | | 3 | 3 | ANSWERED | 3 | | 1289955656.0 | |
+----+---------------------+--------------------+------+------+----------+-------------------+------------+---------+----------+----------+---------+-------------+----------+-------------+--------------+-----------+
1 row in set (0.00 sec)
j'utilise Asterisk 1.8 et mysql, et les drivers ODBC et pas le addon Mysql