List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 7 2011 12:51pm
Subject:Re: mysql apache md5
View as plain text  
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
> 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 apache md5Edward avanti6 Mar
  • Re: mysql apache md5Reindl Harald6 Mar
    • Re: mysql apache md5Edward avanti7 Mar
      • Re: mysql apache md5Johan De Meersman7 Mar
        • Re: mysql apache md5Noel Butler8 Mar