PostgreSQL/phpPgAdmin Default Login

Raptor354 · 06-18-2009, 02:27 PM

I'm just starting to switch over to PostgreSQL from MySQL for my website backend. With MySQL, I know and love phpMyAdmin, so I wanted phpPgAdmin for managing PostgreSQL.

But how do you log in to phpPgAdmin? I can easily log in via the CLI on the server, but none of the credentials I've tried work.

I've asked google in a few different ways, but to no avail. I've tweaked all the files google said, but no gain. Am I just missing something?

Any thoughts?

Raptor354

Tinkster · 06-18-2009, 09:33 PM

It may come down to proper entries in pg_hba.conf ... how
does the apache instance running phpPgAdmin (try to) talk
to the postgres server?

Cheers,
Tink

Raptor354 · 06-19-2009, 12:05 AM

Here's my pg_hba.conf file:

Code:

local   all         all                               ident sameuser
host    all         all         127.0.0.1/32          md5
host    all         all         ::1/128               md5
host    all         all         192.168.11.0/24       md5

This should support external queries, right?

What's the default login credentials, though?

Tinkster · 06-19-2009, 05:01 PM

Quote:

Originally Posted by Raptor354

Here's my pg_hba.conf file:

Code:

local   all         all                               ident sameuser
host    all         all         127.0.0.1/32          md5
host    all         all         ::1/128               md5
host    all         all         192.168.11.0/24       md5

This should support external queries, right?

Line 1 allows for unix socket connections for all OS users
who have access rights to the database that you're trying
to connect to using the same name within postgres .

Lines 3-4 allow any user whose name is defined within postgres
to connect using an MD5 password.

Quote:

Originally Posted by Raptor354

What's the default login credentials, though?

There are none. It will depend on the distro that the
server in question is running. And you didn't tell me
whether apached and postgres are on the same box, either.

Cheers,
Tink

Raptor354 · 06-19-2009, 07:12 PM

Sorry. Everything is on the same OS on the same box. And if it helps, I'm running Ubuntu Server 9.04.

Ideally, I'd have the database on a VM that doesn't have internet access, but that kind of setting should be in a config file somewhere, right? I have VMWare Server 2 set up and ready to have an OS installed.

Tinkster · 06-19-2009, 07:30 PM

OK. I've never used phpPgAdmin, so can't walk you through
the set-up. I'd suggest bumping up postgres' log-level,
restarting the service and then looking at the log ... it
should give you SOME indication what is/why it's failing.

Check the config file for phpPgAdmin, see as what user it's
trying to connect, what type of connection it's trying to
establish, what credentials it's using (I assume user postgres,
no password, which would fail given the pg_hba.conf above).

Cheers,
Tink