I was attempting(required) to connect to postgres using a secure connection.
I had already read the postgres docs and am having no luck.
I created server.crt on postgres machine and imported this into openfire’s jre/security/cacerts keystore
I created client.crt on jabber and dropped this into the postgres data directory.
I was getting the following error on postgres:
“could not accept SSL connection: sslv3 alert certificate unknown”
The quick(and hacky) fix for this was to change the openfire.xml parameter serverURL to not validate certs:
I am now getting a new error on openfire:
java.io.IOException: Error on line 41 of document : The reference to entity “sslfactory” must end with the ‘;’ delimiter. Nested exce
ption: The reference to entity “sslfactory” must end with the ‘;’ delimiter.