Difference between revisions of "SAC:Budget"

From OSGeo
Jump to navigation Jump to search
 
(15 intermediate revisions by 2 users not shown)
Line 9: Line 9:
 
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 
! Item !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 
|-
 
|-
| Budget || 51950 [0] || 0 || Total Requested
+
| Budget || 51800 [0] || 0 || Total Requested
 
|-
 
|-
 
| Hosting || 6,500 [0] || 0 ||OSUOSL for hosting services $6500  
 
| Hosting || 6,500 [0] || 0 ||OSUOSL for hosting services $6500  
Line 23: Line 23:
 
| Domains || 300 [0] ||0  || Renewals, expect 5 domains (~$15 x 5 years each)
 
| Domains || 300 [0] ||0  || Renewals, expect 5 domains (~$15 x 5 years each)
 
|-
 
|-
| Sysadmin || 38,400 [0] || 0  || Specific or General support contracts. Can be used in any hours desired and rate/hr, to be approved by SAC PSC. Key items for this year: Upgrade LDAP (requires db upgrade as well), Osgeo6, OSGeo7, secure, new mail system, migrate mailing lists to discourse} |}
+
| Sysadmin || 38,400 [0] || 0  || 300 hrs contract time to be split up as needed -- Specific or General support contracts. Can be used in any hours desired and rate/hr, to be approved by SAC PSC. Key items for this year: Upgrade LDAP and secure (requires db upgrade as well - estimated 20 hrs), Osgeo6 , OSGeo7 (estimated 4 hrs barring no issues), new mail system for use by all services including mailman, discourse, website, etc (estimated 20-60 hrs), migrate mailing lists to discourse
 +
|}
 +
 
 +
 
 +
=== SysAmin contracts ===
 +
{| class="wikitable sortable"
 +
|-
 +
! Name !! Hours !! Amount(Proposed)[Approved] !! Amount(Spent) !!Notes
 +
|-
 +
|  Regina || 100  [0] || 12800 [0] ||  || Major upgrades planned: pretalx (major upgrade flip to postgres from mysql, mysql will soon be retired by pretalx team as an option)
 +
, osgeo7 (upgrade from Ubuntu 20.04 to 24.04), Osgeo3, Osgeo4, osgeo8, and osgeo9 to 24.04 (from 22.04) , secure rebuild (from buster to bookworm, and major upgrade to LDAP db, currently will fail upgrade without upgrading the db to latest format as well, I'm planning to rebuild secure from scratch rather than upgrading from buster to current version) - this I expect to run into a lot of obstacles (20-50 hrs of time), General support
 +
|-
 +
|  Sandro || 100 [0]  || 12800 [0] || || New mail system (major upgrade to be used by mailman, discourse, gitea, and all other osgeo services), ansible standardization; General support
 +
|-
 +
|  Vicky ||100 [0]  || 12800 [0]  ||  || Mailing lists to Discourse migration and mirroring, website/wordpress fixes to support newer PHP,  General support
 +
|-
 +
|  ? || ? || || || Upgrade osgeo6 and upgrade to mailman3?  or should we just live forever on mailman2 or force all mailing lists to discourse
 +
|}
  
 
== 2024 ==
 
== 2024 ==
Line 44: Line 61:
 
| Donations open source infra projects || 4,000 [0] || 0 || See https://wiki.osgeo.org/wiki/SAC:Budget#Donations_open_source_infra_projects
 
| Donations open source infra projects || 4,000 [0] || 0 || See https://wiki.osgeo.org/wiki/SAC:Budget#Donations_open_source_infra_projects
 
|-
 
|-
| Domains || 300 [0] ||0 || Renewals, expect 5 domains (~$15 x 5 years each)
+
| Domains || 300 [0] ||341 || Renewals, 13 renewals and registrations for 1 year $21.85/year
 
|-
 
|-
| Sysadmin || 38,400 [0] || 0 || Specific or General support contracts. Can be used in any hours desired and rate/hr, to be approved by SAC PSC. Key items for this year: Upgrade LDAP, Osgeo6, OSGeo7, secure, pretalx, wiki, matrix, mail system, migrate mailing lists to discourse, standardize infra on ansible, update documentation on our system setup
+
| Sysadmin || 38,400 [19200] || ~19200 || Specific or General support contracts. Can be used in any hours desired and rate/hr, to be approved by SAC PSC. Key items for this year: Upgrade LDAP, Osgeo6, OSGeo7, secure, pretalx, wiki, matrix, mail system, migrate mailing lists to discourse, standardize infra on ansible, update documentation on our system setup
  
 
|}
 
|}

Latest revision as of 06:56, 11 December 2024

Please help fill in the based on this pdf report from the treasurer. Budget allocations can be found via general budget pages on the wiki.

2025

OSGeo_Budget_2025

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 51800 [0] 0 Total Requested
Hosting 6,500 [0] 0 OSUOSL for hosting services $6500
Wordpress ACF Pro Plugin 150[0] 0 https://www.advancedcustomfields.com/pro/?utm_source=ACF+PRO (needed for both prod and dev)
Limesurvey 100 [0] 0 ComfUpdate payment
Hardware Supplies 2,500 [0] 0 Emergency reserve for replacing parts as needed (drives, power supplies etc) and new hard drives, but not planned any change
Donations open source infra projects 4,000 [0] 0 See https://wiki.osgeo.org/wiki/SAC:Budget#Donations_open_source_infra_projects
Domains 300 [0] 0 Renewals, expect 5 domains (~$15 x 5 years each)
Sysadmin 38,400 [0] 0 300 hrs contract time to be split up as needed -- Specific or General support contracts. Can be used in any hours desired and rate/hr, to be approved by SAC PSC. Key items for this year: Upgrade LDAP and secure (requires db upgrade as well - estimated 20 hrs), Osgeo6 , OSGeo7 (estimated 4 hrs barring no issues), new mail system for use by all services including mailman, discourse, website, etc (estimated 20-60 hrs), migrate mailing lists to discourse


SysAmin contracts

Name Hours Amount(Proposed)[Approved] Amount(Spent) Notes
Regina 100 [0] 12800 [0] Major upgrades planned: pretalx (major upgrade flip to postgres from mysql, mysql will soon be retired by pretalx team as an option)

, osgeo7 (upgrade from Ubuntu 20.04 to 24.04), Osgeo3, Osgeo4, osgeo8, and osgeo9 to 24.04 (from 22.04) , secure rebuild (from buster to bookworm, and major upgrade to LDAP db, currently will fail upgrade without upgrading the db to latest format as well, I'm planning to rebuild secure from scratch rather than upgrading from buster to current version) - this I expect to run into a lot of obstacles (20-50 hrs of time), General support

Sandro 100 [0] 12800 [0] New mail system (major upgrade to be used by mailman, discourse, gitea, and all other osgeo services), ansible standardization; General support
Vicky 100 [0] 12800 [0] Mailing lists to Discourse migration and mirroring, website/wordpress fixes to support newer PHP, General support
? ? Upgrade osgeo6 and upgrade to mailman3? or should we just live forever on mailman2 or force all mailing lists to discourse

2024

OSGeo_Budget_2024

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 51950 [21500] 0 Total Requested
Hosting 6,500 [0] 0 OSUOSL for hosting services $6500
Wordpress ACF Pro Plugin 150[0] 0 https://www.advancedcustomfields.com/pro/?utm_source=ACF+PRO (needed for both prod and dev)
Limesurvey 100 [0] 0 ComfUpdate payment
Hardware Supplies 2,500 [0] 0 Emergency reserve for replacing parts as needed (drives, power supplies etc) and new hard drives, but not planned any change
Donations open source infra projects 4,000 [0] 0 See https://wiki.osgeo.org/wiki/SAC:Budget#Donations_open_source_infra_projects
Domains 300 [0] 341 Renewals, 13 renewals and registrations for 1 year $21.85/year
Sysadmin 38,400 [19200] ~19200 Specific or General support contracts. Can be used in any hours desired and rate/hr, to be approved by SAC PSC. Key items for this year: Upgrade LDAP, Osgeo6, OSGeo7, secure, pretalx, wiki, matrix, mail system, migrate mailing lists to discourse, standardize infra on ansible, update documentation on our system setup

Donations open source infra projects

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Pretalx 500 [0] 0
weblate 500 [0] 0
Matrix 500 [0] 0
LiberaChat 500 [0] 0
Trac 500 [0] 0
gitea 500 [0] 0
LXD/Incus (main contributor) 500 [0] 0
jitsi 500 [0] 0

SysAmin contracts

Name Hours Amount(Proposed)[Approved] Amount(Spent) Notes
Regina 100 [50] 12800 [6400] Upgrades: wiki (major upgrade, our version is EOL), pretalx (major upgrade flip to postgres, new preferred db), osgeo7, osgeo6, ldap (this is a major upgrade since requires db upgrade); Other upgrades as needed; General support
Sandro 100 [50] 12800 [6400] Upgrade mail (major upgrade to be used by mailman and discourse), matrix (newer clients will not be able to use soon without upgrade); ansible standardization; General support
Vicky 100 [50] 12800 [6400] Discourse migration and mirroring, website/wordpress, ansible standardization, nginx, General support

2023

Submitted to Board

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 32550 [32550] ? Total Requested
Hosting 6000 [6000] ? Donation to OSUOSL for hosting services $6000
Hardware Supplies 2,500 [0] 0 Reserve for replacing parts as needed (drives, power supplies etc)
Cloud Hosting 1,000 [1000] 0 Fund for utilizing 3rd party cloud services
Donations open source infra projects 4,000 [4000] $2582? Given: Pretalx, weblate, Matrix, LiberaChat, Limesurvey, Trac, gitea, incus/lxd (main contributor), LimeSurvey Comfupdate ($82)
Domains 300 [300] 136 Renewals, expect 3 domains (~$15 x 5 years each)
Sysadmin 18750 [18750] ~$18592 150 hours, ~3x 50 hour general support contracts (~6250 USD each)


Donations open source infra projects

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Pretalx 500 500
weblate 500 500
Matrix 500 0
LiberaChat 500 500
Trac 500 ?
gitea 500 [0] ?
LXD/Incus (main contributor) 500 [0] 500
jitsi 500 [0] ?
Limesurvey 82 82

2022

Submitted to Board

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 32550 [32,550] 26905.32 Total Requested
Hosting 5000 [5000] 5000 Donation to OSUOSL for hosting services $5000
Hardware Supplies 2,500 [2,500] ~$526 Drives for osgeo8 and osgeo9
Cloud Hosting 2,000 [2,000] 0 Fund for utilizing 3rd party cloud services
Donations open source infra projects 4,000 [4,000] ~2582 USD Currently dispensed: Pretalx , Weblate, Limesurvey (78 Euro) for comfort update tool), gitea, LiberaChat , Matrix. Help keep software we use FOSS in particular projects with very few developers
Domains 300 [300] 22.65 + 377.5 + 22.65 = 422.80 Renewals, expect 3 domains (~$15 x 5 years each)
Sysadmin 18750 [18750] 5975 + 6200 + 1891 + 1891 + 1580 + 713 + 124 ($18374) 150 hours, ~3x 50 hour general support contracts (~6250 USD each)

2021

Submitted to Board - [vote]

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 35100 [30,700] 0 Total Requested - New amount is $31600 + (with $3500 carried from 2020 contract - see below)
Hosting 4,600 0 Donation to OSUOSL for hosting services $4600
Hardware Supplies 1,000 0 Reserve for replacing parts as needed (drives, power supplies etc)
Cloud Hosting 6,000 0 Fund for utilizing 3rd party cloud services as needed includes Travis ($5000) + $1000 set aside for others
Domains 300 0 Renewals, expect 3 domains (~$15 x 5 years each), expect a few transfers from Eclipse Foundation.
Sysadmin 13200 [8800] 0 120 hours, ~3x 40 hour general support contracts (~4400 USD each)
Wiki LDAP Completion $6,500 $8050 Contract to complete migration Wiki logins to LDAP, OSGeo single sign on. This amount is the maximum, it could cost less based on actual hours required to complete.
Wiki LDAP $3,500 $3,500 Existing contract commitment from 2020.


  • Regina - I think funtoo we should discontinue because we only had limesurvey on there and I have since moved that to osgeo3. We will be using more OSUOSL resources for the osgeo8 and osgeo9 so that $600 saved on funtoo should be allocated to OSUOSL to compensate for the extra rackspace and support we'll need.
  • Alex - Wiki LDAP project was split for easier accounting and the need to carry an already contracted amount over. Compromise in terms of total support hours, +20 from 100 hours in light of budget constraints, and the ongoing Wiki LDAP project costs. We only spent 100 hours last year, the remaining being spent on the Wiki LDAP project. On mailing list somewhere between 2-4 contracts was suggested 100-200 hours.
  • Jody - isolated prior commitment into a distinct line, board does not hold over budget annually so I wanted to phrase this as a existing contract commitment.

2020

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 28350 ~12632 Total Requested
Hosting 4,600 ? Donation to OSUOSL for hosting services $4000, $500 to funtoo (as monthly payments of $50/mth).
Hardware Supplies 1,000 742 Reserve for replacing parts as needed (drives, power supplies etc)
Cloud Hosting 6,000 ? Fund for utilizing 3rd party cloud services as needed includes Travis ($5000) + $1000 set aside for others
Domains 250 390 Renewals and new ones: postgis.net, gdal.org, proj.org, geotools.org, mapserver.org
Sysadmin 16500 16500[Contracted, ~$11,500 spent] 3x 50 hour support contracts (~5500 USD each), 1 for Wiki/LDAP, 2 for general support/upgrade

2019

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 23750 15351.72 Total Requested and Approved
Hosting 5,000 $4000+6*50?/month Donation to OSUOSL for hosting services $4000, to make up for last year, $1000 to funtoo (as monthly payments of $50).
Hardware Supplies 1,000 776 Reserve for replacing parts as needed (drives, power supplies etc)
Cloud Hosting 1,000 Fund for utilizing 3rd party cloud services as needed
Domains 250 275.72 (65+56+24.72+65+65) Renewals and new ones: postgis.net, gdal.org, proj.org, geotools.org, mapserver.org
Sysadmin 16500? 10000 3x 50 hour support contracts (~5500 USD each), at least 1 for wordpress, 1 for wiki LDAP migration, and 1 for general server support.

2018

Item Amount(Proposed)[Approved] Amount(Spent) Notes
Budget 20,250[20,000] 10201
Hosting 2,000 0 Donation to OSUOSL for hosting services - Was held up waiting for board to add more funds.
OSGeo7 6,000 7,221 New machine to replace OSGeo3. Was budgeted last year but not spent/purchased due to logistics.
Cloud Hosting 1,000 Travis?? Fund for utilizing 3rd party cloud services as needed
Domains 250 230 Renewals and new ones (65+56+19+45+45)
Sysadmin 11,000 ~2,750 2x 50 hour support contracts

2017

Item Amount Notes
Budget 15,000 (+$3000 for new website if needed)
WebSite Hosting Transfer -384.03 GetInteractive
Cloud Hosting -100.00 34.95 Euro/month, estimated cost 2.5 months.
Sysadmin -5533.05 strk, 5000 EUR (USD approximate)

2016

Item Amount Notes
Budget 12,800
SSL Certs -744.51 3 yr.
Domains -195.97
Sysadmin -5200 strk, 5000 EUR (USD approximate)

2015

Item Amount Notes
Budget 8,700.00
OSGeo6 -5,580.82
Domains -214.00
CodeHaus Move Contract -800.00


2014

Item Amount Notes
Budget 12054
Hard Drive & PSU Replacement -245.06 3 yr.
PEER1 Hosting -1,903.73


2013

Item Amount Notes
Budget 12054
Backup Server -2,403.00
PEER 1 Hosting -1,204.51
OSUOSL Hosting (Donation) -3150.00

2012

Item Amount Notes
Budget 12600
PEER 1 Hosting -7,820.15

2011

Item Amount Notes
Budget ?
SSL Certs -1,499 5 yr. OV
PEER 1 Hosting -6,993.68

2010

Item Amount Notes
Budget 9900
OSGeo 3/4 -15,239.69
Domains -440.00
Peer Directed Projects Center / Freenode -77.00 Anyone remember what this was for?
PEER 1 Hosting -13,851.98
Perflect / PSD2HTML -533.00 Anyone remember what this was for?

2009

Item Amount Notes
Budget ?
SSL Certs ? 3 yr.
Domains ?


2008

Item Amount Notes
Budget ?
SSL Certs ? 3 yr.
Domains ?


2007

Item Amount Notes
Budget ?
SSL Certs ? 3 yr.
Domains ?