How To Install MariaDB ODBC Connector on Debian 11.3

To Install MariaDB ODBC Connector On Debian 11.3

Introduction:

MariaDB ODBC is a driver for connecting databases to object-oriented and object-based programming languages. The MariaDB ODBC driver supports both ANSI and Unicode modes. There are many enterprise-level features in this product, and it has very high performance. On Windows and Unix platforms, we can connect to databases such as MariaDB.

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:	Debian
Description:	Debian GNU/Linux 11 (bullseye)
Release:	11
Codename:	bullseye

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 command

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-08-22 00:36:34--  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.18.135.24, 104.17.191.14, 2606:4700::6812:8718, ...
Connecting to downloads.mariadb.com (downloads.mariadb.com)|104.18.135.24|: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 100%[==========================>]   1020K  2.17MB/s    in 0.5s    

2022-08-22 00:36:35 (2.17 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 https://download.docker.com/linux/debian bullseye InRelease
Hit:2 http://deb.debian.org/debian bullseye InRelease       
Hit:3 http://deb.debian.org/debian bullseye-updates InRelease
Hit:4 http://security.debian.org/debian-security bullseye-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 additional packages will be installed:
  autoconf automake autotools-dev libltdl-dev libodbc1 libtool m4 odbcinst odbcinst1debian2
Suggested packages:
  autoconf-archive gnu-standards autoconf-doc 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 2 not upgraded.
Need to get 2,697 kB of archives.
After this operation, 9,362 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://deb.debian.org/debian bullseye/main amd64 m4 amd64 1.4.18-5 [204 kB]
Get:2 http://deb.debian.org/debian bullseye/main amd64 autoconf all 2.69-14 [313 kB]
Get:3 http://deb.debian.org/debian bullseye/main amd64 autotools-dev all 20180224.1+nmu1 [77.1 kB]
Get:4 http://deb.debian.org/debian bullseye/main amd64 automake all 1:1.16.3-2 [814 kB]
Get:5 http://deb.debian.org/debian bullseye/main amd64 libltdl-dev amd64 2.4.6-15 [162 kB]
Get:6 http://deb.debian.org/debian bullseye/main amd64 libodbc1 amd64 2.3.6-0.1+b1 [224 kB]
Get:7 http://deb.debian.org/debian bullseye/main amd64 libtool all 2.4.6-15 [513 kB]
Get:8 http://deb.debian.org/debian bullseye/main amd64 odbcinst1debian2 amd64 2.3.6-0.1+b1 [78.6 kB]
Get:9 http://deb.debian.org/debian bullseye/main amd64 odbcinst amd64 2.3.6-0.1+b1 [48.7 kB]
Get:10 http://deb.debian.org/debian bullseye/main amd64 unixodbc-dev amd64 2.3.6-0.1+b1 [262 kB]
Fetched 2,697 kB in 1s (3,306 kB/s)     
Selecting previously unselected package odbcinst.
Preparing to 
Processing triggers for man-db (2.9.4-2) ...

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 Debian 11.3.Your feedback is much welcome.