[SAC] [OSGeo] #1843: Add strk to sudoers on backup VM

Committees SAC mailing list
1

#1843: Add strk to sudoers on backup VM
---------------------------+-------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Keywords:
---------------------------+-------------------
Needed to ensure backups are in place before starting the Trac upgrade
(#1816)

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

2

#1843: Add strk to sudoers on backup VM
---------------------------+--------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------

Comment (by strk):

I'm actually not sure what the policy is on that machine, because I see
the {{{sudo}}} group is empty. My public RSA key, in case that's the way
to get in:
{{{
ssh-rsa
AAAAB3NzaC1yc2EAAAADAQABAAABAQDXfHGzxlzPA9gjIpbHPjCQ2SHvWve+QgficecsCwjACiZvOLrh71XalGGGpbxANkzs7amZjbqpvVd6L3tQJAZK8pT5ljVSV1bx3pX4HxxcL9CpAMB+SfmdRjlTxJ5uvmDNZkHKZl17PglVRYaS+fBbGAJe4JCNhMBzN0szmI3YWHjKlaJtnlAK6NVPiTyrcxQoNkb+XsDq53TBUapfK78JrJssI/iyuqZZ0nkrCgQL92UACRl9a7Wlq0fswsASi8/X/5iKKQu3Qfxo7yKIi7EbxvXn6/rUnyoykM7SwKEXiK06ABZxw8/lN9qcZhhO8YEo+zairIyX4S5DfF+5kGn9
strk@cdb
}}}

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

3

#1843: Add strk to sudoers on backup VM
---------------------------+--------------------
Reporter: strk | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------

Comment (by martin):

Backup of Trac is three stages (defined in /etc/bacula/bacula-dir.conf on
backup):

1.) Create a full database dump on tracsvn using:
     /usr/local/sbin/PGDump.sh
2.) Create a Trac-level dump /osgeo/trac_backup.zip on tracsvn using:
     /osgeo/backup.sh
3.) Backup /osgeo/trac/ and /osgeo/trac_backup.zip to Bacula

I'vre now added "strk" to sudo on backup

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

4

#1843: Add strk to sudoers on backup VM
---------------------------+---------------------
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:

Thanks ! Will ask next questions on the list.

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