Upgrade 6.4 to 6.5 problem

[Dimitri D 0]

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

[Marcos 5,462]

For how long have you been waiting for the upgrade to complete?

[Dimitri D 0]

I don't remember but as long as for the others customers.

[MartinK 384]

Could you please check /var/log/eset/RemoteAdministrator/Server/trace.log for errors? Seems that eraserver daemon is not running.

[Dimitri D 0]

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.

[MartinK 384]

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.

[Dimitri D 0]

Thanks for the link.

What are the parameters to connect to the appliance DB on CentOS ?

[Dimitri D 0]

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.

[MartinK 384]

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;

 

[Dimitri D 0]

service iptables stop

Thx, it works.

[Dimitri D 0]

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.

[niyom 0]

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