How to install MariaDB ODBC Connector on Rocky linux 8.6

To Install MariaDB ODBC Connector On Rocky Linux 8.6

Introduction:

ODBC drivers allow applications to access data in database management systems (DBMS) using SQL as the standard for data access. ODBC (Open Database Connectivity) is an industry-standard interface for connecting to databases. MariaDB Connector/ODBC uses it.

Installation Procedure:

Step 1: Check the OS version

[root@linuxhelp ~]# cat /etc/os-release 
NAME="Rocky Linux"
VERSION="8.6 (Green Obsidian)"
ID="rocky"
ID_LIKE="rhel centos fedora"
VERSION_ID="8.6"
PLATFORM_ID="platform:el8"
PRETTY_NAME="Rocky Linux 8.6 (Green Obsidian)"
ANSI_COLOR="0;32"
CPE_NAME="cpe:/o:rocky:rocky:8:GA"
HOME_URL="https://rockylinux.org/"
BUG_REPORT_URL="https://bugs.rockylinux.org/"
ROCKY_SUPPORT_PRODUCT="Rocky Linux"
ROCKY_SUPPORT_PRODUCT_VERSION="8"
REDHAT_SUPPORT_PRODUCT="Rocky Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="8"

Step 2: Create a directory as “odbc_package”

[root@linuxhelp ~]# mkdir odbc_package

Step 3: Change the created directory

[root@linuxhelp odbc_package]#cd odbc_package/

Step 4: Download the Package files by using the below link

[root@linuxhelp odbc_package]#wget https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.7/mariadb-connector-odbc-3.1.7-ga-debian-x86_64.tar.gz

--2022-02-15 04:18:43--  https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.7/mariadb-connector-odbc-3.1.7-ga-debian-x86_64.tar.gz
Resolving downloads.mariadb.com (downloads.mariadb.com)... 104.17.191.14, 104.18.135.24, 2606:4700::6812:8718, ...
Connecting to downloads.mariadb.com (downloads.mariadb.com)|104.17.191.14|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1044297 (1020K) [application/octet-stream]
Saving to: ‘mariadb-connector-odbc-3.1.7-ga-debian-x86_64.tar.gz’

mariadb-connector-odbc-3.1.7-g 100%[===================================================>]   1020K  5.27MB/s    in 0.2s    

2022-02-15 04:18:44 (5.27 MB/s) - ‘mariadb-connector-odbc-3.1.7-ga-debian-x86_64.tar.gz’ saved [1044297/1044297]

Step 5: Extract the files

[root@linuxhelp odbc_package]# tar -xvzf mariadb-connector-odbc-3.1.7-ga-debian-x86_64.tar.gz 

Step 6: Install the driver file in following location

[root@linuxhelp odbc_package]#install lib/libmaodbc.so /usr/lib

Step 7: Install libraries in the following location

[root@linuxhelp odbc_package]#install -d /usr/lib/mariadb/
[root@linuxhelp odbc_package]# install -d /usr/lib/mariadb/plugin/

Step 8: Install auth_gssapi_client.so library in the following location

[root@linuxhelp odbc_package]# install lib/mariadb/plugin/auth_gssapi_client.so /usr/lib/mariadb/plugin/

Step 9: Install caching_sha2_password.so library in the following location

[root@linuxhelp odbc_package]# install lib/mariadb/plugin/caching_sha2_password.so /usr/lib/mariadb/plugin/

Step 10: Install client_ed25519.so library in the following location

[root@linuxhelp odbc_package]# install lib/mariadb/plugin/client_ed25519.so /usr/lib/mariadb/plugin/

Step 11: Install dialog.so library in the following location

[root@linuxhelp odbc_package]# install lib/mariadb/plugin/dialog.so /usr/lib/mariadb/plugin/

Step 12: Install mysql_clear_password.so library in the following location

[root@linuxhelp odbc_package]# install lib/mariadb/plugin/mysql_clear_password.so /usr/lib/mariadb/plugin/

Step 13: Install sha256_password.so library in the following location

[root@linuxhelp odbc_package]# install lib/mariadb/plugin/sha256_password.so /usr/lib/mariadb/plugin/

Step 14: Update the yum source list

[root@linuxhelp odbc_package]# yum upadte

Step 15: Install the ODBC Driver Manager

[root@linuxhelp odbc_package]# yum install unixODBC-devel
Last metadata expiration check: 0:13:08 ago on Mon 05 Sep 2022 03:29:38 PM EDT.
Dependencies resolved.
=======================================================================================
 Package                 Architecture    Version              Repository          Size
=======================================================================================
Installing:
 unixODBC-devel          x86_64          2.3.7-1.el8          appstream           63 k
Installing dependencies:
 unixODBC                x86_64          2.3.7-1.el8          appstream          453 k

Transaction Summary
=======================================================================================
Install  2 Packages

Total download size: 516 k
Installed size: 1.5 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): unixODBC-devel-2.3.7-1.el8.x86_64.rpm           270 kB/s |  63 kB     00:00    
(2/2): unixODBC-2.3.7-1.el8.x86_64.rpm                 1.1 MB/s | 453 kB     00:00    
---------------------------------------------------------------------------------------
Total                                                  415 kB/s | 516 kB     00:01     
Running transaction check
Waiting for process with pid 40718 to finish.
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                               1/1 
  Installing       : unixODBC-2.3.7-1.el8.x86_64                                   1/2 
  Running scriptlet: unixODBC-2.3.7-1.el8.x86_64                                   1/2 
  Installing       : unixODBC-devel-2.3.7-1.el8.x86_64                             2/2 
  Running scriptlet: unixODBC-devel-2.3.7-1.el8.x86_64                             2/2 
  Verifying        : unixODBC-2.3.7-1.el8.x86_64                                   1/2 
  Verifying        : unixODBC-devel-2.3.7-1.el8.x86_64                             2/2 

Installed:
  unixODBC-2.3.7-1.el8.x86_64             unixODBC-devel-2.3.7-1.el8.x86_64            

Complete!

Step 16 : view the odbc version and odcb.ini file location

[root@linuxhelp odbc_package]# odbcinst -j
unixODBC 2.3.7
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

Conclusion:

We have reached the end of this article. In this guide, we have walked you through the steps required to Install MariaDB ODBC Connector on Rocky Linux 8.6. Your feedback is much welcome.