Tim Panton
2006-Jul-18 13:09 UTC
[asterisk-users] Hints to help me debug cdr_odbc not inserting
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
Tomislav Parčina
2006-Jul-30 23:16 UTC
[asterisk-users] Re: Hints to help me debug cdr_odbc not inserting
In article <F053D932-3A73-4C77-9EBC-A184E1D722A9@mexuar.com>, tim@mexuar.com says...> 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.....Hi Tim! You can check conection to database like tihis. [root@pbx ~]# isql -v MSSQL-asterisk username password +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> q [root@pbx ~]# -- Tomislav Par?ina Lama Computers Split Stinice 12, 21000 Split Tel.: +385(21)495148 Mob.: +385(91)1212148 SIP: tomo@pbx.lama.hr e-mail: tparcina#lama.hr http://www.lama.hr