[Asterisk-Users] Asterisk Realtime and ODBC

[Brian West]

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
>