Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33425

unable to establish ODBC connection from mariadb cli

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Not a Bug
    • None
    • N/A
    • Storage Engine - Connect
    • 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

          Ascending order - Click to sort in descending order
          Lawrin Lawrin Novitsky added a comment -

          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 ?

          Lawrin Lawrin Novitsky added a comment - 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 ?
          serg Sergei Golubchik added a comment -

          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.

          serg Sergei Golubchik added a comment - 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.

          People

            Lawrin Lawrin Novitsky
            prabha Prabha
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.