If I am interested in doing my own insert into the openser db how should I calculate the following fields:
ha1 ha2
Any example procedure would be greatly appreciated.
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Below are recent items related to your post:
http://openser.org/pipermail/devel/2006-March/002323.html http://openser.org/pipermail/devel/2006-March/002324.html
Regards, Norm
Frogger wrote:
If I am interested in doing my own insert into the openser db how should I calculate the following fields:
ha1 ha2
Any example procedure would be greatly appreciated.
Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Thanks for the quick note.
I will check this out.
It looks like its as simple as passing the parameters to md5 generator.
--- Norman Brandinger norm@goes.com wrote:
Below are recent items related to your post:
http://openser.org/pipermail/devel/2006-March/002323.html
http://openser.org/pipermail/devel/2006-March/002324.html
Regards, Norm
Frogger wrote:
If I am interested in doing my own insert into the openser db how should I calculate the following fields:
ha1 ha2
Any example procedure would be greatly
appreciated.
Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam
protection around
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
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
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
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@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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
I have built some routines but my results are not matching.
Basically I am getting a shorter result 24 digits vs. 32 in the OpenSer db.
Any thoughts?
--- Norman Brandinger norm@goes.com wrote:
Below are recent items related to your post:
http://openser.org/pipermail/devel/2006-March/002323.html
http://openser.org/pipermail/devel/2006-March/002324.html
Regards, Norm
Frogger wrote:
If I am interested in doing my own insert into the openser db how should I calculate the following fields:
ha1 ha2
Any example procedure would be greatly
appreciated.
Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam
protection around
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
I got it figured out.
I was inappropriately converting the hashed array back into an encoded string.
Thanks for your guidance.
--- Norman Brandinger norm@goes.com wrote:
Below are recent items related to your post:
http://openser.org/pipermail/devel/2006-March/002323.html
http://openser.org/pipermail/devel/2006-March/002324.html
Regards, Norm
Frogger wrote:
If I am interested in doing my own insert into the openser db how should I calculate the following fields:
ha1 ha2
Any example procedure would be greatly
appreciated.
Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam
protection around
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
-
Daniel-Constantin Mierla -
Frogger -
Norman Brandinger -
Urtho