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 /etc/asterisk/logger.conf), then the SQL will be > printed to the console. That should help you find where the problem lies. Wow! Thanks for this information! And now coming the most interesting part. I did not do anything with that box and mysql log working fine. I have no idea at all what happen. Thanks for your help! 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
