asterisk users - Aug 2010 - problem with mssql and Asterisk 1.8.0 beta3

Hi all,

I am testing with Asterisk 1.8.0 beta3 using realtime with a mssql server using
freetds and unixodbc, which works with 1.6.1.20.

With the same config in 1.8 I get an error when trying to start asterisk which
says:


[Aug 23 15:06:12] WARNING[7180]: loader.c:387 load_dynamic_module: Error loading
module 'res_config_odbc.so':
/usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol:
ast_odbc_clear_cache
[Aug 23 15:06:12] NOTICE[7180]: res_odbc.c:1471 odbc_obj_connect: Connecting
mssql
asterisk: net.c:348: tds_select: Assertion `timeout_seconds >= 0' failed.

When I set 


[mssql]
enabled => no

in res_odbc.conf asterisk starts.

Have there been changes in res_odbc or is this a bug?

Thanks for advise.

Oliver
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100823/885bfc6d/attachment.htm

On Monday 23 August 2010 08:14:43 unserossi at aol.com
wrote:
> Hi all,
>
> I am testing with Asterisk 1.8.0 beta3 using realtime with a mssql server
> using freetds and unixodbc, which works with 1.6.1.20.
>
> With the same config in 1.8 I get an error when trying to start asterisk
> which says:
>
>
> [Aug 23 15:06:12] WARNING[7180]: loader.c:387 load_dynamic_module: Error
> loading module 'res_config_odbc.so':
> /usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol:
> ast_odbc_clear_cache
For this one, you need to ensure that res_odbc.so loads before 
res_config_odbc.so.  Actually, the load order in 1.8 is such that, unless
you're using static realtime, you should not be using the 'preload'
directive
at all, and everything will just naturally load in the right order.
> [Aug 23 15:06:12] NOTICE[7180]: res_odbc.c:1471 
> odbc_obj_connect: Connecting mssql asterisk: net.c:348: tds_select:
> Assertion `timeout_seconds >= 0' failed.
This is internal to the freetds driver and is therefore not a bug in Asterisk.

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org

For this one, you need to ensure that res_odbc.so loads before 
res_config_odbc.so. Actually, the load order in 1.8 is such that, unless
you're using static realtime, you should not be using the 'preload'
directive
at all, and everything will just naturally load in the right order.
--
If I got that right, static realtime would mean something like


sip.conf => driver,database[,table[,priority]]
 
But I have 

sipusers => odbc,mssql,t_sip_buddies
sippeers => odbc,mssql,t_sip_buddies
sipregs => odbc,mssql,t_sip_buddies
 
so I would assume that I don't need to preload res_odbc.so and
res_config_odbc.so?
 
But without the preloads in modules.conf when trying to start asterisk I get
 
[Aug 24 16:28:34] NOTICE[6825]: cdr.c:1567 do_reload: CDR simple logging
enabled.
[Aug 24 16:28:34] NOTICE[6825]: loader.c:1098 load_modules: 193 modules will be
loaded.
[Aug 24 16:28:34] WARNING[6825]: loader.c:387 load_dynamic_module: Error loading
module 'res_config_odbc.so':
/usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol:
ast_odbc_clear_cache
[Aug 24 16:28:34] NOTICE[6825]: res_odbc.c:1471 odbc_obj_connect: Connecting
mssql
asterisk: net.c:348: tds_select: Assertion `timeout_seconds >= 0' failed.

 
and asterisk does not start.

 
With the preloads I get
 
[Aug 24 16:29:25] NOTICE[6857]: loader.c:1098 load_modules: 2 modules will be
loaded.
[Aug 24 16:29:25] NOTICE[6857]: res_odbc.c:1471 odbc_obj_connect: Connecting
mssql
asterisk: net.c:348: tds_select: Assertion `timeout_seconds >= 0' failed.

 
and asterisk does not start either.
 
Only if I set my DSN 'mssql' to enabled => no in res_odbc.conf
asterisk starts, but then it can't access my sip users config of course.
 
So for me this looks like a bug because in 1.6 this worked without any problems.
 
Oliver




















-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100824/b50f6c4c/attachment-0001.htm