I got the CVS head to compile finally, and yes I ditched odbc. noob or not, it's a pain in the a$$ if you mess up the install. All in all, mysql seems to work fine. Thanks.
Matt -----Original Message----- From: Joe Dennick [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 1:20 PM To: Asterisk Users Mailing List -Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime config Have you considered using the mysql method instead of the odbc method. I'm using it and it works just fine. Here's a sample of my extconfig.conf: extensions => mysql,ast-conf,extension sipfriends => mysql,ast-conf,sip_buddi voicemail => mysql,ast-conf,voicemail You also need to add the floowing to your res_mysql.conf file: [general] dbhost = 192.168.1.7 dbname = ast-conf dbuser = dbusername dbpass = blah dbport = 3306 dbsock = /tmp/mysql.sock The only two things I have found that doesn't work is a) the mailbox entry for a SIP user doesn't actually light up the MWI (Message Waiting Indicator); and b) voicemail passwords cannot begin with a '0' (zero) because its a numeric field. Matt Schulte ([EMAIL PROTECTED]) wrote: > > Having problems getting realtime working, I'm trying to use odbc for > all of this. I've got Fedora 3 and have been fighting with odbc for a > day now. I think I got it working correctly, however I can't seem to > get the realtime portion working. In asterisk 'odbc show' shows it > connected, I see it on my (odbc) mysql server connected and all, it > connects and just idles. So, without saying too much more here's the > configs: > > odbcinst.ini > > [mysql] > Description = ODBC for MySQL > Driver = /usr/lib/libmyodbc3.so > Setup = /usr/lib/libodbcmyS.so > FileUsage = 1 > > odbc.ini > --- > Description = Asterisk MySQL Connection > Trace = off > TraceFile = stderr > Driver = mysql > Server = blah.blah > User = blah > Password = blah > port = 3306 > database = asterisk > > extconfig.conf > > iaxfriends => odbc,asterisk,sip_users > sipfriends => odbc,asterisk,sip_users > sipusers => odbc,asterisk,sip_users > sippeers => odbc,asterisk,sip_users > > > [asterisk] > dsn => asterisk > username => dffjdg > password => blajh > pre-connect => yes > > > Ok, now that's out of the way. In my debug log it shows -nothing-, > besides what I can see in the console. It shows no queries or > anything, driving me nuts. I'm running asterisk 1.0.6, as head won't > seem to compile (as of this this email).. > > I'm trying to test realtime via simply SIP REGISTER: > > Mar 15 13:40:39 NOTICE[7905]: chan_iax2.c:3910 register_verify: No > registration for peer 'brak-test' (from blah blah) Mar 15 13:40:39 > NOTICE[7906]: chan_sip.c:7681 handle_request: Registration from > '<sip:[EMAIL PROTECTED]>' failed for 'blah' > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@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 > -- Joe Dennick [EMAIL PROTECTED] _______________________________________________ Asterisk-Users mailing list Asterisk-Users@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@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