Page 1 of 1

Validation failed: Database not connected

Posted: Fri Sep 29, 2017 4:22 pm
by baradhili
Hi all, got a puzzling one here..
running Debian Stretch with Mariadb 10
Mariadb is listing on 3306
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 598/mysqld

install runs normally but..
>>
Database

Username [root]
logicaldoc

Password
**

Server name/IP [localhost]
localhost

Server port [3306]
3306

Database [logicaldoc]
logicaldoc

Instance []


[x] 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?

Re: Validation failed: Database not connected

Posted: Fri Oct 13, 2017 10:15 am
by agaspa
1) Test the connection with MariaDB from the command line
https://mariadb.com/kb/en/library/mysql ... ne-client/

2) Try to connect using the IP instead of localhost
3) Check password and connection port 3306

Re: Validation failed: Database not connected

Posted: Fri Oct 13, 2017 1:16 pm
by baradhili
command line works fine

Re: Validation failed: Database not connected

Posted: Tue Oct 17, 2017 10:13 am
by admin
Hi baradhili,
I saw that you specified logicaldoc as a username for the database, but was this user has been crated into your database?
Can you log in using logicaldoc user from the command line?
This user (logicaldoc) has permissions to create database and tables or do you already created database logicaldoc?
If you're not sure give to the installer root credentials and it will create the database correctly.

Re: Validation failed: Database not connected

Posted: Tue Oct 17, 2017 11:04 am
by baradhili
Hi, yes Logicaldoc has full permissions on the database and has no problems logging in via mysql -u logicaldoc -p

Re: Validation failed: Database not connected

Posted: Tue Oct 17, 2017 1:45 pm
by admin
You should try to connect using all the information you passed to the installer:

Code: Select all

mysql -u logicaldoc -p"yourpassword" -P 3306 logicaldoc
See also
https://dev.mysql.com/doc/refman/5.7/en ... rvers.html
https://dev.mysql.com/doc/refman/5.7/en ... mysql_port

Re: Validation failed: Database not connected

Posted: Tue Oct 17, 2017 1:51 pm
by baradhili
I did, it does... but now I have switched to Nuxeo.. at least it installs