To Install MariaDB ODBC Connector on Ubuntu 21.04

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 by using the below command

root@linuxhelp:/# lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 21.04
Release:	21.04
Codename:	hirsute

Step 2: Create a directory as “odbc_package” by using the below command

root@linuxhelp:/# mkdir odbc_package

Step 3: Change the created directory by using the below command

root@linuxhelp:/# 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 by using the below command

root@linuxhelp:/odbc_package# tar -xvzf mariadb-connector-odbc-3.1.7-ga-debian-x86_64.tar.gz 
lib/mariadb/plugin/auth_gssapi_client.so
lib/mariadb/plugin/caching_sha2_password.so
lib/mariadb/plugin/client_ed25519.so
lib/mariadb/plugin/dialog.so
lib/mariadb/plugin/mysql_clear_password.so
lib/mariadb/plugin/sha256_password.so
share/doc/mariadb-connector-odbc/COPYING
share/doc/mariadb-connector-odbc/README
lib/libmaodbc.so

Step 6: Install the driver file in following location by using the below command

root@linuxhelp:/odbc_package# sudo install lib/libmaodbc.so /usr/lib

Step 7: Install libraries in the following location by using the below commands

root@linuxhelp:/odbc_package# sudo install -d /usr/lib/mariadb/
root@linuxhelp:/odbc_package# sudo install -d /usr/lib/mariadb/plugin/

Step 8: Install auth_gssapi_client.so library in the following location by using the below command

root@linuxhelp:/odbc_package# sudo install lib/mariadb/plugin/auth_gssapi_client.so /usr/lib/mariadb/plugin/

Step 9: Install caching_sha2_password.so library in the following location by using the below command

root@linuxhelp:/odbc_package# sudo install lib/mariadb/plugin/caching_sha2_password.so /usr/lib/mariadb/plugin/

Step 10: Install client_ed25519.so library in the following location by using the below command

root@linuxhelp:/odbc_package# sudo install lib/mariadb/plugin/client_ed25519.so /usr/lib/mariadb/plugin/

Step 11: Install dialog.so library in the following location by using the below command

root@linuxhelp:/odbc_package# sudo install lib/mariadb/plugin/dialog.so /usr/lib/mariadb/plugin/

Step 12: Install mysql_clear_password.so library in the following location by using the below command

root@linuxhelp:/odbc_package# sudo install lib/mariadb/plugin/mysql_clear_password.so /usr/lib/mariadb/plugin/

Step 13: Install sha256_password.so library in the following location by using the below command

root@linuxhelp:/odbc_package# sudo install lib/mariadb/plugin/sha256_password.so /usr/lib/mariadb/plugin/

Step 14: Update the APT source list by using the below command

root@linuxhelp:/odbc_package# apt-get update 
Hit:1 http://in.archive.ubuntu.com/ubuntu hirsute InRelease
Hit:2 http://in.archive.ubuntu.com/ubuntu hirsute-updates InRelease
Hit:3 http://in.archive.ubuntu.com/ubuntu hirsute-backports InRelease      
Hit:4 http://security.ubuntu.com/ubuntu hirsute-security InRelease         
Reading package lists... Done

Step 15: Install the ODBC Driver Manager by using the below command

root@linuxhelp:/odbc_package# apt-get install unixodbc-dev
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following package was automatically installed and is no longer required:
  libllvm11
Use 'apt autoremove' to remove it.
The following additional packages will be installed:
  autoconf automake autotools-dev libltdl-dev libodbc1 libtool m4 odbcinst odbcinst1debian2
Suggested packages:
  autoconf-archive gnu-standards autoconf-doc gettext libtool-doc libmyodbc odbc-postgresql tdsodbc unixodbc-bin gfortran
  | fortran95-compiler gcj-jdk m4-doc
The following NEW packages will be installed:
  autoconf automake autotools-dev libltdl-dev libodbc1 libtool m4 odbcinst odbcinst1debian2 unixodbc-dev
0 upgraded, 10 newly installed, 0 to remove and 5 not upgraded.
Need to get 1,877 kB of archives.
After this operation, 8,995 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://in.archive.ubuntu.com/ubuntu hirsute/main amd64 m4 amd64 1.4.18-5 [200 kB]
Get:2 http://in.archive.ubuntu.com/ubuntu hirsute/main amd64 autoconf all 2.69-14 [293 kB]
Get:3 http://in.archive.ubuntu.com/ubuntu hirsute/main amd64 autotools-dev all 20180224.1+nmu1 [39.4 kB]
Get:4 http://in.archive.ubuntu.com/ubuntu hirsute/main amd64 automake all 1:1.16.3-2ubuntu1 [552 kB]
Get:5 http://in.archive.ubuntu.com/ubuntu hirsute/main amd64 libltdl-dev amd64 2.4.6-15 [162 kB]
update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode
Setting up libtool (2.4.6-15) ...
Setting up libltdl-dev:amd64 (2.4.6-15) ...
Setting up odbcinst1debian2:amd64 (2.3.6-0.1build1) ...
Setting up unixodbc-dev:amd64 (2.3.6-0.1build1) ...
Setting up odbcinst (2.3.6-0.1build1) ...
Processing triggers for libc-bin (2.33-0ubuntu5) ...
Processing triggers for man-db (2.9.4-2) ...
Processing triggers for install-info (6.7.0.dfsg.2-6) ...

By this, to Install MariaDB ODBC Connector on Ubuntu 21.04 have been completed.