forked from bbalet/jorani
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathrequirements.php
335 lines (290 loc) · 17.8 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
<?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 href="assets/bootstrap/css/bootstrap.min.css" rel="stylesheet">
<script type="text/javascript" src="assets/js/jquery-2.2.0.min.js"></script>
<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="icon-home"></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="icon-download-alt icon-white"></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="icon-info-sign"></i> Environment</td><td><?php echo $env; ?></td></tr>
<?php } ?>
<tr><td><i class="icon-info-sign"></i> Server software</td><td><?php echo $server_software; ?></td></tr>
<tr><td><?php if (strtolower($allow_overwrite) == "on") {?><i class="icon-ok-sign"></i><?php } else { ?><i class="icon-remove-sign"></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="icon-ok-sign"></i><?php } else { ?><i class="icon-remove-sign"></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="icon-ok-sign"></i><?php } else { ?><i class="icon-remove-sign"></i><?php } ?>
Apache module gzip (mod_gzip)</td><td><?php echo $mod_gzip; ?> Improve response times.</td></tr>
<?php if (version_compare(PHP_VERSION, '5.6.0') >= 0) {?>
<tr><td><i class="icon-ok-sign"></i> PHP 5.6.0+</td>
<?php } else { ?>
<tr><td><i class="icon-remove-sign"></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="icon-info-sign"></i> HHVM</td><td><?php echo HHVM_VERSION; ?></td></tr>
<?php } else { ?>
<tr><td><i class="icon-info-sign"></i> PHP</td><td><?php echo PHP_VERSION; ?></td></tr>
<?php } ?>
<?php if ($tmz != 'UTC') {?>
<tr><td><i class="icon-ok-sign"></i> Timezone defined</td>
<?php } else { ?>
<tr><td><i class="icon-remove-sign"></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="icon-ok-sign"></i> <code>mb_strimwidth</code> function exists</td>
<?php } else { ?>
<tr><td><i class="icon-remove-sign"></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="icon-ok-sign"></i> <code>json_encode</code> function exists</td>
<?php } else { ?>
<tr><td><i class="icon-remove-sign"></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(dirname('application/logs/'))) {?>
<tr><td><i class="icon-ok-sign"></i> Jorani can write into logs folder</td>
<?php } else { ?>
<tr><td><i class="icon-exclamation-sign"></i> Jorani can't write into logs folder</td>
<?php } ?><td>The folder application/logs/ must be writable.</td></tr>
<?php if (is_writable(dirname('local/upload/leaves/'))) {?>
<tr><td><i class="icon-ok-sign"></i> Jorani can write files</td>
<?php } else { ?>
<tr><td><i class="icon-exclamation-sign"></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="icon-ok-sign"></i> pdo_mysql is LOADED</td>
<?php } else { ?>
<tr><td><i class="icon-remove-sign"></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="icon-ok-sign"></i> OPcache is LOADED</td>
<?php } else { ?>
<tr><td><i class="icon-exclamation-sign"></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="icon-ok-sign"></i> openssl is LOADED</td>
<?php } else { ?>
<tr><td><i class="icon-remove-sign"></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="icon-ok-sign"></i> curl is LOADED</td>
<?php } else { ?>
<tr><td><i class="icon-exclamation-sign"></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="icon-ok-sign"></i> ldap is LOADED</td>
<?php } else { ?>
<tr><td><i class="icon-exclamation-sign"></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="icon-ok-sign"></i> zip is LOADED</td>
<?php } else { ?>
<tr><td><i class="icon-exclamation-sign"></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="icon-ok-sign"></i> xml is LOADED</td>
<?php } else { ?>
<tr><td><i class="icon-exclamation-sign"></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="icon-ok-sign"></i> gd is LOADED</td>
<?php } else { ?>
<tr><td><i class="icon-exclamation-sign"></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="icon-ok-sign"></i> Configuration file</td><td>Found</td></tr>
<?php } else { ?><tr><td><i class="icon-remove-sign"></i> Configuration file</td><td>Not Found</td></tr>
<?php } ?>
<?php if (!$dbConnError) { ?><tr><td><i class="icon-ok-sign"></i> Database connection</td><td>OK</td></tr>
<?php } else { ?><tr><td><i class="icon-remove-sign"></i> Database connection</td><td>Error</td></tr>
<?php } ?>
<?php if (!$dbQueryError) { ?><tr><td><i class="icon-ok-sign"></i> Database query</td><td>OK</td></tr>
<?php } else { ?><tr><td><i class="icon-remove-sign"></i> Database query</td><td>Error</td></tr>
<?php } ?>
<?php if (!$dbProcsError) { ?><tr><td><i class="icon-ok-sign"></i> Database procedures</td><td>OK</td></tr>
<?php } else { ?><tr><td><i class="icon-remove-sign"></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="icon-remove-sign"></i> Organization structure</td><td>No root entity was found.</td></tr>
<?php } else { ?>
<?php if ($rowOrg['id'] != 0) { ?><tr><td><i class="icon-remove-sign"></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="icon-ok-sign"></i> Organization structure</td><td>OK</td></tr>
<?php }
}?>
<?php foreach ($dbErrorMessages as $msg) {?>
<tr>
<td><i class="icon-exclamation-sign"></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="icon-info-sign"></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>