The SVM on-premise user is unable to log in at SVM On-premise console and getting a Connection Failed Error. Please follow the below steps to resolve your issue.
Steps:
Log in to your DB server
mysql -u root -p
Search the private DB user (The private DB is usually a customer id of the server)
select user, host, password from mysql.user;
Run the following command to update the user
update mysql.user set host = '%' where user = 'enter DB user here';
Run the command to flush the privileges and restart the DB service
FLUSH PRIVILEGES;
or
mysql or mariadb service restart
Stop the following services
service httpd stop
service haproxy stop
Run the dbpdb.sh from /usr/local/Secunia/csi/install and follow instructions
cd /usr/local/Secunia/csi/install
./dbpdb.sh
Start the apache and haproxy service
service httpd start
service haproxy start
Important: Stopping and restarting services are handled in dbpdb.sh script now and this feature is only available in RPM's and not VA(Virtual Appliance).
