search

rapid7 / metasploit-framework

Metasploit Framework
https://www.metasploit.com/
Other
34.21k stars 13.99k forks source link

msfdb: `ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR: permission denied for schema public` + solution #19442

Open fabpiaf opened 2 months ago

fabpiaf commented 2 months ago

https://github.com/rapid7/metasploit-framework/blob/8a46b2b1255faaecd6f3f858b2ac1f3a6cb17fd0/msfdb#L268

This line fails with ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR: permission denied for schema public

my fix was

psql --dbname msf --username postgres --command "grant all on schema public to msf"

maybe its worth to include that into msfdb

github-actions[bot] commented 1 month ago

Hi!

This issue has been left open with no activity for a while now.

We get a lot of issues, so we currently close issues after 60 days of inactivity. It’s been at least 30 days since the last update here. If we missed this issue or if you want to keep it open, please reply here. You can also add the label "not stale" to keep this issue open!

As a friendly reminder: the best way to see this issue, or any other, fixed is to open a Pull Request.

fabpiaf commented 1 month ago

not stale I guess?

github-actions[bot] commented 4 days ago

Hi!

This issue has been left open with no activity for a while now.

We get a lot of issues, so we currently close issues after 60 days of inactivity. It’s been at least 30 days since the last update here. If we missed this issue or if you want to keep it open, please reply here. You can also add the label "not stale" to keep this issue open!

As a friendly reminder: the best way to see this issue, or any other, fixed is to open a Pull Request.

fabpiaf commented 4 days ago

not?