When you are connected to the asterisk manager interface, and a call is ended, an event will be sent to everybody or everything connected to the manager interface. (If that manager interface itself is enabled of course ;-).
Shoham (shohamlevy at gmail dot com) 17 April 2006 13:58:25 I am not sure, but I think this is the place to post the next comment:
In order to let cdr_addon_mysql register the unique ID of calls (may be very useful sometimes), you need to manually modify the Makefile of the asterisk-add-ons:
CFLAGS+=-D_GNU_SOURCE -DMYSQL_LOGUNIQUEID
Other than that, here is a proper MySQL table for CDR:
REATE TABLE `cdr` (
`uniqueid` float NOT NULL default '0',
`clid` varchar(80) NOT NULL default '',
`src` varchar(80) NOT NULL default '',
`dst` varchar(80) NOT NULL default '',
`accountcode` varchar(20) NOT NULL default '',
`amaflags` int(11) NOT NULL default '0',
`billsec` int(11) NOT NULL default '0',
`channel` varchar(80) NOT NULL default '',
`dcontext` varchar(80) NOT NULL default '',
`disposition` varchar(45) NOT NULL default '',
`dstchannel` varchar(80) NOT NULL default '',
`duration` int(11) NOT NULL default '0',
`lastapp` varchar(80) NOT NULL default '',
`lastdata` varchar(80) NOT NULL default '',
`userfield` varchar(255) NOT NULL default '',
`calldate` datetime default NULL,
PRIMARY KEY (`uniqueid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
I hope it helps.
paldi (paldi at paldi dot cjb dot net) 14 January 2006 21:32:44 've a look at NoCDR