If your setting up realtime its only for friends.. so yes you would still need sip.conf for the peers/friends that aren't listed in the conf file.
bkw > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:asterisk-users- > [EMAIL PROTECTED] On Behalf Of Michael Baird > Sent: Friday, October 15, 2004 3:09 PM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: RE: [Asterisk-Users] res_odbc app_realtime > > Thanks, I had tried it with a basic sip.conf, does this mean I can still > have settings in both a flatfile and a database for sip for example? I > changed the database in my extconfig.conf to mysql, and it still failed, > I ran a trace on odbc and it had an error message, I'm not sure what > that means. I'm using todays asterisk CVS. Is there a better way for me > to debug what's happening, asterisk -vvvv doesn't show me anything when > a sip call comes in, other then it can't find the extension. > > SQL Error > >SQLError > | enter: szErrorMsg: bfffd530 > <SQLError > > Regards > Michael Baird > > 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 > > > > _______________________________________________ > 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
