--- sreview-0.11.1.orig/.ci/setup-minio.pl +++ sreview-0.11.1/.ci/setup-minio.pl @@ -0,0 +1,16 @@ +#!/usr/bin/perl + +use strict; +use warnings; + +use Net::Amazon::S3; +use Mojo::JSON qw/decode_json/; + +exit 0 unless exists($ENV{SREVIEWTEST_S3_CONFIG}); +exit 0 unless exists($ENV{SREVIEWTEST_BUCKET}); + +my $config = decode_json($ENV{SREVIEWTEST_S3_CONFIG}); + +my $s3 = Net::Amazon::S3->new($config->{default}); + +$s3->add_bucket({bucket => $ENV{SREVIEWTEST_BUCKET}}); --- sreview-0.11.1.orig/.gitlab-ci.yml +++ sreview-0.11.1/.gitlab-ci.yml @@ -0,0 +1,347 @@ +--- +variables: + SCAN_KUBERNETES_MANIFESTS: "true" +include: + template: Security/SAST.gitlab-ci.yml +stages: +- test +- build +- autopkgtest +- docker +#- dockertest +- release + +.build: &build + stage: test + services: + - postgres:11 + - name: minio/minio:latest + command: + - server + - /data + variables: + POSTGRES_DB: sreview + POSTGRES_USER: sreview + POSTGRES_PASSWORD: "" + POSTGRES_HOST_AUTH_METHOD: trust + SREVIEWTEST_DB: sreview;host=postgres;user=sreview + SREVIEWTEST_S3_CONFIG: '{"default":{"aws_access_key_id":"minioadmin","aws_secret_access_key":"minioadmin","secure":0,"host":"minio-minio:9000"}}' + SREVIEWTEST_BUCKET: 'test' + SREVIEW_COMMAND_TUNE: '{"bs1770gain":"0.5","inkscape":"0.9"}' + JUNIT_OUTPUT_FILE: junit_output.xml + image: $CI_JOB_NAME + before_script: + - apt-get update; apt-get -y --no-install-recommends install inkscape ffmpeg bs1770gain libssh2-1-dev + - cpanm --notest ExtUtils::Depends Devel::Cover TAP::Harness::JUnit Devel::Cover::Report::Cobertura + - cpanm --notest --installdeps . + - perl Makefile.PL + - perl .ci/setup-minio.pl + script: + - cover -delete + - HARNESS_PERL_SWITCHES='-MDevel::Cover' prove -v -l --harness TAP::Harness::JUnit + - cover + - cover -report cobertura + artifacts: + paths: + - cover_db + reports: + junit: junit_output.xml + coverage_report: + coverage_format: cobertura + path: cover_db/cobertura.xml + tags: + - docker + coverage: '/^Total.* (\d+.\d+)$/' + +perl:latest: + <<: *build + +perl:5.28: + <<: *build + +test:committed: + stage: test + image: perl:latest + before_script: + - apt-get update; apt-get -y --no-install-recommends install git ffmpeg libssh2-1-dev + - cpanm ExtUtils::Depends + - cpanm --notest --installdeps . + - perl Makefile.PL + script: + - make manifest + - git diff --exit-code + +.deb: &deb + stage: build + image: $CI_JOB_NAME + before_script: + - apt-get update; apt-get -y --no-install-recommends install devscripts equivs git build-essential cpanminus + - if [ ! -z "$DEB_DEPENDS" ]; then apt-get -y --no-install-recommends install $DEB_DEPENDS; fi + - if [ ! -z "$CPAN_DEPENDS" ]; then cpanm $CPAN_DEPENDS; fi + - mk-build-deps -r -i -t "apt-get -y -o Debug::pkgProblemResolver=yes --no-install-recommends" + - DIST=${CI_JOB_NAME#*:} + - VERSION=$(git describe --match=v*.*.[0-9]|sed -e 's/^v//g') + - DEBEMAIL="gitlab-runner auto build " dch --distribution $DIST -v $VERSION~$DIST-0 --no-auto-nmu "gitlab automatic snapshot build for $DIST of $VERSION-0" + script: + - dpkg-buildpackage -us -uc -i -I.git + after_script: + - mkdir products + - dcmd mv ../*ges products/ + - echo "GIT_DESCRIBE=$(git describe --match=v*.*.[0-9])" > dot.env + artifacts: + paths: + - products + reports: + dotenv: dot.env + tags: + - docker + +debian:stable-backports: + variables: + DEB_DEPENDS: "-t stable-backports libmedia-convert-perl" + <<: *deb +debian:testing: + <<: *deb + allow_failure: true +debian:unstable: + <<: *deb + +.docker: &docker + stage: docker + dependencies: + - debian:stable-backports + services: + - docker:dind + image: docker:latest + tags: + - docker + before_script: + - export IMAGE_TAG=$CI_REGISTRY_IMAGE/${CI_JOB_NAME#*:}:git-$CI_COMMIT_SHORT_SHA + - cp products/*deb dockerfiles/${CI_JOB_NAME#*:} + - docker info + - docker pull $IMAGE_TAG || true + script: + - cd dockerfiles/${CI_JOB_NAME#*:} + - sed -i -e "s/@git_describe@/$GIT_DESCRIBE/g" Dockerfile + - docker build --build-arg=ci_registry_image=$CI_REGISTRY_IMAGE --build-arg=ci_commit_ref_slug=git-$CI_COMMIT_SHORT_SHA --cache-from $CI_REGISTRY_IMAGE/master:git-$CI_COMMIT_SHORT_SHA --cache-from $IMAGE_TAG --pull -t $IMAGE_TAG . + after_script: + - export IMAGE_TAG=$CI_REGISTRY_IMAGE/${CI_JOB_NAME#*:}:git-$CI_COMMIT_SHORT_SHA + - docker login -u $CI_REGISTRY_USER -p $CI_REGISTRY_PASSWORD $CI_REGISTRY + - docker push $IMAGE_TAG + +docker:common: + <<: *docker + needs: + - debian:stable-backports + +docker:encoder: + <<: *docker + needs: + - debian:stable-backports + - docker:common + +docker:detect: + <<: *docker + needs: + - debian:stable-backports + - docker:common + +docker:master-kube: + <<: *docker + needs: + - debian:stable-backports + - docker:master + - docker:common + +docker:master: + <<: *docker + needs: + - debian:stable-backports + - docker:common + +docker:web: + <<: *docker + needs: + - debian:stable-backports + - docker:common + +helm:build: + stage: build + image: + name: alpine/helm + entrypoint: [""] + allow_failure: true + before_script: + - cd helm + - helm dependency update sreview + - cd .. + script: + - VERSION=$(grep ^version helm/sreview/Chart.yaml|cut -d ' ' -f 2) + - cd helm + - helm package sreview + - cd .. + - mkdir -p products/helm + - mv helm/sreview-$VERSION.tgz products/helm + - echo $VERSION > products/helm/version.txt + artifacts: + paths: + - products/helm + only: + changes: + - helm/**/* + - .gitlab-ci.yml + +release:helm: + stage: release + image: debian:stable + allow_failure: true + needs: + - helm:build + dependencies: + - helm:build + before_script: + - apt-get update + - apt-get -y install curl + script: + - VERSION=$(cat products/helm/version.txt) + - curl --request POST --user gitlab-ci-token:$CI_JOB_TOKEN --form "chart=@products/helm/sreview-$VERSION.tgz" "${CI_API_V4_URL}/projects/${CI_PROJECT_ID}/packages/helm/api/dev/charts" + only: + changes: + - helm/**/* + - .gitlab-ci.yml + +.drelease: &drelease + stage: release + when: manual + services: + - docker:dind + image: docker:latest + tags: + - docker + script: + - docker pull $CI_REGISTRY_IMAGE/${CI_JOB_NAME#*:}:git-$CI_COMMIT_SHORT_SHA + - if [ $CI_COMMIT_REF_SLUG eq "main" ]; then TARGET=latest; else TARGET=$CI_COMMIT_REF_SLUG; fi + - docker tag $CI_REGISTRY_IMAGE/${CI_JOB_NAME#*:}:git-$CI_COMMIT_SHORT_SHA $CI_REGISTRY_IMAGE/${CI_JOB_NAME#*:}:$TARGET + - docker login -u $CI_REGISTRY_USER -p $CI_REGISTRY_PASSWORD $CI_REGISTRY + - docker push $CI_REGISTRY_IMAGE/${CI_JOB_NAME#*:}:$TARGET + +release:encoder: + <<: *drelease + +release:master: + <<: *drelease + +release:master-kube: + <<: *drelease + +release:web: + <<: *drelease + +release:detect: + <<: *drelease + +pages: + stage: release + dependencies: + - debian:stable-backports + script: + - mkdir public + - apt-get update; apt-get -y --no-install-recommends install devscripts + - dcmd cp products/*.changes public/ + - for i in public/*.deb; do ln -s $(basename $i) ${i%_${i#*_}}.deb; done + artifacts: + paths: + - public + only: + - main + needs: + - debian:stable-backports + +.dput: &dput + stage: release + image: debian:stable + allow_failure: true + before_script: + - apt-get update + - apt-get -y install dput-ng + - echo -e "[gitlab]\nmethod=https\nfqdn=https://gitlab-runner:$CI_JOB_TOKEN@$CI_SERVER_HOST\nincoming=/api/v4/projects/$CI_PROJECT_ID/packages/debian\n" > dput.cf + script: + - dput --config=dput.cf --unchecked --no-upload-log gitlab products/*.changes + +dput:stable: + <<: *dput + dependencies: + - debian:stable-backports + +dput:testing: + <<: *dput + dependencies: + - debian:testing + +dput:unstable: + <<: *dput + dependencies: + - debian:unstable + +validate:package: &validate + image: debian:stable-backports + dependencies: + - debian:stable-backports + needs: + - debian:stable-backports + stage: autopkgtest + services: + - postgres:latest + - name: minio/minio:latest + command: + - server + - /data + variables: + POSTGRES_DB: sreview + POSTGRES_USER: sreview + POSTGRES_PASSWORD: "" + POSTGRES_HOST_AUTH_METHOD: trust + SREVIEWTEST_DB: 'sreview;host=postgres;user=sreview' + SREVIEWTEST_INSTALLED: 1 + SREVIEWTEST_S3_CONFIG: '{"default": {"aws_access_key_id": "minioadmin", "aws_secret_access_key":"minioadmin","secure":0,"host":"minio-minio:9000"}}' + SREVIEWTEST_BUCKET: 'test' + before_script: + - apt-get update; apt-get -y --no-install-recommends install libnet-amazon-s3-perl libmojolicious-perl ffmpeg + - if [ -z $NO_MC_BACKPORTS]; then apt-get -y -t stable-backports install libmedia-convert-perl; fi + - perl .ci/setup-minio.pl + - apt-get --purge -y remove libnet-amazon-s3-perl libmojolicious-perl + - apt-get --purge -y autoremove + - apt-get -y install autopkgtest + script: + - autopkgtest products/*ges -- null + +validate:unstable: + image: debian:unstable + dependencies: + - debian:unstable + variables: + NO_MC_BACKPORTS: "1" + needs: + - debian:unstable + <<: *validate + +#validate:web: +# allow_failure: true +# stage: dockertest +# services: +# - name: postgres:latest +# alias: postgresql +# - name: $CI_REGISTRY_IMAGE/web:git-$CI_COMMIT_SHORT_SHA +# alias: web +# variables: +# POSTGRES_USER: sreview +# POSTGRES_DB: sreview +# POSTGRES_PASSWORD: "" +# POSTGRES_HOST_AUTH_METHOD: trust +# SREVIEW_DBISTRING: '"dbi:Pg:dbname=sreview;host=postgresql;user=sreview"' +# SREVIEW_ADMINUSER: '"test@example.com"' +# SREVIEW_ADMINPW: '"foo"' +# SREVIEW_URLBASE: '"http://web:8080/"' +# image: $CI_REGISTRY_IMAGE/encoder:git-$CI_COMMIT_SHORT_SHA +# script: +# - perl -I lib dockerfiles/tests/test.pl --- sreview-0.11.1.orig/.travis.yml +++ sreview-0.11.1/.travis.yml @@ -0,0 +1,20 @@ +--- +language: perl +perl: + - "5.24" + - "5.28" +services: + - postgresql +addons: + postgresql: "9.6" + apt: + packages: + - ffmpeg + - inkscape + - bs1770gain +env: + - SREVIEW_TESTDB=sreview SREVIEW_NONSTRICT=1 +before_script: + - psql -c "create database $SREVIEW_TESTDB;" -U postgres +script: + - perl Makefile.PL && make TEST_VERBOSE=1 test --- sreview-0.11.1.orig/MANIFEST +++ sreview-0.11.1/MANIFEST @@ -162,5 +162,3 @@ web/templates/schedule/index.html.ep web/templates/table.html.ep web/templates/volunteer/list.html.ep -META.yml Module YAML meta-data (added by MakeMaker) -META.json Module JSON meta-data (added by MakeMaker) --- sreview-0.11.1.orig/debian/changelog +++ sreview-0.11.1/debian/changelog @@ -0,0 +1,261 @@ +sreview (0.11.1-1) unstable; urgency=medium + + * New upstream release + - Reverts one last-minute patch that ended up not working correctly + + -- Wouter Verhelst Mon, 17 Feb 2025 10:46:13 +0200 + +sreview (0.11.0-1) unstable; urgency=medium + + * The "FOSDEM was a partial success" release. + * New upstream release, with various changes. + - sreview-cut now does more accurate cuts when a cut point is not on a key + frame + - Bugs found at FOSDEM are now also fixed (and there were too many of them + for comfort...). + * Apply patch from Niels Thykier to support + rootless builds. Closes: #1089440. + + -- Wouter Verhelst Wed, 01 Jan 2025 17:03:22 +0200 + +sreview (0.10.0-1) unstable; urgency=medium + + * New upstream release, with various fixes. + + -- Wouter Verhelst Fri, 16 Aug 2024 11:47:03 +0200 + +sreview (0.9.3-1) unstable; urgency=medium + + * New upstream release, with changes implemented at DebConf23. + * Add missing build-dep for libfile-which-perl; Closes: #1052919. + + -- Wouter Verhelst Fri, 03 Nov 2023 09:40:12 +0200 + +sreview (0.9.2-1) unstable; urgency=medium + + * The "DebConf is coming" release + - Add support for animated credits using synfig + - Support for the JSON interface of nginx + - Various bug fixes + + -- Wouter Verhelst Sat, 02 Sep 2023 10:31:24 +0200 + +sreview (0.9.0-1) unstable; urgency=medium + + * The "FOSDEM is coming" release. + * New upstream release, with lots of new and updated features; most + importantly a revamped overview page, thanks to Stefano Rivera + . New features in the form of advanced + filtering, and editing capabilities when the user is logged in. + + -- Wouter Verhelst Wed, 14 Dec 2022 09:47:05 +0200 + +sreview (0.8.0-1.1) unstable; urgency=medium + + * Non-maintainer upload. + * No source change upload to rebuild with debhelper 13.10 + + -- Michael Biebl Sat, 15 Oct 2022 12:48:52 +0200 + +sreview (0.8.0-1) unstable; urgency=medium + + * The "DebConf is a wrap" release. + * New upstream release. New features: + - Support for fully automatic review, through "sreview-autoreview". + Useful if markers are used, or start/stop positions are created + out of band (SReview is reduced to just a transcoder then). + - Audio normalization is now a module that has multiple + implementations: bs1770gain (the default for backcompat reasons), + ffmpeg (using ffmpeg's "loudnorm" filter), and none (no audio + normalization) + - A/V synchronization is now a module, too. + - New state: final review, for reviewing the videos post-transcode + (in case there are errors there). + - The old review form is now completely gone. It was already no + longer active and probably didn't work anymore, but the code was + still there. + - Added the ability to pre-generate and preview (on a single page) + all the credit slides. + - Plus a bunch of smaller improvements and bug fixes. + + -- Wouter Verhelst Thu, 09 Sep 2021 10:34:16 +0200 + +sreview (0.7.1-1) unstable; urgency=medium + + * The "We're ready for FOSDEM" release. + * New upstream release. + + -- Wouter Verhelst Sun, 31 Jan 2021 12:47:42 +0200 + +sreview (0.6.2-4) unstable; urgency=medium + + * debian/tests/control: drop. We can't get the autopkgtest to work + currently, and this close to the freeze we don't have the time to + fix it properly. We'll review this after the release of bullseye. + + -- Wouter Verhelst Sun, 20 Dec 2020 11:34:33 +0200 + +sreview (0.6.2-3) unstable; urgency=medium + + * Ensure that the code under test has access to the database. + + -- Wouter Verhelst Fri, 11 Dec 2020 09:29:30 +0200 + +sreview (0.6.2-2) unstable; urgency=medium + + * Ensure that PostgreSQL is installed and configured in the autopkgtest + + -- Wouter Verhelst Thu, 10 Dec 2020 08:02:56 +0200 + +sreview (0.6.2-1) unstable; urgency=medium + + * New (minor) upstream release. New features: add a "Multi" schedule + parser, to create a "shadow" event from a main upstream event in the + SReview database. + * Drop JSON::Validator cache files, which weren't supposed to be in + the upload to begin with. + * Bump debhelper compat to 13 + * Add debian/not-installed, so we can ignore the files that don't matter + + -- Wouter Verhelst Wed, 09 Dec 2020 14:57:10 +0200 + +sreview (0.6.1-1) unstable; urgency=medium + + * New upstream release. New features: + - sreview-inject, and web form under /i/ for adding + pre-edited videos to the transcode pipeline (packages sreview-web, + sreview-encoder). + - sreview-import, generic way to parse a schedule (package + sreview-detect). + + -- Wouter Verhelst Sat, 05 Dec 2020 11:02:17 +0200 + +sreview (0.6.0-1) unstable; urgency=medium + + * New upstream release. Major new feature: now provides an + OpenAPI-based API to deal with calendars and schedules. + + -- Wouter Verhelst Wed, 24 Jun 2020 10:32:32 +0200 + +sreview (0.5.0-1) unstable; urgency=medium + + * New upstream release (too many changes to enumerate). + + -- Wouter Verhelst Sat, 25 Jan 2020 23:21:50 +0200 + +sreview (0.4.0-2) unstable; urgency=medium + + * Whoops, don't forget to set the version number elsewhere, too + + -- Wouter Verhelst Sun, 17 Feb 2019 10:42:32 +0200 + +sreview (0.4.0-1) unstable; urgency=medium + + * The "FOSDEM 2019" release + - Completely overhauled review UI. Thanks, Belen Barros Pena for + your help with this! + + -- Wouter Verhelst Sun, 17 Feb 2019 10:33:58 +0200 + +sreview (0.3.1-2) unstable; urgency=medium + + * Actually drop dh_sysuser usage, also from debian/rules -- whoops. + Closes: #901542 + + -- Wouter Verhelst Tue, 19 Jun 2018 08:36:43 +0200 + +sreview (0.3.1-1) unstable; urgency=medium + + * New upstream release (minor updates) + * Drop dh_sysuser usage, it hasn't been tested with NSS modules, just + add an adduser call instead. Closes: 901136. + + -- Wouter Verhelst Thu, 14 Jun 2018 08:38:56 +0200 + +sreview (0.3.0-1) unstable; urgency=medium + + * The "FOSDEM worked" release. + * New upstream release, featuring: + - Much less bugs (which were discovered after a production run at + FOSDEM) + - More flexibility in certain areas, needed by the above production + run + - Better documentation (thanks Nattie!) + - Working support for JSON export to Stefano Rivera's youtube upload + tool + - A new state for "ignored" talks (i.e., content that is not + interesting) + - Default to self-installed jQuery and bootstrap libraries, rather + than using CDN-provided ones + - ... and much more! + + -- Wouter Verhelst Tue, 13 Feb 2018 12:39:41 +0100 + +sreview (0.2.6-1) unstable; urgency=medium + + * New upstream release (sortof) + + -- Wouter Verhelst Wed, 31 Jan 2018 17:45:03 +0100 + +sreview (0.2.4-1) unstable; urgency=medium + + * New upstream release + + -- Wouter Verhelst Fri, 26 Jan 2018 13:39:19 +0100 + +sreview (0.2.3-3) unstable; urgency=medium + + * Re-upload to unstable, now that the first major issues are fixed. + + -- Wouter Verhelst Thu, 04 Jan 2018 18:18:13 +0100 + +sreview (0.2.3-2) experimental; urgency=medium + + * debian/rules: ensure sreview-master.install and sreview-master.dbc + are executable. + + -- Wouter Verhelst Mon, 01 Jan 2018 20:44:22 +0100 + +sreview (0.2.3-1) experimental; urgency=medium + + * New upstream release (minor changes) + * debian/control: add missing build-depends. Closes: #884546. + + -- Wouter Verhelst Mon, 01 Jan 2018 03:16:05 +0100 + +sreview (0.2.2-1) experimental; urgency=medium + + * New upstream release (with only a few minor changes) + * debian/copyright: add text of the CC "by" license, too. + + -- Wouter Verhelst Mon, 11 Dec 2017 22:25:31 +0100 + +sreview (0.2.1-1) experimental; urgency=medium + + * New upstream release + + -- Wouter Verhelst Wed, 29 Nov 2017 17:15:47 +0100 + +sreview (0.2.0-1) experimental; urgency=medium + + * New upstream release + - Uses a test video that is CC BY 3.0 instead of the one that was CC + BY 2.0, which is not DFSG-free + - Autodetects whether to use libfdk_aac based on whether ffmpeg + supports it, rather than depending on the user to manually set it. + * Add various fixes to the debian/ directory to make lintian slightly happier + + -- Wouter Verhelst Wed, 22 Nov 2017 21:46:04 +0100 + +sreview (0.1.1-1) experimental; urgency=medium + + * New upstream release + Fixes a few oops kind of thingies. + + -- Wouter Verhelst Mon, 13 Nov 2017 11:50:08 +0100 + +sreview (0.1-1) experimental; urgency=medium + + * Initial release. + + -- Wouter Verhelst Fri, 10 Nov 2017 10:14:20 +0100 --- sreview-0.11.1.orig/debian/control +++ sreview-0.11.1/debian/control @@ -0,0 +1,125 @@ +Source: sreview +Section: video +Priority: optional +Rules-Requires-Root: no +Standards-Version: 4.1.1 +Maintainer: Wouter Verhelst +Vcs-Browser: https://salsa.debian.org/wouter/sreview +Vcs-Git: https://salsa.debian.org/wouter/sreview +Build-Depends: debhelper-compat (= 13), + dh-apache2, + dh-exec, + ffmpeg, + libclass-type-enum-perl, + libcryptx-perl, + libdatetime-format-pg-perl, + libdatetime-perl, + libextutils-depends-perl, + libfile-which-perl, + libmedia-convert-perl (>= 1.1.0-2~), + libmojo-pg-perl, + libmoose-perl, + libtest-deep-perl, + libtext-format-perl, + libyaml-libyaml-perl, + +Package: sreview-master +Architecture: all +Depends: sreview-common, + ${misc:Depends}, + ${perl:Depends}, +Recommends: postgresql, + postgresql-contrib, + rsync, + sreview-detect, +Description: SReview components for master host + SReview is a video review and transcoding system. It allows users to + review videos, and will then (after the review has finished) transcode + them into archive-quality video files. + . + This package contains the components that should run on just one + server. It is not useful without one or more machines also running the + webinterface (in the sreview-web package) or the encoder (in the + sreview-encoder package). + +Package: sreview-web +Architecture: all +Depends: fonts-font-awesome, + libcryptx-perl, + libjs-bootstrap4, + libjs-vue, + libmojolicious-plugin-openapi-perl, + pwgen, + sreview-common, + ${misc:Depends}, +Recommends: httpd, +Description: SReview webinterface + SReview is a video review and transcoding system. It allows users to + review videos, and will then (after the review has finished) transcode + them into archive-quality video files. + . + This package contains the sreview webinterface, used by administrators + and reviewers. + +Package: sreview-encoder +Architecture: all +Depends: libemail-address-perl, + libemail-sender-perl, + libemail-stuffer-perl, + sreview-common, + ${misc:Depends}, + ${perl:Depends}, +Recommends: gridengine-exec, +Description: SReview encoder code + SReview is a video review and transcoding system. It allows users to + review videos, and will then (after the review has finished) transcode + them into archive-quality video files. + . + This package contains the encoder scripts that do all the hard work. + It should be installed on the machines which will do the actual + transcoding. + +Package: sreview-common +Architecture: all +Depends: ffmpeg, + inkscape, + libclass-type-enum-perl, + libdatetime-format-iso8601-perl, + libdatetime-format-pg-perl, + libdatetime-perl, + libmedia-convert-perl (>= 1.1.0-2~), + libmojo-pg-perl, + libmojolicious-perl, + libmoose-perl, + libnet-amazon-s3-perl, + libtext-format-perl, + pwgen, + ${misc:Depends}, +Suggests: libwww-curl-perl, +Description: SReview -- common code + SReview is a video review and transcoding system. It allows users to + review videos, and will then (after the review has finished) transcode + them into archive-quality video files. + . + This package contains the common code used by all the other SReview + packages. + +Package: sreview-detect +Architecture: all +Depends: libdatetime-format-pg-perl, + libical-parser-perl, + libjson-perl, + libxml-simpleobject-perl, + sreview-common, + ${misc:Depends}, +Description: SReview input detection script + SReview is a video review and transcoding system. It allows users to + review videos, and will then (after the review has finished) transcode + them into archive-quality video files. + . + This package contains the sreview-detect script, which probes files in + the input directory and either adds them to the database if they're + new, or just updates their length if they're already known. + . + It also contains the sreview-import script, which is used to import + schedules from conference management systems. --- sreview-0.11.1.orig/debian/copyright +++ sreview-0.11.1/debian/copyright @@ -0,0 +1,978 @@ +SReview was written and packaged by Wouter Verhelst + +It is released under the AGPLv3 or (at your option) any later version. + +Additionally, the source comes with a short test video snippet in +t/testvids which was taken from the "Big Buck Bunny" movie, which is +Copyright(c) 2008, the Blender Foundation / www.bigbuckbunny.org, and is +released under the Creative Commons "by" license, version 3.0. + +The full text of the AGPLv3 and the CC "by" license follow. + +----------------------------------------------------------------------------- + + GNU AFFERO GENERAL PUBLIC LICENSE + Version 3, 19 November 2007 + + Copyright (C) 2007 Free Software Foundation, Inc. + Everyone is permitted to copy and distribute verbatim copies + of this license document, but changing it is not allowed. + + Preamble + + The GNU Affero General Public License is a free, copyleft license for +software and other kinds of works, specifically designed to ensure +cooperation with the community in the case of network server software. + + The licenses for most software and other practical works are designed +to take away your freedom to share and change the works. By contrast, +our General Public Licenses are intended to guarantee your freedom to +share and change all versions of a program--to make sure it remains free +software for all its users. + + When we speak of free software, we are referring to freedom, not +price. Our General Public Licenses are designed to make sure that you +have the freedom to distribute copies of free software (and charge for +them if you wish), that you receive source code or can get it if you +want it, that you can change the software or use pieces of it in new +free programs, and that you know you can do these things. + + Developers that use our General Public Licenses protect your rights +with two steps: (1) assert copyright on the software, and (2) offer +you this License which gives you legal permission to copy, distribute +and/or modify the software. + + A secondary benefit of defending all users' freedom is that +improvements made in alternate versions of the program, if they +receive widespread use, become available for other developers to +incorporate. Many developers of free software are heartened and +encouraged by the resulting cooperation. However, in the case of +software used on network servers, this result may fail to come about. +The GNU General Public License permits making a modified version and +letting the public access it on a server without ever releasing its +source code to the public. + + The GNU Affero General Public License is designed specifically to +ensure that, in such cases, the modified source code becomes available +to the community. It requires the operator of a network server to +provide the source code of the modified version running there to the +users of that server. Therefore, public use of a modified version, on +a publicly accessible server, gives the public access to the source +code of the modified version. + + An older license, called the Affero General Public License and +published by Affero, was designed to accomplish similar goals. This is +a different license, not a version of the Affero GPL, but Affero has +released a new version of the Affero GPL which permits relicensing under +this license. + + The precise terms and conditions for copying, distribution and +modification follow. + + TERMS AND CONDITIONS + + 0. Definitions. + + "This License" refers to version 3 of the GNU Affero General Public License. + + "Copyright" also means copyright-like laws that apply to other kinds of +works, such as semiconductor masks. + + "The Program" refers to any copyrightable work licensed under this +License. Each licensee is addressed as "you". "Licensees" and +"recipients" may be individuals or organizations. + + To "modify" a work means to copy from or adapt all or part of the work +in a fashion requiring copyright permission, other than the making of an +exact copy. The resulting work is called a "modified version" of the +earlier work or a work "based on" the earlier work. + + A "covered work" means either the unmodified Program or a work based +on the Program. + + To "propagate" a work means to do anything with it that, without +permission, would make you directly or secondarily liable for +infringement under applicable copyright law, except executing it on a +computer or modifying a private copy. Propagation includes copying, +distribution (with or without modification), making available to the +public, and in some countries other activities as well. + + To "convey" a work means any kind of propagation that enables other +parties to make or receive copies. Mere interaction with a user through +a computer network, with no transfer of a copy, is not conveying. + + An interactive user interface displays "Appropriate Legal Notices" +to the extent that it includes a convenient and prominently visible +feature that (1) displays an appropriate copyright notice, and (2) +tells the user that there is no warranty for the work (except to the +extent that warranties are provided), that licensees may convey the +work under this License, and how to view a copy of this License. If +the interface presents a list of user commands or options, such as a +menu, a prominent item in the list meets this criterion. + + 1. Source Code. + + The "source code" for a work means the preferred form of the work +for making modifications to it. "Object code" means any non-source +form of a work. + + A "Standard Interface" means an interface that either is an official +standard defined by a recognized standards body, or, in the case of +interfaces specified for a particular programming language, one that +is widely used among developers working in that language. + + The "System Libraries" of an executable work include anything, other +than the work as a whole, that (a) is included in the normal form of +packaging a Major Component, but which is not part of that Major +Component, and (b) serves only to enable use of the work with that +Major Component, or to implement a Standard Interface for which an +implementation is available to the public in source code form. A +"Major Component", in this context, means a major essential component +(kernel, window system, and so on) of the specific operating system +(if any) on which the executable work runs, or a compiler used to +produce the work, or an object code interpreter used to run it. + + The "Corresponding Source" for a work in object code form means all +the source code needed to generate, install, and (for an executable +work) run the object code and to modify the work, including scripts to +control those activities. However, it does not include the work's +System Libraries, or general-purpose tools or generally available free +programs which are used unmodified in performing those activities but +which are not part of the work. For example, Corresponding Source +includes interface definition files associated with source files for +the work, and the source code for shared libraries and dynamically +linked subprograms that the work is specifically designed to require, +such as by intimate data communication or control flow between those +subprograms and other parts of the work. + + The Corresponding Source need not include anything that users +can regenerate automatically from other parts of the Corresponding +Source. + + The Corresponding Source for a work in source code form is that +same work. + + 2. Basic Permissions. + + All rights granted under this License are granted for the term of +copyright on the Program, and are irrevocable provided the stated +conditions are met. This License explicitly affirms your unlimited +permission to run the unmodified Program. The output from running a +covered work is covered by this License only if the output, given its +content, constitutes a covered work. This License acknowledges your +rights of fair use or other equivalent, as provided by copyright law. + + You may make, run and propagate covered works that you do not +convey, without conditions so long as your license otherwise remains +in force. You may convey covered works to others for the sole purpose +of having them make modifications exclusively for you, or provide you +with facilities for running those works, provided that you comply with +the terms of this License in conveying all material for which you do +not control copyright. Those thus making or running the covered works +for you must do so exclusively on your behalf, under your direction +and control, on terms that prohibit them from making any copies of +your copyrighted material outside their relationship with you. + + Conveying under any other circumstances is permitted solely under +the conditions stated below. Sublicensing is not allowed; section 10 +makes it unnecessary. + + 3. Protecting Users' Legal Rights From Anti-Circumvention Law. + + No covered work shall be deemed part of an effective technological +measure under any applicable law fulfilling obligations under article +11 of the WIPO copyright treaty adopted on 20 December 1996, or +similar laws prohibiting or restricting circumvention of such +measures. + + When you convey a covered work, you waive any legal power to forbid +circumvention of technological measures to the extent such circumvention +is effected by exercising rights under this License with respect to +the covered work, and you disclaim any intention to limit operation or +modification of the work as a means of enforcing, against the work's +users, your or third parties' legal rights to forbid circumvention of +technological measures. + + 4. Conveying Verbatim Copies. + + You may convey verbatim copies of the Program's source code as you +receive it, in any medium, provided that you conspicuously and +appropriately publish on each copy an appropriate copyright notice; +keep intact all notices stating that this License and any +non-permissive terms added in accord with section 7 apply to the code; +keep intact all notices of the absence of any warranty; and give all +recipients a copy of this License along with the Program. + + You may charge any price or no price for each copy that you convey, +and you may offer support or warranty protection for a fee. + + 5. Conveying Modified Source Versions. + + You may convey a work based on the Program, or the modifications to +produce it from the Program, in the form of source code under the +terms of section 4, provided that you also meet all of these conditions: + + a) The work must carry prominent notices stating that you modified + it, and giving a relevant date. + + b) The work must carry prominent notices stating that it is + released under this License and any conditions added under section + 7. This requirement modifies the requirement in section 4 to + "keep intact all notices". + + c) You must license the entire work, as a whole, under this + License to anyone who comes into possession of a copy. This + License will therefore apply, along with any applicable section 7 + additional terms, to the whole of the work, and all its parts, + regardless of how they are packaged. This License gives no + permission to license the work in any other way, but it does not + invalidate such permission if you have separately received it. + + d) If the work has interactive user interfaces, each must display + Appropriate Legal Notices; however, if the Program has interactive + interfaces that do not display Appropriate Legal Notices, your + work need not make them do so. + + A compilation of a covered work with other separate and independent +works, which are not by their nature extensions of the covered work, +and which are not combined with it such as to form a larger program, +in or on a volume of a storage or distribution medium, is called an +"aggregate" if the compilation and its resulting copyright are not +used to limit the access or legal rights of the compilation's users +beyond what the individual works permit. Inclusion of a covered work +in an aggregate does not cause this License to apply to the other +parts of the aggregate. + + 6. Conveying Non-Source Forms. + + You may convey a covered work in object code form under the terms +of sections 4 and 5, provided that you also convey the +machine-readable Corresponding Source under the terms of this License, +in one of these ways: + + a) Convey the object code in, or embodied in, a physical product + (including a physical distribution medium), accompanied by the + Corresponding Source fixed on a durable physical medium + customarily used for software interchange. + + b) Convey the object code in, or embodied in, a physical product + (including a physical distribution medium), accompanied by a + written offer, valid for at least three years and valid for as + long as you offer spare parts or customer support for that product + model, to give anyone who possesses the object code either (1) a + copy of the Corresponding Source for all the software in the + product that is covered by this License, on a durable physical + medium customarily used for software interchange, for a price no + more than your reasonable cost of physically performing this + conveying of source, or (2) access to copy the + Corresponding Source from a network server at no charge. + + c) Convey individual copies of the object code with a copy of the + written offer to provide the Corresponding Source. This + alternative is allowed only occasionally and noncommercially, and + only if you received the object code with such an offer, in accord + with subsection 6b. + + d) Convey the object code by offering access from a designated + place (gratis or for a charge), and offer equivalent access to the + Corresponding Source in the same way through the same place at no + further charge. You need not require recipients to copy the + Corresponding Source along with the object code. If the place to + copy the object code is a network server, the Corresponding Source + may be on a different server (operated by you or a third party) + that supports equivalent copying facilities, provided you maintain + clear directions next to the object code saying where to find the + Corresponding Source. Regardless of what server hosts the + Corresponding Source, you remain obligated to ensure that it is + available for as long as needed to satisfy these requirements. + + e) Convey the object code using peer-to-peer transmission, provided + you inform other peers where the object code and Corresponding + Source of the work are being offered to the general public at no + charge under subsection 6d. + + A separable portion of the object code, whose source code is excluded +from the Corresponding Source as a System Library, need not be +included in conveying the object code work. + + A "User Product" is either (1) a "consumer product", which means any +tangible personal property which is normally used for personal, family, +or household purposes, or (2) anything designed or sold for incorporation +into a dwelling. In determining whether a product is a consumer product, +doubtful cases shall be resolved in favor of coverage. For a particular +product received by a particular user, "normally used" refers to a +typical or common use of that class of product, regardless of the status +of the particular user or of the way in which the particular user +actually uses, or expects or is expected to use, the product. A product +is a consumer product regardless of whether the product has substantial +commercial, industrial or non-consumer uses, unless such uses represent +the only significant mode of use of the product. + + "Installation Information" for a User Product means any methods, +procedures, authorization keys, or other information required to install +and execute modified versions of a covered work in that User Product from +a modified version of its Corresponding Source. The information must +suffice to ensure that the continued functioning of the modified object +code is in no case prevented or interfered with solely because +modification has been made. + + If you convey an object code work under this section in, or with, or +specifically for use in, a User Product, and the conveying occurs as +part of a transaction in which the right of possession and use of the +User Product is transferred to the recipient in perpetuity or for a +fixed term (regardless of how the transaction is characterized), the +Corresponding Source conveyed under this section must be accompanied +by the Installation Information. But this requirement does not apply +if neither you nor any third party retains the ability to install +modified object code on the User Product (for example, the work has +been installed in ROM). + + The requirement to provide Installation Information does not include a +requirement to continue to provide support service, warranty, or updates +for a work that has been modified or installed by the recipient, or for +the User Product in which it has been modified or installed. Access to a +network may be denied when the modification itself materially and +adversely affects the operation of the network or violates the rules and +protocols for communication across the network. + + Corresponding Source conveyed, and Installation Information provided, +in accord with this section must be in a format that is publicly +documented (and with an implementation available to the public in +source code form), and must require no special password or key for +unpacking, reading or copying. + + 7. Additional Terms. + + "Additional permissions" are terms that supplement the terms of this +License by making exceptions from one or more of its conditions. +Additional permissions that are applicable to the entire Program shall +be treated as though they were included in this License, to the extent +that they are valid under applicable law. If additional permissions +apply only to part of the Program, that part may be used separately +under those permissions, but the entire Program remains governed by +this License without regard to the additional permissions. + + When you convey a copy of a covered work, you may at your option +remove any additional permissions from that copy, or from any part of +it. (Additional permissions may be written to require their own +removal in certain cases when you modify the work.) You may place +additional permissions on material, added by you to a covered work, +for which you have or can give appropriate copyright permission. + + Notwithstanding any other provision of this License, for material you +add to a covered work, you may (if authorized by the copyright holders of +that material) supplement the terms of this License with terms: + + a) Disclaiming warranty or limiting liability differently from the + terms of sections 15 and 16 of this License; or + + b) Requiring preservation of specified reasonable legal notices or + author attributions in that material or in the Appropriate Legal + Notices displayed by works containing it; or + + c) Prohibiting misrepresentation of the origin of that material, or + requiring that modified versions of such material be marked in + reasonable ways as different from the original version; or + + d) Limiting the use for publicity purposes of names of licensors or + authors of the material; or + + e) Declining to grant rights under trademark law for use of some + trade names, trademarks, or service marks; or + + f) Requiring indemnification of licensors and authors of that + material by anyone who conveys the material (or modified versions of + it) with contractual assumptions of liability to the recipient, for + any liability that these contractual assumptions directly impose on + those licensors and authors. + + All other non-permissive additional terms are considered "further +restrictions" within the meaning of section 10. If the Program as you +received it, or any part of it, contains a notice stating that it is +governed by this License along with a term that is a further +restriction, you may remove that term. If a license document contains +a further restriction but permits relicensing or conveying under this +License, you may add to a covered work material governed by the terms +of that license document, provided that the further restriction does +not survive such relicensing or conveying. + + If you add terms to a covered work in accord with this section, you +must place, in the relevant source files, a statement of the +additional terms that apply to those files, or a notice indicating +where to find the applicable terms. + + Additional terms, permissive or non-permissive, may be stated in the +form of a separately written license, or stated as exceptions; +the above requirements apply either way. + + 8. Termination. + + You may not propagate or modify a covered work except as expressly +provided under this License. Any attempt otherwise to propagate or +modify it is void, and will automatically terminate your rights under +this License (including any patent licenses granted under the third +paragraph of section 11). + + However, if you cease all violation of this License, then your +license from a particular copyright holder is reinstated (a) +provisionally, unless and until the copyright holder explicitly and +finally terminates your license, and (b) permanently, if the copyright +holder fails to notify you of the violation by some reasonable means +prior to 60 days after the cessation. + + Moreover, your license from a particular copyright holder is +reinstated permanently if the copyright holder notifies you of the +violation by some reasonable means, this is the first time you have +received notice of violation of this License (for any work) from that +copyright holder, and you cure the violation prior to 30 days after +your receipt of the notice. + + Termination of your rights under this section does not terminate the +licenses of parties who have received copies or rights from you under +this License. If your rights have been terminated and not permanently +reinstated, you do not qualify to receive new licenses for the same +material under section 10. + + 9. Acceptance Not Required for Having Copies. + + You are not required to accept this License in order to receive or +run a copy of the Program. Ancillary propagation of a covered work +occurring solely as a consequence of using peer-to-peer transmission +to receive a copy likewise does not require acceptance. However, +nothing other than this License grants you permission to propagate or +modify any covered work. These actions infringe copyright if you do +not accept this License. Therefore, by modifying or propagating a +covered work, you indicate your acceptance of this License to do so. + + 10. Automatic Licensing of Downstream Recipients. + + Each time you convey a covered work, the recipient automatically +receives a license from the original licensors, to run, modify and +propagate that work, subject to this License. You are not responsible +for enforcing compliance by third parties with this License. + + An "entity transaction" is a transaction transferring control of an +organization, or substantially all assets of one, or subdividing an +organization, or merging organizations. If propagation of a covered +work results from an entity transaction, each party to that +transaction who receives a copy of the work also receives whatever +licenses to the work the party's predecessor in interest had or could +give under the previous paragraph, plus a right to possession of the +Corresponding Source of the work from the predecessor in interest, if +the predecessor has it or can get it with reasonable efforts. + + You may not impose any further restrictions on the exercise of the +rights granted or affirmed under this License. For example, you may +not impose a license fee, royalty, or other charge for exercise of +rights granted under this License, and you may not initiate litigation +(including a cross-claim or counterclaim in a lawsuit) alleging that +any patent claim is infringed by making, using, selling, offering for +sale, or importing the Program or any portion of it. + + 11. Patents. + + A "contributor" is a copyright holder who authorizes use under this +License of the Program or a work on which the Program is based. The +work thus licensed is called the contributor's "contributor version". + + A contributor's "essential patent claims" are all patent claims +owned or controlled by the contributor, whether already acquired or +hereafter acquired, that would be infringed by some manner, permitted +by this License, of making, using, or selling its contributor version, +but do not include claims that would be infringed only as a +consequence of further modification of the contributor version. For +purposes of this definition, "control" includes the right to grant +patent sublicenses in a manner consistent with the requirements of +this License. + + Each contributor grants you a non-exclusive, worldwide, royalty-free +patent license under the contributor's essential patent claims, to +make, use, sell, offer for sale, import and otherwise run, modify and +propagate the contents of its contributor version. + + In the following three paragraphs, a "patent license" is any express +agreement or commitment, however denominated, not to enforce a patent +(such as an express permission to practice a patent or covenant not to +sue for patent infringement). To "grant" such a patent license to a +party means to make such an agreement or commitment not to enforce a +patent against the party. + + If you convey a covered work, knowingly relying on a patent license, +and the Corresponding Source of the work is not available for anyone +to copy, free of charge and under the terms of this License, through a +publicly available network server or other readily accessible means, +then you must either (1) cause the Corresponding Source to be so +available, or (2) arrange to deprive yourself of the benefit of the +patent license for this particular work, or (3) arrange, in a manner +consistent with the requirements of this License, to extend the patent +license to downstream recipients. "Knowingly relying" means you have +actual knowledge that, but for the patent license, your conveying the +covered work in a country, or your recipient's use of the covered work +in a country, would infringe one or more identifiable patents in that +country that you have reason to believe are valid. + + If, pursuant to or in connection with a single transaction or +arrangement, you convey, or propagate by procuring conveyance of, a +covered work, and grant a patent license to some of the parties +receiving the covered work authorizing them to use, propagate, modify +or convey a specific copy of the covered work, then the patent license +you grant is automatically extended to all recipients of the covered +work and works based on it. + + A patent license is "discriminatory" if it does not include within +the scope of its coverage, prohibits the exercise of, or is +conditioned on the non-exercise of one or more of the rights that are +specifically granted under this License. You may not convey a covered +work if you are a party to an arrangement with a third party that is +in the business of distributing software, under which you make payment +to the third party based on the extent of your activity of conveying +the work, and under which the third party grants, to any of the +parties who would receive the covered work from you, a discriminatory +patent license (a) in connection with copies of the covered work +conveyed by you (or copies made from those copies), or (b) primarily +for and in connection with specific products or compilations that +contain the covered work, unless you entered into that arrangement, +or that patent license was granted, prior to 28 March 2007. + + Nothing in this License shall be construed as excluding or limiting +any implied license or other defenses to infringement that may +otherwise be available to you under applicable patent law. + + 12. No Surrender of Others' Freedom. + + If conditions are imposed on you (whether by court order, agreement or +otherwise) that contradict the conditions of this License, they do not +excuse you from the conditions of this License. If you cannot convey a +covered work so as to satisfy simultaneously your obligations under this +License and any other pertinent obligations, then as a consequence you may +not convey it at all. For example, if you agree to terms that obligate you +to collect a royalty for further conveying from those to whom you convey +the Program, the only way you could satisfy both those terms and this +License would be to refrain entirely from conveying the Program. + + 13. Remote Network Interaction; Use with the GNU General Public License. + + Notwithstanding any other provision of this License, if you modify the +Program, your modified version must prominently offer all users +interacting with it remotely through a computer network (if your version +supports such interaction) an opportunity to receive the Corresponding +Source of your version by providing access to the Corresponding Source +from a network server at no charge, through some standard or customary +means of facilitating copying of software. This Corresponding Source +shall include the Corresponding Source for any work covered by version 3 +of the GNU General Public License that is incorporated pursuant to the +following paragraph. + + Notwithstanding any other provision of this License, you have +permission to link or combine any covered work with a work licensed +under version 3 of the GNU General Public License into a single +combined work, and to convey the resulting work. The terms of this +License will continue to apply to the part which is the covered work, +but the work with which it is combined will remain governed by version +3 of the GNU General Public License. + + 14. Revised Versions of this License. + + The Free Software Foundation may publish revised and/or new versions of +the GNU Affero General Public License from time to time. Such new versions +will be similar in spirit to the present version, but may differ in detail to +address new problems or concerns. + + Each version is given a distinguishing version number. If the +Program specifies that a certain numbered version of the GNU Affero General +Public License "or any later version" applies to it, you have the +option of following the terms and conditions either of that numbered +version or of any later version published by the Free Software +Foundation. If the Program does not specify a version number of the +GNU Affero General Public License, you may choose any version ever published +by the Free Software Foundation. + + If the Program specifies that a proxy can decide which future +versions of the GNU Affero General Public License can be used, that proxy's +public statement of acceptance of a version permanently authorizes you +to choose that version for the Program. + + Later license versions may give you additional or different +permissions. However, no additional obligations are imposed on any +author or copyright holder as a result of your choosing to follow a +later version. + + 15. Disclaimer of Warranty. + + THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY +APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT +HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY +OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, +THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR +PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM +IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF +ALL NECESSARY SERVICING, REPAIR OR CORRECTION. + + 16. Limitation of Liability. + + IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING +WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MODIFIES AND/OR CONVEYS +THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY +GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE +USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF +DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD +PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS), +EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF +SUCH DAMAGES. + + 17. Interpretation of Sections 15 and 16. + + If the disclaimer of warranty and limitation of liability provided +above cannot be given local legal effect according to their terms, +reviewing courts shall apply local law that most closely approximates +an absolute waiver of all civil liability in connection with the +Program, unless a warranty or assumption of liability accompanies a +copy of the Program in return for a fee. + + END OF TERMS AND CONDITIONS + + How to Apply These Terms to Your New Programs + + If you develop a new program, and you want it to be of the greatest +possible use to the public, the best way to achieve this is to make it +free software which everyone can redistribute and change under these terms. + + To do so, attach the following notices to the program. It is safest +to attach them to the start of each source file to most effectively +state the exclusion of warranty; and each file should have at least +the "copyright" line and a pointer to where the full notice is found. + + + Copyright (C) + + This program is free software: you can redistribute it and/or modify + it under the terms of the GNU Affero General Public License as published by + the Free Software Foundation, either version 3 of the License, or + (at your option) any later version. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU Affero General Public License for more details. + + You should have received a copy of the GNU Affero General Public License + along with this program. If not, see . + +Also add information on how to contact you by electronic and paper mail. + + If your software can interact with users remotely through a computer +network, you should also make sure that it provides a way for users to +get its source. For example, if your program is a web application, its +interface could display a "Source" link that leads users to an archive +of the code. There are many ways you could offer source, and different +solutions will be better for different programs; see section 13 for the +specific requirements. + + You should also get your employer (if you work as a programmer) or school, +if any, to sign a "copyright disclaimer" for the program, if necessary. +For more information on this, and how to apply and follow the GNU AGPL, see +. + +----------------------------------------------------------------------------- + +Creative Commons +Attribution 3.0 Unported + + CREATIVE COMMONS CORPORATION IS NOT A LAW FIRM AND DOES NOT PROVIDE +LEGAL SERVICES. DISTRIBUTION OF THIS LICENSE DOES NOT CREATE AN +ATTORNEY-CLIENT RELATIONSHIP. CREATIVE COMMONS PROVIDES THIS INFORMATION +ON AN "AS-IS" BASIS. CREATIVE COMMONS MAKES NO WARRANTIES REGARDING THE +INFORMATION PROVIDED, AND DISCLAIMS LIABILITY FOR DAMAGES RESULTING FROM +ITS USE. + +License + +THE WORK (AS DEFINED BELOW) IS PROVIDED UNDER THE TERMS OF THIS CREATIVE +COMMONS PUBLIC LICENSE ("CCPL" OR "LICENSE"). THE WORK IS PROTECTED BY +COPYRIGHT AND/OR OTHER APPLICABLE LAW. ANY USE OF THE WORK OTHER THAN AS +AUTHORIZED UNDER THIS LICENSE OR COPYRIGHT LAW IS PROHIBITED. + +BY EXERCISING ANY RIGHTS TO THE WORK PROVIDED HERE, YOU ACCEPT AND AGREE +TO BE BOUND BY THE TERMS OF THIS LICENSE. TO THE EXTENT THIS LICENSE MAY +BE CONSIDERED TO BE A CONTRACT, THE LICENSOR GRANTS YOU THE RIGHTS +CONTAINED HERE IN CONSIDERATION OF YOUR ACCEPTANCE OF SUCH TERMS AND +CONDITIONS. + +1. Definitions + + "Adaptation" means a work based upon the Work, or upon the Work and +other pre-existing works, such as a translation, adaptation, derivative +work, arrangement of music or other alterations of a literary or +artistic work, or phonogram or performance and includes cinematographic +adaptations or any other form in which the Work may be recast, +transformed, or adapted including in any form recognizably derived from +the original, except that a work that constitutes a Collection will not +be considered an Adaptation for the purpose of this License. For the +avoidance of doubt, where the Work is a musical work, performance or +phonogram, the synchronization of the Work in timed-relation with a +moving image ("synching") will be considered an Adaptation for the +purpose of this License. + "Collection" means a collection of literary or artistic works, such +as encyclopedias and anthologies, or performances, phonograms or +broadcasts, or other works or subject matter other than works listed in +Section 1(f) below, which, by reason of the selection and arrangement of +their contents, constitute intellectual creations, in which the Work is +included in its entirety in unmodified form along with one or more other +contributions, each constituting separate and independent works in +themselves, which together are assembled into a collective whole. A work +that constitutes a Collection will not be considered an Adaptation (as +defined above) for the purposes of this License. + "Distribute" means to make available to the public the original and +copies of the Work or Adaptation, as appropriate, through sale or other +transfer of ownership. + "Licensor" means the individual, individuals, entity or entities +that offer(s) the Work under the terms of this License. + "Original Author" means, in the case of a literary or artistic work, +the individual, individuals, entity or entities who created the Work or +if no individual or entity can be identified, the publisher; and in +addition (i) in the case of a performance the actors, singers, +musicians, dancers, and other persons who act, sing, deliver, declaim, +play in, interpret or otherwise perform literary or artistic works or +expressions of folklore; (ii) in the case of a phonogram the producer +being the person or legal entity who first fixes the sounds of a +performance or other sounds; and, (iii) in the case of broadcasts, the +organization that transmits the broadcast. "Work" means the literary +and/or artistic work offered under the terms of this License including +without limitation any production in the literary, scientific and +artistic domain, whatever may be the mode or form of its expression +including digital form, such as a book, pamphlet and other writing; a +lecture, address, sermon or other work of the same nature; a dramatic or +dramatico-musical work; a choreographic work or entertainment in dumb +show; a musical composition with or without words; a cinematographic +work to which are assimilated works expressed by a process analogous to +cinematography; a work of drawing, painting, architecture, sculpture, +engraving or lithography; a photographic work to which are assimilated +works expressed by a process analogous to photography; a work of applied +art; an illustration, map, plan, sketch or three-dimensional work +relative to geography, topography, architecture or science; a +performance; a broadcast; a phonogram; a compilation of data to the +extent it is protected as a copyrightable work; or a work performed by a +variety or circus performer to the extent it is not otherwise considered +a literary or artistic work. "You" means an individual or entity +exercising rights under this License who has not previously violated the +terms of this License with respect to the Work, or who has received +express permission from the Licensor to exercise rights under this +License despite a previous violation. "Publicly Perform" means to +perform public recitations of the Work and to communicate to the public +those public recitations, by any means or process, including by wire or +wireless means or public digital performances; to make available to the +public Works in such a way that members of the public may access these +Works from a place and at a place individually chosen by them; to +perform the Work to the public by any means or process and the +communication to the public of the performances of the Work, including +by public digital performance; to broadcast and rebroadcast the Work by +any means including signs, sounds or images. "Reproduce" means to make +copies of the Work by any means including without limitation by sound or +visual recordings and the right of fixation and reproducing fixations of +the Work, including storage of a protected performance or phonogram in +digital form or other electronic medium. + +2. Fair Dealing Rights. Nothing in this License is intended to reduce, +limit, or restrict any uses free from copyright or rights arising from +limitations or exceptions that are provided for in connection with the +copyright protection under copyright law or other applicable laws. + +3. License Grant. Subject to the terms and conditions of this License, +Licensor hereby grants You a worldwide, royalty-free, non-exclusive, +perpetual (for the duration of the applicable copyright) license to +exercise the rights in the Work as stated below: + + to Reproduce the Work, to incorporate the Work into one or more +Collections, and to Reproduce the Work as incorporated in the +Collections; to create and Reproduce Adaptations provided that any such +Adaptation, including any translation in any medium, takes reasonable +steps to clearly label, demarcate or otherwise identify that changes +were made to the original Work. For example, a translation could be +marked "The original work was translated from English to Spanish," or a +modification could indicate "The original work has been modified."; to +Distribute and Publicly Perform the Work including as incorporated in +Collections; and, to Distribute and Publicly Perform Adaptations. + + For the avoidance of doubt: Non-waivable Compulsory License Schemes. +In those jurisdictions in which the right to collect royalties through +any statutory or compulsory licensing scheme cannot be waived, the +Licensor reserves the exclusive right to collect such royalties for any +exercise by You of the rights granted under this License; Waivable +Compulsory License Schemes. In those jurisdictions in which the right to +collect royalties through any statutory or compulsory licensing scheme +can be waived, the Licensor waives the exclusive right to collect such +royalties for any exercise by You of the rights granted under this +License; and, Voluntary License Schemes. The Licensor waives the right +to collect royalties, whether individually or, in the event that the +Licensor is a member of a collecting society that administers voluntary +licensing schemes, via that society, from any exercise by You of the +rights granted under this License. + +The above rights may be exercised in all media and formats whether now +known or hereafter devised. The above rights include the right to make +such modifications as are technically necessary to exercise the rights +in other media and formats. Subject to Section 8(f), all rights not +expressly granted by Licensor are hereby reserved. + +4. Restrictions. The license granted in Section 3 above is expressly +made subject to and limited by the following restrictions: + + You may Distribute or Publicly Perform the Work only under the terms +of this License. You must include a copy of, or the Uniform Resource +Identifier (URI) for, this License with every copy of the Work You +Distribute or Publicly Perform. You may not offer or impose any terms on +the Work that restrict the terms of this License or the ability of the +recipient of the Work to exercise the rights granted to that recipient +under the terms of the License. You may not sublicense the Work. You +must keep intact all notices that refer to this License and to the +disclaimer of warranties with every copy of the Work You Distribute or +Publicly Perform. When You Distribute or Publicly Perform the Work, You +may not impose any effective technological measures on the Work that +restrict the ability of a recipient of the Work from You to exercise the +rights granted to that recipient under the terms of the License. This +Section 4(a) applies to the Work as incorporated in a Collection, but +this does not require the Collection apart from the Work itself to be +made subject to the terms of this License. If You create a Collection, +upon notice from any Licensor You must, to the extent practicable, +remove from the Collection any credit as required by Section 4(b), as +requested. If You create an Adaptation, upon notice from any Licensor +You must, to the extent practicable, remove from the Adaptation any +credit as required by Section 4(b), as requested. If You Distribute, or +Publicly Perform the Work or any Adaptations or Collections, You must, +unless a request has been made pursuant to Section 4(a), keep intact all +copyright notices for the Work and provide, reasonable to the medium or +means You are utilizing: (i) the name of the Original Author (or +pseudonym, if applicable) if supplied, and/or if the Original Author +and/or Licensor designate another party or parties (e.g., a sponsor +institute, publishing entity, journal) for attribution ("Attribution +Parties") in Licensor's copyright notice, terms of service or by other +reasonable means, the name of such party or parties; (ii) the title of +the Work if supplied; (iii) to the extent reasonably practicable, the +URI, if any, that Licensor specifies to be associated with the Work, +unless such URI does not refer to the copyright notice or licensing +information for the Work; and (iv) , consistent with Section 3(b), in +the case of an Adaptation, a credit identifying the use of the Work in +the Adaptation (e.g., "French translation of the Work by Original +Author," or "Screenplay based on original Work by Original Author"). The +credit required by this Section 4 (b) may be implemented in any +reasonable manner; provided, however, that in the case of a Adaptation +or Collection, at a minimum such credit will appear, if a credit for all +contributing authors of the Adaptation or Collection appears, then as +part of these credits and in a manner at least as prominent as the +credits for the other contributing authors. For the avoidance of doubt, +You may only use the credit required by this Section for the purpose of +attribution in the manner set out above and, by exercising Your rights +under this License, You may not implicitly or explicitly assert or imply +any connection with, sponsorship or endorsement by the Original Author, +Licensor and/or Attribution Parties, as appropriate, of You or Your use +of the Work, without the separate, express prior written permission of +the Original Author, Licensor and/or Attribution Parties. Except as +otherwise agreed in writing by the Licensor or as may be otherwise +permitted by applicable law, if You Reproduce, Distribute or Publicly +Perform the Work either by itself or as part of any Adaptations or +Collections, You must not distort, mutilate, modify or take other +derogatory action in relation to the Work which would be prejudicial to +the Original Author's honor or reputation. Licensor agrees that in those +jurisdictions (e.g. Japan), in which any exercise of the right granted +in Section 3(b) of this License (the right to make Adaptations) would be +deemed to be a distortion, mutilation, modification or other derogatory +action prejudicial to the Original Author's honor and reputation, the +Licensor will waive or not assert, as appropriate, this Section, to the +fullest extent permitted by the applicable national law, to enable You +to reasonably exercise Your right under Section 3(b) of this License +(right to make Adaptations) but not otherwise. + +5. Representations, Warranties and Disclaimer + +UNLESS OTHERWISE MUTUALLY AGREED TO BY THE PARTIES IN WRITING, LICENSOR +OFFERS THE WORK AS-IS AND MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY +KIND CONCERNING THE WORK, EXPRESS, IMPLIED, STATUTORY OR OTHERWISE, +INCLUDING, WITHOUT LIMITATION, WARRANTIES OF TITLE, MERCHANTIBILITY, +FITNESS FOR A PARTICULAR PURPOSE, NONINFRINGEMENT, OR THE ABSENCE OF +LATENT OR OTHER DEFECTS, ACCURACY, OR THE PRESENCE OF ABSENCE OF ERRORS, +WHETHER OR NOT DISCOVERABLE. SOME JURISDICTIONS DO NOT ALLOW THE +EXCLUSION OF IMPLIED WARRANTIES, SO SUCH EXCLUSION MAY NOT APPLY TO YOU. + +6. Limitation on Liability. EXCEPT TO THE EXTENT REQUIRED BY APPLICABLE +LAW, IN NO EVENT WILL LICENSOR BE LIABLE TO YOU ON ANY LEGAL THEORY FOR +ANY SPECIAL, INCIDENTAL, CONSEQUENTIAL, PUNITIVE OR EXEMPLARY DAMAGES +ARISING OUT OF THIS LICENSE OR THE USE OF THE WORK, EVEN IF LICENSOR HAS +BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. + +7. Termination + + This License and the rights granted hereunder will terminate +automatically upon any breach by You of the terms of this License. +Individuals or entities who have received Adaptations or Collections +from You under this License, however, will not have their licenses +terminated provided such individuals or entities remain in full +compliance with those licenses. Sections 1, 2, 5, 6, 7, and 8 will +survive any termination of this License. Subject to the above terms and +conditions, the license granted here is perpetual (for the duration of +the applicable copyright in the Work). Notwithstanding the above, +Licensor reserves the right to release the Work under different license +terms or to stop distributing the Work at any time; provided, however +that any such election will not serve to withdraw this License (or any +other license that has been, or is required to be, granted under the +terms of this License), and this License will continue in full force and +effect unless terminated as stated above. + +8. Miscellaneous + + Each time You Distribute or Publicly Perform the Work or a +Collection, the Licensor offers to the recipient a license to the Work +on the same terms and conditions as the license granted to You under +this License. Each time You Distribute or Publicly Perform an +Adaptation, Licensor offers to the recipient a license to the original +Work on the same terms and conditions as the license granted to You +under this License. If any provision of this License is invalid or +unenforceable under applicable law, it shall not affect the validity or +enforceability of the remainder of the terms of this License, and +without further action by the parties to this agreement, such provision +shall be reformed to the minimum extent necessary to make such provision +valid and enforceable. No term or provision of this License shall be +deemed waived and no breach consented to unless such waiver or consent +shall be in writing and signed by the party to be charged with such +waiver or consent. This License constitutes the entire agreement +between the parties with respect to the Work licensed here. There are no +understandings, agreements or representations with respect to the Work +not specified here. Licensor shall not be bound by any additional +provisions that may appear in any communication from You. This License +may not be modified without the mutual written agreement of the Licensor +and You. The rights granted under, and the subject matter referenced, +in this License were drafted utilizing the terminology of the Berne +Convention for the Protection of Literary and Artistic Works (as amended +on September 28, 1979), the Rome Convention of 1961, the WIPO Copyright +Treaty of 1996, the WIPO Performances and Phonograms Treaty of 1996 and +the Universal Copyright Convention (as revised on July 24, 1971). These +rights and subject matter take effect in the relevant jurisdiction in +which the License terms are sought to be enforced according to the +corresponding provisions of the implementation of those treaty +provisions in the applicable national law. If the standard suite of +rights granted under applicable copyright law includes additional rights +not granted under this License, such additional rights are deemed to be +included in the License; this License is not intended to restrict the +license of any rights under applicable law. + + Creative Commons Notice + + Creative Commons is not a party to this License, and makes no +warranty whatsoever in connection with the Work. Creative Commons will +not be liable to You or any party on any legal theory for any damages +whatsoever, including without limitation any general, special, +incidental or consequential damages arising in connection to this +license. Notwithstanding the foregoing two (2) sentences, if Creative +Commons has expressly identified itself as the Licensor hereunder, it +shall have all rights and obligations of Licensor. + + Except for the limited purpose of indicating to the public that the +Work is licensed under the CCPL, Creative Commons does not authorize the +use by either party of the trademark "Creative Commons" or any related +trademark or logo of Creative Commons without the prior written consent +of Creative Commons. Any permitted use will be in compliance with +Creative Commons' then-current trademark usage guidelines, as may be +published on its website or otherwise made available upon request from +time to time. For the avoidance of doubt, this trademark restriction +does not form part of this License. + + Creative Commons may be contacted at https://creativecommons.org/. --- sreview-0.11.1.orig/debian/not-installed +++ sreview-0.11.1/debian/not-installed @@ -0,0 +1,5 @@ +usr/share/man3/SReview::Normalizer* +usr/share/perl5/JSON/Validator/cache/* +usr/share/perl5/SReview/Job.pm +usr/share/perl5/SReview/Normalizer/ +usr/share/perl5/SReview/Model/ --- sreview-0.11.1.orig/debian/rules +++ sreview-0.11.1/debian/rules @@ -0,0 +1,12 @@ +#!/usr/bin/make -f + +%: + dh $@ --with apache2 + +execute_before_dh_install: + chmod +x debian/sreview-master.install debian/sreview-master.dbc + chmod -R u+rwX debian/tmp + +override_dh_installsystemd: + dh_installsystemd -psreview-master --name=sreview-dispatch + dh_installsystemd --remaining-packages --- sreview-0.11.1.orig/debian/sreview-common.dirs +++ sreview-0.11.1/debian/sreview-common.dirs @@ -0,0 +1 @@ +etc/sreview --- sreview-0.11.1.orig/debian/sreview-common.install +++ sreview-0.11.1/debian/sreview-common.install @@ -0,0 +1,17 @@ +usr/bin/sreview-config +usr/bin/sreview-user +usr/share/man/man1/sreview-config* +usr/share/man/man1/sreview-user* +usr/share/man/man3/SReview* +usr/share/man/man3/SReview::Config* +usr/share/man/man3/SReview::Talk* +usr/share/perl5/SReview.pm +usr/share/perl5/SReview/CodecMap.pm +usr/share/perl5/SReview/Config.pm +usr/share/perl5/SReview/Config/ +usr/share/perl5/SReview/Db.pm +usr/share/perl5/SReview/Files/ +usr/share/perl5/SReview/Talk.pm +usr/share/perl5/SReview/Talk/*.pm +usr/share/perl5/SReview/Template.pm +usr/share/perl5/SReview/Template/ --- sreview-0.11.1.orig/debian/sreview-common.postinst +++ sreview-0.11.1/debian/sreview-common.postinst @@ -0,0 +1,7 @@ +#!/bin/sh + +#DEBHELPER# + +if ! id sreview > /dev/null 2>&1; then + adduser --system --group --home /var/lib/sreview sreview +fi --- sreview-0.11.1.orig/debian/sreview-common.postrm +++ sreview-0.11.1/debian/sreview-common.postrm @@ -0,0 +1,10 @@ +#!/bin/sh + +set -e + +if [ $1 = "purge" ] +then + rm -f /etc/sreview/config.pm +fi + +#DEBHELPER# --- sreview-0.11.1.orig/debian/sreview-detect.cron.d +++ sreview-0.11.1/debian/sreview-detect.cron.d @@ -0,0 +1 @@ +*/30 * * * * sreview [ -x /usr/bin/sreview-detect ] && /usr/bin/sreview-detect --- sreview-0.11.1.orig/debian/sreview-detect.install +++ sreview-0.11.1/debian/sreview-detect.install @@ -0,0 +1,5 @@ +usr/bin/sreview-detect +usr/bin/sreview-import +usr/share/man/man1/sreview-detect* +usr/share/man/man1/sreview-import* +usr/share/perl5/SReview/Schedule/ --- sreview-0.11.1.orig/debian/sreview-encoder.install +++ sreview-0.11.1/debian/sreview-encoder.install @@ -0,0 +1,18 @@ +usr/bin/sreview-autoreview +usr/bin/sreview-copy +usr/bin/sreview-cut +usr/bin/sreview-inject* +usr/bin/sreview-notify +usr/bin/sreview-notranscode +usr/bin/sreview-previews +usr/bin/sreview-skip +usr/bin/sreview-titles +usr/bin/sreview-transcode +usr/bin/sreview-transcribe +usr/bin/sreview-upload +usr/share/man/man1/sreview-cut* +usr/share/man/man1/sreview-notranscode* +usr/share/man/man1/sreview-previews* +usr/share/man/man1/sreview-skip* +usr/share/man/man1/sreview-transcode* +usr/share/man/man1/sreview-transcribe* --- sreview-0.11.1.orig/debian/sreview-master.config +++ sreview-0.11.1/debian/sreview-master.config @@ -0,0 +1,15 @@ +#!/bin/sh + +set -e + +dbc_dbuser=sreview +dbc_dbname=sreview +dbc_dbtypes=pgsql + +. /usr/share/debconf/confmodule +if [ -f /usr/share/dbconfig-common/dpkg/config.pgsql ]; then + . /usr/share/dbconfig-common/dpkg/config.pgsql + dbc_go sreview-master "$@" +fi + +#DEBHELPER# --- sreview-0.11.1.orig/debian/sreview-master.dbc +++ sreview-0.11.1/debian/sreview-master.dbc @@ -0,0 +1,49 @@ +#!/bin/sh + +set -e + +. /etc/dbconfig-common/sreview-master.conf + +if [ $dbc_dbtype = "none" ]; +then + exit # User wants do things manually +fi + +[ $dbc_dbtype = "pgsql" ] # we can't work with anything but postgres + +dbistring="dbi:Pg:dbname='$dbc_dbname'" + +if [ ! -z "$dbc_dbuser" ] +then + dbistring="$dbistring;user='$dbc_dbuser'" +fi + +if [ ! -z "$dbc_dbpass" ] +then + dbistring="$dbistring;password='$dbc_dbpass'" +fi + +if [ ! -z "$dbc_dbserver" ] +then + dbistring="$dbistring;host='$dbc_dbserver'" +fi + +if [ ! -z "$dbc_dbport" ] +then + dbistring="$dbistring;host='$dbc_dbport'" +fi + +if [ "$dbc_ssl" = "true" ] +then + dbistring="$dbistring;sslmode=require" +fi + +if [ "$dbc_authmethod_admin" = "ident" ] +then + su - $dbc_dbadmin -c "psql $dbc_dbname -c 'create extension if not exists pgcrypto; create extension if not exists plpgsql'" +else + psql -U $dbc_dbadmin $dbc_dbname -c 'create extension if not exists pgcrypto; create extension if not exists plpgsql' +fi + +sreview-config --set=dbistring="$dbistring" --action=update +sreview-config --action=initdb --- sreview-0.11.1.orig/debian/sreview-master.install +++ sreview-0.11.1/debian/sreview-master.install @@ -0,0 +1,5 @@ +#!/usr/bin/dh-exec +usr/bin/sreview-dispatch +usr/bin/sreview-reply +usr/share/man/man1/sreview-dispatch* +debian/sreview-master.dbc => usr/share/dbconfig-common/scripts/sreview-master/install/pgsql --- sreview-0.11.1.orig/debian/sreview-master.postinst +++ sreview-0.11.1/debian/sreview-master.postinst @@ -0,0 +1,12 @@ +#!/bin/sh + +set -e + +. /usr/share/debconf/confmodule + +if [ -f /usr/share/dbconfig-common/dpkg/postinst.pgsql ]; then + . /usr/share/dbconfig-common/dpkg/postinst.pgsql + dbc_go sreview-master "$@" +fi + +#DEBHELPER# --- sreview-0.11.1.orig/debian/sreview-master.postrm +++ sreview-0.11.1/debian/sreview-master.postrm @@ -0,0 +1,12 @@ +#!/bin/sh + +set -e + +. /usr/share/debconf/confmodule + +if [ -f /usr/share/dbconfig-common/dpkg/postrm.pgsql ]; then + . /usr/share/dbconfig-common/dpkg/postrm.pgsql + dbc_go sreview-master "$@" +fi + +#DEBHELPER# --- sreview-0.11.1.orig/debian/sreview-master.prerm +++ sreview-0.11.1/debian/sreview-master.prerm @@ -0,0 +1,12 @@ +#!/bin/sh + +set -e + +. /usr/share/debconf/confmodule + +if [ -f /usr/share/dbconfig-common/dpkg/prerm.pgsql ]; then + . /usr/share/dbconfig-common/dpkg/prerm.pgsql + dbc_go sreview-master "$@" +fi + +#DEBHELPER# --- sreview-0.11.1.orig/debian/sreview-master.sreview-dispatch.service +++ sreview-0.11.1/debian/sreview-master.sreview-dispatch.service @@ -0,0 +1,10 @@ +[Unit] +Description=SReview dispatch service +Requires=postgresql.service +Requires=gridengine-master.service +[Service] +User=sreview +Group=sreview +ExecStart=/usr/bin/sreview-dispatch +[Install] +WantedBy=multi-user.target --- sreview-0.11.1.orig/debian/sreview-web.apache2 +++ sreview-0.11.1/debian/sreview-web.apache2 @@ -0,0 +1 @@ +site debian/sreview-web.conf --- sreview-0.11.1.orig/debian/sreview-web.conf +++ sreview-0.11.1/debian/sreview-web.conf @@ -0,0 +1,50 @@ + + ServerName sreview.example.com + DocumentRoot /usr/share/sreview/public + + + Require all granted + AllowOverride None + Options +Indexes + Redirect permanent / https://sreview.example.com + + + + ServerName sreview.example.com + + + UserDir disabled + + DocumentRoot /usr/share/sreview/public + + Require all granted + Options +Indexes + + Alias /bootstrap4 /usr/share/javascript/bootstrap4 + Alias /jquery /usr/share/javascript/jquery + Alias /vue /usr/share/javascript/vue + Alias /font-awesome /usr/share/javascript/font-awesome + Alias /popper.js /usr/share/javascript/popper.js + + Require all granted + Options +FollowSymlinksIfOwnerMatch + + + Require all granted + + SSLEngine on + SSLProtocol -ALL +TLSv1.2 + # SSLCertificateFile + # SSLCertificateKeyFile + # SSLCipherSuite "EECDH+ECDSA+AESGCM EECDH+aRSA+AESGCM EECDH+ECDSA+SHA384 EECDH+ECDSA+SHA256 EECDH+aRSA+SHA384 EECDH+aRSA+SHA256 EECDH EDH+aRSA !RC4 !aNULL !eNULL !LOW !3DES !MD5 !EXP !PSK !SRP !DSS" + Header set Strict-Transport-Security max-age=15768000 + Header set X-Frame-Options DENY + Header set X-Content-Type-Options nosniff + ProxyRequests off + ProxyPreserveHost On + ProxyPass /video ! + ProxyPass /.well-known ! + ProxyPass / http://localhost:8080/ keepalive=on + ProxyPassReverse / http://localhost:8080/ + RequestHeader set X-Forwarded-Proto "https" + --- sreview-0.11.1.orig/debian/sreview-web.install +++ sreview-0.11.1/debian/sreview-web.install @@ -0,0 +1,8 @@ +usr/bin/sreview-web +usr/share/perl5/SReview/API +usr/share/perl5/SReview/API.pm +usr/share/perl5/SReview/Access.pm +usr/share/perl5/SReview/Web.pm +usr/share/perl5/SReview/Web/ +web/public usr/share/sreview +web/templates usr/share/sreview --- sreview-0.11.1.orig/debian/sreview-web.postinst +++ sreview-0.11.1/debian/sreview-web.postinst @@ -0,0 +1,5 @@ +#!/bin/sh + +sreview-config --set=secret=$(pwgen -s 40 -n 1) --action=update + +#DEBHELPER# --- sreview-0.11.1.orig/debian/sreview-web.service +++ sreview-0.11.1/debian/sreview-web.service @@ -0,0 +1,11 @@ +[Unit] +Description=SReview web service +[Service] +ExecStart=/usr/bin/hypnotoad -f /usr/bin/sreview-web +ExecStop=/usr/bin/hypnotoad -s /usr/bin/sreview-web +RuntimeDirectory=sreview +User=sreview +Group=sreview +PIDFile=/var/run/sreview/sreview-web.pid +[Install] +WantedBy=multi-user.target --- sreview-0.11.1.orig/docker-compose.yml +++ sreview-0.11.1/docker-compose.yml @@ -0,0 +1,29 @@ +services: + + web: + build: + context: . + dockerfile: ./dockerfiles/web/local.Dockerfile + volumes: + - ./web/:/usr/share/sreview/ + - ./lib/:/usr/local/lib/site_perl/ + - ./scripts/:/usr/src/scripts/ + - ./dev-incoming/:/srv/sreview/incoming/ + - ./dev-script-output/:/srv/sreview/script-output/ + - ./dev-output/:/srv/sreview/output/ + ports: + - 3000:3000 + depends_on: + - db + + db: + image: postgres:17.2 + volumes: + - postgres_data:/var/lib/postgresql/data/ + environment: + - POSTGRES_USER=sreviewuser + - POSTGRES_PASSWORD=sreviewpassword + - POSTGRES_DB=sreviewdb + +volumes: + postgres_data: --- sreview-0.11.1.orig/dockerfiles/common/Dockerfile +++ sreview-0.11.1/dockerfiles/common/Dockerfile @@ -0,0 +1,3 @@ +FROM debian:stable-backports +COPY *.deb /root/ +RUN apt-get update && apt-get -y --no-install-recommends install libmedia-convert-perl && apt-get -y --no-install-recommends install -t stable-backports libmedia-convert-perl && apt-get -y --no-install-recommends install /root/sreview-common*deb && apt-get clean --- sreview-0.11.1.orig/dockerfiles/detect/Dockerfile +++ sreview-0.11.1/dockerfiles/detect/Dockerfile @@ -0,0 +1,5 @@ +ARG ci_registry_image +ARG ci_commit_ref_slug +FROM $ci_registry_image/common:$ci_commit_ref_slug +RUN apt-get update && DEBIAN_FRONTEND=noninteractive apt-get -y install --no-install-recommends /root/sreview-detect*deb +ENTRYPOINT /usr/bin/sreview-detect --- sreview-0.11.1.orig/dockerfiles/encoder/Dockerfile +++ sreview-0.11.1/dockerfiles/encoder/Dockerfile @@ -0,0 +1,4 @@ +ARG ci_registry_image +ARG ci_commit_ref_slug +FROM $ci_registry_image/common:$ci_commit_ref_slug +RUN apt-get update && DEBIAN_FRONTEND=noninteractive apt-get -y --no-install-recommends install /root/sreview-encoder*deb libdevel-trace-perl curl rsync ssh --- sreview-0.11.1.orig/dockerfiles/master-kube/Dockerfile +++ sreview-0.11.1/dockerfiles/master-kube/Dockerfile @@ -0,0 +1,6 @@ +ARG ci_registry_image +ARG ci_commit_ref_slug +FROM $ci_registry_image/master:$ci_commit_ref_slug +COPY run-kube /usr/local/bin/run-kube +COPY config.pm /etc/sreview/config.pm +RUN apt-get update && apt-get -y install curl libjson-perl libjson-xs-perl libyaml-libyaml-perl libdatetime-perl && curl -LO https://storage.googleapis.com/kubernetes-release/release/`curl -s https://storage.googleapis.com/kubernetes-release/release/stable.txt`/bin/linux/amd64/kubectl && apt-get --purge -y remove curl && apt-get --purge -y autoremove && chmod +x kubectl && mv kubectl /usr/local/bin/ --- sreview-0.11.1.orig/dockerfiles/master-kube/config.pm +++ sreview-0.11.1/dockerfiles/master-kube/config.pm @@ -0,0 +1,13 @@ +$state_actions = { + 'announcing' => 'run-kube announce <%== $talkid %>', + 'notify_final' => 'run-kube notify_final <%== $talkid %>', + 'cutting' => 'run-kube cut <%== $talkid %>', + 'generating_previews' => 'run-kube previews <%== $talkid %>', + 'notification' => 'run-kube notify <%== $talkid %>', + 'transcoding' => 'run-kube transcode <%== $talkid %>', + 'uploading' => 'run-kube upload <%== $talkid %>', + 'injecting' => 'run-kube inject-job <%== $talkid %>', + 'remove' => 'run-kube remove <%== $talkid %>', +}; + +1; --- sreview-0.11.1.orig/dockerfiles/master-kube/example-job-template.ep +++ sreview-0.11.1/dockerfiles/master-kube/example-job-template.ep @@ -0,0 +1,5 @@ +% use YAML::XS; +% push @$env, { name => "SREVIEW_DBISTRING", valueFrom => { secretKeyRef => { key => "SREVIEW_DBISTRING", name => $secretname } } }; +% unshift @$args, $command; +% my %data = ( apiVersion => "kubequeue.grep.be/v1", kind => "JobEntry", metadata => { name => "sreview-$jobsuffix" }, spec => { defName => "sreview-job-def", extraArgs => $args, extraEnv => $env } ); +<%= Dump(\%data); %> --- sreview-0.11.1.orig/dockerfiles/master-kube/example-kubequeue-configs.yaml +++ sreview-0.11.1/dockerfiles/master-kube/example-kubequeue-configs.yaml @@ -0,0 +1,191 @@ +--- +apiVersion: kubequeue.grep.be/v1 +kind: JobQueue +metadata: + name: sreview-queue +spec: + maxJobs: 10 +--- +apiVersion: kubequeue.grep.be/v1 +kind: JobDef +metadata: + name: sreview-previews +spec: + queueName: sreview-queue + jobTemplate: + apiVersion: batch/v1 + kind: Job + metadata: + name: test + spec: + template: + metadata: + name: sreview + spec: + containers: + - name: worker + image: registry.salsa.debian.org/debconf-video-team/sreview/detect:main + command: + - sreview-previews + restartPolicy: OnFailure +--- +apiVersion: kubequeue.grep.be/v1 +kind: JobDef +metadata: + name: sreview-cut +spec: + queueName: sreview-queue + jobTemplate: + apiVersion: batch/v1 + kind: Job + metadata: + name: test + spec: + template: + metadata: + name: sreview + spec: + containers: + - name: worker + image: registry.salsa.debian.org/debconf-video-team/sreview/detect:main + command: + - sreview-cut + restartPolicy: OnFailure +--- +apiVersion: kubequeue.grep.be/v1 +kind: JobDef +metadata: + name: sreview-transcode +spec: + queueName: sreview-queue + jobTemplate: + apiVersion: batch/v1 + kind: Job + metadata: + name: test + spec: + template: + metadata: + name: sreview + spec: + containers: + - name: worker + image: registry.salsa.debian.org/debconf-video-team/sreview/detect:main + command: + - sreview-transcode + restartPolicy: OnFailure +--- +apiVersion: kubequeue.grep.be/v1 +kind: JobDef +metadata: + name: sreview-notify +spec: + queueName: sreview-queue + jobTemplate: + apiVersion: batch/v1 + kind: Job + metadata: + name: test + spec: + template: + metadata: + name: sreview + spec: + containers: + - name: worker + image: registry.salsa.debian.org/debconf-video-team/sreview/detect:main + command: + - sreview-notify + restartPolicy: OnFailure +--- +apiVersion: kubequeue.grep.be/v1 +kind: JobDef +metadata: + name: sreview-notify-final +spec: + queueName: sreview-queue + jobTemplate: + apiVersion: batch/v1 + kind: Job + metadata: + name: test + spec: + template: + metadata: + name: sreview + spec: + containers: + - name: worker + image: registry.salsa.debian.org/debconf-video-team/sreview/detect:main + command: + - sreview-notify + restartPolicy: OnFailure +--- +apiVersion: kubequeue.grep.be/v1 +kind: JobDef +metadata: + name: sreview-announce +spec: + queueName: sreview-queue + jobTemplate: + apiVersion: batch/v1 + kind: Job + metadata: + name: test + spec: + template: + metadata: + name: sreview + spec: + containers: + - name: worker + image: registry.salsa.debian.org/debconf-video-team/sreview/detect:main + command: + - sreview-notify + restartPolicy: OnFailure +--- +apiVersion: kubequeue.grep.be/v1 +kind: JobDef +metadata: + name: sreview-upload +spec: + queueName: sreview-queue + jobTemplate: + apiVersion: batch/v1 + kind: Job + metadata: + name: test + spec: + template: + metadata: + name: sreview + spec: + containers: + - name: worker + image: registry.salsa.debian.org/debconf-video-team/sreview/detect:main + command: + - sreview-upload + restartPolicy: OnFailure +--- +apiVersion: kubequeue.grep.be/v1 +kind: JobDef +metadata: + name: sreview-inject-job +spec: + queueName: sreview-queue + jobTemplate: + apiVersion: batch/v1 + kind: Job + metadata: + name: test + spec: + template: + metadata: + name: sreview + spec: + containers: + - name: worker + image: registry.salsa.debian.org/debconf-video-team/sreview/detect:main + command: + - sreview-inject-job + restartPolicy: OnFailure --- sreview-0.11.1.orig/dockerfiles/master-kube/example-kubequeue-template.ep +++ sreview-0.11.1/dockerfiles/master-kube/example-kubequeue-template.ep @@ -0,0 +1,5 @@ +% use YAML::XS; +% push @$env, { name => "SREVIEW_DBISTRING", valueFrom => { secretKeyRef => { key => "SREVIEW_DBISTRING", name => $secretname } } }; +% $jobsuffix =~ s/_/-/g; +% my %data = ( apiVersion => "kubequeue.grep.be/v1", kind => "JobEntry", metadata => { name => "sreview-$jobsuffix" }, spec => { defName => "sreview-$task", extraArgs => $args, extraEnv => $env } ); +<%= Dump(\%data); %> --- sreview-0.11.1.orig/dockerfiles/master-kube/run-kube +++ sreview-0.11.1/dockerfiles/master-kube/run-kube @@ -0,0 +1,75 @@ +#!/usr/bin/perl -w + +use strict; +use warnings; + +use SReview::Config::Common; +use SReview::Talk; +use SReview::Template; +use YAML::XS; +use JSON; +use DateTime; + +my $task = shift; +my $id = shift; + +my $json = JSON->new->allow_nonref; + +my $config = SReview::Config::Common::setup; + +my $talk = SReview::Talk->new(talkid => $id); +my $now = DateTime->now; +my $start = DateTime->new( + year => $now->year, + month => $now->month, + day => 1, + hour => 0, + minute => 0, + second => 0, +); +my $secs = $now->epoch - $start->epoch; +my $jobsuffix = $talk->talkid . "-" . unpack("h*", pack("L", $secs)); + +my $image = "registry.salsa.debian.org/debconf-video-team/sreview/encoder"; +if(exists($ENV{SREVIEW_ENCODER_IMAGE})) { + $image = $ENV{SREVIEW_ENCODER_IMAGE}; +} + +my $vars = { + task => $task, + image => $image, + jobsuffix => $jobsuffix, + command => "sreview-$task", + args => [ $talk->talkid ], + env => [], + secretname => $ENV{SREVIEWSECRET_NAME}, +}; + +if($task eq "announce" || $task eq "notify_final") { + $vars->{command} = "sreview-notify"; + push @{$vars->{args}}, $task; +} + +foreach my $cfg ($config->keys) { + next if $config->is_default($cfg); + my $val = $json->encode($config->get($cfg)); + push @{$vars->{env}}, {name => "SREVIEW_" . uc($cfg), value => $val}; +} + +my $template = SReview::Template->new(talk => $talk, vars => $vars); +my $data; + +{ + local $/ = undef; + open my $input, "<:encoding(UTF-8)", "/opt/sreview/template.ep"; + $data = <$input>; + close $input; +} + +my $yamldata = Load($template->string($data)); + +print "About to create this kubernetes object:\n"; +print Dump($yamldata) . "\n"; +open my $kubectl, "|-", "kubectl", "apply", "-f", "-"; +print $kubectl Dump($yamldata) . "\n"; +close $kubectl; --- sreview-0.11.1.orig/dockerfiles/master/Dockerfile +++ sreview-0.11.1/dockerfiles/master/Dockerfile @@ -0,0 +1,5 @@ +ARG ci_registry_image +ARG ci_commit_ref_slug +FROM $ci_registry_image/common:$ci_commit_ref_slug +RUN apt-get update && DEBIAN_FRONTEND=noninteractive apt-get -y install --no-install-recommends /root/sreview-master*deb +ENTRYPOINT /usr/bin/sreview-dispatch --- sreview-0.11.1.orig/dockerfiles/tests/test.pl +++ sreview-0.11.1/dockerfiles/tests/test.pl @@ -0,0 +1,31 @@ +#!/usr/bin/perl -w + +use strict; +use warnings; + +use Mojo::UserAgent; +use Mojo::JSON qw/decode_json/; +use Mojo::URL; +use SReview::Talk; +use SReview::Config::Common; +use Data::Dumper; + +my $ua = Mojo::UserAgent->new; + +my $config = SReview::Config::Common::setup(); + +my $baseurl = Mojo::URL->new($config->get('urlbase')); + +my $res = $ua->post(Mojo::URL->new("/login_post")->base($baseurl)->to_abs => form => { email => $config->get('adminuser'), pass => $config->get('adminpw') })->result; + +$res->is_redirect or die "error " . $res->code . ": " . $res->message; + +my $talk = SReview::Talk->new(talkid => 1); + +$res = $ua->get(Mojo::URL->new("/r/" . $talk->nonce. "/data")->base($baseurl)->to_abs)->result; + +$res->is_success or die "error " . $res->code . ": " . $res->message; + +my $json = decode_json($res->body); + +print Dumper($json); --- sreview-0.11.1.orig/dockerfiles/web/Dockerfile +++ sreview-0.11.1/dockerfiles/web/Dockerfile @@ -0,0 +1,7 @@ +ARG ci_registry_image +ARG ci_commit_ref_slug +FROM $ci_registry_image/common:$ci_commit_ref_slug +RUN apt-get update && DEBIAN_FRONTEND=noninteractive apt-get -y --no-install-recommends install /root/sreview-web*deb wait-for-it && mkdir -p /var/run/sreview && chown sreview:sreview /var/run/sreview +ENV GIT_DESCRIBE @git_describe@ +ENTRYPOINT ["/usr/bin/hypnotoad","-f","/usr/bin/sreview-web"] +EXPOSE 8080 --- sreview-0.11.1.orig/dockerfiles/web/local.Dockerfile +++ sreview-0.11.1/dockerfiles/web/local.Dockerfile @@ -0,0 +1,17 @@ +FROM debian:stable-backports +RUN apt-get update && DEBIAN_FRONTEND=noninteractive apt-get -y --no-install-recommends install perl postgresql-client ffmpeg inkscape bs1770gain libnet-amazon-s3-perl libmojolicious-perl libclass-type-enum-perl libcryptx-perl libdatetime-format-pg-perl libdatetime-perl libextutils-depends-perl libfile-which-perl libmojo-pg-perl libmoose-perl libtest-deep-perl libtext-format-perl libyaml-libyaml-perl fonts-font-awesome libcryptx-perl libjs-bootstrap4 libjs-vue libmojolicious-plugin-openapi-perl pwgen python3.11-venv && apt-get install -y --no-install-recommends -t bookworm-backports libmedia-convert-perl + +# torch without CUDA +RUN python3 -m venv /venv && /venv/bin/pip install torch --index-url https://download.pytorch.org/whl/cpu && /venv/bin/pip install openai-whisper + +RUN mkdir /etc/sreview + +WORKDIR /usr/share/sreview/ + +ADD /lib/ /usr/local/lib/site_perl/ +ADD /scripts/sreview-config /usr/src/scripts/sreview-config + +RUN cd /usr/src/scripts/ && ./sreview-config --action=update --set=adminpw=dev --set=adminuser=dev@dev.dev --set=secret=INSECURE_DEV_SECRET --set=dbistring=dbi:Pg:dbname=sreviewdb\;host=db\;user=sreviewuser\;password=sreviewpassword --set=api_key=devkey --set=event=testevent + +CMD ./sreview-web daemon +EXPOSE 8080 --- sreview-0.11.1.orig/docs/components.md +++ sreview-0.11.1/docs/components.md @@ -0,0 +1,189 @@ +# SReview components + +This page tries to explain the components that exist in SReview, and how +they work together. + +## Database + +At the heart of an SReview installation is the database, which contains +information on all the talks that exist, what their state is in the +review queue, as well as on all the raw recordings, what time they were +started, and how long they are (in terms of time, not in terms of +bytes). + +There can be only one SReview database per instance. + +## Scheduler + +Theoretically speaking, SReview does not require a distributed resource +manager (DRM), but using it without one has not been tested at all. It +may magically work, but it is quite likely that it does not work. + +To use SReview, the use of a DRM is therefore strongly recommended. For +FOSDEM 2017 as well as DebConf17, gridengine was used, but strictly +speaking it doesn't really matter which one you use. + +Future versions of SReview may require the use of a +[DRMAA](http://www.drmaa.org)-compatible DRM, but currently that's not +yet the case. + +It is recommended that the scheduler is configured so that short, +high-priority, jobs can be scheduled as well as longer-running, +low-priority jobs. When using gridengine, this can be done by creating +two queues, where the high-priority queue has a `subordinate_queues` +configuration set. + +## Web interface + +If human review is required, a web interface needs to be running. This is +implemented in Mojolicious. Since it stores all state in the database +and in (encrypted) cookies, it should be possible to run multiple +instances of the web interface, although this has not been tested. + +## Job dispatcher + +The `sreview-dispatch` script watches the database for new work, and submits +jobs in the scheduler that will handle them. It needs to run for as long as +work is being performed. + +Currently it polls the database every 10 seconds, but long-term plans +are for it to use [Mojo::Pg](https://metacpan.org/pod/Mojo::Pg) and +PostgreSQL [asynchronous +notification](https://www.postgresql.org/docs/9.6/static/sql-listen.html). + +## File detection + +The `sreview-detect` script needs to be run from cron every so often. It +will run `ffprobe` on all files it finds (new as well as old files), and +use a regex from the configuration file on the full filename to figure +out what the start time of the file is, and in which room it was +recorded. It then stores that information, along with the filename, in +the database. + +This means that the start time and room name needs to be encoded in the +file and/or path name. + +If the file already exists in the database, it will then instead update +the length (and *only* the length), as specified in time rather than +bytes, of the file in the database. + +An obvious optimization which has not yet been implemented is to not +probe the length of a particular file if a newer file for the same room +already exists in the database. + +After files are added to the database, the script will run a few SQL +`UPDATE` statements so the review process will be started for talks for +which all recordings are available. + +Future plans are for `sreview-detect` to be rewritten so it (optionally) +uses the Linux `inotify` API to detect when file contents is modified. + +## Per-state scripts + +There are a number of per-state scripts that are called (through the +scheduler) when a talk reaches a particular state in the database. Each +of them only receives the talk ID as a command line parameter, and is +expected to search for the information that it needs in the databse. + +The following scripts exist: + +### sreview-skip + +This script simply sets the progress to "done". It should be used when a +state is not useful for a particular instance of SReview. + +It does not assume anything about the particular state that the talk is +in, and can therefore be used for pretty much any state. + +### sreview-cut + +This script takes the raw recordings, extracts the useful data of the +talk itself as scheduled and/or corrected by reviewers into a "main" +file, and also extracts the 20 minutes immediately before the talk into +a "pre" file as well as the 20 minutes immediately after into a "post" +file. It does so by copying data, *without* transcoding anything (i.e., +by way of specifying the `-c copy` parameter to ffmpeg). + +However, this script also performs a BS.1770-compliant audio +normalisation. + +There are two older versions of this script: the one used at FOSDEM +2017, and the one used at DebConf17. The `sreview-cut` script is +generic, however, and should not need to be modified for different +conferences. + +This script is designed for talks in the `cutting` state. + +### sreview-notify + +This script should perform whatever is required to send out a +notification to reviewers that a particular talk is now ready for +review. This may include instructing an IRC bot to say something, or +sending out an email to the speakers and/or designated reviewers. + +This script is designed for talks in the `notification` state. + +The genericized version of this script allows you to run commands, +and also has support for sending out emails from a template. + +### sreview-previews + +This script should do whatever is required to convert the output of the +`cut_talk` script to something HTML5-compatible so that it can be viewed +by reviewers. + +If the output of the recording system is already HTML5-compatible (that +is, if it uses H.264 or one of the WebM codecs), then this script should +not do anything, and instead the `skip` script (see above) should be +used. Alternatively, this script may copy files from one machine to the +other so that they are available over HTTP. + +While there is a fosdem version of the `previews` script, that is simply +an older version of the skip script, since FOSDEM recorded in H.264 +which is already HTML5-compatible. The debconf version of this script +would transcode to low-quality VP8, however, since DebConf records in +MPEG2, which is not HTML5-compatible. + +The genericized version of this script verifies whether the output of +sreview-cut is HTML5-compatible, and will transcode to low-quality VP8 +if not, or just copy from one container file to the other if it is. + +This script is designed to be run in the `generating_previews` state; +*not* in the `preview` state (the latter is meant as the state where the +web-based review is done). + +### sreview-transcode + +This script takes the output of the `sreview-cut` script, prepends opening +credits (based on an SVG template after a simple sed-like replacement of +a few key words), appends closing credits (based on either a similar SVG +template or a static PNG file), and then transcodes the whole resulting +file into high-quality output files that will be released to the general +public. Optionally, it will also add an "apology" slide just after the +opening credits; this is designed for cases where minor but +uncorrectable technical issues exist with the recordings (e.g., a +microphone buzz, or the loss of some but not all of the recorded data), +and allows to show a "We are sorry for the inconvenience" type of slide, +so that viewers know what's going on. + +This script may take a long time to complete (usually several seconds +per second of recorded time), and usually does a two-pass transcode. + +It is designed to be run in the `transcoding` state. + +Similar to the `sreview-cut` script, there are two older versions of the +`sreview-transcode` script, too. + +### sreview-upload + +This script should take the output of the `sreview-transcode` script, +and publishes it by whatever method is required. It then also removes +all intermediate files that were created by the `sreview-cut` and/or +`sreview-transcode` scripts; if a change is required after a talk has +already been published, then the talk needs to be put back through the +`sreview-cut` script. + +Two versions exist here too, but they are very similar. + +The genericized version of this script is only able to run a few +commands, but you can easily write your own version if needs be... --- sreview-0.11.1.orig/docs/index.md +++ sreview-0.11.1/docs/index.md @@ -0,0 +1,86 @@ +# SReview documentation + +Welcome to SReview, a video review and transcoding system. + +Please note that any changes you make while reviewing your talk video +will only be visible after you have submitted it for re-cutting. + +There are two main ways to run SReview. Anonymous mode keeps an +overview list of talks to be reviewed, so anyone with access to the list +can review. Notification mode directly informs people by email of the +URL of a specific video to be reviewed. + +## Reviewing + +If you received an email stating that your talk is ready for review, but +the review page claims it is *not* ready, someone else may have already +done some reviewing on it. Check the Cc field on the initial +notification email for other recipients. Additionally, people with +administration logon credentials may review any talk, even if they +didn’t get the notification email. + +### The web form + +The review form shows three video elements; one large video, and two +small ones. The large video should contain *just* the talk that this +video should contain, plus possibly an introduction at the start and the +questions at the end, but no more and no less than that. + +The two smaller video elements above the large video element contain +*context* video; the twenty minutes before and the twenty minutes after +the large video element. These may be helpful should the main video +start too late or stop too soon, and are re-cut whenever the main video +is re-cut (so the end of the pre video should always be *just* before +the start of the main video). + +Below the three video elements is a web form where you can decide what +to do. Read on. + +If you review the recording, and all is well, just select the option +labeled “This preview looks OK, please transcode it at high quality and +release it” in the webform and submit it. Everything else will now +happen automatically. You’re done! + +If the start and end points of the video are incorrect, locate the +correct points in either the main video or the two smaller context +videos. Using the pause button is helpful here, but not obligatory. +Once you've found them, set them with "Take start point" and "Take end +point". This will automatically set the correct values in the "Common +fixes" section. Then, press "OK" to submit the video for re-cutting. + +If the video and audio are out of sync, and you feel confident adjusting +it yourself, fill in an estimated value in the "audio offset" field +under "Common fixes" and send the video for re-cutting. You will be able +to check the adjustment after the video has been re-cut and you have a +new preview. + +If the audio is of poor quality, try changing the audio channel under +"Common fixes". + +If you don't feel confident adjusting the audio offset or channel +yourself, select "This preview has the following issues not covered by +the above" under "Other brokenness", and describe the problem in the +text box there. + +Once you’ve made all the changes you think are needed, hit the “OK” +button at the bottom of the page. Your talk will then be re-cut, after +which it will be available for review again. If SReview is running in +notification mode, you’ll get another notification email. You can check +the new cut, make any more changes as needed, and re-submit the talk. +Once your talk is just as you want it, select "This preview looks OK, +please transcode it at high quality ad release it" and press "OK". + +If you see a problem not covered by "Common Fixes", please select the +"Other brokenness" option, and explain the issue in the text area below +that. Once you’ve submitted the form, your talk will now be placed in +the “broken” state. If you change your mind, you can always choose the +‘Do not make changes, do not notify video team; set the state back to +“preview”’ option. You can then go back to reviewing, as usual. + +Thanks for reviewing! + +## Further documentation + +There is a document about the [components](components) of SReview, which +explains how the system works. If you want to install, read the +[installation](installation) document. --- sreview-0.11.1.orig/docs/installation.md +++ sreview-0.11.1/docs/installation.md @@ -0,0 +1,229 @@ +Installing SReview +================== + +This will install SReview in a way that is useful for a small +conference. That is, you expect to have no more than a handful of talks. + +* Install the packages + [sreview-detect](https://packages.debian.org/unstable/sreview-detect), + [sreview-master](https://packages.debian.org/unstable/sreview-master), + [sreview-encoder](https://packages.debian.org/unstable/sreview-encoder), + and + [sreview-web](https://packages.debian.org/unstable/sreview-web) on + a *single* machine. +* The installation will create an sreview user and database, and will + start the `sreview-web` service on port 8080, listening only to + localhost. The sreview-web package also ships with an apache + configuration snippet that shows how to proxy it from the interwebs. + This is enabled by default, but may require an SSL configuration. +* Run `sreview-config --action=dump`. This will show you the current + configuration of SReview. If you want to change something, either edit + `/etc/sreview/config.pm`, or use `sreview-config --set=variable=value + --action=update`. +* Run `sreview-user -d --action=create -u `. This will + create an administrator user in the SReview database. +* Browse to the SReview webinterface (either on http://localhost:8080/, + or on the apache-redirected standard web port). +* Set the `schedule_format` configuration option to one of the supported + formats. They're all under `lib/SReview/Schedule`; as of this writing, + parsers exist for pentabarf XML (`penta`), the wafer variant of + pentabarf XML (`wafer`), a YAML-based format (`yaml`), and the ICS + format (`ics`) that has however not seen a lot of testing. + Additionally, a `multi` parser exists that allows you to create shadow + copies of each found talk (useful if you want to perform multiple + unrelated actions for each talk, e.g., have an injected prerecording + system as well as a transcode of the output after the fact) and a + `filtered` parser which stacks with another one and which can be used + to ignore certain talks based on properties of those talks. +* Set the `schedule_options` configuration option so that the relevant + options of the parser are set. Most parsers just expect a `url` + parameter with the URL of the schedule file. +* Make sure to run `sreview-import` to import the schedule. This should + run from cron once every half hour, normally. +* Decide whether you want notifications: + - If you set the `anonreviews` configuration option to a nonzero + value, then the `/overview` URL in the webinterface will have + links to individual review pages. Reviewers can then just click on + links and do review. However, an out-of-band mechanism for + coordination between reviewers will be required. Note that review + for talks not in the `previews` state will not be possible. + - If you do *not* set that option, but create review volunteer users + through the webinterface, then these users can go to the + `/volunteer/list` URL, where they will receive a number of talks. These + talks will be locked to them; the reviewers will have to finish the + review. + - If you add email addresses to speakers and/or track managers in + the SReview database, and set the `notify_actions` configuration + value to an array including `email`, the `email_template` variable + to a Mojo::Template template for the email, the `email_from` + configuration value to the email sender address, and the `urlbase` + configuration value to the base URL where SReview can be found, + then speakers and/or track managers will receive an email + notification when a talk reaches the `previews` state containing + the review link. + - If you set the `notify_actions` configuration value to an array + including `command`, and `notify_commands` to an array of arrays, + then the command(s) in `notify_commands` will be run when a talk + reaches the `previews` state. This may be used to, e.g., cause an + IRC bot to say something. +* Review the `inputglob` and `parse_re` configuration parameters of + SReview. The first should contain a filename glob pattern that will + find your raw assets; the second should parse any given filename into + room, year, month, day, hour, minute, and second components. +* Provide an SVG file for opening credits, and point to it from the + `preroll_template` configuration value. See the `SVG TRANSFORMATIONS` + section in the sreview-transcode POD documentation for details on how + to do that. +* Provide an SVG or PNG file for closing credits, and point to it from + the `postroll_template` (for SVG) or `postroll` (for PNG) + configuration option. +* Store raw asset files, and make sure `sreview-detect` runs (it should + do so from cron once every half hour by default). + +The above configuration should work, and will be sufficient for a small +conference. The downside, however, is that there will be only one +backend process running at all times. When a talk reaches the `cutting` +state, but no `sreview-dispatch` process is available immediately, it +may take a *long* time for a process to become available for use. + +There are two ways to fix that: + +Using multiple cores +-------------------- + +In the default configuration, it is safe to run `sreview-dispatch` +multiple times. Each instance will request one job, run it, and then +request the next job. + +However, it does not allow prioritizing short-running jobs (like +`sreview-cut`, which should never take more than a few minutes) over +long-running ones (like `sreview-transcode`, which may easily take +several hours). The result may be that reviewers may have to wait +before the system produces another review, which is not ideal. + +Using a distributed resource manager +------------------------------------ + +A DRM like gridenine, SLURM, PBS, or Torque allows one to submit a job +and have it be run elsewhere. In such a configuration, you would +configure SReview to submit jobs to the DRM system, and it would then be +up to the DRM system to decide where to run it; e.g., it could be +configured to run high-I/O jobs (like `sreview-cut`) on the file server +where the files are directly available, whereas high-CPU jobs (like +`sreview-transcode`) would run on nodes with many CPU cores and +reasonable network bandwidth but not the fileserver. + +Due to the increased flexibility in managing jobs that way, the author +of SReview *strongly* recommends the use of a DRM system for most +installations, even if SReview only runs on one system. However, because +setting up a DRM system is a lot of work and can be fairly complicated, +this is not the default mode of operation. + +Since the author is most familiar with `gridengine`, a short tutorial on +how to set up a gridengine-based system follows. Instructions for other +DRM systems are welcome. + +- Make sure all hosts have a fixed IP address of some sort. This may be + a VPN IP or something, but it must exist. +- Make sure all hosts' FQDN resolves to that fixed IP address, not to + something like `127.0.0.1` or (like is common on Debian) `127.0.1.1`. +- Make sure that all hosts can resolve eachother by name. This may be + through DNS or it may be through adding entries to `/etc/hosts`. +- Pick one host as the master host. On this host, install the + `gridengine-master`, `gridengine-exec`, and `gridengine-client` + packages. +- Run `qconf -ap smp`. This will open your editor with the configuration + values for the `smp` PE that you're creating. Set the `slots` value to + a number not lower than the total number of CPU cores on *all* the + hosts you will be adding to the network. It's fine to set it to + something ridiculously high, like `9999`. Save and exit. +- Run `qconf -ahgrp @allhosts`. This will open your editor with other + configuration values. On the `hostlist` line, add the hostname of your + master host. Save and exit. +- Run `qconf -aq lowprio.q`. Make the following changes: + - Set the `slots` value here to the number of CPU cores that *each + host* will have. That is, if you have 8 cores on every machine in + your network, set it to 8. If you have 4 cores, set it to 4. If + you have a mix of machines, choose the value that is valid for the + master host for now. + - Set the `pe_list` value to `smp` (we didn't create the `make` and + `mpi` values, because we don't need them). + - Set the `hostlist` value to `@allhosts`. + Save and exit. +- Run `qconf -aq hiprio.q`. Make the same changes as for the + `lowprio.q`, above. In addition to that, set the `subordinate_list` + value to `slots=X(lowprio.q:0:sr)`, where `X` is the value you entered + for `slots`. Save and exit. + +The above creates a gridengine environment with two queues, one called +`lowprio.q` and one called `hiprio.q`. The system is configured such +that gridengine will *never* allow more jobs to be running than you have +CPU cores. However, if all CPUs are busy and a job is submitted in the +`hiprio.q` queue, gridengine will send `SIGSTOP` to all processes +started by the shortest-running job in the `lowprio.q` queue, and then +allow the `hiprio.q` job to be started. Once the `hiprio.q` job +finishes, the `lowprio.q` job will receive a SIGCONT and be allowed to +continue. + +To add more worker machines to the system, install `gridengine-exec` on +all other machines in the network. Then, perform the following tasks on +the master: + +- Run `qconf -ae ` for each of the other hosts. This creates + "exec hosts" in the gridengine configuration. +- Run `qconf -mhgrp @allhosts`, and add the hostnames of the exechosts + to the `hostlist` line. +- If one or more of the newly added exec hosts have more or less CPU + cores than what you configured, then set the number of available slots + on a per-node basis, using the following format: + + slots default,[hostname=value],[hostname=value] + + that is, set the default value for the "slots" configuration parameter + first; and then for each host that should have a different value, use + the format `[hostname=X]` for that host. e.g., if most of your hosts + have 8 cores, but host `newbox.example.com` has 16 and host + `oldthing.example.com` has 4, you would use: + + slots 8,[newbox.example.com=16],[oldthing.example.com=4] + + If you have more hosts than it turns out you need and you want to shut + one down, note that it *is* possible to set the slots value to a value + lower than the number of jobs already running on a particular host; if + you do that, gridengine will allow jobs to be finished but not start + any new jobs until the number of running jobs goes below the new + `slots` value. +- If you prefer that the master host does not run any jobs (e.g., + because it is your fileserver and you don't want it to be distracted + transcoding things), set its number of slots for a given queue to 0. +- Now run `qsub -q lowprio.q sleep 100`, and then run `qstat -q + lowprio.q` a few times. You should see your job listed as `pending` + first, and then after a few seconds it should be queued on a host. + Once the job has run for 100 seconds, it should be removed from the + system (you can remove it forcibly before its time is up by way of + `qdel `, where jobid is the number of the job that `qstat` will + show you and which `qsub` returned in its output). +- If that worked, make sure that all exechosts have access to the files + they need (e.g., through NFS or Samba), that they have + the `sreview-encoder` package installed, and that their + `/etc/sreview/config.pm` synchronized. +- Now, modify the `state_actions` so that rather than directly running + your `sreview-*` commands, they are submitted into the `gridengine` + system. e.g., the following would work: + + $state_actions = { + 'cutting' => 'qsub -cwd -pe smp 1 -b y -V -q hiprio.q -e <%== $output_dir %> -o <%== $output_dir %> -N cut_<%== $talkid %> sreview-cut <%== $talkid %>', + 'generating_previews' => 'qsub -cwd -pe smp 1 -b y -V -q hiprio.q -e <%== $output_dir %> -o <%== $output_dir %> -N preview_<%== $talkid %> sreview-previews <%== $talkid %>', + 'notification' => 'qsub -cwd -pe smp 1 -b y -V -q hiprio.q -e <%== $output_dir %> -o <%== $output_dir %> -N notify_<%== $talkid %> sreview-notify <%== $talkid %>', + 'transcoding' => 'qsub -cwd -pe smp 1 -b y -V -q lowprio.q -e <%== $output_dir %> -o <%== $output_dir %> -N transcode_<%== $talkid %> sreview-transcode <%== $talkid %>', + 'uploading' => 'qsub -cwd -pe smp 1 -b y -V -q lowprio.q -e <%== $output_dir %> -o <%== $output_dir %> -N upload_<%== $talkid %> sreview-upload <%== $talkid %>', + }; + +Help! +===== + +If you need more help, contact wouter: + +- IRC: wouter on OFTC or Freenode +- email: wouter on the debian.org domain + --- sreview-0.11.1.orig/docs/production.md +++ sreview-0.11.1/docs/production.md @@ -0,0 +1,103 @@ +# Production examples + +SReview has been used in production for the following conferences: + +* FOSDEM: Every edition since the 2017 edition +* DebConf: Every edition since the 2017 edition +* A few mini-debconfs: 2017 Cambridge, 2018 Hamburg, most mini-debconfs + since. +* OSW.za: 2019 edition + +What follows below is a short description of how SReview was installed +and configured for some of those conferences. Note, however, that it is +possible to run all components of SReview on a single host; for small +conferences, doing so is recommended. + +## FOSDEM + +### 2017 + +At FOSDEM 2017, SReview was installed on the following machines: + +- review.video.fosdem.org: web interface, postgresql, gridengine master, + gridengine exec, dispatch script +- encoder0.video.fosdem.org, encoder1.video.fosdem.org, ...: gridengine + exec, encoder nodes +- backend0.video.fosdem.org, backend1.video.fosdem.org, ...: + `detect_files`, storage for raw recordings (access over HTTP only) +- storage0.video.fosdem.org, storage1.video.fosdem.org, ...: NFS, + storage for `cut_talk`, `previews`, and `transcode` output. + +All machines were "bare metal" machines at a cloud hoster. Data access +to the database and the raw files was LAN-based and therefore quick. + +FOSDEM 2017 was the first ever conference where SReview was used. The +code was *extremely* rough around the edges; in fact, much of the +functionality wasn't there yet, and much of what was there has since +been rewritten. + +### 2018 + +The setup for FOSDEM 2018 was very similar, but there were a few +differences: + +- Everything ran from Debian packages, and we used the generic scripts + (`sreview-transcode` rather than a custom `transcode` script, etc). +- review.video.fosdem.org was renamed to review-master.video.fosdem.org, + and a CNAME was created for the former, for more flexibility (which we + turned out not to need in the end, sigh). +- The NGinX-mp4 module was not used this time around to access the + backend machines, instead we used NFS to access them. + +## DebConf + +### 2017 (Montéal, Canada) + +At DebConf17, SReview was installed on the following machines: + +- vittoria.debian.org: web interface, postgresql, gridengine master, + gridengine exec, dispatch script with configuration for upload and + notification *only* (upload script would pull from noc1st0 first and + then publish). +- noc1st0.debconf17.debconf.org: raw recordings, all intermediate files, + nginx (for serving preview files to reviewers), gridengine master, + `detect_files`, NFS server for raw and intermediate files, gridengine + exec (for `cut_talks` scripts *only*). +- encoder0.debconf17.debconf.org, encoder1.debconf17.debconf.org, ...: + gridengine exec, encoder nodes. + +vittoria is a VM that runs on Debian infrastructure at GRNET (Greece). +It is available to the DebConf video team all year. + +The other machines were local hardware, borrowed for the duration of +DebConf17. They were configured to be granted access to *only* the +postgresql on vittoria. + +During the conference, while the talks were in the `waiting_for_files` +through `transcoding` states, no files were copied to vittoria. Only +when the transcodes had finished were they copied (by the `uploads` +script that ran on vittoria) to vittoria, and then pushed from vittoria +to the DebConf [video archive](https://video.debian.net). + +After the conference, all raw recordings were rsync'd to vittoria. + +### 2018 (Hsinchu, Taiwan) + +For DebConf18, the setup was very similar, but there was a major +difference: rather than having multiple machines on-site, the DebConf18 +setup only had one 24-core VM with 10 TiB of storage on-site, +`storage.dc18.debconf.org`. All cutting and transcoding was done on this +machine; vittoria served the webinterface and the database, etc. + +## Mini debconfs + +Everything was installed and run on vittoria.debian.org + +## OSW.co.za + +The Open Source Week in Johannesburg, South Africa, used SReview for the +review and transcode cycle. Everything was installed on a single +machine (from Debian packages) that was only available from the NOC; +review was done by a single user. After the first day of this +conference, when less rooms were required, we also reused some of the +machines that were originally used for recording as transcoding workers. --- sreview-0.11.1.orig/helm/sreview/.helmignore +++ sreview-0.11.1/helm/sreview/.helmignore @@ -0,0 +1,22 @@ +# Patterns to ignore when building packages. +# This supports shell glob matching, relative path matching, and +# negation (prefixed with !). Only one pattern per line. +.DS_Store +# Common VCS dirs +.git/ +.gitignore +.bzr/ +.bzrignore +.hg/ +.hgignore +.svn/ +# Common backup files +*.swp +*.bak +*.tmp +*~ +# Various IDEs +.project +.idea/ +*.tmproj +.vscode/ --- sreview-0.11.1.orig/helm/sreview/Chart.lock +++ sreview-0.11.1/helm/sreview/Chart.lock @@ -0,0 +1,9 @@ +dependencies: +- name: minio + repository: https://charts.min.io/ + version: 4.0.2 +- name: postgresql + repository: https://charts.bitnami.com/bitnami + version: 12.1.3 +digest: sha256:3822cc6854cfd5f62ceb809e5f37c4af30799b51459fb890a8e36ab13078f6c6 +generated: "2022-12-09T21:11:27.659012204+02:00" --- sreview-0.11.1.orig/helm/sreview/Chart.yaml +++ sreview-0.11.1/helm/sreview/Chart.yaml @@ -0,0 +1,14 @@ +apiVersion: v2 +appVersion: "latest" +description: Helm chart for deploying SReview +name: sreview +version: 0.3.0 +dependencies: +- name: minio + version: 4.0.2 + repository: "https://charts.min.io/" + condition: use_internal_minio +- name: postgresql + repository: https://charts.bitnami.com/bitnami + version: 12.1.3 + condition: use_internal_pg --- sreview-0.11.1.orig/helm/sreview/requirements.lock +++ sreview-0.11.1/helm/sreview/requirements.lock @@ -0,0 +1,9 @@ +dependencies: +- name: minio + repository: https://helm.min.io/ + version: 8.0.10 +- name: postgresql + repository: https://charts.bitnami.com/bitnami + version: 10.3.11 +digest: sha256:e21b78f9521827f63e0c76c680c10fb351faa292f6194281f167c3fb17a80122 +generated: "2021-03-09T13:00:07.911506686+02:00" --- sreview-0.11.1.orig/helm/sreview/templates/_helpers.tpl +++ sreview-0.11.1/helm/sreview/templates/_helpers.tpl @@ -0,0 +1,76 @@ +{{- define "sreview.render_template" }} + {{- if typeIs "string" .value }} + {{- tpl .value .context }} + {{- else }} + {{- tpl (.value | toYaml) .context }} + {{- end }} +{{- end }} +{{- define "sreview.envvals" }} +envFrom: +- configMapRef: + name: {{ .Release.Name }}-config +env: +- name: SREVIEWSECRET_NAME + value: {{ .Release.Name }}-secret +{{- if .Values.use_internal_pg }} +- name: SREVIEW_DBICOMPONENTS + value: "host password dbname user" +- name: SREVIEW_DBI_USER + value: "postgres" +- name: SREVIEW_DBI_HOST + value: {{ .Release.Name }}-postgresql +- name: SREVIEW_DBI_PASSWORD + valueFrom: + secretKeyRef: + name: {{ .Release.Name }}-postgresql + key: postgres-password +- name: SREVIEW_DBI_DBNAME + value: "postgres" +{{- else }} +- name: SREVIEW_DBISTRING + valueFrom: + secretKeyRef: + name: {{ .Release.Name }}-secret + key: SREVIEW_DBISTRING +{{- end }} +{{- if .Values.use_internal_minio }} +- name: SREVIEW_S3_DEFAULT_ACCESSKEY + valueFrom: + secretKeyRef: + name: {{ .Release.Name }}-minio + key: {{ .Values.minioAccount | default "root" }}User +- name: SREVIEW_S3_DEFAULT_SECRETKEY + valueFrom: + secretKeyRef: + name: {{ .Release.Name }}-minio + key: {{ .Values.minioAccount | default "root" }}Password +- name: SREVIEW_S3_DEFAULT_HOST + value: {{ .Release.Name }}-minio:9000 +- name: SREVIEW_S3_DEFAULT_SECURE + value: "0" +{{- else }} +- name: SREVIEW_S3_ACCESS_CONFIG + valueFrom: + secretKeyRef: + name: {{ .Release.Name }}-secret + key: SREVIEW_S3_ACCESS_CONFIG +{{- end }} +- name: SREVIEW_ADMINPW + valueFrom: + secretKeyRef: + name: {{ .Release.Name }}-secret + key: SREVIEW_ADMINPW +- name: SREVIEW_API_KEY + valueFrom: + secretKeyRef: + name: {{ .Release.Name }}-secret + key: SREVIEW_API_KEY +{{- with .Values.extraEnv }} +{{ include "sreview.render_template" (dict "value" . "context" $) }} +{{- end }} +{{- with .Values.secret }} +{{- with .extraEnv }} +{{ include "sreview.render_template" (dict "value" . "context" $) }} +{{- end }} +{{- end }} +{{- end }} --- sreview-0.11.1.orig/helm/sreview/templates/configmaps.yaml +++ sreview-0.11.1/helm/sreview/templates/configmaps.yaml @@ -0,0 +1,33 @@ +--- +apiVersion: v1 +kind: ConfigMap +metadata: + name: {{ .Release.Name }}-config +data: +{{- range $key, $val := .Values.config }} + SREVIEW_{{ upper $key }}: '{{ $val }}' +{{- end }} +--- +apiVersion: v1 +kind: Secret +metadata: + name: {{ .Release.Name }}-secret +type: Opaque +stringData: +{{- $dbpass := randAlphaNum 40 }} + SREVIEW_ADMINPW: '"{{ .Values.secret.adminpw | default ( randAlphaNum 40 ) }}"' + SREVIEW_DBPASS: '"{{ $dbpass }}"' + SREVIEW_DBISTRING: '"{{ .Values.secret.dbistring | default ( replace "release" .Release.Name ( replace "pw" $dbpass "dbi:Pg:dbname=sreview;host=release-db;user=sreview;password=pw") ) }}"' +{{- if empty .Values.secret.apikey }} + SREVIEW_API_KEY: 'null' +{{- else }} + SREVIEW_API_KEY: '"{{ .Values.secret.apikey }}"' +{{ end }} + SREVIEW_S3_ACCESS_CONFIG: '{{ .Values.secret.s3_access_config | default "{{ .Values.minio.accessKey }}" }}' +--- +apiVersion: v1 +kind: ConfigMap +metadata: + name: {{ .Release.Name }}-run-kube-config +data: + template.ep: {{ .Values.run_kube_template | quote }} --- sreview-0.11.1.orig/helm/sreview/templates/cronjobs.yaml +++ sreview-0.11.1/helm/sreview/templates/cronjobs.yaml @@ -0,0 +1,52 @@ +{{- if not .Values.no_detect_on_cluster }} +--- +apiVersion: batch/v1 +kind: CronJob +metadata: + name: {{ .Release.Name }}-detect +spec: + concurrencyPolicy: Forbid + schedule: 0,30 * * * * + jobTemplate: + metadata: + labels: + app: {{ .Release.Name }}-detect + spec: + template: + metadata: + labels: + app: {{ .Release.Name }}-detect + spec: + restartPolicy: OnFailure + containers: + - name: detect + image: '{{ .Values.containerRoot | default "registry.salsa.debian.org/debconf-video-team/sreview" }}/detect:{{ .Values.containerLabel | default "latest" }}' + imagePullPolicy: {{ .Values.pullPolicy | default "IfNotPresent" }} + command: ["/usr/bin/sreview-detect"] + {{- include "sreview.envvals" . | indent 12 }} +{{- end }} +--- +apiVersion: batch/v1 +kind: CronJob +metadata: + name: {{ .Release.Name }}-import +spec: + concurrencyPolicy: Forbid + schedule: 0,30 * * * * + jobTemplate: + metadata: + labels: + app: {{ .Release.Name }}-import + spec: + template: + metadata: + labels: + app: {{ .Release.Name }}-import + spec: + restartPolicy: OnFailure + containers: + - name: import + image: '{{ .Values.containerRoot | default "registry.salsa.debian.org/debconf-video-team/sreview" }}/detect:{{ .Values.containerLabel | default "latest" }}' + imagePullPolicy: {{ .Values.pullPolicy | default "IfNotPresent" }} + command: ["/usr/bin/sreview-import"] + {{- include "sreview.envvals" . | indent 12 }} --- sreview-0.11.1.orig/helm/sreview/templates/deployments.yaml +++ sreview-0.11.1/helm/sreview/templates/deployments.yaml @@ -0,0 +1,60 @@ +--- +apiVersion: apps/v1 +kind: Deployment +metadata: + name: {{ .Release.Name }}-web +spec: + replicas: {{ .Values.webReplicas | default 3 }} + selector: + matchLabels: + app: {{ .Release.Name }}-web + template: + metadata: + labels: + app: {{ .Release.Name }}-web + spec: + containers: + - name: web + image: '{{ .Values.containerRoot | default "registry.salsa.debian.org/debconf-video-team/sreview" }}/web:{{ .Values.containerLabel | default "latest" }}' + imagePullPolicy: {{ .Values.pullPolicy | default "IfNotPresent" }} + {{- include "sreview.envvals" . | indent 8 }} + resources: + limits: + cpu: 500m + requests: + cpu: 200m + livenessProbe: + httpGet: + path: / + port: 8080 +--- +apiVersion: apps/v1 +kind: Deployment +metadata: + name: {{ .Release.Name }}-master + annotations: + checksum/configmaps: {{ include (print .Template.BasePath "/configmaps.yaml") . | sha256sum }} +spec: + replicas: 1 + selector: + matchLabels: + app: {{ .Release.Name }}-master + template: + metadata: + labels: + app: {{ .Release.Name }}-master + spec: + serviceAccountName: {{ .Release.Name }}-master + containers: + - name: master + image: '{{ .Values.containerRoot | default "registry.salsa.debian.org/debconf-video-team/sreview" }}/master-kube:{{ .Values.containerLabel | default "latest" }}' + imagePullPolicy: {{ .Values.pullPolicy | default "IfNotPresent" }} + {{- include "sreview.envvals" . | indent 8 }} + volumeMounts: + - name: rkconfig + readOnly: true + mountPath: /opt/sreview + volumes: + - name: rkconfig + configMap: + name: {{ .Release.Name }}-run-kube-config --- sreview-0.11.1.orig/helm/sreview/templates/ingress.yaml +++ sreview-0.11.1/helm/sreview/templates/ingress.yaml @@ -0,0 +1,35 @@ +--- +apiVersion: networking.k8s.io/v1 +kind: Ingress +metadata: + name: {{ .Release.Name }}-ingress +{{- with .Values.ingress.labels }} + labels: +{{ toYaml . | indent 4 }} +{{- end }} +{{- with .Values.ingress.annotations }} + annotations: +{{ toYaml . | indent 4 }} +{{- end }} +spec: + rules: + - host: {{ .Values.webHostname | default "sreview.example.com" }} + http: + paths: + - path: / + pathType: Prefix + backend: + service: + name: {{ .Release.Name }}-web + port: + number: 8080 +{{- if .Values.ingress.tls }} + tls: + {{- range .Values.ingress.tls }} + - hosts: + {{- range .hosts }} + - {{ . | quote }} + {{- end }} + secretName: {{ .secretName }} + {{- end }} +{{- end }} --- sreview-0.11.1.orig/helm/sreview/templates/rbac.yaml +++ sreview-0.11.1/helm/sreview/templates/rbac.yaml @@ -0,0 +1,33 @@ +--- +apiVersion: v1 +kind: ServiceAccount +metadata: + name: {{ .Release.Name }}-master +--- +apiVersion: rbac.authorization.k8s.io/v1 +kind: Role +metadata: + name: {{ .Release.Name }}-manage-jobs +rules: +- apiGroups: [""] + resources: ["pods"] + verbs: ["get", "watch", "list"] +- apiGroups: ["batch", "extensions"] + resources: ["jobs"] + verbs: ["get", "list", "watch", "create", "update", "patch", "delete"] +- apiGroups: ["kubequeue.grep.be"] + resources: ["jobentries"] + verbs: ["get","list","watch","create","update","patch","delete"] +--- +apiVersion: rbac.authorization.k8s.io/v1 +kind: RoleBinding +metadata: + name: {{ .Release.Name }}-manage-jobs +subjects: +- kind: ServiceAccount + name: {{ .Release.Name }}-master + apiGroup: "" +roleRef: + kind: Role + name: {{ .Release.Name }}-manage-jobs + apiGroup: rbac.authorization.k8s.io --- sreview-0.11.1.orig/helm/sreview/templates/services.yaml +++ sreview-0.11.1/helm/sreview/templates/services.yaml @@ -0,0 +1,14 @@ +--- +apiVersion: v1 +kind: Service +metadata: + name: {{ .Release.Name }}-web +spec: + type: NodePort + selector: + app: {{ .Release.Name }}-web + ports: + - name: http + protocol: TCP + port: 8080 + targetPort: 8080 --- sreview-0.11.1.orig/helm/sreview/values.yaml +++ sreview-0.11.1/helm/sreview/values.yaml @@ -0,0 +1,35 @@ +# Set SReview configuration values here. For a full list of +# all the possible configuration values with their documentation, run +# docker run --rm -ti registry.salsa.debian.org/debconf-video-team/sreview/encoder sreview-config -a dump +# Note that everything needs to be JSON-encoded; that includes +# strings, which means you have to double-quote them. See the +# "adminuser" configuration value for an example. +config: + adminuser: '"admin@example.com"' + accessmethods: '{"input": "S3", "intermediate": "S3", "output": "S3"}' + inputglob: '"input/*"' + pubdir: '"inter"' + outputdir: '"output"' +secret: + # Set this to override the administrator password. If left unset, will + # generate one. + adminpw: + # Set this to configure an external database (see below) + dbistring: + # Set this if you want a working API key. If left unset, will generate + # one. + apikey: + # Set this to configure an external S3 store (see below). + s3_access_config: +# if you want to use a PostgreSQL database outside of Kubernetes, set +# the following to false and make sreview.secret.dbistring point to +# your external server. If you want to run PostgreSQL on your +# Kubernetes cluster, keep it at true; in that case, secret.dbistring +# will be ignored. +use_internal_pg: true +# if you want to use an object store outside of Kubernetes (highly +# recommended), set the following to false and make +# secret.s3_access_config point to your external object store. If you +# want to run a minio on your Kubernetes cluster, keep it at true; +# secret.s3_access_config will be ignored. +use_internal_minio: true --- sreview-0.11.1.orig/helm/testvals.yaml +++ sreview-0.11.1/helm/testvals.yaml @@ -0,0 +1,7 @@ +pullPolicy: Always +containerLabel: main +webHostname: sreviewk.example.com +config: + schedule_format: '"penta"' + schedule_options: '{"url":"https://fosdem.org/2021/schedule/xml"}' + event: '"FOSDEM 2021"' --- sreview-0.11.1.orig/javascript-test/test.html +++ sreview-0.11.1/javascript-test/test.html @@ -0,0 +1,39 @@ + + + + + + SReview javascript tests + + + +
+
+ + + + + +