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
LogicalDoc need to try - but no DB Connection
Moderator: car031
- admin
- Site Admin
Post
Re: LogicalDoc need to try - but no DB Connection
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
/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
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
Post
Re: LogicalDoc need to try - but no DB Connection
Thanks for your answer, yes add your parameter
/LogicalDOC-Community/conf# cat context.properties | grep jdbc.url
/LogicalDOC-Community/conf# cat context.properties | grep jdbc.url
Please see also this from = /LogicalDOC-Community/repository/docs/logs/jdbc.url=jdbc:mysql://192.168.1.250:3306/logicaldoc?useSSL=false&allowPublicKeyRetrieval=true
please watch my picture, thanks06.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.)
- Attachments
-
- logicaldoc.gif (33.79 KiB) Viewed 13204 times
Last edited by AlfaRomeo on Wed Sep 08, 2021 9:32 am, edited 1 time in total.
Post
Re: LogicalDoc need to try - but no DB Connection
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 !
# 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 !
Post
Re: LogicalDoc need to try - but no DB Connection
finaly i have this error, i thin this are a major one:
thanks for any update.
regards AlfaRomeo
and i'am not shure if this are in trouble with mysql 8.0.26?>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.)
thanks for any update.
regards AlfaRomeo
Post
Re: LogicalDoc need to try - but no DB Connection
ok now it's Running, i know that AlfaRomeo can do this!! thanx
- Attachments
-
- Logicaldoc Finish.gif (19.96 KiB) Viewed 13148 times
Who is online
Users browsing this forum: No registered users and 1 guest