Error connecting for first connect upon pgAdmin start (with solution)
От | Martin Schayna |
---|---|
Тема | Error connecting for first connect upon pgAdmin start (with solution) |
Дата | |
Msg-id | AANLkTimSQNF5oaRxNu5_=kzczEdhcuKJe+SJrn0u6byh@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Error connecting for first connect upon pgAdmin
start (with solution)
|
Список | 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
В списке pgadmin-support по дате отправления: