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

[fabpiaf]

metasploit-framework/msfdb

Line 268 in 8a46b2b

run_cmd('bundle exec rake db:migrate')

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]

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]

not stale I guess?