27 Mar
2006
27 Mar
'06
8: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