NÃO CONSIGO CONECTAR AO INFORMIX NO LINUX - [01000][UNIXODBC][DRIVER MANAGER]CAN'T OPEN LIB '/OPT/

VitorS7
(usa Ubuntu)

Enviado em 06/07/2023 - 10:20h

Mensagem de erro:
[01000][unixODBC][Driver Manager]Can't open lib '/opt/IBM/Informix_Client-SDK/lib/cli/iclis09b.so' : file not found [ISQL]ERROR: Could not SQLConnect

Durante configuração, vi que era preciso também configurar um arquivo de nome onconfig, que não tinha na pasta do Informix.

Help! Please.

Segue a configuração dos arquivos

[b] ODBC.INI [b]

;---------------------------------------------------------------------------
; IBM Informix Informix ODBC Sample File
;
; File: odbc.ini
;
;---------------------------------------------------------------------------
[ODBC Data Sources]
Infdrv1=IBM Informix Informix ODBC DRIVER
Infdrv2=IBM Informix Informix ODBC DRIVER
;
; Define ODBC Database Driver's Below - Driver Configuration Section
;
[Infdrv1]
Driver=/opt/IBM/Informix_Client-SDK/lib/cli/iclit09b.so
Description=IBM Informix Informix ODBC DRIVER
Database=teste
LogonID=teste
pwd=teste
Servername=192.168.19.5
Port=54567
[Infdrv2]
Driver=/opt/IBM/Informix_Client-SDK/lib/cli/iclis09b.so
Description=IBM Informix Informix ODBC DRIVER
Database=teste
LogonID=teste
pwd=teste
Servername=192.168.19.5
Port=50003
CursorBehavior=0
CLIENT_LOCALE=en_US.CP1252
DB_LOCALE=en_US.819
TRANSLATIONDLL=/opt/IBM/Informix_Client-SDK/lib/esql/igo4a304.so
;
; UNICODE connection Section
;
[ODBC]
;uncomment the below line for UNICODE connection
;UNICODE=UCS-4
;
; Trace file Section
;
Trace=0
TraceFile=/tmp/odbctrace.out
InstallDir=/opt/IBM/Informix_Client-SDK/
TRACEDLL=idmrs09a.so


[b] ODBCINST [b]

;---------------------------------------------------------------------------
; IBM Informix Informix ODBC Sample File
;
; File: odbcinst.ini
;
;---------------------------------------------------------------------------
[ODBC Drivers]
IBM Informix Informix ODBC DRIVER=Installed
[IBM Informix Informix ODBC DRIVER]
Driver=/opt/IBM/Informix_Client-SDK/lib/cli/iclit09b.so
Setup=/opt/IBM/Informix_Client-SDK/lib/cli/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y

[b] SQLHOSTS [b]

#**************************************************************************
#
# Licensed Material - Property of IBM Corporation
#
# "Restricted Materials of IBM Corporation"
#
# IBM Informix Dynamic Server
# Copyright IBM Corporation 2012, 2013
#
# Title: sqlhosts.cmsm.sample.all
# Description:
# sample sqlhosts file for Connection Manager.
#
#**************************************************************************

# INFORMIXSERVER
g_west group - - i=110,e=west3
west1 onsoctcp hostw1 9810 g=g_west
west2 onsoctcp hostw2 9820 g=g_west
west3 onsoctcp hostw3 9830 g=g_west
teste olsoctcp 192.168.19.2 50003 g=g_west
Infdrv2 olsoctcp 192.168.19.2 50003 g=g_west
g_north group - - i=120,e=north1
north1 onsoctcp hostn1 9860 g=g_north

g_south group - - i=210,e=south3
south1 onsoctcp hosts1 9810 g=g_south
south2 onsoctcp hosts2 9820 g=g_south
south3 onsoctcp hosts3 9830 g=g_south

g_east group - - i=220,e=east1
east1 onsoctcp hoste1 9860 g=g_east

# CM SLAs
oltp_w onsoctcp hostcm 9910
report_w onsoctcp hostcm 9911
oltpdr_w drsoctcp hostcm 9912
report_rr_w onsoctcp hostcm 9913
current_rss_w onsoctcp hostcm 9914
current_rss_rr_w onsoctcp hostcm 9915

oltp_s onsoctcp hostcm 9920
report_s onsoctcp hostcm 9921
oltpdr_s drsoctcp hostcm 9922

repl1_any onsoctcp hostcm 9931
repl1_ns onsoctcp hostcm 9932
repl1_ns_rr onsoctcp hostcm 9933
repl1_ew onsoctcp hostcm 9934

grid1_any onsoctcp hostcm 9940
grid1_avail onsoctcp hostcm 9941

ss_any onsoctcp hostcm 9950
ss_avail onsoctcp hostcm 9951


[b] /root/.BASHRC [b]

#Incluindo variáveis ​​de ambiente
INFORMIXDIR=/opt/IBM/Informix_Client-SDK
export INFORMIXDIR
INFORMIXSQLHOSTS=/opt/IBM/Informix_Client-SDK/etc/sqlhosts
export INFORMIXSQLHOSTS
INFORMIXSERVER=ol_conect
export INFORMIXSERVER
ODBCINI=/opt/IBM/Informix_Client-SDK/etc/odbc.ini
export ODBCINI
ONCONFIG=onconfig_logix
export ONCONFIG
CLIENT_LOCALE=en_US.CP1252
export CLIENT_LOCALE
DB_LOCALE=en_US.819
export DB_LOCALE
LD_LIBRARY_PATH=/opt/IBM/Informix_Client-SDK/lib:/opt/IBM/Informix_Client-SDK/lib/esql:/opt/IBM/Informix_Client-SDK/lib/cli: /opt/IBM/Informix_Client-SDK/lib/c++:/opt/IBM/Informix_Client-SDK/lib/client:/opt/IBM/Informix_Client-SDK/lib/dmi
export LD_LIBRARY_PATH

leandropscardua
(usa Ubuntu)

Enviado em 06/07/2023 - 14:55h

Qual a sua distribuição? Nas baseadas em debian vc pode saber de qual pacote um arquivo faz parte rodando apt-file -s iclis09b.so. descobrindo o nome do pacote vc instala ele. O apt- file normalmente nao vem instalado por padrao

VitorS7
(usa Ubuntu)

Enviado em 19/07/2023 - 11:44h

Usando no momento versão Mint do Linux