Re: [asterisk-users] Asterisk 1.6 mysql cdr log problem
On Tue, Nov 25, 2008 at 2:19 AM, Tilghman Lesher [EMAIL PROTECTED] wrote: On Monday 24 November 2008 11:38:09 am Atis Lezdins wrote: On Sun, Nov 23, 2008 at 2:19 PM, Artifex Maximus [EMAIL PROTECTED] wrote: I've installed a new Asterisk 1.6.0.1 with addons and dahdi drivers and tools but my calls aren't logged. I'd enabled mysql log and noticed that asterisk send a 'DESC cdr' so connection is working between asterisk and mysql and I am able to call other phones so Asterisk is working as well. No error messages on startup though. Any idea why is it happen? As I realized there is some differences between 1.2 (my previous system) and 1.6 log system. I suspect that you have some unique index on the table which is conflicting with the inserted fields. Once you figure out which field is causing the conflict, it should be easier to figure out where the problem actually lies. You should also check Asterisk log for warnings. 1.6 should detect table structure and warn about missing fields. If it's so, perhaps you can change asterisk - mysql (res_cdr_addon_mysql if i remember correctly) to do an alter on your table - then it will automagically create missing fields. You remember incorrectly. None of the CDR drivers currently have the capability to alter tables. What they will do is to adapt to the table structure and insert only the required fields. Only realtime table drivers have the capability of altering tables and then, only if you turn that behavior on. By default, Asterisk does not alter table structures. Oh, my mistake :) BTW, if you 'core set debug 2 cdr_addon_mysql.c' (and make sure debug is enabled to the console, via /etc/asterisk/logger.conf), then the SQL will be printed to the console. That should help you find where the problem lies. Actually SQL's are logged with debug 1, debug 2 is too much of everything. I didn't knew that you could use filename.c when setting debug level, seems quite useful :) Regards, Atis -- Atis Lezdins, VoIP Project Manager / Developer, IQ Labs Inc, [EMAIL PROTECTED] Skype: atis.lezdins Cell Phone: +371 28806004 Cell Phone: +1 800 7300689 Work phone: +1 800 7502835 ___ -- 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] Asterisk 1.6 mysql cdr log problem
Hello! On Tue, Nov 25, 2008 at 2:25 AM, Tilghman Lesher [EMAIL PROTECTED] wrote: On Monday 24 November 2008 06:19:44 pm Tilghman Lesher wrote: On Monday 24 November 2008 11:38:09 am Atis Lezdins wrote: On Sun, Nov 23, 2008 at 2:19 PM, Artifex Maximus [EMAIL PROTECTED] wrote: I've installed a new Asterisk 1.6.0.1 with addons and dahdi drivers and tools but my calls aren't logged. I'd enabled mysql log and noticed that asterisk send a 'DESC cdr' so connection is working between asterisk and mysql and I am able to call other phones so Asterisk is working as well. No error messages on startup though. Any idea why is it happen? As I realized there is some differences between 1.2 (my previous system) and 1.6 log system. I suspect that you have some unique index on the table which is conflicting with the inserted fields. Once you figure out which field is causing the conflict, it should be easier to figure out where the problem actually lies. All indexes are simple indexes so that cannot be a problem. Asterisk's log did not noticed any problem with table structure. [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got hostname of localhost [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got port of xxx [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a timeout of 0 [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got sock file of [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got user of xxx [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got dbname of xxx [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got password of xxx [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Not running in calldate compatibility mode [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Successfully connected to MySQL database. [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'calldate' of type 'datetime' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column calldate, type datetime [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'clid' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column clid, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'src' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column src, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'dst' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column dst, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'dcontext' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column dcontext, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'channel' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column channel, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'dstchannel' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column dstchannel, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'lastapp' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column lastapp, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'lastdata' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column lastdata, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'duration' of type 'int(11)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column duration, type int(11) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'billsec' of type 'int(11)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column billsec, type int(11) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'disposition' of type 'varchar(45)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column disposition, type varchar(45) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'amaflags' of type 'int(11)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column amaflags, type int(11) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'accountcode' of type 'varchar(20)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column accountcode, type varchar(20) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'uniqueid' of type 'varchar(32)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column uniqueid, type varchar(32) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'userfield' of type 'varchar(255)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column userfield, type varchar(255) [Nov 21 16:05:16] VERBOSE[10740] logger.c: [Nov 21 16:05:16] cdr_addon_mysql.so = (MySQL CDR Backend) BTW, if you 'core set debug 2 cdr_addon_mysql.c' (and make sure debug is enabled to the console, via
Re: [asterisk-users] Asterisk 1.6 mysql cdr log problem
I think call-limit is for 1 outbound and 1 inbound so if you get a call you wont get other but if you do an outbound call an incoming call will be allowed. Maybe you can configure 1 line in your phone or try Check device state before make the call in extensions. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Artifex Maximus Sent: martes, 25 de noviembre de 2008 11:25 a.m. To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Asterisk 1.6 mysql cdr log problem Hello! On Tue, Nov 25, 2008 at 2:25 AM, Tilghman Lesher [EMAIL PROTECTED] wrote: On Monday 24 November 2008 06:19:44 pm Tilghman Lesher wrote: On Monday 24 November 2008 11:38:09 am Atis Lezdins wrote: On Sun, Nov 23, 2008 at 2:19 PM, Artifex Maximus [EMAIL PROTECTED] wrote: I've installed a new Asterisk 1.6.0.1 with addons and dahdi drivers and tools but my calls aren't logged. I'd enabled mysql log and noticed that asterisk send a 'DESC cdr' so connection is working between asterisk and mysql and I am able to call other phones so Asterisk is working as well. No error messages on startup though. Any idea why is it happen? As I realized there is some differences between 1.2 (my previous system) and 1.6 log system. I suspect that you have some unique index on the table which is conflicting with the inserted fields. Once you figure out which field is causing the conflict, it should be easier to figure out where the problem actually lies. All indexes are simple indexes so that cannot be a problem. Asterisk's log did not noticed any problem with table structure. [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got hostname of localhost [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got port of xxx [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a timeout of 0 [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got sock file of [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got user of xxx [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got dbname of xxx [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got password of xxx [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Not running in calldate compatibility mode [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Successfully connected to MySQL database. [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'calldate' of type 'datetime' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column calldate, type datetime [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'clid' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column clid, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'src' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column src, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'dst' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column dst, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'dcontext' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column dcontext, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'channel' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column channel, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'dstchannel' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column dstchannel, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'lastapp' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column lastapp, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'lastdata' of type 'varchar(80)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column lastdata, type varchar(80) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'duration' of type 'int(11)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column duration, type int(11) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'billsec' of type 'int(11)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column billsec, type int(11) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'disposition' of type 'varchar(45)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column disposition, type varchar(45) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'amaflags' of type 'int(11)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column amaflags, type int(11) [Nov 21 16:05:16] DEBUG[10740] cdr_addon_mysql.c: Got a field 'accountcode' of type 'varchar(20)' [Nov 21 16:05:16] NOTICE[10740] cdr_addon_mysql.c: Found a DB column accountcode, type varchar(20) [Nov 21 16:05:16] DEBUG[10740
Re: [asterisk-users] Asterisk 1.6 mysql cdr log problem
On Sun, Nov 23, 2008 at 2:19 PM, Artifex Maximus [EMAIL PROTECTED] wrote: Hi all! I've installed a new Asterisk 1.6.0.1 with addons and dahdi drivers and tools but my calls aren't logged. I'd enabled mysql log and noticed that asterisk send a 'DESC cdr' so connection is working between asterisk and mysql and I am able to call other phones so Asterisk is working as well. No error messages on startup though. Any idea why is it happen? As I realized there is some differences between 1.2 (my previous system) and 1.6 log system. You should also check Asterisk log for warnings. 1.6 should detect table structure and warn about missing fields. If it's so, perhaps you can change asterisk - mysql (res_cdr_addon_mysql if i remember correctly) to do an alter on your table - then it will automagically create missing fields. Regards, Atis -- Atis Lezdins, VoIP Project Manager / Developer, IQ Labs Inc, [EMAIL PROTECTED] Skype: atis.lezdins Cell Phone: +371 28806004 Cell Phone: +1 800 7300689 Work phone: +1 800 7502835 ___ -- 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] Asterisk 1.6 mysql cdr log problem
On Monday 24 November 2008 11:38:09 am Atis Lezdins wrote: On Sun, Nov 23, 2008 at 2:19 PM, Artifex Maximus [EMAIL PROTECTED] wrote: I've installed a new Asterisk 1.6.0.1 with addons and dahdi drivers and tools but my calls aren't logged. I'd enabled mysql log and noticed that asterisk send a 'DESC cdr' so connection is working between asterisk and mysql and I am able to call other phones so Asterisk is working as well. No error messages on startup though. Any idea why is it happen? As I realized there is some differences between 1.2 (my previous system) and 1.6 log system. I suspect that you have some unique index on the table which is conflicting with the inserted fields. Once you figure out which field is causing the conflict, it should be easier to figure out where the problem actually lies. You should also check Asterisk log for warnings. 1.6 should detect table structure and warn about missing fields. If it's so, perhaps you can change asterisk - mysql (res_cdr_addon_mysql if i remember correctly) to do an alter on your table - then it will automagically create missing fields. You remember incorrectly. None of the CDR drivers currently have the capability to alter tables. What they will do is to adapt to the table structure and insert only the required fields. Only realtime table drivers have the capability of altering tables and then, only if you turn that behavior on. By default, Asterisk does not alter table structures. -- Tilghman ___ -- 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] Asterisk 1.6 mysql cdr log problem
On Monday 24 November 2008 06:19:44 pm Tilghman Lesher wrote: On Monday 24 November 2008 11:38:09 am Atis Lezdins wrote: On Sun, Nov 23, 2008 at 2:19 PM, Artifex Maximus [EMAIL PROTECTED] wrote: I've installed a new Asterisk 1.6.0.1 with addons and dahdi drivers and tools but my calls aren't logged. I'd enabled mysql log and noticed that asterisk send a 'DESC cdr' so connection is working between asterisk and mysql and I am able to call other phones so Asterisk is working as well. No error messages on startup though. Any idea why is it happen? As I realized there is some differences between 1.2 (my previous system) and 1.6 log system. I suspect that you have some unique index on the table which is conflicting with the inserted fields. Once you figure out which field is causing the conflict, it should be easier to figure out where the problem actually lies. BTW, if you 'core set debug 2 cdr_addon_mysql.c' (and make sure debug is enabled to the console, via /etc/asterisk/logger.conf), then the SQL will be printed to the console. That should help you find where the problem lies. -- Tilghman ___ -- 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] Asterisk 1.6 mysql cdr log problem
Hi all! I've installed a new Asterisk 1.6.0.1 with addons and dahdi drivers and tools but my calls aren't logged. I'd enabled mysql log and noticed that asterisk send a 'DESC cdr' so connection is working between asterisk and mysql and I am able to call other phones so Asterisk is working as well. No error messages on startup though. Any idea why is it happen? As I realized there is some differences between 1.2 (my previous system) and 1.6 log system. Bye, a ___ -- 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