Hi Christopher.
Thanks for the info.
Complementing, the procedure depends on the version (11.0 in my case) and I found this information:
Future Support - Starting with On-Premises SecureSphere version v13.6.0.30 and 14.1.0 and higher you will be able to execute the command form the MX CLI which will reset the password to webco123
impctl support server --reset-admin-passwordThe following steps are to reset the password to webco123 by updating the MX DB.
Initial Steps
- Login to the MX via SSH as user root (or through another user and elevate)
- Run the command "su - oracle"
- Login to the local database by running the command
- "sqlplus secure/<password of user secure>". For example: sqlplus secure/webco123
- Enter the following queries on the prompt:
The following steps will change the password to "webco123" :
- For for V13.2 and earlier
UPDATE SECURE.CONF_SECURE_MEMBERS SET password = 'c803ac767fddcdfc230a31c98ed27745' WHERE dn = 'admin';
commit;
- For for V13.3 and newer - the encryption string is different
UPDATE SECURE.CONF_SECURE_MEMBERS SET password = '$2a$07$zFlZZFscmZuxCIltoclHk..NuPzrZTUHl3BhkQW5ImwiJiURgO9LC' WHERE dn = 'admin';commit;It is important that the password is between '', example 'password'
And for the recovery of the root password and the bootloader password, I followed the following links:
https://wiki.centos.org/TipsAndTricks/ResetRootPasswordhttps://www.youtube.com/watch?v=t0OgDxV6AFU
I hope not to violate any policy by putting these links and help many friends.Thanks for your help.
Solved case!!.
------------------------------
Juan Nogueron
Wise Solutions
CD MX DIF
------------------------------
Original Message:
Sent: 04-09-2020 08:07
From: Christopher Detzel
Subject: Reset Password admin and root
Juan,
I think this could answer your question. Let me know if it doesn't.
Documentation can be found here:
Resetting the Password for the 'admin' User in the GUI
To reset the admin password to SamplePassword123:
- Login to the MX via SSH as user root (or through another user and elevate).
- Run the command:
su - oracle
- Login to the local database by running the command "sqlplus secure/<password of secure user>". For example:
sqlplus secure/OldPassword
- Create a new password and hash it using the blowfish algorithm. For example, SamplePassword123 results in the hash: $2a$07$BpGXtpYkbz0bFtIS9NDX4OlDRfE/Fhb/xscFwN5lcXKq3Qb8mSQeu
- Enter the following query on the SQL> prompt using the hashed password you created:
UPDATE SECURE.CONF_SECURE_MEMBERS SET password = $2a$07$BpGXtpYkbz0bFtIS9NDX4OlDRfE/Fhb/xscFwN5lcXKq3Qb8mSQeu WHERE dn = 'admin';
commit;
- Type exit to exit the sqlplus prompt then exit again to return to the root unix prompt.
Now you can go to the Web interface and enter admin as the user, and the new password you configured, in the above example SamplePassword123.
------------------------------
Christopher Detzel
Community Manager
Imperva
Original Message:
Sent: 04-08-2020 20:51
From: Juan Nogueron
Subject: Reset Password admin and root
Hi there
I hope you can help me.
I have a device mx which I do not have the passwords of admin or root.
My question is if there is a way to reset the admin and root account.
Do you know of any documentation link that I can consult for this?
Thanks in advance.
JN
#On-PremisesWAF(formerlySecuresphere)
------------------------------
Juan Nogueron
Wise Solutions
CD MX
------------------------------