Re: [GENERAL] Generating random values.

2005-08-18 Thread Chris Travers
Mike Nolan wrote: Your new password is 87&3jiwkjIJiwkjikmkq,^^2v12hqIwLbvCQQQi18152 Do not write it down or save it in a password manager, as doing so creates security problems. There is a solution here. Initialize passwords with a random string. Flag these accounts as "Password Tempora

Re: [GENERAL] Generating random values.

2005-08-18 Thread Fernando Lujan
On 8/18/05, Mike Nolan <[EMAIL PROTECTED]> wrote: > As I indicated in my original response, there is no best answer to the > issue of password choices, though there are probably a few 'worst' > answers. :-) > > Once someone has established a password scheme, either randomly generated > or user s

Re: [GENERAL] Generating random values.

2005-08-18 Thread Mike Nolan
> This way you can let users choose their own passwords :-) > > If you like you can put other checks in it to make sure you have any > three of uppercase/lowercase/numbers/other characters or whatever else > you like. Allowing users to choose their own permanent passwords does not make them any

Re: [GENERAL] Generating random values.

2005-08-18 Thread Bruno Wolff III
On Wed, Aug 17, 2005 at 15:54:40 -0600, Edmund <[EMAIL PROTECTED]> wrote: > > Great! a simple, dumb program can generate all your passwords in very > quickly. My 2.4 Ghz Pentium 4 did it in under 10 minutes. A token set of > 16 characters, and a fixed length of 8 charachters just isnt a very

Re: [GENERAL] Generating random values.

2005-08-18 Thread Mike Nolan
> Great! a simple, dumb program can generate all your passwords in very > quickly. My 2.4 Ghz Pentium 4 did it in under 10 minutes. A token set of > 16 characters, and a fixed length of 8 charachters just isnt a very big > search space. Your new password is 87&3jiwkjIJiwkjikmkq,^^2v12hqIwLbvCQQ

Re: [GENERAL] Generating random values.

2005-08-18 Thread Chris Travers
Edmund wrote: [EMAIL PROTECTED] ("Joshua D. Drake") writes: Fernando Lujan wrote: Hi folks, I have a table wich contains my users... I want to insert to each user a random password, so I need a random function. Is there such function in Postgres? I just found the RANDOM which generate

Re: [GENERAL] Generating random values.

2005-08-18 Thread Edmund
[EMAIL PROTECTED] ("Joshua D. Drake") writes: > Fernando Lujan wrote: > > Hi folks, > > I have a table wich contains my users... I want to insert to each > > user > > a random password, so I need a random function. Is there such function > > in Postgres? I just found the RANDOM which generates val

Re: [despammed] [GENERAL] Generating random values.

2005-08-17 Thread Fernando Lujan
On 8/17/05, A. Kretschmer <[EMAIL PROTECTED]> wrote: > select substring(md5(random()) from 5 for 15); Thanks everybody, this solution will fullfill my needs... ;) Sincerely, Fernando Lujan ---(end of broadcast)--- TIP 9: In versions below 8.0, t

Re: [despammed] [GENERAL] Generating random values.

2005-08-17 Thread A. Kretschmer
am 17.08.2005, um 13:48:38 -0300 mailte Fernando Lujan folgendes: > Hi folks, > > I have a table wich contains my users... I want to insert to each user > a random password, so I need a random function. Is there such function > in Postgres? I just found the RANDOM which generates values between >

Re: [GENERAL] Generating random values.

2005-08-17 Thread Chris Travers
Hi Fernando; I think that PL/Perl would be the easiest language to use in this case. However, you could use PL/PGSQL and do something like: 1) Generate a random number (RANDOM()) and multiply it by a base value, and add something to it to bring it within a certain range. 2) Look up the ASCII

Re: [GENERAL] Generating random values.

2005-08-17 Thread Sebastian Hennebrueder
Fernando Lujan schrieb: >Hi folks, > >I have a table wich contains my users... I want to insert to each user >a random password, so I need a random function. Is there such function >in Postgres? I just found the RANDOM which generates values between >0.0 and 1.0. > >Any help or suggestion will be

Re: [GENERAL] Generating random values.

2005-08-17 Thread Joshua D. Drake
Fernando Lujan wrote: Hi folks, I have a table wich contains my users... I want to insert to each user a random password, so I need a random function. Is there such function in Postgres? I just found the RANDOM which generates values between 0.0 and 1.0. Any help or suggestion will be appreciat

Re: [GENERAL] Generating random values.

2005-08-17 Thread Mike Nolan
> I have a table wich contains my users... I want to insert to each user > a random password, so I need a random function. Is there such function > in Postgres? I just found the RANDOM which generates values between > 0.0 and 1.0. If you multiply that random number by a large integer and then trun

[GENERAL] Generating random values.

2005-08-17 Thread Fernando Lujan
Hi folks, I have a table wich contains my users... I want to insert to each user a random password, so I need a random function. Is there such function in Postgres? I just found the RANDOM which generates values between 0.0 and 1.0. Any help or suggestion will be appreciated. :) Fernando Lujan