KNOWLEDGE BASE

How To Install Maria DB Driver On Linux Tableau Server?


Published: 01 Feb 2021
Last Modified Date: 02 Feb 2021

Question

How to install Maria DB driver on Linux Tableau Server?

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

 
Did this article resolve the issue?