Issue

The installation fails to connect the MySQL database with ODBC connector.

Solution

1. Open a Terminal and follow the steps a-h to install MySQL Server
   1. Download the Repository package:
      
      wget http://dev.mysql.com/get/mysql-community-release-sles11-7.noarch.rpm
       
   2. Install the downloaded release package:
      
      sudo rpm -Uvh mysql-community-release-sles11-7.noarch.rpm
       
   3. Import the GnuPG key:
      
      sudo rpm --import /etc/RPM-GPG-KEY-mysql
       
   4. Refresh the repository information:
      
      sudo zypper refresh
       
   5. Install the MySQL Server by the following command:
      
      sudo zypper install mysql-community-server
       
   6. Start the MySQL Server:
      
      sudo /etc/init.d/mysql start
       
   7. You can check if the MySQL is running:
      
      sudo /etc/init.d/mysql status
       
   8. 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.

2. Configure the MySQL Server. 
    
3. 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
    
4. 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 
    
5. 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.

6. 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
    
7. 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]
    
8. Check your odbcinst_23 version:
   
    odbcinst_23 --version
   
   If the version is earlier than 2.3.0 append the following line into your odbcinst_23.ini file:
   
   Threading = 0
    
9. Update the configuration files that control ODBC  access by the following command:
   
   sudo odbcinst_23 -i -d -f /etc/unixODBC_23/odbcinst_23.ini
    
10. 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
     
11. Make the ESMC Server install file executable:
    
    chmod +x Server-Linux-x86_64.sh
     
12. 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 with mysql_secure_installation command.

13. 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