| From: | First Last <y2kdis(at)atenista(dot)net> |
|---|---|
| To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: can't connect to postgresql via phppgadmin and pgaccess |
| Date: | 2006-01-05 12:14:24 |
| Message-ID: | 20060105041424.515911BB@dm21.mta.everyone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
i'm sorry about the previous format. i didn't know my emails are being sent in html format until you pointed it out. now that you mentioned it i saw an option where i could switch to plain text format (apparently the default is html format). anyway, i'm resending my previous message in case you had trouble reading it.
first last is obviously not my real name. i've tried correcting the entry in my email's profile several times already but it keeps on defaulting to the bogus name i entered during the registration process.
i'm trying to use phppgadmin to connect to postgresql and
except for the 'www-data' account, no other account could
log on to the database. i tried tweaking all the config
files (pg_hba.conf, postgresql.conf, etc) but to no avail.
it always gives me the 'FATAL: IDENT Authentication failed
for user [username]'.
would somebody know what app postgresql uses for the
authentication process? earlier on, i removed several
services which include portmapper, inetd, auth/identd,
etc., to limit services and subsequently tighten security.
perhaps i removed the app that postgre uses? but if that's
the case, i wonder how www-data is able to make a
connection, and i also doubt if i could remove a package
without aptitude warning me of a broken dependency (for
postgresql). anyway, i tried to reinstall and run
portmapper and auth/identd again but still i had no luck.
with psql, i have no problem accessing the database. it's
only with the gui-based pgaccess and phppgadmin that i am
having problem. what baffles me is that 'www-data' can
make a connection via phppgadmin.
btw, i'm running phppgadmin 3.5.2, postgresql 7.4 on
debian sarge 3.1, if that would help.
--- "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
From: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Date: Thu, 5 Jan 2006 09:48:53 +0100
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] can't connect to postgresql via
phppgadmin and pgaccess
am 05.01.2006, um 0:36:58 -0800 mailte First Last folgendes:
> <html><body><FONT face="Arial, Helvetica, sans-serif"
size=2>...
Hi First Last,
this is a _mail_ing list, not a web-page. Please write plain
ASCII, no
HTML.
Btw.: you are sure that your name is 'First Last'?
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
---------------------------(end of
broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an
appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that
your
message can get through to the mailing list cleanly
_____________________________________________________________
Check out Atenista.Net (www.atenista.net)- new design, regular content and additional services!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2006-01-05 12:24:17 | Re: can't connect to postgresql via phppgadmin and pgaccess |
| Previous Message | Roland Giesler | 2006-01-05 10:50:09 | Re: Best way to manage users |