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.