[Asterisk-Users] res_odbc app_realtime

[Matthew Boehm]

I've only had 1 person notify me of that. Didn't know it affected others
too. If you can supply more information. I guess I should install ODBC and
see what happens.

Matthew
----- Original Message ----- 
From: "Brian West" <brian at bkw.org>
To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"
<asterisk-users at lists.digium.com>
Sent: Friday, October 15, 2004 3:14 PM
Subject: RE: [Asterisk-Users] res_odbc app_realtime


> Matthew,
> If you have a chance can you look at the bug associated with having
> both mysql and odbc loaded?  If one or the other is loaded its fine.. both
> it goes kaboom.
>
> bkw
>
> > -----Original Message-----
> > From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
> > bounces at lists.digium.com] On Behalf Of Matthew Boehm
> > Sent: Friday, October 15, 2004 3:10 PM
> > To: Asterisk Users Mailing List - Non-Commercial Discussion
> > Subject: Re: [Asterisk-Users] res_odbc app_realtime
> >
> > >From what I have seen, that is the wrong table layout for using
res_odbc
> > and
> > storing *.conf files.
> > Should be more like this:
> >
> > http://www.voip-info.org/wiki-Asterisk+res_config
> >
> > If you want to use RealTime and MySQL, I have developed (the only) a
> > native
> > RealTime driver for MySQL.
> >
> > It bypasses ODBC and makes calls directly to mysql.
> >
> > http://bugs.digium.com/bug_view_page.php?bug_id=0002613
> >
> > It should be noted that RealTime is currently in development and not
> > recommened for prod servers.
> >
> > Matthew
> > ----- Original Message -----
> > From: "Michael Baird" <mike at tc3net.com>
> > To: <asterisk-users at lists.digium.com>
> > Sent: Friday, October 15, 2004 2:29 PM
> > 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