Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 12-17-2003, 12:17 PM   #1
Registered: Apr 2003
Distribution: Red Hat
Posts: 65

Rep: Reputation: 15
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:
local    all     all                                       trust
host     all     all     trust
My [I]config_inc_php.conf[/I(} is set up like:
$conf['servers'][0]['desc'] = 'PostgreSQL';
$conf['servers'][0]['host'] = '';
$conf['servers'][0]['port'] = 5432;
$conf['servers'][0]['defaultdb'] = 'template1';
and then as standard.

Any help???

Trying to access from local at the moment.

Old 12-17-2003, 09:21 PM   #2
LQ Newbie
Registered: Sep 2003
Location: Brisbane, AUS
Distribution: Slackware
Posts: 14

Rep: Reputation: 0
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.


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

OR just change the line:

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

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
Old 12-18-2003, 04:50 AM   #3
Registered: Apr 2003
Distribution: Red Hat
Posts: 65

Original Poster
Rep: Reputation: 15

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???

Old 12-18-2003, 06:19 AM   #4
Registered: Apr 2003
Distribution: Red Hat
Posts: 65

Original Poster
Rep: Reputation: 15
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...



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to start phpPGAdmin in Mandrake 10.1? bdika Mandriva 2 09-06-2005 06:59 PM
Apache2 - PHPpgadmin won't work on FireFox SWAT Linux - Newbie 3 02-14-2005 03:33 PM
dansguardian setup problems!!! kbrian38 Linux - Software 1 06-16-2004 10:10 PM
Apache-php-postgresql-phppgadmin koswo Linux - Software 0 02-05-2004 07:05 AM
problem with installing phppgadmin elea0612 Programming 0 05-22-2003 05:31 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:00 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration