+if ($request->isGet()) {
+ echo('<h2>Environment Checks</h2>');
+
+ // Check if WEB-INF/templates_c dir is writable.
+ if (is_writable(APP_DIR.'/WEB-INF/templates_c/')) {
+ echo('WEB-INF/templates_c/ directory is writable.<br>');
+ } else {
+ echo('<font color="red">Error: WEB-INF/templates_c/ directory is not writable.</font><br>');
+ }
+
+ // Require the configuration file with application settings.
+ if (file_exists(APP_DIR."/WEB-INF/config.php")) {
+ echo('WEB-INF/config.php file exists.<br>');
+
+ // Config file must start with the PHP opening tag. We are checking this because
+ // a Unicode editor may insert a byte order mark (BOM) before it. This is not good as it will
+ // spit white space before output in some situations such as in PDF reports.
+ $file = fopen(APP_DIR.'/WEB-INF/config.php', 'r');
+ $line = fgets($file);
+ if (strcmp('<?php'.PHP_EOL, $line) !== 0) {
+ echo('<font color="red">Error: WEB-INF/config.php file does not start with PHP opening tag.</font><br>');
+ }
+ fclose($file);
+ } else {
+ echo('<font color="red">Error: WEB-INF/config.php file does not exist.</font><br>');
+ }
+
+ // Check whether DSN is defined.
+ if (defined('DSN')) {
+ // echo('DSN is defined as '.DSN.'<br>');
+ echo('DSN is defined.<br>');
+ } else {
+ echo('<font color="red">Error: DSN value is not defined. Check your config.php file.</font><br>');
+ }
+
+ // Check if PHP version is good enough.
+ $required_version = '5.2.1'; // Something in TCPDF library does not work below this one.
+ if (version_compare(phpversion(), $required_version, '>=')) {
+ echo('PHP version: '.phpversion().', good enough.<br>');
+ } else {
+ echo('<font color="red">Error: PHP version is not high enough: '.phpversion().'. Required: '.$required_version.'.</font><br>');
+ }
+
+ // Depending on DSN, require either mysqli or mysql extensions.
+ if (strrpos(DSN, 'mysqli://', -strlen(DSN)) !== FALSE) {
+ if (extension_loaded('mysqli')) {
+ echo('mysqli PHP extension is loaded.<br>');
+ } else {
+ echo('<font color="red">Error: mysqli PHP extension is required but is not loaded.</font><br>');
+ }
+ }
+ if (strrpos(DSN, 'mysql://', -strlen(DSN)) !== FALSE) {
+ if (extension_loaded('mysql')) {
+ echo('mysql PHP extension is loaded.<br>');
+ } else {
+ echo('<font color="red">Error: mysql PHP extension is required but is not loaded.</font><br>');
+ }
+ }
+
+ // Check mbstring extension.
+ if (extension_loaded('mbstring')) {
+ echo('mbstring PHP extension is loaded.<br>');
+ } else {
+ echo('<font color="red">Error: mbstring PHP extension is not loaded.</font><br>');
+ }
+
+ // Check gd extension.
+ if (extension_loaded('gd')) {
+ echo('gd PHP extension is loaded.<br>');
+ } else {
+ echo('<font color="red">Error: gd PHP extension is not loaded. It is required for charts plugin.</font><br>');
+ }
+
+ // Check ldap extension.
+ if (AUTH_MODULE == 'ldap') {
+ if (extension_loaded('ldap_')) {
+ echo('ldap PHP extension is loaded.<br>');
+ } else {
+ echo('<font color="red">Error: ldap PHP extension is not loaded. It is required for LDAP authentication.</font><br>');
+ }
+ }
+
+ // Check database access.
+ require_once('MDB2.php');
+ $conn = MDB2::connect(DSN);
+ if (!is_a($conn, 'MDB2_Error')) {
+ echo('Connection to database successful.<br>');
+ } else {
+ die('<font color="red">Error: connection to database failed. '.$conn->getMessage().'</font><br>');
+ }
+
+ $conn->setOption('debug', true);
+ $conn->setFetchMode(MDB2_FETCHMODE_ASSOC);
+
+ $sql = "show tables";
+ $res = $conn->query($sql);
+ if (is_a($res, 'MDB2_Error')) {
+ die('<font color="red">Error: show tables returned an error. '.$res->getMessage().'</font><br>');
+ }
+ $tblCnt = 0;
+ while ($val = $res->fetchRow()) {
+ $tblCnt++;
+ }
+ if ($tblCnt > 0) {
+ echo("There are $tblCnt tables in database.<br>");
+ } else {
+ echo('<font color="red">There are no tables in database. Execute step 1 - Create database structure.</font><br>');
+ }
+ $conn->disconnect();
+}
+