Обсуждение: phpPgAdmin cannot login to server
I have asked this once, but never got a definitive answer, so am asking again. Have Suse 9.2 server running postgresql 7.4, apache 2. and phpPgAdmin. I can loginto to the server using either pgadminIII, OOoBase, or MS Acess from my windows machine with no problem. When I try to login with phpPgAdmin as postgres (same as in pgadmin or msaccess), all I get is a Login disallowed for security reasons and no info in serverlog or postgresql log. Logingin as user, I get Login failed and the serverlog show IDENT authentication fail for user afore. Would like to have any info with an example if possible on how to fix this or where to find out how to fix this. Have searched the web but found nothing. Art
> -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Art Fore > Sent: 03 February 2005 00:13 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] phpPgAdmin cannot login to server > > I have asked this once, but never got a definitive answer, so > am asking > again. > > Have Suse 9.2 server running postgresql 7.4, apache 2. and > phpPgAdmin. I > can loginto to the server using either pgadminIII, OOoBase, > or MS Acess > from my windows machine with no problem. When I try to login with > phpPgAdmin as postgres (same as in pgadmin or msaccess), all > I get is a > Login disallowed for security reasons and no info in serverlog or > postgresql log. Logingin as user, I get Login failed and the > serverlog > show IDENT authentication fail for user afore. > > Would like to have any info with an example if possible on how to fix > this or where to find out how to fix this. Have searched the web but > found nothing. Hi Art, This list is for pgAdmin support, not phpPgAdmin which is a separate product altogether. I would tell you the correct list to use but unfortunately I don't know - you might try sourceforge, I believe that is where the project is hosted. Regards, Dave.
It is not a problem of phpPgAdmin - it is it's default configuration. A
standart logins is not allowed by default.
You can try to connect with other login and non-blank password, or edit a
phpPgAdmin config file as showh in it's FAQ
-----Original Message-----
From: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Art Fore
Sent: Thursday, February 03, 2005 3:13 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] phpPgAdmin cannot login to server
I have asked this once, but never got a definitive answer, so am asking
again.
Have Suse 9.2 server running postgresql 7.4, apache 2. and phpPgAdmin. I can
loginto to the server using either pgadminIII, OOoBase, or MS Acess from my
windows machine with no problem. When I try to login with phpPgAdmin as
postgres (same as in pgadmin or msaccess), all I get is a Login disallowed
for security reasons and no info in serverlog or postgresql log. Logingin as
user, I get Login failed and the serverlog show IDENT authentication fail
for user afore.
Would like to have any info with an example if possible on how to fix this
or where to find out how to fix this. Have searched the web but found
nothing.
Art
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Yes, I realized after I sent the email that it was to the wrong list. thanks for your suggestion, but have not found any info on setting up Postgresql for use with phpPgAdmin in faq or anywhere else. Everything points to editing the pg_hba.conf file, but no info on what is required for phpPgAdmin. Thanks any way. Art mef wrote: > It is not a problem of phpPgAdmin - it is it's default configuration. A > standart logins is not allowed by default. > You can try to connect with other login and non-blank password, or edit a > phpPgAdmin config file as showh in it's FAQ > > -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Art Fore > Sent: Thursday, February 03, 2005 3:13 AM > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] phpPgAdmin cannot login to server > > I have asked this once, but never got a definitive answer, so am asking > again. > > Have Suse 9.2 server running postgresql 7.4, apache 2. and phpPgAdmin. I can > loginto to the server using either pgadminIII, OOoBase, or MS Acess from my > windows machine with no problem. When I try to login with phpPgAdmin as > postgres (same as in pgadmin or msaccess), all I get is a Login disallowed > for security reasons and no info in serverlog or postgresql log. Logingin as > user, I get Login failed and the serverlog show IDENT authentication fail > for user afore. > > Would like to have any info with an example if possible on how to fix this > or where to find out how to fix this. Have searched the web but found > nothing. > > Art > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > >