A lecturer demanded that we do some homework in PHP and PostgreSQL, so I downloaded a package off the internet called "The BitNami WAPPStack" which had php, phpPgAdmin.
The problem is I have failed to access the database and I keep failing to login yet I have checked the password and its ok. am using the following:
- username: Administrator
- password: 123
Attempts at reading up the problem have failed. i came across some cryptic FAQs from phpPgAdmin
Q: I always get "Login failed" even though I'm sure I'm using the right username and password.
A: There are a number of reasons why you might not be able to connect, typically having nothing to do with phpPgAdmin itself. First check the Postgres log on your server, it should contain a FATAL error message detailing the exact reason why the login is failing. You will probably need to either adjust the username or password, add LOGIN permissions to the role, or adjust your pg_hba.conf file in your Postgres data dir; so follow the directions laid out in the FATAL message.
- you will probably need to adjust the username and password :( a've tried many times)
- add LOGIN permissions to the role (what the heck is this geek stuff?)
- adjust pg_hba.conf(why does a newbie have to edit any configurations?)
After several futile attempts am almost giving up.
whats the most painless way of getting php, postgresql to work (set up file prefered to building from sources) Thanks.
EDIT: Am running windows xp sp2.