Your message dated Mon, 17 Oct 2022 20:39:29 +0000
with message-id <e1okwtv-0053zm...@fasolo.debian.org>
and subject line Bug#1021791: fixed in dbconfig-common 2.0.22
has caused the Debian Bug report #1021791,
regarding Testsuite needs updated permissions with PostgreSQL 15
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)


-- 
1021791: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1021791
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Source: redmine
Version: 5.0.2-2
Severity: serious

PostgreSQL 15 restricts the CREATE privilege on the default "public"
schema in each database to the database owner; previous all users were
allowed to create new objects.

redmine needs updating for this; one workaround for the testsuite
would be to "grant create on schema public to public;" to revert to
the old default.

https://ci.debian.net/data/autopkgtest/testing/arm64/r/redmine/27072176/log.gz

Setting up redmine (5.0.2-2) ...
Don't run Bundler as root. Bundler can ask for sudo if it is needed, and
installing your bundle as root will break this application for all non-root
users on this machine.
dbconfig-common: writing config to 
/etc/dbconfig-common/redmine/instances/default.conf
creating postgres user redmine/instances/default:  already exists.
resetting password:  success.
creating database redmine_default: already exists.
dbconfig-common: flushing administrative password
rake aborted!
ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR:  permission 
denied for schema public
LINE 1: CREATE TABLE "schema_migrations" ("version" character varyin...
                     ^
/usr/share/rubygems-integration/all/gems/activerecord-6.1.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:49:in
 `exec'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:49:in
 `block (2 levels) in execute'
/usr/share/rubygems-integration/all/gems/activesupport-6.1.7/lib/active_support/dependencies/interlock.rb:48:in
 `block in permit_concurrent_loads'
/usr/share/rubygems-integration/all/gems/activesupport-6.1.7/lib/active_support/concurrency/share_lock.rb:187:in
 `yield_shares'

(Possibly this might need fixing in dbconfig-common.)

Christoph

--- End Message ---
--- Begin Message ---
Source: dbconfig-common
Source-Version: 2.0.22
Done: Paul Gevers <elb...@debian.org>

We believe that the bug you reported is fixed in the latest version of
dbconfig-common, which is due to be installed in the Debian FTP archive.

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 1021...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Paul Gevers <elb...@debian.org> (supplier of updated dbconfig-common package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@ftp-master.debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Format: 1.8
Date: Mon, 17 Oct 2022 21:31:16 +0200
Source: dbconfig-common
Architecture: source
Version: 2.0.22
Distribution: unstable
Urgency: medium
Maintainer: Paul Gevers <elb...@debian.org>
Changed-By: Paul Gevers <elb...@debian.org>
Closes: 1010923 1021791
Changes:
 dbconfig-common (2.0.22) unstable; urgency=medium
 .
   [ Debian Janitor ]
   * Remove constraints unnecessary since buster
 .
   [ Paul Gevers ]
   * make postgresql user the owner of the database; postgresql changed its
     default for write access to databases (Closes: #1010923, #1021791)
Checksums-Sha1:
 0e6da1f4febb6c1db4997313801af1166b87e92e 1918 dbconfig-common_2.0.22.dsc
 5c479021e67c8a813a613c333eb2f40ed7b11aeb 222888 dbconfig-common_2.0.22.tar.xz
Checksums-Sha256:
 6193475a7ebc112d708ffa6cde07b70233f231d35c7f9dc51c744fc6d36401a8 1918 
dbconfig-common_2.0.22.dsc
 9ed042d75e82983d6b15aceaa24f5044b14d449641bedace73528c18837c0631 222888 
dbconfig-common_2.0.22.tar.xz
Files:
 c7cf2418b417d42ca86df0f718584c6e 1918 admin optional dbconfig-common_2.0.22.dsc
 d0185874f65271aaf5e12fdd7e0c71fa 222888 admin optional 
dbconfig-common_2.0.22.tar.xz

-----BEGIN PGP SIGNATURE-----

iQEzBAEBCAAdFiEEWLZtSHNr6TsFLeZynFyZ6wW9dQoFAmNNtLMACgkQnFyZ6wW9
dQqxVggAqZuZ5woWJQghgWEyyNwYFxvE8UfMcS7zuevD1rjjwiKPn90Wn2boHWQW
+QnHk+4sJie1LFhkgyQwTTmr6FRxtw1cR+I+0OgtYgTmq2OgzxneH6PGw/+zjEg3
YTok33sNUwkxky49cFRaIfvOAcqnaGv+1gZFafU5Qhwngk50HwcdbTs4PAELkwI2
Y5ftzBkK+dn/b1GryXb9SsBlt4tT9BKwOy9LliS/OjOAa37VSGYw0SyKQb6TSco3
gDpatNhbuXCyPEY04xLsm7PecnwHUpmphP+Fz5U11m+l3Ui9cousxFzZPZ+U46Ou
hGWjzZ77ZkoOU6KTmoGVlDgfIZ1vKg==
=Ejz3
-----END PGP SIGNATURE-----

--- End Message ---

Reply via email to