<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi,<br><br>I have configured the cdr throught ODBC with this files:<br><br>/etc/cdr_odbc.conf<br>[global]<br>dsn=asterisk2<br>;loguniqueid=yes<br>dispositionstring=yes<br>table=cdr ;"cdr" is default table name<br>usegmtime=no ; set to "yes" to log in GMT<br>hrtime=yes ;Enables microsecond accuracy with the billsec and duration fields<br><br>/etc/cdr.conf<br>[general]<br>enable=yes<br>unanswered = yes<br><br>/etc/res_odbc.conf<br>[asterisk]<br>enabled => yes<br>dsn => asterisk-connector<br>pre-connect => yes<br><br>[asterisk2]<br>enabled => yes<br>dsn => asterisk-cdr<br>pre-connect => yes<br><br>etc/odbc.ini<br><br>[asterisk-connector]<br>Description=SQLite3 database<br>Driver=SQLite3<br>Database=/var/lib/asterisk/sqlite3dir/sqlite3.db<br># optional lock timeout in miliseconds<br>Timeout=2000<br><br>[asterisk-cdr]<br>Description=SQLite3 db<br>Driver=SQLite3<br>Database=/var/log/asterisk/master.db<br># optional lock timeout in miliseconds<br>Timeout=2000<br><br>When I put in Asterisk CLI, odbc show, Its shows me:<br><br>ODBC DSN Settings<br>-----------------<br><br> Name: asterisk<br> DSN: asterisk-connector<br> Last connection attempt: 1970-01-01 01:00:00<br> Pooled: No<br> Connected: Yes<br><br> Name: asterisk2<br> DSN: asterisk-cdr<br> Last connection attempt: 1970-01-01 01:00:00<br> Pooled: No<br> Connected: Yes<br><br>But when I make a call warnigs appear and I don't acces to database<br><br>[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]...<br>[Feb 21 10:30:53] ERROR[7101][C-00000007]: cdr_odbc.c:162 odbc_log: CDR direct execute failed<br><br>Can someone help me?<br><br>Thanks,<br>Jordi<br> </div></body>
</html>