Although you reset the password, you also need to re-enable the account. There's 2 additional fields to check.
Blanket command to enable all accounts and reset login attempts
#dbc "update users set login_attempts = '0', is_enabled = 1;"
note that login attempts is an integer string, so needs single quotes. if you want to be more specific, you can add where username=<insert user> at the end like so:
#dbc "update users set login_attempts = '0', is_enabled = 1 where username = 'rgin';"
Referencing article: http://community.arubanetworks.com/t5/Network-Management/Airwave-Password-Recovery/m-p/34149/highlight/true#M351
Keep in mind that in AMP 8+, there's an additional column 'is_enabled' that should be set to 1. You may also need to reset 'login_attempts' as well (by default, the max login attempts is 10 tries before account is disabled).
# dbc "select * from users where username='admin';"
-[ RECORD 1 ]---+-------------------------------------------------------------------------------------------------------------------------------
id | 1
username | admin
password | 2cf94b0aea63ebf7bf41c90fe500603e
role_id | 5
full_name | admin
email | admin@blank.com
phone | 555-555-5555
notes |
password_format | md5
login_attempts | 0
is_enabled | 1