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 ...
Release : 6.7
Component : CA RELEASE AUTOMATION ACTION PACK
DB : MySQL
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.
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
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