From: | Martin Schayna <mschayna(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Error connecting for first connect upon pgAdmin start (with solution) |
Date: | 2011-03-03 16:12:36 |
Message-ID: | AANLkTimSQNF5oaRxNu5_=kzczEdhcuKJe+SJrn0u6byh@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Small bug + solution
pgAdmin III 1.12.0
PostgreSQL 9.0
Ubuntu Linux 10.04
installed completely from Martin Pitt's PPA
https://launchpad.net/~pitti/+archive/postgresql, but also
reproducible with original Ubuntu repositories (PostgreSQL 8.4,
pgAdmin III 1.10.2)
Scenario:
1) start pgAdmin from console: $ pgadmin3
2) warning appears on console:
WARNING: password file "/home/mase/.pgpass" has group or world
access; permissions should be u=rw (0600) or less
3) now try to connect some server by double-clicking server node in
tree, error window appears and server is not connected:
An error has occurred:
Error connecting to the server: fe_sendauth: no password supplied
4) subsequent tries works, until pgAdmin close
Solution:
When I change permissions for .pgpass file as warning suggested,
connection error for first connect upon pgAdmin start disappears and
everything works like a charm. It looks like there is some lack in
reading passwords from .pgpass when warning is shown.
Keep up good work, guys!
Martin Schayna
From | Date | Subject | |
---|---|---|---|
Next Message | Boblitz John | 2011-03-04 06:54:32 | pgadminIII Configuration problem |
Previous Message | Ashesh Vashi | 2011-03-03 04:27:14 | Re: paste into SQL editor from Eclipse on Mac doesn't work |