[Asterisk-bsd] mysql and cdr

[Marcos Espinoza]

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:pim at vanstam-ict.nl] 
Enviado el: jueves, 15 de febrero de 2007 18:10
Para: mespinoza at hispanicglobal.com
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