Open Source Document Management

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

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:
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

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

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 !

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

ok now it's Running, i know that AlfaRomeo can do this!! thanx