LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 12-17-2003, 12:17 PM   #1
deadlock
Member
 
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:
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
 
Old 12-17-2003, 09:21 PM   #2
theSuperJason
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.

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

Original Poster
Rep: Reputation: 15
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
 
Old 12-18-2003, 06:19 AM   #4
deadlock
Member
 
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...

Dan
 
  


Reply


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


All times are GMT -5. The time now is 11:54 AM.

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