LinuxQuestions.org - phpPgAdmin setup problems

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - phpPgAdmin setup problems (https://www.linuxquestions.org/questions/linux-software-2/phppgadmin-setup-problems-126659/)

phpPgAdmin setup problems

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

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

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

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