ODBC installation and configuration
|
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
Debian, Ubuntu
1.Install unixODBC drivers:
sudo apt-get install unixodbc
2.Download the ODBC connector:
Ubuntu 16 |
wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-linux-ubuntu16.04-x86-64bit.tar.gz |
Ubuntu 18 |
wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-linux-ubuntu18.04-x86-64bit.tar.gz |
Ubuntu 20 |
wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-linux-ubuntu19.04-x86-64bit.tar.gz |
Debian 10 |
wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-linux-debian10-x86-64bit.tar.gz |
|
•Select and download the version compatible with your Linux distribution and version. •You can download the ODBC connector for MySQL from the official MySQL site. |
3.Unzip the ODBC driver archive (package name changes depending on link used):
gunzip mysql-connector-odbc-8.0.17-linux-ubuntu19.04-x86-64bit.tar.gz
4.Extract the ODBC driver (package name changes depending on link used):
tar xvf mysql-connector-odbc-8.0.17-linux-ubuntu19.04-x86-64bit.tar
5.Navigate to the ODBC driver folder (package name changes depending on link used):
cd mysql-connector-odbc-8.0.17-linux-ubuntu19.04-x86-64bit
6.Copy ODBC driver files:
sudo cp bin/* /usr/local/bin
sudo cp lib/* /usr/local/lib
7.Register the driver for ODBC.
•For new Linux versions like Ubuntu 20.x, we recommend using the Unicode driver:
sudo myodbc-installer -a -d -n "MySQL ODBC 8.0 Driver" -t "Driver=/usr/local/lib/libmyodbc8w.so"
•For other systems, or when Unicode driver is not working, use this command:
sudo myodbc-installer -a -d -n "MySQL ODBC 8.0" -t "Driver=/usr/local/lib/libmyodbc8a.so"
8.List the installed drivers:
sudo myodbc-installer -d -l
For more information, see https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-unix-tarball.html.
CentOS 7
1.Install unixODBC drivers:
sudo yum install unixODBC -y
2.Download the ODBC connector:
wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-1.el7.x86_64.rpm
|
•Do not install the ODBC connector using YUM - it would install the latest, not compatible version. •Select and download the version compatible with your Linux distribution and version. •You can download the ODBC connector for MySQL from the official MySQL site. |
3.Install the ODBC driver:
sudo rpm -ivh mysql-connector-odbc-8.0.17-1.e17.x86_64.rpm --nodeps
4.Set up the ODBC driver:
sudo myodbc-installer -a -d -n "MySQL ODBC 8.0.17" -t "Driver=/usr/lib64/libmyodbc8w.so"
5.List the installed drivers:
sudo myodbc-installer -d -l
Other supported Linux distributions
|
•Select and download the version compatible with your Linux distribution and version. •You can download the ODBC connector for MySQL from the official MySQL site. |
1.Follow these instructions to install the ODBC driver:
•SUSE Linux Enterprise Server: sudo zypper install unixODBC. See also https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-unix-rpm.html
•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