[asterisk-users] Asterisk 1.6 mysql cdr log problem

[Tilghman Lesher]

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.

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