can't connect to postgresql via phppgadmin and pgaccess

From: First Last <y2kdis(at)atenista(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: can't connect to postgresql via phppgadmin and pgaccess
Date: 2006-01-05 08:36:58
Message-ID: 20060105003658.515903EB@dm21.mta.everyone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<html><body><FONT face="Arial, Helvetica, sans-serif" size=2></FONT><FONT style="FONT-FAMILY: arial,helvetica,sans-serif" size=2><BR>i'm trying to use phppgadmin to connect to postgresql and <BR>except for the 'www-data' account, no other account could <BR>log on to the database. i tried tweaking all the config <BR>files (pg_hba.conf, postgresql.conf, etc) but to no avail. <BR>it always gives me the 'FATAL: IDENT Authentication failed <BR>for user [username]'.&nbsp; <BR> <BR>would somebody know what app postgresql uses for the <BR>authentication process? earlier on, i removed several <BR>services which include portmapper, inetd, auth/identd, <BR>etc., to limit services and subsequently tighten security. <BR>perhaps i removed the app that postgre uses? but if that's <BR>the case, i wonder how www-data is able to make a <BR>connection, and i also doubt if i could remove a package <BR>without aptitude warning me of a broken dependency (for <BR>postgresql). anyway, i tried to reinstall and run <BR>portmapper and auth/identd again but still i had no luck.<BR><BR>with psql, i have no problem accessing the database. it's <BR>only with the gui-based pgaccess and phppgadmin that i am <BR>having problem. what baffles me is that 'www-data' can <BR>make a connection via phppgadmin.<BR> <BR>btw, i'm running phppgadmin 3.5.2, postgresql 7.4 on <BR>debian sarge 3.1, if that would help. <BR></FONT><br>&nbsp;<br><hr>Check out Atenista.Net (www.atenista.net)- new design, regular content and additional services!<br></body></html>

Attachment Content-Type Size
unknown_filename text/html 1.5 KB

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2006-01-05 08:42:31 Re: GRANT access rights on rows
Previous Message Andrew Chambers 2006-01-05 08:25:17 Re: GRANT access rights on rows