Обсуждение: can't connect to postgresql via phppgadmin and pgaccess
<FO= NT style=3D"FONT-FAMILY: arial,helvetica,sans-serif" size=3D2>i'm tryin= g to use phppgadmin to connect to postgresql and except for the 'www-da= ta' account, no other account could log on to the database. i tried twe= aking all the config files (pg_hba.conf, postgresql.conf, etc) but to n= o avail. it always gives me the 'FATAL: IDENT Authentication failed <BR= >for user [username]'. would somebody know what app postgres= ql uses for the authentication process? earlier on, i removed several <= BR>services which include portmapper, inetd, auth/identd, etc., to limi= t 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 ab= le to make a connection, and i also doubt if i could remove a package <= BR>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 a= m having problem. what baffles me is that 'www-data' can make a con= nection via phppgadmin. btw, i'm running phppgadmin 3.5.2, postgres= ql 7.4 on debian sarge 3.1, if that would help. <b= r>Check out Atenista.Net (www.atenista.net)- new design, regular conten= t and additional services!
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 ===
i'm sorry about the previous format. i didn't know my emails are being sent in html format until you pointed it out. nowthat 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 butit 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.kretschmer@schollglas.com> wrote: From: "A. Kretschmer" <andreas.kretschmer@schollglas.com> Date: Thu, 5 Jan 2006 09:48:53 +0100 To: pgsql-novice@postgresql.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@postgresql.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!
am 05.01.2006, um 4:14:24 -0800 mailte First Last folgendes: > > i'm trying to use phppgadmin to connect to postgresql and > except for the 'www-data' account, no other account could Your Webserver runs with this id, and so you can log in into pg with this username. > 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]'. comment the line in pg_hba.conf "local all postgres ident sameuser" and change to: "local all all trust" Then you can login with other login name. You should read this: http://www.postgresql.org/docs/current/static/client-authentication.html PS.: please no stupid Top-Posting with Fullquote. HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===