Обсуждение: Re: VMWare connection
> -----Original Message----- > From: Vikram Khurana [mailto:vkhurana@mail.nmfs.hawaii.edu] > Sent: 23 August 2002 22:31 > To: 'Krystian Brazulewicz'; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] VMWare connection > > > Does Postgres's service run on port 5432 by default? Yes. > I've tried changing the password for Postgres but it asks me > for the current passwd when I do that in Linux. As far as I > could find it is supposed to be empty, but when I just press > enter at the current password it errors it. Is there another > default password for Postgres? I did my install thro RPM's Make sure that TCP/IP is enabled in PostgreSQL. Check $PGDATA/postgresql.conf. Also, you might find it easier to allow password connections in $PGDATA/pg_hba.conf. iirc, the RPMs default to ident. Regards, Dave.
Make sure that TCP/IP is enabled in PostgreSQL. Check $PGDATA/postgresql.conf. Also, you might find it easier to allow password connections in $PGDATA/pg_hba.conf. iirc, the RPMs default to ident. I set the tcpip_socket = true However the "ident" password still didn't work? Thanks for your help, Vikram
> -----Original Message----- > From: Vikram Khurana [mailto:vkhurana@mail.nmfs.hawaii.edu] > Sent: 23 August 2002 22:56 > To: Dave Page; 'Krystian Brazulewicz'; pgadmin-support@postgresql.org > Subject: RE: [pgadmin-support] VMWare connection > > > > Make sure that TCP/IP is enabled in PostgreSQL. Check > $PGDATA/postgresql.conf. Also, you might find it easier to > allow password connections in $PGDATA/pg_hba.conf. iirc, the > RPMs default to ident. > > > I set the tcpip_socket = true > However the "ident" password still didn't work? No, try setting it to password instead of ident. Regards, Dave.
> try setting it to password instead of ident. I guess ident means the same password as the users, correct? But I don't understand your statement above at all.... Can you please explain a little more. Thanks for your time, VIkram Dave Page wrote: > >>-----Original Message----- >>From: Vikram Khurana [mailto:vkhurana@mail.nmfs.hawaii.edu] >>Sent: 23 August 2002 22:56 >>To: Dave Page; 'Krystian Brazulewicz'; pgadmin-support@postgresql.org >>Subject: RE: [pgadmin-support] VMWare connection >> >> >> >>Make sure that TCP/IP is enabled in PostgreSQL. Check >>$PGDATA/postgresql.conf. Also, you might find it easier to >>allow password connections in $PGDATA/pg_hba.conf. iirc, the >>RPMs default to ident. >> >> >>I set the tcpip_socket = true >>However the "ident" password still didn't work? >> > >No, try setting it to password instead of ident. > >Regards, >Dave. > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/users-lounge/docs/faq.html >
> -----Original Message----- > From: Vikram Khurana [mailto:vkhurana@mail.nmfs.hawaii.edu] > Sent: 26 August 2002 21:24 > To: Dave Page > Cc: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] VMWare connection > > > > try setting it to password instead of ident. > > I guess ident means the same password as the users, correct? No. Ident means use an ident server. > But I don't understand your statement above at all.... > > Can you please explain a little more. Replace the word ident with the word password. You want a line like: host all 192.168.1.0 255.255.255.0 password You'll need to adjust the ip/subnet mask as approriate. Regards, Dave.
> No. Ident means use an ident server. Is Ident server something I need to set up? Why would I do that > host all 192.168.1.0 255.255.255.0 password I was able to get the connection when I made the entry host all 192.168.1.0 255.255.255.255 trust However on changing the 'trust' to 'password' I get a password authentication failure-- I tried by using a blank passwd and then changed the password of the user postgres & tried that. Both failed. Not sure why I shouldn't leave the AUTH_TYPE to 'trust' -- bad security maybe?? > -----Original Message----- > From: Vikram Khurana [mailto:vkhurana@mail.nmfs.hawaii.edu] > Sent: 26 August 2002 21:24 > To: Dave Page > Cc: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] VMWare connection > > > > try setting it to password instead of ident. > > I guess ident means the same password as the users, correct? > No. Ident means use an ident server. > But I don't understand your statement above at all.... > > Can you please explain a little more. Replace the word ident with the word password. You want a line like: host all 192.168.1.0 255.255.255.0 password You'll need to adjust the ip/subnet mask as approriate. Regards, Dave.
> -----Original Message----- > From: Vikram Khurana [mailto:vkhurana@mail.nmfs.hawaii.edu] > Sent: 26 August 2002 22:38 > To: Dave Page > Cc: pgadmin-support@postgresql.org > Subject: RE: [pgadmin-support] VMWare connection > > > > No. Ident means use an ident server. > Is Ident server something I need to set up? Why would I do that > > > host all 192.168.1.0 255.255.255.0 password > > I was able to get the connection when I made the entry > host all 192.168.1.0 255.255.255.255 trust 192.168.1.0 is a network address, not a host address. You might want to check that. > However on changing the 'trust' to 'password' I get a > password authentication failure-- I tried by using a blank > passwd and then changed the password of the user postgres & > tried that. Both failed. > Not sure why I shouldn't leave the AUTH_TYPE to 'trust' -- > bad security maybe?? If only you can login to that client, then it's not quite so bad as effectively only you are trusted. You should be able to set the postgres user password and use password auth though - did you set it in pgAdmin? If so, you might want to try switching Encrypted Passwords off under Tools -> Options and trying again (to set the password). Regards, Dave.
> If only you can login to that client, then it's not quite so bad as > effectively only you are trusted. You should be able to set the postgres > user password and use password auth though - did you set it in pgAdmin? > If so, you might want to try switching Encrypted Passwords off under > Tools -> Options and trying again (to set the password). > That worked. Maybe you can point me to some reading material, so I can understand this behavior. Thanks for all your help.... > -----Original Message----- > From: Dave Page [mailto:dpage@vale-housing.co.uk] > Sent: Monday, August 26, 2002 11:41 AM > To: Vikram Khurana > Cc: pgadmin-support@postgresql.org > Subject: RE: [pgadmin-support] VMWare connection > > > > > -----Original Message----- > > From: Vikram Khurana [mailto:vkhurana@mail.nmfs.hawaii.edu] > > Sent: 26 August 2002 22:38 > > To: Dave Page > > Cc: pgadmin-support@postgresql.org > > Subject: RE: [pgadmin-support] VMWare connection > > > > > > > No. Ident means use an ident server. > > Is Ident server something I need to set up? Why would I do that > > > > > host all 192.168.1.0 255.255.255.0 password > > > > I was able to get the connection when I made the entry > > host all 192.168.1.0 255.255.255.255 trust > > 192.168.1.0 is a network address, not a host address. You might want to > check that. > > > However on changing the 'trust' to 'password' I get a > > password authentication failure-- I tried by using a blank > > passwd and then changed the password of the user postgres & > > tried that. Both failed. > > Not sure why I shouldn't leave the AUTH_TYPE to 'trust' -- > > bad security maybe?? > > If only you can login to that client, then it's not quite so bad as > effectively only you are trusted. You should be able to set the postgres > user password and use password auth though - did you set it in pgAdmin? > If so, you might want to try switching Encrypted Passwords off under > Tools -> Options and trying again (to set the password). > > Regards, Dave.
> -----Original Message----- > From: Vikram Khurana [mailto:vkhurana@mail.nmfs.hawaii.edu] > Sent: 26 August 2002 22:50 > To: Dave Page > Cc: pgadmin-support@postgresql.org > Subject: RE: [pgadmin-support] VMWare connection > > > > If only you can login to that client, then it's not quite so bad as > > effectively only you are trusted. You should be able to set the > postgres > > user password and use password auth though - did you set it in > pgAdmin? > > If so, you might want to try switching Encrypted Passwords > off under > > Tools -> Options and trying again (to set the password). > > > That worked. Maybe you can point me to some reading material, > so I can understand this behavior. Thanks for all your help.... Check the PostgreSQL administrator's guide in the pgAdmin helpfile. If you are using pgAdmin 1.3.x, then there is a howto on using Encrypted passwords in the helpfile as well. Regards, Dave.