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/[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
_______________________________________________
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
