[asterisk-users] Asterisk 1.6 mysql cdr log problem

[Artifex Maximus]

Hello!

On Tue, Nov 25, 2008 at 2:25 AM, Tilghman Lesher
<tilghman at mail.jeffandtilghman.com> 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 <artifexor at gmail.com>
>>
>> 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