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

Reply via email to