View Issue Details

IDProjectCategoryView StatusLast Update
0002292Kali LinuxGeneral Bugpublic2018-01-29 11:49
Reportersinamanavi Assigned Tog0tmi1k  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionsuspended 
Product Version1.1.0 
Summary0002292: PostgreSQL can not run due to ssl problem
Description

I have tried to run the postgreSQL since the last update and upgrade and I am facing the following error, which as a result, the Metasploit can not work properly as well. would you please kindly help me how can solve this issue? since the postgresql service can not be started properly, the metasploit doesnt respond properly as well.

service postgresql restart
[....] Restarting PostgreSQL 9.1 database server: main[....] The PostgreSQL server failed to start. Please check the log output: 2015-05-26 12:02:18 MYT LOG: database system was interrupted; last known up at 2015-05-23 18:57:12 MYT 2015-05-26 12:02:18 MYT FATAL: could not open file "/etc/ssl/certs/ssl-cert-snakeoil.pem": Permission denied 2015-05-26 12:02:18 MYT LOG: startup process (PID 6143) exited with exit code 1 201[FAIL26 12:02:18 MYT LOG: aborting startup due to startup process failure ... failed!
failed!

Steps To Reproduce

I have searched this issue over the Internet, and seems others faced the same issue as well

Activities

rhertzog

rhertzog

2015-05-26 08:47

administrator   ~0003314

Please explain us in what situation you have the problem. Is this with the live image or with an installed system? Do you remember doing something special that broke your setup?

Please give the output of the following commands:
ls -al /etc/ssl/certs/ssl-cert-snakeoil.pem /etc/ssl/private/ssl-cert-snakeoil.key
dpkg -s ssl-cert

Thank you.

sinamanavi

sinamanavi

2015-05-27 05:08

reporter   ~0003323

thanks for helping me.

result of the request command is as follows:

command:ls -al /etc/ssl/certs/ssl-cert-snakeoil.pem /etc/ssl/private/ssl-cert-snakeoil.key
Results:

-rw-r--r-- 1 root root 1005 May 26 11:57 /etc/ssl/certs/ssl-cert-snakeoil.pem
-rw-r----- 1 root ssl-cert 1704 May 26 11:57 /etc/ssl/private/ssl-cert-snakeoil.key

and for the second command I have the following results:
command:
dpkg -s ssl-cert
results:
Package: ssl-cert
Status: install ok installed
Priority: optional
Section: utils
Installed-Size: 101
Maintainer: Debian Apache Maintainers <[email protected]>
Architecture: all
Version: 1.0.32
Depends: debconf (>= 0.5) | debconf-2.0, openssl (>= 0.9.8g-9), adduser
Suggests: openssl-blacklist
Description: simple debconf wrapper for OpenSSL
This package enables unattended installs of packages that
need to create SSL certificates.
.
It is a simple wrapper for OpenSSL's certificate request utility that
feeds it with the correct user variables.

rhertzog

rhertzog

2015-05-27 07:22

administrator   ~0003324

The file itself is readable by everyone so postgresql should be able to open it. What about the parent directories? Please provide the output of:
ls -adl /etc /etc/ssl /etc/ssl/certs

sinamanavi

sinamanavi

2015-05-27 09:33

reporter   ~0003325

ls -adl /etc /etc/ssl /etc/ssl/certs
drwxr-xr-x 179 root root 12288 May 27 17:20 /etc
drwxr-xr-x 4 root root 4096 Mar 27 19:49 /etc/ssl
drwxr-xr-x 3 root root 28672 May 26 11:57 /etc/ssl/certs

service postgresql start
[....] Starting PostgreSQL 9.1 database server: main[....] The PostgreSQL server failed to start. Please check the log output: 2015-05-27 17:32:13 MYT LOG: database system was interrupted; last known up at 2015-05-23 18:57:12 MYT 2015-05-27 17:32:13 MYT FATAL: could not open file "/etc/ssl/certs/ssl-cert-snakeoil.pem": Permission denied 2015-05-27 17:32:13 MYT LOG: startup process (PID 4593) exited with exit code 1 2015-[FAIL 17:32:13 MYT LOG: aborting startup due to startup process failure ... failed!
failed!

muts

muts

2015-05-27 11:08

reporter   ~0003326

I've seen this happen with improper shutdowns of postgresql, on Docker.

sinamanavi

sinamanavi

2015-05-27 11:25

reporter   ~0003327

im not using Docker,
so how can I solve this issue.
I usually once I finished my tasks on the Kali, I simply turn it off by poweroff command.

muts

muts

2015-05-27 11:27

reporter   ~0003328

This is not a support forum, but a bug tracker.

sinamanavi

sinamanavi

2015-05-27 11:28

reporter   ~0003329

but this just happned since I updated my kali .

sinamanavi

sinamanavi

2015-05-27 11:28

reporter   ~0003330

by the way thanks for your effort.

g0tmi1k

g0tmi1k

2018-01-29 11:49

administrator   ~0008051

Due to the age of the OS (Kali Moto [v1], Kali Safi [v2], Kali Rolling 2016.x), these legacy versions are no longer supported.
We will be closing this ticket due to inactivity.

Please could you see if you are able to replicate this issue with the latest version of Kali Linux - https://www.kali.org/downloads/)?

If you are still facing the same problem, feel free to re-open the ticket. If you choose to do this, could you provide more information to the issue you are facing,and also give information about your setup?
For more information, please read: https://kali.training/topic/filing-a-good-bug-report/

Issue History

Date Modified Username Field Change
2015-05-26 04:07 sinamanavi New Issue
2015-05-26 08:47 rhertzog Note Added: 0003314
2015-05-27 05:08 sinamanavi Note Added: 0003323
2015-05-27 07:22 rhertzog Note Added: 0003324
2015-05-27 09:33 sinamanavi Note Added: 0003325
2015-05-27 11:08 muts Note Added: 0003326
2015-05-27 11:25 sinamanavi Note Added: 0003327
2015-05-27 11:27 muts Note Added: 0003328
2015-05-27 11:28 sinamanavi Note Added: 0003329
2015-05-27 11:28 sinamanavi Note Added: 0003330
2018-01-29 11:49 g0tmi1k Assigned To => g0tmi1k
2018-01-29 11:49 g0tmi1k Status new => closed
2018-01-29 11:49 g0tmi1k Resolution open => suspended
2018-01-29 11:49 g0tmi1k Note Added: 0008051