Yup, I already did that,
Here's what I'm getting on to the MYSQL DB calldate, end, clid, src, dst, dcontext, channel, dstchannel,lastapp,lastdata, duration, billsec, disposition, amaflags, accountcode, uniqueid,userfield as you can see, the answer field is missing... a simple question: calldate represents the exact time for the communication established, or the answer time for an established communication? Marcos. -----Mensaje original----- De: Pim van Stam [mailto:[EMAIL PROTECTED] Enviado el: jueves, 15 de febrero de 2007 18:10 Para: [EMAIL PROTECTED] Asunto: Re: [Asterisk-bsd] mysql and cdr Op do, 15-02-2007 te 17:10 -0300, schreef Marcos Espinoza: > HI: > I'm using mysql to strore the CDR for all my incoming SIP connections. <cut> > Anybody knows what's the correct way to create the tables, in order to > get the data for start , answer, and end ? > Using: > - FreeBSD 6.X > - Asterisk 1.2.13 > - Mysql Server 5.0.27 > ' Did you install asterisk-addons? In ports: net/asterisk-addons Regards, !P _______________________________________________ Asterisk-BSD mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-bsd
