[KB6038] The installation of ERA Server (6.x) on SUSE Linux Enterprise Server 11 fails

Issue

End of support for version 6.4 and 6.5 of ESET Remote Administrator / MDM

ESET Remote Administrator version 6.5 is currently in Limited Support status and will soon be in Basic Support status. It is expected to reach End of Life status in December 2020.

ESET Remote Administrator version 6.4 is currently in basic support status and is expected to reach End of Life status in December 2019.

The MDM functionality in ESET Remote Administrator version 6 is in Basic Support status as of April 11, 2019. After this date, MDM version 6 will no longer be available for download.

  • 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 inspired by officialMySQL documentation. Visit the MySQL developer sitefor 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 ERA 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.0append 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 ERA Server install file (you can download it from theESET Download page). For example:

    wget http://download.eset.com/download/ra/v6/standalone-installers/server/Server-Linux-x86_64.sh
  11. Make the ERA Server install file executable:

    chmod+xServer-Linux-x86_64.sh
  12. Run the installation command on your ERA 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, you can check if the ERA Server is running:

    sudo /etc/init.d/eraserver status