Jump to content

Archived

This topic is now archived and is closed to further replies.

BDeep

Upgrading to 6.3 - Invalid credentials

Recommended Posts

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?

 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

 

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?

Share this post


Link to post
Share on other sites

 

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.

Share this post


Link to post
Share on other sites

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


Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...