[odrs-web] (336 commits) Non-fast-forward update to branch oscp

[Richard Hughes <rhughes src gnome org>]

The branch 'oscp' was changed in a way that was not a fast-forward update.
NOTE: This may cause problems for people pulling from the branch. For more information,
please see:

 https://wiki.gnome.org/Git/Help/NonFastForward

Commits removed from the branch:

  961dcbc... Prepare the field to deploy odrs on OSCP
  9f5edf6... git's not needed
  1bd20c5... Drop the additional RUN
  b44bb69... Run as user 1001
  064b098... bash's not installed
  a60ec03... Port bind changes + mod_ssl
  0aae227... s/ROOT/root
  2c2b987... Missing closing parenthesis
  ae053a8... Path fixes here as well
  53664e9... Minor fixes
  e2ec33f... User should be odrs, adjust permissions for sed to work as 
  5ee429a... Needs a group created as well
  773e421... Additional permissions. Load mod_expires
  f07a8ac... Typo
  60a2ca6... Additional permissions
  c389561... Disable logging
  660c6ee... Missing closing parenthesis
  90c8211... Wide permissions on the logs dir
  2d6ca41... Temp comment
  2986066... Set a ServerName
  a3ac3bc... Only enable errorlog
  e6920d6... The opposite :)
  a4d6633... Disable the default mod_ssl vhost
  fa05dcc... Working sed calls
  2f251da... Comment out all the lines we do not need. Also chown to the
  97ca7f4... These should be good to go now
  1ae79a4... Additional permissions fixes. Move entrypoint over to /usr/
  1d3adcc... Missing && :)
  0d8c563... Install strace
  ebb8e06... Modify the start command for httpd
  babaaf5... Workaround a mod_wsgi crash
  a5abe53... Revert "Workaround a mod_wsgi crash"
  88b32aa... Revert "Revert "Workaround a mod_wsgi crash""
  674ab65... Revert "Modify the start command for httpd"
  8129c89... Rebase the branch to use a different docker image (centos/h
  0a3129d... httpd and mod_ssl come preinstalled
  b00a48c... One liner
  9f40070... Make use of scl_source
  a7987ca... This image ships with uid 1001 by default
  a4fe29c... Use the uid as specified on oc describe project and let mod
  322bba4... Remove welcome.conf
  dd4ffde... Land proper permissions for the wsgi script
  9bd2ba0... Move app files over to container's APP_HOME
  db7805b... This should be sufficient
  8fd941c... And then they figured the app is no py3 ready yet :)
  c4a7450... Why I keep forgetting you?!
  b4862a2... Python 2 ships with RPMs for the reqs we need
  c501d20... Missing runtime dependency
  8287af5... And some leftovers
  ed830bb... Adjust the static directory according to what the container
  2743a31... Temp workaround to access httpd log files
  3d93eaa... Temp run as root for debugging purposes
  735374c... Put the wsgi file on the same directory as the app folder
  1f7c173... Revert "Put the wsgi file on the same directory as the app 
  987d50b... Use ODRS_HOME as the path wsgi should follow to import the 
  de1e2d5... Set an error log for the vhost as well
  2204685... Increase loglevel
  9f58fd9... And move the wsgi file back to the vhost root (again)
  967e38f... Permissions for the relevant directory are missing
  f958dbb... Revert "Permissions for the relevant directory are missing"
  93b363c... Revert "And move the wsgi file back to the vhost root (agai
  fc2dddd... Install mysql client (debug)
  0caf107... Replace env variables names
  8cf6e4a... Widening the exception class for debugging purposes
  e2ca8b4... Kill 000-default.conf and use FQDN.conf instead
  f0487ef... Previous commit needed an adjustement here as well
  18488e3... Set shebang to python2
  c890785... Go match the variable name odrs expects
  caae1d1... Whenever a review has not been deleted it reports a date of
  88afa65... Debugging completed, restore configuration
  e695bcb... Land a cronjob for the daily ratings stats
  13ae947... s/USER/USERNAME
  adbf7cb... The json should end up on the static dir
  e0822eb... And on the cronjob as well!
  89bf38c... Don't even attempt to use cron, go for a while loop instead
  0f6f6f2... Import changes from the master branch
  71eeaeb... Migrate to Deneb theme
  1b7db30... Grid layout changes for admin page
  428d68b... Make inputs shorter on admin's area
  3b73443... Merge changes from master
  0acce3c... The entrypoint file is not needed anymore
  c7bc0a4... Add a doap file
  40757b6... Convert to Python 3 and fix some pylint warnings
  f9c0912... Use short form SPDX license IDs in all source files
  b7e6957... Split out a file to avoid a traceback in the admin panel
  5fbc21c... Rename the Flask project directory to 'odrs'
  fc7e25e... Add a simple Makefile which allows us to run the ODRS local
  33f2e3b... Convert everything to sqlalchemy and add lots of nice unit 
  c3a69df... Use flash in more places in the admin view
  f62720f... Only show reviews with more than one report
  c68bcfa... Automatically delete reviews marked for deletion over one m
  c60ba6d... Fix up the '0000-00-00 00:00:00' review datetime misconfigu
  cefd9a9... Allow db upgrade
  c1e995e... Disable stats collection
  b4b1c92... Disable all the fetch counts
  57cc27f... Don't rely on ODRS_REVIEWS_SECRET being in config
  c7c0bac... Restore the Analytic duplicate handling
  2c9f080... Install the MariaDB tools in the container too
  2278987... Use the email address as the account username
  f02dd8a... Use actual sqlalchemy boolean types
  2f547f7... Use a 40-char string for the user_hash
  e57e628... Add a user_id foreign key to all tables
  de7c44d... Drop the duplicate user_hash table rows
  e5a5c81... trivial: Remove two FIXMEs that now are not valid
  f467821... Return reviews with less than 2 reports by default
  4543a93... Fix banning users from the review page
  c54308b... Add a foreign key for the votes table back to the review it
  2380df8... Ensure votes get deleted when the review is deleted
  b38344e... Delete the users reviews if they are banned
  b7ddac6... Make the per-review page nicer on the eye
  80538fc... Save a hashed version of the reviewers IP address
  0e0c4a1... Add some primitive search functionality
  0d351d6... Allow moderators to add per-locale banned words
  6b6e4c5... Fix showing all the reviews for a specific user
  98f2d05... Make the list of reviews nicer on the eye
  7568cb7... Show the number of reviews from the user before deleting
  ed294ab... trivial: Fix cron help output
  d9e007f... Add taboo severity and export to JSON
  0a15d5e... Deduplicate the app_id values in the reviews table
  eaa0229... Update the app_id fetch count when revews are requested
  da37ca3... Remove the now-unused app_id column from the reviews table
  25d2787... Allow deleting and joining components
  1f01fbf... Fix a backtrace seen when merging components
  998d6fc... Fix another backtrace when getting the list of reviews
  a5ea6ba... Do not try to emulate UPSERT for components
  6ba1a28... Get the latest flathub provides list at build time
  dd1cc87... Break a circular dependency when reparenting components
  26dbb82... Never try to adopt a component to itself
  9c0e17c... Use the component duplicates when getting app reviews or ra
  9cf3be3... Get the latest badword list when building
  e136e71... Dedupe the list of components whenever we check the databas
  543abc6... Merge in the users section into stats
  3b13501... Merge in the distros section into stats
  3278fb5... Never allow zero sized reviews
  308f0f4... trivial: Fix a backtrace when adding a moderator
  17ebae2... Enable moderator accounts by default
  c48adcb... trivial: Fix a test regression introduced in 9b031d
  9db889a... trivial: Fix the MySQL example for new versions
  10584ce... trivial: Fix a traceback when logging in as a new moderator
  5ab1de1... Be explicit with Python requirements
  052c268... trivial: Use a more standard Python binary name
  74469c7... trivial: Change the Dockerfile to use python3 too
  ee9b4cf... trivial: Use new flathub download link
  2c314ca... Prevent crash when moderators have no password set
  6d302ed... trivial: Force the various IDs to be integers
  6c6e715... Allow moderators to change thier own passwords
  13c5ca8... Allow moderators to search for specific keywords
  fabae04... Revert "Allow moderators to change thier own passwords"
  2ce02cb... Make a few make commands more robust on different systems
  8ee71f4... Fix the taboo API docstring
  9c17f39... Correct the DOAP license link
  317867e... Fix typo in sentence about not making typos
  499cc99... trivial: Fix inconsistencies in license information
  f5f0ec7... Boost recent reviews and decay old ones
  ac37eb2... Attempt to fix backtrace
  18565b2... trivial: Ignore some pylint warnings

Commits added to the branch:

  528604f... Initial commit (*)
  b5996ab... Add the start of a flask webapp (*)
  16ce7bc... Implement a simple ratings server (*)
  09cf383... Add some files required for OpenShift (*)
  4caf099... Split up the post and get actions (*)
  7fbe0cb... Up and downvote using a JSON POST (*)
  0ab9869... Add ratings and event log functionality (*)
  ad9018c... Support a 'thick' review query (*)
  ecf6358... Allow removing reviews (*)
  1a7440e... Match expectations with the client tool (*)
  a23a95e... Change how users are added to please MySQL (*)
  0f1ba2d... Use rhc to set env vars (*)
  59d927d... trivial: Fix backtrace when getting ratings of things not i (*)
  5c192f9... trivial: Check that required data is not just NULL (*)
  a36ebd9... Return a fake review for applications without reviews (*)
  d408fe8... Break API and make database IDs have sensible names (*)
  aed17e8... trivial: Fix getting event log data (*)
  6d78eb1... trivial: Do not log ratings requests (*)
  34f5f1e... trivial: Check the length of the hash strings (*)
  3632eca... Add a way to ban specific users (*)
  f206957... Allow users to downvote reviews (*)
  dff9821... Log when reviews are created (*)
  89f6ea8... Allow dismissing a review when moderating (*)
  5bd0071... trivial: Add missing images (*)
  e2a5783... Make the app_id a field in the event log (*)
  f2dd386... List application fetch stats (*)
  ffe1926... Limit the list of popular apps (*)
  e0ac117... Add OARS generator example (*)
  7b79c6d... Add two more attributes (*)
  7a39e3e... Add language-discrimination (*)
  5c9419d... Fix oars descriptions (*)
  b8b69a8... Give the service a new name (*)
  29b7211... Move the README info from the html to markdown (*)
  bb5ea25... Show some analytics for the server usage (*)
  0174c95... trivial: Add missing static files (*)
  4c2fd91... Show the per-user count on the analytics page (*)
  397a6ac... trivial: Fix import ordering for pylint (*)
  2a55d25... trivial: Remove two FIXMEs (*)
  f327055... Add newrelic module (*)
  fdb3882... Don't query all tables at startup (*)
  1967f46... Don't disallow moderation because of positive karma being u (*)
  03bc3ea... Remove date_request from the SQL (*)
  d3f1083... Fix crash when getting users (*)
  7b06a82... Allow reviews to be submitted with UTF-8 chars (*)
  1e6b24c... trivial: Fix updating the user karma value (*)
  c1142bc... Add notes for backup (*)
  a71d9dd... trivial: Change the name of the env variable (*)
  583a7c5... trvial: Rename database (*)
  dfabae0... Don't traceback on broken UTF-8 (*)
  6039a7c... Don't get the event log data for the analytics page (*)
  1767bed... Don't show a huge event log, ever (*)
  115a597... trivial: Don't be helpful on the index page, bots are not f (*)
  67c3d44... Make compatable with Python3 (*)
  013029b... trivial: More top applications please (*)
  03eb786... trivial: Tiny addition to the README (*)
  3d1df56... Show the number of locales in the status page (*)
  4f0fe03... Show the locale in the all status page (*)
  86050f9... Start newrelic module (*)
  c136c07... Speed up getting the eventlog stats (*)
  deb0388... Use UTF-8 for json requests (*)
  870adbe... trivial: Fix up some backup code in README (*)
  830c67d... Show apps my review count too (*)
  2c95464... Revert "Start newrelic module" (*)
  c3d2eec... trivial: Make easier to C&P (*)
  4299d60... Allow modifying reviews (*)
  5b1e347... Add a start towards a login system (*)
  3b7d4ca... Get logins from the database (*)
  401adc2... Split up the API and admin functions into two blueprints (*)
  8d85756... trivial: Split up the graphs into different pages (*)
  1bd06db... Split out popularity from stats (*)
  ba33027... Use a proper object for events and reviews (*)
  556ee5b... Only show review action buttons when logged in (*)
  4352fa0... Don't inject HTML using dyncontent any more (*)
  2cd7a50... Show reported reviews (*)
  a114d7d... Support showing all reviews from a specific user (*)
  6c9baad... Allow deleting reviews (*)
  a32bb03... trivial: Make navigation more spaced out (*)
  e1d2074... trivial: Remove some debugging left in (*)
  be20869... Allow reviews to be unreported (*)
  c8ce3cc... Allow going backwards and forwards in the review view (*)
  ed76be5... Make deleting accidentally more difficult (*)
  9452b81... Add a button to easily Englishify a review (*)
  83d2115... trivial: Fix last patch so it works on all browsers (*)
  900602d... trivial: Install missing file (*)
  7c7a981... Add a view to show reported reviews (*)
  8c5c0bb... Move some of the README content to the index page (*)
  ad09ac8... Only show the Englishify button when logged in (*)
  86a180a... Show a nicer page for no results (*)
  1bf1414... Rename the API implementation to have the version in the na (*)
  a34952c... Show how many unique apps we have in the stat page (*)
  3f93078... Add a way to get all the ratings in one API call (*)
  4294848... Fix a crash when removing a review (*)
  c0e4e64... Allow modifying the userhash (*)
  c533118... Allow unremoving reviews (*)
  285e913... Add a admin-only graph for each distro (*)
  f01d19f... Add filtering by more types (*)
  076de8d... trivial: Fix unremoving reviews (*)
  d7ab663... Add stats about users (*)
  5d48ea2... trivial: Remove unused import (*)
  0cbb949... trivial: Fix flask aborting (*)
  e1845a7... Use pagination when showing all the reviews (*)
  d2aa2b6... Make the reviews list less wide by merging columns (*)
  737a1a7... trivial: Only show unreport if authenticated (*)
  b310616... Do not show users reviews that do not match their lang code (*)
  76f188f... trivial: Show the spread of ratings on the stats page (*)
  956ed4c... trivial: Do not limit on karma when fetching results (*)
  257c719... Use a Wilson score to sort the reviews by karma (*)
  5e6eca2... Support limiting the moderator queue by language (*)
  d5d99bd... trivial: Put dates in the backup filename (*)
  d4ccffd... Do not store generic user_display values (*)
  98cf149... Use a new 'analytics' table (*)
  d0b80e3... trivial: Use two graphs for the different things (*)
  7d44e69... Fix the admin popularity page after the database cleanup (*)
  fe4755e... trivial: Remove warning (*)
  9dd784b... trivial: Fix up a OARS description (*)
  c4386fd... Add a doap file (*)
  ddfe330... trivial: Fix up the DOAP file (*)
  51cdb34... trivial: Add MAINTAINERS file (*)
  0e30c27... Switch to a GNOME website theme (*)
  87b274d... trivial: Show links to the app reviews in the stats page (*)
  ed685fe... Add an wsgi file for mod_wsgi (*)
  0b6046d... Add path to wsgi file (*)
  cda5822... Use non-backwards compat table names for the migration (*)
  870912c... Move the schema to a different file (*)
  838c25a... Fix up the base ref (*)
  06c2c9a... trivial: Remove unused directory (*)
  5a693da... trivial: Remove unused file (*)
  1c981d6... trivial: Remove OpenShift specific file (*)
  8442acc... trivial: Remove OpenShift specifics (*)
  2084f0b... Do not use the config file for the openshift overrides (*)
  7acbe42... Remove another unused file (*)
  b642718... Use the new database env vars (*)
  e17082b... Hardcode less in the wsgi file (*)
  a4f946d... Set the environ keys from SetEnv (*)
  28b30f3... trivial: Use the ODRS hash as the session secret (*)
  e5013e1... Make compatible with python2 again (*)
  57e107c... Show the correct page on database failure (*)
  c296a66... Set the secret key earlier (*)
  5802d4b... Try harder to set the secret key (*)
  c9b1ace... trivial: Fix the distros graph on python2 (*)
  69b6850... trivial: Set the environ before importing (*)
  a332885... trivial: Fix the usage graphs (*)
  b390d91... trivial: Fix the distro graphs (*)
  ac94502... Fix traceback when printing a OdrsUser (*)
  27fb442... trivial: Allow reloading SQL schema (*)
  1634e5f... trivial: Make the OARS site work in Firefox (*)
  4be689c... trivial: Use flask_login as the new import name (*)
  03ae9d7... Use limit=0 for unlimited (*)
  d2372f5... Show the review number in the title (*)
  947020c... Add several more ignored user names (*)
  d2d4cbe... Do some more content filtering serverside (*)
  d9fbcda... Fix ordering of reviews - return the highest scores first (*)
  79ebdf0... Allow banning users from the admin panel (*)
  ca9ed72... trivial: Fix up some trivial pylint warnings (*)
  f1269b3... trivial: Limit the number of unmoderated reviews (*)
  f56c981... Add support for compat_ids when getting reviews (*)
  aaa772d... Move to a more flask-like project layout (*)
  9e6b60f... Revert "Move to a more flask-like project layout" (*)
  5cc6492... Do not use flask.ext.login (*)
  11665e3... Convert to a more flask-like structure (*)
  af3cda2... trivial: Try to make static images work (*)
  605b762... trivial: Fix static images harder (*)
  0a94b5f... trivial: Fix redirecting admin actions (*)
  3311ab9... trivial: Make longer varchars for app-ids (*)
  7e7ca6f... Add a moderator class that can take over from me (*)
  6107573... Allow specifying all locales (*)
  62490ca... trivial: Add guidelines for moderators (*)
  cba58cf... Make moderation easier (*)
  99d0ddb... trivial: Relax password requirements (*)
  a426932... trivial: Fix the moderator queue (*)
  83414c6... trivial: Don't try getting the value of something unset (*)
  662a7b3... trivial: Fix deleting reviews (*)
  e685a7e... trivial: Fix a typo to allow us to ban users (*)
  f7c1aaf... trivial: Fix typo (*)
  b6d666a... trivial: Redirect to the new OARS site (*)
  63f05a9... Use an index for the user_hash (*)
  13a88b1... Don't accept fetch requests with an empty app_id (*)
  93afa20... trivial: Clean up more event log actions (*)
  e874ac6... Add a robots.txt (*)
  2153943... Fix typo (*)
  0e68b6e... Properly return a sorted list upon /fetch (*)
  8615740... trivial: Remove app-id whitelisting on .desktop (*)
  d7677b3... Add a utility to generate the semi-static data in a cron jo (*)
  9b8a941... Add a privacy policy (*)
  0d6829f... Rebase master to what is going to be oscp-dev (*)
  b3c98c3... Modify default db name (*)
  090eacc... ServerName should be odrs-dev.g.o (*)
  5660b9b... Revert "ServerName should be odrs-dev.g.o" (*)
  670754c... Seems the ServerName is actually (really) needed (*)
  32ca95a... Migrate to Deneb theme (*)
  66804c8... Merge branch 'deneb-theme' into 'master' (*)
  d96731a... Don't even attempt to use cron, go for a while loop instead (*)
  42db882... Make inputs shorter on admin's area (*)
  6155128... Grid layout changes for admin page (*)
  bb2c34e... Move the vhost to its own directory to avoid sed permission (*)
  79477c9... id run (debugging) (*)
  d35ae32... s/id/pwd (further debugging) (*)
  d35f2a3... Temp comment (debugging) (*)
  b9c4160... sed (on run-httpd) won't run if /etc/httpd/conf is not chow (*)
  9408b1b... sed (on run-httpd) won't run if /etc/httpd/conf.d is not ch (*)
  55d5a2f... Now that conf.d has the perms we need for run-httpd, move t (*)
  35d3c01... Needed as we do not -R (*)
  50c1c77... Revert "Now that conf.d has the perms we need for run-httpd (*)
  f899f6d... Attempt to have odrs-dev set as default (*)
  dcd0ffd... Load sites.d before conf.d (*)
  c1a96cc... Missing &&, drop 00_, it should not be needed anymore (*)
  ed4d961... Seems httpd is still not happy about sites.d, revert using  (*)
  86fd685... Reading https://hub.docker.com/r/centos/httpd-24-centos7 he (*)
  d274f14... These are still needed (*)
  5e532f5... Move httpd* folders within app_data? (*)
  365f953... Drop these chowns (they shouldn't be needed, the image shou (*)
  6f9e8d6... Re-introduce the chowns, drop yum update (is it the culprit (*)
  540c3ad... The chown should run as the latest step (*)
  d1e2f61... Fix some pylint warnings (*)
  5caed8f... The entrypoint file is not needed anymore (*)
  3ac2179... Convert to Python 3 (*)
  579e8bb... Use short form SPDX license IDs in all source files (*)
  81d0006... Split out a file to avoid a traceback in the admin panel (*)
  e2b1feb... Rename the Flask project directory to 'odrs' (*)
  bd9a797... Install mod_wsgi harder (*)
  3a5598d... Revert "Install mod_wsgi harder" (*)
  68b110b... Actually install mod_wsgi now (*)
  f1e73d4... No WSGIPythonPath in VirtualHost (*)
  67b08d8... Add a simple Makefile which allows us to run the ODRS local (*)
  3156894... Convert everything to sqlalchemy and add lots of nice unit  (*)
  0d3ea7e... Set SQLALCHEMY_DATABASE_URI when deploying (*)
  522d364... Use flash in more places in the admin view (*)
  47d99ae... Only show reviews with more than one report (*)
  c0e394c... Fix up the '0000-00-00 00:00:00' review datetime misconfigu (*)
  3ed6ba5... Don't use sed for environ substitution (*)
  b297d07... Using {ENV:FOO} does not work with uwsgi (*)
  f448468... trivial: Fix path (*)
  fe23ff2... Automatically delete reviews marked for deletion over one m (*)
  2e771cd... Add missing generated files required for db stamp and db up (*)
  847b6e6... Fix pylint false-positive (*)
  51462f1... trivial: Unbreak the cron ratings script (*)
  f402857... Allow recoving from database up->down->up (*)
  3c56b35... Use UTC when comparing datetime (*)
  fa3e93e... Don't rely on ODRS_REVIEWS_SECRET being in config (*)
  9ba1759... Fix app stats collection (*)
  c0a2ea1... Install the MariaDB tools in the container too (*)
  a705eb3... Use the email address as the account username (*)
  3048974... Use actual sqlalchemy boolean types (*)
  ea5fb3e... Use a 40-char string for the user_hash (*)
  2baf922... Add a user_id foreign key to all tables (*)
  a5c9bc7... Allow the alembic migration to fail when deploying (*)
  3272b88... Drop the duplicate user_hash table rows (*)
  6ad8ea5... trivial: Remove two FIXMEs that now are not valid (*)
  0551497... Return reviews with less than 2 reports by default (*)
  61b4f1b... Fix banning users from the review page (*)
  242a6a9... Add a foreign key for the votes table back to the review it (*)
  72afbe2... Ensure votes get deleted when the review is deleted (*)
  3f3aa37... Delete the users reviews if they are banned (*)
  0fc53c5... Make the per-review page nicer on the eye (*)
  e9d59bb... Save a hashed version of the reviewers IP address (*)
  36ea01e... Add some primitive search functionality (*)
  20798b0... Add missing file (*)
  03d57d7... Allow moderators to add per-locale banned words (*)
  bc38aee... Fix showing all the reviews for a specific user (*)
  178ac97... Make the list of reviews nicer on the eye (*)
  4ee17e1... Show the number of reviews from the user before deleting (*)
  89f1cb5... trivial: Fix cron help output (*)
  a4fd01a... Add taboo severity and export to JSON (*)
  5e0b9b5... Deduplicate the app_id values in the reviews table (*)
  01d2916... Add the foreign key after the tables have been repaired (*)
  505d898... Actually port the cron script over to use component (*)
  a42f7a3... Update the app_id fetch count when revews are requested (*)
  49c90bc... Remove the now-unused app_id column from the reviews table (*)
  58dd5b0... Allow deleting and joining components (*)
  999dd01... Fix a backtrace seen when merging components (*)
  058fb08... Fix another backtrace when getting the list of reviews (*)
  cee1e87... Do not try to emulate UPSERT for components (*)
  1346499... Get the latest flathub provides list at build time (*)
  a2be1e5... Break a circular dependency when reparenting components (*)
  a155ddb... Never try to adopt a component to itself (*)
  ca2b7a9... Use the component duplicates when getting app reviews or ra (*)
  067f6af... Get the latest badword list when building (*)
  173b0b2... Dedupe the list of components whenever we check the databas (*)
  ae924c5... Merge in the users section into stats (*)
  6a92f62... Merge in the distros section into stats (*)
  9111d0a... Never allow zero sized reviews (*)
  ca555ef... trivial: Fix a backtrace when adding a moderator (*)
  9b031db... Enable moderator accounts by default (*)
  2b3eac1... trivial: Fix a test regression introduced in 9b031d (*)
  a122ab9... Set the LoginManager view function for login (*)
  a4b674e... Protect all forms against CSRF (*)
  a9bc809... 0 used to be an acceptable value (*)
  8352511... Make it possible to fetch from a starting point (*)
  308b6a4... Add tests (*)
  742b764... trivial: Fix the MySQL example for new versions (*)
  abfa7b5... trivial: Fix a traceback when logging in as a new moderator (*)
  bb75dce... Be explicit with Python requirements (*)
  f21af73... trivial: Use a more standard Python binary name (*)
  808f0b3... trivial: Change the Dockerfile to use python3 too (*)
  9e02b67... trivial: Use new flathub download link (*)
  9149f34... Prevent crash when moderators have no password set (*)
  a7a4450... trivial: Force the various IDs to be integers (*)
  0da70d7... Allow moderators to search for specific keywords (*)
  2ea83c3... Make a few make commands more robust on different systems (*)
  8a7b8eb... Fix the taboo API docstring (*)
  3b58471... Correct the DOAP license link (*)
  674e1cd... Fix typo in sentence about not making typos (*)
  05f8150... Merge branch 'minor-fixes' into 'master' (*)
  4320536... Merge branch 'bug/typo' into 'master' (*)
  1f7abe3... Merge branch 'limits' into 'master' (*)
  221c974... trivial: Fix inconsistencies in license information (*)
  c3ccefe... Boost recent reviews and decay old ones (*)
  40e8b0a... Merge branch 'boost-recent-reviews' into 'master' (*)
  794c546... app_data: Switch from freenode to libera.chat (*)
  c17dae6... Merge branch 'freenode' into 'master' (*)
  4548b66... odrs: Rename HTTP request data to request_item (*)
  8830991... odrs: Generate user_skey from the response app_id (*)
  b13d01c... Attempt to fix backtrace (*)
  a0a3bfe... trivial: Ignore some pylint warnings (*)
  c7ab55c... Uprev all deps to latest versions (*)
  f1b4fed... Allow db upgrade (*)
  73db47e... Revert "Add tests" (*)
  908b429... Install more deps from pip for RHEL 7 (*)
  89eead6... Install mysqlclient (*)
  c65fcd5... Merge branch 'user_skey-fixes2' into 'master' (*)
  92fbc07... Remove /admin/show/unmoderated as its just not helpful (*)
  9eb8356... Do not require CSRF for API requests (*)
  9b0bb69... Add a delete button to the overview page (*)
  3a453e3... Remove the /all endpoint (*)
  8c63649... Generate user_skey from the response app_id, harder (*)
  f077fe5... odrs: Add caching support to fetch and ratings endpoints (*)
  7f98744... httpd: Apply public caching to ratings.json too (*)
  7842ea9... httpd: Support content encoding and pre-compressed forms of (*)
  d2b7d79... Fix gzip for RHEL-7 (*)
  33ee60a... Install brotli (*)
  5d46327... Fix setting the cache control property (*)
  f5a3947... Remove the pubic Taboo endpoint as it's a liability (*)
  25cb4bf... Another gzip -k fix for RHEL 7 (*)
  d2d8a89... Blacken the codebase (*)
  7e785de... Codespell fixes (*)
  fbe9604... Fix the ServerName for the actual prod instance

(*) This commit already existed in another branch; no separate mail sent