27 Mar
2006
27 Mar
'06
11:39 p.m.
> 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