<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Forum PostgreSQL - phppgadmin]]></title>
		<link>https://forum.postgresql.org.pl/viewtopic.php?id=452</link>
		<description><![CDATA[Najświeższe odpowiedzi w phppgadmin.]]></description>
		<lastBuildDate>Tue, 15 Jun 2010 11:19:57 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Odp: phppgadmin]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=2087#p2087</link>
			<description><![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]]]></description>
			<author><![CDATA[dummy@example.com (Hobo)]]></author>
			<pubDate>Tue, 15 Jun 2010 11:19:57 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=2087#p2087</guid>
		</item>
		<item>
			<title><![CDATA[Odp: phppgadmin]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=2085#p2085</link>
			<description><![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?]]></description>
			<author><![CDATA[dummy@example.com (rski)]]></author>
			<pubDate>Mon, 14 Jun 2010 21:05:40 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=2085#p2085</guid>
		</item>
		<item>
			<title><![CDATA[phppgadmin]]></title>
			<link>https://forum.postgresql.org.pl/viewtopic.php?pid=2084#p2084</link>
			<description><![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]]]></description>
			<author><![CDATA[dummy@example.com (Hobo)]]></author>
			<pubDate>Mon, 14 Jun 2010 21:03:11 +0000</pubDate>
			<guid>https://forum.postgresql.org.pl/viewtopic.php?pid=2084#p2084</guid>
		</item>
	</channel>
</rss>
