phpPgAdmin setup problems

deadlock · 12-17-2003, 12:17 PM

I am having problems setting up phpPgAdmin to access and administer a new postgres database server.

I have set up postgres, and installed a database called mydb on it. I have also set up an additional user, dan to the standard postgres user.

I have also installed phpPgAdmin and can access the login page. However neither user can log in, getting "login failed" messages.

At the moment I am not worried about the security of the service - I want to get it working, then lock down as I go...

My pg_hba.conf is as follows:

Code:

local    all     all                                       trust
host     all     all     127.0.0.1     255.255.255.255     trust

My [I]config_inc_php.conf[/I(} is set up like:

Code:

$conf['servers'][0]['desc'] = 'PostgreSQL';
$conf['servers'][0]['host'] = '127.0.0.1';
$conf['servers'][0]['port'] = 5432;
$conf['servers'][0]['defaultdb'] = 'template1';

and then as standard.

Any help???

Trying to access from local at the moment.

Dan

theSuperJason · 12-17-2003, 09:21 PM

Hi Dan

Did you start Postgres with the '-i' option? If not, it won't be listening for a TCP connection and will only use a UNIX socket for connections.

Try:

/usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data &

OR just change the line:

$conf['servers'][0]['host'] = '127.0.0.1';

to read:

$conf['servers'][0]['host'] = '';

Without a hostname or IP, phpPgAdmin will try and use a UNIX socket rather than via TCP/IP

HTH, Jason

deadlock · 12-18-2003, 04:50 AM

Thanks,

I have tried changing the $conf line to be blank, but I still get the same problem.

"Login Failed" when I hit OK

The User dan has no password set up in the db and can conenct to the db fine when I am logged in as him. I there anything else I can do?

Or is there another program that will allow me to set up the nwetworking for postgresql with less hassle???

Dan

deadlock · 12-18-2003, 06:19 AM

Somehow I have got this working.

Installed Webmin and did a couple of reboots and I now have loca access.
Now to get the ODBC working...

Dan