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

[Tilghman Lesher]

On Thursday 29 October 2009 11:49:30 Carlos Chavez wrote:
> 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.

Try the following commands.  What is output?

CLI> core set debug 1
CLI> module reload cdr_addon_mysql.so

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org