ODBC installation and configuration—Linux
|
Ensure to install a supported version of database server (MySQL or MariaDB) and ODBC Connector. |
|
You can install the Microsoft ODBC driver (version 13 and later) to connect the ESET PROTECT Server on Linux to Microsoft SQL Server on Windows. For more information, visit this Knowledgebase article. |
Install the ODBC driver using the Terminal. Follow the steps for your database server:
•MySQL ODBC Connector—Debian, Ubuntu
•MySQL ODBC Connector—Other supported Linux distributions
|
Your installation experience may vary according to the supported Linux distribution running on your server. |
MySQL ODBC Connector—Debian, Ubuntu
1.Install unixODBC drivers:
sudo apt install unixodbc
2.Download the ODBC connector:
wget <mysql-connector-package>
Replace <mysql-connector-package> with the download link to the package.
|
You can download the MySQL ODBC connector from the official MySQL site. Select and download the version compatible with your Linux distribution and version (earlier versions are also available). |
3.Install the ODBC driver:
•Ubuntu 22.04/24.04, Debian 11/12—See Installing Connector/ODBC from a DEB Distribution. Run the following command to install a .deb package on Ubuntu: sudo dpkg -i package_file.deb
•Debian 10 and Ubuntu 20.04—See Installing Connector/ODBC from a Binary Tarball Distribution.
Example of tar.gz driver installation steps:
Run the following command to list the installed drivers:
sudo myodbc-installer -d -l
MySQL ODBC Connector—Red Hat
1.Install unixODBC drivers:
sudo dnf install unixODBC -y
2.Download the ODBC connector:
wget <mysql-connector-package>
Replace <mysql-connector-package> with the download link to the package.
|
You can download the MySQL ODBC connector from the official MySQL site. Select and download the version compatible with your Linux distribution and version (earlier versions are also available). |
3.Install the ODBC driver:
|
Do not install the ODBC connector using YUM/DNF—it would install the latest, not compatible version. |
sudo rpm -ivh mysql-connector-odbc-9.3.0-1.el10.x86_64.rpm --nodeps
4.Set up the ODBC driver:
sudo myodbc-installer -a -d -n "MySQL ODBC 9.3.0" -t "Driver=/usr/lib64/libmyodbc9w.so"
5.List the installed drivers:
sudo myodbc-installer -d -l
MySQL ODBC Connector—Other supported Linux distributions
1.Follow these instructions to install the ODBC driver:
•SUSE Linux Enterprise Server: sudo zypper install unixODBC.
•Installing Connector/ODBC from an RPM Distribution
•Installing Connector/ODBC from a DEB Distribution
•Installing Connector/ODBC from a Binary Tarball Distribution
2.Run the following command to open the odbcinst.ini file in a text editor:
sudo nano /etc/odbcinst.ini
or sudo nano /etc/unixODBC/odbcinst.ini
3.Copy the following configuration into the odbcinst.ini file (ensure the paths to Driver and Setup are correct), then save and close the file:
[MySQL] |
The driver may be in a different location for some distributions. You can find the file using the following command:
sudo find /usr -iname "*libmyodbc*"
4.Update the configuration files that control ODBC access to database servers on the current host by running the following command:
sudo odbcinst -i -d -f /etc/odbcinst.ini
or sudo odbcinst -i -d -f /etc/unixODBC/odbcinst.ini
MariaDB ODBC Connector
1.Download the supported MariaDB ODBC Connector for your supported Linux distribution from the official MariaDB site.
2.Install the MariaDB ODBC Connector. See also Quickstart Guide: MariaDB Connector/ODBC.
|
Your installation experience may vary according to the supported Linux distribution running on your server. |