Page 1 of 1

postgresql 14 jdbc connection string during setup

Posted: Thu Nov 04, 2021 4:24 pm
by djangoxl
I have installed logicaldoc community edition but when doing the setup, I am not sure the jdbc connection string is ok.

I have written this: jdbc:postgresql:[<//192.168.0.121>[<:5432>/]]<logicaldoc>

But the setyp won't proceed as it gives internal error 500.

Can someone who knows postgres verify that the connection string given by me is valid?

Re: postgresql 14 jdbc connection string during setup

Posted: Tue Nov 30, 2021 9:36 am
by agaspa
The problem is that the driver used by LogicalDOC community 8.6.1 is not 100% compatible with PostgreSQL 14.
That driver is only compatible with PostgreSQL 11
You can setup your PostgreSQL 14 to run with password authentication = md5 and in that way you will be able to operate
https://www.postgresql.org/docs/14/auth-password.html

Or you can simply switch the java library of the driver to a newer version (ex. 42.3.1) and then run again the setup from the web-interface
https://jdbc.postgresql.org/download.html