This all came about with the release of 4.10. Rapid7 is aware of the 'aftermath' of it. For more information ~ https://community.rapid7.com/communi...ting-the-wheel
In short, you need to tell Metasploit the database location if you upgrade. (If you do a fresh install, its been fixed).
Method one - point to the database (you can copy or soft-link. I prefer to soft-link.).
ln -sf /opt/metasploit/apps/pro/ui/config/database.yml /root/.msf4/database.yml
#cp /opt/metasploit/apps/pro/ui/config/database.yml /root/.msf4/database.yml
Method two - use an alias when starting up msfconsole
file=/root/.bash_aliases; [ -e $file ]
grep -q '^alias msfconsole' $file 2>/dev/null || echo -e '\n### Metasploit\nalias msfconsole="msfconsole db_connect -y /opt/metasploit/apps/pro/ui/config/database.yml"\n' >> $file