Forums WAPPStack

Login PostgreSQL failure - 0.9-beta stack

Subscribe to Login PostgreSQL failure - 0.9-beta stack 8 post(s), 4 voice(s)

 
Avatar JonB 2 post(s)

The password that I selected during installation is not being accepted for login to PostgreSQL. I used administrator as the Username.

The selected password did work to gain access to phpPGAdmin, although.

This problem occured when I first installed WAPP. Thinking that I may have somehow typed the password incorrectly (twice) at install time, I uninstalled WAPP and re-installed it. The second time I carefully entered/recorded the password. The same problem still shows up.

 
Avatar diego 16 post(s)

Hello JonB, the ‘administrator’ username is used to access the phpPgAdmin panel. Once you are inside you must log to a database and each database you create can have a different owner. But you also have a default “root” user which name is “postgres” that can access and create databases.

So if you want to login use “postgres” as user and the password that you provide during the installation process.

I hope it helps you. Cheers

 
Avatar JonB 2 post(s)

Thanks diego. Was that documented somewhere? Where should I have looked for that information?

 
Avatar diego 16 post(s)

Well, it is the PostgreSQL standard so it is documented in the main postgresql documentation. But we should improve our documentation adding that information.

Postgres user can create other users and give administrator permissions to them, so you can use the CREATE ROLE function in phpPgAdmin if you feel more comfortable with it.

If you have more suggestions or ideas to improve the stack, feel free to contribute.

Cheers

 
Avatar lah 2 post(s)

Hello,
I can’t access to the phpPgAdmin panel.
I installed the WAPPStack (XP – French) and services are running.
I try couples of Login / Pwd but all I obtain is:
“This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (e.g., bad password), or your browser doesn’t understand how to supply the credentials required.”
Do you have any idea ?
Thanks

 
Avatar diego 16 post(s)

There are two login steps with the phpPgAdmin panel. The first one is to login to reach the panel. You must insert “administrator” as the user and the password you supplied during the installation.

Once you are in the panel, you have to log to the PostgreSQL database. Here the username is “postgres” and the password the one you supplied during the installation. It is the same password the two times.

From now on, you can create PostgreSQL users with the panel, so next time you will be able to log, as the users you create, to the databases. But the “administrator” user to access the panel will always remain the same.

Hope it helps.

 
Avatar lah 2 post(s)

oups, sorry
I didn’t understand that the password of the phpPgAdmin panel was (also) the password given for the ‘database postgres user’... so it’s ok now …
Thanks for your reply !

 
Avatar vinic 1 post

Ran into this same roadblock. Glad this post was here and recent. IMO this needs to be noted somewhere in the BitNami literature.

Thanx.

Forums WAPPStack