Jump to content

Recommended Posts

Posted

We recently upgraded to ESMC from ERA 6.5, we stumbled upon some performance problems (timeouts in web console), wanting to debug if it's a problem with our docker-deployed mysql 5.6.41 i installed mysql 5.7 on host machine, imported db and tried to connect VA to it. The eraserver service seems to fails, there is no crash related info in /var/log/eset/RemoteAdministrator/Server/trace.log, it seems to exit after following info:

Quote

2018-08-28 10:37:11 Information: Kernel [Thread 7fe6aa5bb740]: Initialized module CDatabaseModule (used 18664 KB)

 

  • ESET Staff
Posted

Could you please check content of folder /var/opt/eset/RemoteAdministrator/Server/Dumps for possible crash dumps? If you execute ERAServer process manually from root terminal, does it provide more details in console output (before starting, service eraserver stop to disable service startup will be required)?

Posted (edited)

It says this:

[root@era ~]# /opt/eset/RemoteAdministrator/Server/ERAServer
Loading kernel
Logging to directory /var/log/eset/RemoteAdministrator/Server/
ERAServer: /export/home2/pb2/build/sb_1-28191188-1523532795.64/rpm/BUILD/mysql-connector-odbc-8.0.11-src/driver/my_prepared_stmt.cc:135: int ssps_get_out_params(STMT*): Assertion `values' failed.
Created mini-dump: /var/opt/eset/RemoteAdministrator/Server/Dumps/Local/455c2741-a7ca-4486-1fb0ba8a-11e04845.dmp
Aborted
[root@era ~]#

Ill send you a dump by PM

MySQL version is  5.7.23-0ubuntu0.16.04.1, i remember the same happening when after upgrading docker deployed database to mysql:5.7.23

Edited by maniel
  • ESET Staff
Posted
7 hours ago, maniel said:

It says this:


[root@era ~]# /opt/eset/RemoteAdministrator/Server/ERAServer
Loading kernel
Logging to directory /var/log/eset/RemoteAdministrator/Server/
ERAServer: /export/home2/pb2/build/sb_1-28191188-1523532795.64/rpm/BUILD/mysql-connector-odbc-8.0.11-src/driver/my_prepared_stmt.cc:135: int ssps_get_out_params(STMT*): Assertion `values' failed.
Created mini-dump: /var/opt/eset/RemoteAdministrator/Server/Dumps/Local/455c2741-a7ca-4486-1fb0ba8a-11e04845.dmp
Aborted
[root@era ~]#

Ill send you a dump by PM

MySQL version is  5.7.23-0ubuntu0.16.04.1, i remember the same happening when after upgrading docker deployed database to mysql:5.7.23

As I wrote in PM, problem will be most probably with MySQL ODBC driver v8. We have been aware of this issues, but left v8 driver in appliance, because t worked in combination with MySQL 5.6 available in appliance. My recommendations is to downgrade MySQL ODBC driver to version 5.3, which should work both with MySQL 5.6 and also MySQL 5.7.

Posted

thanks for reply, it works with `mysql-connector-odbc.x86_64-5.3.10-1.el7` from `mysql-connectors-community` repo, other versions i tried generated following error:

2018-08-29 19:46:29 Error: Service [Thread 7f0163e66740]: [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.41]Duplicate entry 'db_starschema' for key 'PRIMARY'

on the side note I've learned howto use yum:)

  • 2 weeks later...
Posted (edited)

reboot and that not work...

and more reboot disable Virtualbox network adapter and now work...

vmplayer_2018-09-11_20-18-39.png

Edited by opa-pro
Posted

They just found out that MySQL 8.0 driver works cool with 5.6 database bundled with VA, as @MartinK wrote ESMC doesn't work with MySQL 8.0 yet

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

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