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.com@interlock.lexmark.com> on 07/23/2001
02:13:27 PM
To: Jason DiCioccio <geniusj%bluenugget.net@interlock.lexmark.com>
cc: pgsql-general%postgresql.org@interlock.lexmark.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
