Solved

Can't Login to Postgres with phpPgAdmin

Posted on 2006-11-07
2
1,710 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.
0
Comment
Question by:BetaPictoris
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
Luxana earned 250 total points
ID: 17895260
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
0
 

Author Comment

by:BetaPictoris
ID: 17901379
Thanks Luxana. I made a minor change to phpPgAdmin and restarted Postgres and everything works ok.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question