29 Mar
2006
29 Mar
'06
4:59 a.m.
Nice.
This looks perfect. I really appreciate it.
Does mysql 4.1 support the MD5 call?
--- Urtho junk@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