Your message dated Thu, 04 Jun 2015 10:56:53 +0000
with message-id <[email protected]>
and subject line Bug#786874: fixed in postgresql-9.4 9.4.3-1
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-1
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-1
Distribution: unstable
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-1) unstable; urgency=medium
.
* New upstream version:
Avoid failures while fsync'ing data directory during crash restart
(Abhijit Menon-Sen, Tom Lane; Closes: #786874)
Checksums-Sha1:
1215918a02b33b9997a517382330486a80c84ebd 3490 postgresql-9.4_9.4.3-1.dsc
ca13047d38d09db0105cb39d74ba72a83d74d14b 17618524
postgresql-9.4_9.4.3.orig.tar.bz2
c5c3a6708d158bd6ce31a01abb400f62404308c1 20872
postgresql-9.4_9.4.3-1.debian.tar.xz
083d81412129944037cac0c0efc5359bf026ee31 14074
libecpg-compat3_9.4.3-1_amd64.deb
e7a2181d676a6fa7856bf438200d2616db575d69 215692 libecpg-dev_9.4.3-1_amd64.deb
ddbbbeb6c03bda77722910c7fd0fe9367a868f0c 77770 libecpg6_9.4.3-1_amd64.deb
f1e5be45cad30653048ebae82556f47096471054 36126 libpgtypes3_9.4.3-1_amd64.deb
5c948b3bc30fc43246bd735ab91a188d30c5a27a 161982 libpq-dev_9.4.3-1_amd64.deb
ba59cbcaf5a63b28b97ed0ff82873a8fa8b141f9 121494 libpq5_9.4.3-1_amd64.deb
d5dfe3fb2a16b0aecd210011155bfbcf2b309c6e 12047372
postgresql-9.4-dbg_9.4.3-1_amd64.deb
4fbf292514e55b97ca3fb4a6740190d2917243d6 3707816
postgresql-9.4_9.4.3-1_amd64.deb
37f32bef07779618292b8f3c70fa4d2be3e43009 1070242
postgresql-client-9.4_9.4.3-1_amd64.deb
0fbaa4a61202b72e3560524575be783d27165d2d 448588
postgresql-contrib-9.4_9.4.3-1_amd64.deb
6284daf19decdac5a0bd36a92f76bb33fafcc1eb 1828112
postgresql-doc-9.4_9.4.3-1_all.deb
16f2f2011bc96359e851ba43eed6296150134a82 54988
postgresql-plperl-9.4_9.4.3-1_amd64.deb
a523c13ebcc7edd9b9fb85a3d9bcee411be5f14c 43400
postgresql-plpython-9.4_9.4.3-1_amd64.deb
e39c08d68ee5ef7b3e55baa758245a462ad54d2c 43000
postgresql-plpython3-9.4_9.4.3-1_amd64.deb
02299426114481bd4ccd3ce470f5ab66891f20db 28834
postgresql-pltcl-9.4_9.4.3-1_amd64.deb
3cdf7a3471eadc3906661454333f3b53f0868de8 634470
postgresql-server-dev-9.4_9.4.3-1_amd64.deb
Checksums-Sha256:
3cb017b92ed5a9ceae090e31e1f946ec62224ee813c08a640855b6c02f3d01e3 3490
postgresql-9.4_9.4.3-1.dsc
734acfd2ac352dd0cd353d226f3199c2e1a2730200998aea5b38cf685136d755 17618524
postgresql-9.4_9.4.3.orig.tar.bz2
c0067c951d5f69e1261555191ce4934e924f8cc252652899427ab438359dcfc6 20872
postgresql-9.4_9.4.3-1.debian.tar.xz
3dd58626a07ec7c07524997e6338d5fe1fc8f4d5f3fa5d9c72dcdb257a0d3747 14074
libecpg-compat3_9.4.3-1_amd64.deb
a0d705ef7239804aebc08dc2ceabbd96375249e5b783875bb85a7c16262da2c6 215692
libecpg-dev_9.4.3-1_amd64.deb
9a22494d411704a37eff0b2d5ba8013214ccf7ef512e3727f0b96554aae2b58e 77770
libecpg6_9.4.3-1_amd64.deb
22c0d1472c0f6e5a5be5230239d43de52cce9a86395494a3fc3d85363dc9ebef 36126
libpgtypes3_9.4.3-1_amd64.deb
66fe1949c139d79bc7a31af9361808cbf47998e9147ee28114f431ba4a69b18f 161982
libpq-dev_9.4.3-1_amd64.deb
008fb3790ea964eec1a29fe029d92fca8f1783da73f64373f7b999c8a9aaf87e 121494
libpq5_9.4.3-1_amd64.deb
5eb5bc4026e42f8391aceaf47dba24a7744e663cbd284279725f10bf07be502c 12047372
postgresql-9.4-dbg_9.4.3-1_amd64.deb
038952439bdb36ea135161fd61319ddfcd995790a703b26c92776125c8424608 3707816
postgresql-9.4_9.4.3-1_amd64.deb
39b401dfb20d49554f47604947f4b900d3366caace19d92980dc69f292fa2722 1070242
postgresql-client-9.4_9.4.3-1_amd64.deb
b10f7020f0675086328c61cb395dbe90df694152bb3b977b35e147bf6a851fdb 448588
postgresql-contrib-9.4_9.4.3-1_amd64.deb
7810567ad9500a820976ac378f8b5082b60707cf9fd20182bd1f186cfaf97a9f 1828112
postgresql-doc-9.4_9.4.3-1_all.deb
2e26c7c6a6cafa0110d94284ce9049b8a89456e9955da440a7f0b2d27dc397ef 54988
postgresql-plperl-9.4_9.4.3-1_amd64.deb
89c9ebff4d2e172f93e3249f002ed569dcbcda1143c41342030cdc99ea64b978 43400
postgresql-plpython-9.4_9.4.3-1_amd64.deb
81ede244d45bda7605951323ae2d0c2fb0780eafa8da4214361f58b710590ce9 43000
postgresql-plpython3-9.4_9.4.3-1_amd64.deb
fe376d11e99f4de5b7fbfadc74ea61bef14420dce9c1d4d52f947492e4ee7286 28834
postgresql-pltcl-9.4_9.4.3-1_amd64.deb
cc816f4a181221ac0624c34c87df606eb356ee41efa1a9024759e0b4b4137268 634470
postgresql-server-dev-9.4_9.4.3-1_amd64.deb
Files:
206914b77277d9847fd388367516ec9d 3490 database optional
postgresql-9.4_9.4.3-1.dsc
05217e0921b51fb886e9e50875776bf1 17618524 database optional
postgresql-9.4_9.4.3.orig.tar.bz2
3d3c869f982fe725e69e082cd9cf041b 20872 database optional
postgresql-9.4_9.4.3-1.debian.tar.xz
2a2152c52cafa98d3aed1f1486c0a5c3 14074 libs optional
libecpg-compat3_9.4.3-1_amd64.deb
3e85b794ba2644591832b4b5321fbd1e 215692 libdevel optional
libecpg-dev_9.4.3-1_amd64.deb
879c36aaf4a250365130ecff759ece03 77770 libs optional libecpg6_9.4.3-1_amd64.deb
1e764b0d698f6188cbbb3bb7012d1de7 36126 libs optional
libpgtypes3_9.4.3-1_amd64.deb
c779f2ce6f9286e4671b62aee9e407c1 161982 libdevel optional
libpq-dev_9.4.3-1_amd64.deb
1f87e5e3b54d74e7b74145a6a01c051e 121494 libs optional libpq5_9.4.3-1_amd64.deb
e02258c08176e5ca57f225115d911443 12047372 debug extra
postgresql-9.4-dbg_9.4.3-1_amd64.deb
369f3fe9485d7ebf16885e93f82386c2 3707816 database optional
postgresql-9.4_9.4.3-1_amd64.deb
b93818424cb1c7fd678e6ab7a6bc0879 1070242 database optional
postgresql-client-9.4_9.4.3-1_amd64.deb
87b94f62c87a710014951e977b33b1eb 448588 database optional
postgresql-contrib-9.4_9.4.3-1_amd64.deb
a83bc456dda4eddb9b2246d068d702b8 1828112 doc optional
postgresql-doc-9.4_9.4.3-1_all.deb
cd91ee49a0e00032799cd83dc663e945 54988 database optional
postgresql-plperl-9.4_9.4.3-1_amd64.deb
b5f0ad4728bb47555923a1f5ad0afbbe 43400 database optional
postgresql-plpython-9.4_9.4.3-1_amd64.deb
f2aa567a78ce6704e4ea399bedecf819 43000 database optional
postgresql-plpython3-9.4_9.4.3-1_amd64.deb
a87baac9e28e2b742d5fd668bdfbd6f6 28834 database optional
postgresql-pltcl-9.4_9.4.3-1_amd64.deb
cec0801dade54c0180a70bdc1ff307d6 634470 libdevel optional
postgresql-server-dev-9.4_9.4.3-1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQIcBAEBCAAGBQJVcCpHAAoJEExaa6sS0qeuoQcP/iVIbVtModIt65IUGhhmkK9B
/7nnGsbqAnPtq5A9B6KaEBRigDLDQxvkwBEzpcWxusc3jV/tN5erSqBnzY687wbk
+cwQlfqCWNFNS5r0+dHr5K+e/k2NLgpCPHvCA/zHsst4yc4Dw7jzu/4SIjD7Zfmh
G8vn9hLc3wMgY2L74SsuXGolRpi4dp5BcYHrwm0wsq9Q28IpLG9m8ZDqMCJDEVZZ
JqsXkdeeyjPF/pTmoVAGMEFTikVGkVDdN+v79tRNGAxOwiODpQ/A8pRElzjWzgYm
6jXwmAY8DHJfTeDuaZxsn2t+IjPyEmXlk4YHfpNSwZ2plIjVLI2Yg5DpzdagpftZ
Tk6j8xefYhqEtaJ6HSRIQBuJoWghx+wPFxfjVD6UZu0KIPYdlJJ9G86k2e7nwSSI
CphS7G8Hz33NUG2JD+otNnwM5vqhV+Q4UVkVxB0VbBjThQNzVbWOFOKNRSytKzXx
rtjj4osh9+lSbFNFSRx1naQ0EBawwa86+vSEHMcmm12enk748iYDh+uqj6SACqHK
Oy/YSHv63/Gj1PnastCLs36Rm4Oeu8/YOWeAgHFe33flxRCB7wm5QiStbIPi+Egb
ySa5eolMY/u7hN8Z1XTZUfDYoWvmmdt8031E8+AIJQ4/D8QgQ3LRI4BEBGrOe6m9
jQd9DjfQodtnz6IQs+PW
=Pk5E
-----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
