maniel 0 Posted August 28, 2018 Share 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) Link to comment Share on other sites More sharing options...
ESET Staff MartinK 376 Posted August 28, 2018 ESET Staff Share 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)? Link to comment Share on other sites More sharing options...
maniel 0 Posted August 29, 2018 Author Share 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 Link to comment Share on other sites More sharing options...
ESET Staff MartinK 376 Posted August 29, 2018 ESET Staff Share 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. Link to comment Share on other sites More sharing options...
maniel 0 Posted August 29, 2018 Author Share 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:) Link to comment Share on other sites More sharing options...
opa-pro 2 Posted September 11, 2018 Share 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 Link to comment Share on other sites More sharing options...
maniel 0 Posted September 12, 2018 Author Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts