Bonjour,

Je suis en train d'installer l'interface graphique phppgadmin mais sans succès pour le moment, snif !

J'ai le message suivant qui apparaît lorsque j'essaye de me connecter dessus en mode web :

PhpPgAdmin : erreur lors du chargement servers.php?action=tree (200: OK)

Il s'agit de la version 4.1.3. La version de postgresql est la 8.2.

Voici mes fichiers de config :

apache.conf
Code :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
Alias /phppgadmin /usr/share/phppgadmin/
 
<DirectoryMatch /usr/share/phppgadmin/>
 
DirectoryIndex INDEX.php
Options +FollowSymLinks
AllowOverride None
 
ORDER deny,allow
deny FROM ALL
allow FROM 127.0.0.0/255.0.0.0
allow FROM monIP
# allow from all
 
<IfModule mod_php4.c>
  php_flag magic_quotes_gpc Off
  php_flag track_vars ON
  php_flag register_globals ON
  php_value include_path .
</IfModule>
 
<IfModule mod_php5.c>
  php_flag magic_quotes_gpc Off
  php_flag track_vars ON
  php_flag register_globals ON
  php_value include_path .
</IfModule>
 
</DirectoryMatch>
config.inc.php :
Code :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
 
<?php
 
        /**
         * Central phpPgAdmin configuration.  As a user you may modify the
         * settings here for your particular configuration.
         *
         * $Id: config.inc.php-dist,v 1.44 2005/09/07 08:09:21 chriskl Exp $
         */
 
        // An example server.  CREATE AS many of these AS you wish,
        // indexed FROM zero upwards.
 
        // Display name FOR the server ON the login screen
        $conf['servers'][0]['desc'] = 'PostgreSQL';
 
        // Hostname OR IP address FOR server.  USE '' FOR UNIX domain socket.
        // USE 'localhost' FOR TCP/IP connection ON this computer
        $conf['servers'][0]['host'] = 'localhost';
 
        // DATABASE port ON server (5432 IS the PostgreSQL DEFAULT)
        $conf['servers'][0]['port'] = 5432;
 
    // DATABASE SSL mode
        // Possible options: disable, allow, prefer, require
//      $conf['servers'][0]['sslmode'] = 'allow';
 
        // CHANGE the DEFAULT DATABASE only IF you cannot connect TO template1
        $conf['servers'][0]['defaultdb'] = 'template1';
 
        // Specify the path TO the DATABASE dump utilities FOR this server.
        // You can SET these TO '' IF no dumper IS available.
        $conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump';
        $conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';
 
        // Slony (www.slony.info) support?
        $conf['servers'][0]['slony_support'] = false;
        // Specify the path TO the Slony SQL scripts (WHERE slony1_base.sql IS located, etc.)
        // No TRAILING slash.
        $conf['servers'][0]['slony_sql'] = '/usr/share/postgresql';
 
        // DEFAULT LANGUAGE. Eg: 'english', 'polish', etc.  See lang/ directory
        // FOR ALL possibilities. IF you specify 'auto' (the DEFAULT) it will USE
        // your browser preference.
        $conf['default_lang'] = 'auto';
 
        // IF extra login security IS true, then logins via phpPgAdmin WITH no
        // password OR certain usernames (pgsql, postgres, root, administrator)
        // will be denied. Only SET this false once you have READ the FAQ AND
        // understand how TO CHANGE PostgreSQL's pg_hba.conf to enable
        // passworded local connections.
        $conf['extra_login_security'] = true;
 
        // AutoComplete uses ajaxy interaction to list FK options on insert fields
        // It currently only works on single column foreign keys. You can control
        // it's behavior WITH the following settings.
        // 'default on' enables AutoComplete AND turns it ON BY DEFAULT.
        // 'default off' enables AutoComplete but turns it off BY DEFAULT.
        // 'disable' disables AutoComplete.
        $conf['autocomplete'] = 'default on';
 
        // Only SHOW owned DATABASES?
        // Note: This will simply hide other DATABASES IN the list - this does
        // NOT IN any way prevent your users FROM seeing other DATABASE BY
        // other means. (eg. Run 'SELECT * FROM pg_database' IN the SQL area.)
        $conf['owned_only'] = true;
 
        // Display comments ON objects?  Comments are a good way of documenting
        // a DATABASE, but they do take up space IN the interface.
        $conf['show_comments'] = true;
 
        // Display "advanced" objects?  Setting this TO true will SHOW types,
        // operators conversions, languages AND casts IN phpPgAdmin.  These
        // objects are rarely administered AND can clutter the interface.
        $conf['show_advanced'] = false;
        // Display "system" objects?
        $conf['show_system'] = false;
 
        // Display reports feature?  FOR this feature TO work, you must
        // install the reports DATABASE AS explained IN the INSTALL file.
        $conf['show_reports'] = true;
 
        // Only SHOW owned reports?
        // Note: This does NOT prevent people FROM accessing other reports BY
        // other means.
        $conf['owned_reports_only'] = true;
 
        // Minimum length users can SET their password TO.
        $conf['min_password_length'] = 1;
 
        // Width of the LEFT frame IN pixels (object browser)
        $conf['left_width'] = 200;
 
        // Which look & feel theme TO USE
        $conf['theme'] = 'default';
 
        // SHOW OIDs when browsing TABLES?
        $conf['show_oids'] = false;
 
        // Max rows TO SHOW ON a page when browsing record sets
        $conf['max_rows'] = 30;
 
        // Max chars of each FIELD TO display BY DEFAULT IN browse mode
        $conf['max_chars'] = 50;
 
        // Send XHTML headers?  Unless debugging, it's best to leave this off
        $conf['use_xhtml'] = false;
 
        // Base URL for PostgreSQL documentation.
        // '%s', if present, will be replaced with the PostgreSQL version
        // (7, 7.1, 7.2, 7.3, 7.4, or 8.0)
        $conf['help_base'] = 'http://www.postgresql.org/docs/%s/interactive/';
 
        /*****************************************
         * Don't MODIFY anything below this line *
         *****************************************/
 
        $conf['version'] = 17;
 
?>
J'ai également le message suivant :
Notice: Undefined index: sslmode in /usr/share/phppgadmin/classes/Misc.php on line 1819

Qu'est-ce qui cloche dans ma configuration d'après vous ?

Merci d'avance !

Maryy