Your message dated Tue, 03 Nov 2015 13:48:50 +0000
with message-id <[email protected]>
and subject line Bug#703277: fixed in dbconfig-common 1.8.55
has caused the Debian Bug report #703277,
regarding postgresql defaults are confusing and non-working
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 [email protected]
immediately.)
--
703277: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=703277
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: dbconfig-common
Version: 1.8.47+nmu1
Severity: normal
I've experienced this with the tt-rss package but I don't think it's
package-specific.
First, dbconfig-common tells that connecting via the UNIX socket is the best
way at least performance-wise. Second, it tells that using the ident
authentication is not only the best way but also recommended with default
PostgreSQL settings.
The default PostgreSQL 9.1 Debian settings allow only 'peer' on the local UNIX
socket, so the password authentication simply won't work with the UNIX socket.
And 'ident'/'peer' requires matching between the DB user name (the default for
which is chosen by dbconfig-common and changing that default is usually wrong)
and the system user name (which usually cannot be changed, and when it can the
administrator must do that manually, including the user creation).
This all means that without reconfiguring the DB server the only usable setting
is TCP/IP+'password' even for the local server, despite all dbconfig-common
suggestions.
-- System Information:
Debian Release: 7.0
APT prefers testing
APT policy: (990, 'testing'), (500, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 3.6.5-linode47 (SMP w/4 CPU cores)
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages dbconfig-common depends on:
ii debconf [debconf-2.0] 1.5.49
ii ucf 3.0025+nmu3
dbconfig-common recommends no packages.
Versions of packages dbconfig-common suggests:
ii mysql-client 5.5.28+dfsg-1
ii mysql-client-5.5 [virtual-mysql-client] 5.5.28+dfsg-1
ii postgresql-client-9.1 [postgresql-client] 9.1.8-1
-- debconf information:
* dbconfig-common/remote-questions-default: false
dbconfig-common/db/basepath:
dbconfig-common/pgsql/revertconf: false
dbconfig-common/install-error: abort
dbconfig-common/pgsql/no-empty-passwords:
dbconfig-common/pgsql/admin-user: postgres
dbconfig-common/dbconfig-install: true
dbconfig-common/internal/skip-preseed: false
dbconfig-common/db/dbname:
dbconfig-common/dbconfig-reinstall: false
dbconfig-common/remote/host:
dbconfig-common/pgsql/manualconf:
dbconfig-common/pgsql/changeconf: false
dbconfig-common/remote/newhost:
dbconfig-common/dbconfig-remove: true
dbconfig-common/missing-db-package-error: abort
dbconfig-common/dbconfig-upgrade: true
dbconfig-common/mysql/method: unix socket
dbconfig-common/pgsql/no-user-choose-other-method:
dbconfig-common/upgrade-backup: true
dbconfig-common/internal/reconfiguring: false
dbconfig-common/passwords-do-not-match:
dbconfig-common/pgsql/authmethod-admin: ident
dbconfig-common/remove-error: abort
* dbconfig-common/remember-admin-pass: false
dbconfig-common/mysql/admin-user: root
dbconfig-common/pgsql/method: unix socket
dbconfig-common/pgsql/authmethod-user:
dbconfig-common/upgrade-error: abort
dbconfig-common/database-type:
dbconfig-common/db/app-user:
dbconfig-common/remote/port:
dbconfig-common/purge: false
--- End Message ---
--- Begin Message ---
Source: dbconfig-common
Source-Version: 1.8.55
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 [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Paul Gevers <[email protected]> (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 [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Tue, 03 Nov 2015 13:51:48 +0100
Source: dbconfig-common
Binary: dbconfig-common
Architecture: source
Version: 1.8.55
Distribution: unstable
Urgency: medium
Maintainer: Paul Gevers <[email protected]>
Changed-By: Paul Gevers <[email protected]>
Description:
dbconfig-common - common framework for packaging database applications
Closes: 509627 703277 703374 801427 803539 803561 803627 803775 803785 803931
Changes:
dbconfig-common (1.8.55) unstable; urgency=medium
.
* Convert nearly all leading chars to Caps in
doc/dbconfig-common.sgml
* Remove alioth project link from documentation as that isn't the
place to find accurate info
* Drop _dbc_asuser from list of local variables in _dbc_generate_mycnf
(Closes: #801427)
* Improve pgsql peer/ident/password situation for dbadmin and dbuser
(Closes: #703277, #509627, #703374)
* Fix ordering of thanks for reproducible builds
* Check for existence of sql input file in dbc_pgsql_exec_file
* Multiple $x -> ${x:-} replacements to ensure the regression test
can run with empty variables
* Tests:
- Use shunit testcases with real databases (mysql only for now)
- Enhance and extend mysql/postgresql testsuite
- TMPDIR wasn't really required, just appeared to be
- check that providing dbadmin password changes correctly from
peer to passwd based login
* Update translations for changes in templates; Thanks to
- Giuseppe Sacco
- Helge Kreutzmann (Closes: #803627)
- Innocent De Marchi (Closes: #803785)
- Joe Dalton (Closes: #803561)
- Julien Patriarca (Closes: #803931)
- Miroslav Kure (Closes: #803775)
- Yuri Kozlov (Closes: #803539)
Checksums-Sha1:
bec9c945369c96f1725db03ea213b42ae93ee4d5 1364 dbconfig-common_1.8.55.dsc
e46604d09db9009b45ab93f0298f249ced86b6f0 204768 dbconfig-common_1.8.55.tar.xz
Checksums-Sha256:
7a059e4be6bd1215359286ac152d8b12156db573c14ec23e0ae5acf119cb2d26 1364
dbconfig-common_1.8.55.dsc
eae73b298c3a8ec3ce735a5bbf97bfd2b5883c92d96fc479402a48eba3317f71 204768
dbconfig-common_1.8.55.tar.xz
Files:
fea8eff7ace92566e9434a3feeed19fd 1364 admin optional dbconfig-common_1.8.55.dsc
c367cc729dd7d2d22f7254fb9757a645 204768 admin optional
dbconfig-common_1.8.55.tar.xz
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQEcBAEBCAAGBQJWOLWCAAoJEJxcmesFvXUKSEcIAImOIhejrpFoHjX2fNKdiY9L
keiI5Ols2ETHECIaRbqYr35lHo3o5Oo/yZ0ZxPeRpt1sgARrm7K7Zg+Kz1eO0vLU
mMAtfTZrRfYhicQ8v7VZUFQssIsL9RMWqpX5vJP9DWzDv+YCIi9f/IDRYx6S9xM8
GCrTgUfj5uiVpSCN4FLAkxSeKXjX4DTn6mOqd45gghkWIPuMiaUlPYJ97VrsdvQ4
A2TqoR2yG/pxd6SO5h3Z6bdbkoT6eergaNg5OUSxsFFOt4cZdk6TLD3K+6JU9cEc
kH87il8fOM21+6OZlMmUBQ4D9Nk3CgmDVgZX4R+Hhro5U9QXFBdXg6H/thA7QUc=
=rwA7
-----END PGP SIGNATURE-----
--- End Message ---
