cd /opt/domjudge/domserver && bin/dj_setup_database --help

Error: unknown option '-'.
Usage: bin/dj_setup_database [option]... <command> [argument]

Commands:
  status           check database installation status
  genpass          generate DB,API,Symfony,admin password files
  create-db-users  create (empty) database and users
  update-password  update DB user database to that in 'etc/dbpasswords.secret'
  install          create database, example contest and users if not existing
  bare-install     create database, setup defaults if not existing
  uninstall        remove database users and database, INCLUDING ALL DATA!
  install-examples install examples only
  install-loadtest configure for load testing. WARNING: CREATES A LOT OF EXTRA ITEMS!
  upgrade          upgrade MySQL database schema to current version
  dump [filename]  backup the current database to file (without .sql.gz suffix)
  load [filename]  load a backup from file (without .sql.gz suffix), REMOVES ALL PREVIOUS DATA!

Options:
  -u <user>  connect to MySQL with DB admin <user>
  -p <pass>  use password <pass> for DB admin user
  -q         be (mostly) quiet
  -r         read DB admin password from prompt

bin/dj_setup_database -s status

Database credentials read from '/opt/domjudge/domserver/etc/dbpasswords.secret'.
Trying to connect to the server as DB admin: success.
Trying to connect to the server with user 'domjudge': success.
Searching for database 'domjudge': found.
Searching for data in database: DOMjudge
MySQL server version: 10.6.23-MariaDB-0ubuntu0.22.04.1
Database check successful: database and users present and accessible.

bin/dj_console list --raw | grep -E "^(domjudge|api|compare)"

api:call                                    Call the DOMjudge API directly. Note: this will use admin credentials
compare:awards                              Compare awards between two files
compare:results                             Compare results between two files
compare:scoreboard                          Compare scoreboard between two files
domjudge:db-config:check                    Check if the default values of the database configuration are valid
domjudge:load-default-data                  Load the data needed by all DOMjudge installations
domjudge:load-development-data              Load fixture data to verify unit tests.
domjudge:load-example-data                  Load example data to get a sample DOMjudge installation up and running
domjudge:load-gatling-data                  Load the gatling data(for load testing)
domjudge:refresh-cache                      Refreshes the scoreboard caches for all contests
domjudge:reset-user-password                Reset the password of the given user

bin/dj_console domjudge:reset-user-password admin q1w2e3r4

 [OK] New password for admin is q1w2e3r4

bin/dj_console domjudge:db-config:check

 [OK] All default values have the correct type

bin/dj_console domjudge:refresh-cache

 [OK] Refreshed cache for contest Demo contest.

bin/dj_console api:call -m GET contests

[{"formal_name":"Demo contest","scoreboard_type":"pass-fail","start_time":"2026-10-28T05:30:30+00:00","end_time":"2026-10-28T10:30:30+00:00","scoreboard_thaw_time":null,"duration":"5:00:00.000","scoreboard_freeze_duration":"1:00:00.000","cid":1,"id":"demo","name":"Demo contest","shortname":"demo","allow_submit":true,"runtime_as_score_tiebreaker":false,"warning_message":null,"penalty_time":20}]

contest_id = 'wf48_finals'

for endpoint in [
        'accounts',
        'awards',
        'balloons',
        'clarifications',
        'groups',
        'judgements',
        'languages',
        'organizations',
        'problems',
#        'runs',
        'scoreboard',
        'submissions',
        'teams',
        ]:
    data = api_to_file(f'contests/{contest_id}/{endpoint}', f'{endpoint}.json')

Usage: bin/export-contest [<domjudge-api-url>]

mkdir -p /tmp/d1-export && cd /tmp/d1-export
sed -i "s/wf48_finals/demo/g" /opt/domjudge/domserver/bin/export-contest
/opt/domjudge/domserver/bin/export-contest

Downloading 'contests/demo/submissions/2/files'
Downloading 'contests/demo/submissions/3/files'
Downloading 'contests/demo/submissions/4/files'
Downloading 'contests/demo/submissions/5/files'

accounts.json
awards.json
balloons.json
clarifications.json
event-feed.ndjson
groups.json
judgements.json
languages.json
organizations.json
problems.json
scoreboard.json
submissions
submissions.json
teams.json

bin/force-passwords --help

Database credentials read from '/opt/domjudge/domserver/etc/dbpasswords.secret'.
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

 [OK] New password for judgehost is ujN3KSfMCG5aVgsvyWqnsG/ZdXqo0hEa


 [OK] New password for admin is TJKHC33jtTYh0a6M

ExecStart=/opt/domjudge/judgehost/bin/judgedaemon -n %i
User=domjudge
Restart=always

journalctl -u domjudge-judgedaemon@1 -n 6 --no-pager -o cat

No submissions in queue (for endpoint default), waiting...

API request GET judgehosts

API request POST judgehosts/fetch-work

  55213 php /opt/domjudge/judgehost/bin/judgedaemon -n 1
  55567 php ./judgedaemon --help

Usage: /opt/domjudge/judgehost/bin/dj_make_chroot [options]...
Creates a chroot environment with Java JRE support using the
Debian or Ubuntu GNU/Linux distribution.

Options:
  -a <arch>    Machine architecture to use.
  -d <dir>     Directory where to build the chroot environment.
  -D <distro>  Linux distribution to use: 'Debian' or 'Ubuntu'.
  -R <release> Release for the selected Linux distribution.
  -i <debs>    List of extra package names to install (comma separated).
  -r <debs>    List of extra package names to remove (comma separated).
  -l <debs>    List of local package files to install (comma separated).
  -s <lists>   List of apt repository .list files that exist outside the chroot
               to add to the chroot (comma separated). Signing keys for the

Usage: ./dj_run_chroot [options]... [command]
Runs <command> inside the prebuilt chroot environment. If no command is
given, then an interactive shell inside the chroot is started.

Options:
  -d <dir>    Directory of the prebuild chroot (if not default).
  -h          Display this help.

This script must be run as root. It mounts proc, sysfs and devpts
before starting the chroot, and unmounts those afterwards. This script
can be used, for example, to upgrade or install new packages in the
chroot:

  sudo dj_run_chroot "apt update && apt upgrade"

Usage: dj_judgehost_cleanup <command>
Perform various cleanup tasks on a judgehost.

Make sure that no judgings are in process while running this script.
It is best to temporarily disable the judgehost in the web interface
or stop the service and wait until all judgings are finished.

Commands:
  procs     Kill any remaining processes running as the restricted
              domjudge-run* user. These can remain when the judging
              process aborted in an unexpected way.
  mounts    Unmount stale bind mounts to the chroot. These can appear
              when then judgedaemon crashes in the middle of a judging.
  cache     Delete cached test cases and executables.
  judgings  Delete detailed logs and compiled programs of judgings.
              Note that the most important data is stored in the database.
              The additional data on disk is mostly useful for debugging.
  all       First kill remaining processes, then unmount stale bind mounts,
              and finally delete cache and judging data.

mysql -N -e "select roleid,role from domjudge.role order by roleid"

1	admin
2	jury
3	team
4	balloon
5	judgehost
6	api_reader
7	api_writer
8	api_source_reader
9	clarification_rw

admin	admin
judgehost	judgehost
demo	team

curl -s -u admin:q1w2e3r4 -X POST http://localhost/domjudge/api/v4/users \
  -H "Content-Type: application/json" \
  -d '{"username":"d1tester","name":"D1 Tester","password":"d1test123","roles":["team"]}'

{"last_login_time":null,"last_api_login_time":null,"first_login_time":null,"team":null,"team_id":null,"roles":["team"],"type":"team","userid":4,"id":"d1tester","username":"d1tester","name":"D1 Tester","email":null,"last_ip":null,"ip":null,"enabled":true}

delete from domjudge.userrole where userid=4;
delete from domjudge.user where userid=4;

mysqldump: Error 2013: Lost connection to server during query when dumping table `testcase_content` at row: 6

mysqldump --max_allowed_packet=1G domjudge > /tmp/d1-dump.sql
tail -1 /tmp/d1-dump.sql
du -h /tmp/d1-dump.sql

-- Dump completed on 2026-10-28  7:22:09
40M	/tmp/d1-dump.sql

mysql -e "create database dj_restore_test"
mysql dj_restore_test < /tmp/d1-dump.sql

restore_exit=0
src=5 dst=5
tables=51
cleanup_exit=0

requests.exceptions.MissingSchema: Invalid URL '--help/user': No schema supplied. Perhaps you meant http://--help/user?
RuntimeError: Invalid URL '--help/user': No schema supplied. Perhaps you meant http://--help/user?