Re: [ADMIN] [GENERAL] postgresql Secure Mode

2005-08-08 Thread Alvaro Herrera
On Mon, Aug 08, 2005 at 12:40:24PM -0400, Alvaro Herrera wrote: > On Mon, Aug 08, 2005 at 12:24:14PM -0400, Mario Soto Cordones - Venezuela > wrote: > > 2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>: > > > > > Yeah, the server thinks it's active, but the client doesn't know it. > > > Did you try co

Re: [GENERAL] postgresql Secure Mode

2005-08-08 Thread Alvaro Herrera
On Mon, Aug 08, 2005 at 11:06:22AM -0400, Mario Soto Cordones - Venezuela wrote: > 2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>: > > On Mon, Aug 08, 2005 at 10:24:54AM -0400, Mario Soto Cordones - Venezuela > > wrote: > > > but when I try to connect myself for example from an application EMS > >

Re: [GENERAL] postgresql Secure Mode

2005-08-08 Thread Mario Soto Cordones - Venezuela
uppercase but not say error thank you 2005/8/8, Michael Fuhr <[EMAIL PROTECTED]>: > On Mon, Aug 08, 2005 at 10:24:54AM -0400, Mario Soto Cordones - Venezuela > wrote: > > 3.- configure pg_hba.conf > > > > hostssl all all 192.168.0.0 255.255.255.0 MD5 > > Do you have "MD5" (uppercase) or "md5"

Re: [GENERAL] postgresql Secure Mode

2005-08-08 Thread Mario Soto Cordones - Venezuela
2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>: > On Mon, Aug 08, 2005 at 10:24:54AM -0400, Mario Soto Cordones - Venezuela > wrote: > > > 3.- configure pg_hba.conf > > > > hostssl all all 192.168.0.0 255.255.255.0 MD5 > > I assume the connection is coming from within this network; is that > righ

Re: [GENERAL] postgresql Secure Mode

2005-08-08 Thread Michael Fuhr
On Mon, Aug 08, 2005 at 10:24:54AM -0400, Mario Soto Cordones - Venezuela wrote: > 3.- configure pg_hba.conf > > hostssl all all 192.168.0.0 255.255.255.0 MD5 Do you have "MD5" (uppercase) or "md5" (lowercase)? Using uppercase on my 8.0.3 system generates an error in the postmaster logs: LOG:

Re: [GENERAL] postgresql Secure Mode

2005-08-08 Thread Alvaro Herrera
On Mon, Aug 08, 2005 at 10:24:54AM -0400, Mario Soto Cordones - Venezuela wrote: > 3.- configure pg_hba.conf > > hostssl all all 192.168.0.0 255.255.255.0 MD5 I assume the connection is coming from within this network; is that right? (What's the IP address of the client machine?) > 4.- servic

Re: [GENERAL] postgresql Secure Mode

2005-08-08 Thread Mario Soto Cordones - Venezuela
Hello, what comments of PAM, was alone that, a comment, since try to make it and I don't work. now I detail them the carried out steps. 1.- make the digital certificate, and it places it in the directory it data of postgresql. openssl req -new -text -out server.req openssl rsa -in pr

Re: [GENERAL] postgresql Secure Mode

2005-08-08 Thread Alvaro Herrera
On Mon, Aug 08, 2005 at 08:44:44AM -0400, Mario Soto Cordones - Venezuela wrote: > Hi , > not in fact I don't have a password file, I wanted to use > autentificacion PAM, I have attempted it but I have not gotten it, on > the other hand I don't understand that of the passwords file. Can you post

Re: [GENERAL] postgresql Secure Mode

2005-08-08 Thread Mario Soto Cordones - Venezuela
Hi , not in fact I don't have a password file, I wanted to use autentificacion PAM, I have attempted it but I have not gotten it, on the other hand I don't understand that of the passwords file. Greetings and thank you Mario Soto 2005/8/7, Christopher Browne <[EMAIL PROTECTED]>: > > Hi, > >

Re: [GENERAL] postgresql Secure Mode

2005-08-07 Thread Christopher Browne
> Hi, > > i have a probem,. > > I am trying to configure postgresql in sure way, I have made the > following thing: > > 1. - I have created the certificate and put this in the directory it data > 2. - given him privileges to the user postgresql for the certificate > 3. - in the file postgre

[GENERAL] postgresql Secure Mode

2005-08-07 Thread Mario Soto Cordones - Venezuela
Hi, i have a probem,. I am trying to configure postgresql in sure way, I have made the following thing: 1. - I have created the certificate and put this in the directory it data 2. - given him privileges to the user postgresql for the certificate 3. - in the file postgresql.conf, modify t