Upgrading to 6.3 - Invalid credentials

[BDeep 7]

When attempting to upgrade using the instructions here on CentOS: hxxp://support.eset.com/kb3670/, specifically step 9:

Run the ERA Server installer: ./Server-Linux-x86_64.sh --skip-license

Extracting archive, please wait...
Archive extracted to /tmp/tmp.lK8FpNVE9q.
Checking OpenSSL ... done [OpenSSL 1.0.1e-fips 11 Feb 2013]
Reading previous installation settings ..../Server-Linux-x86_64.sh: eval: line 495: unexpected EOF while looking for matching `"'
./Server-Linux-x86_64.sh: eval: line 496: syntax error: unexpected end of file
./Server-Linux-x86_64.sh: line 496: warning: syntax errors in . or eval will cause future versions of the shell to abort as Posix requires
 done
Checking installed version... done
Status of current installation is: UPGRADE
Checking database connection ... failure

Error: User login failed (invalid credentials provided)

The log file in /var/log/eset/RemoteAdministrator/EraServerInstaller.log shows:

 

2016-01-27 20:19:21 Information: Exception thrown while connecting to the database as a user.. Error code: 1045, DB specific error code: 1045, error message: [unixODBC][MySQL][ODBC 5.3(w) Driver]Access denied for user 'era'@'localhost' (using password: NO)


2016-01-27 20:19:22 Information: Exception thrown while connecting to the database SERVER as a user.. Error code: 1045, DB specific error code: 1045, error message: [unixODBC][MySQL][ODBC 5.3(w) Driver]Access denied for user 'era'@'localhost' (using password: NO)
 

 

It looks like the script is attempting to connect to the database and it is getting rejected as requiring a password?

 

[MartinK 384]

It looks like the script is attempting to connect to the database and it is getting rejected as requiring a password?

 

Yes, it is trying to connect to database using credentials it found in connection string and SERVER configuration - but unfortunately it seems loading of them failed at some point -> most probably fetching of password for "era" user was not successful. Is there any chance you are using "special" characters (characters with special meaning in shell scripting, like {}[]";\'@$<\n>*) in password?

[BDeep 7]

 

It looks like the script is attempting to connect to the database and it is getting rejected as requiring a password?

 

Yes, it is trying to connect to database using credentials it found in connection string and SERVER configuration - but unfortunately it seems loading of them failed at some point -> most probably fetching of password for "era" user was not successful. Is there any chance you are using "special" characters (characters with special meaning in shell scripting, like {}[]";\'@$<\n>*) in password?

 

 

Yup, I have one or more of those special characters in the password. Workaround?

[MartinK 384]

 

Yup, I have one or more of those special characters in the password. Workaround?

 

 

Simplest workaround I can recall know without testing would be temporarily changing password of database user, both in database and SERVER connection string (this is described in point 8 of hxxp://help.eset.com/era_install/63/en-US/db_migration_mysql.htm).Once SERVER is successfully upgraded, you can restore original settings.

[BDeep 7]

Nailed it! Thanks.

 

Files are in root (using WinSCP and dumping them in /root). My terminal lines in the CentOS OVA if anybody want to copy/paste:

service tomcat6 stop

mkdir backup

cp -R /var/lib/tomcat6/webapps/era /backup

cp /var/lib/tomcat6/webapps/era/WEB-INF/classes/sk/eset/era/g2webconsole/server/modules/config/EraWebServerConfig.properties /backup/EraWebServerConfig.properties

rm -rf /var/lib/tomcat6/webapps/era/webconsole

rm -f /var/lib/tomcat6/webapps/era.war

yum -y install unzip

unzip era.war -d /var/lib/tomcat6/webapps/era/

rm /var/lib/tomcat6/webapps/era/WEB-INF/classes/sk/eset/era/g2webconsole/server/modules/config/EraWebServerConfig.properties

cp /backup/EraWebServerConfig.properties /var/lib/tomcat6/webapps/era/WEB-INF/classes/sk/eset/era/g2webconsole/server/modules/config/EraWebServerConfig.properties

cp /etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini /backup/StartupConfiguration.ini

nano /etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini

chmod +x Server-Linux-x86_64.sh

mysql -u root -p
(P is root pass)

set password for 'root'@'localhost' = PASSWORD(' ');
set password for 'era'@'localhost' = PASSWORD(' ');
flush privileges;

grant SUPER on *.* to 'era'@'localhost';

exit

./Server-Linux-x86_64.sh --skip-license

mysql -u root -p

revoke SUPER on *.* from 'era'@'localhost';

exit

chmod +x EraAgentInstaller.sh
(downloaded new version from ERA server using "Agent Live Installers"

./EraAgentInstaller.sh

chmod +x RDSensor-Linux-x86_64.sh

./RDSensor-Linux-x86_64.sh

shutdown -r now

Edited January 28, 2016 by BDeep