Hi. here is a brand new cdr_mysql . Is based on the previous one, but with lots of changes, so I include here the whole file, not a patch. What I've changed: added new fields, in order to reflect cdr csv : * call start time * call answer time * call end time * call unique id Changed the table structure to reflect cdr.h lengths. Added some (a lot?) sanity checks, to be sure to insert records that fits into mysql, and not to exit with "Failed insert" errors. Also now on load/reload cdr mysql checks the table structure to adjust the fields length values (and issue warnings if some fields are too small). Feel free to blame me (I'm not a C guru). I can fix any error, of course. Mark feel free to add it to asterisk, if u think that's a good work. I'll disclaim, if needed. Positive and/or negative comments are welcome. Matteo. -- Matteo Brancaleoni Powered by RedHat Linux 8.0 Linux User #153521 -----BEGIN GEEK CODE BLOCK----- Version: 3.12 GS d? s:- a- C+++ UL++++ P+ L+++ E- W+++ N++ o K- w-- O- M-- V-- PS PE- Y PGP++ t 5 X+ R tv- b++ DI D+ G e h! r++ y ------END GEEK CODE BLOCK------ -------------- next part -------------- # phpMyAdmin MySQL-Dump # version 2.5.0 # http://www.phpmyadmin.net/ (download page) # # Host: localhost # Generato il: 07 Giu, 2003 at 03:23 # Versione MySQL: 3.23.56 # Versione PHP: 4.2.2 # Database : `asterisk` # -------------------------------------------------------- # # Struttura della tabella `cdr` # # Creazione: 07 Giu, 2003 at 02:57 # Ultimo cambiamento: 07 Giu, 2003 at 03:07 # CREATE TABLE `cdr` ( `ID` int(10) unsigned NOT NULL auto_increment, `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 '', `start` datetime NOT NULL default '0000-00-00 00:00:00', `answer` datetime NOT NULL default '0000-00-00 00:00:00', `end` datetime NOT NULL default '0000-00-00 00:00:00', `duration` int(11) NOT NULL default '0', `billsec` int(11) NOT NULL default '0', `disposition` int(11) NOT NULL default '0', `amaflags` int(11) NOT NULL default '0', `accountcode` varchar(20) NOT NULL default '', `uniqueid` varchar(32) NOT NULL default '', PRIMARY KEY (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -------------- next part -------------- A non-text attachment was scrubbed... Name: cdr_mysql.c Type: text/x-c Size: 32160 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20030607/81712c9d/cdr_mysql.bin