[asterisk-users] res_odbc with informix

[Justin Killen]

I figured it out - it was nothing to do with Informix or unixodbc, but rather with func_odbc.conf and res_odbc.conf.  In res_odbc.conf, I had the section titled 'asterisk' and dsn=asterisk-connector.  In func_odbc.conf, I had dsn=asterisk-connector, but that isn't right - func_odbc.conf's dsn doesn't point to a unixodbc dsn, but rather to a section in res_odbc.conf, so I changed func_odbc.conf from 'asterisk-connector' to 'asterisk' and everything started working as expected.

________________________________
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Justin Killen
Sent: Monday, August 22, 2011 10:17 AM
To: asterisk-users at lists.digium.com
Subject: [asterisk-users] res_odbc with informix

Hi, all.

I am attempting to get res_odbc working with Informix (server version 11.10.UC1 on an AIX 5.3 box, Informix csdk (client) version: 3.70.UC3DE on a CentOS 6.0 box).  I am able to successfully connect and run a query via isql, but if I attempt that same query via the dialplan, I get this error:

[Aug 22 09:24:22] ERROR[19020]: func_odbc.c:532 acf_odbc_read: Unable to execute query [SELECT comp_name FROM comp_descr where comp_num = 37]

I've enabled unixODBC logging, and I get output during the res_odbc module load, but when the dialplan executes there are no entries generated.  I'm running asterisk via 'asterisk -cvvv', and I'm loading res_odbc manually so that I can see the output when the module is loaded - here is the console output for reference:

*CLI> module load res_odbc
  == Parsing '/etc/asterisk/res_odbc.conf':   == Found
[Aug 22 10:15:43] NOTICE[19355]: res_odbc.c:774 load_odbc_config: Adding ENV var: INFORMIXSERVER=borgnet
[Aug 22 10:15:43] NOTICE[19355]: res_odbc.c:774 load_odbc_config: Adding ENV var: INFORMIXDIR=/opt/IBM/informix
[Aug 22 10:15:43] NOTICE[19355]: res_odbc.c:774 load_odbc_config: Adding ENV var: ODBCINI=/etc/odbc.ini
[Aug 22 10:15:43] NOTICE[19355]: res_odbc.c:1479 odbc_obj_connect: Connecting asterisk
[Aug 22 10:15:43] NOTICE[19355]: res_odbc.c:1509 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Aug 22 10:15:43] NOTICE[19355]: res_odbc.c:901 load_odbc_config: Registered ODBC class 'asterisk' dsn->[asterisk-connector]
  == Registered application 'ODBC_Commit'
  == Registered application 'ODBC_Rollback'
  == Registered custom function 'ODBC'
[Aug 22 10:15:43] NOTICE[19355]: res_odbc.c:1837 load_module: res_odbc loaded.
 Loaded res_odbc.so => (ODBC resource)
Loaded res_odbc
*CLI> module load func_odbc
  == Registered custom function 'ODBC_FETCH'
  == Registered application 'ODBCFinish'
  == Parsing '/etc/asterisk/func_odbc.conf':   == Found
  == Registered custom function 'AAA_COMPNAME'
  == Registered custom function 'SQL_ESC'
 Loaded func_odbc.so => (ODBC lookups)
Loaded func_odbc



Following are some configs:

extension.conf (swift is the app for Cepstral):
[AAA_37]
exten => s,1,Answer
exten => s,n,Set(TIMEOUT(digit)=5)
exten => s,n,Set(TIMEOUT(response)=10)
exten => s,n,Set(COMPNAME=${AAA_COMPNAME(37)})
exten => s,n,Swift(No schedule information available for ${COMPNAME})
exten => s,n,Playback(AAA/5_sec_delay)


and from func_odbc.conf:
[COMPNAME]
dsn=INFORMIX
readsql=SELECT comp_name FROM comp_descr where comp_num = ${ARG1}
prefix=AAA


/etc/odbcinst.ini:
[INFORMIX]
Driver=/opt/IBM/informix/lib/cli/iclit09b.so
Setup=/opt/IBM/informix/lib/cli/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y


/etc/odbc.ini:
[ODBC Data Sources]
asterisk-connector=INFORMIX

[asterisk-connector]
Driver=INFORMIX
Description=INFORMIX connection to asterisk database on borg
Database=rmca_test
Server=borgnet
LogonID=<name>
pwd=<password>
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/opt/IBM/informix/lib/esql/igo4a304.so
;
[ODBC]
Trace=1
TraceFile=/tmp/odbctrace.out
InstallDir=/opt/IBM/informix/lib/cli
TRACEDLL=idmrs09a.so




Thanks in advance for the help,
-Justin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110822/073bfa3c/attachment.htm>