2012 Developer budget: Difference between revisions

From Wikimedia UK
Jump to navigation Jump to search
(expanding a bit)
(expanding)
Line 124: Line 124:
* Using SmartDebit API. Integrate with CiviCRM.
* Using SmartDebit API. Integrate with CiviCRM.
* Partnership with others via [http://civicrm.org/mih#ukdd] - details at [http://wiki.civicrm.org/confluence/display/CRM/Direct+Debit+integration+%28UK%29+requirements+and+specification]
* Partnership with others via [http://civicrm.org/mih#ukdd] - details at [http://wiki.civicrm.org/confluence/display/CRM/Direct+Debit+integration+%28UK%29+requirements+and+specification]
* Needs additional funding of circa £1500 to get the development started. Recommend that we provide this funding.


=== Gift Aid solution ===
=== Gift Aid solution ===
Line 132: Line 133:
* Toolserver grant
* Toolserver grant
* Mass upload tool
* Mass upload tool
== Budget ==
{| class="wikitable"
|-
! Description !! Amount
|-
| 'Confidential' server (VPS) || £320
|-
| 'Community' server || ???
|-
| Mirror server || £6,700?
|-
| Backup server || ???
|-
| SSL certificates || £250?
|-
| Domain names || £250
|-
| Sysadmin || £7,000?
|-
| QRPedia || ??
|-
| Fundraising || ???
|-
| Direct Debit || £1,500?
|-
| Gift Aid || ???
|-
| Unallocated || £13,020
|-
| '''Total''' || £30,000
|}

Revision as of 02:23, 12 January 2012

Comment This is currently a draft being put together by Mike Peel. Please help improve it!

We currently have a budget of £30k allocated towards our developer activities. The 2012 Activity Plan summarises this as follows:

"Various needs including maintaining the WMUK websites and email systems (including the donation site and QRpedia), and developing MediaWiki to support the global projects and general wiki community. Expected to be contract work, rather than a single employee. QRpedia will be the first software project that WMUK has run and should complement the services supplied from Germany and the U.S. More essential is the need to maintain our part of the fundraising software."

This page fleshes out this summary, providing more technical and contextual information, as well as a breakdown of the budget into the appropriate subsections. It is intended to be relevant in the period 1 February 2012 through to 31 January 2013.

Status as of January 2012

Our websites and general online tech needs currently utilize a Virtual Private Server donated and managed by Mike Peel, as well as hosting provided by the Wikimedia Foundation. These needs are currently as follows (they are hosted by WMUK unless otherwise stated).

  • Wikis
    • Public wiki: hosted by the WMF (tied in with Single User Login)
    • Private wikis (office and board, plus the largely-unused internal wiki)
    • Project wikis (britainloveswikipedia.org)
  • Wordpress for our blog
  • CiviCRM (with Joomla) for donations
  • DirectDebit form (custom software)
  • glamwiki.org
  • Email
    • Personal addresses - POP/IMAP/SMTP, webmail. Also many forwarders.
    • Mailing lists (mailman)
    • Forwarders to OTRS

We also have service providers for domain names and SSL certificates.

Upcoming needs and opportunities

  • All of the above need maintaining and upgrading
  • The direct debit form needs moving from an iframe solution to an API solution, ideally directly integrated with CiviCRM
  • Gift Aid for CiviCRM
  • QRPedia
  • Hosting a mirror of the Wikimedia project dumps - see [1]
  • OTRS/other CRM system
  • We need to establish a more robust backup plan
  • Security review, and improvements based on the outcome of that review
  • Mediawiki development
  • 2012-13 fundraiser (does this fall under this budget, or the fundraiser budget?)
    • Banner design
    • Landing page design, including forms
  • wikipedia.org.uk portal (e.g. like http://www.wikipedia.pl/ )?
  • Expense system?
  • Community server?

General approach

Since our needs are so varied in terms of the skills and knowledge they require, and each need does not require a significant amount of work at the current time, our general approach is to hire contractors as needed, and to collaborate with partners where possible. Also offer bounties for development of specific non-urgent things?

Note that a single person could fulfill the needs of several contracts.

Infrastructure

Servers

The current solution of a VPS works well for our current purposes, but our needs will go beyond this. Suggest a trio (or quadruple) of setups:

  1. 'Confidential' server - donation website, internal wikis, email. Either stick with existing VPS fully migrated to WMUK ownership, or new VPS.
  2. 'Community' server - WMUK projects (QRPedia etc), tools that don't fit in on the toolserver or Wikimedia Labs. Could go with either VPS or dedicated server. Would need logins for individuals, an SVN, etc.
  3. 'Mirror' server - needs to have large disk and bandwidth capacity. Needs to be a dedicated server.
  4. 'Backup' server - not sure whether this is needed or not, but we need somewhere off the main servers to keep backups.

Projected costs are:

  1. VPS - Webfusion community VPS, £30/month inc. VAT = £360
  2. Mirror server. A Dell PowerEdge R510 server, with space for up to 12 hard disks, 4 core 2.16GHz CPU, 16GB memory (probably don't need this amount; cost over 4GB is £200), 12 2TB HDs (24TB in total) costs circa £5,500. Coloration for a 2U server with 10Mbit connection is circa £100/month (but may be donated for free). Hence total cost for server and 1 year of operation is circa £6,700. Would need sysadmin in place to set it up.

SSL certificates

We are currently using an interim system that provides adequate security for our fundraising subdomains (including 256-bit encryption), but there is a lot of scope to improve here. The best solution would be to have a "wildcard" certificate for wikimedia.org.uk that comprehensively covers all of the sections of the website, includes a warranty in the case of problems, and is signed by the industry-standard GlobalSign organisation. Options here include:

  • 123-reg Domain or Organisation SSL, with Wildcard, either £175/year (£150/year for 2+ years), or £225/year (£200/year for 2+ years)
  • GlobalSign directly, £429-£499/year

This issue should be resolved once we have a sysadmin in place to fully implement it.

Domain portfolio

There are several issues here, which depend more on strategy and legal advice rather more than they do on budgetary requirements or technical possibilities.

Wikimedia UK currently owns 6 domain names:

  1. wikimedia.org.uk *
  2. wikimedia.co.uk *
  3. britainloveswikipedia.org
  4. glamwiki.org *
  5. monmouthpedia.org
  6. scotwiki.org

Those marked with * are core to our long-term activities; the other domains are currently being used for specific projects whose duration is currently unclear. All of our domains are currently renewed on the minimum period permitted (1 year for .com/.net/.org domains, 2 years for .co.uk/.org.uk domains). It is recommended that those marked with * are renewed for the maximum period possible to ensure long-term stability.

Renewal costs are £2.95+VAT(=£3.45)/year for .uk domains, £9.49+VAT(=11.49)/year for .org domains. As such the budget here is:

  • wikimedia.*.uk domains: 2*10 years = £69
  • glamwiki.org: 10 years = 114.90
  • Others: 3*1 year = 34.47
  • Total = £218.37

We may want to register alternative forms of the URLs to avoid squatters - costs per year per domain would be as above.

We currently do not own any of the UK domain names for the Wikimedia projects (or their common misspellings); nor does the WMF. Some of these are owned by volunteers, others by domain squatters. We currently lack a strategy or effective solution here due to legal ambiguities - the Wikimedia projects are trademarked by the Wikimedia Foundation, and the WMF have not given us permission to use the trademarks in this fashion, but they are equally not registering these domains themselves. The costs with registering the domains are minimal, but time needs to be invested in identifying and contacting the domain owners (Mike Peel is willing to volunteer to do this), and time (and possibly legal advice and additional money, including transfer fees) may be needed to transfer the domains to WMUK (or WMF) ownership as necessary. This is to be discussed with Geoff Brigham and Michelle Paulson over the next few months.

Contracts

Sysadmin

Skills needed:

  • Prior experience administrating web servers running Linux operating systems
  • Experience with PHP (programming) and MySQL (database)
  • Experience with Mediawiki, CiviCRM, Wordpress (desirable)

Tasks will include:

  • Set up and manage WMUK-operated servers, including migrating projects between servers as needed
  • Maintain existing software, carrying out upgrades, reconfigurations and ensuring security
  • Ensure regular backups, both online and offline
  • Establish and manage a CRM system for dealing with incoming emails
  • Manage domain names, including renewal and subdomains
  • Manage SSL certificates, and ensure the security of donation websites

Would report to the Chief Exec for management purposes, would liaise with Mike Peel on the technical side.

Hourly rate - unsure what the norm is here. Suggest somewhere between £15-£20 per hour (probably an underestimate), with the expectation that they'd be working between 5 and 10 hours per week (will vary unpredictably over the course of the year). Hence would cost somewhere around £7k per year.

External security review

QRPedia development

Things like:

  1. Multilingual user interface for the webpage?
  2. Stats tools
  3. Special features for partnership organisations?

Mediawiki development

Needs identification of Mediawiki projects to support.

Fundraising

Will become relevant in the run-up to the 2012-13 fundraiser, particularly during the testing period over the summer, and the actual fundraiser period. Unclear whether this will be covered by this budget, or the fundraiser budget.

Partnerships

Direct Debit solution

  • Using SmartDebit API. Integrate with CiviCRM.
  • Partnership with others via [2] - details at [3]
  • Needs additional funding of circa £1500 to get the development started. Recommend that we provide this funding.

Gift Aid solution

  • Integrate with CiviCRM.

Other relevant budgets

There are two budget lines relevant to the general issue of tech, but which aren't covered here:

  • Toolserver grant
  • Mass upload tool

Budget

Description Amount
'Confidential' server (VPS) £320
'Community' server ???
Mirror server £6,700?
Backup server ???
SSL certificates £250?
Domain names £250
Sysadmin £7,000?
QRPedia ??
Fundraising ???
Direct Debit £1,500?
Gift Aid ???
Unallocated £13,020
Total £30,000