[opensuse] MySQL encryption agent
Greetings list openSuSe 10.2 MySQL 5.0.26 How can I establish what the standard encryption agent(s) is (are) for MySQL? SELECT ENCRYPT('password'), PASSWORD('password'), MD5('password'); generates a different encrypted password to what: select * from user; does, and I think this is why my database lookups aren't auth'ing. How would I go about changing the standard encryption agent if I could? Regards, Stuart -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On 7/16/07, Stuart Murray-Smith
Greetings list
openSuSe 10.2 MySQL 5.0.26
How can I establish what the standard encryption agent(s) is (are) for MySQL?
SELECT ENCRYPT('password'), PASSWORD('password'), MD5('password');
generates a different encrypted password to what:
select * from user;
does, and I think this is why my database lookups aren't auth'ing.
How would I go about changing the standard encryption agent if I could?
Regards,
Stuart
Stuart,
If Suse does anything unusual or overrides a default they document it
a couple of ways.
One, they often have a README.SuSE or similar in /usr/share/doc/packages.
i.e Checkout /usr/share/doc/packages/mysql/README.SuSE
Unfortunately I don't see an answer to your question there.
The second thing is to install the mysql source rpm and extract the specfile.
You can get the source rpm off the DVD/CD you installed from and use
rpmbuild to compile it.
rpmbuild --rebuild mysql.src.rpm
I think that will create a rpm file you can install. By looking at
the specfile it extracts you can see what patches SuSE applied beyond
the standard code. You can also see any args they pass into make etc.
Further, if there is something in the specfile you want to change, you
can do that manually then recompile with:
rpmbuild -bb
Stuart Murray-Smith escribió:
Greetings list
openSuSe 10.2 MySQL 5.0.26
How can I establish what the standard encryption agent(s) is (are) for MySQL?
SELECT ENCRYPT('password'), PASSWORD('password'), MD5('password');
generates a different encrypted password to what:
you are seriuolsy confused, this is the expected behaviuor. ENCRYPT calls crypt() system call PASSWORD is mysql specific way to encrypt password suitable for encrypting MySQL passwords for storage in the "Password" column of the user grant table. ( do not use this in your app) MD5 quite obviuoly uses MD5 if you are coming from older mysql versions, and you used PASSWORD() to "encrypt" your passwords in newver mysql versions you must use OLD_PASSWORD() to obtain the same old result. this function is deprecated and I suggets you convert your passwords (with the password reminder form) ASAP because it may go away at anytime soon. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (3)
-
Cristian Rodriguez R.
-
Greg Freemyer
-
Stuart Murray-Smith