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
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
|
<?php
/**
* PHPPgAdmin 6.0.0
*/
use Symfony\Component\Yaml\Yaml;
$conf = [
/**
* Change this parameter ONLY if you mean to serve phpPgAdmin from a subfolder
* e.g for `https://www.server.com/phppga` this parameter should be `/phppga`
* (leading slash, no trailing slash).
*
* If you mean to serve phpPgAdmin6 in the document root (e.g `https://www.server.com`)
* this parameter must be an empty string
*/
'subfolder' => '',
/**
* enable this to calculate schema and table sizes. This will have a performance impact
* e.g. $conf['display_sizes'] = true.
*
* you can also enable it specifically for tables and or schemas:
* $conf['display_sizes'] = ['schemas'=>false,'tables'=>true];
*/
'display_sizes' => false,
/**
* Set to true if you want to enable debugging output.
*/
'debugmode' => false,
/**
* Don't touch this value. It's used to inform the config structure has a breaking change.
*/
'version' => 61,
];
// Two debug library examples. Pick one of course.
$conf['register_debuggers'] = static function (): void {
//require_once __DIR__ . '/.configs/debug.kint.php';
//require_once __DIR__ . '/.configs/debug.var_dumper.php';
};
// optionally, set a path for your error log, relative to this project root
// $conf['error_log']='temp/phppga.php_error.log';
// An example server. Create as many of these as you wish,
// indexed from zero upwards.
$server_index = 0;
/**
* $conf['servers'] is an array that holds (at least) one server block.
*
* @see https://github.com/HuasoFoundries/phpPgAdmin6/wiki/Config:-servers
*/
$conf['servers'][$server_index] = [
// Display name for the server on the login screen
'desc' => 'PostgreSQL',
// Hostname or IP address for server. Use '' for UNIX domain socket.
// use 'localhost' for TCP/IP connection on this computer
'host' => '',
// Database port on server (5432 is the PostgreSQL default)
'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
'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'.
'defaultdb' => 'template1',
// Specify the path to the database dump utilities for this server.
// You can set these to '' if no dumper is available.
'pg_dump_path' => '/usr/bin/pg_dump',
'pg_dumpall_path' => '/usr/bin/pg_dumpall',
];
// Server group 0 will show up with an alias
$conf['srv_groups'][0]['desc'] = 'dev1 and prod2';
// Add here servers indexes belonging to the group '0' seperated by comma
$conf['srv_groups'][0]['servers'] = '1,3';
// Default language. E.g.: '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';
// AutoComplete uses AJAX interaction to list foreign key values
// on insert fields. It currently only works on single column
// foreign keys. You can choose one of the following values:
// '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';
// 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;
// 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. (e.g. Run 'SELECT * FROM pg_database' in the SQL area.)
$conf['owned_only'] = false;
// 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
// aggregates, types, operators, operator classes, 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;
// 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 strict headers?
$conf['use_xhtml_strict'] = false;
// Base URL for PostgreSQL documentation.
// '%s', if present, will be replaced with the PostgreSQL version
// (e.g. 8.4 )
$conf['help_base'] = 'http://www.postgresql.org/docs/%s/interactive/';
// Configuration for ajax scripts
// Time in seconds. If set to 0, refreshing data using ajax will be disabled (locks and activity pages)
$conf['ajax_refresh'] = 3;
// If there's a config.yml in the root folder, parse it and merge its contents with $conf array
// see config.example.yml
$yamlConfigPath = \implode(\DIRECTORY_SEPARATOR, [__DIR__, 'config.yml']);
if (\is_readable($yamlConfigPath) && \class_exists('Symfony\Component\Yaml\Yaml')) {
try {
$yamlConfig = Yaml::parseFile($yamlConfigPath);
// Servers and srv_groups must be merged beforehand
$servers = $conf['servers'] ?? [];
foreach ($yamlConfig['servers'] ?? [] as $index => $srv) {
$servers[] = $srv;
}
$srv_groups = $conf['srv_groups'] ?? [];
foreach ($yamlConfig['srv_groups'] ?? [] as $index => $srv_group) {
$srv_groups[] = $srv;
}
$yamlConfig['srv_groups'] = \array_merge([
$conf['srv_groups'] ?? [],
$yamlConfig['srv_groups'] ?? [],
]);
$conf = \array_merge($conf, $yamlConfig);
$conf['servers'] = $servers ?? [];
$conf['srv_groups'] = $srv_groups ?? [];
} catch (\Exception $e) {
die($e->getMessage());
\error_log($e->getTraceAsString());
}
}
|
