Mercurial > p > roundup > code
annotate scripts/roundup.rc-debian @ 7719:3071db43bfb6
feat: issue2550852 - support using a specified PostgreSQL db schema
Finally after 7 years this is closed.
roundup/backends/back_postgresql.py:
Support use of schema when specified in RDBMS_NAME. Stuart McGraws
code is finally merged 8-).
test/test_postgresql.py, test/conftest.py:
Run all postgresql tests in the schema db as well.
Also make sure that db_nuke raises an error when trying to delete
the schema test database. Conftest defines pg_schema mark that can
be used to exclude schema tests with pytest -m "not pg_schema".
roundup/configuration.py:
change doc on RDBMS_NAME to include db.schema form.
.travis.yml, .github/workflows/ci-test.yml:
create schema test db; add user for testing with schema; grant new
user create privs for schema.
doc/installation.txt:
Reference to roundup-admin init deleting schema added.
doc/mysql.txt doc/postgresql.txt:
New documentation on psql/mysql commands to set up a production db.
doc/upgrading.txt:
mention schema support, also document service setting for
selecting connection from pg_service.conf.
doc/reference.txt:
update config.ini documentation for RDBMS_NAME.
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Wed, 27 Dec 2023 22:52:14 -0500 |
| parents | 6e3e4f24c753 |
| children |
| rev | line source |
|---|---|
|
1841
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
1 #!/bin/sh -e |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
2 # |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
3 # roundup Startup script for the roundup http server. |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
4 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
5 DESC='Roundup HTTP-Server' |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
6 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
7 BINFILE=roundup-server |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
8 EXECUTABLE=/usr/local/bin/$BINFILE |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
9 PIDFILE=/var/run/roundup/server.pid |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
10 LOGFILE=/var/log/roundup/roundup.log |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
11 TRACKERS=tttech=/tttech/org/software/roundup/tttech/ |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
12 OPTIONS="-- -p 8080 -u roundup -d $PIDFILE -l $LOGFILE $TRACKERS" |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
13 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
14 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
15 test -x $EXECUTABLE || exit 0 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
16 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
17 start_stop() { |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
18 case "$1" in |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
19 start) |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
20 printf "Starting $DESC:" |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
21 start-stop-daemon --start --oknodo --quiet \ |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
22 --pidfile $PIDFILE \ |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
23 --exec $EXECUTABLE $OPTIONS |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
24 printf " $BINFILE" |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
25 printf ".\n" |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
26 ;; |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
27 stop) |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
28 printf "Stopping $DESC:" |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
29 start-stop-daemon --stop --oknodo --quiet \ |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
30 --pidfile $PIDFILE \ |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
31 --exec $EXECUTABLE $OPTIONS |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
32 printf " $BINFILE" |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
33 printf ".\n" |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
34 ;; |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
35 restart | force-reload) |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
36 start_stop stop |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
37 sleep 1 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
38 start_stop start |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
39 ;; |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
40 *) |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
41 printf "Usage: $0 {start|stop|restart|force-reload}\n" >&2 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
42 exit 1 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
43 ;; |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
44 esac |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
45 } |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
46 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
47 start_stop "$@" |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
48 |
|
24fb163ddece
added Debian rc script
Richard Jones <richard@users.sourceforge.net>
parents:
diff
changeset
|
49 exit 0 |
