I have a problem with logging in. After I succesfully log in and I navigate further I again have to log in.
I get to see the list of databases. And with the same username/password I can use pgql.
Help would be much appreciated!
NB there is a strange icon (serverOut.png) in front of my server in the left frame. Maybe this is related? I don't know what it means though.
setup:
I use postgresql 8.1 and the phppgadmin 4.0.
cookies:
The cookies seem to arrive, but it is not clear to me what happens with them: i see them in the response headers: Set-Cookie: PPA_ID=l0v2soj63nbjgtrt6hvudlsb51; path=\
Expires: Thu, 19 Nov 1981 08:52:00 GMT.
But with the cookie editor it says 'expiry at end of session'
phppgadmin:
I do have the settings I found on the forum:
$conf['extra_login_security'] = false;
$conf['servers'][0]['host'] = 'localhost';
php:
session.use_cookies = 1
session.save_path = "C:\WINDOWS\Temp\session_data"
pg_hba:
host all all 127.0.0.1/32 trust
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
pg:
listen_addresses = '*' ( this is for versions > 8.0 instead of tcpip_socket=true, i believe )
port = 5432
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
phpPgAdmin 4.0.1 logs into PostgreSQL 8.1 succesfully, obtains and displays available database info, then logs out of PostgreSQL. Subsequent phpPgAdmin actions recycle login process.
phpPgAdmin status line:
PostgreSQL 8.1.0 running on localhost:5432 -- You are logged in as user "postgres", 5th Dec, 2005 7:59AM
I think I've found the solution. Check apachas error log, and you propably find something like this:
Mon Jan 23 00:01:28 2006] [error] PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: open(/tmp//sess_oidtduliea20h1hgf5
rru1ii02, O_RDWR) failed: Permission denied (13) in /phpPgAdmin/libraries/lib.inc.php on line 77
Make sure that your server accepts sessions, and that apache/php can write to the that diractory you've set in php.ini, namely: session.save_path
For me, since I'm running a chrooted apache this variable is set to /tmp (which, in fact is /var/www/tmp/). Next, make sure the permissions for that dir are correct so. Then it should work...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I blindly did a cut and past from the phpadmin faq
of the line:
session.save_path = "c:\windows\temp"
into c:\php\php.ini, but DID NOT heed the warning after that cut line that warns:
"And make sure that the folder c:\windows\temp actually exists."
My windows temp directory is c:\winnt\temp, so the php.ini added line should have been:
session.save_path = "c:\winnt\temp"
After making the above change to php.ini and restarting Apache, phpPgAdmin login now works.
Thanks again!
(Follow up to my above post: 2005-12-05 06:00)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a problem with logging in. After I succesfully log in and I navigate further I again have to log in.
I get to see the list of databases. And with the same username/password I can use pgql.
Help would be much appreciated!
NB there is a strange icon (serverOut.png) in front of my server in the left frame. Maybe this is related? I don't know what it means though.
setup:
I use postgresql 8.1 and the phppgadmin 4.0.
cookies:
The cookies seem to arrive, but it is not clear to me what happens with them: i see them in the response headers: Set-Cookie: PPA_ID=l0v2soj63nbjgtrt6hvudlsb51; path=\ Expires: Thu, 19 Nov 1981 08:52:00 GMT.
But with the cookie editor it says 'expiry at end of session'
phppgadmin:
I do have the settings I found on the forum:
$conf['extra_login_security'] = false;
$conf['servers'][0]['host'] = 'localhost';
php:
session.use_cookies = 1
session.save_path = "C:\WINDOWS\Temp\session_data"
pg_hba:
host all all 127.0.0.1/32 trust
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
pg:
listen_addresses = '*' ( this is for versions > 8.0 instead of tcpip_socket=true, i believe )
port = 5432
I have some apps that don't work correctly with php 5
Definitely, it won't work right with php 5
Works fine for me in 5.1. Sure it's not your browser?
Chris
I have the same problem.
phpPgAdmin 4.0.1 logs into PostgreSQL 8.1 succesfully, obtains and displays available database info, then logs out of PostgreSQL. Subsequent phpPgAdmin actions recycle login process.
phpPgAdmin status line:
PostgreSQL 8.1.0 running on localhost:5432 -- You are logged in as user "postgres", 5th Dec, 2005 7:59AM
Browser status line:
Waiting for [server]...
PostgreSQL LOG:
2005-12-05 07:59:12 LOG: connection received: host=127.0.0.1 port=2638
2005-12-05 07:59:12 LOG: connection authorized: user=postgres database=postgres
2005-12-05 07:59:12 LOG: disconnection: session time: 0:00:00.26 user=postgres database=postgres host=127.0.0.1 port=2638
pgAdminIII 1.4 works fine
pgAccess 0.99 works fine
PostgreSQL 8.1
PHP 5.1.1
Apache 2.0.55
phpPgAdmin 4.0.1
Firefox 1.5
IE 6.0.28
Win2KSP4 5.00.2195
P4 Northwood HT enabled
I have the same problem, on 2 different servers.
The first is :
phpPgAdmin 4.0.0
php 5.1.0
postgresql 8.1.0
firefox 1.5
2 CPU Athlon MP
The second is :
phpPgAdmin 4.0.1
php 5.1.1
postgresql 8.1.1
firefox 1.0
1 P4 HT disabled
I have solved the issue on both servers by installing phpPgAdmin 3.x
Jono
I have the same problem, but it didn't solve by installing phpPgAdmin 3.4.1
First I tried with phpPgAdmin 4.0.1
The rest of my setup is OpenBSD 3.8 and php5.0.4 and postgresql 8.0.3
Any suggestions?
I think I've found the solution. Check apachas error log, and you propably find something like this:
Mon Jan 23 00:01:28 2006] [error] PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: open(/tmp//sess_oidtduliea20h1hgf5
rru1ii02, O_RDWR) failed: Permission denied (13) in /phpPgAdmin/libraries/lib.inc.php on line 77
Make sure that your server accepts sessions, and that apache/php can write to the that diractory you've set in php.ini, namely: session.save_path
For me, since I'm running a chrooted apache this variable is set to /tmp (which, in fact is /var/www/tmp/). Next, make sure the permissions for that dir are correct so. Then it should work...
Thanks, now it works.
I did everything right exept setting the permissions correct in /var/www/tmp
hehe, got to feel a bit stupid :)
Thank you! I also feel a bit stupid :)
I blindly did a cut and past from the phpadmin faq
of the line:
session.save_path = "c:\windows\temp"
into c:\php\php.ini, but DID NOT heed the warning after that cut line that warns:
"And make sure that the folder c:\windows\temp actually exists."
My windows temp directory is c:\winnt\temp, so the php.ini added line should have been:
session.save_path = "c:\winnt\temp"
After making the above change to php.ini and restarting Apache, phpPgAdmin login now works.
Thanks again!
(Follow up to my above post: 2005-12-05 06:00)