Again this should have been asked in a mySQL List, however:
Why not do the Job with mySQL directly ?
SELECT count(*) FROM system_user WHERE pass=password("yourplaintextpass");
Started your Server with --old-passwords ? No problem, just use
"pass=old_password()" instead.
hth
FranzF
Solaris User wrote:
> What type of hash does OTRS v2 use when storing a password in MySQL?
> It looks like crypt, but I am unable to tell what the salt is.
>
> Essentially, my problem is that I want to interface with the 'pw'
> field in the system_user table using a PHP page I made. I am currently
> unable to do this because I do not know how to encrypt the plaintext
> given by a user in the PHP page, encrypt it, and compare it to the
> 'pw' field in the system_user table.
>
> Any help is greatly appriciated!
>
> _________________________________________________________________
> FREE pop-up blocking with the new MSN Toolbar – get it now!
> http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
>
> _______________________________________________
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
> Support oder Consulting für Ihr OTRS System?
> => http://www.otrs.de/
>
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
