[asterisk-users] Hints to help me debug cdr_odbc not inserting

[Tim Panton]

Has anyone got a hint as to how I can best debug my problem with writing
cdr to an odbc database?

Problem:
	It doesn't insert records, it doesn't complain either .
The cdr entries turn up in cdr_csv/Master.csv just fine, but not in  
my database.

debug log says:
Jul 18 16:57:07 DEBUG[25511] cdr_odbc.c: cdr_odbc: Logging uniqueid
Jul 18 16:57:07 DEBUG[25511] cdr_odbc.c: cdr_odbc: Logging in GMT

which it didn't till I had the dsn correct.

I can use isql to insert entries into the database, but asterisk
doesn't seem to want to.

I have the config in flat files, so I get warnings from res_odbc,
but that isn't the problem (is it?)

The (only) thing I'm doing that's out of the ordinary is that I'm using
Oracle XE (on a remote machine) as the database and using
Oracle's unixOdbc driver. I had to work on the postgres version
of the table create code to get something equivalent in oracle.

How can I see why asterisk isn't attempting an insert ?
Or if it is, why don't I see any errors?

Thanks in advance for any clues.....




Tim Panton

www.mexuar.com