[asterisk-users] Asterisk 1.6 mysql cdr log problem

[Atis Lezdins]

On Tue, Nov 25, 2008 at 2:19 AM, Tilghman Lesher
<tilghman at mail.jeffandtilghman.com> 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.
>
>> 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,
atis at iq-labs.net
Skype: atis.lezdins
Cell Phone: +371 28806004
Cell Phone: +1 800 7300689
Work phone: +1 800 7502835