[Solved] DB error on 2.0 Upgrade

Unimus support forum
Post Reply
jstump
Posts: 16
Joined: Thu Jul 14, 2016 8:26 pm

Mon May 18, 2020 2:54 pm

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.
User avatar
Tomas
Posts: 1206
Joined: Sat Jun 25, 2016 12:33 pm

Mon May 18, 2020 3:01 pm

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
Posts: 16
Joined: Thu Jul 14, 2016 8:26 pm

Mon May 18, 2020 3:18 pm

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
User avatar
Tomas
Posts: 1206
Joined: Sat Jun 25, 2016 12:33 pm

Mon May 18, 2020 3:20 pm

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
Posts: 16
Joined: Thu Jul 14, 2016 8:26 pm

Mon May 18, 2020 3:30 pm

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.
User avatar
Tomas
Posts: 1206
Joined: Sat Jun 25, 2016 12:33 pm

Tue May 19, 2020 2:29 pm

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?
User avatar
Tomas
Posts: 1206
Joined: Sat Jun 25, 2016 12:33 pm

Tue May 19, 2020 7:12 pm

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.
Post Reply