Jump to content

Can not log in into Remote Administrator Web Console

alexroz
 Share

Recommended Posts

alexroz

alexroz 2

Posted
Posted (edited)

Hi

Suddenly i can not log-in into my Remote Administrator Web Console that runs into VM based on CENTOS.

The server up and running.

I  can open https://myeraserverip/era/webconsole/ page in the browser.

But when I enter the administrative password I receive: 

Login failed: Connection has failed with state 'Not connected'

When I run 

/opt/eset/RemoteAdministrator/Server/DiagnosticServer

with 

4. ActionConfiguration. Get configuration.

I receive:  

ERROR executing task ActionConfiguration, error: [unixODBC][Driver Manager]Can't open lib 'MySQL ODBC 5.3 Unicode Driver' : file not found (0)

In my /etc/odbcinst.ini I can see only "MySQL ODBC 8.0 Unicode Driver" but no "MySQL ODBC 5.3 Unicode Driver" as "/opt/eset/RemoteAdministrator/Server/DiagnosticServer" trying to apply 

[root@era ~]# cat /etc/odbcinst.ini
[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/lib/psqlodbcw.so
Setup=/usr/lib/libodbcpsqlS.so
Driver64=/usr/lib64/psqlodbcw.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1

[MySQL ODBC 8.0 Unicode Driver]
Driver=/usr/lib64/libmyodbc8w.so
UsageCount=1

[MySQL ODBC 8.0 ANSI Driver]
Driver=/usr/lib64/libmyodbc8a.so
UsageCount=1

 

  

[root@era ~]# ldd -v /usr/lib64/libmyodbc8w.so
        linux-vdso.so.1 =>  (0x00007ffc5d828000)
        libodbcinst.so.2 => /usr/lib64/libodbcinst.so.2 (0x00007f412ac6c000)
        libpthread.so.0 => /usr/lib64/libpthread.so.0 (0x00007f412aa4f000)
        librt.so.1 => /usr/lib64/librt.so.1 (0x00007f412a847000)
        libssl.so.10 => /usr/lib64/libssl.so.10 (0x00007f412a5d5000)
        libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x00007f412a174000)
        libdl.so.2 => /usr/lib64/libdl.so.2 (0x00007f4129f6f000)
        libm.so.6 => /usr/lib64/libm.so.6 (0x00007f4129c6d000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f4129965000)
        libgcc_s.so.1 => /usr/lib64/libgcc_s.so.1 (0x00007f412974e000)
        libc.so.6 => /usr/lib64/libc.so.6 (0x00007f412938b000)
        /lib64/ld-linux-x86-64.so.2 (0x000055e80c50a000)
        libltdl.so.7 => /usr/lib64/libltdl.so.7 (0x00007f4129181000)
        libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2 (0x00007f4128f33000)
        libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x00007f4128c4b000)
        libcom_err.so.2 => /usr/lib64/libcom_err.so.2 (0x00007f4128a47000)
        libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3 (0x00007f4128813000)
        libz.so.1 => /usr/lib64/libz.so.1 (0x00007f41285fd000)
        libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0 (0x00007f41283ee000)
        libkeyutils.so.1 => /usr/lib64/libkeyutils.so.1 (0x00007f41281ea000)
        libresolv.so.2 => /usr/lib64/libresolv.so.2 (0x00007f4127fd0000)
        libselinux.so.1 => /usr/lib64/libselinux.so.1 (0x00007f4127da8000)
        libpcre.so.1 => /usr/lib64/libpcre.so.1 (0x00007f4127b46000)

        Version information:
        /usr/lib64/libmyodbc8w.so:
                libgcc_s.so.1 (GCC_3.0) => /usr/lib64/libgcc_s.so.1
                ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x86-64.so.2
                libdl.so.2 (GLIBC_2.2.5) => /usr/lib64/libdl.so.2
                libstdc++.so.6 (GLIBCXX_3.4.18) => /usr/lib64/libstdc++.so.6
                libstdc++.so.6 (GLIBCXX_3.4.11) => /usr/lib64/libstdc++.so.6
                libstdc++.so.6 (CXXABI_1.3) => /usr/lib64/libstdc++.so.6
                libstdc++.so.6 (CXXABI_1.3.5) => /usr/lib64/libstdc++.so.6
                libstdc++.so.6 (GLIBCXX_3.4) => /usr/lib64/libstdc++.so.6
                libpthread.so.0 (GLIBC_2.2.5) => /usr/lib64/libpthread.so.0
                libcrypto.so.10 (libcrypto.so.10) => /usr/lib64/libcrypto.so.10
                libssl.so.10 (libssl.so.10) => /usr/lib64/libssl.so.10
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
        /usr/lib64/libodbcinst.so.2:
                libpthread.so.0 (GLIBC_2.2.5) => /usr/lib64/libpthread.so.0
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6
        /usr/lib64/libpthread.so.0:
                ld-linux-x86-64.so.2 (GLIBC_2.2.5) => /lib64/ld-linux-x86-64.so.2
                ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x86-64.so.2
                ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linux-x86-64.so.2
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.2) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_PRIVATE) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
        /usr/lib64/librt.so.1:
                libpthread.so.0 (GLIBC_2.3.2) => /usr/lib64/libpthread.so.0
                libpthread.so.0 (GLIBC_PRIVATE) => /usr/lib64/libpthread.so.0
                libpthread.so.0 (GLIBC_2.2.5) => /usr/lib64/libpthread.so.0
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.2) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_PRIVATE) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
        /usr/lib64/libssl.so.10:
                libk5crypto.so.3 (k5crypto_3_MIT) => /usr/lib64/libk5crypto.so.3
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.17) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libkrb5.so.3 (krb5_3_MIT) => /usr/lib64/libkrb5.so.3
                libcrypto.so.10 (OPENSSL_1.0.1_EC) => /usr/lib64/libcrypto.so.10
                libcrypto.so.10 (libcrypto.so.10) => /usr/lib64/libcrypto.so.10
        /usr/lib64/libcrypto.so.10:
                libdl.so.2 (GLIBC_2.2.5) => /usr/lib64/libdl.so.2
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.7) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.17) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
        /usr/lib64/libdl.so.2:
                ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linux-x86-64.so.2
                libc.so.6 (GLIBC_PRIVATE) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
        /usr/lib64/libm.so.6:
                ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linux-x86-64.so.2
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_PRIVATE) => /usr/lib64/libc.so.6
        /usr/lib64/libstdc++.so.6:
                ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x86-64.so.2
                libm.so.6 (GLIBC_2.2.5) => /usr/lib64/libm.so.6
                libgcc_s.so.1 (GCC_4.2.0) => /usr/lib64/libgcc_s.so.1
                libgcc_s.so.1 (GCC_3.3) => /usr/lib64/libgcc_s.so.1
                libgcc_s.so.1 (GCC_3.0) => /usr/lib64/libgcc_s.so.1
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.2) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
        /usr/lib64/libgcc_s.so.1:
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
        /usr/lib64/libc.so.6:
                ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x86-64.so.2
                ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linux-x86-64.so.2
        /usr/lib64/libltdl.so.7:
                libdl.so.2 (GLIBC_2.2.5) => /usr/lib64/libdl.so.2
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
        /usr/lib64/libgssapi_krb5.so.2:
                libk5crypto.so.3 (k5crypto_3_MIT) => /usr/lib64/libk5crypto.so.3
                libkrb5support.so.0 (krb5support_0_MIT) => /usr/lib64/libkrb5support.so.0
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.8) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libkrb5.so.3 (krb5_3_MIT) => /usr/lib64/libkrb5.so.3
        /usr/lib64/libkrb5.so.3:
                libresolv.so.2 (GLIBC_2.2.5) => /usr/lib64/libresolv.so.2
                libk5crypto.so.3 (k5crypto_3_MIT) => /usr/lib64/libk5crypto.so.3
                libkrb5support.so.0 (krb5support_0_MIT) => /usr/lib64/libkrb5support.so.0
                libkeyutils.so.1 (KEYUTILS_1.0) => /usr/lib64/libkeyutils.so.1
                libkeyutils.so.1 (KEYUTILS_1.5) => /usr/lib64/libkeyutils.so.1
                libkeyutils.so.1 (KEYUTILS_0.3) => /usr/lib64/libkeyutils.so.1
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.8) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.16) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6
        /usr/lib64/libcom_err.so.2:
                ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x86-64.so.2
                libpthread.so.0 (GLIBC_2.2.5) => /usr/lib64/libpthread.so.0
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.17) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
        /usr/lib64/libk5crypto.so.3:
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libkrb5support.so.0 (krb5support_0_MIT) => /usr/lib64/libkrb5support.so.0
        /usr/lib64/libz.so.1:
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
        /usr/lib64/libkrb5support.so.0:
                libdl.so.2 (GLIBC_2.2.5) => /usr/lib64/libdl.so.2
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.8) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.7) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
        /usr/lib64/libkeyutils.so.1:
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.7) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
        /usr/lib64/libresolv.so.2:
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_PRIVATE) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6
        /usr/lib64/libselinux.so.1:
                libdl.so.2 (GLIBC_2.2.5) => /usr/lib64/libdl.so.2
                ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x86-64.so.2
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.8) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.7) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
        /usr/lib64/libpcre.so.1:
                libpthread.so.0 (GLIBC_2.2.5) => /usr/lib64/libpthread.so.0
                libc.so.6 (GLIBC_2.14) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.4) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /usr/lib64/libc.so.6
                libc.so.6 (GLIBC_2.3) => /usr/lib64/libc.so.6

I can see the following in servers /var/log/messages 

Apr 23 11:43:16 era server: Apr 23, 2018 11:43:16 AM sk.eset.era.g2webconsole.server.modules.logger.FileLogWriter addItem
Apr 23 11:43:16 era server: INFO: [2018-04-23 11:43:16.755] V3 [] <INFO> Generating main page HTML using locale: en_US
Apr 23 11:43:17 era server: Apr 23, 2018 11:43:17 AM sk.eset.era.g2webconsole.server.modules.logger.FileLogWriter addItem
Apr 23 11:43:17 era server: INFO: [2018-04-23 11:43:17.491] V2 [] <INFO> Console requests webserver info.
Apr 23 11:43:18 era server: Apr 23, 2018 11:43:18 AM sk.eset.era.g2webconsole.server.modules.logger.FileLogWriter addItem
Apr 23 11:43:18 era server: INFO: [2018-04-23 11:43:18.717] V2 [] <INFO> User sends request for authentification using login name Administrator, domain false, locale en_US and cookies true (192.168.0.19).
Apr 23 11:43:18 era server: Apr 23, 2018 11:43:18 AM sk.eset.era.g2webconsole.server.modules.logger.FileLogWriter addItem
Apr 23 11:43:18 era server: INFO: [2018-04-23 11:43:18.720] V2 [] <INFO> Closing connection
Apr 23 11:43:18 era server: Apr 23, 2018 11:43:18 AM sk.eset.era.g2webconsole.server.modules.logger.FileLogWriter addItem
Apr 23 11:43:18 era server: INFO: [2018-04-23 11:43:18.720] V2 [Administrator] <WARNING> Login (session creation) failed (code 3) from address 192.168.0.19.
Apr 23 11:43:18 era server: Apr 23, 2018 11:43:18 AM sk.eset.era.g2webconsole.server.modules.logger.FileLogWriter addItem
Apr 23 11:43:18 era server: INFO: [2018-04-23 11:43:18.721] V1 [Administrator] <TRACE> Login failed. Reason: Connection failed 'NOT_CONNECTED'
Apr 23 11:43:18 era server: Apr 23, 2018 11:43:18 AM sk.eset.era.g2webconsole.server.modules.logger.FileLogWriter addItem
Apr 23 11:43:18 era server: INFO: [2018-04-23 11:43:18.725] V2 [] <ERROR> Connection closing because of ERA server communication processing error: Connection refused
Apr 23 11:43:18 era server: Apr 23, 2018 11:43:18 AM sk.eset.era.g2webconsole.server.modules.logger.FileLogWriter addItem
Apr 23 11:43:18 era server: INFO: [2018-04-23 11:43:18.725] V2 [] <ERROR> Connection closing because of ERA server communication error: Connection refused
Apr 23 11:43:18 era server: Apr 23, 2018 11:43:18 AM sk.eset.era.g2webconsole.server.modules.logger.FileLogWriter addItem
Apr 23 11:43:18 era server: INFO: [2018-04-23 11:43:18.727] V2 [] <INFO> Closing connection

How can I solve the problem?

Edited by alexroz
Link to comment
Share on other sites
  • ESET Moderators
foneil

foneil 342

Posted
  • ESET Moderators
Posted
6 hours ago, alexroz said:

Just found the solution at:  Cannot connect to the ESET Remote Administrator Web Console (6.x) after MySQL update on Linux

I'm glad you found it. For issues like this that necessitate a quick KB article, I'm toying with the idea of an RSS feed users can subscribe to for new KB articles, same as the ones already created for KB News, Alerts, Customer Advisories: 

Subscribe to ESET Knowledgebase Support News, Alerts and Customer Advisories

I'm not sure how else we could get this info to users like you when you need it--let me know what you think, and we'll keep thinking too ;)

Link to comment
Share on other sites
alexroz

alexroz 2

Posted
  • Author
Posted
20 minutes ago, foneil said:

I'm glad you found it. For issues like this that necessitate a quick KB article, I'm toying with the idea of an RSS feed users can subscribe to for new KB articles, same as the ones already created for KB News, Alerts, Customer Advisories: 

Subscribe to ESET Knowledgebase Support News, Alerts and Customer Advisories

I'm not sure how else we could get this info to users like you when you need it--let me know what you think, and we'll keep thinking too ;)

Keep toying with it ;-P

 

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...