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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
