[Bug 1533153] Re: cannot connect to database after update to postgresql 9.5
I checkd back that the message during update did not state that. In my humble opinion it would be better if it would drop a note on that. I only have the update text in german: Veraltete Version 9.4 │ │ Die PostgreSQL-Version 9.4 ist veraltet, aber die Server-oder │ Client-Pakete sind noch installiert. Bitte installieren Sie die │ aktuellen Pakete (postgresql-9.5 und postgresql-client-9.5) und │ aktualisieren Sie die existierenden Cluster mit pg_upgradecluster (siehe │ man-Seite). │ │ Bitte beachten Sie, dass die Installation des Pakets postgresql-9.5 │ automatisch einen Standard-Cluster 9.5/main anlegt. Wenn Sie den Cluster │ 9.4/main aktualisieren möchten, müssen Sie den schon vorhandenen 9.5 │ Cluster entfernen (pg_dropcluster --stop 9.5 main, siehe man-Seite für │ Details). -- 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 -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1533153] [NEW] cannot connect to database after update to postgresql 9.5
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 0x000E 24 (v02 VBOX ) Jan 12 08:02:28 hostname kernel: ACPI: XSDT 0x7FFF0030 3C (v01 VBOX VBOXXSDT 0001 ASL 0061) Jan 12 08:02:28 hostname kernel: ACPI: FACP 0x7FFF00F0 F4 (v04 VBOX VBOXFACP 0001 ASL 0061) Jan 12 08:02:28 hostname kernel: ACPI: DSDT 0x7FFF0470 001CEB (v01 VBOX VBOXBIOS 0002 INTL 20100528) Jan 12 08:02:28 hostname kernel: ACPI: FACS 0x7FFF0200 40 Jan 12 08:02:28 hostname kernel: ACPI: FACS 0x7FFF0200 40 Jan 12 08:02:28 hostname kernel: ACPI: APIC 0x7FFF0240 5C (v02 VBOX VBOXAPIC 0001 ASL 0061) Jan 12 08:02:28 hostname kernel: ACPI: SSDT 0x7FFF02A0 0001CC (v01 VBOX VBOXCPUT 0002 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
[Bug 1533153] Re: cannot connect to database after update to postgresql 9.5
** Attachment added: "init.sql" https://bugs.launchpad.net/ubuntu/+source/libapache2-mod-auth-pgsql/+bug/1533153/+attachment/4548454/+files/init.sql -- 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 -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1533153] Re: cannot connect to database after update to postgresql 9.5
This is not a bug, but a feature which was hard to see for me: The package update installs postgresql 9.5 in parallel to 9.4 such that one has the chance to dump the database with 9.4 and to import the dump with 9.5 as a .releases have incompatible data base formats. To be able to run them in parallel, the (tcp/ip) port of 9.5 is incremented by one and thus 5433 instead of default 5432. So far so good, as I connect over a socket and never by tcp/ip on this system. However, the socket file in /var/lib/postgresql contains also the port number, probably to have seperate sockets for more than one postgresql server on one system. So my mistake was to identify port with tcp/ip port. I wonder if that is on the update notification automatically displayed during system updates. Sorry, I was too fast (after about 10h trying) to open this bug here. ** Changed in: libapache2-mod-auth-pgsql (Ubuntu) Status: New => Invalid -- 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 -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1272857] Re: apache2 crashed with SIGSEGV in signal handler called()
I am using the code of Andreas in #12 now in a productive environment. So far without any problems. Could someone assign the bug to the package maintainer? It seems like I have not the option to do that here. Thank you, Chris. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to apache2 in Ubuntu. https://bugs.launchpad.net/bugs/1272857 Title: apache2 crashed with SIGSEGV in signal handler called() To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/apache2/+bug/1272857/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1272857] Re: apache2 crashed with SIGSEGV in signal handler called()
Now I could sharpen the problem. It only shows up if using AuthPG libapache2-mod-auth-pgsql in connection with a cgi script. To reproduce put the following in /etc/apache2/conf.d/authpgtest.conf and then execute a2enconf authpgtest.conf and service apache2 reload . Alias /authpgtest /export/scratch/authpgtest Directory /export/scratch/authpgtest/ Options +ExecCGI +FollowSymLinks AddHandler cgi-script .pl AuthName TestRealm AuthType Basic AuthBasicProvider pgsql Auth_PG_host /var/run/postgresql Auth_PG_port 5432 Auth_PG_database authpgtestdb Auth_PG_pwd_table ident_users Auth_PG_uid_field uname Auth_PG_pwd_field password Auth_PG_encrypted off Require valid-user /Directory Of course the postgres db authpgtestdb with table ident_users with columns uname and password have to exist, or the params adapted. Under /export/scratch/authpgtest/hw.pl put the follwing. #!/usr/bin/perl print Content-type: text/html\n\n; print Hello, World!\n; Then call http://host/authpgtest/hw.pl in your browser while tail -f tail -f /var/log/apache2/error.log is running. Press the reload button of the browser a few times. Without using AuthPG-Realm I think the errors do not show up. Unfortunately, I need this for production and a workaround seems not to doable. Chris -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to apache2 in Ubuntu. https://bugs.launchpad.net/bugs/1272857 Title: apache2 crashed with SIGSEGV in signal handler called() To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/apache2/+bug/1272857/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1272857] Re: apache2 crashed with SIGSEGV in signal handler called()
Calling a python cgi script delivers in error.log (with all regular ubuntu updates/patches installed): *** Error in `/usr/sbin/apache2': free(): invalid pointer: 0x7ff1a80004b8 *** *** Error in `/usr/sbin/apache2': free(): invalid pointer: 0x7ff1a80004b8 *** *** Error in `/usr/sbin/apache2': free(): invalid pointer: 0x7ff1a8017840 *** *** Error in `/usr/sbin/apache2': free(): invalid pointer: 0x7ff1a8017840 *** *** Error in `/usr/sbin/apache2': free(): invalid pointer: 0x7ff1a8015a20 *** *** Error in `/usr/sbin/apache2': double free or corruption (!prev): 0x7ff1a80019a0 *** [Fri Apr 04 08:43:44.969263 2014] [core:notice] [pid 1764:tid 140676438046592] AH00051: child pid 1769 exit signal Segmentation fault (11), possible coredump in /etc/apache2 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to apache2 in Ubuntu. https://bugs.launchpad.net/bugs/1272857 Title: apache2 crashed with SIGSEGV in signal handler called() To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/apache2/+bug/1272857/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1272857] Re: apache2 crashed with SIGSEGV in signal handler called()
Calling a cgi-sript using mod_cgid unter Trusty Thar delivers segementation faults nearly on every single request in error.log: [Tue Mar 25 10:30:07.598453 2014] [core:notice] [pid 1178:tid 140037490894720] AH00051: child pid 7555 exit signal Segmentation fault (11), possible coredump in /etc/apache2 *** Error in `/usr/sbin/apache2': double free or corruption (!prev): 0x7f5cdc0019a0 *** [Tue Mar 25 10:30:09.601954 2014] [core:notice] [pid 1178:tid 140037490894720] AH00051: child pid 7593 exit signal Segmentation fault (11), possible coredump in /etc/apache2 However, this is not always and mostly the content is correctly displayed in the client browser. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to apache2 in Ubuntu. https://bugs.launchpad.net/bugs/1272857 Title: apache2 crashed with SIGSEGV in signal handler called() To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/apache2/+bug/1272857/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
