[SAC] Vote request to extend Sysadmin Contract 2019-I amount for another $5000

Committees SAC mailing list
1

The Sysadmin Contract I had a Service completion date of September 30th, 2019 and capped at $5000.

I have already reached the cap limit and am requesting an extension of budget, which I will submit formally if all are in agreement.

What I’d like to accomplish in next round, which I hope to do in a new $5000 budget

https://trac.osgeo.org/osgeo/query?status=new&status=reopened&milestone=Sysadmin+Contract+2019-I

  1. Once osgeo4 has got some new drives in it (plan is to replace with 6 new SATA drives and throw out all the drives (only 2 are still good) and reformatted, firmware upgrade – set it up as a secondary LXD host to use for non-mission critical stuff (like adhoc, buildbots, etc) and also to mirror osgeo7 containers in stopped state for redundancy.

  2. Setup file and database backup for osgeo7 containers – which will get pushed to bacula

  3. Speed up website – with configuring caching of static content like css and images first and then database content if that proves insufficient.

  4. Upgrade Nextcloud to latest version

  5. Create a new wiki with latest Debian, MariaDb and MediaWiki, PHP – right now our wiki everything is EOL’d – the OS, MySQL, and PHP

What was accomplished in the first round is itemized here:

https://trac.osgeo.org/osgeo/query?status=closed&milestone=Sysadmin+Contract+2019-I

With key highlights being

  1. Create new ldap.osgeo.or g ( now on osgeo7) running debian 9

  2. Create new download.osgeo.org (on osgeo7) running debian 9 / nginx

  3. Install letsencrypt on all servers that need it replacing the SSL.com star cert that expired May 1st

  4. Migrate VMS projects, adhoc, web (still need to do some final checks) as is to LXD containers now on osgeo7

  5. Setup 30 day retention lxd image snapshots of key osgeo7 vms

  6. Upgrade LXD to snap 3.12 so always at the latest stable LXD offering

  7. Decommission osgeo4 so it’s ready to be reformatted/firmware upgraded (all old vms have either been rebuilt as new lxd containers or migrated as is using lxd-p2c tool to osgeo7)

Thanks,

Regina

2

On Thu, May 23, 2019 at 06:15:14PM -0400, Regina Obe wrote:

What I'd like to accomplish in next round, which I hope to do in a new $5000
budget

It looks like your MUA wraps long lines, here's the query URL, hoping
it won't get wrapped:

https://trac.osgeo.org/osgeo/query?status=new&status=reopened&milestone=Sysadmin+Contract+2019-I

I think every sysadmin round should include update of all docs, so
that by the end of each slot any other sysadmin can take over, it's
important to keep bus factor low..

1) Create new ldap.osgeo.or g ( now on osgeo7) running debian 9

\o/

2) Create new download.osgeo.org (on osgeo7) running debian 9 / nginx

\o/

3) Install letsencrypt on all servers that need it replacing the
SSL.com star cert that expired May 1st

\o/

4) Migrate VMS projects, adhoc, web (still need to do some final
checks) as is to LXD containers now on osgeo7

\o/

5) Setup 30 day retention lxd image snapshots of key osgeo7 vms
6) Upgrade LXD to snap 3.12 so always at the latest stable LXD offering

LXD is new, right ?
Where's all this LXD for OSGeo business documented ?

7) Decommission osgeo4 so it's ready to be reformatted/firmware
upgraded (all old vms have either been rebuilt as new lxd containers or
migrated as is using lxd-p2c tool to osgeo7)

\o/

I really appreciate all the effort you put into this Regina,
and very much hope it won't be disspated by lack of documentation
and guidance for other SAC members. I know I've been busy and unable
to attend meetings and will likely be the same for the future, so

I'd like to ask you to use email more (like this) and ensure all
procedures for sysadmin work are properly documented, from some common
starting point (last I worked on this the entry point for SAC work
was https://wiki.osgeo.org/wiki/SAC_Service_Status, and I think I'd
still go there to find up-to-date information. Can you make sure, in
the next contract, to update that page with whatever it takes ?
Having that page point to somewhere else is fine, as long as people
are not lost from there :slight_smile:

Thanks again !

--strk;

3

+1

And thank you for your hard work.

···

–
Jody Garnett

4

+1 & big thanks,

Markus

On Fri, May 24, 2019 at 12:15 AM Regina Obe <lr@pcorp.us> wrote:

The Sysadmin Contract I had a Service completion date of September 30th, 2019 and capped at $5000.

I have already reached the cap limit and am requesting an extension of budget, which I will submit formally if all are in agreement.

What I’d like to accomplish in next round, which I hope to do in a new $5000 budget

https://trac.osgeo.org/osgeo/query?status=new&status=reopened&milestone=Sysadmin+Contract+2019-I

1) Once osgeo4 has got some new drives in it (plan is to replace with 6 new SATA drives and throw out all the drives (only 2 are still good) and reformatted, firmware upgrade – set it up as a secondary LXD host to use for non-mission critical stuff (like adhoc, buildbots, etc) and also to mirror osgeo7 containers in stopped state for redundancy.

2) Setup file and database backup for osgeo7 containers – which will get pushed to bacula

3) Speed up website – with configuring caching of static content like css and images first and then database content if that proves insufficient.

4) Upgrade Nextcloud to latest version

5) Create a new wiki with latest Debian, MariaDb and MediaWiki, PHP – right now our wiki everything is EOL’d – the OS, MySQL, and PHP

What was accomplished in the first round is itemized here:

https://trac.osgeo.org/osgeo/query?status=closed&milestone=Sysadmin+Contract+2019-I

With key highlights being

1) Create new ldap.osgeo.or g ( now on osgeo7) running debian 9

2) Create new download.osgeo.org (on osgeo7) running debian 9 / nginx

3) Install letsencrypt on all servers that need it replacing the SSL.com star cert that expired May 1st

4) Migrate VMS projects, adhoc, web (still need to do some final checks) as is to LXD containers now on osgeo7

5) Setup 30 day retention lxd image snapshots of key osgeo7 vms

6) Upgrade LXD to snap 3.12 so always at the latest stable LXD offering

7) Decommission osgeo4 so it’s ready to be reformatted/firmware upgraded (all old vms have either been rebuilt as new lxd containers or migrated as is using lxd-p2c tool to osgeo7)

Thanks,

Regina

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

--
Markus Neteler, PhD
https://www.mundialis.de - free data with free software
https://grass.osgeo.org
https://courses.neteler.org/blog

5

I'm +1, pending discussion of specific tickets to target - I don't think
all the ones listed are important enough to go on the contract. But that
we have other tasks which might be.

Just a few notes:
* This will us up the rest of our 2019 contract budget, we can ask the
board for more if we feel it's necessary.
* I also think we should discuss if want to reserve a % of these hours
for "urgent response" tasks or if it should all be pre-determined tickets.

Based on the vote we should move forward drawing up the exact contract
for signing.

Thanks,
Alex

On 5/30/19 09:50, Markus Neteler wrote:

+1 & big thanks,

Markus

On Fri, May 24, 2019 at 12:15 AM Regina Obe <lr@pcorp.us> wrote:

The Sysadmin Contract I had a Service completion date of September 30th, 2019 and capped at $5000.

I have already reached the cap limit and am requesting an extension of budget, which I will submit formally if all are in agreement.

What I’d like to accomplish in next round, which I hope to do in a new $5000 budget

https://trac.osgeo.org/osgeo/query?status=new&status=reopened&milestone=Sysadmin+Contract+2019-I

1) Once osgeo4 has got some new drives in it (plan is to replace with 6 new SATA drives and throw out all the drives (only 2 are still good) and reformatted, firmware upgrade – set it up as a secondary LXD host to use for non-mission critical stuff (like adhoc, buildbots, etc) and also to mirror osgeo7 containers in stopped state for redundancy.

2) Setup file and database backup for osgeo7 containers – which will get pushed to bacula

3) Speed up website – with configuring caching of static content like css and images first and then database content if that proves insufficient.

4) Upgrade Nextcloud to latest version

5) Create a new wiki with latest Debian, MariaDb and MediaWiki, PHP – right now our wiki everything is EOL’d – the OS, MySQL, and PHP

What was accomplished in the first round is itemized here:

https://trac.osgeo.org/osgeo/query?status=closed&milestone=Sysadmin+Contract+2019-I

With key highlights being

1) Create new ldap.osgeo.or g ( now on osgeo7) running debian 9

2) Create new download.osgeo.org (on osgeo7) running debian 9 / nginx

3) Install letsencrypt on all servers that need it replacing the SSL.com star cert that expired May 1st

4) Migrate VMS projects, adhoc, web (still need to do some final checks) as is to LXD containers now on osgeo7

5) Setup 30 day retention lxd image snapshots of key osgeo7 vms

6) Upgrade LXD to snap 3.12 so always at the latest stable LXD offering

7) Decommission osgeo4 so it’s ready to be reformatted/firmware upgraded (all old vms have either been rebuilt as new lxd containers or migrated as is using lxd-p2c tool to osgeo7)

Thanks,

Regina

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

6

Can we move this forward ?
We really need more maintainance (I agree with "urgent response" planning).
Let's use some trust and not get stuck with this.

I'm +1 for next contract (2019-II, I'd call it) to Regina.

--strk;

On Thu, Jun 06, 2019 at 12:47:06PM -0700, Alex M wrote:

I'm +1, pending discussion of specific tickets to target - I don't think
all the ones listed are important enough to go on the contract. But that
we have other tasks which might be.

Just a few notes:
* This will us up the rest of our 2019 contract budget, we can ask the
board for more if we feel it's necessary.
* I also think we should discuss if want to reserve a % of these hours
for "urgent response" tasks or if it should all be pre-determined tickets.

Based on the vote we should move forward drawing up the exact contract
for signing.

Thanks,
Alex

On 5/30/19 09:50, Markus Neteler wrote:
> +1 & big thanks,
>
> Markus
>
> On Fri, May 24, 2019 at 12:15 AM Regina Obe <lr@pcorp.us> wrote:
>>
>> The Sysadmin Contract I had a Service completion date of September 30th, 2019 and capped at $5000.
>>
>> I have already reached the cap limit and am requesting an extension of budget, which I will submit formally if all are in agreement.
>>
>>
>>
>> What I’d like to accomplish in next round, which I hope to do in a new $5000 budget
>>
>> https://trac.osgeo.org/osgeo/query?status=new&status=reopened&milestone=Sysadmin+Contract+2019-I
>>
>>
>>
>>
>>
>> 1) Once osgeo4 has got some new drives in it (plan is to replace with 6 new SATA drives and throw out all the drives (only 2 are still good) and reformatted, firmware upgrade – set it up as a secondary LXD host to use for non-mission critical stuff (like adhoc, buildbots, etc) and also to mirror osgeo7 containers in stopped state for redundancy.
>>
>> 2) Setup file and database backup for osgeo7 containers – which will get pushed to bacula
>>
>> 3) Speed up website – with configuring caching of static content like css and images first and then database content if that proves insufficient.
>>
>> 4) Upgrade Nextcloud to latest version
>>
>> 5) Create a new wiki with latest Debian, MariaDb and MediaWiki, PHP – right now our wiki everything is EOL’d – the OS, MySQL, and PHP
>>
>>
>>
>>
>>
>> What was accomplished in the first round is itemized here:
>>
>> https://trac.osgeo.org/osgeo/query?status=closed&milestone=Sysadmin+Contract+2019-I
>>
>>
>>
>> With key highlights being
>>
>>
>>
>> 1) Create new ldap.osgeo.or g ( now on osgeo7) running debian 9
>>
>> 2) Create new download.osgeo.org (on osgeo7) running debian 9 / nginx
>>
>> 3) Install letsencrypt on all servers that need it replacing the SSL.com star cert that expired May 1st
>>
>> 4) Migrate VMS projects, adhoc, web (still need to do some final checks) as is to LXD containers now on osgeo7
>>
>> 5) Setup 30 day retention lxd image snapshots of key osgeo7 vms
>>
>> 6) Upgrade LXD to snap 3.12 so always at the latest stable LXD offering
>>
>> 7) Decommission osgeo4 so it’s ready to be reformatted/firmware upgraded (all old vms have either been rebuilt as new lxd containers or migrated as is using lxd-p2c tool to osgeo7)
>>
>>
>>
>>
>>
>> Thanks,
>>
>> Regina

7

Yes, based on the vote we can move ahead with this. I checked and we
actually budgeted for 3 contracts this year, the 3rd was expected to
deal with the main website, not sure if optimization should go to that one.

Regina, want to use the previous contract as a template? Then we just
need to make the new list of tickets to cover under Contract II using
the list you already made as the starting point, we should suggest
additions and removals from that list.

Thanks,
Alex

On 6/13/19 09:51, Sandro Santilli wrote:

Can we move this forward ?
We really need more maintainance (I agree with "urgent response" planning).
Let's use some trust and not get stuck with this.

I'm +1 for next contract (2019-II, I'd call it) to Regina.

--strk;

On Thu, Jun 06, 2019 at 12:47:06PM -0700, Alex M wrote:

I'm +1, pending discussion of specific tickets to target - I don't think
all the ones listed are important enough to go on the contract. But that
we have other tasks which might be.

Just a few notes:
* This will us up the rest of our 2019 contract budget, we can ask the
board for more if we feel it's necessary.
* I also think we should discuss if want to reserve a % of these hours
for "urgent response" tasks or if it should all be pre-determined tickets.

Based on the vote we should move forward drawing up the exact contract
for signing.

Thanks,
Alex

On 5/30/19 09:50, Markus Neteler wrote:

+1 & big thanks,

Markus

On Fri, May 24, 2019 at 12:15 AM Regina Obe <lr@pcorp.us> wrote:

The Sysadmin Contract I had a Service completion date of September 30th, 2019 and capped at $5000.

I have already reached the cap limit and am requesting an extension of budget, which I will submit formally if all are in agreement.

What I’d like to accomplish in next round, which I hope to do in a new $5000 budget

https://trac.osgeo.org/osgeo/query?status=new&status=reopened&milestone=Sysadmin+Contract+2019-I

1) Once osgeo4 has got some new drives in it (plan is to replace with 6 new SATA drives and throw out all the drives (only 2 are still good) and reformatted, firmware upgrade – set it up as a secondary LXD host to use for non-mission critical stuff (like adhoc, buildbots, etc) and also to mirror osgeo7 containers in stopped state for redundancy.

2) Setup file and database backup for osgeo7 containers – which will get pushed to bacula

3) Speed up website – with configuring caching of static content like css and images first and then database content if that proves insufficient.

4) Upgrade Nextcloud to latest version

5) Create a new wiki with latest Debian, MariaDb and MediaWiki, PHP – right now our wiki everything is EOL’d – the OS, MySQL, and PHP

What was accomplished in the first round is itemized here:

https://trac.osgeo.org/osgeo/query?status=closed&milestone=Sysadmin+Contract+2019-I

With key highlights being

1) Create new ldap.osgeo.or g ( now on osgeo7) running debian 9

2) Create new download.osgeo.org (on osgeo7) running debian 9 / nginx

3) Install letsencrypt on all servers that need it replacing the SSL.com star cert that expired May 1st

4) Migrate VMS projects, adhoc, web (still need to do some final checks) as is to LXD containers now on osgeo7

5) Setup 30 day retention lxd image snapshots of key osgeo7 vms

6) Upgrade LXD to snap 3.12 so always at the latest stable LXD offering

7) Decommission osgeo4 so it’s ready to be reformatted/firmware upgraded (all old vms have either been rebuilt as new lxd containers or migrated as is using lxd-p2c tool to osgeo7)

Thanks,

Regina

8

Hello SAC,
Sorry I've been incommunicado; I'm still dealing with an injury from
back in December :frowning:
+1 for Regina to continue the great work under a follow-on contract ASAP.

Take care,
   ~~~Chris~~~

On 6/13/19, Sandro Santilli <strk@kbt.io> wrote:

Can we move this forward ?
We really need more maintainance (I agree with "urgent response" planning).
Let's use some trust and not get stuck with this.

I'm +1 for next contract (2019-II, I'd call it) to Regina.

--strk;

On Thu, Jun 06, 2019 at 12:47:06PM -0700, Alex M wrote:

I'm +1, pending discussion of specific tickets to target - I don't think
all the ones listed are important enough to go on the contract. But that
we have other tasks which might be.

Just a few notes:
* This will us up the rest of our 2019 contract budget, we can ask the
board for more if we feel it's necessary.
* I also think we should discuss if want to reserve a % of these hours
for "urgent response" tasks or if it should all be pre-determined tickets.

Based on the vote we should move forward drawing up the exact contract
for signing.

Thanks,
Alex

On 5/30/19 09:50, Markus Neteler wrote:
> +1 & big thanks,
>
> Markus
>
> On Fri, May 24, 2019 at 12:15 AM Regina Obe <lr@pcorp.us> wrote:
>>
>> The Sysadmin Contract I had a Service completion date of September
>> 30th, 2019 and capped at $5000.
>>
>> I have already reached the cap limit and am requesting an extension of
>> budget, which I will submit formally if all are in agreement.
>>
>>
>>
>> What I’d like to accomplish in next round, which I hope to do in a new
>> $5000 budget
>>
>> https://trac.osgeo.org/osgeo/query?status=new&status=reopened&milestone=Sysadmin+Contract+2019-I
>>
>>
>>
>>
>>
>> 1) Once osgeo4 has got some new drives in it (plan is to replace
>> with 6 new SATA drives and throw out all the drives (only 2 are still
>> good) and reformatted, firmware upgrade – set it up as a secondary LXD
>> host to use for non-mission critical stuff (like adhoc, buildbots, etc)
>> and also to mirror osgeo7 containers in stopped state for redundancy.
>>
>> 2) Setup file and database backup for osgeo7 containers – which
>> will get pushed to bacula
>>
>> 3) Speed up website – with configuring caching of static content
>> like css and images first and then database content if that proves
>> insufficient.
>>
>> 4) Upgrade Nextcloud to latest version
>>
>> 5) Create a new wiki with latest Debian, MariaDb and MediaWiki,
>> PHP – right now our wiki everything is EOL’d – the OS, MySQL, and PHP
>>
>>
>>
>>
>>
>> What was accomplished in the first round is itemized here:
>>
>> https://trac.osgeo.org/osgeo/query?status=closed&milestone=Sysadmin+Contract+2019-I
>>
>>
>>
>> With key highlights being
>>
>>
>>
>> 1) Create new ldap.osgeo.or g ( now on osgeo7) running debian 9
>>
>> 2) Create new download.osgeo.org (on osgeo7) running debian 9 /
>> nginx
>>
>> 3) Install letsencrypt on all servers that need it replacing the
>> SSL.com star cert that expired May 1st
>>
>> 4) Migrate VMS projects, adhoc, web (still need to do some final
>> checks) as is to LXD containers now on osgeo7
>>
>> 5) Setup 30 day retention lxd image snapshots of key osgeo7 vms
>>
>> 6) Upgrade LXD to snap 3.12 so always at the latest stable LXD
>> offering
>>
>> 7) Decommission osgeo4 so it’s ready to be reformatted/firmware
>> upgraded (all old vms have either been rebuilt as new lxd containers or
>> migrated as is using lxd-p2c tool to osgeo7)
>>
>>
>>
>>
>>
>> Thanks,
>>
>> Regina

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

9

Sure will do when I get back from trip next week.

Thanks all,
Regina

-----Original Message-----
From: Sac [mailto:sac-bounces@lists.osgeo.org] On Behalf Of Alex M
Sent: Thursday, June 13, 2019 1:07 PM
To: tech@wildintellect.com; System Administration Committee Discussion/OSGeo <sac@lists.osgeo.org>; Markus Neteler <neteler@osgeo.org>
Subject: Re: [SAC] Vote request to extend Sysadmin Contract 2019-I amount for another $5000

Yes, based on the vote we can move ahead with this. I checked and we actually budgeted for 3 contracts this year, the 3rd was expected to deal with the main website, not sure if optimization should go to that one.

Regina, want to use the previous contract as a template? Then we just need to make the new list of tickets to cover under Contract II using the list you already made as the starting point, we should suggest additions and removals from that list.

Thanks,
Alex

On 6/13/19 09:51, Sandro Santilli wrote:

Can we move this forward ?
We really need more maintainance (I agree with "urgent response" planning).
Let's use some trust and not get stuck with this.

I'm +1 for next contract (2019-II, I'd call it) to Regina.

--strk;

On Thu, Jun 06, 2019 at 12:47:06PM -0700, Alex M wrote:

I'm +1, pending discussion of specific tickets to target - I don't
think all the ones listed are important enough to go on the contract.
But that we have other tasks which might be.

Just a few notes:
* This will us up the rest of our 2019 contract budget, we can ask
the board for more if we feel it's necessary.
* I also think we should discuss if want to reserve a % of these
hours for "urgent response" tasks or if it should all be pre-determined tickets.

Based on the vote we should move forward drawing up the exact
contract for signing.

Thanks,
Alex

On 5/30/19 09:50, Markus Neteler wrote:

+1 & big thanks,

Markus

On Fri, May 24, 2019 at 12:15 AM Regina Obe <lr@pcorp.us> wrote:

The Sysadmin Contract I had a Service completion date of September 30th, 2019 and capped at $5000.

I have already reached the cap limit and am requesting an extension of budget, which I will submit formally if all are in agreement.

What I d like to accomplish in next round, which I hope to do in a
new $5000 budget

https://trac.osgeo.org/osgeo/query?status=new&status=reopened&miles
tone=Sysadmin+Contract+2019-I

1) Once osgeo4 has got some new drives in it (plan is to replace with 6 new SATA drives and throw out all the drives (only 2 are still good) and reformatted, firmware upgrade set it up as a secondary LXD host to use for non-mission critical stuff (like adhoc, buildbots, etc) and also to mirror osgeo7 containers in stopped state for redundancy.

2) Setup file and database backup for osgeo7 containers which will get pushed to bacula

3) Speed up website with configuring caching of static content like css and images first and then database content if that proves insufficient.

4) Upgrade Nextcloud to latest version

5) Create a new wiki with latest Debian, MariaDb and MediaWiki, PHP right now our wiki everything is EOL d the OS, MySQL, and PHP

What was accomplished in the first round is itemized here:

https://trac.osgeo.org/osgeo/query?status=closed&milestone=Sysadmin
+Contract+2019-I

With key highlights being

1) Create new ldap.osgeo.or g ( now on osgeo7) running debian 9

2) Create new download.osgeo.org (on osgeo7) running debian 9 / nginx

3) Install letsencrypt on all servers that need it replacing the SSL.com star cert that expired May 1st

4) Migrate VMS projects, adhoc, web (still need to do some final checks) as is to LXD containers now on osgeo7

5) Setup 30 day retention lxd image snapshots of key osgeo7 vms

6) Upgrade LXD to snap 3.12 so always at the latest stable LXD offering

7) Decommission osgeo4 so it s ready to be reformatted/firmware upgraded (all old vms have either been rebuilt as new lxd containers or migrated as is using lxd-p2c tool to osgeo7)

Thanks,

Regina

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

10

I've prepare contract patterned after my contract 1 but with the new items.

https://nextcloud.osgeo.org/s/i2D7zt6CsLFHWnS

Let me know thoughts any changes.

Thanks,
Regina

-----Original Message-----
From: Sac [mailto:sac-bounces@lists.osgeo.org] On Behalf Of Chris Giorgi
Sent: Thursday, June 13, 2019 1:09 PM
To: System Administration Committee Discussion/OSGeo <sac@lists.osgeo.org>; tech@wildintellect.com; Markus Neteler <neteler@osgeo.org>
Subject: Re: [SAC] Vote request to extend Sysadmin Contract 2019-I amount for another $5000

Hello SAC,
Sorry I've been incommunicado; I'm still dealing with an injury from back in December :frowning:
+1 for Regina to continue the great work under a follow-on contract ASAP.

Take care,
   ~~~Chris~~~

On 6/13/19, Sandro Santilli <strk@kbt.io> wrote:

Can we move this forward ?
We really need more maintainance (I agree with "urgent response" planning).
Let's use some trust and not get stuck with this.

I'm +1 for next contract (2019-II, I'd call it) to Regina.

--strk;

On Thu, Jun 06, 2019 at 12:47:06PM -0700, Alex M wrote:

I'm +1, pending discussion of specific tickets to target - I don't
think all the ones listed are important enough to go on the contract.
But that we have other tasks which might be.

Just a few notes:
* This will us up the rest of our 2019 contract budget, we can ask
the board for more if we feel it's necessary.
* I also think we should discuss if want to reserve a % of these
hours for "urgent response" tasks or if it should all be pre-determined tickets.

Based on the vote we should move forward drawing up the exact
contract for signing.

Thanks,
Alex

On 5/30/19 09:50, Markus Neteler wrote:
> +1 & big thanks,
>
> Markus
>
> On Fri, May 24, 2019 at 12:15 AM Regina Obe <lr@pcorp.us> wrote:
>>
>> The Sysadmin Contract I had a Service completion date of
>> September 30th, 2019 and capped at $5000.
>>
>> I have already reached the cap limit and am requesting an
>> extension of budget, which I will submit formally if all are in agreement.
>>
>>
>>
>> What I d like to accomplish in next round, which I hope to do in a
>> new
>> $5000 budget
>>
>> https://trac.osgeo.org/osgeo/query?status=new&status=reopened&mile
>> stone=Sysadmin+Contract+2019-I
>>
>>
>>
>>
>>
>> 1) Once osgeo4 has got some new drives in it (plan is to replace
>> with 6 new SATA drives and throw out all the drives (only 2 are
>> still
>> good) and reformatted, firmware upgrade set it up as a
>> secondary LXD host to use for non-mission critical stuff (like
>> adhoc, buildbots, etc) and also to mirror osgeo7 containers in stopped state for redundancy.
>>
>> 2) Setup file and database backup for osgeo7 containers which
>> will get pushed to bacula
>>
>> 3) Speed up website with configuring caching of static content
>> like css and images first and then database content if that
>> proves insufficient.
>>
>> 4) Upgrade Nextcloud to latest version
>>
>> 5) Create a new wiki with latest Debian, MariaDb and MediaWiki,
>> PHP right now our wiki everything is EOL d the OS, MySQL, and
>> PHP
>>
>>
>>
>>
>>
>> What was accomplished in the first round is itemized here:
>>
>> https://trac.osgeo.org/osgeo/query?status=closed&milestone=Sysadmi
>> n+Contract+2019-I
>>
>>
>>
>> With key highlights being
>>
>>
>>
>> 1) Create new ldap.osgeo.or g ( now on osgeo7) running debian 9
>>
>> 2) Create new download.osgeo.org (on osgeo7) running debian 9 /
>> nginx
>>
>> 3) Install letsencrypt on all servers that need it replacing the
>> SSL.com star cert that expired May 1st
>>
>> 4) Migrate VMS projects, adhoc, web (still need to do some final
>> checks) as is to LXD containers now on osgeo7
>>
>> 5) Setup 30 day retention lxd image snapshots of key osgeo7 vms
>>
>> 6) Upgrade LXD to snap 3.12 so always at the latest stable LXD
>> offering
>>
>> 7) Decommission osgeo4 so it s ready to be reformatted/firmware
>> upgraded (all old vms have either been rebuilt as new lxd
>> containers or migrated as is using lxd-p2c tool to osgeo7)
>>
>>
>>
>>
>>
>> Thanks,
>>
>> Regina

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

11

Regina,

Apologies, I got to reviewing this last week. Looks fine, let's change
the start date to Aug 1, end date can be end of the year. With those
updates I'll submit it to be signed.

I encourage everyone else to look at the tickets/tasks mentioned and
review if there are any other tickets/tasks we want to include. I went
back and forth in my head about if we should retain a % of time for
unexpected events to be handled under the contract or not, since it's
hard to predict hours needed for those.

Thanks,
Alex

On 6/17/19 13:25, Regina Obe wrote:

I've prepare contract patterned after my contract 1 but with the new items.

https://nextcloud.osgeo.org/s/i2D7zt6CsLFHWnS

Let me know thoughts any changes.

Thanks,
Regina

-----Original Message-----
From: Sac [mailto:sac-bounces@lists.osgeo.org] On Behalf Of Chris Giorgi
Sent: Thursday, June 13, 2019 1:09 PM
To: System Administration Committee Discussion/OSGeo <sac@lists.osgeo.org>; tech@wildintellect.com; Markus Neteler <neteler@osgeo.org>
Subject: Re: [SAC] Vote request to extend Sysadmin Contract 2019-I amount for another $5000

Hello SAC,
Sorry I've been incommunicado; I'm still dealing with an injury from back in December :frowning:
+1 for Regina to continue the great work under a follow-on contract ASAP.

Take care,
   ~~~Chris~~~

On 6/13/19, Sandro Santilli <strk@kbt.io> wrote:

Can we move this forward ?
We really need more maintainance (I agree with "urgent response" planning).
Let's use some trust and not get stuck with this.

I'm +1 for next contract (2019-II, I'd call it) to Regina.

--strk;

On Thu, Jun 06, 2019 at 12:47:06PM -0700, Alex M wrote:

I'm +1, pending discussion of specific tickets to target - I don't
think all the ones listed are important enough to go on the contract.
But that we have other tasks which might be.

Just a few notes:
* This will us up the rest of our 2019 contract budget, we can ask
the board for more if we feel it's necessary.
* I also think we should discuss if want to reserve a % of these
hours for "urgent response" tasks or if it should all be pre-determined tickets.

Based on the vote we should move forward drawing up the exact
contract for signing.

Thanks,
Alex

On 5/30/19 09:50, Markus Neteler wrote:

+1 & big thanks,

Markus

On Fri, May 24, 2019 at 12:15 AM Regina Obe <lr@pcorp.us> wrote:

The Sysadmin Contract I had a Service completion date of
September 30th, 2019 and capped at $5000.

I have already reached the cap limit and am requesting an
extension of budget, which I will submit formally if all are in agreement.

What I d like to accomplish in next round, which I hope to do in a
new
$5000 budget

https://trac.osgeo.org/osgeo/query?status=new&status=reopened&mile
stone=Sysadmin+Contract+2019-I

1) Once osgeo4 has got some new drives in it (plan is to replace
with 6 new SATA drives and throw out all the drives (only 2 are
still
good) and reformatted, firmware upgrade set it up as a
secondary LXD host to use for non-mission critical stuff (like
adhoc, buildbots, etc) and also to mirror osgeo7 containers in stopped state for redundancy.

2) Setup file and database backup for osgeo7 containers which
will get pushed to bacula

3) Speed up website with configuring caching of static content
like css and images first and then database content if that
proves insufficient.

4) Upgrade Nextcloud to latest version

5) Create a new wiki with latest Debian, MariaDb and MediaWiki,
PHP right now our wiki everything is EOL d the OS, MySQL, and
PHP

What was accomplished in the first round is itemized here:

https://trac.osgeo.org/osgeo/query?status=closed&milestone=Sysadmi
n+Contract+2019-I

With key highlights being

1) Create new ldap.osgeo.or g ( now on osgeo7) running debian 9

2) Create new download.osgeo.org (on osgeo7) running debian 9 /
nginx

3) Install letsencrypt on all servers that need it replacing the
SSL.com star cert that expired May 1st

4) Migrate VMS projects, adhoc, web (still need to do some final
checks) as is to LXD containers now on osgeo7

5) Setup 30 day retention lxd image snapshots of key osgeo7 vms

6) Upgrade LXD to snap 3.12 so always at the latest stable LXD
offering

7) Decommission osgeo4 so it s ready to be reformatted/firmware
upgraded (all old vms have either been rebuilt as new lxd
containers or migrated as is using lxd-p2c tool to osgeo7)

Thanks,

Regina

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

12

Mike sent me one yesterday which I already signed.

-----Original Message-----
From: Alex M [mailto:tech_dev@wildintellect.com]
Sent: Wednesday, July 31, 2019 3:27 PM
To: System Administration Committee Discussion/OSGeo <sac@lists.osgeo.org>; Regina Obe <lr@pcorp.us>
Subject: Re: [SAC] Vote request to extend Sysadmin Contract 2019-I amount for another $5000

Regina,

Apologies, I got to reviewing this last week. Looks fine, let's change the start date to Aug 1, end date can be end of the year. With those updates I'll submit it to be signed.

I encourage everyone else to look at the tickets/tasks mentioned and review if there are any other tickets/tasks we want to include. I went back and forth in my head about if we should retain a % of time for unexpected events to be handled under the contract or not, since it's hard to predict hours needed for those.

Thanks,
Alex

On 6/17/19 13:25, Regina Obe wrote:

I've prepare contract patterned after my contract 1 but with the new items.

https://nextcloud.osgeo.org/s/i2D7zt6CsLFHWnS

Let me know thoughts any changes.

Thanks,
Regina

-----Original Message-----
From: Sac [mailto:sac-bounces@lists.osgeo.org] On Behalf Of Chris
Giorgi
Sent: Thursday, June 13, 2019 1:09 PM
To: System Administration Committee Discussion/OSGeo
<sac@lists.osgeo.org>; tech@wildintellect.com; Markus Neteler
<neteler@osgeo.org>
Subject: Re: [SAC] Vote request to extend Sysadmin Contract 2019-I
amount for another $5000

Hello SAC,
Sorry I've been incommunicado; I'm still dealing with an injury from
back in December :frowning:
+1 for Regina to continue the great work under a follow-on contract ASAP.

Take care,
   ~~~Chris~~~

On 6/13/19, Sandro Santilli <strk@kbt.io> wrote:

Can we move this forward ?
We really need more maintainance (I agree with "urgent response" planning).
Let's use some trust and not get stuck with this.

I'm +1 for next contract (2019-II, I'd call it) to Regina.

--strk;

On Thu, Jun 06, 2019 at 12:47:06PM -0700, Alex M wrote:

I'm +1, pending discussion of specific tickets to target - I don't
think all the ones listed are important enough to go on the contract.
But that we have other tasks which might be.

Just a few notes:
* This will us up the rest of our 2019 contract budget, we can ask
the board for more if we feel it's necessary.
* I also think we should discuss if want to reserve a % of these
hours for "urgent response" tasks or if it should all be pre-determined tickets.

Based on the vote we should move forward drawing up the exact
contract for signing.

Thanks,
Alex

On 5/30/19 09:50, Markus Neteler wrote:

+1 & big thanks,

Markus

On Fri, May 24, 2019 at 12:15 AM Regina Obe <lr@pcorp.us> wrote:

The Sysadmin Contract I had a Service completion date of
September 30th, 2019 and capped at $5000.

I have already reached the cap limit and am requesting an
extension of budget, which I will submit formally if all are in agreement.

What I d like to accomplish in next round, which I hope to do in a
new
$5000 budget

https://trac.osgeo.org/osgeo/query?status=new&status=reopened&mile
stone=Sysadmin+Contract+2019-I

1) Once osgeo4 has got some new drives in it (plan is to replace
with 6 new SATA drives and throw out all the drives (only 2 are
still
good) and reformatted, firmware upgrade set it up as a
secondary LXD host to use for non-mission critical stuff (like
adhoc, buildbots, etc) and also to mirror osgeo7 containers in stopped state for redundancy.

2) Setup file and database backup for osgeo7 containers which
will get pushed to bacula

3) Speed up website with configuring caching of static content
like css and images first and then database content if that
proves insufficient.

4) Upgrade Nextcloud to latest version

5) Create a new wiki with latest Debian, MariaDb and MediaWiki,
PHP right now our wiki everything is EOL d the OS, MySQL, and
PHP

What was accomplished in the first round is itemized here:

https://trac.osgeo.org/osgeo/query?status=closed&milestone=Sysadmi
n+Contract+2019-I

With key highlights being

1) Create new ldap.osgeo.or g ( now on osgeo7) running debian 9

2) Create new download.osgeo.org (on osgeo7) running debian 9 /
nginx

3) Install letsencrypt on all servers that need it replacing the
SSL.com star cert that expired May 1st

4) Migrate VMS projects, adhoc, web (still need to do some final
checks) as is to LXD containers now on osgeo7

5) Setup 30 day retention lxd image snapshots of key osgeo7 vms

6) Upgrade LXD to snap 3.12 so always at the latest stable LXD
offering

7) Decommission osgeo4 so it s ready to be reformatted/firmware
upgraded (all old vms have either been rebuilt as new lxd
containers or migrated as is using lxd-p2c tool to osgeo7)

Thanks,

Regina

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac