[Asterisk-Users] Asterisk Realtime and ODBC

[Tim Lyakhovetskiy]

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/