ODBC installation and configuration—Linux
|
Ensure to install a supported version of MySQL Server 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 MySQL ODBC driver using the Terminal. Follow the steps for your Linux distribution:
•Other supported Linux distributions
|
Your installation experience may vary according to the supported Linux distribution running on your server. |
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
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
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
|
The ESET PROTECT Server Rocky Linux installation with mariadb-connector-odbc driver fails with specific locales—Chinese, Korean, Japanese. |
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