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

[Joseph]

On 10/30/09 10:32, Carlos Chavez wrote:
>On Fri, 2009-10-30 at 08:37 -0500, Tilghman Lesher wrote:
>> On Thursday 29 October 2009 12:32:48 Carlos Chavez wrote:
>> > On Thu, 2009-10-29 at 12:23 -0500, Tilghman Lesher wrote:
>> > > 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
>> >
>> > 	Just this:
>> >
>> > pbxoficina*CLI> core set debug 1
>> > Core debug is at least 1
>> > pbxoficina*CLI> module reload cdr_addon_mysql.so
>> >     -- Reloading module 'cdr_addon_mysql.so' (MySQL CDR Backend)
>> > pbxoficina*CLI>
>>
>> Do you have debug set to go to console in logger.conf?
>>
>	Yes:
>
>pbxoficina*CLI> logger show channels
>Channel                             Type     Status    Configuration
>-------                             ----     ------    -------------
>/var/log/asterisk/messages          File     Enabled    - Warning Notice
>Error
>                                    Console  Enabled    - Debug Warning

Did you solved this problem?
I'm having the same issue on asteriks-1.6.1.8 
except in my case no records are being passed to mysql.

-- 
Joseph