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 Bugs, which is subscribed to 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 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs