[SAC] [OSGeo] #2728: Upgrade osgeo6 to buster

Committees SAC mailing list
1

#2728: Upgrade osgeo6 to buster
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Keywords:
---------------------------+---------------------------------------
Right now osgeo6 is at debian stretch level. Which is two stable versions
behind. I had meant to do this last year.

My main concern is with the mailing system. When I had upgraded trac to
buster the mail stopped working (I mean the mail server was working as far
as I could tell, but trac couldn't use it) and I hadn't investigated why,
Instead I just put in a stop gap to channel email thru osgeo6.

Given that osgeo6 is our primary mail server, special attention must be
given to make sure it doesn't happen and that lists still works after, and
other services that channel mail thru it (osgeo.org, repo.osgeo.org,
limesurvey.osgeo.org, talks.osgeo.org, trac.osgeo.org).

After this is done, we should upgrade to bullseye after, but want to wait
a month or so after this upgrade before attempting a bullseye upgrade.

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

2

#2728: Upgrade osgeo6 to buster
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------

Comment (by robe):

Also a side note. for some reason osgeo6 has 2 versions of PostgreSQL
running on it with PostgreSQL 12 being the only live one (11 is stopped on
port 5433). At a glance only the drone database is on the running
instance. drone has been moved to dronie-server dronie.osgeo.org, so this
old drone is not needed anymore.

I plan to uninstall PostgreSQL completely on osgeo6 before pushing forward
with the upgrade.

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

3

#2728: Upgrade osgeo6 to buster
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------

Comment (by robe):

Other thing I plan to remove:

docker -- there are no docker containers running on this server and not
sure if there were ever any.

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

4

#2728: Upgrade osgeo6 to buster
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Description changed by robe:

Old description:

Right now osgeo6 is at debian stretch level. Which is two stable
versions behind. I had meant to do this last year.

My main concern is with the mailing system. When I had upgraded trac to
buster the mail stopped working (I mean the mail server was working as
far as I could tell, but trac couldn't use it) and I hadn't investigated
why, Instead I just put in a stop gap to channel email thru osgeo6.

Given that osgeo6 is our primary mail server, special attention must be
given to make sure it doesn't happen and that lists still works after,
and other services that channel mail thru it (osgeo.org, repo.osgeo.org,
limesurvey.osgeo.org, talks.osgeo.org, trac.osgeo.org).

After this is done, we should upgrade to bullseye after, but want to wait
a month or so after this upgrade before attempting a bullseye upgrade.

New description:

Right now osgeo6 is at debian stretch level. Which is two stable versions
behind. I had meant to do this last year.

My main concern is with the mailing system. When I had upgraded trac to
buster the mail stopped working (I mean the mail server was working as far
as I could tell, but trac couldn't use it) and I hadn't investigated why,
Instead I just put in a stop gap to channel email thru osgeo6.

Given that osgeo6 is our primary mail server, special attention must be
given to make sure it doesn't happen and that lists still works after, and
other services that channel mail thru it (osgeo.org, repo.osgeo.org,
limesurvey.osgeo.org, talks.osgeo.org, trac.osgeo.org, weblate.osgeo.org,
wiki.osgeo.org ? (wiki might be using itself) ).

After this is done, we should upgrade to bullseye after, but want to wait
a month or so after this upgrade before attempting a bullseye upgrade.

--

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

5

#2728: Upgrade osgeo6 to buster
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------

Comment (by robe):

Okay I figured out why tracsvn mail stopped working when I upgraded it to
buster.
The same thing did not happen on my trial upgrade of osgeo6.

The issue was the /etc/postfix/mail.cf on tracsvn was missing this line:

{{{
  smtpd_relay_restrictions = permit_mynetworks permit_sasl_authenticated
reject_unauth_destination
}}}

perhaps older postfix had defaulted to something and newer didn't

Once I added that and did a

{{{
systemctl restart postfix
}}}

I was able to change /var/www/trac/env/osgeo/conf/trac.ini

back to smpt_server = localhost

from mail.osgeo.org

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

6

#2728: Upgrade osgeo6 to buster
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------

Comment (by robe):

I have started the upgrade process.

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

7

#2728: Upgrade osgeo6 to buster
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------

Comment (by robe):

Upgrade to buster is complete.

I ran into some stumbling blocks like apache2 wouldn't start.

I had to disable old.grasswiki.osgeo.org #as I recall I think I had the
same issue when resetting it up on bullseye on osgeo3. I assume this isn't
need anymore so will leave shut off.

I also needed to install certbot, cause the certbot-auto that was in use
is not supported on debian10.
None of the certs are up for renewal, so their may be an issue. I will
revisit in july when they come due.

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

8

#2728: Upgrade osgeo6 to buster
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+----------------------------------------
Changes (by robe):

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

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

9

#2728: Upgrade osgeo6 to buster
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+----------------------------------------

Comment (by robe):

Forgot to add, I documented things here -
https://git.osgeo.org/gitea/sac/osgeo6-etc-apache2/wiki/Dist-upgrade

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