FranzF,
You have misunderstood the question. This has nothing to do with the MySQL
user, but the user that is stored in MySQL *THROUGH* OTRS. Hence why this
forum is the best shot I have of getting the correct information. Running
the server with --old-password is not relevant. My question is what
encryption scheme does OTRS use to encrypt the user supplied password,
nothing more. Unlike other applications I've come across, OTRS is a bit
confusing to figure out which hash algorithm was used when encrypting the
user's password.
Marco Geweke,
I tried your method, but it did not work. For one thing, there is no
crypt() function in MySQL. I tried encrypt, and decrypt, but it did not
work.
I wasn't aware this was going to be such a challenge, none the less, I would
like anyone who has successfully integrated the OTRS system_user or
customer_user password field to speak up! =)
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
_________________________________________________________________
Dont just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/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/