#3419: Hosting Fedora Badges
------------------------------------------------+------------------------
Reporter: rossdylan | Owner: webmaster
Type: Hosting Request | Status: new
Priority: minor | Milestone: Fedora 18
Component: Web Content | Version: Test
Severity: Normal | Resolution:
Keywords: fedbadges fedbadges pyramid python | Blocked By:
Blocking: |
------------------------------------------------+------------------------
Comment (by toshio):
I wrote an "RFC" about creating databases a long time ago but I don't
think any of the app developers follow it even though they thought it was
sensible. :-)
* We'll use a database superuser to create a db and thus own it
* The db superuser will create the schema for the db
* The db supervisor will grant the necessary permissions to select,
insert, and update to a db user $DBNAMEapp which will be used for the web
application's day-to-day operation. The password for this must
necessarily be added to a config file where the web app runs
* Additional db accounts can be created that target the specific
permissions that are needed by pieces of the system (for instance, if a
cron job needs to add to tables that the web app would never write to)
* Schema updates should *not* be possible by the $DBNAMEapp account
--
Ticket URL: <https://fedorahosted.org/fedora-infrastructure/ticket/3419#comment:2>
Fedora Infrastructure <http://fedoraproject.org/wiki/Infrastructure>
Fedora Infrastructure Project for Bugs, feature requests and access to our source code.
--
websites mailing list
websites@xxxxxxxxxxxxxxxxxxxxxxx
https://admin.fedoraproject.org/mailman/listinfo/websites
