msf連接postgresql時(shí)因排序規(guī)則版本不匹配導(dǎo)致無法連接
1、今天在數(shù)據(jù)庫全面升級(jí)之后，用新版msf連接新版postgresql時(shí)出現(xiàn)了告警
警告: ?database "msf" has a collation version mismatch
DETAIL: ?The database was created using collation version 2.36, but the operating system provides version 2.37.
HINT: ?Rebuild all objects in this database that use the default collation and run ALTER DATABASE msf REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
?
大意是數(shù)據(jù)庫的排序規(guī)則版本和安裝的版本不匹配，需要更新一下
sudo -u postgres psql -U postgres -d msf
REINDEX DATABASE msf;
ALTER DATABASE msf REFRESH COLLATION VERSION;
完成，可以連接了
補(bǔ)充：postgresql數(shù)據(jù)庫賬號(hào)密碼獲取
cat?/usr/share/metasploit-framework/config/database.yml
連接方式
db_connect username:password@localhost:端口號(hào)/數(shù)據(jù)庫名
