[SAC] Re: [Urgent][Vote] Proposal for new OSGeo site hosting

Responses inline from GetInteractive.
Is Ubuntu, Apache, php, MySQL sound ok with everyone? Jeff Mckenna, can
we put you as the main contact they should work with on setting this up?

Thanks,
Alex

-------- Forwarded Message --------
Subject: Re: [SAC] [Urgent][Vote] Proposal for new OSGeo site hosting
Date: Thu, 14 Sep 2017 14:01:50 -0700
From: Jeffrey Johnson <ortelius@gmail.com>
To: Jeffrey Lasut <j.lasut@getinteractive.nl>
CC: Pim Tebbens <p.tebbens@getinteractive.nl>, Patrick Kepel
<p.kepel@getinteractive.nl>, Jody Garnett <jody.garnett@gmail.com>, Alex
Mandel <tech@wildintellect.com>

+Alex

On Thu, Sep 14, 2017 at 1:53 PM, Jeffrey Lasut
<j.lasut@getinteractive.nl> wrote:

Hi Jeff,

My reply underneath in Alex his email.

Verstuurd vanaf mijn iPhone

Op 7 sep. 2017 om 20:31 heeft Jeffrey Johnson <ortelius@gmail.com> het volgende geschreven:

Guys from GET there are some questions in here for you. Does this all sound ok?

---------- Forwarded message ----------
From: Alex M <tech_dev@wildintellect.com>
Date: Thu, Sep 7, 2017 at 9:50 AM
Subject: Re: [SAC] [Urgent][Vote] Proposal for new OSGeo site hosting
To: Alex Mandel <tech@wildintellect.com>, System Administration
Committee Discussion/OSGeo <sac@lists.osgeo.org>

After discussion on IRC, here is the proposal for SAC to vote on:

Summary: We will use GetInteractive to setup a VM on 3rd party hosting
to keep the beta site going while Jeff Mckenna leads the effort to bring
up the official site on OSGeo machines.

1. Angelos will ask GetInteractive for the Database dump and supporting
files. (Note, I have a copy of the theme, but getting it again is fine)

No request yet, but supply what ever you need.

2. Jody/Jeff J. - We would like to accept GetInteractive's offer to
setup a VM for us with some modifications.
a. The site will be beta.osgeo.org

Ok

b. We would like the initial setup and month to month plan on the VM.

Ok

c. The VM can be scaled back to a cheaper option (4 GB RAM choice). We
can always make it bigger later if it becomes the production site.

Ok

d. We do not at this time need the 1 hr/month maintenance.

That's ok, there is no margin for us in a hosting only contract, so OSGeo should order and pay for the hosting themselves.

e. Clarification that we'll be given root access to the VM, or perhaps
we should setup the account and then grant them access?

For the initial setup we like to have root access, after that the permissions can be downgraded.

f. Clarification on the stack that will be installed.
Debian/Apache/Maria/Php7 (Though I'm curious if they recommend NGINX/phpFPM)

I think for the OSGeo website we probably would recommend a Ubuntu, Apache, php, MySQL all latest versions. Why Ubuntu over Debian, in our experience is that new package versions are usually released faster in Ubuntu than Debian.
Why apache over Nginx, this is more a consideration on website load and the balance of static and dynamic content. In our experience Apache handles dynamic content a bit faster. If we truly want to know witch one is best for OSGeo website is to try it en do some testing.
Phpfpm have no experience with this, looks like it is shipping with php5.3.*. We would like to use the latest php version, and php7 has allot of performance improvements.
Also no experience with Maria, couldn't judge if Maria is better or not for the OSGeo website, love to hear your experiences Alex.

3. Long term maintenance will be done by Jeff McKenna et al. A
formalized plan and team list will be presented next week.
a. If we can decide on how to host on OSGeo machines (Containers, VM,
new machine) then the official site will be internalized.
b. either the 3rd party VM, or another internal solution will be made
to host the beta site.

4. The new site should not be made the official site until the LDAP
integration is resolved.
a. This requires setting up LDAP in Wordpress connected to our server
b. Migrating or mapping existing users. (Note: on Wordpress import you
can reassign posts from one user to another in a batch manner).

Thanks,
Alex
Sys Admin Chair

On 09/05/2017 11:02 PM, Jody Garnett wrote:
Reminder meeting scheduled for 14:00 UTC tomorrow if you needed any
questions/clarifications with Get Interactive.

--
Jody Garnett

On 2 September 2017 at 10:52, Alex Mandel <tech_dev@wildintellect.com>
wrote:

Yes, that will be a sufficient amount of time to make decisions.

Thanks,
Alex

On 09/01/2017 03:18 PM, Jody Garnett wrote:
Alex I did not get an indication on timeframe from Get Interactive (on

when

the website will be complete; perhaps Jeff Johnson has a better

indication).

I have put this topic on the agenda for next week's OSGeo board meeting,
https://wiki.osgeo.org/wiki/Board_Meeting_2017-09-07

Will that be sufficient time for SAC to make a decision?

--
Jody Garnett

On 30 August 2017 at 10:38, Alex M <tech_dev@wildintellect.com> 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@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/sac

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

+1

-----Original Message-----
From: Sac [mailto:sac-bounces@lists.osgeo.org] On Behalf Of Alex M
Sent: Wednesday, September 27, 2017 4:45 PM
To: sac >> System Administration Committee Discussion/OSGeo <sac@lists.osgeo.org>
Subject: [SAC] Fwd: Re: [Urgent][Vote] Proposal for new OSGeo site hosting

Responses inline from GetInteractive.
Is Ubuntu, Apache, php, MySQL sound ok with everyone? Jeff Mckenna, can we put you as the main contact they should work with on setting this up?

Thanks,
Alex

-------- Forwarded Message --------
Subject: Re: [SAC] [Urgent][Vote] Proposal for new OSGeo site hosting
Date: Thu, 14 Sep 2017 14:01:50 -0700
From: Jeffrey Johnson <ortelius@gmail.com>
To: Jeffrey Lasut <j.lasut@getinteractive.nl>
CC: Pim Tebbens <p.tebbens@getinteractive.nl>, Patrick Kepel <p.kepel@getinteractive.nl>, Jody Garnett <jody.garnett@gmail.com>, Alex Mandel <tech@wildintellect.com>

+Alex

On Thu, Sep 14, 2017 at 1:53 PM, Jeffrey Lasut <j.lasut@getinteractive.nl> wrote:

Hi Jeff,

My reply underneath in Alex his email.

Verstuurd vanaf mijn iPhone

Op 7 sep. 2017 om 20:31 heeft Jeffrey Johnson <ortelius@gmail.com> het volgende geschreven:

Guys from GET there are some questions in here for you. Does this all sound ok?

---------- Forwarded message ----------
From: Alex M <tech_dev@wildintellect.com>
Date: Thu, Sep 7, 2017 at 9:50 AM
Subject: Re: [SAC] [Urgent][Vote] Proposal for new OSGeo site hosting
To: Alex Mandel <tech@wildintellect.com>, System Administration
Committee Discussion/OSGeo <sac@lists.osgeo.org>

After discussion on IRC, here is the proposal for SAC to vote on:

Summary: We will use GetInteractive to setup a VM on 3rd party
hosting to keep the beta site going while Jeff Mckenna leads the
effort to bring up the official site on OSGeo machines.

1. Angelos will ask GetInteractive for the Database dump and
supporting files. (Note, I have a copy of the theme, but getting it
again is fine)

No request yet, but supply what ever you need.

2. Jody/Jeff J. - We would like to accept GetInteractive's offer to
setup a VM for us with some modifications.
a. The site will be beta.osgeo.org

Ok

b. We would like the initial setup and month to month plan on the VM.

Ok

c. The VM can be scaled back to a cheaper option (4 GB RAM choice).
We can always make it bigger later if it becomes the production site.

Ok

d. We do not at this time need the 1 hr/month maintenance.

That's ok, there is no margin for us in a hosting only contract, so OSGeo should order and pay for the hosting themselves.

e. Clarification that we'll be given root access to the VM, or
perhaps we should setup the account and then grant them access?

For the initial setup we like to have root access, after that the permissions can be downgraded.

f. Clarification on the stack that will be installed.
Debian/Apache/Maria/Php7 (Though I'm curious if they recommend
NGINX/phpFPM)

I think for the OSGeo website we probably would recommend a Ubuntu, Apache, php, MySQL all latest versions. Why Ubuntu over Debian, in our experience is that new package versions are usually released faster in Ubuntu than Debian.
Why apache over Nginx, this is more a consideration on website load and the balance of static and dynamic content. In our experience Apache handles dynamic content a bit faster. If we truly want to know witch one is best for OSGeo website is to try it en do some testing.
Phpfpm have no experience with this, looks like it is shipping with php5.3.*. We would like to use the latest php version, and php7 has allot of performance improvements.
Also no experience with Maria, couldn't judge if Maria is better or not for the OSGeo website, love to hear your experiences Alex.

3. Long term maintenance will be done by Jeff McKenna et al. A
formalized plan and team list will be presented next week.
a. If we can decide on how to host on OSGeo machines (Containers, VM,
new machine) then the official site will be internalized.
b. either the 3rd party VM, or another internal solution will be made
to host the beta site.

4. The new site should not be made the official site until the LDAP
integration is resolved.
a. This requires setting up LDAP in Wordpress connected to our
server b. Migrating or mapping existing users. (Note: on Wordpress
import you can reassign posts from one user to another in a batch manner).

Thanks,
Alex
Sys Admin Chair

On 09/05/2017 11:02 PM, Jody Garnett wrote:
Reminder meeting scheduled for 14:00 UTC tomorrow if you needed any
questions/clarifications with Get Interactive.

--
Jody Garnett

On 2 September 2017 at 10:52, Alex Mandel
<tech_dev@wildintellect.com>
wrote:

Yes, that will be a sufficient amount of time to make decisions.

Thanks,
Alex

On 09/01/2017 03:18 PM, Jody Garnett wrote:
Alex I did not get an indication on timeframe from Get Interactive
(on

when

the website will be complete; perhaps Jeff Johnson has a better

indication).

I have put this topic on the agenda for next week's OSGeo board
meeting,
https://wiki.osgeo.org/wiki/Board_Meeting_2017-09-07

Will that be sufficient time for SAC to make a decision?

--
Jody Garnett

On 30 August 2017 at 10:38, Alex M <tech_dev@wildintellect.com> 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@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

On Wed, Sep 27, 2017 at 01:44:46PM -0700, Alex M wrote:

Responses inline from GetInteractive.
Is Ubuntu, Apache, php, MySQL sound ok with everyone? Jeff Mckenna, can
we put you as the main contact they should work with on setting this up?

I would prefer PostgreSQL if it was possible
(but last I checked Wordpress did not support it)

Other than that, I'm +1

--strk;

Sandro Santilli wrote:

I would prefer PostgreSQL if it was possible

+1

  Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------