asterisk users - Oct 2009 - Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID

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

	Is anyone using this version of Asterisk and Addons that can confirm if
they are getting the CLID?  If I do a NoOp(CLID: ${CDR(clid)}) I see the
callerid in the CLI.  The CSV file also records the callerid.  Maybe a
bug in cdr_addon_mysql ?

-- 
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/20091028/3f7472a2/attachment.pgp

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.

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

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

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