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/[EMAIL PROTECTED]
<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
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
