<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&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ;"cdr" is default table name<br>usegmtime=no&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ; set to "yes" to log in GMT<br>hrtime=yes&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ;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 =&gt; yes<br>dsn =&gt; asterisk-connector<br>pre-connect =&gt; yes<br><br>[asterisk2]<br>enabled =&gt; yes<br>dsn =&gt; asterisk-cdr<br>pre-connect =&gt; 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>&nbsp; Name:&nbsp;&nbsp; asterisk<br>&nbsp; DSN:&nbsp;&nbsp;&nbsp; asterisk-connector<br>&nbsp;&nbsp;&nbsp; Last connection attempt: 1970-01-01 01:00:00<br>&nbsp; Pooled: No<br>&nbsp; Connected: Yes<br><br>&nbsp; Name:&nbsp;&nbsp; asterisk2<br>&nbsp; DSN:&nbsp;&nbsp;&nbsp; asterisk-cdr<br>&nbsp;&nbsp;&nbsp; Last connection attempt: 1970-01-01 01:00:00<br>&nbsp; Pooled: No<br>&nbsp; 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>