forked from bbalet/jorani
-
Notifications
You must be signed in to change notification settings - Fork 0
/
requirements.php
342 lines (296 loc) · 17.5 KB
/
requirements.php
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
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
<?php
/**
* This diagnostic page helps you to check your setup.
* @copyright Copyright (c) 2014-2018 Benjamin BALET
* @license http://opensource.org/licenses/AGPL-3.0 AGPL-3.0
* @link https://github.com/bbalet/jorani
* @since 0.3.0
*/
define('BASEPATH','.');//Make this script works with nginx
define('ENVIRONMENT','');//Compatibility with CI3 new index
$mod_rewrite = getenv('HTTP_MOD_REWRITE');
if (function_exists('apache_get_modules')) {
$modules = apache_get_modules();
$mod_rewrite = in_array('mod_rewrite', $modules)?TRUE:FALSE;
} else {
$mod_rewrite = strtolower(getenv('HTTP_MOD_REWRITE')) == 'on'?TRUE:FALSE;
}
$env = is_null(getenv('CI_ENV'))?'':getenv('CI_ENV');
$allow_overwrite = getenv('ALLOW_OVERWRITE');
$server_software = getenv('SERVER_SOFTWARE');
$mod_gzip = getenv('HTTP_MOD_GZIP');
$rowOrg = NULL;
if ($mod_rewrite == "") $mod_rewrite = '<b>.htaccess not visited</b>';
if ($allow_overwrite == "") $allow_overwrite = '<b>Off</b>';
$tmz = @date_default_timezone_get();
//Check if we can access to the configuration file
$pathConfigFile = realpath(join(DIRECTORY_SEPARATOR, array('application', 'config', $env, 'database.php')));
$configFileExists = file_exists($pathConfigFile);
$dbErrorMessages = array();
$dbConn = NULL;
$rowsSchema = NULL;
$dbConnError = FALSE;
$dbQueryError = FALSE;
$dbDbError = FALSE;
$dbProcsError = FALSE;
if ($configFileExists) {
include $pathConfigFile;
//Try to connect to database
try {
$dbConn = new PDO($db[$active_group]['dsn'], $db[$active_group]['username'], $db[$active_group]['password']);
} catch(PDOException $ex) {
$dbConnError = TRUE;
array_push($dbErrorMessages, $ex->getMessage());
}
if (!$dbConnError) {
//Examine organization structure
try {
$resultOrg = $dbConn->query("SELECT id FROM organization WHERE parent_id=-1");
} catch(PDOException $ex) {
$dbQueryError = TRUE;
array_push($dbErrorMessages, $ex->getMessage());
}
if (!$dbQueryError) {
$rowOrg = $resultOrg->fetch(PDO::FETCH_ASSOC);
//Try to use a procedure in order to check the install script
//We don't know if the user has access to information schema
//So we try to call one of the procedures with a parameter returning a small set of results
try {
$dbConn->query("SELECT GetParentIDByID(0) AS result");
} catch(PDOException $ex) {
$dbProcsError = TRUE;
array_push($dbErrorMessages, $ex->getMessage());
}
$sql = "SELECT TABLE_NAME, MD5(GROUP_CONCAT(CONCAT(TABLE_NAME, COLUMN_NAME, COALESCE(COLUMN_DEFAULT, ''), IS_NULLABLE, COLUMN_TYPE, COALESCE(COLLATION_NAME, '')) SEPARATOR ', ')) AS signature"
. " FROM information_schema.columns"
. " WHERE table_schema = DATABASE()"
. " GROUP BY TABLE_NAME"
. " ORDER BY TABLE_NAME";
try {
$stmt = $dbConn->query($sql);
} catch(PDOException $ex) {
$dbQueryError = TRUE;
array_push($dbErrorMessages, $ex->getMessage());
}
$rowsSchema = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
}
}
?>
<html>
<head>
<title>Jorani Requirements</title>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<meta charset="UTF-8">
<link rel="icon" type="image/x-icon" href="favicon.ico" sizes="32x32">
<link rel="stylesheet" href="assets/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="assets/MDI-2.1.19/css/materialdesignicons.min.css">
<script type="text/javascript" src="assets/js/jquery-2.2.4.min.js"></script>
<style>
.nolink {
color: black;
}
</style>
<script type="text/javascript">
function export2csv() {
var content = "";
content += "Table;Description;Value\n";
$("#tblServer tr").each(function() {
$this = $(this)
content += "Server;" + $.trim($(this).find("td:eq(0)").text())
+ ";" + $(this).find("td:eq(1)").text() + "\n";
});
$("#tblDatabase tr").each(function() {
$this = $(this)
content += "Database;" + $.trim($(this).find("td:eq(0)").text())
+ ";" + $(this).find("td:eq(1)").text() + "\n";
});
$("#tblSchema tr").each(function() {
$this = $(this)
content += "Schema;" + $.trim($(this).find("td:eq(0)").text())
+ ";" + $(this).find("td:eq(1)").text() + "\n";
});
// Build a data URI:
uri = "data:text/csv;charset=utf-8," + encodeURIComponent(content);
location.href = uri;
}
</script>
</head>
<body>
<div class="container-fluid">
<ul class="nav nav-pills">
<li><a href="home" title="login to Jorani"><i class="mdi mdi-home nolink"></i></a></li>
<li class="active"><a href="#">Requirements</a></li>
<li><a href="testmail.php">Email</a></li>
<li><a href="testldap.php">LDAP</a></li>
<li><a href="testssl.php">SSL</a></li>
<li><a href="testoauth2.php">OAuth2</a></li>
<li><a href="opcache.php">Opcache</a></li>
</ul>
<h1>Jorani Requirements</h1>
<noscript>
Javascript is disabled. Jorani requires Javascript to be enabled.
</noscript>
<button class="btn btn-primary" onclick="export2csv();"><i class="mdi mdi-download"></i> Export to a CSV file</button>
<h2>Web Server</h2>
<table class="table table-bordered table-hover table-condensed">
<thead>
<tr>
<th>Requirement</th>
<th>Value / Description</th>
</tr>
</thead>
<tbody id="tblServer">
<?php if ($env != '') {?>
<tr><td><i class="mdi mdi-information-outline"></i> Environment</td><td><?php echo $env; ?></td></tr>
<?php } ?>
<tr><td><i class="mdi mdi-information-outline"></i> Server software</td><td><?php echo $server_software; ?></td></tr>
<tr><td><?php if (strtolower($allow_overwrite) == "on") {?><i class="mdi mdi-check"></i><?php } else { ?><i class="mdi mdi-alert"></i><?php } ?>
Allow overwrite (.htaccess files)</td><td><?php echo $allow_overwrite; ?> (used for cool URLs). Ignore this message if you are running something else than Apache.</td></tr>
<tr><td><?php if ($mod_rewrite) {?><i class="mdi mdi-check"></i><?php } else { ?><i class="mdi mdi-alert"></i><?php } ?>
Apache module rewrite (mod_rewrite)</td><td><?php echo $mod_rewrite; ?> (used for cool URLs). Ignore this message if you are running something else than Apache.</td></tr>
<tr><td><?php if (strtolower($mod_gzip) == "on") {?><i class="mdi mdi-check"></i><?php } else { ?><i class="mdi mdi-alert"></i><?php } ?>
Apache module gzip (mod_gzip)</td><td><?php echo $mod_gzip; ?> (turning it On would improve response times).</td></tr>
<?php if (version_compare(PHP_VERSION, '5.6.0') >= 0) {?>
<tr><td><i class="mdi mdi-check"></i> PHP 5.6.0+</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> Old PHP version</td>
<?php } ?><td>Ignore this message if you are running an exotic PHP runtime</td></tr>
<?php if (defined('HHVM_VERSION')) {?>
<tr><td><i class="mdi mdi-information-outline"></i> HHVM</td><td><?php echo HHVM_VERSION; ?></td></tr>
<?php } else { ?>
<tr><td><i class="mdi mdi-information-outline"></i> PHP</td><td><?php echo PHP_VERSION; ?></td></tr>
<?php } ?>
<?php if ($tmz != 'UTC') {?>
<tr><td><i class="mdi mdi-check"></i> Timezone defined</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> Timezone undefined</td>
<?php } ?><td>If error, please check date.timezone into PHP.ini.</td></tr>
<?php if (function_exists('mb_strimwidth')) {?>
<tr><td><i class="mdi mdi-check"></i> <code>mb_strimwidth</code> function exists</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> <code>mb_strimwidth</code> function doesn't exist</td>
<?php } ?><td>PHP must be compiled with <a href="http://php.net/manual/en/mbstring.installation.php" target="_blank">multibyte string support<a>.</td></tr>
<?php if (function_exists('json_encode')) {?>
<tr><td><i class="mdi mdi-check"></i> <code>json_encode</code> function exists</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> <code>json_encode</code> function doesn't exist</td>
<?php } ?><td>PHP must be compiled with <a href="http://php.net/manual/en/json.installation.php" target="_blank">json support<a>.</td></tr>
<?php if (is_writable(realpath('application/logs/'))) {?>
<tr><td><i class="mdi mdi-check"></i> Jorani can write into logs folder</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> Jorani can't write into logs folder</td>
<?php } ?><td>The folder application/logs/ must be writable.</td></tr>
<?php if (is_writable(realpath('local/upload/leaves/'))) {?>
<tr><td><i class="mdi mdi-check"></i> Jorani can write files</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> Jorani can't write files</td>
<?php } ?><td>The folder local/upload/leaves/ must be writable.</td></tr>
<?php if (extension_loaded('pdo_mysql')) {?>
<tr><td><i class="mdi mdi-check"></i> pdo_mysql is LOADED</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> PDO/mysql IS NOT LOADED.</td>
<?php } ?><td>PDO/mysql is the recommended database driver.</td></tr>
<?php if (extension_loaded('Zend OPcache')) {?>
<tr><td><i class="mdi mdi-check"></i> OPcache is LOADED</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> OPcache IS NOT LOADED.</td>
<?php } ?><td>Please consider activating OPcache for the best performances.</td></tr>
<?php if (extension_loaded('openssl')) {?>
<tr><td><i class="mdi mdi-check"></i> openssl is LOADED</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> openssl IS NOT LOADED.</td>
<?php } ?><td>PHP Extension openssl is required if you use PHP7.1.</td></tr>
<?php if (extension_loaded('curl')) {?>
<tr><td><i class="mdi mdi-check"></i> curl is LOADED</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> curl IS NOT LOADED.</td>
<?php } ?><td>PHP Extension curl is needed for OAuth2 authentication.</td></tr>
<?php if (extension_loaded('ldap')) {?>
<tr><td><i class="mdi mdi-check"></i> ldap is LOADED</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> ldap IS NOT LOADED</td>
<?php } ?><td>PHP Extension ldap is optional and allows you to use LDAP for authentication.</td></tr>
<?php if (extension_loaded('zip')) {?>
<tr><td><i class="mdi mdi-check"></i> zip is LOADED</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> zip IS NOT LOADED</td>
<?php } ?><td>PHP Extension zip allows you to use the export to Excel feature.</td></tr>
<?php if (extension_loaded('xml')) {?>
<tr><td><i class="mdi mdi-check"></i> xml is LOADED</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> xml IS NOT LOADED</td>
<?php } ?><td>PHP Extension xml allows you to use the export to Excel feature.</td></tr>
<?php if (extension_loaded('gd')) {?>
<tr><td><i class="mdi mdi-check"></i> gd is LOADED</td>
<?php } else { ?>
<tr><td><i class="mdi mdi-alert"></i> gd IS NOT LOADED</td>
<?php } ?><td>PHP Extension gd2 allows you to use the export to Excel feature.</td></tr>
</tbody>
</table>
<h2>Additional configuration</h2>
<p>You can test the following settings, but you need to edit the corresponding PHP scripts :</p>
<ul>
<li><a href="testssl.php" target="_blank">SSL Configuration and Utility.</a></li>
<li><a href="testoauth2.php" target="_blank">OAuth2 Settings.</a></li>
<li><a href="testmail.php" target="_blank">E-mail Settings.</a></li>
<li><a href="testldap.php" target="_blank">LDAP Settings.</a></li>
<li><a href="opcache.php" target="_blank">OPCache Tester.</a></li>
</ul>
<h2>Database</h2>
<table class="table table-bordered table-hover table-condensed">
<thead>
<tr>
<th>Requirement</th>
<th>Value / Description</th>
</tr>
</thead>
<tbody id="tblDatabase">
<?php if ($configFileExists) { ?><tr><td><i class="mdi mdi-check"></i> Configuration file</td><td>Found</td></tr>
<?php } else { ?><tr><td><i class="mdi mdi-alert"></i> Configuration file</td><td>Not Found</td></tr>
<?php } ?>
<?php if (!$dbConnError) { ?><tr><td><i class="mdi mdi-check"></i> Database connection</td><td>OK</td></tr>
<?php } else { ?><tr><td><i class="mdi mdi-alert"></i> Database connection</td><td>Error</td></tr>
<?php } ?>
<?php if (!$dbQueryError) { ?><tr><td><i class="mdi mdi-check"></i> Database query</td><td>OK</td></tr>
<?php } else { ?><tr><td><i class="mdi mdi-alert"></i> Database query</td><td>Error</td></tr>
<?php } ?>
<?php if (!$dbProcsError) { ?><tr><td><i class="mdi mdi-check"></i> Database procedures</td><td>OK</td></tr>
<?php } else { ?><tr><td><i class="mdi mdi-alert"></i> Database procedures</td><td>Error. Please check if your hosting company allows custom procedures (e.g. <a href="https://techtavern.wordpress.com/2013/06/17/mysql-triggers-and-amazon-rds/" target="_blank">Amazon RDS</a>).</td></tr>
<?php } ?>
<?php if (is_null($rowOrg)) { ?><tr><td><i class="mdi mdi-alert"></i> Organization structure</td><td>No root entity was found.</td></tr>
<?php } else { ?>
<?php if ($rowOrg['id'] != 0) { ?><tr><td><i class="mdi mdi-alert"></i> Organization structure</td><td>The root entity must be equal to zero. To fix a problem of backup/restore, please execute this query: <br />
<code>UPDATE `organization` SET `organization`.`id` = 0 WHERE `parent_id` = -1</code></td></tr>
<?php } else { ?><tr><td><i class="mdi mdi-check"></i> Organization structure</td><td>OK</td></tr>
<?php }
}?>
<?php foreach ($dbErrorMessages as $msg) {?>
<tr>
<td><i class="mdi mdi-alert"></i> Error</td>
<td><?php echo $msg; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
<h2>Schema</h2>
<table class="table table-bordered table-hover table-condensed">
<thead>
<tr>
<th>Table</th>
<th>Signature</th>
</tr>
</thead>
<tbody id="tblSchema">
<?php if (!$dbConnError && !$dbQueryError) {
foreach ($rowsSchema as $row) { ?>
<tr><td><i class="mdi mdi-information-outline"></i> <?php echo $row['TABLE_NAME']; ?></td><td><?php echo $row['signature']; ?></td></tr>
<?php }
} else { ?>
<tr><td colspan="2"><i>Impossible to query database</i></td></tr>
<?php } ?>
</tbody>
</table>
</div>
</body>
</html>