After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 771647 - Please create a ODRS VM
Please create a ODRS VM
Status: RESOLVED FIXED
Product: sysadmin
Classification: Infrastructure
Component: Other
unspecified
Other Linux
: Normal normal
: ---
Assigned To: GNOME Sysadmins
GNOME Sysadmins
Depends on:
Blocks:
 
 
Reported: 2016-09-19 08:38 UTC by Richard Hughes
Modified: 2016-09-26 15:41 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Richard Hughes 2016-09-19 08:38:35 UTC
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
Comment 1 Andrea Veri 2016-09-26 15:41:56 UTC
All done here, we're live.