Re: Re: 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.

Philip Hallstrom <philip%adhesivemedia(dot)com(at)interlock(dot)lexmark(dot)com> on 07/23/2001
02:13:27 PM

To: Jason DiCioccio <geniusj%bluenugget(dot)net(at)interlock(dot)lexmark(dot)com>
cc: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com (bcc: Wesley
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

On Sun, 15 Jul 2001, Jason DiCioccio wrote:

> 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