[ppa-help] [phppgadmin - Help] RE: Login fails - but I can connect OK with psql

[SourceForge.net <no...@so...>]

Read and respond to this message at: 
https://sourceforge.net/forum/message.php?msg_id=2586662
By: nobody

Thank you very much for your prompt reply. Unfortunately I stll have no luck...

1. How do you run postmaster? Try running it on the cygwin commandline like
this:
  /usr/bin/postmaster -D /usr/local/pgsql/data 	
Gave same result as usual way: postmaster -D /usr/local/pgsql/data
& gave database system is ready. Will also provide log messages

> 2. Edited phpPgAdmin/conf/config.inc.php
> $conf['servers'][0]['desc'] = 'PostgreSQL';
> $conf['servers'][0]['host'] = '127.0.0.1'; (Also tried localhost and '' )
> $conf['servers'][0]['port'] = 5432;
> $conf['servers'][0]['defaultdb'] = 'testx';

That's the configuration I use. I notice you have to use 127.0.0.1 IIRC since
windows doesn't do the unix socket properly.
jwm - also created dirs & specific paths for:
	$conf['servers'][0]['pg_dump_path'] = 'c:/cygwin//usr/bin/pg_dump';
	$conf['servers'][0]['pg_dumpall_path'] = 'c:/cygwin//usr/bin/pg_dumpall';

> 7. browser.php will display the 2 databases I have created OK but if I click
> on one it displays the login screen

How can you get the browser up if you can't login?
jwm 
http://localhost/phpPgAdmin/index.php gave split screen each with a login
screen
entering the correct login gave the list of databases for browser.php in the
left hand window
entering the correct login gave the welcome page for database.php with error
Warning: Undefined index: database in c:\apache\htdocs\phppgadmin\classes\Misc.php
on line 285. The links from the navigation bar were missing the database eg
Schemas gave phpPgAdmin/database.php?database=
clicking on one of the databases listed in the browser.php window reverted to
the login screen in hte browser window
clicking on Create Schemas reverted to the login screen in the database window

Do you have cookies set up correctly? I notice windows seems to have difficulty
in non-cookie mode. Set the session.save_path in your php.ini to c:\windows\temp
and make sure your browser accepts cookies.
jwm 
1.session.save_path=c:\windows\temp - already set
2. In IE6 Browser Tools>Internet>Privacy >advanced Privacy Settings ticked 'Always
allow session cookies' & prompt for others
3. Set Browser privacy and security to LOW
3. In Firewall permitted ingoing and outgoing packages for postgresql.exe
4. I just want to run phpPgAdmin on my local hard drive for development so ..
Turning off the firewall completely - made no difference
5. I can run phpMyAdmin successfully. 

Thank you for your assistance. Any further suggestions greatly appreciated

JWM


______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit: 
https://sourceforge.net/forum/unmonitor.php?forum_id=115884