[MDEV-33425] unable to establish ODBC connection from mariadb cli Created: 2024-02-07  Updated: 2024-02-08

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Blocker
Reporter: Prabha Assignee: Lawrin Novitsky
Resolution: Unresolved Votes: 0
Labels: None
Environment:

RHEL 8, MariaDB 10.6

Attachments: PNG File isql_op.png    

 Description   

Hi, I am working on a project requiring us to pull the data from Oracle to MariaDB Galeria Cluster. For this, we have chosen to use a connect storage engine. I have followed the instructions as below

  • Installed two node MariaDB Galera cluster.
  • Install unixODBC
  • Installed connect plugin.
  • Installed oracle client 12.1
  • Configured tnsnames.ora, odbc.ini and odbcinst.ini.

After that, I tested the connection, and it worked fine. However, when I try to create a table in MariaDB cli, it fails with the below error.

ERROR 1105 (HY000): SQLDriverConnect: [unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1' : file not found

I correctly set the env of LD_LIBRARY_PATH, and the permissions of the files look fine as I am trying with the root user.

Can someone please help with this.

Thanks,
Prabha

 Comments   
Comment by Lawrin Novitsky [ 2024-02-07 ]

I've moved to server project, as it is about Connect storage engine, and not MariaDB ODBC Connector.
Is the file with Oracle ODBC driver really in the location, where Connect engine is looking for it? i.e. /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1 ?

Comment by Prabha [ 2024-02-08 ]

Thanks for the reply. Yes, the Oracle driver is there and with the required privileges. Please find the details below.

[root@tprd5mdb04 ~]# env |grep LD_LIBRARY_PATH
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
[root@tprd5mdb04 ~]# ls -l /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1
-rwxr-xr-x 1 root root 4421284 Jul 7 2014 /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1
[root@tprd5mdb04 ~]#

Thanks,
Prabha

Generated at Thu Feb 08 10:38:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.