Jira (PDB-4625) puppetdb ssl connection to postgresql broken

[Paladox (JIRA)]

Paladox created an issue

PuppetDB / PDB-4625 puppetdb ssl connection to postgresql broken Issue Type: Bug Affects Versions: PDB 6.8.0 Assignee: Unassigned Components: PuppetDB Created: 2020/01/15 6:21 PM Environment: Debian 10 Priority: Critical Reporter: Paladox Upgrading from 6.7 to 6.8 caused ssl connection issues with postgresql, from what i could see in the logs it said:   puppetdb:   2020-01-16T01:59:09.295Z ERROR [p.p.c.services] Will retry database connection after temporary failure: java.sql.SQLTransientConnectionException: PDBMigrationsPool - Connection is not available, request timed out after 3000ms.   postgresql:   2020-01-16 01:56:41 GMT LOG:  could not accept SSL connection: Success   Downgrading back to 6.7 worked. Add Comment

This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93)

[Paladox (JIRA)]

Paladox commented on PDB-4625

Re: puppetdb ssl connection to postgresql broken The postgresql version is 9.6+181+deb9u3 running on debian 9

Add Comment

[Paladox (JIRA)]

Paladox commented on PDB-4625

Re: puppetdb ssl connection to postgresql broken

Could this https://github.com/puppetlabs/puppetdb/commit/2a43a1057ab8dcd8354d06f3d221313c50669c12 have broken it?

Add Comment

[Paladox (JIRA)]

Paladox commented on PDB-4625

Re: puppetdb ssl connection to postgresql broken

Bump

Add Comment

[Paladox (JIRA)]

Paladox updated an issue

PuppetDB / PDB-4625

puppetdb ssl connection to postgresql broken

Change By: Paladox Affects Version/s: PDB 6.8.1 Environment: Debian Stretch (9) and Debian Buster ( 10 ) Master OS: Other Agent OS: Other

Add Comment

[Paladox (JIRA)]

Paladox updated an issue

PuppetDB / PDB-4625 puppetdb ssl connection to postgresql broken

Change By: Paladox Affects Version/s: PDB 6.9.0

Add Comment

[Paladox (JIRA)]

Paladox updated an issue

PuppetDB / PDB-4625 puppetdb ssl connection to postgresql broken

Change By: Paladox Priority: Critical Major

Upgrading from 6.7 to 6.8 caused ssl connection issues with postgresql, from what i could see in the logs it said:   puppetdb:   2020-01-16T01:59:09.295Z ERROR [p.p.c.services] Will retry database connection after temporary failure: java.sql.SQLTransientConnectionException: PDBMigrationsPool - Connection is not available, request timed out after 3000ms.

postgresql logs show :

" 2020-01-16 01:56:41 GMT LOG:  could not accept SSL connection: Success "   Downgrading back to 6.7 worked.

Add Comment

[Vincent Magnin (Jira)]

Vincent Magnin commented on PDB-4625

Re: puppetdb ssl connection to postgresql broken Hello,   I was facing the same issue on a fresh install of puppetdb 6.9.2 on Centos8, with postgresql 10.6 Following https://tickets.puppetlabs.com/browse/PDB-4579 I've done the workaround provided here : https://tickets.puppetlabs.com/browse/PDB-4678   Which has solved the issue, but need to remove the java keystore until postgresql driver rework (according comment on PDB-4579)   Regards

Add Comment

This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935)

[David McTavish (Jira)]

David McTavish updated an issue

PuppetDB / PDB-4625

puppetdb ssl connection to postgresql broken

Change By: David McTavish Sprint: HAHA/Grooming

Add Comment

This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d)