Problem login to PostGreSQL through phpPgAdmin

[milosh]

Dear all,

 

I have a problem login to PostGreSQL database through phpPgAdmin. I successfully created database and accounts for PostGreSQL database. But when I try to log in with created credentials, I'm getting error: Login failed. I tried with several different accounts and one more database, but no luck.

 

Please advice

 

Milosh

 

milosh.heliohost.org

 

[Ashoat]

Try accessing it now. If you get a red "X" on the left panel, click the entry next to it and it should load.

[milosh]

Dear djbob,

 

Thank you for your action. I was able to connect with accounts created yesterday.

However, new problem arise: "There are no databases associated with your account".

Also, if I try to create a new database from "PostgreSQL Databases", a receive a positive response that the database is created but when I'm back in that menu no databases are associated to my account.

 

Please advice

 

Milosh

 

milosh.heliohost.org

 

 

[milosh]

Hi,

 

Do you have any updates on this issue. I'm still unable to create POSTGRES database

 

Regards,

 

Milosh

[Ashoat]

I've figured out what's causing it... more of cPanel/WHM's mistake than anything else. I'll get back to you on this.

[Ashoat]

Here's the problem. You probably won't figure out what it means, but I'm keeping you posted anyways

Still talking to cPanel on fixing this problem.

 

1) cPanel needs to be able to access PostgreSQL. The only way cPanel is able to authenticate is via the "ident sameuser" authentication method, or just using "trust" to allow anyone.

2) PHPPgAdmin needs to be able to access PostgreSQL. The only way PHPpgAdmin is able to authenticate is via the "password" or "md5" authentication methods, or just using "trust" to allow anyone.

3) "Trust" is not an OK configuration because it allows users to access other users' databases.

4) PostgreSQL does not allow multiple authentication methods.

[milosh]

Hi djbob,

 

Do you have any updates regarding this issue.

 

Thank you in advance

 

Milos

 

[Ashoat]

Unfortunately, still no reponse from cPanel. I'll try to escalate the issue

[PYO]

Hi!

 

If someone still have problems with phpPgAdmin, I have workaround:

 

http://pyo.heliohost.org/phpPgAdmin-4.2/

 

Use your cPanel username/password.

[Ashoat]

My login failed. Perhaps it only works on the account it is installed on?

[PYO]

I don't know. Mine works fine

But I think it must work for everyone.

At least I saw other users db's (it's turned off now).

 

PS And I swear there is no logging for username/password in this installation. But if you are afraid of security don't use it!

 

PPS djbob. Can you copy this installation on your account? So I can try to login there.

[Ashoat]

At least I saw other users db's (it's turned off now).

Wait, could you actually access and modify other databases? You can try any database associated with the account "djbob" or "stevie" - they are all dummy databases.

[PYO]

No I can't.

[Ashoat]

OK, the issue should (finally) be resolved. Both cPanel's PostgreSQL and phpPgAdmin seem to be working.