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 Notice Error -- Telecomunicaciones Abiertas de México S.A. de C.V. Carlos Chávez Prats Director de Tecnología +52-55-91169161 ext 2001
signature.asc
Description: This is a digitally signed message part
_______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users