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: <item class="com.vividsolutions.jump.workbench.datastore.ConnectionDescriptor"> <name>postgis</name> <dataStoreDriverClassName>com.vividsolutions.jump.datastore.postgis.PostgisDataStoreDriver</dataStoreDriverClassName> <parameterList> <schema> <name>Server</name> <name>Port</name> <name>Database</name> <name>User</name> <name>Password</name> <class>java.lang.String</class> <class>java.lang.Integer</class> <class>java.lang.String</class> <class>java.lang.String</class> <class>java.lang.String</class> </schema> <nameToValueMap class="java.util.HashMap"> <mapping> <key class="java.lang.String">User</key> <value class="java.lang.String">user</value> </mapping> <mapping> <key class="java.lang.String">Server</key> <value class="java.lang.String">localhost</value> </mapping> <mapping> <key class="java.lang.String">Port</key> <value class="java.lang.Integer">5432</value> </mapping> <mapping> <key class="java.lang.String">Database</key> <value class="java.lang.String">xxxx</value> </mapping> <mapping> <key class="java.lang.String">Password</key> <value class="java.lang.String">yyyy</value> </mapping> </nameToValueMap> </parameterList> </item> -Jukka- -----Alkuperäinen viesti----- Lähettäjä: edgar.sol...@web.de <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) <jukka.rahko...@maanmittauslaitos.fi> > Lähetetty: maanantai 7. lokakuuta 2019 2.21 > Vastaanottaja: OpenJump develop and use > (jump-pilot-devel@lists.sourceforge.net) > <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
