1

Temat: phppgadmin

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

# 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

postgresql.conf:

...
# - 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    
...

phppgadmin/config.inc.php

...
    // 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';
...

2

Odp: phppgadmin

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?

3

Odp: phppgadmin

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"