[asterisk-users] ODBC and SQLIte3

[termo termosel]

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
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130217/999289df/attachment.htm>