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 ] |