[Asterisk-Users] * not logging CDR to MySQL - anyway I can debug this?

[Tilghman Lesher]

On Tuesday 30 September 2003 10:57, Leif Madsen wrote:
> I have created a user called asteriskuser and granted all privileges
> to the asteriskcdrdb database.  Then I created the table via the
> cdr_mysql.txt file.  I have edited the cdr_mysql.conf file to reflect
> this, and added load => cdr_addon_mysql.so after compiling it from
> the latest CVS.
>
> If I check the Master.csv file in /var/log/asterisk/cdr-csv/ then I
> can see that Asterisk is indeed logging calls, so no problem there,
> but I don't know if it is connecting to the database, getting an
> error, even attempting?
>
> The database stays empty after placing or receieving calls.  What
> else can I do to debug this and try to find out where Asterisk is
> failing to write to the DB?  (yes, the database is started :))
>
> I've verified that I can login to mysql with the username and
> password, and it's fine.  Then I do a select * from
> asteriskcdrdb.cdr; to see if anything has been written, and sure
> enough, just Empty.

Try this command (from your bash shell):
grep cdr_mysql /var/log/asterisk/messages

-Tilghman