Jira (PDB-4509) Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

[Scot Kreienkamp (JIRA)]

Scot Kreienkamp commented on PDB-4509

Re: Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8" Manual steps ran: createuser -DRSP puppetdb createdb -E UTF8 -O puppetdb puppetdb psql puppetdb -c 'create extension pg_trgm' As a troubleshooting step I configured puppetdb to connect using the postgres user. No change. Add Comment

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

[Austin Blatt (JIRA)]

Austin Blatt updated an issue

PuppetDB / PDB-4509

Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Change By: Austin Blatt Team: PuppetDB Summary: Puppetdb 6.5, PG9.6.15, fresh Fresh install of puppetdb service will not start ERROR: invalid byte sequence for encoding "UTF8" Method Found: Needs Assessment Customer Feedback

Add Comment

[Austin Blatt (JIRA)]

Austin Blatt commented on PDB-4509

Re: Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8" Scot Kreienkamp it seems like this is not the first time someone has hit it, and this Puppet Users thread has the same error that your encountered, but alas, no resolution. But we can start off where they were. Can you attach the output of psql -c '\l+'?

Add Comment

[Scot Kreienkamp (JIRA)]

Scot Kreienkamp updated an issue

PuppetDB / PDB-4509

Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Change By: Scot Kreienkamp Attachment: Capture.PNG

Add Comment

[Scot Kreienkamp (JIRA)]

[Scot Kreienkamp (JIRA)]

Scot Kreienkamp commented on PDB-4509

Re: Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8" It would be difficult to read due to the formatting so I put in a screenshot of it.

Add Comment

[Scot Kreienkamp (JIRA)]

Scot Kreienkamp updated an issue

PuppetDB / PDB-4509

Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Change By: Scot Kreienkamp Attachment: psql -l output.PNG

Add Comment

[Scot Kreienkamp (JIRA)]

Scot Kreienkamp commented on PDB-4509

Re: Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8" That thread was me when I was trying to set up PuppetDB the first time around on the server I'm now trying to replace... I switched from Oracle Linux to Redhat Linux and it magically worked. I never knew why, which is why I never posted a resolution. This time I started with RH thinking that I wouldn't see that problem again only to have it resurface. These are very vanilla installs of RHEL7 and PuppetDB, was then and is now. That's what has me puzzled.

Add Comment

[Scot Kreienkamp (JIRA)]

Scot Kreienkamp commented on PDB-4509

Re: Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Figured it out... went back and compared all the database settings in the old server and the new server, and one settings change broke it: standard_conforming_strings = off That's in our standard postgres template because one of our primary internal applications requires it. Once I changed that to on it worked fine. Maybe a check could be added before the migrations that outputs an error message if that setting is off?

Add Comment

[Austin Blatt (JIRA)]

Austin Blatt commented on PDB-4509

Re: Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Scot Kreienkamp that's awesome, yes! We will definitely add a check for this since we've been stumped by it at least a couple of times.

Add Comment

[Austin Blatt (JIRA)]

Austin Blatt assigned an issue to Austin Blatt

PuppetDB / PDB-4509

Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Change By: Austin Blatt Assignee: Austin Blatt

Add Comment

[Austin Blatt (JIRA)]

Austin Blatt updated an issue

PuppetDB / PDB-4509 Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Change By: Austin Blatt Fix Version/s: PDB 6.3.5 Fix Version/s: PDB 5.2.10 Fix Version/s: PDB 6.7.1

Add Comment

[Austin Blatt (JIRA)]

Austin Blatt updated an issue

PuppetDB / PDB-4509 Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Change By: Austin Blatt Release Notes: Bug Fix Not Needed

Add Comment

[Austin Blatt (JIRA)]

Austin Blatt updated an issue

PuppetDB / PDB-4509 Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Change By: Austin Blatt Release Notes Summary: PuppetDB migrations require the postgres database the setting `standard_conforming_strings` to be `true`. Before a Postgres exception would terminate startup, now we will verify that setting before checking if migrations are necessary. Release Notes: Not Needed Bug Fix

Add Comment

[Austin Blatt (JIRA)]

Austin Blatt updated an issue

PuppetDB / PDB-4509 Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Change By: Austin Blatt Release Notes Summary: PuppetDB migrations require the postgres database the setting `standard_conforming_strings` to be `true`. Before a Postgres exception would terminate startup, now we will verify that setting before checking if any migrations are necessary.

Add Comment

[Heston Hoffman (JIRA)]

Heston Hoffman updated an issue

PuppetDB / PDB-4509 Fresh install of puppetdb will not start ERROR: invalid byte sequence for encoding "UTF8"

Change By: Heston Hoffman Labels: resolved-issue-added

Add Comment