Re: [GENERAL] Database users Passwords

2006-10-17 Thread Shane Ambler
Jorge Godoy wrote: Shane Ambler <[EMAIL PROTECTED]> writes: The only crypt I know of is the crypt command (FreeBSD has it at /usr/bin/crypt) and is also known as enigma. This is a two way encryption Well... I suppose DES is not Enigma, but I may be wrong. I just quoted this "extension" beca

Re: [GENERAL] Database users Passwords

2006-10-17 Thread Jorge Godoy
Shane Ambler <[EMAIL PROTECTED]> writes: > The only crypt I know of is the crypt command (FreeBSD has it at > /usr/bin/crypt) and is also known as enigma. This is a two way encryption > and is fast. > If that is what he is using then decrypting will not be part of the time > issue and is the basis

Re: [GENERAL] Database users Passwords

2006-10-17 Thread Shane Ambler
Jorge Godoy wrote: Shane Ambler <[EMAIL PROTECTED]> writes: What Dev would want to look for (probably create) is a small script that will read his list of crypt passwords and un-crypt them into a create role string that is fed to psql. Except that the hash used is unidirectional, i.e., there'

Re: [GENERAL] Database users Passwords

2006-10-17 Thread Jorge Godoy
Shane Ambler <[EMAIL PROTECTED]> writes: > What Dev would want to look for (probably create) is a small script that will > read his list of crypt passwords and un-crypt them into a create role string > that is fed to psql. Except that the hash used is unidirectional, i.e., there's no way to decry

Re: [GENERAL] Database users Passwords

2006-10-17 Thread Shane Ambler
Jeff Davis wrote: On Tue, 2006-10-17 at 10:41 -0400, DEV wrote: Hello all, I have user information in a table that I want to use to add users to the user roles tables that are part of postgresql. My question is this: the passwords in my user table are in there as a text file with the dat

Re: [GENERAL] Database users Passwords

2006-10-17 Thread Jeff Davis
On Tue, 2006-10-17 at 12:54 -0400, DEV wrote: > Okay but the issue I have is that I have the passwords already generated and > in crypt() format and would love to just use them if at all possible? > PostgreSQL won't doesn't recognize crypt passwords, as far as I know. That means that it's pretty

Re: [GENERAL] Database users Passwords

2006-10-17 Thread DEV
Cc: pgsql-general@postgresql.org; pgsql-docs@postgresql.org Subject: Re: [GENERAL] Database users Passwords On Tue, 2006-10-17 at 10:41 -0400, DEV wrote: > Hello all, > > I have user information in a table that I want to use to add > users to the user roles tables that

Re: [GENERAL] Database users Passwords

2006-10-17 Thread Jeff Davis
On Tue, 2006-10-17 at 10:41 -0400, DEV wrote: > Hello all, > > I have user information in a table that I want to use to add > users to the user roles tables that are part of postgresql. My > question is this: the passwords in my user table are in there as a > text file with the data being e

[GENERAL] Database users Passwords

2006-10-17 Thread DEV
Hello all,   I have user information in a table that I want to use to add users to the user roles tables that are part of postgresql.  My question is this: the passwords in my user table are in there as a text file with the data being encrypted using the crypt function, is there a way