I installed Parrot security OS several moths ago and I used it for a while before realizing that I did not configure metasploit and its database, so I have got no connection between metasploit and postgresql sql.
I have also got this error while doing apt upgrade
The following packages have been kept back:
linux-headers-amd64 linux-image-amd64 python-cffi-backend
What version of Parrot are you running? (include version (e.g. 4.6), edition(e.g. Home//KDE/OVA, etc.), and architecture (currently we only support amd64)
ID=parrot
ID_LIKE=debian
VERSION=“4.10”
VERSION_ID=“4.10”
HOME_URL=“https://www.parrotsec.org/”
SUPPORT_URL=“https://community.parrotsec.org/”
BUG_REPORT_URL=“https://community.parrotsec.org/”
It is Parrot security OS based on amd64 architecture
What method did you use to install Parrot? (Debian Standard / Debian GTK / parrot-experimental)
I dont remember is there a way to check?
Configured to multiboot with other systems? (yes / no)
yes, configured without issues If there are any similar issues or solutions, link to them below:
not yet If there are any error messages or relevant logs, post them below:
I don’t know where to look for.
looks like postgresql is not run properly. metasploit can not connect to database.
psql
psql: error: could not connect to server: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?
I checked postgresql config page looks like 5432 port is configured
In /etc/postgresql/12/main/postgresql.conf I see
port = 5432 # (change requires restart)
And yes, everything is updated.
2020-07-12 17:52:50.897 UTC [4585] FATAL: could not load server certificate file “/etc/ssl/certs/ssl-cert-snakeoil.pem”: No such file or directory
2020-07-12 17:52:50.897 UTC [4585] LOG: database system is shut down
pg_ctl: could not start server
Examine the log output.
@fopr.ggame.playing & @disrupt_the_flow
I can confirm this is still an issue but I have figured out how to resolve it. I reinstalled parrot OS today, dual booted alongside windows without issues. Version 4.10.
Steps:
Fresh install of ParrotOS 4.10
Connected to network, ran “sudo parrot-upgrade”, then rebooted.
Noticed postgresql was not running.
/var/log/postgresql/postgresql-12-main.log showed “FATAL: could not load server certificate file “/etc/ssl/certs/ssl-cert-snakeoil.pem”: No such file or directory”
Regenerated the snakeoil cert with “sudo make-ssl-cert generate-default-snakeoil”
Rebuilt the database “sudo msfdb reinit”
Afterwards I was able to open armitage without issues.