:pgsql-hackers-
> [EMAIL PROTECTED] On Behalf Of Jeanna Geier
> Sent: Tuesday, September 26, 2006 7:51 PM
> To: Jeff Frost; Alvaro Herrera
> Cc: Tom Lane; pgsql-admin@postgresql.org; pgsql-
> [EMAIL PROTECTED]
> Subject: Re: [HACKERS] [ADMIN] pg_hba.conf: 'trust' vs. '
Behalf Of Jeanna Geier
Sent: Tuesday, September 26, 2006 1:24 PM
To: Jeff Frost
Cc: "Tom Lane"; pgsql-admin@postgresql.org; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues
Searched again for 'pgpass' and for
Thank you, Thank you, Thank you!! :o)
Jeff - Thanks in particular for your help on this, it is greatly
appreciated!
It was a hidden folder, but not anymore!! I found the file and re-set the
password for the 'postgres' user and can now connect using my 'md5' hostssl
connection:
hostssl
On Tue, 26 Sep 2006, Alvaro Herrera wrote:
Jeanna Geier wrote:
Searched again for 'pgpass' and for the 'Application Data' directory with
no luck...
The file is called "pgpass.conf" on Windows. As for the "Application
Data", it may be called differently if your Windows is localized -- try
loo
Jeanna Geier wrote:
> Searched again for 'pgpass' and for the 'Application Data' directory with
> no luck...
The file is called "pgpass.conf" on Windows. As for the "Application
Data", it may be called differently if your Windows is localized -- try
looking for %APPDATA%. (I think I'd do this b
Searched again for 'pgpass' and for the 'Application Data' directory with no
luck...
And, tell me it ain't so "you don't have to build the windows version from
source to use SSL" -- I had two seperate posters tell me that I did and I
wrestled with it for a bit...for nothing?? Ah, live and lea
On Tue, 26 Sep 2006, Jeanna Geier wrote:
Any thoughts?? Like I said previously, I did build this on Windows from
source so we could use the SSL option.could I have missed something when
I was doing that? (It was my first time and I was following instructions from
the INSTALL docs)
Jean
OK, so after doing some more testing and configuring to see if I can narrow
this down, I'm more confused than ever! =) Because now I cannot connect to
my database unless the method is 'trust'; shouldn't I be able to connect
using the correct password if 'password' is the method in the pg_hba.co
On Tue, 26 Sep 2006, Jeff Frost wrote:
But, when I put the trust line back with hostssl, I do not get connected as
per her original indication. Of course this is with my 8.1.4 windows server
and not 8.0.8. Is it possible that 8.0.8 was more liberal with the hostssl
vs host interpretation if
On Tue, 26 Sep 2006, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
Interestingly, I receive the same error when I disable SSL on the server:
If SSL is disabled then hostssl lines in pg_hba.conf effectively become
no-ops --- they can never be matched since no incoming connection will
Jeff Frost <[EMAIL PROTECTED]> writes:
> Interestingly, I receive the same error when I disable SSL on the server:
If SSL is disabled then hostssl lines in pg_hba.conf effectively become
no-ops --- they can never be matched since no incoming connection will
be SSL-ified. So that part of it sounds
On Tue, 26 Sep 2006, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
Do you remember if the problem was on the 8.0.8 server side that caused the
lack of prompting?
No, I'm pretty sure it was a client-side issue (and I thought we'd fixed
it by 8.0.8 anyway, so I'm glad to see your test
Jeff Frost <[EMAIL PROTECTED]> writes:
> Do you remember if the problem was on the 8.0.8 server side that caused the
> lack of prompting?
No, I'm pretty sure it was a client-side issue (and I thought we'd fixed
it by 8.0.8 anyway, so I'm glad to see your test agrees).
Jeanna, do you maybe have a
On Tue, 26 Sep 2006, Jeff Frost wrote:
As for Jeanna's problem, I don't see any password prompt at all in her
example. I've forgotten the details, but wasn't there a password
prompting problem with 8.0.x on Windows?
It worked great with 8.1.4. Let me download 8.0.8 and try that on Windows
On Tue, 26 Sep 2006, Tom Lane wrote:
"Jeanna Geier" <[EMAIL PROTECTED]> writes:
[ hostssl works with 'trust' but not 'md5' ]
It's only when I change the connection method to 'md5' that I'm running into
problems -- then I cannot connect from pgadmin or the command line.
As for Jeanna's proble
"Jeanna Geier" <[EMAIL PROTECTED]> writes:
> [ hostssl works with 'trust' but not 'md5' ]
> It's only when I change the connection method to 'md5' that I'm running into
> problems -- then I cannot connect from pgadmin or the command line.
I experimented with this using CVS HEAD, and found that SS
16 matches
Mail list logo
