[asterisk-bugs] [Asterisk 0017174]: Connection Problem with UnixODBC 2.1.14

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17174 
====================================================================== 
Reported By:                davidsharon
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17174
Category:                   Addons/General
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
Asterisk Version:           1.6.1.18 
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-04-13 03:16 CDT
Last Modified:              2010-05-05 04:08 CDT
====================================================================== 
Summary:                    Connection Problem with UnixODBC 2.1.14
Description: 

I upgraded UnixODBC version to 2.2.14. 

After installation and configuration, I tried iSql (the new release) for
Oracle 11g. It works without any problem: it can connect and execute SQL
commands.

On Asterisk side, in func_odbc.conf, 

[BLACKLIST]
dsn=oracle
; oracle is defined in odbc.ini as dsn. it works with isql. 
readsql = SELECT count(*) as Say FROM Blacklist where CallerId =
'${SQL_ESC(${ARG1})}'; 

In extensions.conf, we have a voicemenu scenario:

...
[voicemenu-custom-7661]
include = default
exten = s,1,NoOp(IVR_BlackList)
exten = s,2,Answer()
exten = s,3,Set(ARG1=${CALLERID(name)})
exten = s,4,Set(Result=${ODBC_BLACKLIST(${ARG1})})
exten = s,5,GotoIf(${Result}=1?0:)
exten = s,6,Playback(dir-welcome)
exten = s,7,Goto(queues,6500,1)   
...

When this context is executed, res_odbc raises an exception and Asterisk
is stopped.

After checking out the log files and the source code, I realized that we
might have a library-related problem.

Could you please check this case and advise us how to fix it?

Thank you in advance,

David

P.S. Upgrading our Asterisk to 1.6.18 didn't solve this issue.
====================================================================== 

---------------------------------------------------------------------- 
 (0121400) davidsharon (reporter) - 2010-05-05 04:08
 https://issues.asterisk.org/view.php?id=17174#c121400 
---------------------------------------------------------------------- 
in res_odbc.conf,

[test]
enabled => yes
dsn => test
username => asterisk
password => *****
pre-connect => no   

when I set pre-connect => yes and reload (at CLI), I have the following
error:

[2010-05-05 18:02:35.404] NOTICE[10504]: res_odbc.c:838 odbc_obj_connect:
Connecting test
asterisk: symbol lookup error:
/opt/oracle/product/11.2.0/dbhome_1/odbc/libsqora.so.11.1: undefined
symbol: SQLGetPrivateProfileStringW 

When i check iSQL, it is working. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-05-05 04:08 davidsharon    Note Added: 0121400                          
2010-05-05 04:08 davidsharon    Status                   closed => new       
2010-05-05 04:08 davidsharon    Resolution               won't fix => reopened
======================================================================