[Asterisk-Users] cdr_addon_mysql compile error

[Tilghman Lesher]

On Friday 30 January 2004 09:41, Asterisk VOIP wrote:
> On Thu, 29 Jan 2004 20:01:05 -0600, Tilghman Lesher wrote
>
> > On Thursday 29 January 2004 19:40, Asterisk VOIP wrote:
> > > almost got it.  I now get the following in the CLI,
> > >  ERROR[1226054960]: cdr_addon_mysql.c:203 mysql_log: Failed to
> > > insert into database.  db is setup correctly.
> >
> > You probably have a single field missing or misspelled.  Recheck
> > your table definition.
> >
> > > asterisk is started with /usr/sbin/asterisk -vvvvc but the only
> > > messages I find are, LOG_ERROR, in the CLI.  Where are the
> > > LOG_DEBUG messages?
> >
> > They aren't actually logged to disk or to the CLI unless you
> > configure them to go there.  Look in /etc/asterisk/logger.conf.
>
> got it!  last question.... the uniqueid and userfield info
> is empty for all calls.  should I "Add a
> CFLAGS+=-DMYSQL_LOGUNIQUEID to the Makefile" for cdr_addon_mysql.c
> and do a make clean make install to get the uniqueid info?

If you want that, yes.

> what about the userfield info?

It only gets set if you execute SetCDRUserField() during the dialplan.
Obviously, what you choose to put in the userfield is user-defined
(i.e. the default is always going to be blank).

-Tilghman