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" <[EMAIL PROTECTED]> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:asterisk-users- > > [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > 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 > > > [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
