[Bug 771647] New: Please create a ODRS VM

["sysadmin" (GNOME Bugzilla) <bugzilla gnome org>]

Bug ID	771647
Summary	Please create a ODRS VM
Classification	Infrastructure
Product	sysadmin
Version	unspecified
OS	Linux
Status	NEW
Severity	normal
Priority	Normal
Component	Other
Assignee	sysadmin-maint@gnome.bugs
Reporter	richard@hughsie.com
QA Contact	sysadmin-maint@gnome.bugs
GNOME version	---

The ODRS is a web service designed as a replacement for the
proprietary Ubuntu Reviews server.

>Which software you will need installed. (i.e PHP, Mysql)

This is what I install at the moment using the distro pakages: python3-PyMySQL,
python3-flask, python3-flask-wtf, python3-flask-login, mariadb

If you're using PIP for provisioning, I that would be 'Flask>=0.10.1',
'Flask-Login', 'PyMySQL'

I need a database (MySQL/MariaDB preferably) ideally with the name "odrs"
although that's easy enough to change in the code (it just makes migration
easier). The schema is here
https://github.com/hughsie/odrs-website/blob/master/README.md#how-do-i-set-up-the-database
although I wouldn't mind being able to run the mysql command line client every
now and again to change the schema and run custom upgrade commands (if that's
something you'd allow).

> A link to a tarball with website's content.

The code is all in git: https://github.com/hughsie/odrs-website with the
exception of the hash secret which is needed to allow users to revoke only
their own reviews. At the moment on OpenShift I set a custom environment
variable, but I guess I can ssh that into place manually, but ideas welcome.
The website is being updated every couple of weeks with new features, so
ideally there'd be a way for me to upload new content automatically without
getting someone to deploy it for me. Again, ideas welcome.

> If the website makes use of a Mysql database, please dump the database and if it doesn't contain any private content attach it to the email.

I don't know if the review data should be "public"; there are deleted posts
there and also hashed IP addresses. I'd also like to have a "flag day" where we
stop the old instance, dump the database, import the database to the new VM,
start the new service and then get all queries to the old endpoint forwarded to
the new VM. But, if you need a dump of the data for compliance or other reasons
please just let me know.

I'm also happy to use the GNOME website visual styling and make the service
"fit in" with the other websites, so if you have any pointers on that please
let me know. Thanks!

Richard

---

      You are receiving this mail because:

• You are watching the QA Contact of the bug.
• You are watching the assignee of the bug.