Mercurial > p > roundup > code
view doc/postgresql.txt @ 6519:22cf6ee7ad88
jwt issue example: require input data, lowercase roles
If content-type is not supplied, input data will not be parsed. As a
result the JWT has the user's assigned roles. Prevent this.
Also lowercase all roles supplied in the input payload so "User", "user"
and "useR" all match the case insensitive "user" role.
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Sat, 30 Oct 2021 23:18:01 -0400 |
| parents | ba82fb74f806 |
| children | a0a100453eb9 |
line wrap: on
line source
.. index:: postgres; deployment notes ========================== PostgreSQL/psycopg Backend ========================== This are notes about PostqreSQL backend based on the psycopg adapter for Roundup issue tracker. Prerequisites ============= To use PostgreSQL as backend for storing roundup data, you should additionally install: 1. PostgreSQL 8.x or higher - https://www.postgresql.org/ 2. The psycopg python interface to PostgreSQL: https://www.psycopg.org/ Running the PostgreSQL unit tests ================================= The user that you're running the tests as will need to be able to access the postgresql database on the local machine and create and drop databases. See the config values in 'test/db_test_base.py' about which database connection, name and user will be used. Credit ====== The postgresql backend was originally submitted by Federico Di Gregorio <fog@initd.org>