Hey, I have a problem deleting one of our local admin users on InsightVM console. On the first try of deleting the user, the system recommended to transfer all existing reports to another user, and that is what I did. After that, there was no notification or so whether this was successfully done or not. Now when I try to delete the user, it just keeps saying “deleting” in the banner but nothing happens.
Any tips? Is there a way to force delete user from cmd?
Apparently it is a “default account” created during the installation. Default account can’t be deleted. A fresh install of the console is needed if you need to get rid of the account.
Coming back to this! There was a way that we logging into the database directly and had to delete user from the database itself. Support Engineer helped us through that process I can dig it up if there is still a need
hank you for providing the screenshot, the best step to resolve this issue is to remove the user directly by manipulating the database, and I’ve detailed the steps below on how to do this!
PLEASE NOTE: it is important to create a backup before directly manipulating the database, in the event that you may need to restore to the previous version.
LOGGING INTO DATABASE: From your host OS command line, follow these steps:
Unlock the Database
Change all the ‘md5’ entries to ‘trust’ in the pg_hba.conf file by running the command:
sed -ibak ‘s/md5/trust/g’ /opt/rapid7/nexpose/nsc/nxpgsql/nxpdata/pg_hba.conf
Reload Database:
Reloading the database config can only be done when no scans are in progress, you can run the following command:
sudo -u nxpgsql /opt/rapid7/nexpose/nsc/nxpgsql/pgsql/bin/pg_ctl -D /opt/rapid7/nexpose/nsc/nxpgsql/nxpdata reload
Log into Database
cd /opt/rapid7/nexpose/nsc/nxpgsql/bin
./psql -U nxpgsql -d nexpose
You should get an output similar to the following:
root@Server1337:/opt/rapid7/nexpose/nsc/nxpgsql/pgsql/bin# ./psql -nU nxpgsql nexpose
psql (15.5)
Type “help” for help.
nexpose=#
DATABASE/SQL QUERIES: now that you are in the database, there are some queries that you must run, copy and paste these commands:
SET search_path to nxsilo_default, nxadmin;
SELECT * FROM users;
use the resulting table to find the user_id associated with the account you need to delete
DELETE FROM users WHERE user_id=x;
where you replace the value for user_id as necessary.