On Dec 7, 2007 11:49 PM, Dave Coventry <[EMAIL PROTECTED]> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
