Umm... I'm no crypto guru, but I've never heard of MD5 having variants, let alone a salt. MD5 is MD5 is MD5. APR, incidentally, is the Apache Runtime, afaik - part of the build kit for apache modules.
I strongly suspect your problem is on another level. ----- Original Message ----- > From: "Edward avanti" <edward.ava...@gmail.com> > To: mysql@lists.mysql.com > Sent: Monday, 7 March, 2011 5:54:02 AM > Subject: Re: mysql apache md5 > > everything to do with mysql > I try make it clearer, sorry for not so in first post > > customer relationship manager add users into mysql > we want not to use apache auth of encrypt, but use md5 for longer > password > apache use variant of md5, called md5 -apr, but mysql md5 only uses > the -1 > type > so, when CRM add userlike > INSERT INTO users (..other....`appass`) values (...other... > 'MD5('$PASS') > .... > the md5 -1 that mysql uses is not compatible so apache auth fail. the > variant is apaprently add > $apr1$<up to 8 chars>$md5passwordhere, > making allabove line the salted md5. > I try to get mysql and apache to play nice, but thy do not because > mysql and > apache not use same method, hence my attempt to work around, even SHA > same > affect, i am try use anything but DES encrypt('$PASS') > sadly that only thing that work happily witrh each other. > openssl have ability to do this so not sure why mysql not have option > > Sure someone had same problem and simple work around to have mysql > use > correct md5, but no google fu work > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org