The silent installation of NAC is failing on ubuntu 20.04 in docker container

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

Hi,

We are trying to install NAC on ubuntu 20.04 server inside a docker container with silent installation. Please find the server.silent.varfile attached herewith.

I am running this command to install NAC silently

./nolio_server_linux-x64_6_7_0_b81.sh -q -varfile server.silent.varfile

I get following message without any additional logs,

===============

Unpacking JRE ...
Starting Installer ...
Jun 28, 2021 7:03:11 PM java.util.prefs.FileSystemPreferences$2 run
INFO: Created system preferences directory in java.home.
Fontconfig warning: no <cachedir> elements found. Check configuration.
Fontconfig warning: adding <cachedir>/var/cache/fontconfig</cachedir>
Fontconfig warning: adding <cachedir prefix="xdg">fontconfig</cachedir>
The installation directory has been set to /opt/ReleaseAutomationServer.

Could not connect to the database and check the schema. check connections and privileges, and see the log for more details
Rolling back changes ...

============================

Environment

Release : 6.7

Component : CA RELEASE AUTOMATION ACTION PACK

DB : MySQL

Cause

This a connection issue with DB from container where you are trying to install NAC. This issue can also occur in case if the user is not having correct grant to connect remote, as MySQL restrict users connection from specific hosts.

Resolution

Please validate the respons.varfile to make sure the configuration are correct. The response file template is present in the document Install Server with silent Install.

Please validate below parameters values in response.varfile are correct

• sys.installationDir=/home/user1/ReleaseAutomationServer [This will change based on which OS you are trying to install]
• nolio.db.type$Integer=0 [Here 0 for mysql, 1 for mssql and 2 for oracle]
• nolio.db.user.name=db_user [The DB username]
• nolio.db.password=secret_password [The password for DB username]

Validate connectivity from remotely to DB server for user db_user

mysql -u db_user -p -h HOSTNAME/IP__OF_DB

Please validate what permission the user has which you are using in response.varfile by running query against MySQL DB

SHOW GRANTS FOR 'techonthenet'@'10.8.0.5';
SHOW GRANTS FOR 'techonthenet'@'%';

Please check if user has remote connect permissions and connect from specific host is allowed. The same can be given by running below query

GRANT ALL ON dbname.* TO [email protected]'10.8.0.5' IDENTIFIED BY 'db_user_pwd'; #specific IP
GRANT ALL ON dbname.* TO [email protected]'%' IDENTIFIED BY 'db_user_pwd'; #Wildcard from any IP