On Wed, Feb 04, 2009 at 04:42:05PM +, chris.el...@shropshire.gov.uk wrote:
> If you want to be really secure, use both a md5 and sha1 hash, snice it
> has been proved you can generate hash collisions so you could use:
>
> insert into auth (user_id, salt, password) values
> (1,'blah',
x27;) || sha1( salt || 'test') ;
Chris Ellis
"Raymond C. Rodgers"
Sent by: pgsql-general-ow...@postgresql.org
04/02/2009 14:34
To
Iñigo Barandiaran
cc
pgsql-general@postgresql.org
Subject
Re: [GENERAL] field with Password
Iñigo Barandiaran wrote:
Thanks!
Ok. I've f
cc
pgsql-general@postgresql.org
Thanks Raymond
That is something I wanted! It's Great if it is already integrated in
Postgre! Superb. This is much more easy.
Thank you All.
Best,
Iñigo Barandiaran wrote:
Well, you can use the built-in md5 function for this purpose. For
instance, you could
Thanks Raymond
That is something I wanted! It's Great if it is already integrated in
Postgre! Superb. This is much more easy.
Thank you All.
Best,
Iñigo Barandiaran wrote:
Thanks!
Ok. I've found http://256.com/sources/md5/
library. So the idea is to
define in the da
Iñigo Barandiaran wrote:
Thanks!
Ok. I've found http://256.com/sources/md5/ library. So the idea is to
define in the dataBase a Field of PlainText type. When I want to
insert a new user, I define a password, convert to MD5 hash with the
library and store it in the DataBase. Afterwards, any u
On Wed, Feb 04, 2009 at 11:09:51AM +0100, Iñigo Barandiaran wrote:
> I would like to create a new table where one of the field would be a
> user password. Is there any data type for supporting this functionality?
> Something like Password DataType. I've taken a look of the available
> data ty
> >> I would like to create a new table where one of the field would be a
> >> user password. Is there any data type for supporting this
> >> functionality? Something like Password DataType. I've taken a look
> of
> >> the available data types in PgAdmin Application and there is nothing
> >> simila
Thanks!
Ok. I've found http://256.com/sources/md5/ library. So the idea is to
define in the dataBase a Field of PlainText type. When I want to insert
a new user, I define a password, convert to MD5 hash with the library
and store it in the DataBase. Afterwards, any user check should get the
Iñigo Barandiaran wrote:
Thanks for your answers. Sorry for the questions but I'm new to
Postgre :)
The problem with a plain text password is that a user can see it by
looking at the user table.
Both suggest to use MD5. How can i use it? Any link, example about
this would be very appreciated
Thanks for your answers. Sorry for the questions but I'm new to Postgre :)
The problem with a plain text password is that a user can see it by
looking at the user table.
Both suggest to use MD5. How can i use it? Any link, example about this
would be very appreciated.
Thanks in advance!
Iñi
In response to Iñigo Barandiaran :
> Hi.
>
>
> I would like to create a new table where one of the field would be a
> user password. Is there any data type for supporting this functionality?
> Something like Password DataType. I've taken a look of the available
> data types in PgAdmin Applicat
Iñigo Barandiaran wrote:
Hi.
I would like to create a new table where one of the field would be a
user password. Is there any data type for supporting this
functionality? Something like Password DataType. I've taken a look of
the available data types in PgAdmin Application and there is nothi
what do you expect from such type? try to use a text field for plain
passwords or better store only hashvalues. see md5()
regards
thomas
Iñigo Barandiaran schrieb:
Hi.
I would like to create a new table where one of the field would be a
user password. Is there any data type for supporting t
Hi.
I would like to create a new table where one of the field would be a
user password. Is there any data type for supporting this functionality?
Something like Password DataType. I've taken a look of the available
data types in PgAdmin Application and there is nothing similar to this.
Than
15 matches
Mail list logo