PASSWORD() function for postgresql? 
Author Message
 PASSWORD() function for postgresql?

This is a multi-part message in MIME format.

------=_NextPart_000_0015_01C10D26.B1AF5260
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am looking for a postgresql PASSWORD() function that
produces hashes compatible with MySQL's implementation.

I am converting from MySQL and I know of no other way to
use the passwords I have in the old database other than
having a compatible PASSWORD() function.

I have searched around for one quite a bit but could not find
one.  Does anyone know if someone has written something
to do this already?  If so, where I can get it from?

I am off the list so please include me in CC, etc.

Thanks in advance,
Jason DiCioccio

------=_NextPart_000_0015_01C10D26.B1AF5260
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2495.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I am looking for a postgresql PASSWORD() f=
unction=20
that</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>produces hashes compatible with MySQL's=20
implementation.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I am converting from MySQL and I know of n=
o other=20
way to</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>use the passwords I have in the old databa=
se other=20
than</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>having a compatible PASSWORD()=20
function.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I have searched around for one quite a bit=
 but=20
could not find</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>one.&nbsp; Does anyone know if someone has=
 written=20
something</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>to do this already?&nbsp; If so, where I c=
an get it=20
from?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I am off the list so please include me in =
CC,=20
etc.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jason DiCioccio</FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0015_01C10D26.B1AF5260--



Sat, 10 Jan 2004 00:59:04 GMT
 PASSWORD() function for postgresql?

You could take the password hashing routine out of client/password.c (in
the mysql source) and write your own C function...  I know just enough C
to think that it shouldn't be that hard, but not enough to do it :)

-philip

Quote:

> I am looking for a postgresql PASSWORD() function that
> produces hashes compatible with MySQL's implementation.

> I am converting from MySQL and I know of no other way to
> use the passwords I have in the old database other than
> having a compatible PASSWORD() function.

> I have searched around for one quite a bit but could not find
> one.  Does anyone know if someone has written something
> to do this already?  If so, where I can get it from?

> I am off the list so please include me in CC, etc.

> Thanks in advance,
> Jason DiCioccio

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Sat, 10 Jan 2004 03:55:06 GMT
 PASSWORD() function for postgresql?

For that matter, you could write a perl function using perl's built-in crypt()
function.  I'm not sure if it's exactly identical to what mysql does, though I
strongly suspect that it is.


02:13:27 PM



      Sheldahl/Lex/Lexmark)
Subject:  [GENERAL] Re: PASSWORD() function for postgresql?

You could take the password hashing routine out of client/password.c (in
the mysql source) and write your own C function...  I know just enough C
to think that it shouldn't be that hard, but not enough to do it :)

-philip

Quote:

> I am looking for a postgresql PASSWORD() function that
> produces hashes compatible with MySQL's implementation.

> I am converting from MySQL and I know of no other way to
> use the passwords I have in the old database other than
> having a compatible PASSWORD() function.

> I have searched around for one quite a bit but could not find
> one.  Does anyone know if someone has written something
> to do this already?  If so, where I can get it from?

> I am off the list so please include me in CC, etc.

> Thanks in advance,
> Jason DiCioccio

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Sat, 10 Jan 2004 04:21:10 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. PASSWORD() function for postgresql?

2. Postgresql datatype password

3. PostgreSQL Password Cracker

4. postgresql-7.1.3 pg_ctl password authentication and startup

5. Postgresql newbie username/password question

6. postgresql-7.1.3 pg_ctl password authentication and startup

7. problems with postgresql passwords on webmin/kylix

8. Password in postgresql?!?

9. Postgresql newbie username/password question

10. Source code of the procedures/Functions in PostgreSQL

11. Simple mail() function for postgresql

12. Covariance Function in Postgresql??


 
Powered by phpBB® Forum Software