[asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID

[Carlos Chavez]

On Wed, 2009-10-28 at 23:36 -0500, Tilghman Lesher wrote:
> On Wednesday 28 October 2009 17:57:49 Carlos Chavez wrote:
> > 	I am having a problem with Asterisk 1.6.2.0-rc3 and Asterisk-Addons
> > 1.6.2.0-rc1 when recording CDR to a Mysql database.  All fields except
> > callerid are recorded properly after every call.  I have both a "clid"
> > and "callerid" field in the database but both fields are empty.  In
> > cdr_mysql.conf I have this alias in the [columns] section:
> >
> > alias start => calldate
> > alias callerid => clid
> 
> Get rid of this "alias callerid => clid" line.  What it does is to tell the
> driver to put the CDR variable called "callerid" into the "clid" column in the
> database, overriding the builtin "clid" mapping.  Then reload.  If you want
> the Caller*ID information in the "callerid" column, then your mapping is
> backwards and should be "alias clid => callerid".  Remember, the arrow points
> in the direction that the information flows:  FROM the cdr TO the database.
> 
	I already tried that with the same result.  I even added a callerid
column to my cdr table just in case.  Either removing the alias line or
reversing it like you suggested will not record the callerid in either
column.  

-- 
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez Prats
Director de Tecnología
+52-55-91169161 ext 2001
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20091029/97f3f238/attachment.pgp