{"action":"created","issue":{"url":"https://api.github.com/repos/halestudio/hale/issues/67","repository_url":"https://api.github.com/repos/halestudio/hale","labels_url":"https://api.github.com/repos/halestudio/hale/issues/67/labels{/name}","comments_url":"https://api.github.com/repos/halestudio/hale/issues/67/comments","events_url":"https://api.github.com/repos/halestudio/hale/issues/67/events","html_url":"https://github.com/halestudio/hale/issues/67","id":165546975,"number":67,"title":"Support SSL connection to PostgreSQL/PostGIS","user":{"login":"bstroebl","id":2534601,"avatar_url":"https://avatars.githubusercontent.com/u/2534601?v=3","gravatar_id":"","url":"https://api.github.com/users/bstroebl","html_url":"https://github.com/bstroebl","followers_url":"https://api.github.com/users/bstroebl/followers","following_url":"https://api.github.com/users/bstroebl/following{/other_user}","gists_url":"https://api.github.com/users/bstroebl/gists{/gist_id}","starred_url":"https://api.github.com/users/bstroebl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bstroebl/subscriptions","organizations_url":"https://api.github.com/users/bstroebl/orgs","repos_url":"https://api.github.com/users/bstroebl/repos","events_url":"https://api.github.com/users/bstroebl/events{/privacy}","received_events_url":"https://api.github.com/users/bstroebl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-14T12:10:22Z","updated_at":"2016-07-14T13:22:01Z","closed_at":null,"body":"Our central PostgreSQL/PostGIS server requires users to connect using ssl. When trying to connect to it from Hale I receive this error:\r\n`org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host \"hostip\", user \"username\", database \"dbname\", SSL off`\r\nWhen entering the credentials there should be a choice of how to connect to the db. In e.g. QGIS these are the choices for SSL:\r\n- disable\r\n- allow\r\n- prefer\r\n- require\r\n\r\nmaybe disable and require are sufficient, could then be done with a checkbox `connect using SSL` defrault would be no"},"comment":{"url":"https://api.github.com/repos/halestudio/hale/issues/comments/232663436","html_url":"https://github.com/halestudio/hale/issues/67#issuecomment-232663436","issue_url":"https://api.github.com/repos/halestudio/hale/issues/67","id":232663436,"user":{"login":"bstroebl","id":2534601,"avatar_url":"https://avatars.githubusercontent.com/u/2534601?v=3","gravatar_id":"","url":"https://api.github.com/users/bstroebl","html_url":"https://github.com/bstroebl","followers_url":"https://api.github.com/users/bstroebl/followers","following_url":"https://api.github.com/users/bstroebl/following{/other_user}","gists_url":"https://api.github.com/users/bstroebl/gists{/gist_id}","starred_url":"https://api.github.com/users/bstroebl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bstroebl/subscriptions","organizations_url":"https://api.github.com/users/bstroebl/orgs","repos_url":"https://api.github.com/users/bstroebl/repos","events_url":"https://api.github.com/users/bstroebl/events{/privacy}","received_events_url":"https://api.github.com/users/bstroebl/received_events","type":"User","site_admin":false},"created_at":"2016-07-14T13:22:01Z","updated_at":"2016-07-14T13:22:01Z","body":"that worked out:\r\n\r\n`jdbc:postgresql://myserver:5432/dbname?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory`\r\n\r\nAs this is an internal server we do not issue an official certificate, hence the none-validating connection.\r\n\r\nI am doing my first steps in hale and thus was not aware of the possibility to directly enter a jdbc connection string in the URL tab, otherwise I might have found it myself as I already knew this jdbc expression can connect to our database.\r\n\r\nPlease close this ticket if you are not going to implement anything in the PostgreSQL/PostGIS tab."}}
{"actor":{"display_login":"bstroebl"}}