[Asterisk-Users] res_odbc app_realtime

[Brian West]

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: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
> bounces at lists.digium.com] 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: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
> > > bounces at lists.digium.com] 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: asterisk-users-bounces at lists.digium.com [mailto:asterisk-
> users-
> > > > bounces at lists.digium.com] On Behalf Of Michael Baird
> > > > Sent: Friday, October 15, 2004 2:30 PM
> > > > To: asterisk-users at lists.digium.com
> > > > 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
> > > > Asterisk-Users at lists.digium.com
> > > > 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
> > > Asterisk-Users at lists.digium.com
> > > 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
> > Asterisk-Users at lists.digium.com
> > 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
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users