src/Protocol/ActivityPub/Queue.php

   1 <?php
   2 /**
   3  * @copyright Copyright (C) 2010-2023, the Friendica project
   4  *
   5  * @license GNU AGPL version 3 or any later version
   6  *
   7  * This program is free software: you can redistribute it and/or modify
   8  * it under the terms of the GNU Affero General Public License as
   9  * published by the Free Software Foundation, either version 3 of the
  10  * License, or (at your option) any later version.
  11  *
  12  * This program is distributed in the hope that it will be useful,
  13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15  * GNU Affero General Public License for more details.
  16  *
  17  * You should have received a copy of the GNU Affero General Public License
  18  * along with this program.  If not, see <https://www.gnu.org/licenses/>.
  19  *
  20  */
  21
  22 namespace Friendica\Protocol\ActivityPub;
  23
  24 use Friendica\Core\Logger;
  25 use Friendica\Core\Worker;
  26 use Friendica\Database\Database;
  27 use Friendica\Database\DBA;
  28 use Friendica\DI;
  29 use Friendica\Model\ItemURI;
  30 use Friendica\Model\Post;
  31 use Friendica\Util\DateTimeFormat;
  32 use Friendica\Util\JsonLD;
  33
  34 /**
  35  * This class handles the processing of incoming posts
  36  */
  37 class Queue
  38 {
  39         /**
  40          * Add activity to the queue
  41          *
  42          * @param array $activity
  43          * @param string $type
  44          * @param integer $uid
  45          * @param string $http_signer
  46          * @param boolean $push
  47          * @return array
  48          */
  49         public static function add(array $activity, string $type, int $uid, string $http_signer, bool $push, bool $trust_source): array
  50         {
  51                 $fields = [
  52                         'activity-id' => $activity['id'],
  53                         'object-id'   => $activity['object_id'],
  54                         'type'        => $type,
  55                         'object-type' => $activity['object_type'],
  56                         'activity'    => json_encode($activity, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT),
  57                         'received'    => DateTimeFormat::utcNow(),
  58                         'push'        => $push,
  59                         'trust'       => $trust_source,
  60                 ];
  61
  62                 if (!empty($activity['reply-to-id'])) {
  63                         $fields['in-reply-to-id'] = $activity['reply-to-id'];
  64                 }
  65
  66                 if (!empty($activity['context'])) {
  67                         $fields['conversation'] = $activity['context'];
  68                 } elseif (!empty($activity['conversation'])) {
  69                         $fields['conversation'] = $activity['conversation'];
  70                 }
  71
  72                 if (!empty($activity['object_object_type'])) {
  73                         $fields['object-object-type'] = $activity['object_object_type'];
  74                 }
  75
  76                 if (!empty($http_signer)) {
  77                         $fields['signer'] = $http_signer;
  78                 }
  79
  80                 DBA::insert('inbox-entry', $fields, Database::INSERT_IGNORE);
  81
  82                 $queue = DBA::selectFirst('inbox-entry', ['id'], ['activity-id' => $activity['id']]);
  83                 if (!empty($queue['id'])) {
  84                         $activity['entry-id'] = $queue['id'];
  85                         DBA::insert('inbox-entry-receiver', ['queue-id' => $queue['id'], 'uid' => $uid], Database::INSERT_IGNORE);
  86                 }
  87                 return $activity;
  88         }
  89
  90         /**
  91          * Checks if an entry for a given url and type already exists
  92          *
  93          * @param string $url
  94          * @param string $type
  95          * @return boolean
  96          */
  97         public static function exists(string $url, string $type): bool
  98         {
  99                 return DBA::exists('inbox-entry', ['type' => $type, 'object-id' => $url]);
 100         }
 101
 102         /**
 103          * Remove activity from the queue
 104          *
 105          * @param array $activity
 106          * @return void
 107          */
 108         public static function remove(array $activity = [])
 109         {
 110                 if (empty($activity['entry-id'])) {
 111                         return;
 112                 }
 113                 DBA::delete('inbox-entry', ['id' => $activity['entry-id']]);
 114         }
 115
 116         /**
 117          * Delete all entries that depend on the given worker id
 118          *
 119          * @param integer $wid
 120          * @return void
 121          */
 122         public static function deleteByWorkerId(int $wid)
 123         {
 124                 $entries = DBA::select('inbox-entry', ['id'], ['wid' => $wid]);
 125                 while ($entry = DBA::fetch($entries)) {
 126                         self::deleteById($entry['id']);
 127                 }
 128                 DBA::close($entries);
 129         }
 130
 131         /**
 132          * Delete recursively an entry and all their children
 133          *
 134          * @param integer $id
 135          * @return void
 136          */
 137         public static function deleteById(int $id)
 138         {
 139                 $entry = DBA::selectFirst('inbox-entry', ['id', 'object-id'], ['id' => $id]);
 140                 if (empty($entry)) {
 141                         return;
 142                 }
 143
 144                 Logger::debug('Delete inbox-entry', ['id' => $entry['id']]);
 145
 146                 DBA::delete('inbox-entry', ['id' => $entry['id']]);
 147
 148                 $children = DBA::select('inbox-entry', ['id'], ['in-reply-to-id' => $entry['object-id']]);
 149                 while ($child = DBA::fetch($children)) {
 150                         self::deleteById($child['id']);
 151                 }
 152                 DBA::close($children);
 153         }
 154
 155         /**
 156          * Set the worker id for the queue entry
 157          *
 158          * @param int $entry_id
 159          * @param int $wid
 160          * @return void
 161          */
 162         public static function setWorkerId(int $entry_id, int $wid)
 163         {
 164                 if (empty($entry_id) || empty($wid)) {
 165                         return;
 166                 }
 167                 DBA::update('inbox-entry', ['wid' => $wid], ['id' => $entry_id]);
 168         }
 169
 170         /**
 171          * Check if there is an assigned worker task
 172          *
 173          * @param int $wid
 174          *
 175          * @return bool
 176          */
 177         public static function hasWorker(int $wid): bool
 178         {
 179                 if (empty($wid)) {
 180                         return false;
 181                 }
 182                 return DBA::exists('workerqueue', ['id' => $wid, 'done' => false]);
 183         }
 184
 185         /**
 186          * Process the activity with the given id
 187          *
 188          * @param integer $id
 189          * @param bool    $fetch_parents
 190          *
 191          * @return bool
 192          */
 193         public static function process(int $id, bool $fetch_parents = true): bool
 194         {
 195                 $entry = DBA::selectFirst('inbox-entry', [], ['id' => $id]);
 196                 if (empty($entry)) {
 197                         return false;
 198                 }
 199
 200                 if (!self::isProcessable($id)) {
 201                         Logger::debug('Other queue entries need to be processed first.', ['id' => $id]);
 202                         return false;
 203                 }
 204
 205                 if (!empty($entry['wid'])) {
 206                         $worker = DI::app()->getQueue();
 207                         $wid = $worker['id'] ?? 0;
 208                         if ($entry['wid'] != $wid) {
 209                                 $workerqueue = DBA::selectFirst('workerqueue', ['pid'], ['id' => $entry['wid'], 'done' => false]);
 210                                 if (!empty($workerqueue['pid']) && posix_kill($workerqueue['pid'], 0)) {
 211                                         Logger::notice('Entry is already processed via another process.', ['current' => $wid, 'processor' => $entry['wid']]);
 212                                         return false;
 213                                 }
 214                         }
 215                 }
 216
 217                 Logger::debug('Processing queue entry', ['id' => $entry['id'], 'type' => $entry['type'], 'object-type' => $entry['object-type'], 'uri' => $entry['object-id'], 'in-reply-to' => $entry['in-reply-to-id']]);
 218
 219                 $activity = json_decode($entry['activity'], true);
 220                 $type     = $entry['type'];
 221                 $push     = $entry['push'];
 222
 223                 $activity['entry-id']        = $entry['id'];
 224                 $activity['worker-id']       = $entry['wid'];
 225                 $activity['recursion-depth'] = 0;
 226
 227                 if (empty($activity['thread-children-type'])) {
 228                         $activity['thread-children-type'] = $type;
 229                 }
 230
 231                 $receivers = DBA::select('inbox-entry-receiver', ['uid'], ["`queue-id` = ? AND `uid` != ?", $entry['id'], 0]);
 232                 while ($receiver = DBA::fetch($receivers)) {
 233                         if (!in_array($receiver['uid'], $activity['receiver'])) {
 234                                 $activity['receiver'][] = $receiver['uid'];
 235                         }
 236                 }
 237                 DBA::close($receivers);
 238
 239                 if (!Receiver::routeActivities($activity, $type, $push, $fetch_parents, $activity['receiver'][0] ?? 0)) {
 240                         self::remove($activity);
 241                 }
 242
 243                 return true;
 244         }
 245
 246         /**
 247          * Process all activities
 248          *
 249          * @return void
 250          */
 251         public static function processAll()
 252         {
 253                 $entries = DBA::select('inbox-entry', ['id', 'type', 'object-type', 'object-id', 'in-reply-to-id'], ["`trust` AND `wid` IS NULL"], ['order' => ['id' => true]]);
 254                 while ($entry = DBA::fetch($entries)) {
 255                         if (!self::isProcessable($entry['id'])) {
 256                                 continue;
 257                         }
 258                         Logger::debug('Process leftover entry', $entry);
 259                         self::process($entry['id'], false);
 260                 }
 261                 DBA::close($entries);
 262         }
 263
 264         public static function isProcessable(int $id): bool
 265         {
 266                 $entry = DBA::selectFirst('inbox-entry', [], ['id' => $id]);
 267                 if (empty($entry)) {
 268                         return false;
 269                 }
 270
 271                 if (($entry['type'] == 'as:Follow') && ($entry['object-type'] == 'as:Note')) {
 272                         return true;
 273                 }
 274
 275                 if (!empty($entry['object-id']) && Post::exists(['uri' => $entry['object-id']])) {
 276                         // The object already exists, so processing can be done
 277                         return true;
 278                 }
 279
 280                 if (!empty($entry['conversation'])) {
 281                         $conv_id = ItemURI::getIdByURI($entry['conversation'], false);
 282                         if (DBA::exists('post-thread', ['conversation-id' => $conv_id])) {
 283                                 // We have got the conversation in the system, so the post can be processed
 284                                 return true;
 285                         }
 286                 }
 287
 288                 if (!empty($entry['object-id']) && !empty($entry['in-reply-to-id']) && ($entry['object-id'] != $entry['in-reply-to-id'])) {
 289                         if (DBA::exists('inbox-entry', ['object-id' => $entry['in-reply-to-id']])) {
 290                                 // This entry belongs to some other entry that should be processed first
 291                                 return false;
 292                         }
 293                         if (!Post::exists(['uri' => $entry['in-reply-to-id']])) {
 294                                 // This entry belongs to some other entry that need to be fetched first
 295                                 if (Fetch::hasWorker($entry['in-reply-to-id'])) {
 296                                         Logger::debug('Fetching of the activity is already queued', ['id' => $entry['activity-id'], 'reply-to-id' => $entry['in-reply-to-id']]);
 297                                         return false;
 298                                 }
 299                                 Fetch::add($entry['in-reply-to-id']);
 300                                 $activity = json_decode($entry['activity'], true);
 301                                 $activity['recursion-depth'] = 0;
 302                                 $wid = Worker::add(Worker::PRIORITY_HIGH, 'FetchMissingActivity', $entry['in-reply-to-id'], $activity, '', Receiver::COMPLETION_ASYNC);
 303                                 Fetch::setWorkerId($entry['in-reply-to-id'], $wid);
 304                                 Logger::debug('Fetch missing activity', ['wid' => $wid, 'id' => $entry['activity-id'], 'reply-to-id' => $entry['in-reply-to-id']]);
 305                                 return false;
 306                         }
 307                 }
 308
 309                 return true;
 310         }
 311
 312         /**
 313          * Clear old activities
 314          *
 315          * @return void
 316          */
 317         public static function clear()
 318         {
 319                 // We delete all entries that aren't associated with a worker entry after seven days.
 320                 // The other entries are deleted when the worker deferred for too long.
 321                 $entries = DBA::select('inbox-entry', ['id'], ["`wid` IS NULL AND `received` < ?", DateTimeFormat::utc('now - 7 days')]);
 322                 while ($entry = DBA::fetch($entries)) {
 323                         self::deleteById($entry['id']);
 324                 }
 325                 DBA::close($entries);
 326
 327                 // Optimizing this table only last seconds
 328                 if (DI::config()->get('system', 'optimize_tables')) {
 329                         Logger::info('Optimize start');
 330                         DBA::optimizeTable('inbox-entry');
 331                         Logger::info('Optimize end');
 332                 }
 333         }
 334
 335         /**
 336          * Process all activities that are children of a given post url
 337          *
 338          * @param string $uri
 339          * @return int
 340          */
 341         public static function processReplyByUri(string $uri): int
 342         {
 343                 $count = 0;
 344                 $entries = DBA::select('inbox-entry', ['id'], ["`in-reply-to-id` = ? AND `object-id` != ?", $uri, $uri]);
 345                 while ($entry = DBA::fetch($entries)) {
 346                         $count += 1;
 347                         self::process($entry['id'], false);
 348                 }
 349                 DBA::close($entries);
 350                 return $count;
 351         }
 352
 353         /**
 354          * Checks if there are children of the given uri
 355          *
 356          * @param string $uri
 357          *
 358          * @return bool
 359          */
 360         public static function hasChildren(string $uri): bool
 361         {
 362                 return DBA::exists('inbox-entry', ["`in-reply-to-id` = ? AND `object-id` != ?", $uri, $uri]);
 363         }
 364
 365         /**
 366          * Prepare the queue entry.
 367          * This is a test function that is used solely for development.
 368          *
 369          * @param integer $id
 370          * @return array
 371          */
 372         public static function reprepareActivityById(int $id): array
 373         {
 374                 $entry = DBA::selectFirst('inbox-entry', [], ['id' => $id]);
 375                 if (empty($entry)) {
 376                         return [];
 377                 }
 378
 379                 $receiver = DBA::selectFirst('inbox-entry-receiver', ['uid'], ['queue-id' => $id]);
 380                 if (!empty($receiver)) {
 381                         $uid = $receiver['uid'];
 382                 } else {
 383                         $uid = 0;
 384                 }
 385
 386                 $trust_source = $entry['trust'];
 387
 388                 $data     = json_decode($entry['activity'], true);
 389                 $activity = json_decode($data['raw'], true);
 390
 391                 $ldactivity = JsonLD::compact($activity);
 392                 return [
 393                         'data'  => Receiver::prepareObjectData($ldactivity, $uid, $entry['push'], $trust_source),
 394                         'trust' => $trust_source
 395                 ];
 396         }
 397
 398         /**
 399          * Set the trust for all untrusted entries.
 400          * This is a test function that is used solely for development.
 401          *
 402          * @return void
 403          */
 404         public static function reprepareAll()
 405         {
 406                 $entries = DBA::select('inbox-entry', ['id'], ["NOT `trust` AND `wid` IS NULL"], ['order' => ['id' => true]]);
 407                 while ($entry = DBA::fetch($entries)) {
 408                         $data = self::reprepareActivityById($entry['id'], false);
 409                         if ($data['trust']) {
 410                                 DBA::update('inbox-entry', ['trust' => true], ['id' => $entry['id']]);
 411                         }
 412                 }
 413                 DBA::close($entries);
 414         }
 415 }