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
Installation process refusing to connect to MySQL
Moderator: car031
Post
Re: Installation process refusing to connect to MySQL
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)
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)
Who is online
Users browsing this forum: No registered users and 35 guests