here

pi@raspberrypi:~ $ sudo apt-get install ufw nginx mariadb-server -y
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  fontconfig-config fonts-dejavu-core galera-3 gawk libaio1 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libdbd-mysql-perl
  libdbi-perl libencode-locale-perl libfcgi-perl libfontconfig1 libgd3 libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl
  libhttp-date-perl libhttp-message-perl libio-html-perl libjbig0 liblwp-mediatypes-perl libmariadb3 libnginx-mod-http-auth-pam
  libnginx-mod-http-dav-ext libnginx-mod-http-echo libnginx-mod-http-geoip libnginx-mod-http-image-filter libnginx-mod-http-subs-filter
  libnginx-mod-http-upstream-fair libnginx-mod-http-xslt-filter libnginx-mod-mail libnginx-mod-stream libreadline5 libsigsegv2 libsnappy1v5
  libterm-readkey-perl libtiff5 libtimedate-perl liburi-perl libwebp6 libxpm4 libxslt1.1 lsof mariadb-client-10.3 mariadb-client-core-10.3
  mariadb-common mariadb-server-10.3 mariadb-server-core-10.3 mysql-common nginx-common nginx-full socat
Suggested packages:
  gawk-doc libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl libgd-tools libdata-dump-perl libipc-sharedcache-perl
  libwww-perl mailx mariadb-test tinyca fcgiwrap nginx-doc ssl-cert
The following NEW packages will be installed:
  fontconfig-config fonts-dejavu-core galera-3 gawk libaio1 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libdbd-mysql-perl
  libdbi-perl libencode-locale-perl libfcgi-perl libfontconfig1 libgd3 libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl
  libhttp-date-perl libhttp-message-perl libio-html-perl libjbig0 liblwp-mediatypes-perl libmariadb3 libnginx-mod-http-auth-pam
  libnginx-mod-http-dav-ext libnginx-mod-http-echo libnginx-mod-http-geoip libnginx-mod-http-image-filter libnginx-mod-http-subs-filter
  libnginx-mod-http-upstream-fair libnginx-mod-http-xslt-filter libnginx-mod-mail libnginx-mod-stream libreadline5 libsigsegv2 libsnappy1v5
  libterm-readkey-perl libtiff5 libtimedate-perl liburi-perl libwebp6 libxpm4 libxslt1.1 lsof mariadb-client-10.3 mariadb-client-core-10.3
  mariadb-common mariadb-server mariadb-server-10.3 mariadb-server-core-10.3 mysql-common nginx nginx-common nginx-full socat ufw
0 upgraded, 56 newly installed, 0 to remove and 0 not upgraded.
Need to get 23.0 MB of archives.
After this operation, 161 MB of additional disk space will be used.
Get:2 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf gawk armhf 1:4.2.1+dfsg-1 [590 kB]
Get:1 http://mirror.datamossa.io/raspbian buster/main armhf libsigsegv2 armhf 2.12-2 [32.3 kB]
Get:3 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf mysql-common all 5.8+1.0.5 [7,324 B]
Get:4 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf mariadb-common all 1:10.3.29-0+deb10u1 [32.5 kB]
Get:5 http://mirror.datamossa.io/raspbian buster/main armhf galera-3 armhf 25.3.25-2 [811 kB]
Get:6 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libdbi-perl armhf 1.642-1+deb10u2 [767 kB]
Get:7 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf lsof armhf 4.91+dfsg-1 [307 kB]
Get:8 http://mirror.datamossa.io/raspbian buster/main armhf libconfig-inifiles-perl all 3.000001-1 [51.9 kB]
Get:9 http://mirror.datamossa.io/raspbian buster/main armhf libaio1 armhf 0.3.112-3 [10.8 kB]
Get:10 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libreadline5 armhf 5.2+dfsg-3 [103 kB]
Get:11 http://mirror.datamossa.io/raspbian buster/main armhf libsnappy1v5 armhf 1.1.7-1 [15.4 kB]
Get:12 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf mariadb-client-core-10.3 armhf 1:10.3.29-0+deb10u1 [4,725 kB]
Get:13 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf mariadb-client-10.3 armhf 1:10.3.29-0+deb10u1 [989 kB]
Get:14 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf mariadb-server-core-10.3 armhf 1:10.3.29-0+deb10u1 [5,224 kB]
Get:15 http://mirror.datamossa.io/raspbian buster/main armhf socat armhf 1.7.3.2-2 [324 kB]
Get:16 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf mariadb-server-10.3 armhf 1:10.3.29-0+deb10u1 [3,559 kB]
Get:17 http://mirror.datamossa.io/raspbian buster/main armhf fonts-dejavu-core all 2.37-1 [1,068 kB]
Get:18 http://mirror.datamossa.io/raspbian buster/main armhf fontconfig-config all 2.13.1-2 [280 kB]
Get:19 http://mirror.datamossa.io/raspbian buster/main armhf libhtml-tagset-perl all 3.20-3 [12.7 kB]
Get:20 http://mirror.datamossa.io/raspbian buster/main armhf liburi-perl all 1.76-1 [89.9 kB]
Get:21 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libhtml-parser-perl armhf 3.72-3+b2 [101 kB]
Get:22 http://mirror.datamossa.io/raspbian buster/main armhf libcgi-pm-perl all 4.40-1 [222 kB]
Get:23 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libfcgi-perl armhf 0.78-2+b2 [35.0 kB]
Get:24 http://mirror.datamossa.io/raspbian buster/main armhf libcgi-fast-perl all 1:2.13-1 [11.4 kB]
Get:25 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libmariadb3 armhf 1:10.3.29-0+deb10u1 [159 kB]
Get:26 http://mirror.datamossa.io/raspbian buster/main armhf libdbd-mysql-perl armhf 4.050-2 [114 kB]
Get:27 http://mirror.datamossa.io/raspbian buster/main armhf libencode-locale-perl all 1.05-1 [13.7 kB]
Get:28 http://mirror.datamossa.io/raspbian buster/main armhf libfontconfig1 armhf 2.13.1-2 [327 kB]
Get:29 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libjbig0 armhf 2.1-3.1+b2 [27.6 kB]
Get:30 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libwebp6 armhf 0.6.1-2+deb10u1 [227 kB]
Get:31 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libtiff5 armhf 4.1.0+git191117-2~deb10u2 [250 kB]
Get:32 http://mirror.datamossa.io/raspbian buster/main armhf libxpm4 armhf 1:3.5.12-1 [43.6 kB]
Get:33 http://mirror.datamossa.io/raspbian buster/main armhf libgd3 armhf 2.2.5-5.2 [115 kB]
Get:34 http://mirror.datamossa.io/raspbian buster/main armhf libhtml-template-perl all 2.97-1 [66.0 kB]
Get:35 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libtimedate-perl all 2.3000-2+deb10u1 [38.1 kB]
Get:36 http://mirror.datamossa.io/raspbian buster/main armhf libhttp-date-perl all 6.02-1 [10.7 kB]
Get:37 http://mirror.datamossa.io/raspbian buster/main armhf libio-html-perl all 1.001-1 [17.6 kB]
Get:38 http://mirror.datamossa.io/raspbian buster/main armhf liblwp-mediatypes-perl all 6.02-1 [22.1 kB]
Get:39 http://mirror.datamossa.io/raspbian buster/main armhf libhttp-message-perl all 6.18-1 [77.8 kB]
Get:40 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf nginx-common all 1.14.2-2+deb10u4 [121 kB]
Get:41 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libnginx-mod-http-auth-pam armhf 1.14.2-2+deb10u4 [92.2 kB]
Get:42 http://mirror.datamossa.io/raspbian buster/main armhf libxslt1.1 armhf 1.1.32-2.2~deb10u1 [215 kB]
Get:43 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libnginx-mod-http-dav-ext armhf 1.14.2-2+deb10u4 [98.9 kB]
Get:44 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libnginx-mod-http-echo armhf 1.14.2-2+deb10u4 [102 kB]
Get:45 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libnginx-mod-http-geoip armhf 1.14.2-2+deb10u4 [93.3 kB]
Get:46 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libnginx-mod-http-image-filter armhf 1.14.2-2+deb10u4 [96.5 kB]
Get:47 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libnginx-mod-http-subs-filter armhf 1.14.2-2+deb10u4 [95.2 kB]
Get:48 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libnginx-mod-http-upstream-fair armhf 1.14.2-2+deb10u4 [95.4 kB]
Get:49 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libnginx-mod-http-xslt-filter armhf 1.14.2-2+deb10u4 [94.9 kB]
Get:50 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libnginx-mod-mail armhf 1.14.2-2+deb10u4 [120 kB]
Get:51 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf libnginx-mod-stream armhf 1.14.2-2+deb10u4 [138 kB]
Get:52 http://mirror.datamossa.io/raspbian buster/main armhf libterm-readkey-perl armhf 2.38-1 [26.3 kB]
Get:53 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf mariadb-server all 1:10.3.29-0+deb10u1 [31.4 kB]
Get:54 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf nginx-full armhf 1.14.2-2+deb10u4 [441 kB]
Get:55 http://mirror.internode.on.net/pub/raspbian/raspbian buster/main armhf nginx all 1.14.2-2+deb10u4 [88.5 kB]
Get:56 http://mirror.datamossa.io/raspbian buster/main armhf ufw all 0.36-1 [164 kB]
Fetched 23.0 MB in 40s (570 kB/s)
Extracting templates from packages: 100%
Preconfiguring packages ...
Selecting previously unselected package libsigsegv2:armhf.
(Reading database ... 40487 files and directories currently installed.)
Preparing to unpack .../libsigsegv2_2.12-2_armhf.deb ...
Unpacking libsigsegv2:armhf (2.12-2) ...
Setting up libsigsegv2:armhf (2.12-2) ...
Selecting previously unselected package gawk.
(Reading database ... 40496 files and directories currently installed.)
Preparing to unpack .../00-gawk_1%3a4.2.1+dfsg-1_armhf.deb ...
Unpacking gawk (1:4.2.1+dfsg-1) ...
Selecting previously unselected package mysql-common.
Preparing to unpack .../01-mysql-common_5.8+1.0.5_all.deb ...
Unpacking mysql-common (5.8+1.0.5) ...
Selecting previously unselected package mariadb-common.
Preparing to unpack .../02-mariadb-common_1%3a10.3.29-0+deb10u1_all.deb ...
Unpacking mariadb-common (1:10.3.29-0+deb10u1) ...
Selecting previously unselected package galera-3.
Preparing to unpack .../03-galera-3_25.3.25-2_armhf.deb ...
Unpacking galera-3 (25.3.25-2) ...
Selecting previously unselected package libdbi-perl:armhf.
Preparing to unpack .../04-libdbi-perl_1.642-1+deb10u2_armhf.deb ...
Unpacking libdbi-perl:armhf (1.642-1+deb10u2) ...
Selecting previously unselected package lsof.
Preparing to unpack .../05-lsof_4.91+dfsg-1_armhf.deb ...
Unpacking lsof (4.91+dfsg-1) ...
Selecting previously unselected package libconfig-inifiles-perl.
Preparing to unpack .../06-libconfig-inifiles-perl_3.000001-1_all.deb ...
Unpacking libconfig-inifiles-perl (3.000001-1) ...
Selecting previously unselected package libaio1:armhf.
Preparing to unpack .../07-libaio1_0.3.112-3_armhf.deb ...
Unpacking libaio1:armhf (0.3.112-3) ...
Selecting previously unselected package libreadline5:armhf.
Preparing to unpack .../08-libreadline5_5.2+dfsg-3_armhf.deb ...
Unpacking libreadline5:armhf (5.2+dfsg-3) ...
Selecting previously unselected package libsnappy1v5:armhf.
Preparing to unpack .../09-libsnappy1v5_1.1.7-1_armhf.deb ...
Unpacking libsnappy1v5:armhf (1.1.7-1) ...
Selecting previously unselected package mariadb-client-core-10.3.
Preparing to unpack .../10-mariadb-client-core-10.3_1%3a10.3.29-0+deb10u1_armhf.deb ...
Unpacking mariadb-client-core-10.3 (1:10.3.29-0+deb10u1) ...
Selecting previously unselected package mariadb-client-10.3.
Preparing to unpack .../11-mariadb-client-10.3_1%3a10.3.29-0+deb10u1_armhf.deb ...
Unpacking mariadb-client-10.3 (1:10.3.29-0+deb10u1) ...
Selecting previously unselected package mariadb-server-core-10.3.
Preparing to unpack .../12-mariadb-server-core-10.3_1%3a10.3.29-0+deb10u1_armhf.deb ...
Unpacking mariadb-server-core-10.3 (1:10.3.29-0+deb10u1) ...
Selecting previously unselected package socat.
Preparing to unpack .../13-socat_1.7.3.2-2_armhf.deb ...
Unpacking socat (1.7.3.2-2) ...
Setting up mysql-common (5.8+1.0.5) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Setting up mariadb-common (1:10.3.29-0+deb10u1) ...
update-alternatives: using /etc/mysql/mariadb.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mariadb-server-10.3.
(Reading database ... 41097 files and directories currently installed.)
Preparing to unpack .../00-mariadb-server-10.3_1%3a10.3.29-0+deb10u1_armhf.deb ...
Unpacking mariadb-server-10.3 (1:10.3.29-0+deb10u1) ...
Selecting previously unselected package fonts-dejavu-core.
Preparing to unpack .../01-fonts-dejavu-core_2.37-1_all.deb ...
Unpacking fonts-dejavu-core (2.37-1) ...
Selecting previously unselected package fontconfig-config.
Preparing to unpack .../02-fontconfig-config_2.13.1-2_all.deb ...
Unpacking fontconfig-config (2.13.1-2) ...
Selecting previously unselected package libhtml-tagset-perl.
Preparing to unpack .../03-libhtml-tagset-perl_3.20-3_all.deb ...
Unpacking libhtml-tagset-perl (3.20-3) ...
Selecting previously unselected package liburi-perl.
Preparing to unpack .../04-liburi-perl_1.76-1_all.deb ...
Unpacking liburi-perl (1.76-1) ...
Selecting previously unselected package libhtml-parser-perl.
Preparing to unpack .../05-libhtml-parser-perl_3.72-3+b2_armhf.deb ...
Unpacking libhtml-parser-perl (3.72-3+b2) ...
Selecting previously unselected package libcgi-pm-perl.
Preparing to unpack .../06-libcgi-pm-perl_4.40-1_all.deb ...
Unpacking libcgi-pm-perl (4.40-1) ...
Selecting previously unselected package libfcgi-perl.
Preparing to unpack .../07-libfcgi-perl_0.78-2+b2_armhf.deb ...
Unpacking libfcgi-perl (0.78-2+b2) ...
Selecting previously unselected package libcgi-fast-perl.
Preparing to unpack .../08-libcgi-fast-perl_1%3a2.13-1_all.deb ...
Unpacking libcgi-fast-perl (1:2.13-1) ...
Selecting previously unselected package libmariadb3:armhf.
Preparing to unpack .../09-libmariadb3_1%3a10.3.29-0+deb10u1_armhf.deb ...
Unpacking libmariadb3:armhf (1:10.3.29-0+deb10u1) ...
Selecting previously unselected package libdbd-mysql-perl:armhf.
Preparing to unpack .../10-libdbd-mysql-perl_4.050-2_armhf.deb ...
Unpacking libdbd-mysql-perl:armhf (4.050-2) ...
Selecting previously unselected package libencode-locale-perl.
Preparing to unpack .../11-libencode-locale-perl_1.05-1_all.deb ...
Unpacking libencode-locale-perl (1.05-1) ...
Selecting previously unselected package libfontconfig1:armhf.
Preparing to unpack .../12-libfontconfig1_2.13.1-2_armhf.deb ...
Unpacking libfontconfig1:armhf (2.13.1-2) ...
Selecting previously unselected package libjbig0:armhf.
Preparing to unpack .../13-libjbig0_2.1-3.1+b2_armhf.deb ...
Unpacking libjbig0:armhf (2.1-3.1+b2) ...
Selecting previously unselected package libwebp6:armhf.
Preparing to unpack .../14-libwebp6_0.6.1-2+deb10u1_armhf.deb ...
Unpacking libwebp6:armhf (0.6.1-2+deb10u1) ...
Selecting previously unselected package libtiff5:armhf.
Preparing to unpack .../15-libtiff5_4.1.0+git191117-2~deb10u2_armhf.deb ...
Unpacking libtiff5:armhf (4.1.0+git191117-2~deb10u2) ...
Selecting previously unselected package libxpm4:armhf.
Preparing to unpack .../16-libxpm4_1%3a3.5.12-1_armhf.deb ...
Unpacking libxpm4:armhf (1:3.5.12-1) ...
Selecting previously unselected package libgd3:armhf.
Preparing to unpack .../17-libgd3_2.2.5-5.2_armhf.deb ...
Unpacking libgd3:armhf (2.2.5-5.2) ...
Selecting previously unselected package libhtml-template-perl.
Preparing to unpack .../18-libhtml-template-perl_2.97-1_all.deb ...
Unpacking libhtml-template-perl (2.97-1) ...
Selecting previously unselected package libtimedate-perl.
Preparing to unpack .../19-libtimedate-perl_2.3000-2+deb10u1_all.deb ...
Unpacking libtimedate-perl (2.3000-2+deb10u1) ...
Selecting previously unselected package libhttp-date-perl.
Preparing to unpack .../20-libhttp-date-perl_6.02-1_all.deb ...
Unpacking libhttp-date-perl (6.02-1) ...
Selecting previously unselected package libio-html-perl.
Preparing to unpack .../21-libio-html-perl_1.001-1_all.deb ...
Unpacking libio-html-perl (1.001-1) ...
Selecting previously unselected package liblwp-mediatypes-perl.
Preparing to unpack .../22-liblwp-mediatypes-perl_6.02-1_all.deb ...
Unpacking liblwp-mediatypes-perl (6.02-1) ...
Selecting previously unselected package libhttp-message-perl.
Preparing to unpack .../23-libhttp-message-perl_6.18-1_all.deb ...
Unpacking libhttp-message-perl (6.18-1) ...
Selecting previously unselected package nginx-common.
Preparing to unpack .../24-nginx-common_1.14.2-2+deb10u4_all.deb ...
Unpacking nginx-common (1.14.2-2+deb10u4) ...
Selecting previously unselected package libnginx-mod-http-auth-pam.
Preparing to unpack .../25-libnginx-mod-http-auth-pam_1.14.2-2+deb10u4_armhf.deb ...
Unpacking libnginx-mod-http-auth-pam (1.14.2-2+deb10u4) ...
Selecting previously unselected package libxslt1.1:armhf.
Preparing to unpack .../26-libxslt1.1_1.1.32-2.2~deb10u1_armhf.deb ...
Unpacking libxslt1.1:armhf (1.1.32-2.2~deb10u1) ...
Selecting previously unselected package libnginx-mod-http-dav-ext.
Preparing to unpack .../27-libnginx-mod-http-dav-ext_1.14.2-2+deb10u4_armhf.deb ...
Unpacking libnginx-mod-http-dav-ext (1.14.2-2+deb10u4) ...
Selecting previously unselected package libnginx-mod-http-echo.
Preparing to unpack .../28-libnginx-mod-http-echo_1.14.2-2+deb10u4_armhf.deb ...
Unpacking libnginx-mod-http-echo (1.14.2-2+deb10u4) ...
Selecting previously unselected package libnginx-mod-http-geoip.
Preparing to unpack .../29-libnginx-mod-http-geoip_1.14.2-2+deb10u4_armhf.deb ...
Unpacking libnginx-mod-http-geoip (1.14.2-2+deb10u4) ...
Selecting previously unselected package libnginx-mod-http-image-filter.
Preparing to unpack .../30-libnginx-mod-http-image-filter_1.14.2-2+deb10u4_armhf.deb ...
Unpacking libnginx-mod-http-image-filter (1.14.2-2+deb10u4) ...
Selecting previously unselected package libnginx-mod-http-subs-filter.
Preparing to unpack .../31-libnginx-mod-http-subs-filter_1.14.2-2+deb10u4_armhf.deb ...
Unpacking libnginx-mod-http-subs-filter (1.14.2-2+deb10u4) ...
Selecting previously unselected package libnginx-mod-http-upstream-fair.
Preparing to unpack .../32-libnginx-mod-http-upstream-fair_1.14.2-2+deb10u4_armhf.deb ...
Unpacking libnginx-mod-http-upstream-fair (1.14.2-2+deb10u4) ...
Selecting previously unselected package libnginx-mod-http-xslt-filter.
Preparing to unpack .../33-libnginx-mod-http-xslt-filter_1.14.2-2+deb10u4_armhf.deb ...
Unpacking libnginx-mod-http-xslt-filter (1.14.2-2+deb10u4) ...
Selecting previously unselected package libnginx-mod-mail.
Preparing to unpack .../34-libnginx-mod-mail_1.14.2-2+deb10u4_armhf.deb ...
Unpacking libnginx-mod-mail (1.14.2-2+deb10u4) ...
Selecting previously unselected package libnginx-mod-stream.
Preparing to unpack .../35-libnginx-mod-stream_1.14.2-2+deb10u4_armhf.deb ...
Unpacking libnginx-mod-stream (1.14.2-2+deb10u4) ...
Selecting previously unselected package libterm-readkey-perl.
Preparing to unpack .../36-libterm-readkey-perl_2.38-1_armhf.deb ...
Unpacking libterm-readkey-perl (2.38-1) ...
Selecting previously unselected package mariadb-server.
Preparing to unpack .../37-mariadb-server_1%3a10.3.29-0+deb10u1_all.deb ...
Unpacking mariadb-server (1:10.3.29-0+deb10u1) ...
Selecting previously unselected package nginx-full.
Preparing to unpack .../38-nginx-full_1.14.2-2+deb10u4_armhf.deb ...
Unpacking nginx-full (1.14.2-2+deb10u4) ...
Selecting previously unselected package nginx.
Preparing to unpack .../39-nginx_1.14.2-2+deb10u4_all.deb ...
Unpacking nginx (1.14.2-2+deb10u4) ...
Selecting previously unselected package ufw.
Preparing to unpack .../40-ufw_0.36-1_all.deb ...
Unpacking ufw (0.36-1) ...
Setting up libconfig-inifiles-perl (3.000001-1) ...
Setting up libreadline5:armhf (5.2+dfsg-3) ...
Setting up libxpm4:armhf (1:3.5.12-1) ...
Setting up gawk (1:4.2.1+dfsg-1) ...
Setting up libhtml-tagset-perl (3.20-3) ...
Setting up liblwp-mediatypes-perl (6.02-1) ...
Setting up nginx-common (1.14.2-2+deb10u4) ...
Created symlink /etc/systemd/system/multi-user.target.wants/nginx.service → /lib/systemd/system/nginx.service.
Setting up libencode-locale-perl (1.05-1) ...
Setting up ufw (0.36-1) ...

Creating config file /etc/ufw/before.rules with new version

Creating config file /etc/ufw/before6.rules with new version

Creating config file /etc/ufw/after.rules with new version

Creating config file /etc/ufw/after6.rules with new version
Created symlink /etc/systemd/system/multi-user.target.wants/ufw.service → /lib/systemd/system/ufw.service.
Setting up libjbig0:armhf (2.1-3.1+b2) ...
Setting up libsnappy1v5:armhf (1.1.7-1) ...
Setting up libnginx-mod-http-auth-pam (1.14.2-2+deb10u4) ...
Setting up libnginx-mod-http-geoip (1.14.2-2+deb10u4) ...
Setting up socat (1.7.3.2-2) ...
Setting up libio-html-perl (1.001-1) ...
Setting up libwebp6:armhf (0.6.1-2+deb10u1) ...
Setting up libmariadb3:armhf (1:10.3.29-0+deb10u1) ...
Setting up fonts-dejavu-core (2.37-1) ...
Setting up lsof (4.91+dfsg-1) ...
Setting up galera-3 (25.3.25-2) ...
Setting up libtimedate-perl (2.3000-2+deb10u1) ...
Setting up libnginx-mod-http-echo (1.14.2-2+deb10u4) ...
Setting up libnginx-mod-http-subs-filter (1.14.2-2+deb10u4) ...
Setting up libxslt1.1:armhf (1.1.32-2.2~deb10u1) ...
Setting up libfcgi-perl (0.78-2+b2) ...
Setting up libtiff5:armhf (4.1.0+git191117-2~deb10u2) ...
Setting up libterm-readkey-perl (2.38-1) ...
Setting up libaio1:armhf (0.3.112-3) ...
Setting up liburi-perl (1.76-1) ...
Setting up libdbi-perl:armhf (1.642-1+deb10u2) ...
Setting up libnginx-mod-http-dav-ext (1.14.2-2+deb10u4) ...
Setting up libnginx-mod-mail (1.14.2-2+deb10u4) ...
Setting up libhttp-date-perl (6.02-1) ...
Setting up fontconfig-config (2.13.1-2) ...
Setting up libnginx-mod-stream (1.14.2-2+deb10u4) ...
Setting up libnginx-mod-http-upstream-fair (1.14.2-2+deb10u4) ...
Setting up libnginx-mod-http-xslt-filter (1.14.2-2+deb10u4) ...
Setting up mariadb-server-core-10.3 (1:10.3.29-0+deb10u1) ...
Setting up libdbd-mysql-perl:armhf (4.050-2) ...
Setting up mariadb-client-core-10.3 (1:10.3.29-0+deb10u1) ...
Setting up libhtml-parser-perl (3.72-3+b2) ...
Setting up libfontconfig1:armhf (2.13.1-2) ...
Setting up libhttp-message-perl (6.18-1) ...
Setting up libcgi-pm-perl (4.40-1) ...
Setting up libhtml-template-perl (2.97-1) ...
Setting up libgd3:armhf (2.2.5-5.2) ...
Setting up mariadb-client-10.3 (1:10.3.29-0+deb10u1) ...
Setting up mariadb-server-10.3 (1:10.3.29-0+deb10u1) ...
Created symlink /etc/systemd/system/mysql.service → /lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /lib/systemd/system/mariadb.service.
Setting up libcgi-fast-perl (1:2.13-1) ...
Setting up libnginx-mod-http-image-filter (1.14.2-2+deb10u4) ...
Setting up nginx-full (1.14.2-2+deb10u4) ...
Setting up mariadb-server (1:10.3.29-0+deb10u1) ...
Setting up nginx (1.14.2-2+deb10u4) ...
Processing triggers for rsyslog (8.1901.0-1) ...
Processing triggers for systemd (241-7~deb10u8+rpi1) ...
Processing triggers for man-db (2.8.5-2) ...
Processing triggers for libc-bin (2.28-10+rpt2+rpi1) ...
pi@raspberrypi:~ $ sudo ufw allow ssh && sudo ufw allow http && sudo ufw allow https && sudo ufw allow 'Nginx Full'
Rules updated
Rules updated (v6)
Rules updated
Rules updated (v6)
Rules updated
Rules updated (v6)
Rules updated
Rules updated (v6)
pi@raspberrypi:~ $ sudo ufw enable
Command may disrupt existing ssh connections. Proceed with operation (y|n)? y
Firewall is active and enabled on system startup
pi@raspberrypi:~ $ sudo mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] n
 ... skipping.

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!
pi@raspberrypi:~ $ sudo mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 56
Server version: 10.3.29-MariaDB-0+deb10u1 Raspbian 10

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [mysql]> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
Query OK, 1 row affected (0.001 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [mysql]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)

MariaDB [mysql]> exit;
Bye
pi@raspberrypi:~ $ sudo nano /etc/nginx/nginx.conf
pi@raspberrypi:~ $ sudo nginx -t
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful
pi@raspberrypi:~ $ sudo nano /etc/nginx/nginx.conf
pi@raspberrypi:~ $ sudo systemctl restart nginx
pi@raspberrypi:~ $ curl -sL https://deb.nodesource.com/setup_14.x | sudo -E bash

## Installing the NodeSource Node.js 14.x repo...


## Populating apt-get cache...

+ apt-get update
Hit:1 http://archive.raspberrypi.org/debian buster InRelease
Hit:2 http://raspbian.raspberrypi.org/raspbian buster InRelease
Reading package lists... Done

## Confirming "buster" is supported...

+ curl -sLf -o /dev/null 'https://deb.nodesource.com/node_14.x/dists/buster/Release'

## Adding the NodeSource signing key to your keyring...

+ curl -s https://deb.nodesource.com/gpgkey/nodesource.gpg.key | gpg --dearmor | tee /usr/share/keyrings/nodesource.gpg >/dev/null
gpg: WARNING: unsafe ownership on homedir '/home/pi/.gnupg'

## Creating apt sources list file for the NodeSource Node.js 14.x repo...

+ echo 'deb [signed-by=/usr/share/keyrings/nodesource.gpg] https://deb.nodesource.com/node_14.x buster main' > /etc/apt/sources.list.d/nodesource.list
+ echo 'deb-src [signed-by=/usr/share/keyrings/nodesource.gpg] https://deb.nodesource.com/node_14.x buster main' >> /etc/apt/sources.list.d/nodesource.list

## Running `apt-get update` for you...

+ apt-get update
Hit:1 http://raspbian.raspberrypi.org/raspbian buster InRelease
Hit:2 http://archive.raspberrypi.org/debian buster InRelease
Get:3 https://deb.nodesource.com/node_14.x buster InRelease [4,584 B]
Get:4 https://deb.nodesource.com/node_14.x buster/main armhf Packages [780 B]
Fetched 5,364 B in 2s (2,283 B/s)
Reading package lists... Done

## Run `sudo apt-get install -y nodejs` to install Node.js 14.x and npm
## You may also need development tools to build native addons:
     sudo apt-get install gcc g++ make
## To install the Yarn package manager, run:
     curl -sL https://dl.yarnpkg.com/debian/pubkey.gpg | gpg --dearmor | sudo tee /usr/share/keyrings/yarnkey.gpg >/dev/null
     echo "deb [signed-by=/usr/share/keyrings/yarnkey.gpg] https://dl.yarnpkg.com/debian stable main" | sudo tee /etc/apt/sources.list.d/yarn.list
     sudo apt-get update && sudo apt-get install yarn


pi@raspberrypi:~ $ sudo apt-get install -y nodejs
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
  nodejs
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 23.0 MB of archives.
After this operation, 116 MB of additional disk space will be used.
Get:1 https://deb.nodesource.com/node_14.x buster/main armhf nodejs armhf 14.18.0-deb-1nodesource1 [23.0 MB]
Fetched 23.0 MB in 2s (11.7 MB/s)
Selecting previously unselected package nodejs.
(Reading database ... 41940 files and directories currently installed.)
Preparing to unpack .../nodejs_14.18.0-deb-1nodesource1_armhf.deb ...
Unpacking nodejs (14.18.0-deb-1nodesource1) ...
Setting up nodejs (14.18.0-deb-1nodesource1) ...
Processing triggers for man-db (2.8.5-2) ...
pi@raspberrypi:~ $ sudo mkdir -p /var/www/ghost
pi@raspberrypi:~ $ sudo chown pi:pi /var/www/ghost
pi@raspberrypi:~ $ sudo npm i -g ghost-cli@latest

> yarn@1.22.10 preinstall /usr/lib/node_modules/ghost-cli/node_modules/yarn
> :; (node ./preinstall.js > /dev/null 2>&1 || true)

/usr/bin/ghost -> /usr/lib/node_modules/ghost-cli/bin/ghost
+ ghost-cli@1.17.3
added 417 packages from 207 contributors in 67.017s
pi@raspberrypi:~ $ cd /var/www/ghost
pi@raspberrypi:/var/www/ghost $ ghost install
✔ Checking system Node.js version - found v14.18.0
✔ Checking logged in user
✔ Checking current folder permissions
System checks failed with message: 'Linux version is not Ubuntu 16, 18, or 20'
Some features of Ghost-CLI may not work without additional configuration.
For local installs we recommend using `ghost install local` instead.
? Continue anyway? Yes
System stack check skipped
ℹ Checking system compatibility [skipped]
✔ Checking for a MySQL installation
✔ Checking memory availability
✔ Checking free space
✔ Checking for latest Ghost version
✔ Setting up install directory
✔ Downloading and installing Ghost v4.17.0
✔ Finishing install process
? Enter your blog URL: http://localhost:2368
? Enter your MySQL hostname: localhost
? Enter your MySQL username: root
? Enter your MySQL password: [hidden]
? Enter your Ghost database name: ghost_prod
✔ Configuring Ghost
✔ Setting up instance
+ sudo useradd --system --user-group ghost
+ sudo chown -R ghost:ghost /var/www/ghost/content
✔ Setting up "ghost" system user
? Do you wish to set up "ghost" mysql user? Yes
✔ Setting up "ghost" mysql user
Your url contains a port. Skipping Nginx setup.
ℹ Setting up Nginx [skipped]
Nginx setup task was skipped, skipping SSL setup
ℹ Setting up SSL [skipped]
? Do you wish to set up Systemd? Yes
+ sudo mv /tmp/localhost/ghost_localhost.service /lib/systemd/system/ghost_localhost.service
+ sudo systemctl daemon-reload
✔ Setting up Systemd
+ sudo systemctl is-active ghost_localhost
? Do you want to start Ghost? Yes
+ sudo systemctl start ghost_localhost
+ sudo systemctl is-enabled ghost_localhost
+ sudo systemctl enable ghost_localhost --quiet
✔ Starting Ghost

Ghost uses direct mail by default. To set up an alternative email method read our docs at https://ghost.org/docs/config/#mail

------------------------------------------------------------------------------

Ghost was installed successfully! To complete setup of your publication, visit:

    http://localhost:2368/ghost/

pi@raspberrypi:/var/www/ghost $ ghost config --url http://192.168.1.208
pi@raspberrypi:/var/www/ghost $