[Solved] DB error on 2.0 Upgrade

[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.

[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.

[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

[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.)

[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.

[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?

[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.