Page 1 of 1

LD 7.7.2 - Enterprise Ed - Database problems during install

Posted: Tue Nov 28, 2017 7:07 pm
by laurocgb
I am evaluating LD 7.7.2 Enterprise Edition, with intention to buy.

As many other users, during install, I am getting this message:

Code: Select all

Tue Nov 28 15:33:47 BRST 2017 - INFO - Setup BEGINS
Tue Nov 28 15:33:47 BRST 2017 - INFO - Checking the existence of /LogicalDOC/conf/context.properties
Tue Nov 28 15:35:30 BRST 2017 - INFO - Detected Java architecture 32bit
Tue Nov 28 15:35:55 BRST 2017 - INFO - Validating connection to jdbc:mysql://<server>[,<failoverhost>][<:3306>]/<database>
Tue Nov 28 15:35:55 BRST 2017 - INFO - Database not connected perhaps the schema doesnt exist yet
Before your (what it seems to be) default answer to this kind of problem: I've already tested this username, password, database name and host with command line tools and it works.


Scenario:

Ubuntu Linux 16.04.3
Oracle java version "1.8.0_151"
logicaldoc-installer-7.7.2.zip
MySQL is running on localhost
Database 'logicaldoc'
Username 'logicaldoc'
Password 'trialinstall'
The 'logicaldoc" database user is allowed to connect from anywhere (both 'logicaldoc'@'%' and 'logicaldoc'@'localhost')

I hope you can point me to a solution, since it seems to be what my company needs, I've configured with embedded database.

Re: LD 7.7.2 - Enterprise Ed - Database problems during install

Posted: Thu Nov 30, 2017 12:23 pm
by agaspa
Hi Lauro,
try to connect from the command line specifying also the port

Code: Select all

mysql -u USERNAME -p"PASSWORD" -P 3306 DBNAME
Otherwise another option is to pass to the installer the root credentials of MySQL, in that way it will also provide the creation of the database schema