Page 1 of 1
[Solved] DB error on 2.0 Upgrade
Posted: Mon May 18, 2020 2:54 pm
by jstump
After running the installer for upgrading to 2.0, my instance is bombing out on start with the following:
Failed to start Unimus
Malformed database config - database config is not complete.
Please fix database config in configuration file and restart Unimus.
please advise.
Re: DB error on 2.0 Upgrade
Posted: Mon May 18, 2020 3:01 pm
by Tomas
Hello,
We are seeing this report from multiple customers, and we are investigating.
It seems the DB port was not properly migrated in the config file across versions.
You can fix this manually by adding missing parameters to:
"C:\ProgramData\Unimus\unimus.properties" or "/etc/unimus/unimus.properties"
After all configs are present, please restart the service, and Unimus should continue working.
Re: DB error on 2.0 Upgrade
Posted: Mon May 18, 2020 3:18 pm
by jstump
Looks like all my db info is in the /etc/unimus/unimus.properties
I have the following present currently:
# Database type, valid values are MYSQL, POSTGRESQL, or HSQL
database.type = MYSQL
# Key used to encrypt sensitive data
database.encryption.key = XXXXXX
# Specify the file system directory path, relevant only for HSQL database
database.path =
# Database host, relevant only for MYSQL and POSTGRESQL databases
database.host = localhost
# Database schema name, relevant only for MYSQL and POSTGRESQL databases
database.name = unimus
# User name to use when connecting to database, relevant only for MYSQL and POSTGRESQL databases
database.user = XXXXXX
# Password to use when connecting to database, relevant only for MYSQL and POSTGRESQL databases
database.password = XXXXXX
Re: DB error on 2.0 Upgrade
Posted: Mon May 18, 2020 3:20 pm
by Tomas
Please add the DB port to the config file:
database.port = 3306
As a side-note, what Unimus distribution are you running please?
(jar, war, etc.)
Re: DB error on 2.0 Upgrade
Posted: Mon May 18, 2020 3:30 pm
by jstump
Thanks. That worked and now I'm getting connection refused by db. Getting the following now:
Reason = 'org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
I can log in via mysql command line.
I'm just using the unimus installer script for Ubuntu.
Re: DB error on 2.0 Upgrade
Posted: Tue May 19, 2020 2:29 pm
by Tomas
At this point, perhaps it would be best to do a direct debug session to look at this in depth.
Could you please create a ticket on our Portal, and we would organize from there?
Re: [Solved] DB error on 2.0 Upgrade
Posted: Tue May 19, 2020 7:12 pm
by Tomas
This one was totally my fault - I posted the wrong port in the previous post.
I edited the previous message with the right MySQL default port.