[asterisk-users] Asterisk + mySQL

[jonas kellens]

What do I define as amaflags in my sip.conf ??

Can I leave it to be amaflags=billing ? What use of defining it as
billing or documentation when the number of columns are pre-defined ?

Jonas.


On Tue, 2009-06-23 at 10:39 +0100, Ishfaq Malik wrote:

> There's a couple of columns you can write to in the table, most notably 
> accountcode and userfield. There is more info here.
> 
> http://www.voip-info.org/wiki/index.php?page=Asterisk+func+cdr
> 
> I'm not sure about defining additional columns and writing to them 
> through the dialplan but I don't think you can.
> 
> Ish
> 
> jonas kellens wrote:
> > Thanks for your reply. I saw that info also on voip-info.org.
> >
> > I was wondering if I could define other columns, like those used for 
> > billing (as defined in my sip.conf).
> >
> > Jonas.
> >
> >
> > On Tue, 2009-06-23 at 09:22 +0100, Ishfaq Malik wrote:
> >> Hi
> >>
> >> The calldate column is the date and time of the call, here's the 
> >> definition of the cdr table
> >>
> >> 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 ''
> >> );
> >>
> >> ALTER TABLE `cdr` ADD `uniqueid` VARCHAR(32) NOT NULL default '';
> >> ALTER TABLE `cdr` ADD INDEX ( `calldate` );
> >> ALTER TABLE `cdr` ADD INDEX ( `dst` );
> >> ALTER TABLE `cdr` ADD INDEX ( `accountcode` );
> >>
> >>
> >> I got that info from here
> >>
> >> http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql
> >>
> >> Ish
> >>     
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> >
> > asterisk-users mailing list
> > To UNSUBSCRIBE or update options visit:
> >    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090623/ff46d21f/attachment.htm