[Asterisk-Users] cdr_mysql

[Tilghman Lesher]

On Monday 18 August 2003 12:33 pm, Tais M. Hansen wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Monday 18 August 2003 18:55, Tilghman Lesher wrote:
> > > There's nothing cdr_mysql related debug output.
> > > $ asterisk -vvvvvgcdf
> >
> > Turn on debugging in /etc/asterisk/logger.conf
>
> Yes. Forgot debug was put into a different file. Sorry.
>
>
> Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 284
> (load_module): cdr_mysql: got hostname of localhost
> Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 285
> (load_module): cdr_mysql: got port of 3306
> Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 287
> (load_module): cdr_mysql: got sock file of
> /var/run/mysql/mysql.sock
> Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 288
> (load_module): cdr_mysql: got user of asteriskcdr
> Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 289
> (load_module): cdr_mysql: got dbname of asterisk
> Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 290
> (load_module): cdr_mysql: got password of j501MNGfRUQo8sLg
> Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 298
> (load_module): Successfully connected to MySQL database.
>
>
> That's what I found. I've attached a log of a call from init to
> hangup. Note that I removed pri dchannel debug and hid phone and
> ipnumbers.

Looks like mysql_log() is not actually getting called.  Try a pure
Zap bridged call or an IAX2 call (both of which I've tested) and see
if it still doesn't work for you.  Are you getting a log from cdr_csv
in the log file (i.e. is CDR logging working at all)?

-Tilghman