[asterisk-bugs] [Asterisk 0017911]: ODBC connection to mssql does not work

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17911 
====================================================================== 
Reported By:                wurstsalat
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17911
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
Asterisk Version:           1.8.0-beta4 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-08-25 09:00 CDT
Last Modified:              2010-08-25 11:12 CDT
====================================================================== 
Summary:                    ODBC connection to mssql does not work
Description: 
Using sip peers and users in realtime via res_odbc and unixodbc does not
work anymore with mssql using freetds driver.

my extconfig.conf
sipusers => odbc,mssql,t_sip_buddies
sippeers => odbc,mssql,t_sip_buddies

my res_odbc.conf
[mssql]
enabled => no
dsn => servername
share_connections => no
limit => 5
username => public
password => public
pre-connect => yes
sanitysql => select count(*) from t_extensions
backslash_is_escape => no

This used to work in 1.6.1.20 but does not work anymore with 1.8.0 beta4.
Trying to start Asterisk i receive.
 
[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 of res_odbc.so and res_config_odbc.so in modules.conf I
receive
 
[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.

====================================================================== 

---------------------------------------------------------------------- 
 (0126321) svnbot (reporter) - 2010-08-25 11:12
 https://issues.asterisk.org/view.php?id=17911#c126321 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 283561

U   branches/1.8/res/res_odbc.c

------------------------------------------------------------------------
r283561 | tilghman | 2010-08-25 11:12:41 -0500 (Wed, 25 Aug 2010) | 5
lines

Initialize connect timeout on each time through the loop.

(closes issue https://issues.asterisk.org/view.php?id=17911)
 Reported by: wurstsalat

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=283561 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-08-25 11:12 svnbot         Checkin                                      
2010-08-25 11:12 svnbot         Note Added: 0126321                          
======================================================================