[Users] ha1 ha2 - sr-users - kamailio.org

List overview All Threads
Download

[Users] ha1 ha2

[Serusers] STATE OF PRESENCE

[Serusers] OpenSER x SER

Frogger

27 Mar 2006 27 Mar '06

10:04 p.m.

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

Reply

Show replies by date

Norman Brandinger

27 Mar 27 Mar

10:13 p.m.

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(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

Reply

Frogger

10:18 p.m.

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(a)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 > > http://mail.yahoo.com >

> > _______________________________________________ > > Users mailing list > > Users(a)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

Reply

Urtho

11:39 p.m.

New subject: Re[2]: [Users] ha1 ha2

> 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

Reply

Frogger

29 Mar 29 Mar

7:59 a.m.

New subject: Re[2]: [Users] ha1 ha2

Nice. This looks perfect. I really appreciate it. Does mysql 4.1 support the MD5 call? --- Urtho <junk(a)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

Reply

Daniel-Constantin Mierla

12: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:

> 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(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

Reply

Frogger

31 Mar 31 Mar

6:15 a.m.

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(a)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 > > http://mail.yahoo.com >

> > _______________________________________________ > > Users mailing list > > Users(a)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

Reply

Frogger

7:04 a.m.

I got it figured out. I was inappropriately converting the hashed array back into an encoded string. Thanks for your guidance. --- Norman Brandinger <norm(a)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 > > http://mail.yahoo.com >

> > _______________________________________________ > > Users mailing list > > Users(a)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

Reply

6811

days inactive

6815

days old

sr-users@lists.kamailio.org

Manage subscription

7 comments

4 participants

tags (0)

participants (4)

Daniel-Constantin Mierla
Frogger
Norman Brandinger
Urtho