PostgreSQL access denied

[gregpearman]

I have setup a PostgreSQL database and created and added a user to that database. But, when I try to access that database using a PHP page with the new user I get an access denied error message.

Also, if I try and access the database using that user via the phpPgAdmin page, I also get an access denied error message.

If I use the main database user that was created for me when my account was setup, I am able to access the database both ways (php and admin page).

I have even gone in via the admin page and granted all privilages to the new user to all the database tables.

Any suggestions?

[pallmall]

I'm having the same problem. I've tried all combinations of username and passwords (with "domain_" and without). I can't login to the database as the non domain master user in PhpPgAdmin, or in the PHP test I have created to test db access. If I use my domain administrator username and password, I can login from PhpPgAdmin, and my PHP test works as well (I immediately changed the script credentials back to that of my "access denied" user because of the security risk involved).

I thought I would post here in the forums before submitting a support ticked.

Thanks

[gregpearman]

I never got a response and I never found a resolution to the problem. I would suggest opening a support ticket. If you do find a resolution, would you please post it here?

Sincerely,

Greg Pearman

[pallmall]

I've just submitted a support ticket, and I will post the response here when it's available.

I also asked about making TCP/IP available (it's not allowed by default at bluehost,) if possible.

Will let you know,

pallmall

[pallmall]

Hi,

Just wanted to let you know that I spoke with bluehost support about logging in to postgresql with a username and password that is not the domain master username and password. They told me that some of the servers are misconfigured, and they don't know for sure which ones they are, and therefore the only options are to use your domain master username and password in php scripts (bad idea, putting your credentials out in the open), use another database (i.e. MySQL), or change hosts.

Before anyone thinks I am slamming Bluehost, I want to say that they gave me the straight answers without any run-around or issue dodging. I think Bluehost is a decent hosting service, and I will probably test other sites here in the future. Unfortunately, the work I want to put on the web is done is Postgresql, and not in MySQL. That leaves me only the last option mentioned above.

Wish I had better news, but ...

--pallmall