Installation fails connection 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

Installation fails connection to MySQL

Wed Sep 19, 2018 12:00 am

Hi everyone, I'm having trouble running the logicaldoc community installer (8.0) on Ubuntu server 18.04.1 LTS

I've created a MySQL database (called logicaldoc) and a database user (also called logicaldoc) and have verified using the MySQL command line client that I can connect to the correct database with these credentials.

But when I run the installer I get to the stage where I enter the database connection credentials and the installer responds with

Code: Select all

Validation failed:
Database not connected
When I checked the installer log file all it contains is;

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
Has anyone else seen this problem and/or figured out what I need to do to resolve it?

O/S - Ubuntu Server 18.04.1 LTS
LogicalDOC - Community Edition 8.0
MySQL - 5.7.23
agaspa
Posts: 714
Joined: Tue Apr 20, 2010 8:24 am

Re: Installation fails connection to MySQL

Wed Sep 19, 2018 3:11 pm

Hi Andy,
if you install from the web gui, you should replace the tokens <> with the values of your connection.

If instead you used the installer from the jar that error is very strange, usually it is enough to follow the procedure and fill-out the field of the database

LogicalDOC Enterprise - Ubuntu easy setup
andy_todd
Posts: 5
Joined: Tue Aug 21, 2018 5:49 am

Re: Installation fails connection to MySQL

Wed Sep 19, 2018 11:49 pm

Thanks for the reply, I can't do a GUI installation as this is Ubuntu Server - it doesn't have a GUI.
andy_todd
Posts: 5
Joined: Tue Aug 21, 2018 5:49 am

Re: Installation fails connection to MySQL

Thu Sep 20, 2018 1:17 am

Just in case there was a problem with the Community Edition I have registered for a trial license for the full product. Sadly the console installer for the commercial edition also fails at the same step.

Anyone know how to engage support to get them to look at this?

I've replicated the problem on 2 server VMs - one at Azure and one running in Virtualbox on my desktop machine.
agaspa
Posts: 714
Joined: Tue Apr 20, 2010 8:24 am

Re: Installation fails connection to MySQL

Thu Sep 20, 2018 8:35 am

Hi Andy,

it is possible to run the installer from the command line with a console installation.

You should download the community installer, uncompress it and launch the command with option -console

Code: Select all

java -jar logicaldoc-installer.jar -console
https://sourceforge.net/projects/logica ... p/download

That same option (-console) is available also for the Free Trial you can download from LogicalDOC website

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

Re: Installation fails connection to MySQL

Tue Sep 25, 2018 12:13 am

Thanks for the advice to use the console installer. That is what I am using.

Return to “Installation”

Who is online

Users browsing this forum: No registered users and 22 guests