API tools faq
paste
Advertisement
Guest User

uptoot & pleroma logs

a guest
Sep 13th, 2020
145
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Logtalk 34.85 KB | None | 0 0
raw download clone embed print report
  1. Logs for case 1:
  2.  
  3. uptoot log:
  4. ```
  5. [DEBUG] Worker b21ba15c-a5ca-4c85-b79b-9ef5567da273 running job 9.
  6. [DEBUG] Signed request with https://valhalla2.dev.uptoot.org/users/realalice
  7. [DEBUG] AP: IN / GET / /users/realalice :
  8. {
  9.   host: 'valhalla2.dev.uptoot.org',
  10.   'user-agent': 'Pleroma 2.1.1; https://pleroma.dev.uptoot.org <contact@toot.party>',
  11.   accept: 'application/activity+json',
  12.   date: 'Sun, 13 Sep 2020 07:42:58 GMT',
  13.   signature: 'keyId="https://pleroma.dev.uptoot.org/internal/fetch#main-key",algorithm="rsa-sha256",headers="(request-target) date host",signature="AXGN1C8ezq9FUWHia4mOAsmftnRrp3CyrPoorScymUbfsxFojr9Kwb49ZGQr0+/3ajQyVlqp6Xqaw+kUF/+pJvTLO8557R6LNtc1dHR6WBVV+27tnAKdUA+WKN7jXoOZoeNhU0juoKy35z/O2Bx1DYKAfDT0SltFL6RbyiBk0phDA8+GHcidg6eli1ozTl9T594nYAtJfNUzPKw9bk9sU8v8YuvZUhTpQBNZxW70UsCTITaWDHq6/BMDYihiXEvoq+4J72HnxBW+jHq0K8crrhYbZDDVQzXjBfrCv8cP9n7O4es5xqvXxy6Jo1APQ1KYq1pnJybswxclj8Y9dS4Zvw=="',
  14.   'x-forwarded-for': '2a01:e0a:435:11e0::db4d:c0f1',
  15.   'x-forwarded-proto': 'https',
  16.   'accept-encoding': 'gzip'
  17. }
  18. [DEBUG] Signed request with https://valhalla2.dev.uptoot.org/users/valhalla2.dev.uptoot.org
  19. [DEBUG] AP: OUT / GET / https://pleroma.dev.uptoot.org/internal/fetch :
  20.          
  21.         response: 200
  22.          {"@context":["https://www.w3.org/ns/activitystreams","https://pleroma.dev.uptoot.org/schemas/litepub-0.1.jsonld",{"@language":"und"}],"endpoints":{"oauthAuthorizationEndpoint":"https://pleroma.dev.uptoot.org/oauth/authorize","oauthRegistrationEndpoint":"https://pleroma.dev.uptoot.org/api/v1/apps","oauthTokenEndpoint":"https://pleroma.dev.uptoot.org/oauth/token","sharedInbox":"https://pleroma.dev.uptoot.org/inbox","uploadMedia":"https://pleroma.dev.uptoot.org/api/ap/upload_media"},"followers":"https://pleroma.dev.uptoot.org/internal/fetch/followers","following":"https://pleroma.dev.uptoot.org/internal/fetch/following","id":"https://pleroma.dev.uptoot.org/internal/fetch","inbox":"https://pleroma.dev.uptoot.org/internal/fetch/inbox","invisible":true,"manuallyApprovesFollowers":false,"name":"Pleroma","preferredUsername":"internal.fetch","publicKey":{"id":"https://pleroma.dev.uptoot.org/internal/fetch#main-key","owner":"https://pleroma.dev.uptoot.org/internal/fetch","publicKeyPem":"-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxJLmqxfnEwtSCnZFR9l9\n571NHbz/ADUPjXa1uH1zndeVMNYEZCKRoNW+ez/tIVRukWv/6TqVwYrrUzz7pNf3\nODBEE35SsYIHGZUa1UL0ZTWGWQ4Z46XjKuk7dnp/npU86s1/YKGN4S5FtNlocm73\navX/6MkF677bqMPf+BkrI2E1UOGKFnbSgfGcDKCjUI8lXNgY8/+qVBt4msH3CsBz\nHO7mTqUs+6veosJ/fmA22ZMD1LcJyl+is2gifL2bvo7Mf74LCwS4XldyY8bg4Ukh\n2K7w5JGjqgvpFiIjEWqeY68Y6vrsJ6gB3bE8+MZJrhF+4WPMnct27uwj1RUDyPqB\nswIDAQAB\n-----END PUBLIC KEY-----\n\n"},"summary":"An internal service actor for this Pleroma instance.  No user-serviceable parts inside.","type":"Application","url":"https://pleroma.dev.uptoot.org/internal/fetch"}
  23. [INFO] GET /users/realalice - 200
  24. [DEBUG] AP: OUT / POST / https://pleroma.dev.uptoot.org/users/pleralice/inbox :
  25.          {"id":"https://valhalla2.dev.uptoot.org/users/realalice/follows/1","type":"Follow","actor":"https://valhalla2.dev.uptoot.org/users/realalice","object":"https://pleroma.dev.uptoot.org/users/pleralice","@context":["https://www.w3.org/ns/activitystreams"]}
  26.         response: 400
  27.          "error"
  28. [WARN] Job 9 finished with result RETRY actor.sendActivity() failed.
  29. ```
  30.  
  31. pleroma log:
  32. ```
  33. Sep 13 09:47:30 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] POST /users/pleralice/inbox
  34. Sep 13 09:47:30 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] Processing with Pleroma.Web.ActivityPub.ActivityPubController.inbox/2
  35.                                           Parameters: %{"@context" => ["https://www.w3.org/ns/activitystreams"], "actor" => "https://valhalla2.dev.uptoot.org/users/realalice", "id" => "https://valhalla2.dev.uptoot.org/users/realalice/follows/1", "nickname" => "pleralice", "object" => "https://pleroma.dev.uptoot.org/users/pleralice", "type" => "Follow"}
  36.                                           Pipelines: [:activitypub]
  37. Sep 13 09:47:30 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] QUERY OK source="users" db=2.6ms idle=102.3ms
  38.                                         SELECT u0."id", u0."bio", u0."raw_bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."keys", u0."public_key", u0."ap_id", u0."avatar", u0."local", u0."follower_address", u0."following_address", u0."tags", u0."last_refreshed_at", u0."last_digest_emailed_at", u0."banner", u0."background", u0."note_count", u0."follower_count", u0."following_count", u0."locked", u0."confirmation_pending", u0."password_reset_pending", u0."approval_pending", u0."registration_reason", u0."confirmation_token", u0."default_scope", u0."domain_blocks", u0."deactivated", u0."no_rich_text", u0."ap_enabled", u0."is_moderator", u0."is_admin", u0."show_role", u0."mastofe_settings", u0."uri", u0."hide_followers_count", u0."hide_follows_count", u0."hide_followers", u0."hide_follows", u0."hide_favorites", u0."unread_conversation_count", u0."pinned_activities", u0."email_notifications", u0."mascot", u0."emoji", u0."pleroma_settings_store", u0."fields", u0."raw_fields", u0."discoverable", u0."invisible", u0."allow_following_move", u0."skip_thread_containment", u0."actor_type", u0."also_known_as", u0."inbox", u0."shared_inbox", u0."accepts_chat_messages", u0."notification_settings", u0."blocks", u0."mutes", u0."muted_reblogs", u0."muted_notifications", u0."subscribers", u0."multi_factor_authentication_settings", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (u0."ap_id" = $1) ["https://valhalla2.dev.uptoot.org/users/realalice"]
  39. Sep 13 09:47:30 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] QUERY OK source="users" db=2.5ms idle=104.9ms
  40.                                         SELECT u0."id", u0."bio", u0."raw_bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."keys", u0."public_key", u0."ap_id", u0."avatar", u0."local", u0."follower_address", u0."following_address", u0."tags", u0."last_refreshed_at", u0."last_digest_emailed_at", u0."banner", u0."background", u0."note_count", u0."follower_count", u0."following_count", u0."locked", u0."confirmation_pending", u0."password_reset_pending", u0."approval_pending", u0."registration_reason", u0."confirmation_token", u0."default_scope", u0."domain_blocks", u0."deactivated", u0."no_rich_text", u0."ap_enabled", u0."is_moderator", u0."is_admin", u0."show_role", u0."mastofe_settings", u0."uri", u0."hide_followers_count", u0."hide_follows_count", u0."hide_followers", u0."hide_follows", u0."hide_favorites", u0."unread_conversation_count", u0."pinned_activities", u0."email_notifications", u0."mascot", u0."emoji", u0."pleroma_settings_store", u0."fields", u0."raw_fields", u0."discoverable", u0."invisible", u0."allow_following_move", u0."skip_thread_containment", u0."actor_type", u0."also_known_as", u0."inbox", u0."shared_inbox", u0."accepts_chat_messages", u0."notification_settings", u0."blocks", u0."mutes", u0."muted_reblogs", u0."muted_notifications", u0."subscribers", u0."multi_factor_authentication_settings", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (u0."ap_id" = $1) ["https://valhalla2.dev.uptoot.org/users/realalice"]
  41. Sep 13 09:47:30 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] Fetching object https://valhalla2.dev.uptoot.org/users/realalice via AP
  42. Sep 13 09:47:30 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] Fetch headers: [{"signature", "keyId=\"https://pleroma.dev.uptoot.org/internal/fetch#main-key\",algorithm=\"rsa-sha256\",headers=\"(request-target) date host\",signature=\"aOPCFJiWAbK/mA1XIeAYlHKTgZWKIFK7/1pqk+zDK8TF/IOEnhBpwry6e324E9Tj3E9GpRr7YdjnMYBKeafWjH5LAtg9IVNR/w02xAXNITi77diiKrZAIAK5bNnjnkagg27youNVUAlgGyHVWMpTGg98ZwGriYeXkEP2+duhE9c4yApc/yGV2vVD6agK3N8SrhXKyACNF0EsVkxUxENAaX+FsFRQqPaavh09Uzfad3tYEBNgU2ZMb1eeqqux+CAxC7jHsSGzvbBf/fanPyMUruM68TRvmPa447aQjLNLphZCX+AfcaBtodwVMEf5s3kXxdLl1srX9I645dAZrZF6yQ==\""}, {"date", "Sun, 13 Sep 2020 07:47:30 GMT"}, {"accept", "application/activity+json"}]
  43. Sep 13 09:47:31 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] QUERY OK source="users" db=4.8ms idle=55.8ms
  44.                                         SELECT u0."id", u0."bio", u0."raw_bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."keys", u0."public_key", u0."ap_id", u0."avatar", u0."local", u0."follower_address", u0."following_address", u0."tags", u0."last_refreshed_at", u0."last_digest_emailed_at", u0."banner", u0."background", u0."note_count", u0."follower_count", u0."following_count", u0."locked", u0."confirmation_pending", u0."password_reset_pending", u0."approval_pending", u0."registration_reason", u0."confirmation_token", u0."default_scope", u0."domain_blocks", u0."deactivated", u0."no_rich_text", u0."ap_enabled", u0."is_moderator", u0."is_admin", u0."show_role", u0."mastofe_settings", u0."uri", u0."hide_followers_count", u0."hide_follows_count", u0."hide_followers", u0."hide_follows", u0."hide_favorites", u0."unread_conversation_count", u0."pinned_activities", u0."email_notifications", u0."mascot", u0."emoji", u0."pleroma_settings_store", u0."fields", u0."raw_fields", u0."discoverable", u0."invisible", u0."allow_following_move", u0."skip_thread_containment", u0."actor_type", u0."also_known_as", u0."inbox", u0."shared_inbox", u0."accepts_chat_messages", u0."notification_settings", u0."blocks", u0."mutes", u0."muted_reblogs", u0."muted_notifications", u0."subscribers", u0."multi_factor_authentication_settings", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (u0."nickname" = $1) ["realalice@valhalla2.dev.uptoot.org"]
  45. Sep 13 09:47:31 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] Could not validate against known public keys: {:error, :error}
  46. Sep 13 09:47:31 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] QUERY OK source="instances" db=0.8ms idle=61.2ms
  47.                                         SELECT i0."id", i0."host", i0."unreachable_since", i0."favicon", i0."favicon_updated_at", i0."inserted_at", i0."updated_at" FROM "instances" AS i0 WHERE (i0."host" = $1) ["valhalla2.dev.uptoot.org"]
  48. Sep 13 09:47:31 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] Signature validation error for: https://valhalla2.dev.uptoot.org/users/realalice, make sure you are forwarding the HTTP Host header!
  49. Sep 13 09:47:31 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] [{"accept-encoding", "gzip"}, {"content-length", "253"}, {"content-type", "application/activity+json"}, {"date", "Sun, 13 Sep 2020 07:47:30 GMT"}, {"digest", "SHA-256=rdkI4/OashReZa0fzPS5qlduCs9qcDznw1a3nv1QALs="}, {"host", "pleroma.dev.uptoot.org"}, {"signature", "keyId=\"https://valhalla2.dev.uptoot.org/users/realalice#main-key\",algorithm=\"rsa-sha256\",headers=\"(request-target) host date digest\",signature=\"QlkAUlqGJ48cSmodR4+/pbEHvmbnXtRAzvXy0nb59bSVa/xR8twx0HDzEeBA+Mz7RzY3l5IReJTsgQmYAfhFhBZHZ6KDJyEisdrMbV1vxtqn+UzD5b/zbbAhlFBq6rUJwWrPKqLkrHXsFcxD/uJiDkyngSBEKuN+EQ3svq0KHVwirL1VKSZmJSCsXiY+wcGW08WAgA82qv460DfubMLoRYbeLk9lhtQpApuUTzHR1W7SfIXCBAYbuwPPL4BbCzIwBD0lMcyUbCJ5J03j3ejbdtWHD3Ms606rL6k0Of0iADQtyC1L6GbTTYaKB1YWGdVJxpjNC356DRD13aXffd+hwm6LVcGr3reTlPP8yKQjEQXZyerPDX7bf16E8nVIlSKyGH8XiyNK+KlEwhxLSTZHBx7KJ3BmBYYxNHoxdmOLPZWG86LnDPpX67RsYD3Xr3y24w7llc5TG5I1D7OwrPS8+SnWKNXnJfjmSZljs+dSRsMDB4GM4rdkDpXvtbZG/1+Q5ZWHSEwQsuMQQU2rSTU/s/de4GN9vvJxGkBV7sX+H4sUcY04xTUeHjv8I3tAUBz7dajYFanoIVAT4tMB6BnPvqiEMwi1YKruFbk3bdgWk23DhYPNcpS0uOl4qdelw6+KrYa741KUJK3tbO64U8UJvnxFI6kqmUpGWQmMs3i1sVQ=\""}, {"x-forwarded-for", "2a01:e0a:435:11e0::db4d:c0f1"}, {"x-forwarded-proto", "https"}, {"(request-target)", "post /users/pleralice/inbox"}]
  50. Sep 13 09:47:31 valhalla pleroma[4014]: request_id=FjRISiaP7ju-XhIAAAXC [debug] Sent 400 in 962ms
  51. ```
  52.  
  53.  
  54. --------------------------------------
  55.  
  56.  
  57. Logs for case 2:
  58.  
  59. uptoot log:
  60. ```
  61. [INFO] GET /.well-known/host-meta - 200
  62. [INFO] GET /.well-known/webfinger?resource=acct:realalice@valhalla2.dev.uptoot.org - 200
  63. [DEBUG] AP: IN / GET / /users/realalice :
  64. {
  65.   host: 'valhalla2.dev.uptoot.org',
  66.   'user-agent': 'Pleroma 2.1.1; https://pleroma.dev.uptoot.org <contact@toot.party>',
  67.   accept: 'application/activity+json',
  68.   date: 'Sun, 13 Sep 2020 07:59:22 GMT',
  69.   signature: 'keyId="https://pleroma.dev.uptoot.org/internal/fetch#main-key",algorithm="rsa-sha256",headers="(request-target) date host",signature="LBTm6TdZPxmHP28gN/NwbFw9y9nlcdo8jOGH3TLCiqeOEK819eVhAnPfVihaW/1/hrjldZhLmJ7BHPGozRBqQhaXxo+c/xN6fsGbXwkitKG11UP5ZGF58wgN/Mhx6w3M8EwH7Lfa3seROc1ccrD9+GhqrIO4qcNrbg+RWjBAVngg7hOth/rVGzs3Z2ZII5E3fMiuJd0hPVaba+WOhGQ9FPaRtY7YI2cisB4ExjiEAlljNiFupgCIRYdGzpJzeSgNbNkP4FBLiZcfOoNoklP4H5/rOYhJuDN0+2efuBU1LzA+On5LoSopMdl2lfnPqpV9dEPmTsaI/cAHpbOAjHwWPQ=="',
  70.   'x-forwarded-for': '2a01:e0a:435:11e0::db4d:c0f1',
  71.   'x-forwarded-proto': 'https',
  72.   'accept-encoding': 'gzip'
  73. }
  74. [INFO] GET /users/realalice - 200
  75. ```
  76.  
  77. pleroma log:
  78. ```
  79. Sep 13 09:59:19 valhalla pleroma[4014]: request_id=FjRI7xd1UVxgT9gAAAxJ [debug] GET /api/v2/search
  80. Sep 13 09:59:19 valhalla pleroma[4014]: request_id=FjRI7xd1UVxgT9gAAAxJ [debug] Processing with Pleroma.Web.MastodonAPI.SearchController.search2/2
  81.                                           Parameters: %{"q" => "@realalice@valhalla2.dev.uptoot.org", "resolve" => "true", "with_relationships" => "true"}
  82.                                           Pipelines: [:api]
  83. Sep 13 09:59:19 valhalla pleroma[4014]: request_id=FjRI7xd1UVxgT9gAAAxJ [debug] QUERY OK source="oauth_tokens" db=1.4ms idle=812.6ms
  84.                                         SELECT o0."id", o0."token", o0."refresh_token", o0."scopes", o0."valid_until", o0."user_id", o0."app_id", o0."inserted_at", o0."updated_at", u1."id", u1."bio", u1."raw_bio", u1."email", u1."name", u1."nickname", u1."password_hash", u1."keys", u1."public_key", u1."ap_id", u1."avatar", u1."local", u1."follower_address", u1."following_address", u1."tags", u1."last_refreshed_at", u1."last_digest_emailed_at", u1."banner", u1."background", u1."note_count", u1."follower_count", u1."following_count", u1."locked", u1."confirmation_pending", u1."password_reset_pending", u1."approval_pending", u1."registration_reason", u1."confirmation_token", u1."default_scope", u1."domain_blocks", u1."deactivated", u1."no_rich_text", u1."ap_enabled", u1."is_moderator", u1."is_admin", u1."show_role", u1."mastofe_settings", u1."uri", u1."hide_followers_count", u1."hide_follows_count", u1."hide_followers", u1."hide_follows", u1."hide_favorites", u1."unread_conversation_count", u1."pinned_activities", u1."email_notifications", u1."mascot", u1."emoji", u1."pleroma_settings_store", u1."fields", u1."raw_fields", u1."discoverable", u1."invisible", u1."allow_following_move", u1."skip_thread_containment", u1."actor_type", u1."also_known_as", u1."inbox", u1."shared_inbox", u1."accepts_chat_messages", u1."notification_settings", u1."blocks", u1."mutes", u1."muted_reblogs", u1."muted_notifications", u1."subscribers", u1."multi_factor_authentication_settings", u1."inserted_at", u1."updated_at" FROM "oauth_tokens" AS o0 INNER JOIN "users" AS u1 ON u1."id" = o0."user_id" WHERE (o0."token" = $1) ["8zCGoOizPQwTSXyo5ZK0aSexiKfowLuqcWA40fQZUM4"]
  85. Sep 13 09:59:19 valhalla pleroma[4014]: [debug] QUERY OK source="users" db=0.6ms queue=0.1ms idle=838.2ms
  86.                                         SELECT u0."ap_id" FROM "users" AS u0 WHERE (u0."deactivated" = $1) AND (NOT (u0."nickname" IS NULL)) [true]
  87. Sep 13 09:59:19 valhalla pleroma[4014]: [debug] QUERY OK source="users" db=0.7ms idle=834.5ms
  88.                                         SELECT DISTINCT u0."ap_id" FROM "users" AS u0 INNER JOIN "user_relationships" AS u1 ON (u1."source_id" = $1) AND (u1."relationship_type" = $2) WHERE (u0."id" = u1."target_id") [<<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>, 1]
  89. Sep 13 09:59:19 valhalla pleroma[4014]: [debug] QUERY OK source="users" db=3.6ms idle=837.5ms
  90.                                         SELECT u0."id", u0."bio", u0."raw_bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."keys", u0."public_key", u0."ap_id", u0."avatar", u0."local", u0."follower_address", u0."following_address", u0."tags", u0."last_refreshed_at", u0."last_digest_emailed_at", u0."banner", u0."background", u0."note_count", u0."follower_count", u0."following_count", u0."locked", u0."confirmation_pending", u0."password_reset_pending", u0."approval_pending", u0."registration_reason", u0."confirmation_token", u0."default_scope", u0."domain_blocks", u0."deactivated", u0."no_rich_text", u0."ap_enabled", u0."is_moderator", u0."is_admin", u0."show_role", u0."mastofe_settings", u0."uri", u0."hide_followers_count", u0."hide_follows_count", u0."hide_followers", u0."hide_follows", u0."hide_favorites", u0."unread_conversation_count", u0."pinned_activities", u0."email_notifications", u0."mascot", u0."emoji", u0."pleroma_settings_store", u0."fields", u0."raw_fields", u0."discoverable", u0."invisible", u0."allow_following_move", u0."skip_thread_containment", u0."actor_type", u0."also_known_as", u0."inbox", u0."shared_inbox", u0."accepts_chat_messages", u0."notification_settings", u0."blocks", u0."mutes", u0."muted_reblogs", u0."muted_notifications", u0."subscribers", u0."multi_factor_authentication_settings", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (u0."nickname" = $1) ["realalice@valhalla2.dev.uptoot.org"]
  91. Sep 13 09:59:19 valhalla pleroma[4014]: [debug] QUERY OK source="activities" db=6.0ms queue=7.0ms idle=834.5ms
  92.                                         SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = COALESCE(a0."data"->'object'->>'id', a0."data"->>'object') WHERE (NOT (a0."actor" = ANY($1))) AND (a0."data"->>'type' = 'Create') AND ($2 = ANY(a0."recipients")) AND (to_tsvector('english', o1."data"->>'content') @@ plainto_tsquery('english', $3)) AND (NOT (a0."actor" = ANY($4))) ORDER BY a0."id" desc nulls last LIMIT $5 OFFSET $6 [[], "https://www.w3.org/ns/activitystreams#Public", "@realalice@valhalla2.dev.uptoot.org", [], 20, 0]
  93. Sep 13 09:59:19 valhalla pleroma[4014]: [debug] QUERY OK source="activities" db=1.0ms idle=839.9ms
  94.                                         SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", b2."id", b2."user_id", b2."activity_id", b2."inserted_at", b2."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at", NOT (t3."id" IS NULL) FROM "activities" AS a0 LEFT OUTER JOIN "objects" AS o1 ON (o1."data"->>'id') = COALESCE(a0."data"->'object'->>'id', a0."data"->>'object') LEFT OUTER JOIN "bookmarks" AS b2 ON (b2."user_id" = $1) AND (b2."activity_id" = a0."id") LEFT OUTER JOIN "thread_mutes" AS t3 ON (t3."user_id" = $2) AND (t3."context" = a0."data"->>'context') WHERE (coalesce((a0."data")->'object'->>'id', (a0."data")->>'object') = ANY($3)) AND ((a0."data")->>'type' = $4) [<<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>, <<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>, [], "Create"]
  95. Sep 13 09:59:19 valhalla pleroma[4014]: [debug] QUERY OK source="user_relationships" db=0.3ms idle=841.0ms
  96.                                         SELECT u0."relationship_type", u0."source_id", u0."target_id" FROM "user_relationships" AS u0 WHERE ((source_id = ANY($1) AND target_id = ANY($2) AND relationship_type = ANY($3)) OR         (source_id = ANY($4) AND target_id = ANY($5) AND relationship_type = ANY($6))) [[<<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>], [], [2], [], [<<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>], []]
  97. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] Couldn't parse XML: "{\"subject\":\"acct:realalice@valhalla2.dev.uptoot.org\",\"aliases\":[\"https://valhalla2.dev.uptoot.org/@realalice\",\"https://valhalla2.dev.uptoot.org/users/realalice\"],\"links\":[{\"rel\":\"http://webfinger.net/rel/profile-page\",\"type\":\"text/html\",\"href\":\"https://valhalla2.dev.uptoot.org/@realalice\"},{\"rel\":\"self\",\"type\":\"application/activity+json\",\"href\":\"https://valhalla2.dev.uptoot.org/users/realalice\"}]}"
  98. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] Unhandled type: "text/html"
  99. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] QUERY OK source="users" db=0.9ms idle=528.5ms
  100.                                        SELECT u0."id", u0."bio", u0."raw_bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."keys", u0."public_key", u0."ap_id", u0."avatar", u0."local", u0."follower_address", u0."following_address", u0."tags", u0."last_refreshed_at", u0."last_digest_emailed_at", u0."banner", u0."background", u0."note_count", u0."follower_count", u0."following_count", u0."locked", u0."confirmation_pending", u0."password_reset_pending", u0."approval_pending", u0."registration_reason", u0."confirmation_token", u0."default_scope", u0."domain_blocks", u0."deactivated", u0."no_rich_text", u0."ap_enabled", u0."is_moderator", u0."is_admin", u0."show_role", u0."mastofe_settings", u0."uri", u0."hide_followers_count", u0."hide_follows_count", u0."hide_followers", u0."hide_follows", u0."hide_favorites", u0."unread_conversation_count", u0."pinned_activities", u0."email_notifications", u0."mascot", u0."emoji", u0."pleroma_settings_store", u0."fields", u0."raw_fields", u0."discoverable", u0."invisible", u0."allow_following_move", u0."skip_thread_containment", u0."actor_type", u0."also_known_as", u0."inbox", u0."shared_inbox", u0."accepts_chat_messages", u0."notification_settings", u0."blocks", u0."mutes", u0."muted_reblogs", u0."muted_notifications", u0."subscribers", u0."multi_factor_authentication_settings", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (u0."ap_id" = $1) ["https://valhalla2.dev.uptoot.org/users/realalice"]
  101. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] Fetching object https://valhalla2.dev.uptoot.org/users/realalice via AP
  102. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] Fetch headers: [{"signature", "keyId=\"https://pleroma.dev.uptoot.org/internal/fetch#main-key\",algorithm=\"rsa-sha256\",headers=\"(request-target) date host\",signature=\"LBTm6TdZPxmHP28gN/NwbFw9y9nlcdo8jOGH3TLCiqeOEK819eVhAnPfVihaW/1/hrjldZhLmJ7BHPGozRBqQhaXxo+c/xN6fsGbXwkitKG11UP5ZGF58wgN/Mhx6w3M8EwH7Lfa3seROc1ccrD9+GhqrIO4qcNrbg+RWjBAVngg7hOth/rVGzs3Z2ZII5E3fMiuJd0hPVaba+WOhGQ9FPaRtY7YI2cisB4ExjiEAlljNiFupgCIRYdGzpJzeSgNbNkP4FBLiZcfOoNoklP4H5/rOYhJuDN0+2efuBU1LzA+On5LoSopMdl2lfnPqpV9dEPmTsaI/cAHpbOAjHwWPQ==\""}, {"date", "Sun, 13 Sep 2020 07:59:22 GMT"}, {"accept", "application/activity+json"}]
  103. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] QUERY OK source="users" db=0.9ms idle=547.3ms
  104.                                        SELECT u0."id", u0."bio", u0."raw_bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."keys", u0."public_key", u0."ap_id", u0."avatar", u0."local", u0."follower_address", u0."following_address", u0."tags", u0."last_refreshed_at", u0."last_digest_emailed_at", u0."banner", u0."background", u0."note_count", u0."follower_count", u0."following_count", u0."locked", u0."confirmation_pending", u0."password_reset_pending", u0."approval_pending", u0."registration_reason", u0."confirmation_token", u0."default_scope", u0."domain_blocks", u0."deactivated", u0."no_rich_text", u0."ap_enabled", u0."is_moderator", u0."is_admin", u0."show_role", u0."mastofe_settings", u0."uri", u0."hide_followers_count", u0."hide_follows_count", u0."hide_followers", u0."hide_follows", u0."hide_favorites", u0."unread_conversation_count", u0."pinned_activities", u0."email_notifications", u0."mascot", u0."emoji", u0."pleroma_settings_store", u0."fields", u0."raw_fields", u0."discoverable", u0."invisible", u0."allow_following_move", u0."skip_thread_containment", u0."actor_type", u0."also_known_as", u0."inbox", u0."shared_inbox", u0."accepts_chat_messages", u0."notification_settings", u0."blocks", u0."mutes", u0."muted_reblogs", u0."muted_notifications", u0."subscribers", u0."multi_factor_authentication_settings", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (u0."nickname" = $1) ["realalice@valhalla2.dev.uptoot.org"]
  105. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] QUERY OK source="users" db=0.5ms queue=0.3ms idle=548.5ms
  106.                                        SELECT u0."id" FROM "users" AS u0 INNER JOIN "following_relationships" AS f1 ON (f1."following_id" = u0."id") AND (f1."follower_id" = $1) WHERE (u0."deactivated" != $2) AND (u0."id" != $3) AND (f1."state" = $4) [<<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>, true, <<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>, 2]
  107. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] QUERY OK source="users" db=0.5ms queue=0.3ms idle=546.4ms
  108.                                        SELECT u0."id" FROM "users" AS u0 INNER JOIN "following_relationships" AS f1 ON (f1."following_id" = $1) AND (f1."follower_id" = u0."id") WHERE (u0."deactivated" != $2) AND (u0."id" != $3) AND (f1."state" = $4) [<<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>, true, <<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>, 2]
  109. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] QUERY OK db=3.5ms queue=2.5ms idle=547.8ms
  110.                                        SELECT s0."id", s0."bio", s0."raw_bio", s0."email", s0."name", s0."nickname", s0."password_hash", s0."keys", s0."public_key", s0."ap_id", s0."avatar", s0."local", s0."follower_address", s0."following_address", s0."tags", s0."last_refreshed_at", s0."last_digest_emailed_at", s0."banner", s0."background", s0."note_count", s0."follower_count", s0."following_count", s0."locked", s0."confirmation_pending", s0."password_reset_pending", s0."approval_pending", s0."registration_reason", s0."confirmation_token", s0."default_scope", s0."domain_blocks", s0."deactivated", s0."no_rich_text", s0."ap_enabled", s0."is_moderator", s0."is_admin", s0."show_role", s0."mastofe_settings", s0."uri", s0."hide_followers_count", s0."hide_follows_count", s0."hide_followers", s0."hide_follows", s0."hide_favorites", s0."unread_conversation_count", s0."pinned_activities", s0."email_notifications", s0."mascot", s0."emoji", s0."pleroma_settings_store", s0."fields", s0."raw_fields", s0."discoverable", s0."invisible", s0."allow_following_move", s0."skip_thread_containment", s0."actor_type", s0."also_known_as", s0."inbox", s0."shared_inbox", s0."accepts_chat_messages", s0."notification_settings", s0."blocks", s0."mutes", s0."muted_reblogs", s0."muted_notifications", s0."subscribers", s0."multi_factor_authentication_settings", s0."inserted_at", s0."updated_at", s0."search_rank" FROM (SELECT ss0."id" AS "id", ss0."bio" AS "bio", ss0."raw_bio" AS "raw_bio", ss0."email" AS "email", ss0."name" AS "name", ss0."nickname" AS "nickname", ss0."password_hash" AS "password_hash", ss0."keys" AS "keys", ss0."public_key" AS "public_key", ss0."ap_id" AS "ap_id", ss0."avatar" AS "avatar", ss0."local" AS "local", ss0."follower_address" AS "follower_address", ss0."following_address" AS "following_address", ss0."tags" AS "tags", ss0."last_refreshed_at" AS "last_refreshed_at", ss0."last_digest_emailed_at" AS "last_digest_emailed_at", ss0."banner" AS "banner", ss0."background" AS "background", ss0."note_count" AS "note_count", ss0."follower_count" AS "follower_count", ss0."following_count" AS "following_count", ss0."locked" AS "locked", ss0."confirmation_pending" AS "confirmation_pending", ss0."password_reset_pending" AS "password_reset_pending", ss0."approval_pending" AS "approval_pending", ss0."registration_reason" AS "registration_reason", ss0."confirmation_token" AS "confirmation_token", ss0."default_scope" AS "default_scope", ss0."domain_blocks" AS "domain_blocks", ss0."deactivated" AS "deactivated", ss0."no_rich_text" AS "no_rich_text", ss0."ap_enabled" AS "ap_enabled", ss0."is_moderator" AS "is_moderator", ss0."is_admin" AS "is_admin", ss0."show_role" AS "show_role", ss0."mastofe_settings" AS "mastofe_settings", ss0."uri" AS "uri", ss0."hide_followers_count" AS "hide_followers_count", ss0."hide_follows_count" AS "hide_follows_count", ss0."hide_followers" AS "hide_followers", ss0."hide_follows" AS "hide_follows", ss0."hide_favorites" AS "hide_favorites", ss0."unread_conversation_count" AS "unread_conversation_count", ss0."pinned_activities" AS "pinned_activities", ss0."email_notifications" AS "email_notifications", ss0."mascot" AS "mascot", ss0."emoji" AS "emoji", ss0."pleroma_settings_store" AS "pleroma_settings_store", ss0."fields" AS "fields", ss0."raw_fields" AS "raw_fields", ss0."discoverable" AS "discoverable", ss0."invisible" AS "invisible", ss0."allow_following_move" AS "allow_following_move", ss0."skip_thread_containment" AS "skip_thread_containment", ss0."actor_type" AS "actor_type", ss0."also_known_as" AS "also_known_as", ss0."inbox" AS "inbox", ss0."shared_inbox" AS "shared_inbox", ss0."accepts_chat_messages" AS "accepts_chat_messages", ss0."notification_settings" AS "notification_settings", ss0."blocks" AS "blocks", ss0."mutes" AS "mutes", ss0."muted_reblogs" AS "muted_reblogs", ss0."muted_notifications" AS "muted_notifications", ss0."subscribers" AS "subscribers", ss0."multi_factor_authentication_settings" AS "multi_factor_authentication_settings", ss0."inserted_at" AS "inserted_at", ss0."updated_at" AS "updated_at",  CASE WHEN (ss0."id" = ANY($1) AND ss0."id" = ANY($2)) THEN (ss0."search_rank") * 1.5
  111.                                         WHEN (ss0."id" = ANY($3)) THEN (ss0."search_rank") * 1.3
  112.                                         WHEN (ss0."id" = ANY($4)) THEN (ss0."search_rank") * 1.1
  113.                                         ELSE (ss0."search_rank") END
  114.                                         AS "search_rank" FROM (SELECT su0."id" AS "id", su0."bio" AS "bio", su0."raw_bio" AS "raw_bio", su0."email" AS "email", su0."name" AS "name", su0."nickname" AS "nickname", su0."password_hash" AS "password_hash", su0."keys" AS "keys", su0."public_key" AS "public_key", su0."ap_id" AS "ap_id", su0."avatar" AS "avatar", su0."local" AS "local", su0."follower_address" AS "follower_address", su0."following_address" AS "following_address", su0."tags" AS "tags", su0."last_refreshed_at" AS "last_refreshed_at", su0."last_digest_emailed_at" AS "last_digest_emailed_at", su0."banner" AS "banner", su0."background" AS "background", su0."note_count" AS "note_count", su0."follower_count" AS "follower_count", su0."following_count" AS "following_count", su0."locked" AS "locked", su0."confirmation_pending" AS "confirmation_pending", su0."password_reset_pending" AS "password_reset_pending", su0."approval_pending" AS "approval_pending", su0."registration_reason" AS "registration_reason", su0."confirmation_token" AS "confirmation_token", su0."default_scope" AS "default_scope", su0."domain_blocks" AS "domain_blocks", su0."deactivated" AS "deactivated", su0."no_rich_text" AS "no_rich_text", su0."ap_enabled" AS "ap_enabled", su0."is_moderator" AS "is_moderator", su0."is_admin" AS "is_admin", su0."show_role" AS "show_role", su0."mastofe_settings" AS "mastofe_settings", su0."uri" AS "uri", su0."hide_followers_count" AS "hide_followers_count", su0."hide_follows_count" AS "hide_follows_count", su0."hide_followers" AS "hide_followers", su0."hide_follows" AS "hide_follows", su0."hide_favorites" AS "hide_favorites", su0."unread_conversation_count" AS "unread_conversation_count", su0."pinned_activities" AS "pinned_activities", su0."email_notifications" AS "email_notifications", su0."mascot" AS "mascot", su0."emoji" AS "emoji", su0."pleroma_settings_store" AS "pleroma_settings_store", su0."fields" AS "fields", su0."raw_fields" AS "raw_fields", su0."discoverable" AS "discoverable", su0."invisible" AS "invisible", su0."allow_following_move" AS "allow_following_move", su0."skip_thread_containment" AS "skip_thread_containment", su0."actor_type" AS "actor_type", su0."also_known_as" AS "also_known_as", su0."inbox" AS "inbox", su0."shared_inbox" AS "shared_inbox", su0."accepts_chat_messages" AS "accepts_chat_messages", su0."notification_settings" AS "notification_settings", su0."blocks" AS "blocks", su0."mutes" AS "mutes", su0."muted_reblogs" AS "muted_reblogs", su0."muted_notifications" AS "muted_notifications", su0."subscribers" AS "subscribers", su0."multi_factor_authentication_settings" AS "multi_factor_authentication_settings", su0."inserted_at" AS "inserted_at", su0."updated_at" AS "updated_at", similarity($5, su0."nickname") +
  115.                                        similarity($6, regexp_replace(su0."nickname", '@.+', '')) +
  116.                                        similarity($7, trim(coalesce(su0."name", '')))
  117.                                         AS "search_rank" FROM "users" AS su0 LEFT OUTER JOIN "user_relationships" AS su1 ON ((su1."relationship_type" = $8) AND (su1."source_id" = $9)) AND (su0."id" = su1."target_id") WHERE (su1."target_id" IS NULL) AND (su0."invisible" = FALSE) AND (su0."actor_type" != 'Application') AND ((
  118.                                          setweight(to_tsvector('simple', regexp_replace(su0."nickname", '\W', ' ', 'g')), 'A') ||
  119.                                          setweight(to_tsvector('simple', regexp_replace(coalesce(su0."name", ''), '\W', ' ', 'g')), 'B')
  120.                                        ) @@ to_tsquery('simple', $10)
  121.                                        )) AS ss0) AS s0 ORDER BY s0."search_rank" DESC, s0."id" desc nulls last LIMIT $11 OFFSET $12 [[<<0, 0, 1, 116, 109, 107, 115, 182, 248, 137, 250, 229, 130, 101, 0, 0>>], [], [<<0, 0, 1, 116, 109, 107, 115, 182, 248, 137, 250, 229, 130, 101, 0, 0>>], [], "realalice@valhalla2.dev.uptoot.org", "realalice@valhalla2.dev.uptoot.org", "realalice@valhalla2.dev.uptoot.org", 1, <<0, 0, 1, 116, 109, 40, 114, 53, 25, 5 (truncated)
  122. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] QUERY OK source="user_relationships" db=0.6ms idle=545.9ms
  123.                                        SELECT u0."relationship_type", u0."source_id", u0."target_id" FROM "user_relationships" AS u0 WHERE ((source_id = ANY($1) AND target_id = ANY($2) AND relationship_type = ANY($3)) OR         (source_id = ANY($4) AND target_id = ANY($5) AND relationship_type = ANY($6))) [[<<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>], [<<0, 0, 1, 116, 109, 107, 115, 182, 248, 137, 250, 229, 130, 101, 0, 0>>], [1, 2, 4, 3], [<<0, 0, 1, 116, 109, 107, 115, 182, 248, 137, 250, 229, 130, 101, 0, 0>>], [<<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>], [1, 5]]
  124. Sep 13 09:59:22 valhalla pleroma[4014]: [debug] QUERY OK source="following_relationships" db=0.5ms idle=546.9ms
  125.                                        SELECT f0."id", f0."state", f0."follower_id", f0."following_id", f0."inserted_at", f0."updated_at" FROM "following_relationships" AS f0 WHERE ((follower_id = ANY($1) AND following_id = ANY($2)) OR         (follower_id = ANY($3) AND following_id = ANY($4))) [[<<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>], [<<0, 0, 1, 116, 109, 107, 115, 182, 248, 137, 250, 229, 130, 101, 0, 0>>], [<<0, 0, 1, 116, 109, 107, 115, 182, 248, 137, 250, 229, 130, 101, 0, 0>>], [<<0, 0, 1, 116, 109, 40, 114, 53, 25, 5, 218, 34, 129, 127, 0, 0>>]]
  126. Sep 13 09:59:22 valhalla pleroma[4014]: request_id=FjRI7xd1UVxgT9gAAAxJ [debug] Sent 200 in 2754ms
  127. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!