1b7059dccSGreg Roach<?php 23976b470SGreg Roach 3b7059dccSGreg Roach/** 4b7059dccSGreg Roach * webtrees: online genealogy 589f7189bSGreg Roach * Copyright (C) 2021 webtrees development team 6b7059dccSGreg Roach * This program is free software: you can redistribute it and/or modify 7b7059dccSGreg Roach * it under the terms of the GNU General Public License as published by 8b7059dccSGreg Roach * the Free Software Foundation, either version 3 of the License, or 9b7059dccSGreg Roach * (at your option) any later version. 10b7059dccSGreg Roach * This program is distributed in the hope that it will be useful, 11b7059dccSGreg Roach * but WITHOUT ANY WARRANTY; without even the implied warranty of 12b7059dccSGreg Roach * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13b7059dccSGreg Roach * GNU General Public License for more details. 14b7059dccSGreg Roach * You should have received a copy of the GNU General Public License 1589f7189bSGreg Roach * along with this program. If not, see <https://www.gnu.org/licenses/>. 16b7059dccSGreg Roach */ 17fcfa147eSGreg Roach 18b7059dccSGreg Roachdeclare(strict_types=1); 19b7059dccSGreg Roach 20b7059dccSGreg Roachnamespace Fisharebest\Webtrees\Services; 21b7059dccSGreg Roach 22b7059dccSGreg Roachuse Fisharebest\Webtrees\I18N; 23b7059dccSGreg Roachuse Illuminate\Support\Collection; 24b7059dccSGreg Roachuse SQLite3; 253976b470SGreg Roach 26b7059dccSGreg Roachuse function array_map; 27b33d97e2SGreg Roachuse function class_exists; 28b33d97e2SGreg Roachuse function date; 29b33d97e2SGreg Roachuse function e; 30b7059dccSGreg Roachuse function explode; 31b7059dccSGreg Roachuse function extension_loaded; 32b33d97e2SGreg Roachuse function function_exists; 33b7059dccSGreg Roachuse function in_array; 34dec352c1SGreg Roachuse function str_ends_with; 35dec352c1SGreg Roachuse function str_starts_with; 367bb10f9aSGreg Roachuse function strtolower; 37b7059dccSGreg Roachuse function sys_get_temp_dir; 38b7059dccSGreg Roachuse function trim; 39b7059dccSGreg Roachuse function version_compare; 403976b470SGreg Roach 41b7059dccSGreg Roachuse const PATH_SEPARATOR; 42b7059dccSGreg Roachuse const PHP_MAJOR_VERSION; 43b7059dccSGreg Roachuse const PHP_MINOR_VERSION; 44b33d97e2SGreg Roachuse const PHP_VERSION; 45b7059dccSGreg Roach 46b7059dccSGreg Roach/** 47b7059dccSGreg Roach * Check if the server meets the minimum requirements for webtrees. 48b7059dccSGreg Roach */ 49b7059dccSGreg Roachclass ServerCheckService 50b7059dccSGreg Roach{ 512ddcca20SGreg Roach private const PHP_SUPPORT_URL = 'https://www.php.net/supported-versions.php'; 52bb5a472eSGreg Roach private const PHP_MINOR_VERSION = PHP_MAJOR_VERSION . '.' . PHP_MINOR_VERSION; 53bb5a472eSGreg Roach private const PHP_SUPPORT_DATES = [ 54b7059dccSGreg Roach '7.3' => '2021-12-06', 552ddcca20SGreg Roach '7.4' => '2022-11-28', 56f32d77e6SGreg Roach '8.0' => '2023-11-26', 57b7059dccSGreg Roach ]; 58b7059dccSGreg Roach 59b7059dccSGreg Roach // As required by illuminate/database 5.8 60b7059dccSGreg Roach private const MINIMUM_SQLITE_VERSION = '3.7.11'; 61b7059dccSGreg Roach 62b7059dccSGreg Roach /** 63b7059dccSGreg Roach * Things that may cause webtrees to break. 64b7059dccSGreg Roach * 65b7059dccSGreg Roach * @param string $driver 66b7059dccSGreg Roach * 67b5c8fd7eSGreg Roach * @return Collection<string> 68b7059dccSGreg Roach */ 6973d58381SGreg Roach public function serverErrors(string $driver = ''): Collection 70b7059dccSGreg Roach { 71b7059dccSGreg Roach $errors = Collection::make([ 72b7059dccSGreg Roach $this->databaseDriverErrors($driver), 73b7059dccSGreg Roach $this->checkPhpExtension('mbstring'), 74b7059dccSGreg Roach $this->checkPhpExtension('iconv'), 75b7059dccSGreg Roach $this->checkPhpExtension('pcre'), 76b7059dccSGreg Roach $this->checkPhpExtension('session'), 77b7059dccSGreg Roach $this->checkPhpExtension('xml'), 78b7059dccSGreg Roach $this->checkPhpFunction('parse_ini_file'), 79b7059dccSGreg Roach ]); 80b7059dccSGreg Roach 81b7059dccSGreg Roach return $errors 82b7059dccSGreg Roach ->flatten() 83b7059dccSGreg Roach ->filter(); 84b7059dccSGreg Roach } 85b7059dccSGreg Roach 86b7059dccSGreg Roach /** 87b7059dccSGreg Roach * Things that should be fixed, but which won't stop completely webtrees from running. 88b7059dccSGreg Roach * 89b7059dccSGreg Roach * @param string $driver 90b7059dccSGreg Roach * 91b5c8fd7eSGreg Roach * @return Collection<string> 92b7059dccSGreg Roach */ 9373d58381SGreg Roach public function serverWarnings(string $driver = ''): Collection 94b7059dccSGreg Roach { 95b7059dccSGreg Roach $warnings = Collection::make([ 96b7059dccSGreg Roach $this->databaseDriverWarnings($driver), 97b7059dccSGreg Roach $this->checkPhpExtension('curl'), 98565f3f17SGreg Roach $this->checkPhpExtension('exif'), 99c95eb19bSGreg Roach $this->checkPhpExtension('fileinfo'), 100b7059dccSGreg Roach $this->checkPhpExtension('gd'), 101f7440925SGreg Roach $this->checkPhpExtension('intl'), 10223c3b21dSGreg Roach $this->checkPhpExtension('zip'), 103b7059dccSGreg Roach $this->checkPhpExtension('simplexml'), 104b7059dccSGreg Roach $this->checkPhpIni('file_uploads', true), 105b7059dccSGreg Roach $this->checkSystemTemporaryFolder(), 106b7059dccSGreg Roach $this->checkPhpVersion(), 107b7059dccSGreg Roach ]); 108b7059dccSGreg Roach 109b7059dccSGreg Roach return $warnings 110b7059dccSGreg Roach ->flatten() 111b7059dccSGreg Roach ->filter(); 112b7059dccSGreg Roach } 113b7059dccSGreg Roach 114b7059dccSGreg Roach /** 115b7059dccSGreg Roach * Check if a PHP extension is loaded. 116b7059dccSGreg Roach * 117b7059dccSGreg Roach * @param string $extension 118b7059dccSGreg Roach * 119b7059dccSGreg Roach * @return string 120b7059dccSGreg Roach */ 121b7059dccSGreg Roach private function checkPhpExtension(string $extension): string 122b7059dccSGreg Roach { 123b7059dccSGreg Roach if (!extension_loaded($extension)) { 124b7059dccSGreg Roach return I18N::translate('The PHP extension “%s” is not installed.', $extension); 125b7059dccSGreg Roach } 126b7059dccSGreg Roach 127b7059dccSGreg Roach return ''; 128b7059dccSGreg Roach } 129b7059dccSGreg Roach 130b7059dccSGreg Roach /** 131b7059dccSGreg Roach * Check if a PHP setting is correct. 132b7059dccSGreg Roach * 133b7059dccSGreg Roach * @param string $varname 134b7059dccSGreg Roach * @param bool $expected 135b7059dccSGreg Roach * 136b7059dccSGreg Roach * @return string 137b7059dccSGreg Roach */ 138b7059dccSGreg Roach private function checkPhpIni(string $varname, bool $expected): string 139b7059dccSGreg Roach { 140b7059dccSGreg Roach $ini_get = (bool) ini_get($varname); 141b7059dccSGreg Roach 142b7059dccSGreg Roach if ($expected && $ini_get !== $expected) { 143b7059dccSGreg Roach return I18N::translate('The PHP.INI setting “%1$s” is disabled.', $varname); 144b7059dccSGreg Roach } 145b7059dccSGreg Roach 146b7059dccSGreg Roach if (!$expected && $ini_get !== $expected) { 147b7059dccSGreg Roach return I18N::translate('The PHP.INI setting “%1$s” is enabled.', $varname); 148b7059dccSGreg Roach } 149b7059dccSGreg Roach 150b7059dccSGreg Roach return ''; 151b7059dccSGreg Roach } 152b7059dccSGreg Roach 153b7059dccSGreg Roach /** 1547bb10f9aSGreg Roach * Check if a PHP function is in the list of disabled functions. 1557bb10f9aSGreg Roach * 1567bb10f9aSGreg Roach * @param string $function 1577bb10f9aSGreg Roach * 1587d99559cSGreg Roach * @return bool 1597bb10f9aSGreg Roach */ 1607bb10f9aSGreg Roach public function isFunctionDisabled(string $function): bool 1617bb10f9aSGreg Roach { 1627bb10f9aSGreg Roach $function = strtolower($function); 1637bb10f9aSGreg Roach 164*d8809d62SGreg Roach $disable_functions = explode(',', (string) ini_get('disable_functions')); 165*d8809d62SGreg Roach $disable_functions = array_map(static fn(string $func): string => strtolower(trim($func)), $disable_functions); 166*d8809d62SGreg Roach 1677bb10f9aSGreg Roach return in_array($function, $disable_functions, true) || !function_exists($function); 1687bb10f9aSGreg Roach } 1697bb10f9aSGreg Roach 1707bb10f9aSGreg Roach /** 1717bb10f9aSGreg Roach * Create a warning message for a disabled function. 172b7059dccSGreg Roach * 173b7059dccSGreg Roach * @param string $function 174b7059dccSGreg Roach * 175b7059dccSGreg Roach * @return string 176b7059dccSGreg Roach */ 177b7059dccSGreg Roach private function checkPhpFunction(string $function): string 178b7059dccSGreg Roach { 1797bb10f9aSGreg Roach if ($this->isFunctionDisabled($function)) { 180acf70b2aSGreg Roach return I18N::translate('The PHP function “%1$s” is disabled.', $function . '()'); 181b7059dccSGreg Roach } 182b7059dccSGreg Roach 183b7059dccSGreg Roach return ''; 184b7059dccSGreg Roach } 185b7059dccSGreg Roach 186b7059dccSGreg Roach /** 187fceda430SGreg Roach * Some servers configure their temporary folder in an inaccessible place. 188b7059dccSGreg Roach */ 189b7059dccSGreg Roach private function checkPhpVersion(): string 190b7059dccSGreg Roach { 191b7059dccSGreg Roach $today = date('Y-m-d'); 192b7059dccSGreg Roach 193b7059dccSGreg Roach foreach (self::PHP_SUPPORT_DATES as $version => $end_date) { 194497c5612SGreg Roach if ($today > $end_date && version_compare(self::PHP_MINOR_VERSION, $version) <= 0) { 195b7059dccSGreg Roach return I18N::translate('Your web server is using PHP version %s, which is no longer receiving security updates. You should upgrade to a later version as soon as possible.', PHP_VERSION) . ' <a href="' . e(self::PHP_SUPPORT_URL) . '">' . e(self::PHP_SUPPORT_URL) . '</a>'; 196b7059dccSGreg Roach } 197b7059dccSGreg Roach } 198b7059dccSGreg Roach 199b7059dccSGreg Roach return ''; 200b7059dccSGreg Roach } 201b7059dccSGreg Roach 202b7059dccSGreg Roach /** 203b7059dccSGreg Roach * Check the 204b7059dccSGreg Roach * 205b7059dccSGreg Roach * @return string 206b7059dccSGreg Roach */ 207b7059dccSGreg Roach private function checkSqliteVersion(): string 208b7059dccSGreg Roach { 209b7059dccSGreg Roach if (class_exists(SQLite3::class)) { 210b7059dccSGreg Roach $sqlite_version = SQLite3::version()['versionString']; 211b7059dccSGreg Roach 212b7059dccSGreg Roach if (version_compare($sqlite_version, self::MINIMUM_SQLITE_VERSION) < 0) { 213b7059dccSGreg Roach return I18N::translate('SQLite version %s is installed. SQLite version %s or later is required.', $sqlite_version, self::MINIMUM_SQLITE_VERSION); 214b7059dccSGreg Roach } 215b7059dccSGreg Roach } 216b7059dccSGreg Roach 217b7059dccSGreg Roach return ''; 218b7059dccSGreg Roach } 219b7059dccSGreg Roach 220b7059dccSGreg Roach /** 221fceda430SGreg Roach * Some servers configure their temporary folder in an inaccessible place. 222b7059dccSGreg Roach */ 223b7059dccSGreg Roach private function checkSystemTemporaryFolder(): string 224b7059dccSGreg Roach { 225b7059dccSGreg Roach $open_basedir = ini_get('open_basedir'); 226b7059dccSGreg Roach 227b33d97e2SGreg Roach if ($open_basedir === '') { 228b33d97e2SGreg Roach // open_basedir not used. 229b7059dccSGreg Roach return ''; 230b7059dccSGreg Roach } 231b7059dccSGreg Roach 232b33d97e2SGreg Roach $open_basedirs = explode(PATH_SEPARATOR, $open_basedir); 233b33d97e2SGreg Roach 234b33d97e2SGreg Roach $sys_temp_dir = sys_get_temp_dir(); 235b33d97e2SGreg Roach $sys_temp_dir = $this->normalizeFolder($sys_temp_dir); 236b33d97e2SGreg Roach 237b33d97e2SGreg Roach foreach ($open_basedirs as $dir) { 238b33d97e2SGreg Roach $dir = $this->normalizeFolder($dir); 239b33d97e2SGreg Roach 240dec352c1SGreg Roach if (str_starts_with($sys_temp_dir, $dir)) { 241b33d97e2SGreg Roach return ''; 242b33d97e2SGreg Roach } 243b33d97e2SGreg Roach } 244b33d97e2SGreg Roach 245b7059dccSGreg Roach $message = I18N::translate('The server’s temporary folder cannot be accessed.'); 246b7059dccSGreg Roach $message .= '<br>sys_get_temp_dir() = "' . e($sys_temp_dir) . '"'; 247b7059dccSGreg Roach $message .= '<br>ini_get("open_basedir") = "' . e($open_basedir) . '"'; 248b7059dccSGreg Roach 249b7059dccSGreg Roach return $message; 250b7059dccSGreg Roach } 251b7059dccSGreg Roach 252b7059dccSGreg Roach /** 253b33d97e2SGreg Roach * Convert a folder name to a canonical form: 254b33d97e2SGreg Roach * - forward slashes. 255b33d97e2SGreg Roach * - trailing slash. 256b33d97e2SGreg Roach * We can't use realpath() as this can trigger open_basedir restrictions, 257b33d97e2SGreg Roach * and we are using this code to find out whether open_basedir will affect us. 258b33d97e2SGreg Roach * 259b33d97e2SGreg Roach * @param string $path 260b33d97e2SGreg Roach * 261b33d97e2SGreg Roach * @return string 262b33d97e2SGreg Roach */ 263b33d97e2SGreg Roach private function normalizeFolder(string $path): string 264b33d97e2SGreg Roach { 265dec352c1SGreg Roach $path = strtr($path, ['\\' => '/']); 266b33d97e2SGreg Roach 267dec352c1SGreg Roach if (str_ends_with($path, '/')) { 268b33d97e2SGreg Roach return $path; 269b33d97e2SGreg Roach } 270b33d97e2SGreg Roach 271dec352c1SGreg Roach return $path . '/'; 272dec352c1SGreg Roach } 273dec352c1SGreg Roach 274b33d97e2SGreg Roach /** 275b7059dccSGreg Roach * @param string $driver 276b7059dccSGreg Roach * 277b5c8fd7eSGreg Roach * @return Collection<string> 278b7059dccSGreg Roach */ 279b7059dccSGreg Roach private function databaseDriverErrors(string $driver): Collection 280b7059dccSGreg Roach { 281b7059dccSGreg Roach switch ($driver) { 282b7059dccSGreg Roach case 'mysql': 283b7059dccSGreg Roach return Collection::make([ 284b7059dccSGreg Roach $this->checkPhpExtension('pdo'), 285b7059dccSGreg Roach $this->checkPhpExtension('pdo_mysql'), 286b7059dccSGreg Roach ]); 287b7059dccSGreg Roach 288b7059dccSGreg Roach case 'sqlite': 289b7059dccSGreg Roach return Collection::make([ 290b7059dccSGreg Roach $this->checkPhpExtension('pdo'), 291b7059dccSGreg Roach $this->checkPhpExtension('sqlite3'), 292b7059dccSGreg Roach $this->checkPhpExtension('pdo_sqlite'), 293b7059dccSGreg Roach $this->checkSqliteVersion(), 294b7059dccSGreg Roach ]); 295b7059dccSGreg Roach 296b7059dccSGreg Roach case 'pgsql': 297b7059dccSGreg Roach return Collection::make([ 298b7059dccSGreg Roach $this->checkPhpExtension('pdo'), 299b7059dccSGreg Roach $this->checkPhpExtension('pdo_pgsql'), 300b7059dccSGreg Roach ]); 301b7059dccSGreg Roach 302b7059dccSGreg Roach case 'sqlsvr': 303b7059dccSGreg Roach return Collection::make([ 304b7059dccSGreg Roach $this->checkPhpExtension('pdo'), 305b7059dccSGreg Roach $this->checkPhpExtension('pdo_odbc'), 306b7059dccSGreg Roach ]); 307b7059dccSGreg Roach 308b7059dccSGreg Roach default: 309b7059dccSGreg Roach return new Collection(); 310b7059dccSGreg Roach } 311b7059dccSGreg Roach } 312b7059dccSGreg Roach 313b7059dccSGreg Roach /** 314b7059dccSGreg Roach * @param string $driver 315b7059dccSGreg Roach * 316b5c8fd7eSGreg Roach * @return Collection<string> 317b7059dccSGreg Roach */ 318b7059dccSGreg Roach private function databaseDriverWarnings(string $driver): Collection 319b7059dccSGreg Roach { 320b7059dccSGreg Roach switch ($driver) { 321b7059dccSGreg Roach case 'sqlite': 322b7059dccSGreg Roach return new Collection([ 323b7059dccSGreg Roach I18N::translate('SQLite is only suitable for small sites, testing and evaluation.'), 324b7059dccSGreg Roach ]); 325b7059dccSGreg Roach 326b7059dccSGreg Roach case 'pgsql': 327b7059dccSGreg Roach return new Collection([ 328b7059dccSGreg Roach I18N::translate('Support for PostgreSQL is experimental.'), 329b7059dccSGreg Roach ]); 330b7059dccSGreg Roach 331b7059dccSGreg Roach case 'sqlsvr': 332b7059dccSGreg Roach return new Collection([ 333b7059dccSGreg Roach I18N::translate('Support for SQL Server is experimental.'), 334b7059dccSGreg Roach ]); 335b7059dccSGreg Roach 336b7059dccSGreg Roach default: 337b7059dccSGreg Roach return new Collection(); 338b7059dccSGreg Roach } 339b7059dccSGreg Roach } 340b7059dccSGreg Roach} 341