Dimitri D 0 Posted July 20, 2017 Share Posted July 20, 2017 (edited) Hello, I have perform an update of ESET Remote Administrator on Centos OS (ESET Appliance) v6.4 to v6.5 thru the web console. I have done this 3-4 times without any issue for others customers but this time I have the error : Login failed: Connection has failed with state 'Not connected' After some investigation, I can mention that when I check initctl list, both eraserver-xvfb and eraserver are stop/waiting. I can start eraserver-xvfb (and i see it start/running) but if I do initctl start eraserver it shows start/running but when I show again initctl list, both are stop/waiting. Can you help me to solve this problem. Thanks Dimitri Edited July 20, 2017 by Dimitri D Link to comment Share on other sites More sharing options...
Administrators Marcos 4,919 Posted July 20, 2017 Administrators Share Posted July 20, 2017 For how long have you been waiting for the upgrade to complete? Link to comment Share on other sites More sharing options...
Dimitri D 0 Posted July 20, 2017 Author Share Posted July 20, 2017 I don't remember but as long as for the others customers. Link to comment Share on other sites More sharing options...
ESET Staff MartinK 376 Posted July 20, 2017 ESET Staff Share Posted July 20, 2017 Could you please check /var/log/eset/RemoteAdministrator/Server/trace.log for errors? Seems that eraserver daemon is not running. Link to comment Share on other sites More sharing options...
Dimitri D 0 Posted July 20, 2017 Author Share Posted July 20, 2017 So I can see only one error : Error : Service [Thread xxxxxxxxx]: [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.28]Table 'era_db.tbl_log_apps_installed_status' doesn't exist Thanks for your help guys. Link to comment Share on other sites More sharing options...
ESET Staff MartinK 376 Posted July 20, 2017 ESET Staff Share Posted July 20, 2017 This is very common problem with upgrade of ERA 6.4 -> ERA 6.5. Most probable cuase is that upgrade process was interrupted (service restart, appliacne reboot,...). Please follow steps described in documentation. Link to comment Share on other sites More sharing options...
Dimitri D 0 Posted July 21, 2017 Author Share Posted July 21, 2017 Thanks for the link. What are the parameters to connect to the appliance DB on CentOS ? Link to comment Share on other sites More sharing options...
Dimitri D 0 Posted July 21, 2017 Author Share Posted July 21, 2017 I think I have found everything for the connexion. But is there anything to do on the appliance (CentOS) to be able to connect to mysql from an other computer ? I got the error "Can't connect to MySQL server on 'xxx.xx.xx.xx' (10060). Thanks for your help. Link to comment Share on other sites More sharing options...
ESET Staff MartinK 376 Posted July 21, 2017 ESET Staff Share Posted July 21, 2017 8 minutes ago, Dimitri D said: I think I have found everything for the connexion. But is there anything to do on the appliance (CentOS) to be able to connect to mysql from an other computer ? I got the error "Can't connect to MySQL server on 'xxx.xx.xx.xx' (10060). Thanks for your help. You will have to temporarily disable firewall using command: service iptables stop It is also possible, that user you will be using to acces database is not configured for acces from outside of appliance. For example there is no root@% available in appliance by default. If you encounter this problem, you will have to create new account or modify existing, using command line MySQL client. For example existing root@localhost user may be updated using: UPDATE mysql.user SET host = '%' WHERE host = 'localhost' AND user = 'root'; FLUSH PRIVILEGES; Link to comment Share on other sites More sharing options...
Dimitri D 0 Posted July 21, 2017 Author Share Posted July 21, 2017 service iptables stop Thx, it works. Link to comment Share on other sites More sharing options...
Dimitri D 0 Posted July 21, 2017 Author Share Posted July 21, 2017 18 hours ago, MartinK said: This is very common problem with upgrade of ERA 6.4 -> ERA 6.5. Most probable cuase is that upgrade process was interrupted (service restart, appliacne reboot,...). Please follow steps described in documentation. Problem solved following MartinK solution, thanks for all guys. Link to comment Share on other sites More sharing options...
niyom 0 Posted July 23, 2017 Share Posted July 23, 2017 On 7/20/2017 at 4:17 PM, Dimitri D said: Hello, I have perform an update of ESET Remote Administrator on Centos OS (ESET Appliance) v6.4 to v6.5 thru the web console. I have done this 3-4 times without any issue for others customers but this time I have the error : Login failed: Connection has failed with state 'Not connected' After some investigation, I can mention that when I check initctl list, both eraserver-xvfb and eraserver are stop/waiting. I can start eraserver-xvfb (and i see it start/running) but if I do initctl start eraserver it shows start/running but when I show again initctl list, both are stop/waiting. Can you help me to solve this problem. Thanks Dimitri Link to comment Share on other sites More sharing options...
Recommended Posts