asterisk users - Feb 2013 - CDR direct executed failed

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>

termo termosel wrote:
>
> But when I make a call warnigs appear and I don't acces to database
I don't know about sqlite3, I use either MariaDB or Mysql, this is my 
configs:

I don't use cdr.conf

cat cdr_odbc.conf

[global]
dsn=MySQL-cdr
dispositionstring=yes
table=cdr
usegmtime=no

cat res_odbc.conf

[MySQL-cdr]
enable => yes
dsn => MySQL-cdr
username => superuser
password => supersecret
preconnect => yes

cat odbc.ini

[MySQL-cdr]
Description     = CDR Database
Driver          = MySQL
Server          = 192.168.104.107
User            = superuser
Password        = supersecret
Database        = asteriskcdr
Option          = 3

Doug

-- 
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."