CE installer can't connect to MySQL

Problems with installing LogicalDOC? No problems, the solution is closer than you think.

Moderator: car031

andy_todd
Posts: 5
Joined: Tue Aug 21, 2018 5:49 am

CE installer can't connect to MySQL

Wed Sep 19, 2018 8:53 am

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?
agaspa
Posts: 620
Joined: Tue Apr 20, 2010 8:24 am

Re: CE installer can't connect to MySQL

Wed Oct 24, 2018 8:44 am

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)

Return to “Installation”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest