[Asterisk-Users] Asterisk Realtime and ODBC

[Tim Lyakhovetskiy]

Tried all sorts of different combinations; loading just a config file, or 
loading just peers, or loading just extensions, etc... None of it produces 
any query packets on the network.

Thanks,
-Tim

>
>try putting your sip.conf on disk and load peers/users from the  database.
>
>/b
>---
>Anakin: “You’re either with me, or you’re my enemy.”
>Obi-Wan: “Only a Sith could be an absolutist.”
>
>On Jun 28, 2005, at 1:36 PM, Tim Lyakhovetskiy wrote:
>
>>Hello all!
>>
>>My basic problem is that we haven't been able to get realtime to  use ODBC 
>>to store configuration data. Here are the details:
>>
>>We've installed Asterisk on a CentOS machine as follows:
>>1. Downloaded, compiled, and installed FreeTDS 0.63
>>2. Downloaded, compiled, and installed  unixODBC 2.2.11
>>3. Downloaded, compiled, and installed Asterisk, Asterisk-Addons,  and 
>>Zaptel from CVS HEAD
>>
>>We checked the FreeTDS and ODBC connections several ways, using the  
>>"tsql" and "isql" utilities, and Ethereal for network monitoring.  
>>Everything worked perfectly. Then we set up asterisk as follows:
>>
>><extconfig.conf>
>>
>>[settings]
>>
>>sip.conf => odbc,asterisk,ast_config
>>sipusers => odbc,asterisk,sip_buddies
>>sippeers => odbc,asterisk,sip_buddies
>>extensions_table => odbc,asterisk,extensions_table
>>
>><extensions.conf>
>>
>>[default]
>>switch => Realtime/default at extensions_table
>>
>><res_odbc.conf>
>>
>>[asterisk]
>>dsn => "our DSN name"
>>username => "our username"
>>password => "our password"
>>pre-connect => yes
>>
>><modules.conf>
>>
>>[modules]
>>autoload=yes
>>
>>noload => pbx_gtkconsole.so
>>noload => pbx_kdeconsole.so
>>noload => app_intercom.so
>>
>>load => chan_modem.so
>>load => res_musiconhold.so
>>
>>noload => chan_alsa.so
>>
>>noload => res_config_mysql.so
>>noload => cdr_addon_mysql.so
>>load => app_realtime.so
>>load => pbx_realtime.so
>>
>>After that, we loaded up Asterisk, and there were no error  messages. Not 
>>only that, the res_odbc and res_config_odbc modules  loaded up just fine, 
>>AND Ethereal showed that a login to our MS SQL  database went through. 
>>However, when we tried to add extensions or  SIP friends, nothing worked. 
>>The strange thing was that Asterisk  didn't even try to query the database 
>>(observed through Ethereal)  and just tried to use the conf files.
>>
>>Just to make sure we weren't crazy, we set up Asterisk using MySQL  and 
>>that setup worked perfectly right from the start. We would  still like to 
>>use ODBC->MS SQL though, because we would like to  keep the amount of 
>>different databases minimal.
>>
>>voip-info isn't much help on this, and we've looked far and wide  for any 
>>more information regarding Asterisk ODBC setups, finding  very little.
>>
>>Anything we missed?
>>
>>Thanks,
>>-Tim Lyakhovetskiy
>>
>>_________________________________________________________________
>>Express yourself instantly with MSN Messenger! Download today -  it's 
>>FREE! http://messenger.msn.click-url.com/go/onm00200471ave/ direct/01/
>>
>>_______________________________________________
>>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

_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee® 
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963