[asterisk-users] CDR direct executed failed

[termo termosel]

Hi,

I have configured the cdr throught ODBC with this files:

/etc/cdr_odbc.conf
[global]
dsn=asterisk2
;loguniqueid=yes
dispositionstring=yes
table=cdr        ;"cdr" is default table name
usegmtime=no             ; set to "yes" to log in GMT
hrtime=yes        ;Enables microsecond accuracy with the billsec and duration fields

/etc/cdr.conf
[general]
enable=yes
unanswered = yes

/etc/res_odbc.conf
[asterisk]
enabled => yes
dsn => asterisk-connector
pre-connect => yes

[asterisk2]
enabled => yes
dsn => asterisk-cdr
pre-connect => yes

etc/odbc.ini

[asterisk-connector]
Description=SQLite3 database
Driver=SQLite3
Database=/var/lib/asterisk/sqlite3dir/sqlite3.db
# optional lock timeout in miliseconds
Timeout=2000

[asterisk-cdr]
Description=SQLite3 db
Driver=SQLite3
Database=/var/log/asterisk/master.db
# optional lock timeout in miliseconds
Timeout=2000

When I put in Asterisk CLI, odbc show, Its shows me:

ODBC DSN Settings
-----------------

  Name:   asterisk
  DSN:    asterisk-connector
    Last connection attempt: 1970-01-01 01:00:00
  Pooled: No
  Connected: Yes

  Name:   asterisk2
  DSN:    asterisk-cdr
    Last connection attempt: 1970-01-01 01:00:00
  Pooled: No
  Connected: Yes

But when I make a call warnigs appear and I don't acces to database

[Feb 21 10:30:53] WARNING[7101][C-00000007]: res_odbc.c:608 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk2 [asterisk-cdr]...
[Feb 21 10:30:53] ERROR[7101][C-00000007]: cdr_odbc.c:162 odbc_log: CDR direct execute failed

Can someone help me?

Thanks,
Jordi
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130221/21e0bc48/attachment.htm>