Issue
The installation fails to connect the MySQL database with ODBC connector.
Solution
- Open a Terminal and follow the steps a-h to install MySQL Server
- Download the Repository package:
wget http://dev.mysql.com/get/mysql-community-release-sles11-7.noarch.rpm
- Install the downloaded release package:
sudo rpm -Uvh mysql-community-release-sles11-7.noarch.rpm
- Import the GnuPG key:
sudo rpm --import /etc/RPM-GPG-KEY-mysql
- Refresh the repository information:
sudo zypper refresh
- Install the MySQL Server by the following command:
sudo zypper install mysql-community-server
- Start the MySQL Server:
sudo /etc/init.d/mysql start
- You can check if the MySQL is running:
sudo /etc/init.d/mysql status
- Perform the
mysql_secure_installation
that will allow you to set basic settings. You will need to know the password you set now in later steps.mysql_secure_installation
For additional help with MySQL installation
This step was informed by official MySQL documentation. Visit the MySQL developer site for additional information.
- Download the Repository package:
- Configure the MySQL Server.
- Save and close the file, and then enter the following command to restart MySQL server and apply the configuration:
sudo /etc/init.d/mysql restart
- Install additional ESMC Server prerequisites:
sudo zypper install xorg-x11-server-extra libqtwebkit4 cifs-utils java-1_7_1-ibm tomcat6 samba-winbind openldap2-client net-snmp krb5-client unixODBC_23
- Download the Generic Linux x86_64 ODBC Connector driver using the command
wget
.Warning:
MySQL database is supported up to version 5.7 and ODBC driver up to version 5.3. Upgrading to a higher version (v8+) of MySQL and ODBC driver is not recommended.
Use the official MySQL Download
You can download the package (ODBC 5.3) from the MySQL Download site. Check for the package name before using the command.
- Install the downloaded driver. Run this command from the directory where you have downloaded the ODBC package:
sudo rpm -Uvh mysql-connector-odbc-5.3.6-1.x86_64.rpm
- Check the
odbcinst_23.ini
file for the configuration:cat /etc/unixODBC_23/odbcinst_23.ini
The output should contain names of available drivers. For example:[MySQL ODBC 5.3 Unicode Driver]
- Check your odbcinst_23 version:
odbcinst_23 --version
If the version is earlier than 2.3.0 append the following line into yourodbcinst_23.ini
file:Threading = 0
- Update the configuration files that control ODBC access by the following command:
sudo odbcinst_23 -i -d -f /etc/unixODBC_23/odbcinst_23.ini
- Download the ESMC Server install file (you can download it from the ESET Download page). For example:
wget http://download.eset.com/download/ra/v6/standalone-installers/server/Server-Linux-x86_64.sh
- Make the ESMC Server install file executable:
chmod +x Server-Linux-x86_64.sh
- Run the installation command on your ESMC Server install file.
MySQL password:
The parameter
--db-admin-password
is the password you set during the manual installation of MySQL withmysql_secure_installation
command. - After the installation has successfully finished, check that the ESMC Server is running:
sudo /etc/init.d/eraserver status
KB Solution ID: KB6879 |Document ID: 25869|Last Revised: August 16, 2018
Reactie toevoegen
Log in of registreer om een reactie te plaatsen.