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
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
