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
21/10/2009, 09h34
PhpPgAdmin : erreur lors du chargement servers.php?action=tree
00
