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: Youre either with me, or youre 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
_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee®
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
_______________________________________________
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
