Re: PgAdmin forgets stored password on connection problem - Mailing list pgadmin-support

From Eugene Lisitsky
Subject Re: PgAdmin forgets stored password on connection problem
Date
Msg-id a745310911110935g5636ce89h4c34b65d24debcf1@mail.gmail.com
Whole thread Raw
In response to Re: PgAdmin forgets stored password on connection problem  (Dave Page <dpage@pgadmin.org>)
Responses Re: PgAdmin forgets stored password on connection problem  (Dave Page <dpage@pgadmin.org>)
List pgadmin-support


2009/11/11 Dave Page <dpage@pgadmin.org>
On Wed, Nov 11, 2009 at 3:33 PM, Eugene Lisitsky <lisitsky@gmail.com> wrote:

> Is it possible to check error and fail reason: network, connection refused,
> password incorrect, no access to such DB?

Not reliably, because we only get CONNECTION_GOOD, CONNECTION_BAD as
connection status flags from libpq, and in the event of a connection
error, get a possibly-localised error message. There are no
standardised codes for connection errors (unlike query results, for
which you can get SQL status codes etc).

I thought lib provides you with a detailed info.
 

> Or at least as a workaround fill the form with old password?

We don't know it, unless you just typed it in. Libpq reads it from
.pgpass and pgAdmin never touches it.
What do you think of adding one more button to the dialog "Use stored pass" which just does nothing only sends the connection request?

I tried to work with sources, but svn version didn't compile at my computer. Can you help me a little?

Compile errors like these:
g++ -DHAVE_CONFIG_H -I. -I..   -I/usr/include/postgresql -DSSL -I/usr/lib/wx/include/base-unicode-release-2.8 -I/usr/include/wx-2.8 -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -DwxUSE_GUI=0 -O2 -DEMBED_XRC -I/usr/include/libxml2 -I/usr/include/libxml2 -DDATA_DIR=\"/usr/local/pgadmin3/share/pgadmin3/\" -Wall -Wno-non-virtual-dtor -fno-strict-aliasing -I../pgadmin/include   -MT pgAdmin3.o -MD -MP -MF .deps/pgAdmin3.Tpo -c -o pgAdmin3.o `test -f './pgAdmin3.cpp' || echo './'`./pgAdmin3.cpp
In file included from ../pgadmin/include/pgAdmin3.h:21,
                 from ./pgAdmin3.cpp:13:
../pgadmin/include/utils/misc.h:120: error: ‘wxPoint’ has not been declared
../pgadmin/include/utils/misc.h:120: error: ‘wxSize’ has not been declared
In file included from ../pgadmin/include/pgAdmin3.h:22,
                 from ./pgAdmin3.cpp:13:
../pgadmin/include/ctl/ctlTree.h:26: error: expected class-name before ‘{’ token
../pgadmin/include/ctl/ctlTree.h:28: error: ISO C++ forbids declaration of ‘wxPoint’ with no type
../pgadmin/include/ctl/ctlTree.h:28: error: expected ‘,’ or ‘...’ before ‘&’ token
In file included from ../pgadmin/include/pgAdmin3.h:22,
                 from ./pgAdmin3.cpp:13:
......


and at the end:

./pgAdmin3.cpp: At global scope:
./pgAdmin3.cpp:171: error: variable or field ‘OnSelect’ declared void
./pgAdmin3.cpp:171: error: ‘wxCommandEvent’ was not declared in this scope
./pgAdmin3.cpp:171: error: ‘ev’ was not declared in this scope
make[2]: *** [pgAdmin3.o] Error 1
make[2]: Выход из каталога `/home/e/eclipse-workspace/pgAdmin/src/pgadmin3/pgadmin'
make[1]: *** [all-recursive] Error 1
make[1]: Выход из каталога `/home/e/eclipse-workspace/pgAdmin/src/pgadmin3'
make: *** [all] Error 2


Thank you!
 

>> There's definitely room for improvement here though - patches are
>> welcome if anyone wants to spend some time on it.
>
> Unfortunately I'm not a C developer.  But I can try :)

:-)

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com



--
Yours,
Eugene Lisitsky

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: PgAdmin forgets stored password on connection problem
Next
From: Vladimir Kokovic'
Date:
Subject: PostgreSQL 8.5