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

2006-07-31 Thread Tomislav Parčina
In article [EMAIL PROTECTED], [EMAIL PROTECTED] 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.


[EMAIL PROTECTED] ~]# isql -v MSSQL-asterisk username password
+---+
| Connected!|
|   |
| sql-statement |
| help [tablename]  |
| quit  |
|   |
+---+
SQL q
[EMAIL PROTECTED] ~]#


--
Tomislav Parčina
Lama Computers Split
Stinice 12, 21000 Split
Tel.: +385(21)495148
Mob.: +385(91)1212148
SIP: [EMAIL PROTECTED]
e-mail: tparcina#lama.hr
http://www.lama.hr
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


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

2006-07-31 Thread Jean-Michel Hiver

Tomislav Parčina a écrit :


In article [EMAIL PROTECTED], [EMAIL PROTECTED] says...
 


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

Does the user asterisks connects the db with have the proper permissions 
on the cdr table?


Have you checked that the table specified in cdr_odbc.conf exists?

What do you see when you go on the Asterisk CLI, type set verbose 
10 and attempt a call?


Cheers,
Jean-Michel.
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users