How to Install MariaDB ODBC Connector on Ubuntu 21.04
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.