Your message dated Sun, 07 Jun 2015 17:32:31 +0000
with message-id <[email protected]>
and subject line Bug#786874: fixed in postgresql-9.1 9.1.16-0+deb7u2
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.1
Source-Version: 9.1.16-0+deb7u2
We believe that the bug you reported is fixed in the latest version of
postgresql-9.1, 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.1 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: Fri, 29 May 2015 21:14:33 +0200
Source: postgresql-9.1
Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3
postgresql-9.1 postgresql-9.1-dbg postgresql-client-9.1
postgresql-server-dev-9.1 postgresql-doc-9.1 postgresql-contrib-9.1
postgresql-plperl-9.1 postgresql-plpython-9.1 postgresql-plpython3-9.1
postgresql-pltcl-9.1
Architecture: source amd64 all
Version: 9.1.16-0+deb7u2
Distribution: wheezy-security
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.1
libpq-dev - header files for libpq5 (PostgreSQL library)
libpq5 - PostgreSQL C client library
postgresql-9.1 - object-relational SQL database, version 9.1 server
postgresql-9.1-dbg - debug symbols for postgresql-9.1
postgresql-client-9.1 - front-end programs for PostgreSQL 9.1
postgresql-contrib-9.1 - additional facilities for PostgreSQL
postgresql-doc-9.1 - documentation for the PostgreSQL database management
system
postgresql-plperl-9.1 - PL/Perl procedural language for PostgreSQL 9.1
postgresql-plpython-9.1 - PL/Python procedural language for PostgreSQL 9.1
postgresql-plpython3-9.1 - PL/Python 3 procedural language for PostgreSQL 9.1
postgresql-pltcl-9.1 - PL/Tcl procedural language for PostgreSQL 9.1
postgresql-server-dev-9.1 - development files for PostgreSQL 9.1 server-side
programming
Closes: 786874
Changes:
postgresql-9.1 (9.1.16-0+deb7u2) wheezy-security; urgency=medium
.
* Fix fsync-at-startup code to not treat errors as fatal.
(Abhijit Menon-Sen and Tom Lane, Closes: #786874)
Checksums-Sha1:
e18b2f34c43e253162878a6f64e20a4fb05bae09 3339
postgresql-9.1_9.1.16-0+deb7u2.dsc
dc2ba1f780171c3df8fa270f94f663c8b8c6dfe2 46544
postgresql-9.1_9.1.16-0+deb7u2.debian.tar.gz
83637df95c3236190b342574fc10701e477ffa42 194044
libpq-dev_9.1.16-0+deb7u2_amd64.deb
bf7100fcba634c380a3757f3e63b5bee23485ec1 138360
libpq5_9.1.16-0+deb7u2_amd64.deb
f7425561b5cf47dd28e29f942ba968fc85d1b69c 95416
libecpg6_9.1.16-0+deb7u2_amd64.deb
410093cff85f779ae3b70e3bbac387d09b054617 227490
libecpg-dev_9.1.16-0+deb7u2_amd64.deb
05238d3fac3f2ed6fc255fb6b4b08b05a7099c59 33068
libecpg-compat3_9.1.16-0+deb7u2_amd64.deb
4c860a2ae8d21b16397d346fa0935b505a0d4b30 54386
libpgtypes3_9.1.16-0+deb7u2_amd64.deb
3b4bce5549f0f0c27be626195b2139707393296c 3292302
postgresql-9.1_9.1.16-0+deb7u2_amd64.deb
51e28a641f25318cda58afe81fd2a4390f7aea11 6705262
postgresql-9.1-dbg_9.1.16-0+deb7u2_amd64.deb
c09eea55ab46ededb5ad05449b2dbef6b9866846 999212
postgresql-client-9.1_9.1.16-0+deb7u2_amd64.deb
a2b0125bff05d8f37fc20315448667291581ee33 555700
postgresql-server-dev-9.1_9.1.16-0+deb7u2_amd64.deb
5e77a9b563e038e28f8d87134712da2e73067865 1645064
postgresql-doc-9.1_9.1.16-0+deb7u2_all.deb
68d99701afa4e5a04b3a097e2910527b6a03a0be 365352
postgresql-contrib-9.1_9.1.16-0+deb7u2_amd64.deb
83fdea2b62c5c91518dc51ec8cfcde240a2e70b8 73418
postgresql-plperl-9.1_9.1.16-0+deb7u2_amd64.deb
17d6cbcc881010fe4b290cc9cd4af778f59acd64 57684
postgresql-plpython-9.1_9.1.16-0+deb7u2_amd64.deb
c1e8ce812f227dc1585a2d8a015d873f66615b1d 57388
postgresql-plpython3-9.1_9.1.16-0+deb7u2_amd64.deb
31bcc907bd282cb06d5e08d39bf798476b38f95c 47672
postgresql-pltcl-9.1_9.1.16-0+deb7u2_amd64.deb
Checksums-Sha256:
94b409f68a16825439b84a5c14daafc2e841eb08575dd8c6dff3afa983598ff5 3339
postgresql-9.1_9.1.16-0+deb7u2.dsc
67d80561f0cf4e809ae7df789237f087b9d406d67ce52d72a0fdfd70d8fdd1f9 46544
postgresql-9.1_9.1.16-0+deb7u2.debian.tar.gz
19c80f6629a6812964208b728e0ceb910c5eff3ba8502921f2f0edcbff21c02c 194044
libpq-dev_9.1.16-0+deb7u2_amd64.deb
af36c45f73f294963d10ce02eaa3f16c2f72c64518014fd4d15736ad1a83ebee 138360
libpq5_9.1.16-0+deb7u2_amd64.deb
ad953b3c18cc0897178bf91cee9a0a5337855b3a46bc830433104d553540703e 95416
libecpg6_9.1.16-0+deb7u2_amd64.deb
ca678dda3aae448ba837467c16d82ea587b82472ef20fd13ccb9c37870acd78b 227490
libecpg-dev_9.1.16-0+deb7u2_amd64.deb
2bf26adc87d8fb5a436f87b7ba288f35e954d32473470efa4c85dbd1bc020a89 33068
libecpg-compat3_9.1.16-0+deb7u2_amd64.deb
349ea842eb845dfef6fa07f60f49af980e6aa09b2aed412a28ba47097435aeba 54386
libpgtypes3_9.1.16-0+deb7u2_amd64.deb
1db38c677af08457f1390273815af20b695260c5b05f54c4e9f5a0edb2e94bc6 3292302
postgresql-9.1_9.1.16-0+deb7u2_amd64.deb
729750f38aac69e83e830e13baea109731119e2bd9f35e7fc1a76eb5b2417ac0 6705262
postgresql-9.1-dbg_9.1.16-0+deb7u2_amd64.deb
c8b63e1a3044e68895a6ddfbc72bc527c1190df25fd2f68df64c540120d9d387 999212
postgresql-client-9.1_9.1.16-0+deb7u2_amd64.deb
58f1da373daf0d2fa5ec43d2ccec4f8449fd74a8a7bc2d9f79129806be884113 555700
postgresql-server-dev-9.1_9.1.16-0+deb7u2_amd64.deb
003e12b7b774436452275697fd5da6e3d0d2cdd1e9b0c18ec7b369ffdde46e0b 1645064
postgresql-doc-9.1_9.1.16-0+deb7u2_all.deb
6185b5ab07249ad6ac623e7229c0dff62cc00934e780045bed18749c9ab26e26 365352
postgresql-contrib-9.1_9.1.16-0+deb7u2_amd64.deb
0a4ff1783e0fab03c507e1b38d86b48ee7b11abfd64913d4b840f29d26323ff0 73418
postgresql-plperl-9.1_9.1.16-0+deb7u2_amd64.deb
d0167875402545cc88893d4dcc3717dad1e7936e442000cd5cd9d2e311d774ab 57684
postgresql-plpython-9.1_9.1.16-0+deb7u2_amd64.deb
846c7bd27a370cc3feb3f1bb7cc06a0e77e17ad2fd53f9a7d007612f24758f69 57388
postgresql-plpython3-9.1_9.1.16-0+deb7u2_amd64.deb
b17b76e397e2ebcbb3f45cf186336373c6e5d69921246826729923dc7835b601 47672
postgresql-pltcl-9.1_9.1.16-0+deb7u2_amd64.deb
Files:
dd46b95b6f0afc5d007e2826ca51155e 3339 database optional
postgresql-9.1_9.1.16-0+deb7u2.dsc
42ee354f3f7a599e22bb89fa45acafb3 46544 database optional
postgresql-9.1_9.1.16-0+deb7u2.debian.tar.gz
8f457889a19560162d195d6d7d687a95 194044 libdevel optional
libpq-dev_9.1.16-0+deb7u2_amd64.deb
0277074395939fb4d35de6a10e2c5681 138360 libs optional
libpq5_9.1.16-0+deb7u2_amd64.deb
c989ecc201deb26c80d0f3dd8b040b2d 95416 libs optional
libecpg6_9.1.16-0+deb7u2_amd64.deb
160bfe14b8060d500808681701713a50 227490 libdevel optional
libecpg-dev_9.1.16-0+deb7u2_amd64.deb
bf8e1c9b5458746f1a29f2d4eeb96896 33068 libs optional
libecpg-compat3_9.1.16-0+deb7u2_amd64.deb
9fccfcf29f882312cc5955f6ee33ff4f 54386 libs optional
libpgtypes3_9.1.16-0+deb7u2_amd64.deb
5ea8a1e64921477e7dc543128a465427 3292302 database optional
postgresql-9.1_9.1.16-0+deb7u2_amd64.deb
51e8ee943d9c02c9fcc0488fd8647335 6705262 debug extra
postgresql-9.1-dbg_9.1.16-0+deb7u2_amd64.deb
1865ce4b8de4b927e1d3410d30325e1b 999212 database optional
postgresql-client-9.1_9.1.16-0+deb7u2_amd64.deb
c0798880a4e16b95ecbc7d5f52f2d011 555700 libdevel optional
postgresql-server-dev-9.1_9.1.16-0+deb7u2_amd64.deb
b9fc0168e10eb300477e211980400c4a 1645064 doc optional
postgresql-doc-9.1_9.1.16-0+deb7u2_all.deb
c008fbf042e8eaf114d5b4f808dad6b7 365352 database optional
postgresql-contrib-9.1_9.1.16-0+deb7u2_amd64.deb
550f5ae7268f5303179b4bc483f37151 73418 database optional
postgresql-plperl-9.1_9.1.16-0+deb7u2_amd64.deb
3dd7b1e9902b4bbd5c0c0f6feef3b107 57684 database optional
postgresql-plpython-9.1_9.1.16-0+deb7u2_amd64.deb
4f443450138035e0b358a881fc8f4d2c 57388 database optional
postgresql-plpython3-9.1_9.1.16-0+deb7u2_amd64.deb
d7b877fa585180124ab4b5a579b49c3a 47672 database optional
postgresql-pltcl-9.1_9.1.16-0+deb7u2_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQIcBAEBCAAGBQJVaM9XAAoJEExaa6sS0qeurQUQAISSeovP2CkvUPLDngzzCX0n
un2DKvUdaJHq2yPnVQfE4l2PGAL1ubziYUEoqKfghbZfZaFRUpNPpdjrlbpGpY/I
UXniOzwZ40hxPEahRzopkhKyjhWN+Zjxd6xV0zMHSvqFg3xWDnejYBvEhpMakVKN
jkrfOn/u+aQyHvfoCDPj4HRDQ9htfwYKU3hHv3Tjj1pyIBThZGmnSPYzPTFT3CzU
qMLP+irh0RjP4ts4WySW3tzJL1M4o2wy9rsweGPyZtSfqKWk1fFpKtOYNlubza/B
JjpdFc9tp9w2n3YjmNOVd4XRXgBsU0OX/JLZWkrtyxz2+0oiHz6myaZUPbUwierv
srgvqHYtT1bhPdsDBOtN/XcbihuemEXiU7nQSJmp+Y9fa8ED/A9wyx4Y+2ebDUrl
C/PAwQhf84wh9q9X4MNflJq67DfHj8NKySQRpdvfyWySf0/6Gfc7wlb+fG64UagG
wGxdMJIsFge21s9t96sxGyb3L6GacsBM4GwkRRbzgPj6CrukSRU5u3+EIQmf3tx9
OnhjxMrRSBBImYrkCvlxigDB1vOtrcBiajuUGVq87qa/XHoX9qZImdUy4yE6nE4k
LOZ+V7XKeos2DViUM4omLG36m6g0HQTfoDrvV8DlqaIHw5G3EV0YNtAU9hw6DNtV
h84GzVaOFsJ7EpauZP9C
=VQPx
-----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
