Development environment fails to run tests without msfdb --msf-test-db-user-name option

[Lazula]

Steps to reproduce

Follow the setup steps, including starting the database with ./msfdb init. No errors are reported until running rake spec.

Were you following a specific guide/tutorial or reading documentation?

https://github.com/rapid7/metasploit-framework/wiki/Setting-Up-a-Metasploit-Development-Environment

Expected behavior

The test suite should run.

Current behavior

rake spec fails with the error ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR: must be owner of database msftest.

Fix

I was able to fix the problem by running ./msfdb delete to remove the problematic database and using ./msfdb init --msf-test-db-user-name $(whoami). After this, rake spec runs the tests as expected.

Metasploit version

953a4cb5dc0e6fa2dc0ba0fccf073f96403f4ce2 (HEAD -> master, origin/master, origin/HEAD) Land #16171, Generate links to new docs site

[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.

[adfoster-r7]

I haven't set up a fresh environment in a while; but my workflow for running tests involves setting up the database with bundle exec rake db:migrate RAILS_ENV=test

I'll keep this open for now 👍