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

Issue when connect DSN oracle DB using Connect Engine

    Details

      Description

      Dear all.
      I facing issue when using connect engine to connect Oracle DB using unixODBC.
      [root@LGEVH_PIS_DB /]# mysql -u root -p -h localhost
      Enter password:
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 28
      Server version: 10.1.28-MariaDB MariaDB Server

      Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [(none)]> connect xe
      Connection id: 29
      Current database: xe

      MariaDB [xe]> create table EMPLOYEE ENGINE=CONNECT TABLE_TYPE=ODBC tabname='EMPLOYEE' CONNECTION='DSN=ORACLE_XE;UID=ojt;PWD=ojt';
      ERROR 1105 (HY000): SQLDriverConnect: [unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1' : file not found
      MariaDB [xe]>

      When using isql . It is OK.
      [root@LGEVH_PIS_DB /]# isql ORACLE_XE ojt ojt;
      ---------------------------------------

      Connected!
       
      sql-statement
      help [tablename]
      quit
       

      ---------------------------------------
      SQL>
      Below is Enviroment CentOS
      XDG_SESSION_ID=1377
      HOSTNAME=LGEVH_PIS_DB.LGEVH
      SELINUX_ROLE_REQUESTED=
      TERM=xterm
      SHELL=/bin/bash
      HISTSIZE=1000
      SSH_CLIENT=10.224.30.163 65526 22
      SELINUX_USE_CURRENT_RANGE=
      OLDPWD=/home/mariadb.lgevh
      SSH_TTY=/dev/pts/1
      USER=root
      LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib/
      LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:.tar=01;31:.tgz=01;31:.arc=01;31:.arj=01;31:.taz=01;31:.lha=01;31:.lz4=01;31:.lzh=01;31:.lzma=01;31:.tlz=01;31:.txz=01;31:.tzo=01;31:.t7z=01;31:.zip=01;31:.z=01;31:.Z=01;31:.dz=01;31:.gz=01;31:.lrz=01;31:.lz=01;31:.lzo=01;31:.xz=01;31:.bz2=01;31:.bz=01;31:.tbz=01;31:.tbz2=01;31:.tz=01;31:.deb=01;31:.rpm=01;31:.jar=01;31:.war=01;31:.ear=01;31:.sar=01;31:.rar=01;31:.alz=01;31:.ace=01;31:.zoo=01;31:.cpio=01;31:.7z=01;31:.rz=01;31:.cab=01;31:.jpg=01;35:.jpeg=01;35:.gif=01;35:.bmp=01;35:.pbm=01;35:.pgm=01;35:.ppm=01;35:.tga=01;35:.xbm=01;35:.xpm=01;35:.tif=01;35:.tiff=01;35:.png=01;35:.svg=01;35:.svgz=01;35:.mng=01;35:.pcx=01;35:.mov=01;35:.mpg=01;35:.mpeg=01;35:.m2v=01;35:.mkv=01;35:.webm=01;35:.ogm=01;35:.mp4=01;35:.m4v=01;35:.mp4v=01;35:.vob=01;35:.qt=01;35:.nuv=01;35:.wmv=01;35:.asf=01;35:.rm=01;35:.rmvb=01;35:.flc=01;35:.avi=01;35:.fli=01;35:.flv=01;35:.gl=01;35:.dl=01;35:.xcf=01;35:.xwd=01;35:.yuv=01;35:.cgm=01;35:.emf=01;35:.axv=01;35:.anx=01;35:.ogv=01;35:.ogx=01;35:.aac=01;36:.au=01;36:.flac=01;36:.mid=01;36:.midi=01;36:.mka=01;36:.mp3=01;36:.mpc=01;36:.ogg=01;36:.ra=01;36:.wav=01;36:.axa=01;36:.oga=01;36:.spx=01;36:*.xspf=01;36:
      CLIENT_HOME=:/usr/lib/oracle/11.2/client64/lib/
      MAIL=/var/spool/mail/root
      PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/usr/lib/oracle/11.2/client64/:/usr/lib/oracle/11.2/client64/lib/
      PWD=/
      LANG=en_US.UTF-8
      SELINUX_LEVEL_REQUESTED=
      HISTCONTROL=ignoredups
      SHLVL=1
      HOME=/root
      LOGNAME=root
      XDG_DATA_DIRS=/root/.local/share/flatpak/exports/share/:/var/lib/flatpak/exports/share/:/usr/local/share/:/usr/share/
      SSH_CONNECTION=10.224.30.163 65526 10.224.30.205 22
      LESSOPEN=||/usr/bin/lesspipe.sh %s
      XDG_RUNTIME_DIR=/run/user/0
      ORACLE_HOME=/usr/lib/oracle/11.2/client64/lib/
      _=/usr/bin/env
      Below is etc/odbc.ini
      [ORACLE_XE]
      DRIVER=/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
      SERVERNAME=10.224.38.45:1521/xe
      OPTION=3
      USER=ojt
      PASSWORD=ojt

      below is etc/odbcinst.ini
      [PostgreSQL]
      Description=ODBC for PostgreSQL
      Driver=/usr/lib/psqlodbcw.so
      Setup=/usr/lib/libodbcpsqlS.so
      Driver64=/usr/lib64/psqlodbcw.so
      Setup64=/usr/lib64/libodbcpsqlS.so
      FileUsage=1
      UsageCount=2

      [MySQL]
      Description=ODBC for MySQL
      Driver=/usr/lib/libmyodbc5.so
      Setup=/usr/lib/libodbcmyS.so
      Driver64=/usr/lib64/libmyodbc5.so
      Setup64=/usr/lib64/libodbcmyS.so
      FileUsage=1
      UsageCount=2

      [Oracle]
      Description=Oracle ODBC Connection
      Driver=/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
      Setup=
      FileUsage=

      dear community,
      Please, help to check may i have mistake in enviroment or odbc config????
      Thank you.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Nguyen Linux DUC MANH NGUYEN
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: