Package: pgadmin3
Version: 1.4.1-1
Severity: normal
Hi,
I tried to follow some adwises written for pgAdmin3 running on a Win machine
as user postgres. This has some drawbacks because user postgres under Debian
has no writable home directory. I switched to postgres using
su -c "su -s /bin/sh postgres"
At first I had to do
psql template1 -c "ALTER ROLE WITH ENCRYPTED PASSWORD 'password' ;"
to enable user postgres logging into a server using pgAdmin3. It is
boring in general that pgAdmin3 does not seem to support ident authentication.
At least I had not found out how to log into localhost as a user with
no password which is the default in Debian. (Should I report this as a
separate bug?)
Then I tried to Edit pg_hba.conf (regarding to the advise mentioned above)
and tried to load the file. This crashed pgAdmin3 and on the console
I've got the following output:
(pgadmin3:18905): libgnomevfs-WARNING **: Unable to create ~/.gnome2 directory:
Permission denied
(pgadmin3:18905): GLib-CRITICAL **: g_hash_table_lookup: assertion `hash_table
!= NULL' failed
(pgadmin3:18905): libgnomevfs-WARNING **: Internal error: the configuration
system was not initialized. Did you call _gnome_vfs_configuration_init?
(pgadmin3:18905): GLib-CRITICAL **: g_hash_table_lookup: assertion `hash_table
!= NULL' failed
(pgadmin3:18905): libgnomevfs-WARNING **: Internal error: the configuration
system was not initialized. Did you call _gnome_vfs_configuration_init?
** (pgadmin3:18905): CRITICAL **: ORBit_POA_new_from: assertion `parent !=
CORBA_OBJECT_NIL' failed
** (pgadmin3:18905): CRITICAL **: ORBit_ObjectAdaptor_set_thread_hintv:
assertion `adaptor != NULL' failed
(pgadmin3:18905): Bonobo-WARNING **: Could not create/get poa
'BonoboPOAHintPerObject'
libgnomevfs-ERROR **: Can't allocate gnome-vfs client POA
aborting...
This sounds reasonable because user postgres is not able to write into its $HOME
directory by default. I did not wanted to change this and tried to trick
pgAdmin3
by just setting
HOME=/tmp pgadmin3
Unfortunately even this did not really help. I don't now really whether
pgAdmin3
is intended to be run as user postgres, but this is nearly the only chance to
edit pg_hba.conf (if you do not want to do it as root).
Kind regards
Andreas.
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (501, 'testing'), (50, 'unstable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.11
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)
Versions of packages pgadmin3 depends on:
ii libc6 2.3.5-8 GNU C Library: Shared libraries an
ii libgcc1 1:4.0.2-5 GCC support library
ii libpq4 8.1.0-3 PostgreSQL C client library
ii libstdc++6 4.0.2-5 The GNU Standard C++ Library v3
ii libwxgtk2.6-0 2.6.1.2 wxWidgets Cross-platform C++ GUI t
ii pgadmin3-data 1.4.1-1 Graphical administration tool for
pgadmin3 recommends no packages.
-- debconf-show failed
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
