Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

Next:From: Boblitz JohnDate: 2011-03-04 06:54:32
Subject: pgadminIII Configuration problem
Previous:From: Ashesh VashiDate: 2011-03-03 04:27:14
Subject: Re: paste into SQL editor from Eclipse on Mac doesn't work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group