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 _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
