[SAC] [OSGeo] #2653: container OS updates for osgeo7, osgeo3, osgeo4

#2653: container OS updates for osgeo7, osgeo3, osgeo4
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2021-II
Component: Systems Admin | Keywords:
---------------------------+---------------------------------------
Various containers need security updates.
I also noticed for some reason download is requesting patches for mariadb-
common and libmariadb. I don't recall ever installing these and mariadb
is not running on download. I plan to remove these but will put those in
a separate ticket for more visibility.

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

#2653: container OS updates for osgeo7, osgeo3, osgeo4
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2021-II
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+----------------------------------------
Changes (by robe):

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

Comment:

#patch upgrades complete - the following servers upgraded.

Servers upgreaded OSGeo7
Dronie Server
{{{
      The following packages were automatically installed and are no longer
required:
         linux-headers-4.19.0-17-amd64 linux-headers-4.19.0-17-common
       Use 'sudo apt autoremove' to remove them.
       The following NEW packages will be installed:
         linux-headers-4.19.0-18-amd64 linux-headers-4.19.0-18-common
       The following packages have been kept back:
         docker-ce
  27 upgraded, 2 newly installed, 0 to remove and 1 not upgraded.
}}}

Download
{{{
       The following packages will be upgraded:
         apache2-utils base-files debconf distro-info-data krb5-locales
         libgssapi-krb5-2 libk5crypto3 libkrb5-3 libkrb5support0
libmariadb3
         linux-libc-dev mariadb-common psmisc python3-debconf tzdata
       15 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
}}}

Nextcloud

{{{
   The following packages will be upgraded:
         libnetplan0 netplan.io nplan
       3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
}}}

Secure

{{{
     The following packages will be upgraded:
         krb5-locales
       1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
       Inst krb5-locales [1.15-1+deb9u2] (1.15-1+deb9u3 Debian-
Security:9/oldoldstable [all])
       Conf krb5-locales (1.15-1+deb9u3 Debian-Security:9/oldoldstable
[all])
}}}

Wordpress

{{{
       The following NEW packages will be installed:
         linux-image-4.19.0-18-amd64{a}
       The following packages will be upgraded:
         apache2 apache2-bin apache2-data apache2-utils base-files debconf
debconf-i18n distro-info-data krb5-locales libapache2-mod-php7.3
libgssapi-krb5-2 libk5crypto3 libkrb5-3 libkrb5support0 libmariadb3
libnss-systemd libpam-systemd libssl-dev libssl-doc libssl1.1 libsystemd0
libudev1 libuv1 linux-image-4.19.0-17-amd64 linux-image-amd64 linux-libc-
dev mariadb-client-10.3 mariadb-client-core-10.3 mariadb-common mariadb-
server mariadb-server-10.3 mariadb-server-core-10.3 openssl php7.3
php7.3-bcmath php7.3-cli php7.3-common php7.3-curl php7.3-dev php7.3-gd
php7.3-intl php7.3-json php7.3-ldap php7.3-mysql php7.3-opcache
php7.3-readline php7.3-xmlrpc psmisc python3-debconf systemd systemd-sysv
tzdata udev
       53 packages upgraded, 1 newly installed, 0 to remove and 0 not
upgraded.
       Need to get 136 MB of archives. After unpacking 270 MB will be used.
       Would download/install/remove packages.
}}}

osgeo3

hop
{{{
      The following packages were automatically installed and are no longer
required:
         dh-python exim4 gnupg-agent guile-2.0-libs libbind9-140
libcryptsetup4
         libdns-export162 libdns162 libgdbm3 libicu57 libisc-export160
libisc160
         libisccc140 libisccfg140 liblwres141 libncurses5 libperl5.24
libprocps6
         libpython3.5-minimal libpython3.5-stdlib libssl1.0.2 libunistring0
         python3-distutils python3-lib2to3 python3.5 python3.5-minimal
rename
         sgml-base tcpd xml-core
       Use 'sudo apt autoremove' to remove them.
       The following packages will be upgraded:
         base-files debconf distro-info-data krb5-locales libgssapi-krb5-2
         libk5crypto3 libkrb5-3 libkrb5support0 libmariadb3 libssl1.1
mariadb-common
         openssl psmisc tzdata
       14 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
}}}

limesurvey - manually ran auto remove to remove the php 7.4 and changed
/etc/nginx/limesurvey.conf to use php 8.0
{{{

      Calculating upgrade...
       The following packages were automatically installed and are no
longer required:
         php7.4-bcmath php7.4-cli php7.4-curl php7.4-fpm php7.4-gd
php7.4-gmp
         php7.4-imap php7.4-intl php7.4-json php7.4-ldap php7.4-mbstring
         php7.4-opcache php7.4-pgsql php7.4-readline php7.4-xml php7.4-zip
       Use 'sudo apt autoremove' to remove them.
       The following packages will be upgraded:
         base-files debconf distro-info-data krb5-locales libgssapi-krb5-2
         libk5crypto3 libkrb5-3 libkrb5support0 libpq5 php-imagick
php7.4-bcmath
         php7.4-cli php7.4-common php7.4-curl php7.4-fpm php7.4-gd
php7.4-gmp
         php7.4-imap php7.4-intl php7.4-json php7.4-ldap php7.4-mbstring
         php7.4-opcache php7.4-pgsql php7.4-readline php7.4-xml php7.4-zip
         php8.0-bcmath php8.0-cli php8.0-common php8.0-curl php8.0-fpm
php8.0-gd
         php8.0-gmp php8.0-imagick php8.0-imap php8.0-intl php8.0-ldap
         php8.0-mbstring php8.0-opcache php8.0-pgsql php8.0-readline
php8.0-xml
         php8.0-zip postgresql-13 postgresql-client-13 postgresql-client-
common
         postgresql-common psmisc tzdata
}}}

matrix
{{{
  'The following packages were automatically installed and are no longer
required:'
     - ' libc-ares2 libnode64 libuv1 python3-distutils python3-lib2to3'
     - Use 'sudo apt autoremove' to remove them.
     - 'The following packages will be upgraded:'
     - ' base-files debconf distro-info-data krb5-locales libc-ares2
libgssapi-krb5-2'
     - ' libk5crypto3 libkrb5-3 libkrb5support0 libnss-systemd libpam-
systemd libpq5'
     - ' libssl1.1 libsystemd0 libudev1 libuv1 linux-libc-dev matrix-
synapse-py3'
     - ' openssl postgresql-11 postgresql-client-11 psmisc systemd
systemd-sysv'
     - ' tzdata'
     - 25 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
}}}

monitor
{{{
      The following packages will be upgraded:
         base-files debconf distro-info-data grafana krb5-locales
libgssapi-krb5-2
         libk5crypto3 libkrb5-3 libkrb5support0 psmisc tzdata
       11 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
}}}

osgeo3_nginx
{{{
     The following packages will be upgraded:
         base-files debconf krb5-locales libgssapi-krb5-2 libk5crypto3
libkrb5-3
         libkrb5support0 libmariadb3 libssl1.1 mariadb-common openssl
psmisc tzdata
       13 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

}}}

wiki

{{{
    The following packages will be upgraded:
         apache2 apache2-bin apache2-data apache2-utils base-files debconf
         krb5-locales libgssapi-krb5-2 libk5crypto3 libkrb5-3
libkrb5support0
         libmariadb3 libssl1.1 mariadb-client-10.3 mariadb-client-core-10.3
         mariadb-common mariadb-server mariadb-server-10.3 mariadb-server-
core-10.3
         openssl psmisc tzdata
       22 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

}}}

=== osgeo4

hop
{{{
      Calculating upgrade...
       The following packages were automatically installed and are no
longer required:
         dh-python exim4 gnupg-agent guile-2.0-libs libbind9-140
libcryptsetup4
         libdns-export162 libdns162 libgdbm3 libicu57 libisc-export160
libisc160
         libisccc140 libisccfg140 liblwres141 libncurses5 libperl5.24
libprocps6
         libpython3.5-minimal libpython3.5-stdlib libssl1.0.2 libunistring0
         python3-distutils python3-lib2to3 python3.5 python3.5-minimal
rename
         sgml-base tcpd xml-core
       Use 'sudo apt autoremove' to remove them.
       The following packages will be upgraded:
         base-files debconf distro-info-data krb5-locales libgssapi-krb5-2
         libk5crypto3 libkrb5-3 libkrb5support0 libmariadb3 libssl1.1
mariadb-common
         openssl psmisc tzdata
       14 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
}}

osgeo9

hop

{{{
    The following packages will be upgraded:
         base-files debconf distro-info-data krb5-locales libgssapi-krb5-2
         libk5crypto3 libkrb5-3 libkrb5support0 libssl1.1 openssl psmisc
tzdata
       12 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
}}}

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