Error connecting for first connect upon pgAdmin start (with solution)

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

Responses

Browse pgadmin-support by date

  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