https://bugzilla.gnome.org/show_bug.cgi?id=771647

            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-ma...@gnome.bugs
          Reporter: rich...@hughsie.com
        QA Contact: sysadmin-ma...@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.
_______________________________________________
gnome-infrastructure mailing list
gnome-infrastructure@gnome.org
https://mail.gnome.org/mailman/listinfo/gnome-infrastructure

Reply via email to