website/deploy/systemd/conservancy-www-db.service

29 lines
765 B
SYSTEMD
Raw Permalink Normal View History

# Update the fundraiser total/sustainer list from an SQL file on Apache restart.
[Unit]
Description=Update Conservancy website database
Before=apache2.service
[Service]
Type=oneshot
User=www-data
ExecStart=/usr/bin/sqlite3 -bail /var/lib/www/database/conservancy-website.sqlite3 ".timeout 30000" "BEGIN TRANSACTION;" ".read /home/debian/django-supporters-list.sql" "COMMIT;"
SystemCallFilter=~@clock @cpu-emulation @debug @module @mount @obsolete
CapabilityBoundingSet=
NoNewPrivileges=true
PrivateDevices=true
PrivateNetwork=true
PrivateTmp=true
PrivateUsers=false
ProtectControlGroups=true
ProtectHome=read-only
ProtectKernelModules=true
ProtectKernelTunables=true
ProtectSystem=strict
ReadWritePaths=/var/lib/www/database
[Install]
WantedBy=apache2.service