Last Modified Date: 08 Jul 2022
Environment
- Tableau Server
- MariaDB
- Linux
Answer
The following steps are for RHEL/CentOS. If you are using Debian/Ubuntu, just replace the command and the packages for Debian/Ubuntu.1. Install pre-packages. Skip this step if you already have the following packages installed. (In Debian/Ubuntu, please replace "yum" command to "apt-get".)
sudo yum install unixODBC
sudo yum install unixODBC-devel
2. Follow the steps below in "Installing MariaDB Connector/ODBC on Linux" page.
About MariaDB Connector/ODBC
Please pay attention to the actual file directories. it may be different for different versions.
This is an example of the commands you should run when installing "mariadb-connector-odbc-3.1.11-centos7-amd64" for CentOS 7 64-bit.
Download links for different OSs could be found on the following page. Please choose the ODBC connector and OS you are using.
Mariadb Connectors
=====================
mkdir odbc_package
cd odbc_package
wget https://dlm.mariadb.com/1489950/Connectors/odbc/connector-odbc-3.1.11/mariadb-connector-odbc-3.1.11-centos7-amd64.tar.gz
tar -xvzf mariadb-connector-odbc-3.1.11-centos7-amd64.tar.gz
cd mariadb-connector-odbc-3.1.11-centos7-amd64
sudo install lib64/mariadb/libmaodbc.so /usr/lib/
sudo install -d /usr/lib/mariadb/
sudo install -d /usr/lib/mariadb/plugin/
sudo install lib64/mariadb/plugin/auth_gssapi_client.so /usr/lib/mariadb/plugin/
sudo install lib64/mariadb/plugin/caching_sha2_password.so /usr/lib/mariadb/plugin/
sudo install lib64/mariadb/plugin/client_ed25519.so /usr/lib/mariadb/plugin/
sudo install lib64/mariadb/plugin/dialog.so /usr/lib/mariadb/plugin/
sudo install lib64/mariadb/plugin/mysql_clear_password.so /usr/lib/mariadb/plugin/
sudo install lib64/mariadb/plugin/sha256_password.so /usr/lib/mariadb/plugin/
=====================
3. Edit OBDC connection files
Please add the following 3 lines to the end of /etc/odbcinst.ini.
[MariaDB ODBC 3.1 Driver]
Description = MariaDB Connector/ODBC v.3.1
Driver = /usr/lib/libmaodbc.so
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials