LogicalDoc need to try - but no DB Connection

Problems with installing LogicalDOC? No problems, the solution is closer than you think.

Moderator: car031

AlfaRomeo
Posts: 10
Joined: Mon Sep 06, 2021 7:34 am

LogicalDoc need to try - but no DB Connection

Mon Sep 06, 2021 7:48 am

Hello Members
Here iam running with Debian 10 installed all requirements like mysql, java, LibreOffice and gs and so...
- LogicalDOC-CE 8.6.1 (2021-04-15; logicaldoc-8.6.1)

The installation are running fine.... i see only one error:
execurte sql file sql/logicaldoc-core.sql.mysql
unable to import data
the following error occured while executing this line
logicaldoc-community/load/build.xml:74: java.sql.,SQLException: No suitable Driver for"


MYSQL DB are also try to add manual like our description but withour change.
https://docs.logicaldoc.com/en/installa ... base-linux

after browwsing localhost 8080
no Connection to Database

i see this error are most known here please exisit here any little help?
thanks
admin
Site Admin
Posts: 37
Joined: Mon Apr 19, 2010 2:20 pm

Re: LogicalDoc need to try - but no DB Connection

Mon Sep 06, 2021 10:20 am

If the installation is completed and you still see the error open the main configuration of logicaldoc
/Logicaldoc/conf/context.properties

edit the value of property jdbc.url and add the parameters useSSL=false&allowPublicKeyRetrieval=true

example:

Code: Select all

jdbc.url=jdbc:mysql://localhost:3306/logicaldoc?useSSL=false&allowPublicKeyRetrieval=true
then restart LogicalDOC

Note #1: check that the database schema logicaldoc is created and there are tables inside
if the schema is present but there are no tables launch again the setup procedure
http://localhost:8080/setup

use admin/admin as creadentials
AlfaRomeo
Posts: 10
Joined: Mon Sep 06, 2021 7:34 am

Re: LogicalDoc need to try - but no DB Connection

Mon Sep 06, 2021 10:41 am

Thanks for your answer, yes add your parameter

/LogicalDOC-Community/conf# cat context.properties | grep jdbc.url
jdbc.url=jdbc:mysql://192.168.1.250:3306/logicaldoc?useSSL=false&allowPublicKeyRetrieval=true
Please see also this from = /LogicalDOC-Community/repository/docs/logs/
06.09.2021 11:54:49,143 ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper: 131) -- Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
please watch my picture, thanks
Attachments
logicaldoc.gif
logicaldoc.gif (33.79 KiB) Viewed 12243 times
Last edited by AlfaRomeo on Wed Sep 08, 2021 9:32 am, edited 1 time in total.
AlfaRomeo
Posts: 10
Joined: Mon Sep 06, 2021 7:34 am

Re: LogicalDoc need to try - but no DB Connection

Tue Sep 07, 2021 8:17 am

LogicalDOC-CE 8.6.1 (2021-04-15; logicaldoc-8.6.1)

# java -version
openjdk version "11.0.12" 2021-07-20
OpenJDK Runtime Environment (build 11.0.12+7-post-Debian-2)
OpenJDK 64-Bit Server VM (build 11.0.12+7-post-Debian-2, mixed mode, sharing)

# echo $JAVA_HOME
/usr/lib/jvm/java-11-openjdk-amd64

--
mysql
-utf8
-IMMODB
-PORT
-bind-address 0.0.0.0
--
[Snip from LogicalDOC-CE 8.6.1 - installation]
Database
JDBC URL [jdbc:mysql://192.168.1.9:3306/logicaldoc?useSSL=false&allowPublicKeyRetrieval=true]

Username root
Password password

Press 1 to continue
1
Validation failed:
Database not connected


--

# mysql -uroot -ppassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 8.0.26 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+----------+
| Database |
+----------+
| logicaldoc |
+----------+
5 rows in set (0.01 sec)

--
mysql-community-server 8.0.26-1debian11 amd64 MySQL Server

mysql.log

2021-09-07T06:52:40.388010Z, 14 Connect root@AD.Caloro.M on logicaldoc using TCP/IP
2021-09-07T06:52:40.442671Z, 15 Connect root@AD.Caloro.M on using TCP/IP
2021-09-07T06:52:40.449386Z, 15 Query /* mysql-connector-java-8.0.18 (Revision: fef2894d751d47223192b706977b4a5bc41e6be4) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@performance_schema AS performance_schema, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout


meny thanks for any possile update !
AlfaRomeo
Posts: 10
Joined: Mon Sep 06, 2021 7:34 am

Re: LogicalDoc need to try - but no DB Connection

Tue Sep 07, 2021 1:09 pm

finaly i have this error, i thin this are a major one:
>07.09.2021 14:01:14,957 ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper: 131) -- Cannot create PoolableConnectionFactory (Communications link failure

>The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
and i'am not shure if this are in trouble with mysql 8.0.26?
thanks for any update.

regards AlfaRomeo
AlfaRomeo
Posts: 10
Joined: Mon Sep 06, 2021 7:34 am

Re: LogicalDoc need to try - but no DB Connection

Tue Sep 07, 2021 2:03 pm

ok now it's Running, i know that AlfaRomeo can do this!! thanx :-)
Attachments
Logicaldoc Finish.gif
Logicaldoc Finish.gif (19.96 KiB) Viewed 12187 times

Return to “Installation”

Who is online

Users browsing this forum: No registered users and 6 guests