ODK Aggregate configure PostgreSQL for SSL


(Erik van der Neut) #1

I have installed ODK Aggregate on Tomcat on Windows server 2016, which is working.

I'm connecting with a PostgreSQL database on MS Azure that WAS configured to enforce SSL connections.

I had to disable this setting as I can't find where I can configure the PostgreSQL connection settings after installation to make KOBO Aggregate connect to Postgre over SSL.

I have not found any configuration file or anything that allows me to do this.

If someone could point me in the right direction?

Regards,

Erik


(Erik van der Neut) #2

OK, fixed it myself :grinning: Thanks to this topic: JSON change-password request to /ssl/user-manage-passwords failed

I found this post from @ggalmazor :

* Stop Tomcat
* Create a backup of the whole directory where Aggregate is deployed
* Unzip WEB-INF/lib/ODKAggregate-settings.jar into WEB-INF/classes
* Delete WEB-INF/lib/ODKAggregate-settings.jar << this is important
* Edit WEB-INF/classes/security.properties and set security.server.hostname with the IP address or hostname that the users will be using to access Aggregate
* Start Tomcat

There i found jdbc.properties in which the postgresql url is configured.

jdbc.url=jdbc:postgresql://sqlserver.mydomain.com/odk_prod?autoDeserialize=true

According to the documentation @ https://jdbc.postgresql.org/documentation/head/connect.html adding "?ssl=true" to the url should do the trick.

well, it did and ODKAggregate now connects to a postgresql database that enforces ssl connections.