...
Resetting Revive Adserver account passwords.
There are a number of two different ways that user account passwords can be re-set in Revive Adserver, to deal with the situation where a user has forgotten their password.
...
| Note |
|---|
It will be necessary to ensure that your PHP installation has been correctly configured to send email, for the Revive Adserver "Forgot your password?" option to work correctly. |
...
. |
Manual Reset
In the event that a user no longer has access to the email address set up for their account, preventing them from using the self-service password reset option above, the user's password will need to be reset manually via the Revive Adserver database.
| Warning |
|---|
Please be very careful performing a manual password reset. It is your responsibility to be 100% certain that the account you change and the password you supply are to a known, trusted person, otherwise you risk exposing access to your Revive Adserver instance to malicious users. You may be better removing the account that is no longer able to be accessed, and create a brand new account, using the known email address of the person the account is intended to be for, rather than manually changing the password of an existing account, and providing that password to someone you may not be able to be completely certain is who they say they are. |
| Info |
|---|
The following SQL statements may need to be adjusted to meet your specific installation's setup. |
Step 1: Check there is only one account for the appropriate email address
| Code Block |
|---|
select * from rv_users where email_address = 'email@example.com'; |
If there is more than one account, you will need to determine which account you want to reset the password for, and then, in the SQL below, use the account's user_id to select the appropriate row to update, instead of the email address.
Step 2: Reset the account password
| Code Block |
|---|
update rv_users set password = MD5('new_password') where email_address = 'email@example.com'; |