[Asterisk-Users] res_odbc app_realtime

[Michael Baird]

Hello, I've been trying to move some of my static configs into a MySQL
database. I have been trying with sip.conf and voicemail.conf, can't
seem to get it to work although it says it is loading the config via
res_odbc fine. Here's what I did, if someone can't point out my error, I
would be grateful.

Setup up UnixODBC, verified I could connect to my database through it,
with the test application, all worked fine.

I then setup res_odbc.conf in /etc/asterisk, like so
[mysql]
dsn => MySQL-voicemail
username => dbuser
password => dbpass 
pre-connect => yes

I setup /etc/asterisk/extconfig.conf with the following info.
[settings]
; file.conf => driver,database[,table]
sip.conf => odbc,accounting,sipusers

I removed sip.conf from /etc/asterisk

I setup my database called accounting, with data in the table sipusers

sipusers table layout

name | host | context | ipaddr | port | regseconds | callerid | username
| md5secret 

Then I start up asterisk with asterisk -vvvv and see the following

Oct 15 15:18:54 NOTICE[1077037376]: config.c:556 ast_config_register:
Registered Config Engine odbc
  == Parsing '/etc/asterisk/extconfig.conf': Found
  == Binding sip.conf to mysql/accounting/sipusers
res_config_odbc loaded.

Which looks good I think, until the end, and chan_sip.so fails to load
and sip doesn't run.

[chan_sip.so] => (Session Initiation Protocol (SIP))
  == Parsing '/etc/asterisk/sip.conf': Not found (No such file or
directory)
Oct 15 15:23:21 NOTICE[1077037376]: chan_sip.c:8432 reload_config:
Unable to load config sip.conf, SIP disabled

I tried setting up voicemail.conf with similar errors, both voicemail
and sip work fine when accessed from flatfiles. 

Regards
Michael Baird