Обсуждение: phpPgAdmin configuration
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
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 failedmessage. > 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
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 failedmessage. > 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
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
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 >
The account has a password. Apache is working. I never configured the vhost on the live red hat server. This is what is soconfusing everything that I can see is the same on the live server (which I configured as well) and it works there butnot 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 okand the vhost is also correctly configured, but maybe you could have a look at its configuration? I run Fedora & have encounteredsimilar 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 >
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