We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Can't Login to Postgres with phpPgAdmin

BetaPictoris
BetaPictoris asked
on
Medium Priority
1,814 Views
Last Modified: 2009-07-29
I'm having great difficulty connecting to Postgres on Fedora 5 with phpPgAdmin. No matter what I do, I can't login in with the postgres user and the dbadmin user I created.

I've tried various combinations in the pg_hba.conf file, and I also made $conf['extra_login_security'] = false in the config.inc.php file in Postgres. Nothing works. I changed the passwords for the postgres and dbadmin user as well in Postgres.

I can login without problems to the database from the command line, i.e.

   su - postgres
   psql template0

Does anyone have any ideas what I'm doing wrong and I what I need to do to login?

Thanks.
Comment
Watch Question

Commented:
Any error message?
---------
Just in case I want to mention taht you neet to restart postreSQL after you have made changes in pg_hba.conf file.
------------
Are you sure that phpPgAdmin is configured properly?
------------
Does the webserver supports postgresql connections? ==> pg_connect
-------------
can you login using IP address?

 psql --host hostname/IPaddress template0

-----------
how about little test with just simple php script?
<?php
$conn_string = "host=yourhost port=5432 dbname=yourdatabase user=postgres password=pass";
$dbconn = pg_connect ($conn_string);

if ($dbconn ) {
echo "connected";
}

?>
----------

check postresql.conf and make sure that:
tcpip_socket = true

hope this helps..

lubo

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks Luxana. I made a minor change to phpPgAdmin and restarted Postgres and everything works ok.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.