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 _______________________________________________ -- 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
