Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 StatusConfiguration --- --- /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
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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? -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org ___ -- 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
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 StatusConfiguration --- --- /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
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 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
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 ___ -- 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
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 -- 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
[asterisk-users] 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 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
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 ___ -- 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