Would it be possible to extend the configuration parameters necessary to
get ‘dbsslkey’, etc for config.php? I’d really like a pg_hba entry that looks like this:
hostssl nextcloud nextcloud 0.0.0.0/0 cert
Already working with my client (ex. - psql (10.3) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384 )
The config parameters are simply passed to the PDO DSN from the host string, so your nextcloud config would need something that looked like this:
‘dbhost’ => ‘127.0.0.1:5432;sslmode=verify-full;sslcert=~/.postgresql/postgresql.crt;sslkey=~/.postgresql/postgresql.key;sslrootcert=~/.postgresql/root.crt’
Sorry for bumping this topic. I am trying to connect my Nextcloud instance to a manated postgresql 12 database in DigitalOcean. Connection is done only via SSL.