<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Hi,<br><br>I had configured Asterisk to use default database located in /var/lib/asterisk/sqlite3dir/sqlite3.db. When I put odbc show in Asterisk's cli, It returns me that I have conected but when I put "sip show peers",Asterisk doesn't found any peer or user.<br><br>ubuntu*CLI> odbc show<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>ubuntu*CLI> sip show peers<br>Name/username Host Dyn Forcerport ACL Port Status Description Realtime<br>0 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 0 offline]<br><br><br>This mi configuration,<br><br>/etc/odbci.ini<br><br>[asterisk-connector]<br>Description = SQLite3 database <br>Driver = SQLite3<br>Database = /var/lib/asterisk/sqlite3dir/sqlite3.db<br><br>/etc/odbcinst.ini<br><br>[SQLite3]<br>Description= SQLite3 ODBC Driver<br>Driver=/usr/local/lib/libsqlite3odbc.so<br>Setup=/usr/local/lib/libsqlite3odbc.so<br>Threading=2<br><br>/etc/asterisk/extconfig.conf<br><br>[settings]<br><br>sipusers => odbc,asterisk,sip_buddies<br>sippeers => odbc,asterisk,sip_buddies<br>sipregs => odbc,asterisk,sip_buddies<br><br>/etc/asterisk/func_odbc.conf<br><br>[SQL]<br>dsn=asterisk<br>readsql=${ARG1}<br><br>/etc/asterisk/modules.conf<br><br>autoload=yes<br>;preload => res_odbc.so<br>;preload => res_config_odbc.so<br>noload => pbx_gtkconsole.so<br>;load => pbx_gtkconsole.so<br>noload => pbx_kdeconsole.so<br>noload => app_intercom.so<br>noload => chan_modem.so<br>noload => chan_modem_aopen.so<br>noload => chan_modem_bestdata.so<br>noload => chan_modem_i4l.so<br>noload => chan_capi.so<br>load => res_musiconhold.so<br>noload => chan_alsa.so<br>;noload => chan_oss.so<br>noload => cdr_sqlite.so<br>noload => app_directory_odbc.so<br>;noload => res_config_odbc.so<br>;noload => res_config_pgsql.so<br><br>/etc/asterisk/res_odbc.conf<br><br>[asterisk]<br>enabled => yes<br>dsn => asterisk-connector<br>pre-connect => yes<br><br><br>Can someone help me?<br><br>Thanks,<br>Jordi<br> </div></body>
</html>