[SAC] [Urgent] Proposal for new OSGeo site hosting

[Alex M]

Jeff,

Please itemize your proposal (or proposals if you have 2 different ideas
on how this could work). I suppose we should put it on a wiki page,
along with the GetInteractive proposal I outlined previously, and any
other options so everyone has a good overview of the choices.

Given the urgency of the task, and budget I think we should do a quick
contract for the work. There are plenty of later tasks that could then
be delegated to a wider non-contract team.

In terms of machines, osgeo6 does have enough space/capacity. However it
currently has php5.x, so we would need to either containerize (docker),
or virtualize the Wordpress install, in order to avoid a big headache of
trying to get all the project sites up to a new php version at the same
time.  I was also concerned about how to to do the 2 site setup so there
is a test site and a production site. So really there's a few tricky
unanswered questions for the long term deployment, but things we need to
answer before putting it on our servers.

Thanks,
Alex

On 08/30/2017 02:08 PM, Jeff McKenna wrote:
> It still needs SAC to agree on where it would live exactly, and give me
> permissions there.   (it could be this weekend project, for example -
> diving into this this weekend)  for kickoff next week?  But again, maybe
> this is serious enough to treat as a contract, with a task list and
> effort/cost outlined on a wiki page, was my thinking (then we don't
> abuse our volunteers).
> 
> I was also thinking of creating a team for this, and listing on the
> proposal wiki.  For example, the site maintenance team could be a team
> such as the 2 jeffs, Nicolas Bozon (master interface dev), and Vicky
> Vergara (I love her passion and commitment to OSGeo).   note - I haven't
> even asked them yet!  But I will.  And will include on the wiki.
> 
> -jeff
> 
> 
> 
> On 2017-08-30 5:50 PM, Jeffrey Johnson wrote:
>> +1 from me (not a member of SAC though).
>>
>> Jeff how quickly do you think you could get stuff stood up? We are
>> supposed to be closing out the contract with GET as quickly as we can.
>>
>> Also, Ill be happy to help you with this longer term.
>>
>> On Wed, Aug 30, 2017 at 1:46 PM, Jeff McKenna
>> <jmckenna at gatewaygeomatics.com> wrote:
>>> Hi Alex,
>>>
>>> I wonder if I am too late, but I'd like to officially respond to your
>>> earlier thread calling for "volunteers" to maintain the new Wordpress
>>> install.
>>>
>>> To be honest, as you had said in the OSGeo AGM, in this case for this
>>> ongoing task, I would not use the word volunteer either; as you know,
>>> or for
>>> background, I've been quietly maintaining the old osgeo.org site for
>>> a very
>>> long time.  This has had me dealing with backend MySQL issues, PHP
>>> issues,
>>> server config, you name it over the years.
>>>
>>> I would like to officially answer your request for help, or a lead,
>>> for the
>>> new WordPress install & maintenance.
>>>
>>> This means I am offering to install WordPress on the OSGeo
>>> infrastructure,
>>> install the custom template provided by GetInteractive, lead/care for
>>> maintaining backups, security, PHP issues (there will be lots), and
>>> answer/watch for any server issues daily (I bet I am the only person in
>>> OSGeo that has bots to check OSGeo services running every 2 hours now).
>>>
>>> I have experience, and most importantly, I have the proven passion to
>>> care
>>> and be there to help when others cannot.  Where I sometimes can lack the
>>> deep server skills, I dig, I try, I ask, I learn, and I eventually fix.
>>>
>>> My plan is to provide a proposal to SAC on this, on the wiki, in the
>>> form of
>>> a quote/contract for this effort.
>>>
>>> So, is the request for help, still valid?
>>>
>>> If so, I will begin work on the wiki draft, and provide it to SAC
>>> here, so
>>> you can make a decision.
>>>
>>> Thanks,
>>>
>>> -jeff
>>>
>>>
>>>
>>>
>>> On 2017-08-30 2:38 PM, Alex M wrote:
>>>>
>>>> SAC Members,
>>>>
>>>> GetInteractive has proposed a solution for our immediate hosting needs
>>>> to take ownership of the site they've built for us.
>>>>
>>>> It includes setting up a host, giving us full admin, and the providing
>>>> monthly updates.
>>>>
>>>>> For the new website I expect that the following configuration will be
>>>>> more
>>>>> then enough:
>>>>> - CPU 4
>>>>> - RAM GB 8
>>>>> - HDD GB 160
>>>>> Price € 34,95 ex. VAT. (Pricing information can be found on
>>>>> https://www.cloudvps.com/openstack/compute)
>>>>>
>>>>> If we need more resources we can easily upgrade the VPS.
>>>>> We can order the VPS on our name and charge you the price that is
>>>>> charged
>>>>> by the hosting provider.
>>>>>
>>>>> For the installation and configuration of the server and required
>>>>> software
>>>>> we'll charge 4 hours.
>>>>> This gives us a total of € 320,- ex. VAT.
>>>>>
>>>>> For performing updates and upgrades on server software, WordPress
>>>>> website
>>>>> and WordPress plugins we'll charge 1 hour a month.
>>>>> This gives us at total of € 80,- ex. VAT a month.
>>>>
>>>>
>>>> Summary
>>>> * ~$500 (USD)/yr for the hosting
>>>> * $381.68 (USD) one time for the setup
>>>> * ~ $100 USD/month for the monthly maintenance
>>>>
>>>> Note the board allocated $3000 USD for this project, separate from the
>>>> SAC budget.
>>>>
>>>> ==========
>>>> We need input from members in the next 24 hours on this.
>>>>
>>>> I have already supplied a list of clarification questions and expect
>>>> answers today.
>>>> 1. What's the exact stack: I suggested our preferred stack was Debian,
>>>> Apache, Mysql/Maria, Php7
>>>> 2. I asked for clarification that the service contract would be for
>>>> doing critical security patches in a timely manner.
>>>>
>>>> I will send a separate email with my opinions on the matter.
>>>>
>>>> Thanks,
>>>> Alex
>>>> Sys Admin Chair
>>>>
> _______________________________________________
> Sac mailing list
> Sac at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/sac