[Users] ha1 ha2

[Daniel-Constantin Mierla]

On 03/29/06 07:59, Frogger wrote:
> Nice.
>
> This looks perfect.  I really appreciate it.
>
> Does mysql 4.1 support the MD5 call?
>   
yes, see: http://dev.mysql.com/doc/refman/4.1/en/encryption-functions.html

Cheers,
Daniel

>
>
> --- Urtho <junk at urtho.net> wrote:
>
>   
>>>> Frogger wrote:
>>>>         
>>>>> If I am interested in doing my own insert into
>>>>>           
>> the
>>     
>>>>> openser db how should I calculate the following
>>>>> fields:
>>>>>
>>>>> ha1 ha2
>>>>>
>>>>>           
>> I use the following trigger in a setup with domain
>> support and MySQL 5.0 :
>>
>> CREATE TRIGGER `tr_insert_subscriber` BEFORE INSERT
>> ON `subscriber` FOR EACH ROW
>> BEGIN
>>     SET NEW.ha1 =
>>
>>     
> MD5(CONCAT(NEW.username,':',NEW.domain,':',NEW.password));
>   
>>     SET NEW.ha1b =
>>
>>     
> MD5(CONCAT(NEW.username,'@',NEW.domain,':',NEW.domain,':',NEW.password));
>   
>> END
>>
>>
>> -- 
>> Regards,
>>  Pawel Pierscionek
>>
>>
>>     
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>