Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Not a Bug
-
None
-
None
-
RHEL 8, MariaDB 10.6
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
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Key |
|
|
| Issue Type | Task [ 3 ] | Bug [ 1 ] |
| Project | MariaDB Connector/ODBC [ 10400 ] | MariaDB Server [ 10000 ] |
| Component/s | Storage Engine - Connect [ 10128 ] |
| Fix Version/s | N/A [ 14700 ] | |
| Resolution | Not a Bug [ 6 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Reporter | Prabha [ JIRAUSER54905 ] | Prabha [ prabha ] |
| Comment |
[ The issue is fixed, please mark it resolved.
Thanks, Prabha ] |
| Comment |
[ 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 ] |
original comments were lost in jira account merge, but here they are for the record:
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 ~]#
and
The issue is fixed, please mark it resolved.
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 ?