3 namespace Friendica\Module\Admin;
5 use Friendica\Core\Addon;
6 use Friendica\Core\Config;
7 use Friendica\Core\L10n;
8 use Friendica\Core\Logger;
9 use Friendica\Core\Renderer;
10 use Friendica\Core\Update;
11 use Friendica\Database\DBA;
12 use Friendica\Database\DBStructure;
13 use Friendica\Model\Register;
14 use Friendica\Module\BaseAdminModule;
15 use Friendica\Util\ConfigFileLoader;
16 use Friendica\Util\DateTimeFormat;
17 use Friendica\Util\FileSystem;
18 use Friendica\Util\Network;
20 class Summary extends BaseAdminModule
22 public static function content()
28 // are there MyISAM tables in the DB? If so, trigger a warning message
30 if (DBA::count(['information_schema' => 'tables'], ['engine' => 'myisam', 'table_schema' => DBA::databaseName()])) {
31 $warningtext[] = L10n::t('Your DB still runs with MyISAM tables. You should change the engine type to InnoDB. As Friendica will use InnoDB only features in the future, you should change this! See <a href="%s">here</a> for a guide that may be helpful converting the table engines. You may also use the command <tt>php bin/console.php dbstructure toinnodb</tt> of your Friendica installation for an automatic conversion.<br />', 'https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html');
34 // Check if github.com/friendica/master/VERSION is higher then
35 // the local version of Friendica. Check is opt-in, source may be master or devel branch
36 if (Config::get('system', 'check_new_version_url', 'none') != 'none') {
37 $gitversion = Config::get('system', 'git_friendica_version');
38 if (version_compare(FRIENDICA_VERSION, $gitversion) < 0) {
39 $warningtext[] = L10n::t('There is a new version of Friendica available for download. Your current version is %1$s, upstream version is %2$s', FRIENDICA_VERSION, $gitversion);
43 if (Config::get('system', 'dbupdate', DBStructure::UPDATE_NOT_CHECKED) == DBStructure::UPDATE_NOT_CHECKED) {
44 DBStructure::update($a->getBasePath(), false, true);
47 if (Config::get('system', 'dbupdate') == DBStructure::UPDATE_FAILED) {
48 $warningtext[] = L10n::t('The database update failed. Please run "php bin/console.php dbstructure update" from the command line and have a look at the errors that might appear.');
51 if (Config::get('system', 'update') == Update::FAILED) {
52 $warningtext[] = L10n::t('The last update failed. Please run "php bin/console.php dbstructure update" from the command line and have a look at the errors that might appear. (Some of the errors are possibly inside the logfile.)');
55 $last_worker_call = Config::get('system', 'last_worker_execution', false);
56 if (!$last_worker_call) {
57 $warningtext[] = L10n::t('The worker was never executed. Please check your database structure!');
58 } elseif ((strtotime(DateTimeFormat::utcNow()) - strtotime($last_worker_call)) > 60 * 60) {
59 $warningtext[] = L10n::t('The last worker execution was on %s UTC. This is older than one hour. Please check your crontab settings.', $last_worker_call);
62 // Legacy config file warning
63 if (file_exists('.htconfig.php')) {
64 $warningtext[] = L10n::t('Friendica\'s configuration now is stored in config/local.config.php, please copy config/local-sample.config.php and move your config from <code>.htconfig.php</code>. See <a href="%s">the Config help page</a> for help with the transition.', $a->getBaseURL() . '/help/Config');
67 if (file_exists('config/local.ini.php')) {
68 $warningtext[] = L10n::t('Friendica\'s configuration now is stored in config/local.config.php, please copy config/local-sample.config.php and move your config from <code>config/local.ini.php</code>. See <a href="%s">the Config help page</a> for help with the transition.', $a->getBaseURL() . '/help/Config');
71 // Check server vitality
72 if (!self::checkSelfHostMeta()) {
73 $well_known = $a->getBaseURL() . '/.well-known/host-meta';
74 $warningtext[] = L10n::t('<a href="%s">%s</a> is not reachable on your system. This is a severe configuration issue that prevents server to server communication. See <a href="%s">the installation page</a> for help.',
75 $well_known, $well_known, $a->getBaseURL() . '/help/Install');
78 // Check logfile permission
79 if (Config::get('system', 'debugging')) {
80 $file = Config::get('system', 'logfile');
82 /** @var FileSystem $fileSystem */
83 $fileSystem = self::getClass(FileSystem::class);
86 $stream = $fileSystem->createStream($file);
88 if (is_file($stream) &&
89 !is_writeable($stream)) {
90 $warningtext[] = L10n::t('The logfile \'%s\' is not writable. No logging possible', $stream);
93 } catch (\Throwable $exception) {
94 $warningtext[] = L10n::t('The logfile \'%s\' is not usable. No logging possible (error: \'%s\')', $file, $exception->getMessage());
97 $stream = Config::get('system', 'dlogfile');
99 if (is_file($stream) &&
100 !is_writeable($stream)) {
101 $warningtext[] = L10n::t('The logfile \'%s\' is not writable. No logging possible', $stream);
105 // check legacy basepath settings
106 $configLoader = new ConfigFileLoader($a->getBasePath(), $a->getMode());
107 $configCache = new Config\Cache\ConfigCache();
108 $configLoader->setupCache($configCache);
109 $confBasepath = $configCache->get('system', 'basepath');
110 $currBasepath = $a->getConfig()->get('system', 'basepath');
111 if ($confBasepath !== $currBasepath || !is_dir($currBasepath)) {
112 if (is_dir($confBasepath) && Config::set('system', 'basepath', $confBasepath)) {
113 $a->getLogger()->info('Friendica\'s system.basepath was updated successfully.', [
114 'from' => $currBasepath,
115 'to' => $confBasepath,
117 $warningtext[] = L10n::t('Friendica\'s system.basepath was updated from \'%s\' to \'%s\'. Please remove the system.basepath from your db to avoid differences.',
120 } elseif (!is_dir($currBasepath)) {
121 $a->getLogger()->alert('Friendica\'s system.basepath is wrong.', [
122 'from' => $currBasepath,
123 'to' => $confBasepath,
125 $warningtext[] = L10n::t('Friendica\'s current system.basepath \'%s\' is wrong and the config file \'%s\' isn\'t used.',
129 $a->getLogger()->alert('Friendica\'s system.basepath is wrong.', [
130 'from' => $currBasepath,
131 'to' => $confBasepath,
133 $warningtext[] = L10n::t('Friendica\'s current system.basepath \'%s\' is not equal to the config file \'%s\'. Please fix your configuration.',
140 [L10n::t('Normal Account'), 0],
141 [L10n::t('Automatic Follower Account'), 0],
142 [L10n::t('Public Forum Account'), 0],
143 [L10n::t('Automatic Friend Account'), 0],
144 [L10n::t('Blog Account'), 0],
145 [L10n::t('Private Forum Account'), 0]
149 $pageFlagsCountStmt = DBA::p('SELECT `page-flags`, COUNT(`uid`) AS `count` FROM `user` GROUP BY `page-flags`');
150 while ($pageFlagsCount = DBA::fetch($pageFlagsCountStmt)) {
151 $accounts[$pageFlagsCount['page-flags']][1] = $pageFlagsCount['count'];
152 $users += $pageFlagsCount['count'];
154 DBA::close($pageFlagsCountStmt);
156 Logger::log('accounts: ' . print_r($accounts, true), Logger::DATA);
158 $pending = Register::getPendingCount();
160 $deferred = DBA::count('workerqueue', ['NOT `done` AND `retrial` > ?', 0]);
162 $workerqueue = DBA::count('workerqueue', ['NOT `done` AND `retrial` = ?', 0]);
164 // We can do better, but this is a quick queue status
165 $queues = ['label' => L10n::t('Message queues'), 'deferred' => $deferred, 'workerq' => $workerqueue];
167 $variables = DBA::toArray(DBA::p('SHOW variables LIKE "max_allowed_packet"'));
168 $max_allowed_packet = $variables ? $variables[0]['Value'] : 0;
171 'label' => L10n::t('Server Settings'),
173 'upload_max_filesize' => ini_get('upload_max_filesize'),
174 'post_max_size' => ini_get('post_max_size'),
175 'memory_limit' => ini_get('memory_limit')
178 'max_allowed_packet' => $max_allowed_packet
182 $t = Renderer::getMarkupTemplate('admin/summary.tpl');
183 return Renderer::replaceMacros($t, [
184 '$title' => L10n::t('Administration'),
185 '$page' => L10n::t('Summary'),
186 '$queues' => $queues,
187 '$users' => [L10n::t('Registered users'), $users],
188 '$accounts' => $accounts,
189 '$pending' => [L10n::t('Pending registrations'), $pending],
190 '$version' => [L10n::t('Version'), FRIENDICA_VERSION],
191 '$platform' => FRIENDICA_PLATFORM,
192 '$codename' => FRIENDICA_CODENAME,
193 '$build' => Config::get('system', 'build'),
194 '$addons' => [L10n::t('Active addons'), Addon::getEnabledList()],
195 '$serversettings' => $server_settings,
196 '$warningtext' => $warningtext
200 private static function checkSelfHostMeta()
202 // Fetch the host-meta to check if this really is a vital server
203 return Network::curl(self::getApp()->getBaseURL() . '/.well-known/host-meta')->isSuccess();