• New Zealand COVID-19 Protection Framework is now in place: Traffic light settings.

    Health tips to prevent the spread of COVID-19:
    • Wash your hands frequently;
    • Maintain 2 meters social distancing;
    • Minimise outdoor activities.
    Stay safe in your bubble!

ESET Security Management Center Login Failed: Connection has failed with the state Not connected

Andy

Administrator
Creative Team
User ID
1
Joined
7 Jan 2019
Messages
606
Reaction score
28
Points
28
You receive the error message: Login Failed: Connection has failed with the state of 'Not connected'

eset-smc.png

This error message means that there is an issue with the connection between Webserver and ESMC Server or the ESMC Server and ESMC Database (but the connection between the Browser and Webserver is probably working).

In that case, we want to investigate the connection between ESMC Server and ESMC Database.

On the ESMC console, type in:
Bash:
[root@av ~]# odbcinst-q -d
[MySQL ODBC 5.3 Unicode Driver]
[MySQL ODBC 5.3 ANSI Driver]
[root@av ~]#
You may have the different ODBC driver, but to confirm, let's have an additional look by using the concatenate (cat command) on this file: /etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini

If the output is:
Bash:
DatabaseType=MySqlOdbc
DatabaseConnectionString=Driver=MySQL ODBC 5.3 Unicode Driver;Server=...

Then congratulations! We have found the root cause. The problem appears ESMC Server can't talk with ESMC Database due to incompatible ODBC driver, this most likely caused by the OS update (yum update).

Here's the solution for this issue:
  • We want to remove the currently installed ODBC driver, type:
    Bash:
    yum remove mysql-connector-odbc.x86_64
  • Then install the compatible 5.3 ODBC driver, type:
    Bash:
    wget https://downloads.mysql.com/archives/get/file/mysql-connector-odbc-5.3.10-1.el7.x86_64.rpm
    chmod +x mysql-connector-odbc-5.3.10-1.el7.x86_64.rpm
    yum localinstall mysql-connector-odbc-5.3.10-1.el7.x86_64.rpm
  • Restart the server and your ESMC should now back online.
For your reference, I'm using the official ESET Remote Administrator Appliance (Hyper-V version), which I believe it's derived from CentOS:
Bash:
[root@av ~]# uname -a
Linux av.genesis.saputra.org 3.10.0-957.5.1.el7.x86_64 #1 SMP Fri Feb 1 14:54:57 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
[root@av ~]#
Let me know if you find this article useful by commenting down below, you can also ask me any questions. Cheers 🍻
 

Anon12345678

New member
User ID
937
Joined
5 Jan 2022
Messages
1
Reaction score
1
Points
3
I know this is two years later but I found this thread while searching for a solution for this problem and you nailed the exact problem. Downgrading the mysql-connector-odbc package solved the issue, though it seems mysql might have changed their URL scheme a little bit so I had to find the download from https://downloads.mysql.com/archives/c-odbc/

Thanks for putting this together!
 

Andy

Administrator
Creative Team
User ID
1
Joined
7 Jan 2019
Messages
606
Reaction score
28
Points
28
I know this is two years later but I found this thread while searching for a solution for this problem and you nailed the exact problem. Downgrading the mysql-connector-odbc package solved the issue, though it seems mysql might have changed their URL scheme a little bit so I had to find the download from https://downloads.mysql.com/archives/c-odbc/

Thanks for putting this together!
Thanks for your feedback, as well as the URL update. Cheers 🥂
 
 Short URL:
Top