Page 1 of 1

CE installer can't connect to MySQL

Posted: Wed Sep 19, 2018 8:53 am
by andy_todd
I can't seem to get the installer (8.0 community edition, release 8th August, 2018) to connect to MySQL (5.7) on Ubuntu 18.04.1 LTS

I have created a MySQL database and associated user (who has full privileges on the database). I have verified this access is valid by connected to the database (called 'logicaldoc') with the user (also called 'logicaldoc') on the command line using the mysql utility.

But when I run the installer I see this error message;

Code: Select all

Validation failed:
Database not connected

Press 1 to redisplay, 2 to quit
And when I check the install.log file I see this;

Code: Select all


Tue Sep 18 22:30:29 UTC 2018 - INFO - Setup BEGINS
Tue Sep 18 22:30:29 UTC 2018 - INFO - Checking the existence of /opt/logicaldoc/conf/context.properties
Tue Sep 18 22:31:23 UTC 2018 - INFO - Validating connection to jdbc:mysql://<server>[,<failoverhost>][<:3306>]/<database>
Tue Sep 18 22:31:23 UTC 2018 - INFO - Database not connected perhaps the schema doesnt exist yet
Tue Sep 18 22:31:23 UTC 2018 - INFO - Validating connection to jdbc:mysql://<server>[,<failoverhost>][<:3306>]/<database>
Tue Sep 18 22:31:23 UTC 2018 - INFO - Database not connected perhaps the schema doesnt exist yet
Tue Sep 18 22:31:39 UTC 2018 - INFO - Validating connection to jdbc:mysql://<server>[,<failoverhost>][<:3306>]/<database>
Tue Sep 18 22:31:39 UTC 2018 - INFO - Database not connected perhaps the schema doesnt exist yet
Tue Sep 18 22:31:39 UTC 2018 - INFO - Validating connection to jdbc:mysql://<server>[,<failoverhost>][<:3306>]/<database>
Tue Sep 18 22:31:39 UTC 2018 - INFO - Database not connected perhaps the schema doesnt exist yet
Does anyone have any tips on what I need to change in either my config or the installer to get this working properly?

Re: CE installer can't connect to MySQL

Posted: Wed Oct 24, 2018 8:44 am
by agaspa
Hi,
it appears that the database configuration is not correct.
If the application is still installed (the installation process completed) you can try to run the setup procedure again.
Open your browser and go to http://localhost: 8080/setup
(Adjust address and port to your setting)