<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[Forum PostgreSQL - phppgadmin]]></title>
	<link rel="self" href="http://forum.postgresql.org.pl/extern.php?action=feed&amp;tid=452&amp;type=atom"/>
	<updated>2010-06-15T11:19:57Z</updated>
	<generator>PunBB</generator>
	<id>https://forum.postgresql.org.pl/viewtopic.php?id=452</id>
		<entry>
			<title type="html"><![CDATA[Odp: phppgadmin]]></title>
			<link rel="alternate" href="https://forum.postgresql.org.pl/viewtopic.php?pid=2087#p2087"/>
			<content type="html"><![CDATA[[quote=rski]Ale apacza oczywiście masz czy jakiś tam inny serwer www. Bo phppgadmin to chyba nie ma nic wbudowanego co? Co dostajesz w logach apache'a.
Nie masz strony do zalogowania a co masz?[/quote]
po wpisaniu adresu [url]http://x.x.x.x:5432[/url] do przeglądarki jest tabula rasa.
apache2/access.log
[code]
10.1.0.64 - - [14/Jun/2010:22:58:40 +0200] "GET / HTTP/1.1" 200 56 "-" "Mozilla/5.0 (X11; U; Linux x86_64; pl-PL; rv:1.9.0.13) Gecko/2009080315 Ubuntu/9.04 (jaunty) Firefox/3.0.13"
10.1.0.64 - - [14/Jun/2010:22:58:40 +0200] "GET /favicon.ico HTTP/1.1" 404 263 "-" "Mozilla/5.0 (X11; U; Linux x86_64; pl-PL; rv:1.9.0.13) Gecko/2009080315 Ubuntu/9.04 (jaunty) Firefox/3.0.13"
10.1.0.64 - - [14/Jun/2010:22:58:43 +0200] "GET /favicon.ico HTTP/1.1" 404 263 "-" "Mozilla/5.0 (X11; U; Linux x86_64; pl-PL; rv:1.9.0.13) Gecko/2009080315 Ubuntu/9.04 (jaunty) Firefox/3.0.13"
[/code]
apache2/error.log
[code]
[Mon Jun 14 22:42:27 2010] [notice] Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.5 with Suhosin-Patch configured -- resuming normal operations
[Mon Jun 14 22:56:45 2010] [notice] caught SIGTERM, shutting down
[Mon Jun 14 22:56:47 2010] [notice] Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.5 with Suhosin-Patch configured -- resuming normal operations
[Mon Jun 14 22:58:16 2010] [notice] caught SIGTERM, shutting down
[Mon Jun 14 22:58:17 2010] [notice] Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.5 with Suhosin-Patch configured -- resuming normal operations
[Mon Jun 14 22:58:40 2010] [error] [client 10.1.0.64] File does not exist: /var/www/favicon.ico
[Mon Jun 14 22:58:43 2010] [error] [client 10.1.0.64] File does not exist: /var/www/favicon.ico
[Tue Jun 15 00:18:14 2010] [notice] caught SIGTERM, shutting down
[Tue Jun 15 11:33:44 2010] [notice] Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.5 with Suhosin-Patch configured -- resuming normal operations
[/code]]]></content>
			<author>
				<name><![CDATA[Hobo]]></name>
				<uri>https://forum.postgresql.org.pl/profile.php?id=1120</uri>
			</author>
			<updated>2010-06-15T11:19:57Z</updated>
			<id>https://forum.postgresql.org.pl/viewtopic.php?pid=2087#p2087</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Odp: phppgadmin]]></title>
			<link rel="alternate" href="https://forum.postgresql.org.pl/viewtopic.php?pid=2085#p2085"/>
			<content type="html"><![CDATA[Ale apacza oczywiście masz czy jakiś tam inny serwer www. Bo phppgadmin to chyba nie ma nic wbudowanego co? Co dostajesz w logach apache'a.
Nie masz strony do zalogowania a co masz?]]></content>
			<author>
				<name><![CDATA[rski]]></name>
				<uri>https://forum.postgresql.org.pl/profile.php?id=26</uri>
			</author>
			<updated>2010-06-14T21:05:40Z</updated>
			<id>https://forum.postgresql.org.pl/viewtopic.php?pid=2085#p2085</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[phppgadmin]]></title>
			<link rel="alternate" href="https://forum.postgresql.org.pl/viewtopic.php?pid=2084#p2084"/>
			<content type="html"><![CDATA[witam,
zainstalowałem phppgadmin do postgresa 8.3 na ubuntu, wszystko z repozytoriów i niestety wpisując adres w przeglądarce nie mam strony do zalogowania. Poprosze o pomoc w konfiguracji.
system: ubuntu 9.04 server, tylko cl
baza: postgres 8.3
pg_hba.conf
[code]
# Database administrative login by UNIX sockets
local   all         postgres                          ident sameuser

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               md5
# IPv4 local connections:
hostnossl    all    all    10.0.0.1/32    md5
host    all         all         10.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               md5[/code]
postgresql.conf:
[code]
...
# - Connection Settings -

listen_addresses = '*'        # what IP address(es) to listen on;
                    # comma-separated list of addresses;
                    # defaults to 'localhost', '*' = all
                    # (change requires restart)
port = 5432                # (change requires restart)
max_connections = 100    
...
[/code]
phppgadmin/config.inc.php
[code]
...
    // Hostname or IP address for server.  Use '' for UNIX domain socket.
    // use 'localhost' for TCP/IP connection on this computer
    $conf['servers'][0]['host'] = '';

    // Database port on server (5432 is the PostgreSQL default)
    $conf['servers'][0]['port'] = 5432;

    // Database SSL mode
    // Possible options: disable, allow, prefer, require
    // To require SSL on older servers use option: legacy
    // To ignore the SSL mode, use option: unspecified
    $conf['servers'][0]['sslmode'] = 'allow';

    // Change the default database only if you cannot connect to template1.
    // For a PostgreSQL 8.1+ server, you can set this to 'postgres'.
    $conf['servers'][0]['defaultdb'] = 'template1';
...
[/code]]]></content>
			<author>
				<name><![CDATA[Hobo]]></name>
				<uri>https://forum.postgresql.org.pl/profile.php?id=1120</uri>
			</author>
			<updated>2010-06-14T21:03:11Z</updated>
			<id>https://forum.postgresql.org.pl/viewtopic.php?pid=2084#p2084</id>
		</entry>
</feed>
