Your message dated Wed, 03 Jun 2015 19:17:06 +0000
with message-id <[email protected]>
and subject line Bug#786874: fixed in postgresql-9.4 9.4.3-0+deb8u1
has caused the Debian Bug report #786874,
regarding postgresql-9.1: Startup error: konnte Datei
>>/etc/ssl/certs/ssl-cert-snakeoil.pem<< nicht ?ffnen: Keine Berechtigung
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.)
--
786874: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=786874
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-9.1
Version: 9.1.16-0+deb7u1
Severity: normal
Dear Maintainer,
After upgrading to 9.1.16-0+deb7u postgres fails to start with following
message:
The PostgreSQL server failed to start. Please check the log output: 2015-05-26
12:26:58 CEST LOG:
Datenbanksystem wurde unterbrochen; letzte bekannte Aktion am 2015-05-22
17:39:05 CEST 2015-05-26
12:26:58 CEST FATAL: konnte Datei >>/etc/ssl/certs/ssl-cert-snakeoil.pem<<
nicht ?ffnen: Keine Berechtigu
[FAIL15-05-26 12:26:58 CEST LOG: Startprozess (PID 28437) beendete mit Status 1
2015-05-26 12:26:58 CEST LOG: Serverstart abgebrochen wegen Startprozessfehler
This is the german translation for something like 'unable to open
/etc/ssl/certs/ssl-cert-snakeoil.pem - insufficient rights"...
The rights of the file are
30696255 24 drwxr-xr-x 2 root root 24576 Okt 20 2014 /etc/ssl/certs
30696687 4 -rw-r--r-- 1 root root 1021 Feb 22 2011
/etc/ssl/certs/ssl-cert-snakeoil.pem
Setting the owner to user prostgres causes the same error concerning the key at
/etc/ssl/private/ssl-cert-snakeoil.key.
I tried changing the owner, groups and permissions to all variants (root,
postgres, ssl-cert,...) but nothing realling worked.
In the log there is nothing special found:
2015-05-26 12:26:58 CEST LOG: Datenbanksystem wurde unterbrochen; letzte
bekannte Aktion am 2015-05-22 17:39:05 CEST
2015-05-26 12:26:58 CEST FATAL: konnte Datei
>>/etc/ssl/certs/ssl-cert-snakeoil.pem<< nicht ?ffnen: Keine Berechtigung
2015-05-26 12:26:58 CEST LOG: Startprozess (PID 28437) beendete mit Status 1
2015-05-26 12:26:58 CEST LOG: Serverstart abgebrochen wegen Startprozessfehler
As a workaround I set ssl=false and had to remove the certificate, the key and
the links from /var/lib/postgresql/9.1/main/.
So postgres now starts without SSL support.
We have some postgres instance with the same configuration here. The problem
occoured on two maschines, all other work fine...
Please let me know if I can provide additional informations.
Regards
Sebastian
-- System Information:
Debian Release: 7.8
APT prefers oldstable-updates
APT policy: (500, 'oldstable-updates'), (500, 'oldstable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages postgresql-9.1 depends on:
ii libc6 2.13-38+deb7u8
ii libcomerr2 1.42.5-1.1+deb7u1
ii libgssapi-krb5-2 1.10.1+dfsg-5+deb7u3
ii libkrb5-3 1.10.1+dfsg-5+deb7u3
ii libldap-2.4-2 2.4.31-2
ii libpam0g 1.1.3-7.1
ii libpq5 9.1.16-0+deb7u1
ii libssl1.0.0 1.0.1e-2+deb7u16
ii libxml2 2.8.0+dfsg1-7+wheezy4
ii locales 2.13-38+deb7u8
ii postgresql-client-9.1 9.1.16-0+deb7u1
ii postgresql-common 134wheezy4
ii ssl-cert 1.0.32
ii tzdata 2015d-0+deb7u1
postgresql-9.1 recommends no packages.
Versions of packages postgresql-9.1 suggests:
pn locales-all <none>
pn oidentd | ident-server <none>
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: postgresql-9.4
Source-Version: 9.4.3-0+deb8u1
We believe that the bug you reported is fixed in the latest version of
postgresql-9.4, 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.
Christoph Berg <[email protected]> (supplier of updated postgresql-9.4
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: Wed, 03 Jun 2015 11:53:43 +0200
Source: postgresql-9.4
Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3
postgresql-9.4 postgresql-9.4-dbg postgresql-client-9.4
postgresql-server-dev-9.4 postgresql-doc-9.4 postgresql-contrib-9.4
postgresql-plperl-9.4 postgresql-plpython-9.4 postgresql-plpython3-9.4
postgresql-pltcl-9.4
Architecture: source amd64 all
Version: 9.4.3-0+deb8u1
Distribution: jessie
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers
<[email protected]>
Changed-By: Christoph Berg <[email protected]>
Description:
libecpg-compat3 - older version of run-time library for ECPG programs
libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
libecpg6 - run-time library for ECPG programs
libpgtypes3 - shared library libpgtypes for PostgreSQL 9.4
libpq-dev - header files for libpq5 (PostgreSQL library)
libpq5 - PostgreSQL C client library
postgresql-9.4 - object-relational SQL database, version 9.4 server
postgresql-9.4-dbg - debug symbols for postgresql-9.4
postgresql-client-9.4 - front-end programs for PostgreSQL 9.4
postgresql-contrib-9.4 - additional facilities for PostgreSQL
postgresql-doc-9.4 - documentation for the PostgreSQL database management
system
postgresql-plperl-9.4 - PL/Perl procedural language for PostgreSQL 9.4
postgresql-plpython-9.4 - PL/Python procedural language for PostgreSQL 9.4
postgresql-plpython3-9.4 - PL/Python 3 procedural language for PostgreSQL 9.4
postgresql-pltcl-9.4 - PL/Tcl procedural language for PostgreSQL 9.4
postgresql-server-dev-9.4 - development files for PostgreSQL 9.4 server-side
programming
Closes: 786874
Changes:
postgresql-9.4 (9.4.3-0+deb8u1) jessie; urgency=medium
.
* New upstream version:
Avoid failures while fsync'ing data directory during crash restart
(Abhijit Menon-Sen, Tom Lane; Closes: #786874)
Checksums-Sha1:
2fd05256e4c78eb529130915b21089eef3ea824a 3525 postgresql-9.4_9.4.3-0+deb8u1.dsc
ca13047d38d09db0105cb39d74ba72a83d74d14b 17618524
postgresql-9.4_9.4.3.orig.tar.bz2
e023924350887729b8ebfb8ee694828c38961a7b 20852
postgresql-9.4_9.4.3-0+deb8u1.debian.tar.xz
fbb55aa30a0d10213d204dbbd20e39ddd8cc17ab 162048
libpq-dev_9.4.3-0+deb8u1_amd64.deb
3f6cb7d61ba1a12cc7420f3fe150811ffd01c958 121786 libpq5_9.4.3-0+deb8u1_amd64.deb
93e3d8704fa7c95d32fc8d8f0ab594f5fbaf4c24 77910
libecpg6_9.4.3-0+deb8u1_amd64.deb
1ecda1f52b841abddcf63ca8c7caa92aed600541 215604
libecpg-dev_9.4.3-0+deb8u1_amd64.deb
58e24da462238d4b0f05d1c5e73fd6749b3dbb8a 14144
libecpg-compat3_9.4.3-0+deb8u1_amd64.deb
fe796570414e630e52c45a1e7207473dcc26df07 36210
libpgtypes3_9.4.3-0+deb8u1_amd64.deb
9c4613c95c0a5b93601415a680e8db855574314a 3701864
postgresql-9.4_9.4.3-0+deb8u1_amd64.deb
9c834409083129c37e0346f192100a1c47c2d1be 12055018
postgresql-9.4-dbg_9.4.3-0+deb8u1_amd64.deb
39f8f6185f35cc5f52c33447d9cd5773a17ea8be 1071676
postgresql-client-9.4_9.4.3-0+deb8u1_amd64.deb
94d2d044149757e61cb5d7378c53454f0d671f88 636018
postgresql-server-dev-9.4_9.4.3-0+deb8u1_amd64.deb
bab333568208a27a7b24af9896849d2889dbffa0 1831474
postgresql-doc-9.4_9.4.3-0+deb8u1_all.deb
7c2b459372a560f2e04fb1fa82de6d14252c4f60 449232
postgresql-contrib-9.4_9.4.3-0+deb8u1_amd64.deb
779554adce18b21766cde5aa603f272f65b910bb 55104
postgresql-plperl-9.4_9.4.3-0+deb8u1_amd64.deb
b5315e85163a04494660e354d7f210df051d28a0 43440
postgresql-plpython-9.4_9.4.3-0+deb8u1_amd64.deb
cc67d82360e3f0cdc4746c28ccf82f4b37a349d6 43000
postgresql-plpython3-9.4_9.4.3-0+deb8u1_amd64.deb
324dcdb71b3cb770805943c11cc2b1bbadd6b203 28866
postgresql-pltcl-9.4_9.4.3-0+deb8u1_amd64.deb
Checksums-Sha256:
43c9a648b8143f346e91f776c5cdac0b12363c7176d98f2baee66c155e79f6d0 3525
postgresql-9.4_9.4.3-0+deb8u1.dsc
734acfd2ac352dd0cd353d226f3199c2e1a2730200998aea5b38cf685136d755 17618524
postgresql-9.4_9.4.3.orig.tar.bz2
1f14bf1a3bcf0fce85a28409b5bf2dea3c0e99560801f7fdc2617c3530e95e0b 20852
postgresql-9.4_9.4.3-0+deb8u1.debian.tar.xz
b5ed5967be4748b217abc495e490bf792ecce3b4a5e148f36e1157d176ccfcc9 162048
libpq-dev_9.4.3-0+deb8u1_amd64.deb
952cd4305d8f31f27efafbcf8aaecd24811e05ed44683112e4fdf80ee6b81d16 121786
libpq5_9.4.3-0+deb8u1_amd64.deb
eee238d308d0bc1eeeae0536343839e5d9185fc5169307cd984404264276a49f 77910
libecpg6_9.4.3-0+deb8u1_amd64.deb
13253d9a732c210ceaba5615104a0af65389c5a0268c2b24c47f0a62bc590ca1 215604
libecpg-dev_9.4.3-0+deb8u1_amd64.deb
87ceb5e0850631556b1455daa1fa0ca9e04ba652a61e648fd5663fe4ceba6218 14144
libecpg-compat3_9.4.3-0+deb8u1_amd64.deb
99c9e7fa0ce3f640dfad7c92a0ee169df45b62d87306fef32b7b3edfc34fd35d 36210
libpgtypes3_9.4.3-0+deb8u1_amd64.deb
dc2d2d674c6419606ffced9b3020790c2a44a7b6b9b398d8422e588362fb48b3 3701864
postgresql-9.4_9.4.3-0+deb8u1_amd64.deb
a16ad2fa9435ebe996efb64cacaa9a78f80760e9bf0c3325271223f18bc194e3 12055018
postgresql-9.4-dbg_9.4.3-0+deb8u1_amd64.deb
9de1e8b81f4d09ff3e5a484c519355326ac696ee1a15b0b28c9aa1c111ec77c1 1071676
postgresql-client-9.4_9.4.3-0+deb8u1_amd64.deb
c48681fa911344f35b9b44c820d82d35598faed4a252a4a687007069dbfb0aab 636018
postgresql-server-dev-9.4_9.4.3-0+deb8u1_amd64.deb
03ad2d5e552c96eaa9040d14026ab72d31749444a0fa632f1d9e729d1c722444 1831474
postgresql-doc-9.4_9.4.3-0+deb8u1_all.deb
198a8da062b4ef68d2c3b7af0325b0deb64adc950c8774d4b1fd8a0a0fe9097f 449232
postgresql-contrib-9.4_9.4.3-0+deb8u1_amd64.deb
dc2116eee1635acd6d184529710697304878d0cf86efedeedbcff577ef6d2e9d 55104
postgresql-plperl-9.4_9.4.3-0+deb8u1_amd64.deb
b6a2600eacb7e85dd8bf00cd16f7340ad1cadf9e827c11e8e3502b39a762bd80 43440
postgresql-plpython-9.4_9.4.3-0+deb8u1_amd64.deb
12e3b90589d86cb362abfc3def1979fee4b2fffbe2abbf7455ae29baab966d7f 43000
postgresql-plpython3-9.4_9.4.3-0+deb8u1_amd64.deb
f105a14f3a94dd6c5d560034a554d6bd4b571210ae39846da619cafc3b3003c5 28866
postgresql-pltcl-9.4_9.4.3-0+deb8u1_amd64.deb
Files:
933d7a8e2783ca4263f2875d6b85209a 3525 database optional
postgresql-9.4_9.4.3-0+deb8u1.dsc
05217e0921b51fb886e9e50875776bf1 17618524 database optional
postgresql-9.4_9.4.3.orig.tar.bz2
a2ab248e959789aaf2a95f4afeac9955 20852 database optional
postgresql-9.4_9.4.3-0+deb8u1.debian.tar.xz
90f40bca49ec65455b7d35c92bf2bfde 162048 libdevel optional
libpq-dev_9.4.3-0+deb8u1_amd64.deb
701394a43935f6fb1006832fc53195df 121786 libs optional
libpq5_9.4.3-0+deb8u1_amd64.deb
627caca12ade7bcb7658475673e1503c 77910 libs optional
libecpg6_9.4.3-0+deb8u1_amd64.deb
24a0467bb9a24c29d36d6c55341f9b71 215604 libdevel optional
libecpg-dev_9.4.3-0+deb8u1_amd64.deb
6bf8460511cb13dbdecbef5e6a8fd5da 14144 libs optional
libecpg-compat3_9.4.3-0+deb8u1_amd64.deb
5f06734f66b80958a436ffa29541f9ac 36210 libs optional
libpgtypes3_9.4.3-0+deb8u1_amd64.deb
bd5945dc5f38887271ccc476c17b53f0 3701864 database optional
postgresql-9.4_9.4.3-0+deb8u1_amd64.deb
ebc39333bc86057e4df4037cbc1c8027 12055018 debug extra
postgresql-9.4-dbg_9.4.3-0+deb8u1_amd64.deb
294ac5d1d075e4c75d4f6ba520d83441 1071676 database optional
postgresql-client-9.4_9.4.3-0+deb8u1_amd64.deb
f86d58653daa6bfb16996f4bd6601b67 636018 libdevel optional
postgresql-server-dev-9.4_9.4.3-0+deb8u1_amd64.deb
7dc08da161b5fd724466bd08651cce52 1831474 doc optional
postgresql-doc-9.4_9.4.3-0+deb8u1_all.deb
9e1256c80888e4d3b63f7e3e1d9fd712 449232 database optional
postgresql-contrib-9.4_9.4.3-0+deb8u1_amd64.deb
5f61706816fc18ca1fe403bf12419a7c 55104 database optional
postgresql-plperl-9.4_9.4.3-0+deb8u1_amd64.deb
14d6595eeea816172346a62a247bbd42 43440 database optional
postgresql-plpython-9.4_9.4.3-0+deb8u1_amd64.deb
4148348007decb85ad085787fce742ae 43000 database optional
postgresql-plpython3-9.4_9.4.3-0+deb8u1_amd64.deb
92b989db199b9fa6bef85f8ddd83a8cb 28866 database optional
postgresql-pltcl-9.4_9.4.3-0+deb8u1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQIcBAEBCAAGBQJVby2vAAoJEExaa6sS0qeumoEP/2oUdGOSMxGGr8+sZKC7RtSB
bAkepKO9HHfeIOttc8pEg7K5D32FmKC9opkv9X6MoktQnFgQe3PZ7xCuW+1ajdXT
QLfCQA1fFBu7lYqydn2gljBSpgavcZxZcqxoSZv/sGZGhPX+qjQjA2qn71vF5UQZ
36CFn8js78BRCZhqJNXg7e7LklN0FKbHENHms1m7TfHYTXJinleOcmVCFUx9adnz
V0uimWNAHg8pdnmt43RRW9u4JnMuNBJotHt/36JbdoO/e2QCpiZp5hIeVUBeiF64
F4KsNveQ87XnnSBbqRK9x/93GVidgpMrj+Oj8BCTCQWm2IRy1CBDPwIwzmnhHQrV
5HGER8iXDRjt9kMnGh9fcccq6yj+Op0QBeU+n+onMN2P4CaGNMMWMUEhYj+0vwig
6DdOYAY7aN7RtwaXajnKowqAo91OOMEH10xetB/ujGjha0a/CeeX3jyCF9UW/c1S
WpJX8mcRht0MsNXrWYjRffQyCkxlSr93CWFJ+c8x9bJJ6zn6aaBJ7v9AHSVua7YT
kmpzaQvTWquCgOnG44SGF+HotfE05DhMSSSUJjhWs9EDO5mRUUhgupgUTn3/lxir
W8LLG9SfEcqnUkn/jcDYeaQ02iXhUoPdIlTxyPPQ6vLE+1s9YqVYPVljfL8EThiA
PjPMSRnvMuP4iZYBsBN3
=hg3X
-----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
