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

          Dear all
          Anyone can help me guide this issue?
          Thanks

          Nguyen Linux DUC MANH NGUYEN added a comment - Dear all Anyone can help me guide this issue? Thanks

          Dear community
          Someone can help me check this case?
          Thanks

          Nguyen Linux DUC MANH NGUYEN added a comment - Dear community Someone can help me check this case? Thanks

          Nguyen Linux,

          You have filed a bug report in the MariaDB bug tracker.
          At the first glance, I don't see anything here that would indicate a bug in MariaDB. If you have a good reason to believe that you have encountered a bug in MariaDB, please indicate it and explain why you think so.
          Otherwise, the bug tracker is not a proper resource for requesting help or advice. Please send your request to appropriate mailing lists or forums instead. If you feel like you need professional assistance at configuring your instance, you can also consider getting a support contract or remote DBA subscription.

          We will have somebody take another look at the reported problem, just to make sure that nothing needs to be done on MariaDB side, but it will happen according to our internal priorities and scheduling, repeating pings won't help and won't speed it up.

          elenst Elena Stepanova added a comment - Nguyen Linux , You have filed a bug report in the MariaDB bug tracker. At the first glance, I don't see anything here that would indicate a bug in MariaDB. If you have a good reason to believe that you have encountered a bug in MariaDB , please indicate it and explain why you think so. Otherwise, the bug tracker is not a proper resource for requesting help or advice. Please send your request to appropriate mailing lists or forums instead. If you feel like you need professional assistance at configuring your instance, you can also consider getting a support contract or remote DBA subscription . We will have somebody take another look at the reported problem, just to make sure that nothing needs to be done on MariaDB side, but it will happen according to our internal priorities and scheduling, repeating pings won't help and won't speed it up.

          Hi Enela
          It is not a bug.
          Sorry but i can not change it.Please, help to change.
          Otherwise, please, help to check this case. Is that usual case, right?
          Thanks

          Nguyen Linux DUC MANH NGUYEN added a comment - Hi Enela It is not a bug. Sorry but i can not change it.Please, help to change. Otherwise, please, help to check this case. Is that usual case, right? Thanks

          People

            Unassigned Unassigned
            Nguyen Linux DUC MANH NGUYEN
            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.