Also your database is [mysql] not accounting. bkw
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:asterisk-users- > [EMAIL PROTECTED] On Behalf Of Brian West > Sent: Friday, October 15, 2004 2:36 PM > To: 'Asterisk Users Mailing List - Non-Commercial Discussion' > Subject: RE: [Asterisk-Users] res_odbc app_realtime > > You must still have a sip.conf with the [general] section. > > bkw > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:asterisk-users- > > [EMAIL PROTECTED] On Behalf Of Michael Baird > > Sent: Friday, October 15, 2004 2:30 PM > > To: [EMAIL PROTECTED] > > Subject: [Asterisk-Users] res_odbc app_realtime > > > > 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 > > _______________________________________________ > 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 _______________________________________________ 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