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:brak-test@brak.netlogic.net>' failed for 'blah'
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 (mschulte@netlogic.net) 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:brak-test@brak.netlogic.net>' 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 joe@dennick.net
Matt Schulte wrote:> anything, driving me nuts. I'm running asterisk 1.0.6, as head won't"Take your 'blah-blah' to the 'blah-blahtologist'." - Dr. Cox, Scrubs RealTime requires CVS-HEAD!!!!! That is why its not working with 1.0.6!!! Perhaps I should make the font on the wiki larger..hmm.. -Matthew
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:joe@dennick.net] 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 (mschulte@netlogic.net) 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:brak-test@brak.netlogic.net>' 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 joe@dennick.net _______________________________________________ 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
I'm a little confused about something with Realtime. It isn't clear to me what order Asterisk prefers to read the config. If we are using realtime, do we have to completely throw away the use of the .conf files? Sometimes not it appears. Extensions.conf lets you have a switch command to call into Realtime. For other conf files, you can use the realtime static table to load the general sections, or can you? I guess this question doesn't make much sense because the docs don't make much sense to me. My preference is to have static stuff in the config files and have dynamic portions, ie bits that might change, in realtime. Doug.
Actually, this is weird too... I have in my res_mysql.conf file: queues => mysql,voxdb,ast_queues queue_members => mysql,voxdb,ast_queue_members and I an connecting to realtime. I removed the agents.conf file. Upon load, Asterisk reports: Dec 22 09:56:40 NOTICE[18475]: chan_agent.c:1033 read_agent_config: No agent configuration found -- agent support disabled I run a network trace when I try to call AgentCallbackLogin and Asterisk isn't even querying the database. So, it appears that with extconfig configured, and no agents.conf file, Asterisk just disables the feature. What am I missing? Thanks, Doug -----Original Message----- From: Douglas Garstang Sent: Thursday, December 22, 2005 9:34 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Realtime Config I'm a little confused about something with Realtime. It isn't clear to me what order Asterisk prefers to read the config. If we are using realtime, do we have to completely throw away the use of the .conf files? Sometimes not it appears. Extensions.conf lets you have a switch command to call into Realtime. For other conf files, you can use the realtime static table to load the general sections, or can you? I guess this question doesn't make much sense because the docs don't make much sense to me. My preference is to have static stuff in the config files and have dynamic portions, ie bits that might change, in realtime. Doug.
Hi Aaron. Well, there's 'realtime static' which it supposedly uses. It's table structure is: CREATE TABLE `ast_config` ( `id` int(11) NOT NULL auto_increment, `cat_metric` int(11) NOT NULL default '0', `var_metric` int(11) NOT NULL default '0', `commented` int(11) NOT NULL default '0', `filename` varchar(128) NOT NULL default '', `category` varchar(128) NOT NULL default 'default', `var_name` varchar(128) NOT NULL default '', `var_val` varchar(128) NOT NULL default '', PRIMARY KEY (`id`), KEY `filename_comment` (`filename`,`commented`) ) TYPE=MyISAM; and you can use it to store information in the [general] section and so on. I know this works because I've used it before. It just isn't clear if all the config files use it or not. Doug. -----Original Message----- From: Aaron Daniel [mailto:amdtech@shsu.edu] Sent: Thursday, December 22, 2005 9:41 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime Config As far as I can tell with our systems, the config files are read first, then the realtime db. We've got a few static servers that never change, so I hardcode those in case something goes wrong with the DB, and the DB contains any other configurations that will be dynamic. I'm not sure if realtime has any support for the basic general information at the top of the config files, so I think you need to have the files to convey that information. Aaron Douglas Garstang wrote:> I'm a little confused about something with Realtime. > > It isn't clear to me what order Asterisk prefers to read the config. If we are using realtime, do we have to completely throw away the use of the .conf files? Sometimes not it appears. Extensions.conf lets you have a switch command to call into Realtime. For other conf files, you can use the realtime static table to load the general sections, or can you? I guess this question doesn't make much sense because the docs don't make much sense to me. > > My preference is to have static stuff in the config files and have dynamic portions, ie bits that might change, in realtime. > > Doug. > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >_______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users