1430ed1cbSGreg Roach<?php 2430ed1cbSGreg Roach 3430ed1cbSGreg Roach/** 4430ed1cbSGreg Roach * webtrees: online genealogy 5d11be702SGreg Roach * Copyright (C) 2023 webtrees development team 6430ed1cbSGreg Roach * This program is free software: you can redistribute it and/or modify 7430ed1cbSGreg Roach * it under the terms of the GNU General Public License as published by 8430ed1cbSGreg Roach * the Free Software Foundation, either version 3 of the License, or 9430ed1cbSGreg Roach * (at your option) any later version. 10430ed1cbSGreg Roach * This program is distributed in the hope that it will be useful, 11430ed1cbSGreg Roach * but WITHOUT ANY WARRANTY; without even the implied warranty of 12430ed1cbSGreg Roach * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13430ed1cbSGreg Roach * GNU General Public License for more details. 14430ed1cbSGreg 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/>. 16430ed1cbSGreg Roach */ 17430ed1cbSGreg Roach 18430ed1cbSGreg Roachdeclare(strict_types=1); 19430ed1cbSGreg Roach 20430ed1cbSGreg Roachnamespace Fisharebest\Webtrees\Http\RequestHandlers; 21430ed1cbSGreg Roach 22430ed1cbSGreg Roachuse Exception; 23430ed1cbSGreg Roachuse Fisharebest\Localization\Locale; 24430ed1cbSGreg Roachuse Fisharebest\Localization\Locale\LocaleEnUs; 25430ed1cbSGreg Roachuse Fisharebest\Localization\Locale\LocaleInterface; 26430ed1cbSGreg Roachuse Fisharebest\Webtrees\Auth; 271fe542e9SGreg Roachuse Fisharebest\Webtrees\Contracts\UserInterface; 28*6f4ec3caSGreg Roachuse Fisharebest\Webtrees\DB; 2955037a57SGreg Roachuse Fisharebest\Webtrees\Factories\CacheFactory; 30430ed1cbSGreg Roachuse Fisharebest\Webtrees\Http\ViewResponseTrait; 31430ed1cbSGreg Roachuse Fisharebest\Webtrees\I18N; 32430ed1cbSGreg Roachuse Fisharebest\Webtrees\Module\ModuleLanguageInterface; 336b9cb339SGreg Roachuse Fisharebest\Webtrees\Registry; 34430ed1cbSGreg Roachuse Fisharebest\Webtrees\Services\MigrationService; 35430ed1cbSGreg Roachuse Fisharebest\Webtrees\Services\ModuleService; 36430ed1cbSGreg Roachuse Fisharebest\Webtrees\Services\ServerCheckService; 37430ed1cbSGreg Roachuse Fisharebest\Webtrees\Services\UserService; 38430ed1cbSGreg Roachuse Fisharebest\Webtrees\Session; 39b55cbc6bSGreg Roachuse Fisharebest\Webtrees\Validator; 40430ed1cbSGreg Roachuse Fisharebest\Webtrees\Webtrees; 41430ed1cbSGreg Roachuse Psr\Http\Message\ResponseInterface; 42430ed1cbSGreg Roachuse Psr\Http\Message\ServerRequestInterface; 43430ed1cbSGreg Roachuse Psr\Http\Server\RequestHandlerInterface; 44430ed1cbSGreg Roachuse Throwable; 45430ed1cbSGreg Roach 46430ed1cbSGreg Roachuse function e; 47430ed1cbSGreg Roachuse function file_get_contents; 48430ed1cbSGreg Roachuse function file_put_contents; 49430ed1cbSGreg Roachuse function ini_get; 50430ed1cbSGreg Roachuse function random_bytes; 51430ed1cbSGreg Roachuse function realpath; 52430ed1cbSGreg Roachuse function redirect; 53430ed1cbSGreg Roachuse function substr; 54430ed1cbSGreg Roachuse function touch; 55430ed1cbSGreg Roachuse function unlink; 56430ed1cbSGreg Roachuse function view; 57430ed1cbSGreg Roach 58430ed1cbSGreg Roach/** 59430ed1cbSGreg Roach * Controller for the installation wizard 60430ed1cbSGreg Roach */ 61430ed1cbSGreg Roachclass SetupWizard implements RequestHandlerInterface 62430ed1cbSGreg Roach{ 63430ed1cbSGreg Roach use ViewResponseTrait; 64430ed1cbSGreg Roach 65430ed1cbSGreg Roach private const DEFAULT_DBTYPE = 'mysql'; 66430ed1cbSGreg Roach private const DEFAULT_PREFIX = 'wt_'; 67430ed1cbSGreg Roach private const DEFAULT_DATA = [ 68430ed1cbSGreg Roach 'baseurl' => '', 69430ed1cbSGreg Roach 'lang' => '', 70430ed1cbSGreg Roach 'dbtype' => self::DEFAULT_DBTYPE, 71430ed1cbSGreg Roach 'dbhost' => '', 72430ed1cbSGreg Roach 'dbport' => '', 73430ed1cbSGreg Roach 'dbuser' => '', 74430ed1cbSGreg Roach 'dbpass' => '', 75430ed1cbSGreg Roach 'dbname' => '', 76430ed1cbSGreg Roach 'tblpfx' => self::DEFAULT_PREFIX, 77430ed1cbSGreg Roach 'wtname' => '', 78430ed1cbSGreg Roach 'wtuser' => '', 79430ed1cbSGreg Roach 'wtpass' => '', 80430ed1cbSGreg Roach 'wtemail' => '', 81430ed1cbSGreg Roach ]; 82430ed1cbSGreg Roach 83354679afSGreg Roach private const DEFAULT_PORTS = [ 84354679afSGreg Roach 'mysql' => '3306', 85354679afSGreg Roach 'pgsql' => '5432', 86354679afSGreg Roach 'sqlite' => '', 878e9b0f08SGreg Roach 'sqlsrv' => '', // Do not use default, as it is valid to have no port number. 88354679afSGreg Roach ]; 89354679afSGreg Roach 90c4943cffSGreg Roach private MigrationService $migration_service; 91430ed1cbSGreg Roach 92c4943cffSGreg Roach private ModuleService $module_service; 93430ed1cbSGreg Roach 94c4943cffSGreg Roach private ServerCheckService $server_check_service; 95430ed1cbSGreg Roach 96c4943cffSGreg Roach private UserService $user_service; 97430ed1cbSGreg Roach 98430ed1cbSGreg Roach /** 99430ed1cbSGreg Roach * @param MigrationService $migration_service 100430ed1cbSGreg Roach * @param ModuleService $module_service 101430ed1cbSGreg Roach * @param ServerCheckService $server_check_service 102430ed1cbSGreg Roach * @param UserService $user_service 103430ed1cbSGreg Roach */ 104430ed1cbSGreg Roach public function __construct( 105430ed1cbSGreg Roach MigrationService $migration_service, 106430ed1cbSGreg Roach ModuleService $module_service, 107430ed1cbSGreg Roach ServerCheckService $server_check_service, 108430ed1cbSGreg Roach UserService $user_service 109430ed1cbSGreg Roach ) { 110430ed1cbSGreg Roach $this->user_service = $user_service; 111430ed1cbSGreg Roach $this->migration_service = $migration_service; 112430ed1cbSGreg Roach $this->module_service = $module_service; 113430ed1cbSGreg Roach $this->server_check_service = $server_check_service; 114430ed1cbSGreg Roach } 115430ed1cbSGreg Roach 116430ed1cbSGreg Roach /** 117430ed1cbSGreg Roach * Installation wizard - check user input and proceed to the next step. 118430ed1cbSGreg Roach * 119430ed1cbSGreg Roach * @param ServerRequestInterface $request 120430ed1cbSGreg Roach * 121430ed1cbSGreg Roach * @return ResponseInterface 122430ed1cbSGreg Roach */ 123430ed1cbSGreg Roach public function handle(ServerRequestInterface $request): ResponseInterface 124430ed1cbSGreg Roach { 125430ed1cbSGreg Roach $this->layout = 'layouts/setup'; 126430ed1cbSGreg Roach 12755037a57SGreg Roach // Some functions need a cache, but we don't have one yet. 1286b9cb339SGreg Roach Registry::cache(new CacheFactory()); 12955037a57SGreg Roach 130430ed1cbSGreg Roach // We will need an IP address for the logs. 131b55cbc6bSGreg Roach $ip_address = Validator::serverParams($request)->string('REMOTE_ADDR', '127.0.0.1'); 132430ed1cbSGreg Roach $request = $request->withAttribute('client-ip', $ip_address); 133430ed1cbSGreg Roach 134d35568b4SGreg Roach Registry::container()->set(ServerRequestInterface::class, $request); 135430ed1cbSGreg Roach 136430ed1cbSGreg Roach $data = $this->userData($request); 137430ed1cbSGreg Roach 138b55cbc6bSGreg Roach $step = Validator::parsedBody($request)->integer('step', 1); 139430ed1cbSGreg Roach 140430ed1cbSGreg Roach $locales = $this->module_service 141430ed1cbSGreg Roach ->setupLanguages() 142430ed1cbSGreg Roach ->map(static function (ModuleLanguageInterface $module): LocaleInterface { 143430ed1cbSGreg Roach return $module->locale(); 144430ed1cbSGreg Roach }); 145430ed1cbSGreg Roach 146430ed1cbSGreg Roach if ($data['lang'] === '') { 147430ed1cbSGreg Roach $default = new LocaleEnUs(); 148430ed1cbSGreg Roach 149430ed1cbSGreg Roach $locale = Locale::httpAcceptLanguage($request->getServerParams(), $locales->all(), $default); 150430ed1cbSGreg Roach 151430ed1cbSGreg Roach $data['lang'] = $locale->languageTag(); 152430ed1cbSGreg Roach } 153430ed1cbSGreg Roach 154430ed1cbSGreg Roach I18N::init($data['lang'], true); 155430ed1cbSGreg Roach 156430ed1cbSGreg Roach $data['cpu_limit'] = $this->maxExecutionTime(); 157dc270d8cSGreg Roach $data['locales'] = $locales; 158430ed1cbSGreg Roach $data['memory_limit'] = $this->memoryLimit(); 159430ed1cbSGreg Roach 160430ed1cbSGreg Roach // Only show database errors after the user has chosen a driver. 161430ed1cbSGreg Roach if ($step >= 4) { 162430ed1cbSGreg Roach $data['errors'] = $this->server_check_service->serverErrors($data['dbtype']); 163430ed1cbSGreg Roach $data['warnings'] = $this->server_check_service->serverWarnings($data['dbtype']); 164430ed1cbSGreg Roach } else { 165430ed1cbSGreg Roach $data['errors'] = $this->server_check_service->serverErrors(); 166430ed1cbSGreg Roach $data['warnings'] = $this->server_check_service->serverWarnings(); 167430ed1cbSGreg Roach } 168430ed1cbSGreg Roach 169430ed1cbSGreg Roach if (!$this->checkFolderIsWritable(Webtrees::DATA_DIR)) { 170430ed1cbSGreg Roach $data['errors']->push( 171430ed1cbSGreg Roach '<code>' . e(realpath(Webtrees::DATA_DIR)) . '</code><br>' . 172430ed1cbSGreg Roach I18N::translate('Oops! webtrees was unable to create files in this folder.') . ' ' . 173430ed1cbSGreg Roach I18N::translate('This usually means that you need to change the folder permissions to 777.') 174430ed1cbSGreg Roach ); 175430ed1cbSGreg Roach } 176430ed1cbSGreg Roach 177430ed1cbSGreg Roach switch ($step) { 178430ed1cbSGreg Roach default: 179430ed1cbSGreg Roach case 1: 180430ed1cbSGreg Roach return $this->step1Language($data); 181430ed1cbSGreg Roach case 2: 182430ed1cbSGreg Roach return $this->step2CheckServer($data); 183430ed1cbSGreg Roach case 3: 184430ed1cbSGreg Roach return $this->step3DatabaseType($data); 185430ed1cbSGreg Roach case 4: 186430ed1cbSGreg Roach return $this->step4DatabaseConnection($data); 187430ed1cbSGreg Roach case 5: 188430ed1cbSGreg Roach return $this->step5Administrator($data); 189430ed1cbSGreg Roach case 6: 190430ed1cbSGreg Roach return $this->step6Install($data); 191430ed1cbSGreg Roach } 192430ed1cbSGreg Roach } 193430ed1cbSGreg Roach 194430ed1cbSGreg Roach /** 195430ed1cbSGreg Roach * @param ServerRequestInterface $request 196430ed1cbSGreg Roach * 197430ed1cbSGreg Roach * @return array<string,mixed> 198430ed1cbSGreg Roach */ 199430ed1cbSGreg Roach private function userData(ServerRequestInterface $request): array 200430ed1cbSGreg Roach { 201430ed1cbSGreg Roach $data = []; 202430ed1cbSGreg Roach 203430ed1cbSGreg Roach foreach (self::DEFAULT_DATA as $key => $default) { 204748dbe15SGreg Roach $data[$key] = Validator::parsedBody($request)->string($key, $default); 205430ed1cbSGreg Roach } 206430ed1cbSGreg Roach 207430ed1cbSGreg Roach return $data; 208430ed1cbSGreg Roach } 209430ed1cbSGreg Roach 210430ed1cbSGreg Roach /** 211430ed1cbSGreg Roach * The server's memory limit 212430ed1cbSGreg Roach * 213430ed1cbSGreg Roach * @return int 214430ed1cbSGreg Roach */ 215430ed1cbSGreg Roach private function maxExecutionTime(): int 216430ed1cbSGreg Roach { 217430ed1cbSGreg Roach return (int) ini_get('max_execution_time'); 218430ed1cbSGreg Roach } 219430ed1cbSGreg Roach 220430ed1cbSGreg Roach /** 221430ed1cbSGreg Roach * The server's memory limit (in MB). 222430ed1cbSGreg Roach * 223430ed1cbSGreg Roach * @return int 224430ed1cbSGreg Roach */ 225430ed1cbSGreg Roach private function memoryLimit(): int 226430ed1cbSGreg Roach { 227430ed1cbSGreg Roach $memory_limit = ini_get('memory_limit'); 228430ed1cbSGreg Roach 229430ed1cbSGreg Roach $number = (int) $memory_limit; 230430ed1cbSGreg Roach 231430ed1cbSGreg Roach switch (substr($memory_limit, -1)) { 232430ed1cbSGreg Roach case 'g': 233430ed1cbSGreg Roach case 'G': 234430ed1cbSGreg Roach return $number * 1024; 235430ed1cbSGreg Roach case 'm': 236430ed1cbSGreg Roach case 'M': 237430ed1cbSGreg Roach return $number; 238430ed1cbSGreg Roach case 'k': 239430ed1cbSGreg Roach case 'K': 240430ed1cbSGreg Roach return (int) ($number / 1024); 241430ed1cbSGreg Roach default: 242430ed1cbSGreg Roach return (int) ($number / 1048576); 243430ed1cbSGreg Roach } 244430ed1cbSGreg Roach } 245430ed1cbSGreg Roach 246430ed1cbSGreg Roach /** 247430ed1cbSGreg Roach * Check we can write to the data folder. 248430ed1cbSGreg Roach * 249430ed1cbSGreg Roach * @param string $data_dir 250430ed1cbSGreg Roach * 251430ed1cbSGreg Roach * @return bool 252430ed1cbSGreg Roach */ 253430ed1cbSGreg Roach private function checkFolderIsWritable(string $data_dir): bool 254430ed1cbSGreg Roach { 255430ed1cbSGreg Roach $text1 = random_bytes(32); 256430ed1cbSGreg Roach 257430ed1cbSGreg Roach try { 258430ed1cbSGreg Roach file_put_contents($data_dir . 'test.txt', $text1); 259430ed1cbSGreg Roach $text2 = file_get_contents(Webtrees::DATA_DIR . 'test.txt'); 260430ed1cbSGreg Roach unlink(Webtrees::DATA_DIR . 'test.txt'); 26128d026adSGreg Roach } catch (Exception) { 262430ed1cbSGreg Roach return false; 263430ed1cbSGreg Roach } 264430ed1cbSGreg Roach 265430ed1cbSGreg Roach return $text1 === $text2; 266430ed1cbSGreg Roach } 267430ed1cbSGreg Roach 268430ed1cbSGreg Roach /** 269430ed1cbSGreg Roach * @param array<string,mixed> $data 270430ed1cbSGreg Roach * 271430ed1cbSGreg Roach * @return ResponseInterface 272430ed1cbSGreg Roach */ 273430ed1cbSGreg Roach private function step1Language(array $data): ResponseInterface 274430ed1cbSGreg Roach { 275430ed1cbSGreg Roach return $this->viewResponse('setup/step-1-language', $data); 276430ed1cbSGreg Roach } 277430ed1cbSGreg Roach 278430ed1cbSGreg Roach /** 279430ed1cbSGreg Roach * @param array<string,mixed> $data 280430ed1cbSGreg Roach * 281430ed1cbSGreg Roach * @return ResponseInterface 282430ed1cbSGreg Roach */ 283430ed1cbSGreg Roach private function step2CheckServer(array $data): ResponseInterface 284430ed1cbSGreg Roach { 285430ed1cbSGreg Roach return $this->viewResponse('setup/step-2-server-checks', $data); 286430ed1cbSGreg Roach } 287430ed1cbSGreg Roach 288430ed1cbSGreg Roach /** 289430ed1cbSGreg Roach * @param array<string,mixed> $data 290430ed1cbSGreg Roach * 291430ed1cbSGreg Roach * @return ResponseInterface 292430ed1cbSGreg Roach */ 293430ed1cbSGreg Roach private function step3DatabaseType(array $data): ResponseInterface 294430ed1cbSGreg Roach { 295430ed1cbSGreg Roach if ($data['errors']->isNotEmpty()) { 296430ed1cbSGreg Roach return $this->viewResponse('setup/step-2-server-checks', $data); 297430ed1cbSGreg Roach } 298430ed1cbSGreg Roach 299430ed1cbSGreg Roach return $this->viewResponse('setup/step-3-database-type', $data); 300430ed1cbSGreg Roach } 301430ed1cbSGreg Roach 302430ed1cbSGreg Roach /** 303430ed1cbSGreg Roach * @param array<string,mixed> $data 304430ed1cbSGreg Roach * 305430ed1cbSGreg Roach * @return ResponseInterface 306430ed1cbSGreg Roach */ 307430ed1cbSGreg Roach private function step4DatabaseConnection(array $data): ResponseInterface 308430ed1cbSGreg Roach { 309430ed1cbSGreg Roach if ($data['errors']->isNotEmpty()) { 310430ed1cbSGreg Roach return $this->step3DatabaseType($data); 311430ed1cbSGreg Roach } 312430ed1cbSGreg Roach 313430ed1cbSGreg Roach return $this->viewResponse('setup/step-4-database-' . $data['dbtype'], $data); 314430ed1cbSGreg Roach } 315430ed1cbSGreg Roach 316430ed1cbSGreg Roach /** 317430ed1cbSGreg Roach * @param array<string,mixed> $data 318430ed1cbSGreg Roach * 319430ed1cbSGreg Roach * @return ResponseInterface 320430ed1cbSGreg Roach */ 321430ed1cbSGreg Roach private function step5Administrator(array $data): ResponseInterface 322430ed1cbSGreg Roach { 323354679afSGreg Roach // Use default port, if none specified. 324354679afSGreg Roach $data['dbport'] = $data['dbport'] ?: self::DEFAULT_PORTS[$data['dbtype']]; 325354679afSGreg Roach 326430ed1cbSGreg Roach try { 327430ed1cbSGreg Roach $this->connectToDatabase($data); 328430ed1cbSGreg Roach } catch (Throwable $ex) { 329430ed1cbSGreg Roach $data['errors']->push($ex->getMessage()); 330430ed1cbSGreg Roach 331430ed1cbSGreg Roach // Don't jump to step 4, as the error will make it jump to step 3. 332430ed1cbSGreg Roach return $this->viewResponse('setup/step-4-database-' . $data['dbtype'], $data); 333430ed1cbSGreg Roach } 334430ed1cbSGreg Roach 335430ed1cbSGreg Roach return $this->viewResponse('setup/step-5-administrator', $data); 336430ed1cbSGreg Roach } 337430ed1cbSGreg Roach 338430ed1cbSGreg Roach /** 339430ed1cbSGreg Roach * @param array<string,mixed> $data 340430ed1cbSGreg Roach * 341430ed1cbSGreg Roach * @return ResponseInterface 342430ed1cbSGreg Roach */ 343430ed1cbSGreg Roach private function step6Install(array $data): ResponseInterface 344430ed1cbSGreg Roach { 345430ed1cbSGreg Roach $error = $this->checkAdminUser($data['wtname'], $data['wtuser'], $data['wtpass'], $data['wtemail']); 346430ed1cbSGreg Roach 347430ed1cbSGreg Roach if ($error !== '') { 348430ed1cbSGreg Roach $data['errors']->push($error); 349430ed1cbSGreg Roach 350430ed1cbSGreg Roach return $this->step5Administrator($data); 351430ed1cbSGreg Roach } 352430ed1cbSGreg Roach 353430ed1cbSGreg Roach try { 354430ed1cbSGreg Roach $this->createConfigFile($data); 355430ed1cbSGreg Roach } catch (Throwable $exception) { 356430ed1cbSGreg Roach return $this->viewResponse('setup/step-6-failed', ['exception' => $exception]); 357430ed1cbSGreg Roach } 358430ed1cbSGreg Roach 359430ed1cbSGreg Roach // Done - start using webtrees! 360430ed1cbSGreg Roach return redirect($data['baseurl']); 361430ed1cbSGreg Roach } 362430ed1cbSGreg Roach 363430ed1cbSGreg Roach /** 364430ed1cbSGreg Roach * @param string $wtname 365430ed1cbSGreg Roach * @param string $wtuser 366430ed1cbSGreg Roach * @param string $wtpass 367430ed1cbSGreg Roach * @param string $wtemail 368430ed1cbSGreg Roach * 369430ed1cbSGreg Roach * @return string 370430ed1cbSGreg Roach */ 37124f2a3afSGreg Roach private function checkAdminUser(string $wtname, string $wtuser, string $wtpass, string $wtemail): string 372430ed1cbSGreg Roach { 373430ed1cbSGreg Roach if ($wtname === '' || $wtuser === '' || $wtpass === '' || $wtemail === '') { 374430ed1cbSGreg Roach return I18N::translate('You must enter all the administrator account fields.'); 375430ed1cbSGreg Roach } 376430ed1cbSGreg Roach 377430ed1cbSGreg Roach if (mb_strlen($wtpass) < 6) { 378430ed1cbSGreg Roach return I18N::translate('The password needs to be at least six characters long.'); 379430ed1cbSGreg Roach } 380430ed1cbSGreg Roach 381430ed1cbSGreg Roach return ''; 382430ed1cbSGreg Roach } 383430ed1cbSGreg Roach 384430ed1cbSGreg Roach /** 385430ed1cbSGreg Roach * @param array<string,mixed> $data 386430ed1cbSGreg Roach * 387430ed1cbSGreg Roach * @return void 388430ed1cbSGreg Roach */ 389430ed1cbSGreg Roach private function createConfigFile(array $data): void 390430ed1cbSGreg Roach { 391430ed1cbSGreg Roach // Create/update the database tables. 392430ed1cbSGreg Roach $this->connectToDatabase($data); 393430ed1cbSGreg Roach $this->migration_service->updateSchema('\Fisharebest\Webtrees\Schema', 'WT_SCHEMA_VERSION', Webtrees::SCHEMA_VERSION); 394430ed1cbSGreg Roach 395430ed1cbSGreg Roach // Add some default/necessary configuration data. 396430ed1cbSGreg Roach $this->migration_service->seedDatabase(); 397430ed1cbSGreg Roach 398430ed1cbSGreg Roach // If we are re-installing, then this user may already exist. 399430ed1cbSGreg Roach $admin = $this->user_service->findByIdentifier($data['wtemail']); 400430ed1cbSGreg Roach if ($admin === null) { 401430ed1cbSGreg Roach $admin = $this->user_service->findByIdentifier($data['wtuser']); 402430ed1cbSGreg Roach } 403430ed1cbSGreg Roach // Create the user 404430ed1cbSGreg Roach if ($admin === null) { 405430ed1cbSGreg Roach $admin = $this->user_service->create($data['wtuser'], $data['wtname'], $data['wtemail'], $data['wtpass']); 4061fe542e9SGreg Roach $admin->setPreference(UserInterface::PREF_LANGUAGE, $data['lang']); 4071fe542e9SGreg Roach $admin->setPreference(UserInterface::PREF_IS_VISIBLE_ONLINE, '1'); 408430ed1cbSGreg Roach } else { 409430ed1cbSGreg Roach $admin->setPassword($_POST['wtpass']); 410430ed1cbSGreg Roach } 411430ed1cbSGreg Roach // Make the user an administrator 4121fe542e9SGreg Roach $admin->setPreference(UserInterface::PREF_IS_ADMINISTRATOR, '1'); 4131fe542e9SGreg Roach $admin->setPreference(UserInterface::PREF_IS_EMAIL_VERIFIED, '1'); 4141fe542e9SGreg Roach $admin->setPreference(UserInterface::PREF_IS_ACCOUNT_APPROVED, '1'); 415430ed1cbSGreg Roach 416430ed1cbSGreg Roach // Write the config file. We already checked that this would work. 417430ed1cbSGreg Roach $config_ini_php = view('setup/config.ini', $data); 418430ed1cbSGreg Roach 419430ed1cbSGreg Roach file_put_contents(Webtrees::CONFIG_FILE, $config_ini_php); 420430ed1cbSGreg Roach 421430ed1cbSGreg Roach // Login as the new user 422d35568b4SGreg Roach $request = Registry::container()->get(ServerRequestInterface::class) 423430ed1cbSGreg Roach ->withAttribute('base_url', $data['baseurl']); 424430ed1cbSGreg Roach 425430ed1cbSGreg Roach Session::start($request); 426430ed1cbSGreg Roach Auth::login($admin); 427430ed1cbSGreg Roach Session::put('language', $data['lang']); 428430ed1cbSGreg Roach } 429430ed1cbSGreg Roach 430430ed1cbSGreg Roach /** 431430ed1cbSGreg Roach * @param array<string,mixed> $data 432430ed1cbSGreg Roach * 433430ed1cbSGreg Roach * @return void 434430ed1cbSGreg Roach */ 435430ed1cbSGreg Roach private function connectToDatabase(array $data): void 436430ed1cbSGreg Roach { 437430ed1cbSGreg Roach $capsule = new DB(); 438430ed1cbSGreg Roach 439430ed1cbSGreg Roach // Try to create the database, if it does not already exist. 440430ed1cbSGreg Roach switch ($data['dbtype']) { 441430ed1cbSGreg Roach case 'sqlite': 442430ed1cbSGreg Roach $data['dbname'] = Webtrees::ROOT_DIR . 'data/' . $data['dbname'] . '.sqlite'; 443430ed1cbSGreg Roach touch($data['dbname']); 444430ed1cbSGreg Roach break; 445430ed1cbSGreg Roach 446430ed1cbSGreg Roach case 'mysql': 447430ed1cbSGreg Roach $capsule->addConnection([ 448430ed1cbSGreg Roach 'driver' => $data['dbtype'], 449430ed1cbSGreg Roach 'host' => $data['dbhost'], 450430ed1cbSGreg Roach 'port' => $data['dbport'], 451430ed1cbSGreg Roach 'database' => '', 452430ed1cbSGreg Roach 'username' => $data['dbuser'], 453430ed1cbSGreg Roach 'password' => $data['dbpass'], 454430ed1cbSGreg Roach ], 'temp'); 455430ed1cbSGreg Roach $capsule->getConnection('temp')->statement('CREATE DATABASE IF NOT EXISTS `' . $data['dbname'] . '` COLLATE utf8_unicode_ci'); 456430ed1cbSGreg Roach break; 457430ed1cbSGreg Roach } 458430ed1cbSGreg Roach 459430ed1cbSGreg Roach // Connect to the database. 460430ed1cbSGreg Roach $capsule->addConnection([ 461430ed1cbSGreg Roach 'driver' => $data['dbtype'], 462430ed1cbSGreg Roach 'host' => $data['dbhost'], 463430ed1cbSGreg Roach 'port' => $data['dbport'], 464430ed1cbSGreg Roach 'database' => $data['dbname'], 465430ed1cbSGreg Roach 'username' => $data['dbuser'], 466430ed1cbSGreg Roach 'password' => $data['dbpass'], 467430ed1cbSGreg Roach 'prefix' => $data['tblpfx'], 468430ed1cbSGreg Roach 'prefix_indexes' => true, 469430ed1cbSGreg Roach // For MySQL 470430ed1cbSGreg Roach 'charset' => 'utf8', 471430ed1cbSGreg Roach 'collation' => 'utf8_unicode_ci', 472430ed1cbSGreg Roach 'timezone' => '+00:00', 473430ed1cbSGreg Roach 'engine' => 'InnoDB', 474430ed1cbSGreg Roach 'modes' => [ 475430ed1cbSGreg Roach 'ANSI', 476430ed1cbSGreg Roach 'STRICT_TRANS_TABLES', 477430ed1cbSGreg Roach 'NO_ZERO_IN_DATE', 478430ed1cbSGreg Roach 'NO_ZERO_DATE', 479430ed1cbSGreg Roach 'ERROR_FOR_DIVISION_BY_ZERO', 480430ed1cbSGreg Roach ], 481430ed1cbSGreg Roach // For SQLite 482430ed1cbSGreg Roach 'foreign_key_constraints' => true, 483430ed1cbSGreg Roach ]); 484430ed1cbSGreg Roach 485430ed1cbSGreg Roach $capsule->setAsGlobal(); 486430ed1cbSGreg Roach } 487430ed1cbSGreg Roach} 488