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 : Sélectionner tout - Visualiser dans une fenêtre à part
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 : Sélectionner tout - Visualiser dans une fenêtre à part
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