akkoma
2 years 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>
2 years 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

2 years 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>
2 years agoAdd `languages` to cheatsheet
FloatingGhost [Fri, 18 Nov 2022 11:22:30 +0000 (11:22 +0000)]
Add `languages` to cheatsheet

2 years 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>
2 years 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

2 years 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

2 years 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

2 years 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

2 years 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

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

2 years 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.

2 years 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

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

Fixes #271

2 years 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

2 years 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

2 years 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

2 years 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

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

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

2 years 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

2 years 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

2 years 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

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

2 years 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

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

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

2 years 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

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

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

2 years 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/

2 years 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)

2 years 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

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

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

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

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

2 years 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

2 years 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

2 years 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

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

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

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

2 years 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

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

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

2 years 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

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

2 years 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

2 years 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>
2 years agoAdd default favicon
FloatingGhost [Wed, 2 Nov 2022 22:38:02 +0000 (22:38 +0000)]
Add default favicon

Fixes pleroma-fe#185

2 years 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

2 years 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.

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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>
2 years 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>
2 years agoFix tests in ldap registration
FloatingGhost [Tue, 1 Nov 2022 14:21:35 +0000 (14:21 +0000)]
Fix tests in ldap registration

2 years 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>
2 years agoReword stop gifs
FloatingGhost [Sat, 29 Oct 2022 21:08:18 +0000 (22:08 +0100)]
Reword stop gifs

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

2 years 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>
2 years 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.

2 years 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

2 years 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.

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

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

2 years 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

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

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

2 years 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

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

2 years 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

2 years 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

2 years 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

2 years 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

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

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

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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>
2 years 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

2 years 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.

2 years 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.

2 years 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

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

2 years 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

2 years 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

2 years 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

2 years 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>