[Bug 1533153] [NEW] cannot connect to database after update to postgresql 9.5

Tue Jan 12 11:12:39 UTC 2016

Public bug reported:

In xenial, after playing in the daily updates and thus updating from
postgresql 9.4 to 9.5, the apache module auth-pgsql cannot connect to
the database any more. When accessing the password protected site,
Apache's error.log states

[Tue Jan 12 11:17:42.779407 2016] [auth_pgsql:error] [pid 643:tid
140653979748096] [client 132.231.64.46:16942] [mod_auth_pgsql.c] -
cannot connect to database

Of course I updated the postgresql 9.5 config (pg_hba.conf) and
installed dumps from 9.4 as this is not done automatically. The database
itself seems to work seemlessly as before. I noticed that also libpq was
updated to 9.5 which is now located under /usr/lib/x86_64-linux-gnu vs
previously directly under /usr/lib . I don't know if this causes the
fault. Whith the previous postgresql 9.4 and libpq everything worked.
Thus this is a regression.

A small example for reproduction can be to place the attached .htaccess
file under /var/www/html/test-auth-pgsql, create the respective sample
database (a la the attached init.sql), the table with an entry and at
least read rights for the user www-data executing apache. Then calling
http://hostname/test-auth-pgsql/ with a browser.

ProblemType: Bug
ApportVersion: 2.19.3-0ubuntu2
Architecture: amd64
Date: Tue Jan 12 11:29:12 2016
Dependencies:
 adduser 3.113+nmu3ubuntu4
 apt 1.1.10
 apt-utils 1.1.10
 debconf 1.5.58ubuntu1
 debconf-i18n 1.5.58ubuntu1
 debianutils 4.5.1
 dpkg 1.18.3ubuntu1
 gcc-5-base 5.3.1-5ubuntu2
 gnupg 1.4.19-6ubuntu1
 gpgv 1.4.19-6ubuntu1
 krb5-locales 1.13.2+dfsg-4
 libacl1 2.2.52-2
 libapt-inst2.0 1.1.10
 libapt-pkg5.0 1.1.10
 libasn1-8-heimdal 1.6~rc2+dfsg-10ubuntu1
 libattr1 1:2.4.47-2
 libaudit-common 1:2.4.4-4ubuntu1
 libaudit1 1:2.4.4-4ubuntu1
 libbz2-1.0 1.0.6-8
 libc6 2.21-0ubuntu5
 libcomerr2 1.42.13-1ubuntu1
 libdb5.3 5.3.28-11
 libffi6 3.2.1-4
 libgcc1 1:5.3.1-5ubuntu2
 libgmp10 2:6.1.0+dfsg-2
 libgnutls-deb0-28 3.3.18-1ubuntu1
 libgssapi-krb5-2 1.13.2+dfsg-4
 libgssapi3-heimdal 1.6~rc2+dfsg-10ubuntu1
 libhcrypto4-heimdal 1.6~rc2+dfsg-10ubuntu1
 libheimbase1-heimdal 1.6~rc2+dfsg-10ubuntu1
 libheimntlm0-heimdal 1.6~rc2+dfsg-10ubuntu1
 libhogweed4 3.1.1-4
 libhx509-5-heimdal 1.6~rc2+dfsg-10ubuntu1
 libk5crypto3 1.13.2+dfsg-4
 libkeyutils1 1.5.9-8ubuntu1
 libkrb5-26-heimdal 1.6~rc2+dfsg-10ubuntu1
 libkrb5-3 1.13.2+dfsg-4
 libkrb5support0 1.13.2+dfsg-4
 libldap-2.4-2 2.4.41+dfsg-1ubuntu3
 liblocale-gettext-perl 1.07-1build1
 liblzma5 5.1.1alpha+20120614-2ubuntu2
 libnettle6 3.1.1-4
 libp11-kit0 0.23.2-3
 libpam-modules 1.1.8-3.1ubuntu3
 libpam-modules-bin 1.1.8-3.1ubuntu3
 libpam0g 1.1.8-3.1ubuntu3
 libpcre3 2:8.35-7.1ubuntu1
 libpq5 9.5.0-1
 libreadline6 6.3-8ubuntu1
 libroken18-heimdal 1.6~rc2+dfsg-10ubuntu1
 libsasl2-2 2.1.26.dfsg1-14
 libsasl2-modules 2.1.26.dfsg1-14
 libsasl2-modules-db 2.1.26.dfsg1-14
 libselinux1 2.4-3
 libsemanage-common 2.3-1build2
 libsemanage1 2.3-1build2
 libsepol1 2.4-2
 libsqlite3-0 3.10.0-1
 libssl1.0.0 1.0.2e-1ubuntu1
 libstdc++6 5.3.1-5ubuntu2
 libtasn1-6 4.7-3
 libtext-charwidth-perl 0.04-7build5
 libtext-iconv-perl 1.7-5build4
 libtext-wrapi18n-perl 0.06-7.1
 libtinfo5 6.0+20151024-2ubuntu1
 libusb-0.1-4 2:0.1.12-28
 libustr-1.0-1 1.0.4-5
 libwind0-heimdal 1.6~rc2+dfsg-10ubuntu1
 multiarch-support 2.21-0ubuntu5
 passwd 1:4.1.5.1-1.1ubuntu7
 perl-base 5.22.1-3
 readline-common 6.3-8ubuntu1
 sensible-utils 0.0.9
 tar 1.28-2.1
 ubuntu-keyring 2012.05.19
 zlib1g 1:1.2.8.dfsg-2ubuntu4
DistroRelease: Ubuntu 16.04
InstallationDate: Installed on 2015-12-23 (20 days ago)
InstallationMedia: Ubuntu-Server 16.04 LTS "Xenial Xerus" - Alpha amd64 (20151115)
JournalErrors:
 -- Logs begin at Tue 2016-01-12 08:02:27 CET, end at Tue 2016-01-12 11:17:01 CET. --
 Jan 12 08:02:28 hostname kernel: ACPI: RSDP 0x00000000000E0000 000024 (v02 VBOX  )
 Jan 12 08:02:28 hostname kernel: ACPI: XSDT 0x000000007FFF0030 00003C (v01 VBOX   VBOXXSDT 00000001 ASL  00000061)
 Jan 12 08:02:28 hostname kernel: ACPI: FACP 0x000000007FFF00F0 0000F4 (v04 VBOX   VBOXFACP 00000001 ASL  00000061)
 Jan 12 08:02:28 hostname kernel: ACPI: DSDT 0x000000007FFF0470 001CEB (v01 VBOX   VBOXBIOS 00000002 INTL 20100528)
 Jan 12 08:02:28 hostname kernel: ACPI: FACS 0x000000007FFF0200 000040
 Jan 12 08:02:28 hostname kernel: ACPI: FACS 0x000000007FFF0200 000040
 Jan 12 08:02:28 hostname kernel: ACPI: APIC 0x000000007FFF0240 00005C (v02 VBOX   VBOXAPIC 00000001 ASL  00000061)
 Jan 12 08:02:28 hostname kernel: ACPI: SSDT 0x000000007FFF02A0 0001CC (v01 VBOX   VBOXCPUT 00000002 INTL 20100528)
 Jan 12 08:02:28 hostname kernel: ACPI: 2 ACPI AML tables successfully acquired and loaded
 Jan 12 08:02:28 hostname kernel: PCCT header not found.
 Jan 12 08:02:28 hostname kernel: ACPI: Executed 1 blocks of module-level executable AML code
 Jan 12 08:02:28 hostname kernel: ACPI Exception: AE_NOT_FOUND, While evaluating Sleep State [\_S1_] (20150818/hwxface-580)
 Jan 12 08:02:28 hostname kernel: ACPI Exception: AE_NOT_FOUND, While evaluating Sleep State [\_S2_] (20150818/hwxface-580)
 Jan 12 08:02:28 hostname kernel: ACPI Exception: AE_NOT_FOUND, While evaluating Sleep State [\_S3_] (20150818/hwxface-580)
 Jan 12 08:02:28 hostname kernel: ACPI Exception: AE_NOT_FOUND, While evaluating Sleep State [\_S4_] (20150818/hwxface-580)
 Jan 12 08:02:28 hostname kernel: acpi PNP0A03:00: fail to add MMCONFIG information, can't access extended PCI configuration space under this bridge.
 Jan 12 08:02:28 hostname kernel: ACPI: Enabled 2 GPEs in block 00 to 07
 Jan 12 08:02:28 hostname systemd[1]: Failed to insert module 'kdbus': Function not implemented
 Jan 12 08:02:28 hostname systemd[1]: gssproxy.service: Cannot add dependency job, ignoring: Unit gssproxy.service failed to load: No such file or directory.
 Jan 12 08:02:28 hostname systemd[1]: nfs-blkmap.service: Cannot add dependency job, ignoring: Unit nfs-blkmap.service failed to load: No such file or directory.
 Jan 12 08:02:28 hostname systemd[1]: display-manager.service: Cannot add dependency job, ignoring: Unit display-manager.service failed to load: No such file or directory.
 Jan 12 08:02:28 hostname systemd-tmpfiles[285]: [/usr/lib/tmpfiles.d/var.conf:14] Duplicate line for path "/var/log", ignoring.
 Jan 12 08:02:29 hostname kernel: VbgdCommonInitDevExt: Setting up heartbeat to trigger every 2000 milliseconds
 Jan 12 08:02:29 hostname kernel: vboxguest: misc device minor 56, IRQ 20, I/O port d020, MMIO at 00000000f0400000 (size 0x400000)
 Jan 12 08:02:29 hostname kernel: piix4_smbus 0000:00:07.0: SMBus base address uninitialized - upgrade BIOS or use force_addr=0xaddr
 Jan 12 08:02:29 hostname kernel: intel_rapl: no valid rapl domains found in package 0
 Jan 12 08:02:29 hostname kernel: intel_rapl: no valid rapl domains found in package 0
 Jan 12 08:02:29 hostname systemd-udevd[272]: Process '/lib/udev/hdparm' failed with exit code 5.
 Jan 12 08:17:29 hostname systemd-tmpfiles[1189]: [/usr/lib/tmpfiles.d/var.conf:14] Duplicate line for path "/var/log", ignoring.
Package: libapache2-mod-auth-pgsql 2.0.3-6.1
PackageArchitecture: amd64
ProcEnviron:
 LANGUAGE=en_US:en
 TERM=linux
 PATH=(custom, no user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 4.3.0-5.16-generic 4.3.3
SourcePackage: libapache2-mod-auth-pgsql
Tags:  xenial
Uname: Linux 4.3.0-5-generic x86_64
UpgradeStatus: No upgrade log present (probably fresh install)
_MarkForUpload: True

** Affects: libapache2-mod-auth-pgsql (Ubuntu)
     Importance: Undecided
         Status: New

** Attachment added: ".htaccess"
   https://bugs.launchpad.net/bugs/1533153/+attachment/4548453/+files/.htaccess

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to libapache2-mod-auth-pgsql in Ubuntu.
https://bugs.launchpad.net/bugs/1533153

Title:
  cannot connect to database after update to postgresql 9.5

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libapache2-mod-auth-pgsql/+bug/1533153/+subscriptions