Re: Access Denied on Administrator login

On Dec 7, 2007 11:49 PM, Dave Coventry <..hidden..> wrote:

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');

Hmmm..... That doesn't look like an MD5 sum to me :-)
UPDATE users_conf SET password = md5('uscvt4acutr').....

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

Many thanks,

Dave Coventry

-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users