Re: Access Denied on Administrator login

["Dave Coventry" <..hidden..>]

Hi Chris, thanks for the help.

>This is LedgerSMB 1.2.x, correct?
Yes it is 1.2.9

>In psql, run the following command:  UPDATE users_conf SET password =
>md5['superSecretPassword') WHERE id = (select id from users where >username =
>'admin');

As user ledgersmb
# su ledgersmb

Then
UPDATE users_conf SET password = 'uscvt4acutr' WHERE id = (select id
from users where username = 'admin');

Which generates the following error:
ERROR:  new row for relation "users_conf" violates check constraint
"users_conf_password_check"

Many thanks,

Dave Coventry