Hi,
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.
ubuntu*CLI> odbc show
ODBC DSN Settings
-----------------
Name: asterisk
DSN: asterisk-connector
Last connection attempt: 1970-01-01 01:00:00
Pooled: No
Connected: Yes
ubuntu*CLI> sip show peers
Name/username Host Dyn
Forcerport ACL Port Status Description Realtime
0 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 0 offline]
This mi configuration,
/etc/odbci.ini
[asterisk-connector]
Description = SQLite3 database
Driver = SQLite3
Database = /var/lib/asterisk/sqlite3dir/sqlite3.db
/etc/odbcinst.ini
[SQLite3]
Description= SQLite3 ODBC Driver
Driver=/usr/local/lib/libsqlite3odbc.so
Setup=/usr/local/lib/libsqlite3odbc.so
Threading=2
/etc/asterisk/extconfig.conf
[settings]
sipusers => odbc,asterisk,sip_buddies
sippeers => odbc,asterisk,sip_buddies
sipregs => odbc,asterisk,sip_buddies
/etc/asterisk/func_odbc.conf
[SQL]
dsn=asterisk
readsql=${ARG1}
/etc/asterisk/modules.conf
autoload=yes
;preload => res_odbc.so
;preload => res_config_odbc.so
noload => pbx_gtkconsole.so
;load => pbx_gtkconsole.so
noload => pbx_kdeconsole.so
noload => app_intercom.so
noload => chan_modem.so
noload => chan_modem_aopen.so
noload => chan_modem_bestdata.so
noload => chan_modem_i4l.so
noload => chan_capi.so
load => res_musiconhold.so
noload => chan_alsa.so
;noload => chan_oss.so
noload => cdr_sqlite.so
noload => app_directory_odbc.so
;noload => res_config_odbc.so
;noload => res_config_pgsql.so
/etc/asterisk/res_odbc.conf
[asterisk]
enabled => yes
dsn => asterisk-connector
pre-connect => yes
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
