29 Mar
2006
29 Mar
'06
8:28 p.m.
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(a)urtho.net> wrote:
MD5(CONCAT(NEW.username,':',NEW.domain,':',NEW.password));
>
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 =
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users