Updates django-q and add optional setproctitle to allow display

Minor logging updates

Extends the cleanup of image versions to the library images and all the registry cache images as well

Merge pull request #1566 from paperless-ngx/fix/issue-1564

Fix document comments not updating on document navigation

Fix live updating of comments on doc change

Remove user dropdown border

Update messages.xlf

Updates version string to 1.9.0-rc1

Signed-off-by: Trenton Holmes <holmes.trenton@gmail.com>

Merge branch 'main' into beta

New Crowdin updates (#1295)

Squashed commit of Crowdin updates

Co-authored-by: shamoon <4887959+shamoon@users.noreply.github.com>

Merge pull request #543 from bckelly1/feature-mariadb-support

Feature: Add MariaDB support

Ensures the Pipfile.lock hash is up to date

Removes optipng, added in a bad merge

Fixes the shellcheck issues

Combines the two database folders to a single variable during installation

Fully qualifies the image and updates to Redis 7

Adds the mysql Python dependency

re-order apt dependencies

correct the mariadb volume data path

set paperless db user

remove debug image reference

rebase mariadb feature onto dev

Include storage path in exporter + tests

Merge pull request #1551 from paperless-ngx/chore-settings-cleanup

Chore: Cleanup and validate settings

Adds validation and testing to cover some of the common settings

Fixes a minor TODO in settings, and enables flake8 for settings.py

Bump pikepdf from 5.5.0 to 5.6.1

Bumps [pikepdf](https://github.com/pikepdf/pikepdf) from 5.5.0 to 5.6.1.
- [Release notes](https://github.com/pikepdf/pikepdf/releases)
- [Commits](https://github.com/pikepdf/pikepdf/compare/v5.5.0...v5.6.1)

---
updated-dependencies:
- dependency-name: pikepdf
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>

Decrease the final size of the images containing .deb and .whl files

Bump black from 22.6.0 to 22.8.0

Bumps [black](https://github.com/psf/black) from 22.6.0 to 22.8.0.
- [Release notes](https://github.com/psf/black/releases)
- [Changelog](https://github.com/psf/black/blob/main/CHANGES.md)
- [Commits](https://github.com/psf/black/compare/22.6.0...22.8.0)

---
updated-dependencies:
- dependency-name: black
  dependency-type: direct:development
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>

Bump tqdm from 4.64.0 to 4.64.1

Bumps [tqdm](https://github.com/tqdm/tqdm) from 4.64.0 to 4.64.1.
- [Release notes](https://github.com/tqdm/tqdm/releases)
- [Commits](https://github.com/tqdm/tqdm/compare/v4.64.0...v4.64.1)

---
updated-dependencies:
- dependency-name: tqdm
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>

Bump pytest from 7.1.2 to 7.1.3

Bumps [pytest](https://github.com/pytest-dev/pytest) from 7.1.2 to 7.1.3.
- [Release notes](https://github.com/pytest-dev/pytest/releases)
- [Changelog](https://github.com/pytest-dev/pytest/blob/main/CHANGELOG.rst)
- [Commits](https://github.com/pytest-dev/pytest/compare/7.1.2...7.1.3)

---
updated-dependencies:
- dependency-name: pytest
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #1528 from erikarvstedt/docs-fix-variable-defaults

docs/configuration: Fix binary variable defaults

docs/configuration: Fix binary variable defaults

Bump tj-actions/changed-files from 24 to 29.0.2

Bumps [tj-actions/changed-files](https://github.com/tj-actions/changed-files) from 24 to 29.0.2.
- [Release notes](https://github.com/tj-actions/changed-files/releases)
- [Changelog](https://github.com/tj-actions/changed-files/blob/main/HISTORY.md)
- [Commits](https://github.com/tj-actions/changed-files/compare/v24...v29.0.2)

---
updated-dependencies:
- dependency-name: tj-actions/changed-files
  dependency-type: direct:production
  update-type: version-update:semver-major
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #1500 from paperless-ngx/feature-gunicorn-tune

Bugfix: Better gunicorn settings for workers

Merge pull request #1502 from paperless-ngx/dependabot/npm_and_yarn/src-ui/dev/angular/cli-14.2.1

update jest-preset-angular

update angular core

update angular cli

Bump @angular/cli from 14.1.0 to 14.2.1 in /src-ui

Bumps [@angular/cli](https://github.com/angular/angular-cli) from 14.1.0 to 14.2.1.
- [Release notes](https://github.com/angular/angular-cli/releases)
- [Changelog](https://github.com/angular/angular-cli/blob/main/CHANGELOG.md)
- [Commits](https://github.com/angular/angular-cli/compare/14.1.0...14.2.1)

---
updated-dependencies:
- dependency-name: "@angular/cli"
  dependency-type: direct:development
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #1507 from paperless-ngx/dependabot/npm_and_yarn/src-ui/dev/jest-environment-jsdom-29.0.1

Bump jest-environment-jsdom from 28.1.3 to 29.0.1 in /src-ui

Bump jest-environment-jsdom from 28.1.3 to 29.0.1 in /src-ui

Bumps [jest-environment-jsdom](https://github.com/facebook/jest/tree/HEAD/packages/jest-environment-jsdom) from 28.1.3 to 29.0.1.
- [Release notes](https://github.com/facebook/jest/releases)
- [Changelog](https://github.com/facebook/jest/blob/main/CHANGELOG.md)
- [Commits](https://github.com/facebook/jest/commits/v29.0.1/packages/jest-environment-jsdom)

---
updated-dependencies:
- dependency-name: jest-environment-jsdom
  dependency-type: direct:development
  update-type: version-update:semver-major
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #1506 from paperless-ngx/dependabot/npm_and_yarn/src-ui/dev/types/node-18.7.14

Bump @types/node from 18.6.3 to 18.7.14 in /src-ui

Bump @types/node from 18.6.3 to 18.7.14 in /src-ui

Bumps [@types/node](https://github.com/DefinitelyTyped/DefinitelyTyped/tree/HEAD/types/node) from 18.6.3 to 18.7.14.
- [Release notes](https://github.com/DefinitelyTyped/DefinitelyTyped/releases)
- [Commits](https://github.com/DefinitelyTyped/DefinitelyTyped/commits/HEAD/types/node)

---
updated-dependencies:
- dependency-name: "@types/node"
  dependency-type: direct:development
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #1505 from paperless-ngx/dependabot/npm_and_yarn/src-ui/dev/angular-builders/jest-14.0.1

Bump @angular-builders/jest from 14.0.0 to 14.0.1 in /src-ui

Bump @angular-builders/jest from 14.0.0 to 14.0.1 in /src-ui

Bumps [@angular-builders/jest](https://github.com/just-jeb/angular-builders/tree/HEAD/packages/jest) from 14.0.0 to 14.0.1.
- [Release notes](https://github.com/just-jeb/angular-builders/releases)
- [Changelog](https://github.com/just-jeb/angular-builders/blob/master/packages/jest/CHANGELOG.md)
- [Commits](https://github.com/just-jeb/angular-builders/commits/@angular-builders/jest@14.0.1/packages/jest)

---
updated-dependencies:
- dependency-name: "@angular-builders/jest"
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #1504 from paperless-ngx/dependabot/npm_and_yarn/src-ui/dev/zone.js-0.11.8

Bump zone.js from 0.11.7 to 0.11.8 in /src-ui

Bump zone.js from 0.11.7 to 0.11.8 in /src-ui

Bumps [zone.js](https://github.com/angular/angular/tree/HEAD/packages/zone.js) from 0.11.7 to 0.11.8.
- [Release notes](https://github.com/angular/angular/releases)
- [Changelog](https://github.com/angular/angular/blob/main/packages/zone.js/CHANGELOG.md)
- [Commits](https://github.com/angular/angular/commits/zone.js-0.11.8/packages/zone.js)

---
updated-dependencies:
- dependency-name: zone.js
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #1494 from paperless-ngx/dependabot/npm_and_yarn/src-ui/dev/ngx-color-8.0.2

Bump ngx-color from 8.0.1 to 8.0.2 in /src-ui

Bump ngx-color from 8.0.1 to 8.0.2 in /src-ui

Bumps [ngx-color](https://github.com/scttcper/ngx-color) from 8.0.1 to 8.0.2.
- [Release notes](https://github.com/scttcper/ngx-color/releases)
- [Commits](https://github.com/scttcper/ngx-color/compare/v8.0.1...v8.0.2)

---
updated-dependencies:
- dependency-name: ngx-color
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #1496 from paperless-ngx/dependabot/npm_and_yarn/src-ui/dev/cypress-10.7.0

Bump cypress from 10.3.1 to 10.7.0 in /src-ui

Bump cypress from 10.3.1 to 10.7.0 in /src-ui

Bumps [cypress](https://github.com/cypress-io/cypress) from 10.3.1 to 10.7.0.
- [Release notes](https://github.com/cypress-io/cypress/releases)
- [Changelog](https://github.com/cypress-io/cypress/blob/develop/.releaserc.base.js)
- [Commits](https://github.com/cypress-io/cypress/compare/v10.3.1...v10.7.0)

---
updated-dependencies:
- dependency-name: cypress
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #1495 from paperless-ngx/dependabot/npm_and_yarn/src-ui/dev/cypress/schematic-2.1.1

Bump @cypress/schematic from 2.0.0 to 2.1.1 in /src-ui

Merge pull request #1498 from paperless-ngx/dependabot/npm_and_yarn/src-ui/dev/popperjs/core-2.11.6

Bump @popperjs/core from 2.11.5 to 2.11.6 in /src-ui

Tweaks gunicorn to preload the app and use shared memory for temporary fs

Bump @popperjs/core from 2.11.5 to 2.11.6 in /src-ui

Bumps [@popperjs/core](https://github.com/popperjs/popper-core) from 2.11.5 to 2.11.6.
- [Release notes](https://github.com/popperjs/popper-core/releases)
- [Commits](https://github.com/popperjs/popper-core/compare/v2.11.5...v2.11.6)

---
updated-dependencies:
- dependency-name: "@popperjs/core"
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>

Bump @cypress/schematic from 2.0.0 to 2.1.1 in /src-ui

Bumps [@cypress/schematic](https://github.com/cypress-io/cypress) from 2.0.0 to 2.1.1.
- [Release notes](https://github.com/cypress-io/cypress/releases)
- [Changelog](https://github.com/cypress-io/cypress/blob/develop/.releaserc.base.js)
- [Commits](https://github.com/cypress-io/cypress/compare/@cypress/schematic-v2.0.0...@cypress/schematic-v2.1.1)

---
updated-dependencies:
- dependency-name: "@cypress/schematic"
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #1492 from paperless-ngx/feature-imap-utf-improve

Feature: Simplify IMAP login for UTF-8

Updates imap_tools and updates to use the new login method for UTF-8

Info about installing on subpath (#1350)

* Update docker-compose.env

* Update configuration.rst

example.com/paperless is not a subdomain, but a subpath. Also when hosting from a subdomain like paperless.example.com one does not have to change anything in the configuration, it just works, because paperless expects to be hosted at root, i.e. paperless.example.com
This however changes when paperless is not hosted at root anymore but for example at paperless.example.com/paperlessNgx

* Update docker-compose.env

* Apply suggestions from code review

Co-authored-by: shamoon <4887959+shamoon@users.noreply.github.com>

Merge pull request #1488 from paperless-ngx/fix/tasks-table-actions

Fix actions button in tasks table

Fix actions button in tasks table

Merge pull request #1482 from paperless-ngx/move-scanners-to-wiki

Docs: move scanner & software recs to GH wiki

Move scanner & software recs to GH wiki

Merge pull request #1467 from tooomm/patch-1

Docs: Update mobile scanner section

update mobile scanner section

Merge pull request #1463 from paperless-ngx/fix/issue-1462

Fix: Add missing filter rule types to SavedViewFilterRule model & fix migrations

Fix 1023, 1024 migrations, add savedviewfilterrule migration

Add missing filter rule types to SavedViewFilterRule model

And add note to filter-rule-type.ts

Merge pull request #1451 from paperless-ngx/feature-better-redo-ocr

Feature: Even better re-do of OCR

Merge pull request #1375 from tim-vogel/add_comments

Feature: document comments

Merge pull request #1367 from Eckii24/feat/date-suggestions

Adding date suggestions to the documents details view

Locks scipy to 1.8.1, allows some other minor version updates

Revert "Bump sphinx from 5.0.2 to 5.1.1"

Merge pull request #1460 from paperless-ngx/fix/paperless-conf-typo

Fix paperless.conf.example typo

Fix minor duplicate/incorrect conf key

Merge pull request #1297 from paperless-ngx/dependabot/pip/dev/sphinx-5.1.1

Bump sphinx from 5.0.2 to 5.1.1

Merge pull request #1301 from paperless-ngx/fix-release-drafter

[CI] Fix release drafter issues

Merge pull request #1421 from paperless-ngx/feature-consumer-event-driven

Feature: Event driven consumer

Default PAPERLESS_NUMBER_OF_SUGGESTED_DATES to 3

Merge pull request #1442 from paperless-ngx/fix/skip-archive-still-archiving

Bugfix: Fixes the creation of an archive file, even if noarchive was specified

Fix CodeQL warnings

Finalizes testing of the delete comment

Starts on implementing tests for the new API

Merges the migration branches

Basic verification of Comment export & exporter comment tuple fix

From oprhaned commits https://github.com/paperless-ngx/paperless-ngx/commit/b1855a4b7af689d0a7c7f18bf7ef513967da269f
https://github.com/paperless-ngx/paperless-ngx/commit/53f21574fd8af0f3561c12f709a14980f8f1cb7f

Co-Authored-By: Trenton Holmes <797416+stumpylog@users.noreply.github.com>

Add frontend tests for comments

docs: scanners: add Brother ads4700w

I've tested Paperless with the ADS-4700W and it works great.

This commit adds the recommendation.

Update messages.xlf

Move add comment to top of comments list

Cleanup frontend comment service & other code

[ci skip]

Rework comment UI

Add error popups, text field validation, move form, move comment header to footer, updated styling

python code style

Refactor comment UI code

And run prettier

fix migration dependency

and run code style

Missed PAPERLESS_COMMENTS_ENABLED code

Remove faux test file

Fix comment service method signature

and run prettier over file

Remove faux testing file

Use frontend settings instead of env variable