Page 1 of 1

Installation fails connection to MySQL

Posted: Wed Sep 19, 2018 12:00 am
by andy_todd
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

Re: Installation fails connection to MySQL

Posted: Wed Sep 19, 2018 3:11 pm
by agaspa
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

Re: Installation fails connection to MySQL

Posted: Wed Sep 19, 2018 11:49 pm
by andy_todd
Thanks for the reply, I can't do a GUI installation as this is Ubuntu Server - it doesn't have a GUI.

Re: Installation fails connection to MySQL

Posted: Thu Sep 20, 2018 1:17 am
by andy_todd
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.

Re: Installation fails connection to MySQL

Posted: Thu Sep 20, 2018 8:35 am
by agaspa
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

Re: Installation fails connection to MySQL

Posted: Tue Sep 25, 2018 12:13 am
by andy_todd
Thanks for the advice to use the console installer. That is what I am using.