The EUM Server crashes with the following error in log files: java.sql.SQLException: Connections could not be acquired from the underlying database!
Stack trace from eum-processor.log:
1) One reason why this issue occurs is due to the complexity of the password used for the property onprem.dbPassword inside the eum.properties file. This property is used to specify the user password to the EUM database.
2) Starting with the 4.4.x release, as EUM has its own database, this error can even surface when the EUM database is not running at all.
The solution to the first problem would be to use simpler passwords (e.g., without non-alphanumeric characters) for the property onprem.dbPassword.
Once the property above is modified with a simpler password, complete the following steps:
Save and close the properties file.
Restart the EUM server.
For the second issue, make sure that the database is started before starting the EUM server using the commands below:
cd <EUM_INSTALL_DIR>/orcha/orcha-master/bin ./orcha-master -d mysql.groovy -p ../../playbooks/mysql-orcha/start-mysql.orcha -o ../conf/orcha.properties -c local