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>

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

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 #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 #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

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

add comment function

typo

Bump sphinx from 5.0.2 to 5.1.1

Bumps [sphinx](https://github.com/sphinx-doc/sphinx) from 5.0.2 to 5.1.1.
- [Release notes](https://github.com/sphinx-doc/sphinx/releases)
- [Changelog](https://github.com/sphinx-doc/sphinx/blob/5.x/CHANGES)
- [Commits](https://github.com/sphinx-doc/sphinx/compare/v5.0.2...v5.1.1)

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

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

Merge pull request #1446 from paperless-ngx/feature-storage-path-rematch

Feature: Adds storage paths to re-tagger command

Merge pull request #1440 from GwynHannay/feature-orig-filename-metadata

Feature: Preserve original filename in metadata

Merge pull request #1445 from paperless-ngx/library-deps-update

Chore: Bump Python dependencies

Implements a better re-do of OCR by making the document archiver function common.  Actually creates updated file now

Adds the storage paths to the re-tagger command

Also provide the original file name to the post consumption script

Bumps all library versions which are currently working

Add original filename to frontend doc detail metadata

format code

create migration for original filename

update files and model to include new field

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

adapt test to respect gmail_label keyword

fix debug output

Ignore tagged emails from gmail to avoid duplicated documents.

add test for gmail account tag handling

fix mail tests