Re: postgresql jndi datasource with certificate authentication?

2019-10-26 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Felix, On 10/26/19 16:37, Felix Schumacher wrote: > > Am 22.10.19 um 20:07 schrieb Magosányi Árpád: >> Thank you all for the suggestions. >> >> Based on the documentation, my setup should work: The server >> certificate is already processed and

Re: postgresql jndi datasource with certificate authentication?

2019-10-26 Thread Felix Schumacher
Am 22.10.19 um 20:07 schrieb Magosányi Árpád: > Thank you all for the suggestions. > > Based on the documentation, my setup should work: The server certificate > is already processed and accepted (I know that because I could not get > it right at the first try). The driver is supposed to work

Re: postgresql jndi datasource with certificate authentication?

2019-10-22 Thread Magosányi Árpád
Thank you all for the suggestions. Based on the documentation, my setup should work: The server certificate is already processed and accepted (I know that because I could not get it right at the first try). The driver is supposed to work with a PEM certificate and a pkcs-8 DER encoded key, and

Re: postgresql jndi datasource with certificate authentication?

2019-10-22 Thread Christopher Schultz
Arpad, On 10/22/19 12:19, logo wrote: I have the following in context.xml: url="jdbc:postgresql://infra.kodekonveyor.com:5432/users?ssl=truesslmode=verify-ca" username="market" maxTotal="20" maxIdle="10" maxWaitMillis="-1"/> I have this in

Re: postgresql jndi datasource with certificate authentication?

2019-10-22 Thread logo
Magosányi Árpád: Hi! Anyone have a postgresql jndi datasource with certificate authentication working? I have the following in context.xml: url="jdbc:postgresql://infra.kodekonveyor.com:5432/users?ssl=truesslmode=verify-ca" username="market&

Re: postgresql jndi datasource with certificate authentication?

2019-10-22 Thread Christopher Schultz
nnection c = DriverManager.getConnection(sb.toString()); and convert the pem certificate to JKS/P12 ? I have this working in mysql... Peter Am 2019-10-22 12:56, schrieb Magosányi Árpád: Hi! Anyone have a postgresql jndi datasource with certificate authentication working? I have the following in co

Re: postgresql jndi datasource with certificate authentication?

2019-10-22 Thread Magosányi Árpád
rePassword=changeit"); > >     Connection c = DriverManager.getConnection(sb.toString()); > > and convert the pem certificate to JKS/P12 ? I have this working in > mysql... > > Peter > > Am 2019-10-22 12:56, schrieb Magosányi Árpád: >> Hi! >> >>

Re: postgresql jndi datasource with certificate authentication?

2019-10-22 Thread logo
22 12:56, schrieb Magosányi Árpád: Hi! Anyone have a postgresql jndi datasource with certificate authentication working? I have the following in context.xml:     I have this in ~tomcat/.postgresql: root@market:/var/lib/tomcat9/.postgresql# ls -lL total 11 -rw-r--r-- 1 root   root 4597 Oct 21 12:49

postgresql jndi datasource with certificate authentication?

2019-10-22 Thread Magosányi Árpád
Hi! Anyone have a postgresql jndi datasource with certificate authentication working? I have the following in context.xml:     I have this in ~tomcat/.postgresql: root@market:/var/lib/tomcat9/.postgresql# ls -lL total 11 -rw-r--r-- 1 root   root 4597 Oct 21 12:49 postgresql.crt -r