pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedphpPgAdmin configuration
7+ messages / 3 participants
[nested] [flat]
* phpPgAdmin configuration
@ 2011-02-08 22:23 Marc Fromm <Marc.Fromm@wwu.edu>
0 siblings, 2 replies; 7+ messages in thread
From: Marc Fromm @ 2011-02-08 22:23 UTC (permalink / raw)
To: pgsql-admin
I installed phpPgAdmin on my red hat box in the /var/www/html directory.
I edited the pg_hba.conf file as many tutorials stated with the lines.
local all all trust
host all all 127.0.0.1/32 trust
When I try to login to phpPgAdmin with a user account that I created, using the CREATE USER command, I get the login failed message.
What else do I need to configure to allow access with phpPgAdmin?
Thanks
Marc
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: phpPgAdmin configuration
@ 2011-02-08 23:03 Guillaume Lelarge <guillaume@lelarge.info>
parent: Marc Fromm <Marc.Fromm@wwu.edu>
1 sibling, 1 reply; 7+ messages in thread
From: Guillaume Lelarge @ 2011-02-08 23:03 UTC (permalink / raw)
To: Marc Fromm <Marc.Fromm@wwu.edu>; +Cc: pgsql-admin
Le 08/02/2011 23:23, Marc Fromm a écrit :
> I installed phpPgAdmin on my red hat box in the /var/www/html directory.
> I edited the pg_hba.conf file as many tutorials stated with the lines.
> local all all trust
> host all all 127.0.0.1/32 trust
>
Meaning you have your database server on the same server than the http
server?
> When I try to login to phpPgAdmin with a user account that I created, using the CREATE USER command, I get the login failed message.
>
What's the complete error message?
> What else do I need to configure to allow access with phpPgAdmin?
>
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: phpPgAdmin configuration
@ 2011-02-08 23:27 Marc Fromm <Marc.Fromm@wwu.edu>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 7+ messages in thread
From: Marc Fromm @ 2011-02-08 23:27 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: pgsql-admin
Yes, the database server is on the same server as the http server.
The complete error message is just "Login failed."
There is nothing in the pg_log file, that the FAQ's say to check.
Marc
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Guillaume Lelarge
Sent: Tuesday, February 08, 2011 3:04 PM
To: Marc Fromm
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] phpPgAdmin configuration
Le 08/02/2011 23:23, Marc Fromm a écrit :
> I installed phpPgAdmin on my red hat box in the /var/www/html directory.
> I edited the pg_hba.conf file as many tutorials stated with the lines.
> local all all trust
> host all all 127.0.0.1/32 trust
>
Meaning you have your database server on the same server than the http server?
> When I try to login to phpPgAdmin with a user account that I created, using the CREATE USER command, I get the login failed message.
>
What's the complete error message?
> What else do I need to configure to allow access with phpPgAdmin?
>
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: phpPgAdmin configuration
@ 2011-02-08 23:35 Guillaume Lelarge <guillaume@lelarge.info>
parent: Marc Fromm <Marc.Fromm@wwu.edu>
0 siblings, 1 reply; 7+ messages in thread
From: Guillaume Lelarge @ 2011-02-08 23:35 UTC (permalink / raw)
To: Marc Fromm <Marc.Fromm@wwu.edu>; +Cc: pgsql-admin
Le 09/02/2011 00:27, Marc Fromm a écrit :
> Yes, the database server is on the same server as the http server.
> The complete error message is just "Login failed."
>
> There is nothing in the pg_log file, that the FAQ's say to check.
>
How did you configure phpPgAdmin?
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: phpPgAdmin configuration
@ 2011-02-09 00:57 barbara@bariloche.com.ar
parent: Marc Fromm <Marc.Fromm@wwu.edu>
1 sibling, 1 reply; 7+ messages in thread
From: barbara@bariloche.com.ar @ 2011-02-09 00:57 UTC (permalink / raw)
To: Marc Fromm <Marc.Fromm@wwu.edu>; +Cc: pgsql-admin
Hello:
Is it a passwordless account? I ran in such an error using a passwordless
account.
Since the error supposes a successful connection to the server &
unsuccessful login attempt, I guess apache is running ok and the vhost is
also correctly configured, but maybe you could have a look at its
configuration? I run Fedora & have encountered similar problems on every
upgrade (shame on me, I forget about it until the next upgrade...)
Barbara
> I installed phpPgAdmin on my red hat box in the /var/www/html directory.
> I edited the pg_hba.conf file as many tutorials stated with the lines.
> local all all
> trust
> host all all 127.0.0.1/32 trust
>
> When I try to login to phpPgAdmin with a user account that I created,
> using the CREATE USER command, I get the login failed message.
>
> What else do I need to configure to allow access with phpPgAdmin?
>
> Thanks
>
> Marc
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: phpPgAdmin configuration
@ 2011-02-09 15:53 Marc Fromm <Marc.Fromm@wwu.edu>
parent: barbara@bariloche.com.ar
0 siblings, 0 replies; 7+ messages in thread
From: Marc Fromm @ 2011-02-09 15:53 UTC (permalink / raw)
To: barbara@bariloche.com.ar <barbara@bariloche.com.ar>; +Cc: pgsql-admin
The account has a password. Apache is working. I never configured the vhost on the live red hat server. This is what is so confusing everything that I can see is the same on the live server (which I configured as well) and it works there but not on this test box.
I must be missing something simple but I cannot seem to see it.
-----Original Message-----
From: barbara@bariloche.com.ar [mailto:barbara@bariloche.com.ar]
Sent: Tuesday, February 08, 2011 4:57 PM
To: Marc Fromm
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] phpPgAdmin configuration
Hello:
Is it a passwordless account? I ran in such an error using a passwordless account.
Since the error supposes a successful connection to the server & unsuccessful login attempt, I guess apache is running ok and the vhost is also correctly configured, but maybe you could have a look at its configuration? I run Fedora & have encountered similar problems on every upgrade (shame on me, I forget about it until the next upgrade...) Barbara
> I installed phpPgAdmin on my red hat box in the /var/www/html directory.
> I edited the pg_hba.conf file as many tutorials stated with the lines.
> local all all
> trust
> host all all 127.0.0.1/32 trust
>
> When I try to login to phpPgAdmin with a user account that I created,
> using the CREATE USER command, I get the login failed message.
>
> What else do I need to configure to allow access with phpPgAdmin?
>
> Thanks
>
> Marc
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: phpPgAdmin configuration
@ 2011-02-09 16:08 Marc Fromm <Marc.Fromm@wwu.edu>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 7+ messages in thread
From: Marc Fromm @ 2011-02-09 16:08 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: pgsql-admin
I just found my problem. In the config.inc.php page, I needed to change $conf['servers'][0]['host'] = 'host'; to $conf['servers'][0]['host'] = 'localhost';. After that change I was able to login with the account that I created.
-----Original Message-----
From: Guillaume Lelarge [mailto:guillaume@lelarge.info]
Sent: Tuesday, February 08, 2011 3:36 PM
To: Marc Fromm
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] phpPgAdmin configuration
Le 09/02/2011 00:27, Marc Fromm a écrit :
> Yes, the database server is on the same server as the http server.
> The complete error message is just "Login failed."
>
> There is nothing in the pg_log file, that the FAQ's say to check.
>
How did you configure phpPgAdmin?
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2011-02-09 16:08 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-02-08 22:23 phpPgAdmin configuration Marc Fromm <Marc.Fromm@wwu.edu>
2011-02-08 23:03 ` Guillaume Lelarge <guillaume@lelarge.info>
2011-02-08 23:27 ` Marc Fromm <Marc.Fromm@wwu.edu>
2011-02-08 23:35 ` Guillaume Lelarge <guillaume@lelarge.info>
2011-02-09 16:08 ` Marc Fromm <Marc.Fromm@wwu.edu>
2011-02-09 00:57 ` barbara@bariloche.com.ar
2011-02-09 15:53 ` Marc Fromm <Marc.Fromm@wwu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox