Hi,
I did not do anything differently really. I switched to use another computer
that does not use our company proxy, and then I gave the right details for
creating a new PostGIS connection. Both actions were compulsory and nothing to
do with the sslmode.
By reading https://www.postgresql.org/docs/9.1/libpq-ssl.html it seems that
using "sslmode=require" is not a demand set by the database server but
PostgreSQL client can set it and ask the server to send data encrypted. Perhaps
our database experts can say if using encrypted connection would require some
extra configuration on OpenJUMP side and installation of some certificates and
keys.
I guess that for making it possible to select the sslmode with OpenJUMP we
should add a new item into the connection menu and also into the schema of the
PostgisDataStoreDriver that nowadays looks like thin in the workbench-state.xml:
postgis
com.vividsolutions.jump.datastore.postgis.PostgisDataStoreDriver
Server
Port
Database
User
Password
java.lang.String
java.lang.Integer
java.lang.String
java.lang.String
java.lang.String
User
user
Server
localhost
Port
5432
Database
Password
-Jukka-
-Alkuperäinen viesti-
Lähettäjä: edgar.sol...@web.de
Lähetetty: maanantai 7. lokakuuta 2019 13.19
Vastaanottaja: jump-pilot-devel@lists.sourceforge.net
Aihe: Re: [JPP-Devel] Can we connect PostGIS with SSL?
just for the archive. what did you do different in order to have it working?
..ede
On 07.10.2019 01:55, Rahkonen Jukka (MML) wrote:
> Hi,
>
> I managed to make a connection but I am not sure if sslmode=require is used
> or not. GDAL seems to connect QGIS cloud db with or without using that option
> in the connection string.
>
> -Jukka-
>
> Lähettäjä: Rahkonen Jukka (MML)
> Lähetetty: maanantai 7. lokakuuta 2019 2.21
> Vastaanottaja: OpenJump develop and use
> (jump-pilot-devel@lists.sourceforge.net)
>
> Aihe: [JPP-Devel] Can we connect PostGIS with SSL?
>
> Hi,
>
> I created a database into QGIS cloud and tried to connect it with OpenJUMP
> with no success. I wonder if it is because QGIS cloud requires SSL connection
> https://support.qgiscloud.com/kb/faq.php?id=4. Does anyone know how to make
> OpenJUMP to use sslmode=require when making a connection with PostGIS?
>
> -Jukka Rahkonen-
>
>
>
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel