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.avanti@stripped>
> To: mysql@stripped
> 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
> apache use variant of md5, called md5 -apr, but mysql md5 only uses
> the -1
> so, when CRM add userlike
> INSERT INTO users (..other....`appass`) values (...other...
> 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
> 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
> 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