maniel 0 Posted August 28, 2018 Posted August 28, 2018 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 MartinK 384 Posted August 28, 2018 ESET Staff Posted August 28, 2018 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)?
maniel 0 Posted August 29, 2018 Author Posted August 29, 2018 (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 August 29, 2018 by maniel
ESET Staff MartinK 384 Posted August 29, 2018 ESET Staff Posted August 29, 2018 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.
maniel 0 Posted August 29, 2018 Author Posted August 29, 2018 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:)
opa-pro 2 Posted September 11, 2018 Posted September 11, 2018 (edited) reboot and that not work... and more reboot disable Virtualbox network adapter and now work... Edited September 11, 2018 by opa-pro
maniel 0 Posted September 12, 2018 Author Posted September 12, 2018 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
Recommended Posts