Installation process refusing to connect to MySQL

[geotux2zeus]

Hi,

I've read many posts on this forum about what appears to be a common problem. However, the documentation are not really helping with the issue.

Like many others, I'm getting the following:

Validation failed:
Database not connected

I go and check the install.log file and I see many of the same error:

at Nov 11 21:56:11 GMT 2017 - INFO - Setup BEGINS
Sat Nov 11 21:56:11 GMT 2017 - INFO - Checking the existence of /opt/LogicalDOC-Community/conf/context.properties
Sat Nov 11 21:57:13 GMT 2017 - INFO - Validating connection to jdbc:mysql://192.168.2.2:3306/logicaldoc
Sat Nov 11 21:57:13 GMT 2017 - INFO - Database not connected perhaps the schema doesnt exist yet
Sat Nov 11 21:57:13 GMT 2017 - INFO - Validating connection to jdbc:mysql://192.168.2.2:3306
Sat Nov 11 21:57:13 GMT 2017 - INFO - Database not connected perhaps the schema doesnt exist yet

I've created the 'logicaldoc' database and granted priviliges to the 'logicaldoc' user. In fact, on by debian machine I can connect with no problem to this database via bash terminal. So this is NOT a mysql problem. I can easily operate on the 'logicaldoc' database without problems, whether I am the logicaldoc mysql user (in whic case I only see one database with no tables) or whether I login as the mysql root user.

I'm running the LogicalDOC installation as root to prevent issues around pribiliges but I'm finding it really frustrating that I cannot debug this. The mysql logs show not error at all and I'm definitely passing the right arguements to the installer.

171111 21:26:33 InnoDB: 5.5.58 started; log sequence number 74107294
171111 21:26:33 [Note] Server hostname (bind-address): '192.168.2.2'; port: 3306
171111 21:26:33 [Note] - '192.168.2.2' resolves to '192.168.2.2';
171111 21:26:33 [Note] Server socket created on IP: '192.168.2.2'.
171111 21:26:33 [Note] Event Scheduler: Loaded 0 events
171111 21:26:33 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.58-0+deb7u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)

User Data
──────────────────────────────────────────────────────────────────────────────────────────────────

Database

Username [root]

Password
*********
Server name/IP [192.168.2.2]

Server port [3306]

Database [logicaldoc]

Instance []

[ ] Manual specification of the database connection URL
Enter 1 to select, 0 to deselect:
1

Input 1(Next), 2(Exit), 3(once again show):
1
Validation failed:
Database not connected

Input 1(See Again), 2(Exit):


Any suggestions on next steps? What can I do to debug this properly?

Thanks

[agaspa]

Try to validate the connection by connecting to the server from the command-line.
Note: if you're using an online server (on a different IP) please check that remote connection is available for root user (usually it is forbidden)