pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedAw: BUG #17647: 12.12 package has difference on ubuntu 18.04
2+ messages / 2 participants
[nested] [flat]
* Aw: BUG #17647: 12.12 package has difference on ubuntu 18.04
@ 2022-10-18 08:19 Mike Fröhner <mikefroehner@gmx.de>
0 siblings, 1 reply; 2+ messages in thread
From: Mike Fröhner @ 2022-10-18 08:19 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/vnd.ui.insecure+html;charset=utf-8">
</head>
<body style="overflow-wrap:break-word; word-break: break-word;"><div class="mail_android_message" style="line-height: 1; padding: 0.5em">Hello<br/><br/>I have made some deeper investigation:<br/><br/>Steps to reproduce:<br/><br/>```<br/>docker pull ubuntu:18.04 && docker run -it --rm ubuntu:18.04 bash<br/>## or<br/>docker pull ubuntu:20.04 && docker run -it --rm ubuntu:20.04 bash<br/>## or<br/>docker pull ubuntu:22.04 && docker run -it --rm ubuntu:22.04 bash<br/><br/><br/>apt-get update<br/>apt-get install -y vim strace less curl ca-certificates gnupg sudo lsb-release<br/><br/>curl <a href="https://www.postgresql.org/media/keys/ACCC4CF8.asc">https://www.postgresql.org/media/keys/ACC...; | gpg --dearmor | sudo tee /etc/apt/<a href="http://trusted.gpg">trusted.gpg</a>.d/<a href="http://apt.postgresql.org.gpg">apt.postgresql.org.gpg</a; >/dev/null<br/><br/>sh -c 'echo "deb <a href="http://apt.postgresql.org/pub/repos/apt">http://apt.postgresql.org/pub/repos/apt</a; $(lsb_release -cs)-pgdg main" > /etc/apt/<a href="http://sources.list">sources.list</a>.d/<a href="http://pgdg.list">pgdg.list</a>'<br/>apt-get update<br/>apt-get install -y postgresql-12<br/><br/>pg_ctlcluster 12 main start<br/><br/>sudo -u postgres -i<br/>psql<br/>CREATE DATABASE database_name;<br/>CREATE USER my_username WITH PASSWORD 'my_password';<br/>GRANT ALL PRIVILEGES ON DATABASE "database_name" to my_username;<br/>exit<br/><br/>echo '*:*:*:my_username:my_password' > .pgpass<br/>chmod 0600 .pgpass<br/>exit<br/><br/>##<br/>## this does not work for ubuntu 18.04 but for ubuntu 20.04/22.04<br/>##<br/>/usr/bin/sudo -u postgres psql -U my_username -h <a href="http://127.0.0.1">127.0.0.1</a; database_name -c "CREATE TABLE foo (foo char);"<br/><br/>##<br/>## this works for all<br/>##<br/>sudo -u postgres -i<br/>psql -U my_username -h <a href="http://127.0.0.1">127.0.0.1</a; database_name -c "CREATE TABLE foo (foo char);"<br/>```<br/><br/>We have narrowed it down to three packages which have been upgraded on ubuntu 18.04 between working and broken state:<br/>- `libpq5` upgraded from `14.5-1.pgdg18.04+1` to `15.0-1.pgdg18.04+1`<br/>- `postgresql-client-common` and `postgresql-common` from `243.pgdg18.04+1` to `244.pgdg18.04+1`<br/><br/>None other packages have been upgraded (incl. ubuntu repo packages)!<br/><br/>For me it does look like a bug with in psql client package.<br/><br/>regards<br/>Mike<br/><br/>--<br/>Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.</div><div class="mail_android_quote" style="line-height: 1; padding: 0.3em"><html><body>Am 17.10.22, 16:19 schrieb PG Bug reporting form <noreply@postgresql.org>:</body></html><blockquote class="gmail_quote" style="margin: 0.8ex 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
The following bug has been logged on the website:
<br>
<br> Bug reference: 17647
<br> Logged by: Mike Fröhner
<br> Email address: mikefroehner@gmx.de
<br> PostgreSQL version: 12.12
<br> Operating system: Ubuntu 18.04
<br> Description:
<br>
<br> Hello,
<br>
<br> today our CI noticed the upgrade of PostgreSQL to 12.12. We have a CI/CD
<br> which tests our Puppet Module against Ubuntu 16./18./20./22.04. We run
<br> different tests (kitchen-ci) including the following:
<br> ```
<br> describe command('/usr/bin/sudo -u postgres psql -U myuser1 -h 127.0.0.1
<br> mydb1 -c "CREATE TABLE foo (foo char);"') do
<br> its('exit_status') { should eq 0 }
<br> its('stdout') { should eq "CREATE TABLE\n" }
<br> its('stderr') { should eq '' }
<br> end
<br> ```
<br> Therefore we rollout a DB and a user via:
<br> ```
<br> postgresql::databases:
<br> 'mydb1':
<br> user: myuser1
<br> password: mypassword1
<br> host: 127.0.0.1/32
<br> ```
<br> We also rollout a file:
<br> ```
<br> '/var/lib/postgresql/.pgpass':
<br> owner: postgres
<br> group: postgres
<br> mode: '0600'
<br> content: '*:*:*:myuser1:mypassword1'
<br> require_class: postgresql
<br> ```
<br> This test only fails/times out on Ubuntu 18.04 because it is waiting for a
<br> password input. With all other Ubuntu (16./20./22.04) this test succedds. Is
<br> there anything wrong with my test or is the package for Ubuntu 18.04 broken?
<br>
<br>
</blockquote></div></body>
</html>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Aw: BUG #17647: 12.12 package has difference on ubuntu 18.04
@ 2022-10-18 12:44 Julien Rouhaud <rjuju123@gmail.com>
parent: Mike Fröhner <mikefroehner@gmx.de>
0 siblings, 0 replies; 2+ messages in thread
From: Julien Rouhaud @ 2022-10-18 12:44 UTC (permalink / raw)
To: Mike Fröhner <mikefroehner@gmx.de>; +Cc: pgsql-bugs@lists.postgresql.org
Hi,
On Tue, Oct 18, 2022 at 10:19:20AM +0200, Mike Fröhner wrote:
>
> <html>
> <head>
> <meta name="viewport" content="width=device-width">
> <meta http-equiv="Content-Type" content="text/vnd.ui.insecure+html;charset=utf-8">
> </head>
> <body style="overflow-wrap:break-word; word-break: break-word;"><div class="mail_android_message" style="line-height: 1; padding: 0.5em">Hello<br/><br/>I have made some deeper investigation:<br/><br/>Steps to reproduce:<br/><br/>```<br/>docker pull ubuntu:18.04 && docker run -it --rm ubuntu:18.04 bash<br/>## or<br/>docker pull ubuntu:20.04 && docker run -it --rm ubuntu:20.04 bash<br/>## or<br/>docker pull ubuntu:22.04 && docker run -it --rm ubuntu:22.04 bash<br/><br/><br/>apt-get update<br/>apt-get install -y vim strace less curl ca-certificates gnupg sudo lsb-release<br/><br/>curl <a href="https://www.postgresql.org/media/keys/ACCC4CF8.asc">https://www.postgresql.org/media/keys/ACC...; | gpg --dearmor | sudo tee /etc/apt/<a href="http://trusted.gpg">trusted.gpg</a>.d/<a href="http://apt.postgresql.org.gpg">apt.postgresql.org.gpg</a; >/dev/null<br/><br/>sh -c 'echo "deb <a href="http://apt.postgresql.org/pub/repos/apt">http://apt.postgresql.org/pub/repos/apt</a; $(lsb_release -cs)-pgdg main" > /etc/apt/<a href="http://sources.list">sources.list</a>.d/<a href="http://pgdg.list">pgdg.list</a>'<br/>apt-get update<br/>apt-get install -y postgresql-12<br/><br/>pg_ctlcluster 12 main start<br/><br/>sudo -u postgres -i<br/>psql<br/>CREATE DATABASE database_name;<br/>CREATE USER my_username WITH PASSWORD 'my_password';<br/>GRANT ALL PRIVILEGES ON DATABASE "database_name" to my_username;<br/>exit<br/><br/>echo '*:*:*:my_username:my_password' > .pgpass<br/>chmod 0600 .pgpass<br/>exit<br/><br/>##<br/>## this does not work for ubuntu 18.04 but for ubuntu 20.04/22.04<br/>##<br/>/usr/bin/sudo -u postgres psql -U my_username -h <a href="http://127.0.0.1">127.0.0.1</a; database_name -c "CREATE TABLE foo (foo char);"<br/><br/>##<br/>## this works for all<br/>##<br/>sudo -u postgres -i<br/>psql -U my_username -h <a href="http://127.0.0.1">127.0.0.1</a; database_name -c "CREATE TABLE foo (foo char);"<br/>```<br/><br/>We have narrowed it down to three packages which have been upgraded on ubuntu 18.04 between working and broken state:<br/>- `libpq5` upgraded from `14.5-1.pgdg18.04+1` to `15.0-1.pgdg18.04+1`<br/>- `postgresql-client-common` and `postgresql-common` from `243.pgdg18.04+1` to `244.pgdg18.04+1`<br/><br/>None other packages have been upgraded (incl. ubuntu repo packages)!<br/><br/>For me it does look like a bug with in psql client package.<br/><br/>regards<br/>Mike<br/><br/>--<br/>Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.</div><div class="mail_android_quote" style="line-height: 1; padding: 0.3em"><html><body>Am 17.10.22, 16:19 schrieb PG Bug reporting form <noreply@postgresql.org>:</body></html><blockquote class="gmail_quote" style="margin: 0.8ex 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
You should configure your MUA to send plaintext too and not only html, as some
people can't (and don't want to) read html-only emails. After reading it on
the html archives, I'm surprised to see that this would work at all on other
ubuntu versions, and it doesn't look like a bug in our code. sudo without -i
will look for the .pgpass in the wrong place:
# sudo -u postgres bash -c "echo \$HOME"
/root
# sudo -iu postgres bash -c "echo \$HOME"
/var/lib/postgresql
Do you get a different behavior for those commands on other ubuntu versions?
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-10-18 12:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-10-18 08:19 Aw: BUG #17647: 12.12 package has difference on ubuntu 18.04 Mike Fröhner <mikefroehner@gmx.de>
2022-10-18 12:44 ` Julien Rouhaud <rjuju123@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox