akkoma
18 months agoHTTP header improvements (#294)
@r3g_5z@plem.sapphic.site [Sun, 20 Nov 2022 21:20:06 +0000 (21:20 +0000)]
HTTP header improvements (#294)

- Drop Expect-CT

Expect-CT has been redundant since 2018 when Certificate Transparency became mandated and required for all CAs and browsers. This header is only implemented in Chrome and is now deprecated. HTTP header analysers do not check this anymore as this is enforced by default. See https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Expect-CT

- Raise HSTS to 2 years and explicitly preload

The longer age for HSTS, the better. Header analysers prefer 2 years over 1 year now as free TLS is very common using Let's Encrypt.
For HSTS to be fully effective, you need to submit your root domain (domain.tld) to https://hstspreload.org. However, a requirement for this is the "preload" directive in Strict-Transport-Security. If you do not have "preload", it will reject your domain.

- Drop X-Download-Options

This is an IE8-era header when Adobe products used to use the IE engine for making outbound web requests to embed webpages in things like Adobe Acrobat (PDFs). Modern apps are using Microsoft Edge WebView2 or Chromium Embedded Framework. No modern browser checks or header analyser check for this.

- Set base-uri to 'none'

This is to specify the domain for relative links (`<base>` HTML tag). pleroma-fe does not use this and it's an incredibly niche tag.

I use all of these myself on my instance by rewriting the headers with zero problems. No breakage observed.

I have not compiled my Elixr changes, but I don't see why they'd break.

Co-authored-by: r3g_5z <june@terezi.dev>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/294
Co-authored-by: @r3g_5z@plem.sapphic.site <june@terezi.dev>
Co-committed-by: @r3g_5z@plem.sapphic.site <june@terezi.dev>
18 months agoMerge pull request 'Drop XSS auditor' (#292) from r3g_5z/akkoma:drop-xss-auditor...
floatingghost [Sun, 20 Nov 2022 04:00:25 +0000 (04:00 +0000)]
Merge pull request 'Drop XSS auditor' (#292) from r3g_5z/akkoma:drop-xss-auditor into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/292

18 months agoDrop XSS auditor
r3g_5z [Sun, 20 Nov 2022 01:40:20 +0000 (20:40 -0500)]
Drop XSS auditor

It's deprecated, removed in some, by all modern browsers and is known
to create XSS vulnerabilities in itself.

Signed-off-by: r3g_5z <june@terezi.dev>
18 months agoAdd `languages` to cheatsheet
FloatingGhost [Fri, 18 Nov 2022 11:22:30 +0000 (11:22 +0000)]
Add `languages` to cheatsheet

18 months agodocs: Update list of clients (#284)
Norm [Fri, 18 Nov 2022 11:19:37 +0000 (11:19 +0000)]
docs: Update list of clients (#284)

In addition to making the page refer to Akkoma instead of Pleroma, I've
also removed clients that were not updated in a year or more and updated
links to websites and the contact links of authors.

Also removed language that suggested these clients are in any way
"officially supported".

Co-authored-by: Francis Dinh <normandy@biribiri.dev>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/284
Co-authored-by: Norm <normandy@biribiri.dev>
Co-committed-by: Norm <normandy@biribiri.dev>
18 months agoMerge pull request 'Update copyright info' (#285) from norm/akkoma:copyright-stuff...
floatingghost [Fri, 18 Nov 2022 11:17:24 +0000 (11:17 +0000)]
Merge pull request 'Update copyright info' (#285) from norm/akkoma:copyright-stuff into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/285

18 months agomicroblogpub federation fixes (#288)
floatingghost [Fri, 18 Nov 2022 11:14:35 +0000 (11:14 +0000)]
microblogpub federation fixes (#288)

Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/288

18 months agoUpdate copyright info
Francis Dinh [Fri, 18 Nov 2022 03:48:33 +0000 (22:48 -0500)]
Update copyright info

- Bump years to 2022 where appropriate
- Add copyright for Akkoma authors
- Remove references to deleted images

19 months agoMerge pull request 'docs: Update links to list of akkoma instances' (#278) from norm...
floatingghost [Wed, 16 Nov 2022 10:16:27 +0000 (10:16 +0000)]
Merge pull request 'docs: Update links to list of akkoma instances' (#278) from norm/akkoma:update-akkoma-list-urls into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/278

19 months agoBe very specific about the double-quotes in strings
FloatingGhost [Wed, 16 Nov 2022 10:13:41 +0000 (10:13 +0000)]
Be very specific about the double-quotes in strings

19 months agoSet instance reachable on fetch
Haelwenn (lanodan) Monnier [Tue, 15 Nov 2022 17:23:47 +0000 (17:23 +0000)]
Set instance reachable on fetch

19 months agodocs: Update links to list of akkoma instances
Francis Dinh [Tue, 15 Nov 2022 12:51:19 +0000 (07:51 -0500)]
docs: Update links to list of akkoma instances

The old links were for Pleroma instances and one of them isn't even active anymore.

19 months agoand i yoink (#275)
floatingghost [Mon, 14 Nov 2022 15:07:26 +0000 (15:07 +0000)]
and i yoink (#275)

Co-authored-by: Mark Felder <feld@feld.me>
Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/275

19 months agoRemove references to soykaf
FloatingGhost [Mon, 14 Nov 2022 00:01:31 +0000 (00:01 +0000)]
Remove references to soykaf

Fixes #271

19 months agoAdd configurable timeline per oban job (#273)
floatingghost [Sun, 13 Nov 2022 23:55:51 +0000 (23:55 +0000)]
Add configurable timeline per oban job (#273)

Heavily inspired by https://git.pleroma.social/pleroma/pleroma/-/merge_requests/3777

Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/273

19 months agoMerge pull request 'change default redirectRootNoLogin to /main/public' (#272) from...
floatingghost [Sun, 13 Nov 2022 22:45:22 +0000 (22:45 +0000)]
Merge pull request 'change default redirectRootNoLogin to /main/public' (#272) from nocebo/akkoma:nocebo-default-public-tl into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/272

19 months agochange default redirectRootNoLogin to /main/public
nocebo [Sun, 13 Nov 2022 08:43:12 +0000 (08:43 +0000)]
change default redirectRootNoLogin to /main/public

close #268

19 months agoMerge pull request 'Chores for 2022.11' (#266) from 2022-11-stable into develop
floatingghost [Sat, 12 Nov 2022 15:16:51 +0000 (15:16 +0000)]
Merge pull request 'Chores for 2022.11' (#266) from 2022-11-stable into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/266

19 months agoChores for 2022.11
FloatingGhost [Fri, 11 Nov 2022 16:12:04 +0000 (16:12 +0000)]
Chores for 2022.11

19 months agofix requirements
FloatingGhost [Fri, 11 Nov 2022 16:07:07 +0000 (16:07 +0000)]
fix requirements

19 months agoAdd media sources to connect-src if media proxy is enabled
FloatingGhost [Thu, 10 Nov 2022 17:26:51 +0000 (17:26 +0000)]
Add media sources to connect-src if media proxy is enabled

19 months agoMerge branch 'develop' of akkoma.dev:AkkomaGang/akkoma into develop
FloatingGhost [Thu, 10 Nov 2022 11:54:35 +0000 (11:54 +0000)]
Merge branch 'develop' of akkoma.dev:AkkomaGang/akkoma into develop

19 months agostrip \r and \r from content-disposition filenames
FloatingGhost [Thu, 10 Nov 2022 11:54:12 +0000 (11:54 +0000)]
strip \r and \r from content-disposition filenames

19 months agoadd manual deploy for docs
FloatingGhost [Thu, 10 Nov 2022 10:55:57 +0000 (10:55 +0000)]
add manual deploy for docs

19 months agoMerge pull request 'Fix typo in README' (#262) from eloy/akkoma:develop into develop
floatingghost [Thu, 10 Nov 2022 10:52:59 +0000 (10:52 +0000)]
Merge pull request 'Fix typo in README' (#262) from eloy/akkoma:develop into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/262

19 months agoFix typo in README
Eloy Degen [Thu, 10 Nov 2022 09:00:39 +0000 (10:00 +0100)]
Fix typo in README

19 months agoupdate requirements.txt
FloatingGhost [Thu, 10 Nov 2022 03:40:36 +0000 (03:40 +0000)]
update requirements.txt

19 months agoMerge remote-tracking branch 'origin/translations' into develop
FloatingGhost [Thu, 10 Nov 2022 03:38:38 +0000 (03:38 +0000)]
Merge remote-tracking branch 'origin/translations' into develop

19 months agoUpdate documentation builder
FloatingGhost [Thu, 10 Nov 2022 03:38:10 +0000 (03:38 +0000)]
Update documentation builder

19 months agoadd requested_by changelog entry
FloatingGhost [Thu, 10 Nov 2022 03:17:00 +0000 (03:17 +0000)]
add requested_by changelog entry

19 months agoUpdate translation files
Weblate [Fri, 19 Aug 2022 09:25:17 +0000 (09:25 +0000)]
Update translation files

Updated by "Squash Git commits" hook in Weblate.

Translation: Pleroma fe/Akkoma Backend (Errors)
Translate-URL: http://translate.akkoma.dev/projects/akkoma/akkoma-backend-errors/

19 months agoTranslated using Weblate (Spanish)
Weblate [Fri, 19 Aug 2022 09:25:17 +0000 (09:25 +0000)]
Translated using Weblate (Spanish)

Currently translated at 21.6% (23 of 106 strings)

Co-authored-by: mint <they@mint.lgbt>
Translate-URL: http://translate.akkoma.dev/projects/akkoma/akkoma-backend-errors/es/
Translation: Pleroma fe/Akkoma Backend (Errors)

19 months agoInclude requested_by in relationship (#260)
floatingghost [Thu, 10 Nov 2022 03:16:32 +0000 (03:16 +0000)]
Include requested_by in relationship (#260)

Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/260

19 months agoreference "stable" in all URLs
FloatingGhost [Wed, 9 Nov 2022 13:22:44 +0000 (13:22 +0000)]
reference "stable" in all URLs

19 months agoRemove unused pattern
FloatingGhost [Tue, 8 Nov 2022 13:54:43 +0000 (13:54 +0000)]
Remove unused pattern

19 months agofix count of poll voters
FloatingGhost [Tue, 8 Nov 2022 13:50:04 +0000 (13:50 +0000)]
fix count of poll voters

19 months agomake metdata check a debug log
FloatingGhost [Tue, 8 Nov 2022 11:03:43 +0000 (11:03 +0000)]
make metdata check a debug log

19 months agoAdd fallback for reports that don't have attached activities
FloatingGhost [Tue, 8 Nov 2022 11:01:47 +0000 (11:01 +0000)]
Add fallback for reports that don't have attached activities

19 months agoDon't mess with the cache on metadata update
FloatingGhost [Tue, 8 Nov 2022 10:39:01 +0000 (10:39 +0000)]
Don't mess with the cache on metadata update

19 months agoautomatically trim loading *. prefixes on domain blocks
FloatingGhost [Mon, 7 Nov 2022 22:33:18 +0000 (22:33 +0000)]
automatically trim loading *. prefixes on domain blocks

19 months agoUpdate finch
FloatingGhost [Mon, 7 Nov 2022 13:32:34 +0000 (13:32 +0000)]
Update finch

19 months agoAdd rollbacks for associated_object_id
FloatingGhost [Mon, 7 Nov 2022 00:08:20 +0000 (00:08 +0000)]
Add rollbacks for associated_object_id

19 months agoAdd "differences" in readme
FloatingGhost [Sun, 6 Nov 2022 23:57:43 +0000 (23:57 +0000)]
Add "differences" in readme

19 months agoFix regex usage in MRF (#254)
floatingghost [Sun, 6 Nov 2022 23:50:32 +0000 (23:50 +0000)]
Fix regex usage in MRF (#254)

fixes #235
fixes #228

Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/254

19 months agoAdd enabled check on /translation/languages
FloatingGhost [Sun, 6 Nov 2022 22:55:26 +0000 (22:55 +0000)]
Add enabled check on /translation/languages

19 months agoChangelog
FloatingGhost [Sun, 6 Nov 2022 22:50:11 +0000 (22:50 +0000)]
Changelog

19 months agoScrape instance nodeinfo (#251)
floatingghost [Sun, 6 Nov 2022 22:49:39 +0000 (22:49 +0000)]
Scrape instance nodeinfo (#251)

Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/251

19 months agoFix instance name in email test
FloatingGhost [Fri, 4 Nov 2022 18:42:12 +0000 (18:42 +0000)]
Fix instance name in email test

19 months agoMerge pull request 'Fix typo in CSP Report-To header name' (#250) from tcit/akkoma...
floatingghost [Fri, 4 Nov 2022 18:41:26 +0000 (18:41 +0000)]
Merge pull request 'Fix typo in CSP Report-To header name' (#250) from tcit/akkoma:fix-typo-in-csp-report-to-header-name into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/250

19 months agoFix typo in CSP Report-To header name
Thomas Citharel [Fri, 4 Nov 2022 08:43:13 +0000 (09:43 +0100)]
Fix typo in CSP Report-To header name

The header name was Report-To, not Reply-To.

In any case, that's now being changed to the Reporting-Endpoints HTTP
Response Header.
https://w3c.github.io/reporting/#header
https://github.com/w3c/reporting/issues/177

CanIUse says the Report-To header is still supported by current Chrome
and friends.
https://caniuse.com/mdn-http_headers_report-to

It doesn't have any data for the Reporting-Endpoints HTTP header, but
this article says Chrome 96 supports it.
https://web.dev/reporting-api/

(Even though that's come out one year ago, that's not compatible with
Network Error Logging which's still using the Report-To version of the
API)

Signed-off-by: Thomas Citharel <tcit@tcit.fr>
19 months agoAdd default favicon
FloatingGhost [Wed, 2 Nov 2022 22:38:02 +0000 (22:38 +0000)]
Add default favicon

Fixes pleroma-fe#185

19 months agoMerge pull request 'Change default instance name to "Akkoma"' (#248) from norm/akkoma...
floatingghost [Wed, 2 Nov 2022 01:29:42 +0000 (01:29 +0000)]
Merge pull request 'Change default instance name to "Akkoma"' (#248) from norm/akkoma:default-instance-name into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/248

19 months agoChange default instance name to "Akkoma"
Norm [Tue, 1 Nov 2022 20:52:17 +0000 (20:52 +0000)]
Change default instance name to "Akkoma"

This was left at "Pleroma" for some reason.

19 months agoMerge pull request 'Push.Impl: support edits' (#244) from norm/akkoma:push-support...
floatingghost [Tue, 1 Nov 2022 15:14:08 +0000 (15:14 +0000)]
Merge pull request 'Push.Impl: support edits' (#244) from norm/akkoma:push-support-edits into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/244

19 months agoMerge pull request 'fix flaky test_user_relationship_test.exs:81' (#240) from ilja...
floatingghost [Tue, 1 Nov 2022 14:44:23 +0000 (14:44 +0000)]
Merge pull request 'fix flaky test_user_relationship_test.exs:81' (#240) from ilja/akkoma:fix_flaky_test_user_relationship_test.exs_81 into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/240

19 months agoMerge pull request 'fix flaky test filter_controller_test.exs:200' (#239) from ilja...
floatingghost [Tue, 1 Nov 2022 14:42:43 +0000 (14:42 +0000)]
Merge pull request 'fix flaky test filter_controller_test.exs:200' (#239) from ilja/akkoma:fix_flaky_filter_controller_test.exs_200 into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/239

19 months agoMerge pull request 'fix flaky participation_test.exs' (#238) from ilja/akkoma:fix_err...
floatingghost [Tue, 1 Nov 2022 14:37:06 +0000 (14:37 +0000)]
Merge pull request 'fix flaky participation_test.exs' (#238) from ilja/akkoma:fix_erratic_participation_test into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/238

19 months agofix_flaky_transfer_task_test.exs (#237)
ilja [Tue, 1 Nov 2022 14:31:29 +0000 (14:31 +0000)]
fix_flaky_transfer_task_test.exs (#237)

There were async calls happening, so they weren't always finished when assert happened.

I also fixed some bugs in the erratic tests that were introduced when removing :shout.:shout is a key where restart is needed, and was changed in the test to use :rate_limit (which also requires a restart). But there was a bug in the syntax that didn't get caught because the test was tagged as erratic and therefor didn't fail. Here I fixed it.

During compilation, we had a warning `:logger is used by the current application but the current application does not depend on :logger` which is now fixed as well (see commit message for complete stacktrace).

Co-authored-by: Ilja <ilja@ilja.space>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/237
Co-authored-by: ilja <akkoma.dev@ilja.space>
Co-committed-by: ilja <akkoma.dev@ilja.space>
19 months agoFix rate_limiter_test.exs test "it restricts based on config values" (#233)
ilja [Tue, 1 Nov 2022 14:25:54 +0000 (14:25 +0000)]
Fix rate_limiter_test.exs test "it restricts based on config values" (#233)

Fixes one of the 'erratic' tests

It used a timer to sleep.
But time also goes on when doing other things, so depending on hardware, the timings could be off.
I slightly changed the tests so we still test what we functionally want.
Instead of waiting until the cache expires I now have a function to expire the test and use that.

That means we're not testing any more if the cache really expires after a certain amount of time,
but that's the responsability of the dependency imo, so shouldn't be a problem.

I also changed `Pleroma.Web.Endpoint, :http, :ip` in the tests to `127.0.0.1`
Currently it was set to 8.8.8.8, but I see no reason for that and, while I assume that no calls
are made to it, it may come over as weird or suspicious to people.

Co-authored-by: Ilja <ilja@ilja.space>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/233
Co-authored-by: ilja <akkoma.dev@ilja.space>
Co-committed-by: ilja <akkoma.dev@ilja.space>
19 months agoFix tests in ldap registration
FloatingGhost [Tue, 1 Nov 2022 14:21:35 +0000 (14:21 +0000)]
Fix tests in ldap registration

19 months agoFix LDAP user registration (#229)
nullobsi [Tue, 1 Nov 2022 14:17:55 +0000 (14:17 +0000)]
Fix LDAP user registration (#229)

Simple fix for LDAP user registration. I'm not sure what changed but I managed to get Akkoma running in a debug session and figured out it was missing a match for an extra value at the end. I don't know Elixir all that well so I'm not sure if this was the correct way to do it... but it works. :)

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/229
Co-authored-by: nullobsi <me@nullob.si>
Co-committed-by: nullobsi <me@nullob.si>
19 months agoReword stop gifs
FloatingGhost [Sat, 29 Oct 2022 21:08:18 +0000 (22:08 +0100)]
Reword stop gifs

19 months agoAdd StopGifs to description
FloatingGhost [Sat, 29 Oct 2022 20:57:50 +0000 (21:57 +0100)]
Add StopGifs to description

19 months agoPush.Impl: support edits
marcin mikołajczak [Sat, 1 Oct 2022 21:28:02 +0000 (23:28 +0200)]
Push.Impl: support edits

Signed-off-by: marcin mikołajczak <git@mkljczk.pl>
19 months agofix flaky test_user_relationship_test.exs:81
ilja [Sun, 23 Oct 2022 11:31:01 +0000 (13:31 +0200)]
fix flaky test_user_relationship_test.exs:81

The problem was double. On the one hand, the function didn't actually return what was in the DB.
On the other hand the test was flaky because it used NaiveDateTime.utc_now() so test could fail or pass depending on a difference of microseconds.

Both are fixed now.

19 months agofix flaky test filter_controller_test.exs:200
Ilja [Wed, 24 Aug 2022 15:24:57 +0000 (15:24 +0000)]
fix flaky test filter_controller_test.exs:200

19 months agofix flaky participation_test.exs
ilja [Sun, 23 Oct 2022 10:33:31 +0000 (12:33 +0200)]
fix flaky participation_test.exs

It was tested if the updated_at after marking as "read" was equal as the updated_at at insertion, but that seems wrong.
Firstly, if a record is updated, you expect the updated_at to also update.
Secondly, the insert and update happen almost at the same time, so it's flaky regardless.

Here I make sure it has a much older updated_at during insert so we can clealy see the effect after update.
I also check that the updated_at is actually updated because I expect that this is the expected behaviour and it's also the current behaviour.

19 months agodocument local_bubble
FloatingGhost [Fri, 21 Oct 2022 09:23:07 +0000 (10:23 +0100)]
document local_bubble

19 months agoRemove unused DATA arg
FloatingGhost [Thu, 20 Oct 2022 12:26:00 +0000 (13:26 +0100)]
Remove unused DATA arg

19 months agoUnilateral remove from followers (#232)
floatingghost [Wed, 19 Oct 2022 10:01:14 +0000 (10:01 +0000)]
Unilateral remove from followers (#232)

from https://git.pleroma.social/pleroma/pleroma/-/merge_requests/3647/

Co-authored-by: marcin mikołajczak <git@mkljczk.pl>
Co-authored-by: Tusooa Zhu <tusooa@kazv.moe>
Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/232

19 months agoAdd docker migration guide
FloatingGhost [Tue, 18 Oct 2022 15:16:55 +0000 (16:16 +0100)]
Add docker migration guide

19 months agoadd DB restart to docker file
FloatingGhost [Mon, 17 Oct 2022 15:29:36 +0000 (16:29 +0100)]
add DB restart to docker file

20 months agoDocker builds (#231)
floatingghost [Sun, 16 Oct 2022 19:25:54 +0000 (19:25 +0000)]
Docker builds (#231)

Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/231

20 months agobump version
FloatingGhost [Fri, 14 Oct 2022 11:49:35 +0000 (12:49 +0100)]
bump version

20 months agoMerge pull request 'Check that the signature matches the creator' (#230) from domain...
floatingghost [Fri, 14 Oct 2022 11:41:34 +0000 (11:41 +0000)]
Merge pull request 'Check that the signature matches the creator' (#230) from domain-blocks into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/230

20 months agoMerge pull request 'SQL optimisations' (#227) from i-hate-sql into develop
floatingghost [Fri, 14 Oct 2022 10:49:02 +0000 (10:49 +0000)]
Merge pull request 'SQL optimisations' (#227) from i-hate-sql into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/227

20 months agoCheck that the signature matches the creator
FloatingGhost [Fri, 14 Oct 2022 10:48:32 +0000 (11:48 +0100)]
Check that the signature matches the creator

20 months agoEnsure deletes are handled after everything else
FloatingGhost [Tue, 11 Oct 2022 13:30:08 +0000 (14:30 +0100)]
Ensure deletes are handled after everything else

20 months agooptimise notifications query
FloatingGhost [Tue, 11 Oct 2022 10:40:43 +0000 (11:40 +0100)]
optimise notifications query

20 months agoformat
FloatingGhost [Mon, 10 Oct 2022 16:13:42 +0000 (17:13 +0100)]
format

20 months agoUse inner lateral join to not get dropped in :total
FloatingGhost [Mon, 10 Oct 2022 15:45:02 +0000 (16:45 +0100)]
Use inner lateral join to not get dropped in :total

20 months agoExtract deactivated users query to a join
FloatingGhost [Mon, 10 Oct 2022 14:55:58 +0000 (15:55 +0100)]
Extract deactivated users query to a join

20 months agoBackend settings sync (#226)
floatingghost [Thu, 6 Oct 2022 16:22:15 +0000 (16:22 +0000)]
Backend settings sync (#226)

Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/226

20 months agoMerge pull request 'include requirement to enable HTTP tunnel in tor' (#224) from...
floatingghost [Tue, 20 Sep 2022 13:43:14 +0000 (13:43 +0000)]
Merge pull request 'include requirement to enable HTTP tunnel in tor' (#224) from tor-docs into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/224

20 months agoinclude requirement to enable HTTP tunnel in tor
FloatingGhost [Tue, 20 Sep 2022 13:40:32 +0000 (14:40 +0100)]
include requirement to enable HTTP tunnel in tor

20 months agoMerge pull request 'ensure we use the same OTP for all releases' (#223) from update...
floatingghost [Tue, 20 Sep 2022 12:33:16 +0000 (12:33 +0000)]
Merge pull request 'ensure we use the same OTP for all releases' (#223) from update-otp-version into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/223

20 months agoensure we use the same OTP for all releases
FloatingGhost [Tue, 20 Sep 2022 11:20:54 +0000 (12:20 +0100)]
ensure we use the same OTP for all releases

20 months agoAdd installation note about flavour, support special cases (#222)
floatingghost [Tue, 20 Sep 2022 11:04:26 +0000 (11:04 +0000)]
Add installation note about flavour, support special cases (#222)

Fixes #210

Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/222

20 months agoFix false error in meilisearch index (#221)
floatingghost [Tue, 20 Sep 2022 10:36:21 +0000 (10:36 +0000)]
Fix false error in meilisearch index (#221)

the schema changed

https://docs.meilisearch.com/reference/api/documents.html#add-or-update-documents

this wasn't breaking anything, it would just report errors that were actually successes

Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/221

20 months agoMerge pull request 'Move remote user interaction changelog entry to correct version...
floatingghost [Mon, 19 Sep 2022 17:33:32 +0000 (17:33 +0000)]
Merge pull request 'Move remote user interaction changelog entry to correct version' (#219) from norm/akkoma:changelog-remote-user-interaction into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/219

20 months agoMake backups require its own scope (#218)
Norm [Mon, 19 Sep 2022 17:31:35 +0000 (17:31 +0000)]
Make backups require its own scope (#218)

Pulled from https://git.pleroma.social/pleroma/pleroma/-/merge_requests/3721.

This makes backups require its own scope (`read:backups`) instead of the `read:accounts` scope.

Co-authored-by: Tusooa Zhu <tusooa@kazv.moe>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/218
Co-authored-by: Norm <normandy@biribiri.dev>
Co-committed-by: Norm <normandy@biribiri.dev>
20 months agoMerge pull request 'Update soapbox-fe base url' (#220) from lou_de_sel/akkoma:lou_de_...
floatingghost [Mon, 19 Sep 2022 17:30:04 +0000 (17:30 +0000)]
Merge pull request 'Update soapbox-fe base url' (#220) from lou_de_sel/akkoma:lou_de_sel-patch-1 into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/220

20 months agoUpdate soapbox base url
lou_de_sel [Sun, 18 Sep 2022 07:45:30 +0000 (07:45 +0000)]
Update soapbox base url

At some point 'soapbox-pub/soapbox-fe' was moved to 'soapbox-pub/soapbox' and the build url is now updated.

20 months agoMove remote user interaction changelog entry to correct version
Norm [Sun, 18 Sep 2022 03:21:05 +0000 (03:21 +0000)]
Move remote user interaction changelog entry to correct version

That feature was added in 2022.09, not 2022.08.

21 months agoensure queue_target can't be silly low
FloatingGhost [Fri, 16 Sep 2022 13:23:31 +0000 (14:23 +0100)]
ensure queue_target can't be silly low

21 months agoEnsure rollback succeeds
FloatingGhost [Fri, 16 Sep 2022 12:00:40 +0000 (13:00 +0100)]
Ensure rollback succeeds

21 months agoMerge pull request 'User: search: exclude deactivated users from user search' (#214...
floatingghost [Fri, 16 Sep 2022 11:56:00 +0000 (11:56 +0000)]
Merge pull request 'User: search: exclude deactivated users from user search' (#214) from norm/akkoma:exclude-deactivated-search into develop

Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/214

21 months agoEnsure migrations succeed (#216)
floatingghost [Fri, 16 Sep 2022 11:53:11 +0000 (11:53 +0000)]
Ensure migrations succeed (#216)

Co-authored-by: FloatingGhost <hannah@coffee-and-dreams.uk>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/216

21 months agoUser: search: exclude deactivated users from user search
a1batross [Thu, 15 Sep 2022 20:38:35 +0000 (22:38 +0200)]
User: search: exclude deactivated users from user search

This way we don't pollute search results with deactivated and deleted users

21 months agoUpdate styles.json path in frontend config doc (#212)
Norm [Wed, 14 Sep 2022 10:20:07 +0000 (10:20 +0000)]
Update styles.json path in frontend config doc (#212)

Co-authored-by: Francis Dinh <normandy@biribiri.dev>
Reviewed-on: https://akkoma.dev/AkkomaGang/akkoma/pulls/212
Co-authored-by: Norm <normandy@biribiri.dev>
Co-committed-by: Norm <normandy@biribiri.dev>