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
Thread
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