[SAC] [OSGeo] #2016: Remove crschmidt from LDAP admin group

#2016: Remove crschmidt from LDAP admin group
---------------------------+-------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Keywords:
---------------------------+-------------------
Chris confirmed by mail he is not active on OSGeo:
{{{
Date: Mon, 23 Oct 2017 08:13:32 -0400
From: Christopher Schmidt <crschmidt at crschmidt.net>
To: Sandro Santilli <strk at kbt.io>
Cc: Frank Warmerdam <warmerdam at pobox.com>
Message-ID: <CALxbL9pqzJ4iNc9m4sJOwi2rg+zB5ZDvXAFgWKyvf-
RyKEfniA@mail.gmail.com>
Subject: Re: [SAC] OpenAerialMap service state
In-Reply-To: <20171023074916.brskhxdgpsk4ruar@liz>

...

Yeah, I haven't touched anything OSGeo related in about 4-6 years, so
pulling my name off anything it's leftover on would be a good plan :slight_smile:
}}}

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2016&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2016: Remove crschmidt from LDAP admin group
---------------------------+--------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------

Comment (by wildintellect):

Probably also needs to have key removed from the root user on osgeo3 and
osgeo4 VMs. We should probably open another ticket to manage the public
keys of root users with git (or puppet) in a centralized manner.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2016#comment:1&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2016: Remove crschmidt from LDAP admin group
---------------------------+---------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone:
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+---------------------
Changes (by strk):

* status: new => closed
* resolution: => fixed

Comment:

I've removed him from the admin team for now.
Also I removed his ssh key, renamed his home directory and removed his
unix user from the "sudo" group on the following hosts:

  - trac.osgeo.org
  - www.osgeo.org
  - osgeo6.osgeo.osuosl.org
  - secure.osgeo.osuosl.org
  - adhoc.osgeo.osuosl.org
  - backup.osgeo.osuosl.org
  - wiki.osgeo.org
  - webextra.osgeo.osuosl.org
  - download.osgeo.org

Did I miss any other ?
+1 with managing public keys with some automatic deploy, please file
another ticket for that, I'm closing this one as done, will file another
one to remove shell access too.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2016#comment:2&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2016: Remove crschmidt from LDAP admin group
---------------------------+---------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone:
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+---------------------

Comment (by strk):

Alex you mentioned osgeo3 but I cannot even find the IP address of osgeo3,
it is not mapped as the others:
{{{
osgeo3.osgeo.osuosl.org: Name or service not known
osgeo3.osgeo.org: Name or service not known
osgeo3.osuosl.org: Name or service not known
}}}

The wiki page should be updated with some info about it:
https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo3

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2016#comment:3&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2016: Remove crschmidt from LDAP admin group
---------------------------+---------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone:
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+---------------------

Comment (by wildintellect):

Just the VMs on osgeo3 not the host itself.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2016#comment:4&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2016: Remove crschmidt from LDAP admin group
---------------------------+---------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone:
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+---------------------

Comment (by strk):

VMs on osgeo3 should be all covered, let me know if you see anyone
missing.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2016#comment:5&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2016: Remove crschmidt from LDAP admin group
---------------------------+---------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone:
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+---------------------

Comment (by martin):

Additionally to your list of OSGeo servers mine also includes:

projects.osgeo.osuosl.org

osgeo3 and osgeo4 are only accessible from OSL's management network. After
feeling locked out for quite some time, I recently found out that I still
have access, but most likely Christoper never had.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2016#comment:6&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2016: Remove crschmidt from LDAP admin group
---------------------------+---------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone:
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+---------------------

Comment (by strk):

Thanks, projects.osgeo.osuosl.org now also done.

Note though that according to https://wiki.osgeo.org/wiki/ProjectsVM
the services in the "projects" VM were all migrated to osgeo6
while there's no mention of a "VM" from here:
https://wiki.osgeo.org/wiki/Osgeo6

Could anyone please clarify the situation ?
Is "projects.osgeo.osuosl.org" a VM on "osgeo6.osgeo.osuosl.org" ?
Sorry but I don't know how to find out by myself ( a wiki page
about management of VMs on OSgeo6 would be useful )

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2016#comment:7&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

On 10/24/2017 03:28 AM, OSGeo wrote:

#2016: Remove crschmidt from LDAP admin group
---------------------------+---------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone:
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+---------------------

Comment (by strk):

Thanks, projects.osgeo.osuosl.org now also done.

Note though that according to https://wiki.osgeo.org/wiki/ProjectsVM
the services in the "projects" VM were all migrated to osgeo6
while there's no mention of a "VM" from here:
https://wiki.osgeo.org/wiki/Osgeo6

Could anyone please clarify the situation ?
Is "projects.osgeo.osuosl.org" a VM on "osgeo6.osgeo.osuosl.org" ?

projects is a VM on osgeo4. I thought it was 100% migrated and turned
off. Martin did most of the migrations an would know best.

Sorry but I don't know how to find out by myself ( a wiki page
about management of VMs on OSgeo6 would be useful )

There are no VMs on osgeo6 at this time. See other email thread about
adding containers to osgeo6 for discussion of what we might do.

Thanks,
Alex

Alex M wrote:

projects is a VM on osgeo4. I thought it was 100% migrated and turned
off. Martin did most of the migrations an would know best.

Indeed, I think three sites are still left over. I somehow got stuck,
probably due to formal reasons, but right now I don't remember the details
any more. Chances are good that I'll be able to find out this weekend.

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

On Tue, Oct 24, 2017 at 05:34:47PM +0000, Martin Spott wrote:

Alex M wrote:

> projects is a VM on osgeo4. I thought it was 100% migrated and turned
> off. Martin did most of the migrations an would know best.

Indeed, I think three sites are still left over. I somehow got stuck,
probably due to formal reasons, but right now I don't remember the details
any more. Chances are good that I'll be able to find out this weekend.

Could you please, once found out, update the wiki page starting
from https://wiki.osgeo.org/wiki/SAC_Service_Status ?

The section about "osgeo4" only mentions presence of QGIS and AdHoc VMs:
https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo4

It could be useful to start a dedicated page for "osgeo4" machine,
like it is done for "osgeo6":
https://wiki.osgeo.org/wiki/Osgeo6

Thank you !

--strk;

On 10/24/2017 12:51 PM, Sandro Santilli wrote:

On Tue, Oct 24, 2017 at 05:34:47PM +0000, Martin Spott wrote:

Alex M wrote:

projects is a VM on osgeo4. I thought it was 100% migrated and turned
off. Martin did most of the migrations an would know best.

Indeed, I think three sites are still left over. I somehow got stuck,
probably due to formal reasons, but right now I don't remember the details
any more. Chances are good that I'll be able to find out this weekend.

Could you please, once found out, update the wiki page starting
from https://wiki.osgeo.org/wiki/SAC_Service_Status ?

The section about "osgeo4" only mentions presence of QGIS and AdHoc VMs:
https://wiki.osgeo.org/wiki/SAC_Service_Status#osgeo4

It could be useful to start a dedicated page for "osgeo4" machine,
like it is done for "osgeo6":
https://wiki.osgeo.org/wiki/Osgeo6

Thank you !

--strk;

Feel free to copy information from the following page to seed pages
specific to each machine.
http://wiki.osgeo.org/wiki/Infrastructure_Transition_Plan_2010#osgeo3_.26_osgeo4

-Alex