wiki3 - another wiki machine
guest os: FreeBSD / amd64
cpu: 2
memory size: 1408 MB
storage: file - 13 GB
tmux commands: ls - list session, attach - t
tmux keys: ctrl-B command key, ctrl-b i information, ctrl-b t time, ctrl-b d detach,
back to virtual machines page.
History
2024-02-18: vtbd0p2 - reboot, FreeBSD 13.2-release-p10 is in
root@wiki3:~ # freebsd-version -ku 13.2-RELEASE-p10 13.2-RELEASE-p10
kernel
root@wiki3:~ # uname -a FreeBSD wiki3.kg4.no 13.2-RELEASE-p10 FreeBSD 13.2-RELEASE-p10 GENERIC amd64
2024-02-18: vtbd0p2 - freebsd-update fetch
root@wiki3:~ # freebsd-update fetch src component not installed, skipped [..] The following files will be updated as part of updating to 13.2-RELEASE-p10: /bin/freebsd-version /boot/kernel/kernel [..] /var/db/etcupdate/current/etc/defaults/rc.conf /var/db/etcupdate/current/etc/periodic/daily/480.leapfile-ntpd /var/db/mergemaster.mtree
install
root@wiki3:~ # freebsd-update install src component not installed, skipped Installing updates... Restarting sshd after upgrade Performing sanity check on sshd configuration. Stopping sshd. Waiting for PIDS: 1914. Performing sanity check on sshd configuration. Starting sshd. Scanning //usr/share/certs/blacklisted for certificates... Scanning //usr/share/certs/trusted for certificates... Scanning //usr/local/share/certs for certificates... done.
2024-01-06: vtbd0p2 - mysql - mysql now requires the '--skip-binary-as-hex' parameter when starting, example
tingo@wiki3:~ $ mysql --skip-binary-as-hex -u wikiuser -p wikidb Enter password:
If you skip this, mysql defults to returning text as hex data. Example
tingo@wiki3:~ $ mysql -u wikiuser -p wikidb Enter password:
and you get stuff like this
wikiuser@localhost [wikidb]> select user_id, user_name, user_real_name from user; +---------+----------------------+--------------------------------+ | user_id | user_name | user_real_name | +---------+----------------------+--------------------------------+ | 1 | 0x54696E676F | 0x | +---------+----------------------+--------------------------------+ 1 row in set (0.00 sec)
with '--skip-binary-as-hex'
tingo@wiki3:~ $ mysql --skip-binary-as-hex -u wikiuser -p wikidb Enter password:
you get
wikiuser@localhost [wikidb]> select user_id, user_name, user_real_name from user; +---------+-----------+----------------+ | user_id | user_name | user_real_name | +---------+-----------+----------------+ | 1 | Tingo | | +---------+-----------+----------------+ 1 row in set (0.00 sec)
check the status command
wikiuser@localhost [wikidb]> \s -------------- mysql Ver 8.0.33 for FreeBSD13.2 on amd64 (Source distribution) Connection id: 352 Current database: wikidb Current user: wikiuser@localhost SSL: Not in use Current pager: less Using outfile: '' Using delimiter: ; Server version: 8.0.33 Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8mb4 Conn. characterset: utf8mb4 UNIX socket: /tmp/mysql.sock Uptime: 1 hour 45 min 51 sec Threads: 2 Questions: 27048 Slow queries: 8 Opens: 1165 Flush tables: 4 Open tables: 650 Queries per second avg: 4.258 --------------
without '--skip-binary-as-hex' the status command shows
wikiuser@localhost [wikidb]> \s -------------- mysql Ver 8.0.33 for FreeBSD13.2 on amd64 (Source distribution) Connection id: 353 Current database: wikidb Current user: wikiuser@localhost SSL: Not in use Current pager: less Using outfile: '' Using delimiter: ; Server version: 8.0.33 Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8mb4 Conn. characterset: utf8mb4 UNIX socket: /tmp/mysql.sock Binary data as: Hexadecimal Uptime: 1 hour 47 min 2 sec Threads: 2 Questions: 27054 Slow queries: 8 Opens: 1165 Flush tables: 4 Open tables: 650 Queries per second avg: 4.212 --------------
now you know.
2024-01-06: vtbd0p2 - pkg - upgrade
Jan 6 13:39:41 wiki3 pkg[2096]: pkg upgraded: 1.19.2 -> 1.20.9 Jan 6 13:40:50 wiki3 pkg[2117]: xorgproto upgraded: 2022.1_1 -> 2023.2 Jan 6 13:40:51 wiki3 pkg[2117]: gettext-runtime upgraded: 0.21.1 -> 0.22_1 Jan 6 13:40:52 wiki3 pkg[2117]: libxml2 upgraded: 2.10.4 -> 2.10.4_1 Jan 6 13:41:32 wiki3 pkg[2117]: python39 upgraded: 3.9.17 -> 3.9.18 Jan 6 13:41:33 wiki3 pkg[2117]: libICE upgraded: 1.1.0_1,1 -> 1.1.0_2,1 Jan 6 13:41:33 wiki3 pkg[2117]: png upgraded: 1.6.39 -> 1.6.40 Jan 6 13:41:34 wiki3 pkg[2117]: jpeg-turbo upgraded: 2.1.5.1 -> 3.0.0 Jan 6 13:41:34 wiki3 pkg[2117]: libdeflate upgraded: 1.18 -> 1.19 Jan 6 13:41:39 wiki3 pkg[2117]: libX11 upgraded: 1.8.6,1 -> 1.8.7,1 Jan 6 13:41:39 wiki3 pkg[2117]: brotli upgraded: 1.0.9,1 -> 1.1.0,1 Jan 6 13:41:40 wiki3 pkg[2117]: libSM upgraded: 1.2.3,1 -> 1.2.3_1,1 Jan 6 13:41:44 wiki3 pkg[2117]: glib upgraded: 2.76.4,2 -> 2.78.3,2 Jan 6 13:41:45 wiki3 pkg[2117]: freetype2 upgraded: 2.12.1_2 -> 2.13.1 Jan 6 13:41:46 wiki3 pkg[2117]: dbus upgraded: 1.14.6,1 -> 1.14.10_1,1 Jan 6 13:41:47 wiki3 pkg[2117]: libfontenc upgraded: 1.1.4 -> 1.1.7 Jan 6 13:41:47 wiki3 pkg[2117]: gmp upgraded: 6.2.1 -> 6.3.0 Jan 6 13:41:49 wiki3 pkg[2117]: tiff upgraded: 4.4.0_1 -> 4.4.0_2 Jan 6 13:41:50 wiki3 pkg[2117]: gdk-pixbuf2 upgraded: 2.42.10 -> 2.42.10_1 Jan 6 13:41:50 wiki3 pkg[2117]: libcjson upgraded: 1.7.15_1 -> 1.7.16 Jan 6 13:41:51 wiki3 pkg[2117]: highway upgraded: 1.0.4_1 -> 1.0.7 Jan 6 13:41:53 wiki3 pkg[2117]: openexr upgraded: 3.1.9 -> 3.2.0 Jan 6 13:41:53 wiki3 pkg[2117]: libglvnd upgraded: 1.6.0 -> 1.6.0_2 Jan 6 13:41:54 wiki3 pkg[2117]: lcms2 upgraded: 2.15_1 -> 2.15_2 Jan 6 13:41:54 wiki3 pkg[2117]: libnghttp2 upgraded: 1.53.0 -> 1.57.0 Jan 6 13:41:58 wiki3 pkg[2117]: libjxl upgraded: 0.8.2 -> 0.8.2_3 Jan 6 13:41:58 wiki3 pkg[2117]: webp upgraded: 1.3.0_1 -> 1.3.2 Jan 6 13:41:59 wiki3 pkg[2117]: ca_root_nss upgraded: 3.89.1 -> 3.93 Jan 6 13:42:04 wiki3 pkg[2117]: php82 upgraded: 8.2.7 -> 8.2.11 Jan 6 13:42:05 wiki3 pkg[2117]: font-bh-ttf upgraded: 1.0.3_4 -> 1.0.3_5 Jan 6 13:42:38 wiki3 pkg[2117]: perl5 upgraded: 5.32.1_3 -> 5.34.3_3 Jan 6 13:42:39 wiki3 pkg[2117]: font-misc-meltho upgraded: 1.0.3_4 -> 1.0.3_5 Jan 6 13:42:40 wiki3 pkg[2117]: dejavu upgraded: 2.37_1 -> 2.37_3 Jan 6 13:42:44 wiki3 pkg[2117]: groff upgraded: 1.22.4_4 -> 1.23.0_2 Jan 6 13:42:44 wiki3 pkg[2117]: php82-dom upgraded: 8.2.7 -> 8.2.11 Jan 6 13:42:45 wiki3 pkg[2117]: openjpeg upgraded: 2.5.0 -> 2.5.0_1 Jan 6 13:42:47 wiki3 pkg[2117]: aom upgraded: 3.6.1 -> 3.7.1 Jan 6 13:42:47 wiki3 pkg[2117]: libgd upgraded: 2.3.3_5,1 -> 2.3.3_7,1 Jan 6 13:42:49 wiki3 pkg[2117]: harfbuzz upgraded: 7.3.0 -> 8.2.2 Jan 6 13:42:53 wiki3 pkg[2117]: curl upgraded: 8.1.2 -> 8.5.0 Jan 6 13:42:55 wiki3 pkg[2117]: svt-av1 upgraded: 1.6.0 -> 1.7.0 Jan 6 13:42:55 wiki3 pkg[2117]: jbig2dec upgraded: 0.19 -> 0.20 Jan 6 13:42:55 wiki3 pkg[2117]: dav1d upgraded: 1.2.1 -> 1.2.1_2 Jan 6 13:42:57 wiki3 pkg[2117]: openldap26-client upgraded: 2.6.4 -> 2.6.6 Jan 6 13:42:57 wiki3 pkg[2117]: php82-session upgraded: 8.2.7 -> 8.2.11 Jan 6 13:42:57 wiki3 pkg[2117]: php82-zlib upgraded: 8.2.7 -> 8.2.11 Jan 6 13:42:58 wiki3 pkg[2117]: php82-readline upgraded: 8.2.7 -> 8.2.11 Jan 6 13:42:58 wiki3 pkg[2117]: php82-mbstring upgraded: 8.2.7 -> 8.2.11 Jan 6 13:43:06 wiki3 pkg[2117]: ghostscript9-agpl-base upgraded: 9.56.1_11 -> 9.56.1_12 Jan 6 13:43:07 wiki3 pkg[2117]: libraw upgraded: 0.21.1_1 -> 0.21.1_2 Jan 6 13:43:07 wiki3 pkg[2117]: pkgconf upgraded: 1.8.1,1 -> 2.0.3,1 Jan 6 13:43:08 wiki3 pkg[2117]: php82-mysqli upgraded: 8.2.7 -> 8.2.11 Jan 6 13:43:08 wiki3 pkg[2117]: php82-sockets upgraded: 8.2.7 -> 8.2.11 Jan 6 13:43:08 wiki3 pkg[2117]: php82-xmlreader upgraded: 8.2.7 -> 8.2.11 Jan 6 13:43:08 wiki3 pkg[2117]: php82-xml upgraded: 8.2.7 -> 8.2.11 Jan 6 13:43:12 wiki3 pkg[2117]: mysql80-client upgraded: 8.0.32_3 -> 8.0.33_3 Jan 6 13:43:12 wiki3 pkg[2117]: php82-intl upgraded: 8.2.7 -> 8.2.11 Jan 6 13:43:14 wiki3 pkg[2117]: libwmf-nox11 upgraded: 0.2.13 -> 0.2.13_2 Jan 6 13:43:15 wiki3 pkg[2117]: php82-ctype upgraded: 8.2.7 -> 8.2.11 Jan 6 13:43:15 wiki3 pkg[2117]: php82-iconv upgraded: 8.2.7 -> 8.2.11 Jan 6 13:43:15 wiki3 pkg[2117]: php82-fileinfo upgraded: 8.2.7 -> 8.2.11 Jan 6 13:43:15 wiki3 pkg[2117]: php82-filter upgraded: 8.2.7 -> 8.2.11 Jan 6 13:43:18 wiki3 pkg[2117]: librsvg2-rust upgraded: 2.56.2 -> 2.56.4 Jan 6 13:45:45 wiki3 pkg[2117]: mediawiki140-php82 upgraded: 1.40.0 -> 1.40.1 Jan 6 13:45:54 wiki3 pkg[2117]: ImageMagick7-nox11 upgraded: 7.1.0.62_5 -> 7.1.0.62_7 Jan 6 13:46:07 wiki3 pkg[2117]: mysql80-server upgraded: 8.0.32_3 -> 8.0.33 Jan 6 13:46:12 wiki3 pkg[2117]: sudo upgraded: 1.9.14 -> 1.9.15p4
2024-01-06: vtbd0p2 - freebsd-update fetch
root@wiki3:~ # freebsd-update fetch src component not installed, skipped [..] The following files will be added as part of updating to 13.2-RELEASE-p9: The following files will be updated as part of updating to 13.2-RELEASE-p9: /usr/sbin/bhyve /usr/sbin/freebsd-update /usr/sbin/nologin /usr/sbin/sshd /usr/share/man/man1/ssh-agent.1.gz /usr/share/man/man5/sshd_config.5.gz /var/db/etcupdate/current/etc/ssh/sshd_config /var/db/mergemaster.mtree
install
root@wiki3:~ # freebsd-update install src component not installed, skipped Installing updates... Restarting sshd after upgrade Performing sanity check on sshd configuration. Stopping sshd. Waiting for PIDS: 1715. Performing sanity check on sshd configuration. Starting sshd. Scanning //usr/share/certs/blacklisted for certificates... Scanning //usr/share/certs/trusted for certificates... Scanning //usr/local/share/certs for certificates... done.
2023-07-16: vtbd0p2 - convert (from ImageMagick) is helpful enough (or perhaps MediaWiki is) to show one of the error messages in the file list
Error creating thumbnail: convert: attempt to perform an operation not allowed by the security policy `MVG' @ error/constitute.c/IsCoderAuthorized/449. convert: no images defined `PNG:/tmp//transform_61bc927808c4.png' @ error/convert.c/ConvertImageCommand/3342.
that's interesting. See if we have policy files for ImageMagick
root@wiki3:~ # ll /usr/local/etc/ImageMagick-7/p* -rw-r--r-- 1 root wheel 4109 Jul 8 09:06 /usr/local/etc/ImageMagick-7/policy.xml -rw-r--r-- 1 root wheel 4109 Jul 8 09:06 /usr/local/etc/ImageMagick-7/policy.xml.sample
yes. So change the policy
root@wiki3:~ # diff /usr/local/etc/ImageMagick-7/policy.xml.sample /usr/local/etc/ImageMagick-7/policy.xml 68c68 < <policy domain="coder" rights="none" pattern="MVG" /> --- > <policy domain="coder" rights="read|write" pattern="MVG" />
yep, that works.
2023-07-16: vtbd0p2 - pkg - install librsvg2-rust
Jul 16 11:41:34 wiki3 pkg[6102]: libfontenc-1.1.4 installed Jul 16 11:41:34 wiki3 pkg[6102]: mkfontscale-1.2.1 installed Jul 16 11:41:35 wiki3 pkg[6102]: libXext-1.3.4,1 installed Jul 16 11:41:35 wiki3 pkg[6102]: libdatrie-0.2.13_1 installed Jul 16 11:41:35 wiki3 pkg[6102]: libglvnd-1.6.0 installed Jul 16 11:41:36 wiki3 pkg[6102]: font-misc-ethiopic-1.0.4 installed Jul 16 11:41:36 wiki3 pkg[6102]: libXrender-0.9.10_2 installed Jul 16 11:41:36 wiki3 pkg[6102]: graphite2-1.3.14 installed Jul 16 11:41:36 wiki3 pkg[6102]: encodings-1.0.5,1 installed Jul 16 11:41:37 wiki3 pkg[6102]: font-bh-ttf-1.0.3_4 installed Jul 16 11:41:37 wiki3 pkg[6102]: pixman-0.42.2 installed Jul 16 11:41:38 wiki3 pkg[6102]: font-misc-meltho-1.0.3_4 installed Jul 16 11:41:40 wiki3 pkg[6102]: dejavu-2.37_1 installed Jul 16 11:41:40 wiki3 pkg[6102]: libthai-0.1.29 installed Jul 16 11:41:40 wiki3 pkg[6102]: fribidi-1.0.13 installed Jul 16 11:41:41 wiki3 pkg[6102]: libXft-2.3.7 installed Jul 16 11:41:42 wiki3 pkg[6102]: cairo-1.17.4_2,3 installed Jul 16 11:41:44 wiki3 pkg[6102]: harfbuzz-7.3.0 installed Jul 16 11:41:44 wiki3 pkg[6102]: xorg-fonts-truetype-7.7_1 installed Jul 16 11:41:49 wiki3 pkg[6102]: pango-1.50.14 installed Jul 16 11:41:51 wiki3 pkg[6102]: librsvg2-rust-2.56.2 installed
check for rsvg-convert
root@wiki3:~ # which rsvg-convert /usr/local/bin/rsvg-convert
and see if it runs
root@wiki3:~ # rsvg-convert --help Convert SVG files to other image formats Usage: rsvg-convert [OPTIONS] [FILE]... Arguments: [FILE]... The input file(s) to convert Options: -?, --help Display the help -v, --version Display the version information -d, --dpi-x <number> Pixels per inch [default: 96] -p, --dpi-y <number> Pixels per inch [default: 96] -x, --x-zoom <number> Horizontal zoom factor -y, --y-zoom <number> Vertical zoom factor -z, --zoom <number> Zoom factor -w, --width <length> Width [defaults to the width of the SVG] -h, --height <length> Height [defaults to the height of the SVG] --top <length> Distance between top edge of page and the image [defaults to 0] --left <length> Distance between left edge of page and the image [defaults to 0] --page-width <length> Width of output media [defaults to the width of the SVG] --page-height <length> Height of output media [defaults to the height of the SVG] -f, --format <format> Output format [default: png] [possible values: png, pdf, ps, eps, svg] -o, --output <output> Output filename [defaults to stdout] -i, --export-id <object id> SVG id of object to export [default is to export all objects] -l, --accept-language <languages> Languages to accept, for example "es-MX,de,en" [default uses language from the environment] -a, --keep-aspect-ratio Preserve the aspect ratio -b, --background-color <color> Set the background color using a CSS color spec [default: none] -s, --stylesheet <filename.css> Filename of CSS stylesheet to apply -u, --unlimited Allow huge SVG files --keep-image-data Keep image data --no-keep-image-data Do not keep image data --completion <completion> Output shell completion for the given shell [possible values: bash, elvish, fish, powershell, zsh]
good.
2023-07-16: vtbd0p2 - check what convert uses for svg's
root@wiki3:~ # convert -list delegate | grep 'svg =' svg => "rsvg-convert' -o '%o' '%i"
2023-07-16: vtbd0p2 - pkg - install ImageMagick7
Jul 16 11:21:11 wiki3 pkg[5316]: xorgproto-2022.1_1 installed Jul 16 11:21:11 wiki3 pkg[5316]: libXau-1.0.9 installed Jul 16 11:21:11 wiki3 pkg[5316]: libXdmcp-1.1.3 installed Jul 16 11:21:21 wiki3 pkg[5316]: libxcb-1.15_1 installed Jul 16 11:21:21 wiki3 pkg[5316]: libICE-1.1.0_1,1 installed Jul 16 11:21:21 wiki3 pkg[5316]: jpeg-turbo-2.1.5.1 installed Jul 16 11:21:22 wiki3 pkg[5316]: libdeflate-1.18 installed Jul 16 11:21:22 wiki3 pkg[5316]: libSM-1.2.3,1 installed Jul 16 11:21:26 wiki3 pkg[5316]: libX11-1.8.6,1 installed Jul 16 11:21:30 wiki3 pkg[5316]: glib-2.76.4,2 installed Jul 16 11:21:30 wiki3 pkg[5316]: jbigkit-2.1_1 installed Jul 16 11:21:31 wiki3 pkg[5316]: expat-2.5.0 installed Jul 16 11:21:31 wiki3 pkg[5316]: png-1.6.39 installed Jul 16 11:21:32 wiki3 pkg[5316]: dbus-1.14.6,1 installed Jul 16 11:21:33 wiki3 pkg[5316]: brotli-1.0.9,1 installed Jul 16 11:21:33 wiki3 pkg[5316]: gmp-6.2.1 installed Jul 16 11:21:34 wiki3 pkg[5316]: Imath-3.1.9 installed Jul 16 11:21:34 wiki3 pkg[5316]: libtasn1-4.19.0 installed Jul 16 11:21:36 wiki3 pkg[5316]: tiff-4.4.0_1 installed Jul 16 11:21:37 wiki3 pkg[5316]: shared-mime-info-2.2_1 installed Jul 16 11:21:38 wiki3 pkg[5316]: freetype2-2.12.1_2 installed Jul 16 11:21:39 wiki3 pkg[5316]: highway-1.0.4_1 installed Jul 16 11:21:40 wiki3 pkg[5316]: nettle-3.9.1 installed Jul 16 11:21:41 wiki3 pkg[5316]: p11-kit-0.24.1_2 installed Jul 16 11:21:41 wiki3 pkg[5316]: dbus-glib-0.112 installed Jul 16 11:21:41 wiki3 pkg[5316]: gnome_subr-1.0 installed Jul 16 11:21:43 wiki3 pkg[5316]: gdk-pixbuf2-2.42.10 installed Jul 16 11:21:43 wiki3 pkg[5316]: giflib-5.2.1 installed Jul 16 11:21:45 wiki3 pkg[5316]: openexr-3.1.9 installed Jul 16 11:21:46 wiki3 pkg[5316]: libdaemon-0.14_1 installed Jul 16 11:21:46 wiki3 pkg[5316]: gdbm-1.23 installed Jul 16 11:21:47 wiki3 pkg[5316]: avahi-app-0.8_1 installed Jul 16 11:21:48 wiki3 pkg[5316]: lcms2-2.15_1 installed Jul 16 11:21:49 wiki3 pkg[5316]: vmaf-2.3.1 installed Jul 16 11:21:50 wiki3 pkg[5316]: fontconfig-2.14.2,1 installed Jul 16 11:21:57 wiki3 pkg[5316]: gnutls-3.7.9 installed Jul 16 11:22:01 wiki3 pkg[5316]: libjxl-0.8.2 installed Jul 16 11:22:02 wiki3 pkg[5316]: webp-1.3.0_1 installed Jul 16 11:22:04 wiki3 pkg[5316]: x265-3.4_2 installed Jul 16 11:22:08 wiki3 pkg[5316]: cups-2.4.6 installed Jul 16 11:22:08 wiki3 pkg[5316]: libde265-1.0.12 installed Jul 16 11:22:09 wiki3 pkg[5316]: svt-av1-1.6.0 installed Jul 16 11:22:10 wiki3 pkg[5316]: libidn-1.38 installed Jul 16 11:22:10 wiki3 pkg[5316]: openjpeg-2.5.0 installed Jul 16 11:22:10 wiki3 pkg[5316]: jbig2dec-0.19 installed Jul 16 11:22:13 wiki3 pkg[5316]: aom-3.6.1 installed Jul 16 11:22:13 wiki3 pkg[5316]: libgd-2.3.3_5,1 installed Jul 16 11:22:13 wiki3 pkg[5316]: dav1d-1.2.1 installed Jul 16 11:22:16 wiki3 pkg[5316]: poppler-data-0.4.12 installed Jul 16 11:22:17 wiki3 pkg[5316]: libzip-1.10.0 installed Jul 16 11:22:17 wiki3 pkg[5316]: liblqr-1-0.4.2 installed Jul 16 11:22:17 wiki3 pkg[5316]: libltdl-2.4.7 installed Jul 16 11:22:20 wiki3 pkg[5316]: libwmf-nox11-0.2.13 installed Jul 16 11:22:21 wiki3 pkg[5316]: fftw3-3.3.10_3 installed Jul 16 11:22:21 wiki3 pkg[5316]: libheif-1.16.1 installed Jul 16 11:22:28 wiki3 pkg[5316]: ghostscript9-agpl-base-9.56.1_11 installed Jul 16 11:22:29 wiki3 pkg[5316]: libraw-0.21.1_1 installed Jul 16 11:22:29 wiki3 pkg[5316]: pkgconf-1.8.1,1 installed Jul 16 11:22:31 wiki3 pkg[5316]: gsfonts-8.11_8 installed Jul 16 11:22:38 wiki3 pkg[5316]: ImageMagick7-nox11-7.1.0.62_5 installed
2023-07-15: vtbd0p2 - mediawiki - I ran the upgrade script now MW is at 1.40.0. All that remians is to copy over media (images etc), and add imagemagick for image conversion.
2023-07-15: vtbd0p2 - pkg - delete mediawiki135-php82, install mediawiki140-php82
Jul 15 23:42:47 wiki3 pkg[3811]: mediawiki135-php82-1.35.11 deinstalled Jul 15 23:46:21 wiki3 pkg[3813]: mediawiki140-php82-1.40.0 installed
2023-07-15: vtbd0p2 - mysql - make a backup of the database before the next upgrade step
tingo@wiki3:~/work/mediawiki/2023/0715_mw_upgrade $ mysqldump -u wikiuser -p --no-tablespaces wikidb > wikidb_mw_1.35.sql Enter password: Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events. Warning: A dump from a server that has GTIDs enabled will by default include the GTIDs of all transactions, even those that were executed during its extraction and might not be represented in the dumped data. This might result in an inconsistent data dump. In order to ensure a consistent backup of the database, pass --single-transaction or --lock-all-tables or --master-data.
2023-07-15: vtbd0p2 - mediawiki - I ran the upgrade script (after disabling extensions CharInsert and MyVariables) it worked. MediaWiki 1.35 is not totally compatible with php 8.x; there are warning messages all over the web page. But it worked at least.
2023-07-15: vtbd0p2 - mysql - import dump from wiki2 machine (mysql 5.7). Because of errors when importing as the wiki (mysql) user, I imported as root. Seems to work.
2023-07-15: vtbd0p2 - configure nginx, then enable it
root@wiki3:~ # sysrc nginx_enable="YES" nginx_enable: -> YES
start it
root@wiki3:~ # service nginx status nginx is not running. root@wiki3:~ # service nginx start Performing sanity check on nginx configuration: nginx: the configuration file /usr/local/etc/nginx/nginx.conf syntax is ok nginx: configuration file /usr/local/etc/nginx/nginx.conf test is successful Starting nginx. root@wiki3:~ # service nginx status nginx is running as pid 3086.
2023-07-15: vtbd0p2 - enable php_fpm
root@wiki3:~ # sysrc php_fpm_enable="YES" php_fpm_enable: -> YES
and start it
root@wiki3:~ # service php-fpm status php_fpm is not running. root@wiki3:~ # service php-fpm start Performing sanity check on php-fpm configuration: [15-Jul-2023 16:45:45] NOTICE: configuration file /usr/local/etc/php-fpm.conf test is successful Starting php_fpm. root@wiki3:~ # service php-fpm status php_fpm is running as pid 2927.
I changed php-fpm configuration to listen on a unix socket instead of tcp
root@wiki3:~ # grep ^listen /usr/local/etc/php-fpm.d/www.conf listen = /var/run/php-fpm.sock; listen.owner = www listen.group = www listen.mode = 0660
and restarted the service.
2023-07-15: vtbd0p2 - mysql - setup and configure
root@wiki3:~ # sysrc mysql_enable="YES" mysql_enable: -> YES
start the server
root@wiki3:~ # service mysql-server status mysql is not running. root@wiki3:~ # service mysql-server start Starting mysql. root@wiki3:~ # service mysql-server status mysql is running as pid 2809.
I connectesd to mysql via mysql -u root --skip-password then I used
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password';
to set a new password. run the script to secure the installation.
root@wiki3:~ # mysql_secure_installation [..] Securing the MySQL server deployment. Enter password for user root: VALIDATE PASSWORD COMPONENT can be used to test passwords and improve security. It checks the strength of password and allows the users to set only those passwords which are secure enough. Would you like to setup VALIDATE PASSWORD component? Press y|Y for Yes, any other key for No: n Using existing password for root. Change the password for root ? ((Press y|Y for Yes, any other key for No) : n ... skipping. By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL 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? (Press y|Y for Yes, any other key for No) : 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? (Press y|Y for Yes, any other key for No) : y Success. By default, MySQL 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? (Press y|Y for Yes, any other key for No) : 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? (Press y|Y for Yes, any other key for No) : y Success. All done!
2023-07-15: vtbd0p2 - pkg - install nginx-lite, mysql80-server,
Jul 15 16:00:20 wiki3 pkg[1502]: nginx-lite-1.24.0,3 installed Jul 15 16:03:54 wiki3 pkg[1523]: mysql80-server-8.0.32_3 installed
messages
Message from mysql80-server-8.0.32_3:
--
There is no initial password for first time use of MySQL.
Keep in mind to reset it to a secure password.
MySQL80 has a default /usr/local/etc/mysql/my.cnf,
remember to replace it with your own
or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.
2023-07-15: vtbd0p2 - pkg - install mediawiki135 with php8.2 - message
Message from mediawiki135-php82-1.35.11: -- Remember to check /usr/local/www/mediawiki/INSTALL and /usr/local/www/mediawiki/UPGRADE for details
packages
Jul 15 14:59:07 wiki3 pkg[1027]: libunistring-1.1 installed Jul 15 14:59:07 wiki3 pkg[1027]: libcjson-1.7.15_1 installed Jul 15 14:59:08 wiki3 pkg[1027]: libxml2-2.10.4 installed Jul 15 14:59:09 wiki3 pkg[1027]: libidn2-2.3.4 installed Jul 15 14:59:09 wiki3 pkg[1027]: libpaper-1.1.28 installed Jul 15 14:59:09 wiki3 pkg[1027]: libargon2-20190702 installed Jul 15 14:59:11 wiki3 pkg[1027]: pcre2-10.42 installed Jul 15 14:59:13 wiki3 pkg[1027]: cyrus-sasl-2.1.28 installed Jul 15 14:59:13 wiki3 pkg[1027]: libnghttp2-1.53.0 installed Jul 15 14:59:13 wiki3 pkg[1027]: psutils-1.17_5 installed Jul 15 14:59:13 wiki3 pkg[1027]: liblz4-1.9.4,1 installed Jul 15 14:59:22 wiki3 pkg[1027]: php82-8.2.7 installed Jul 15 14:59:57 wiki3 pkg[1027]: perl5-5.32.1_3 installed Jul 15 14:59:58 wiki3 pkg[1027]: libssh2-1.11.0,3 installed Jul 15 14:59:58 wiki3 pkg[1027]: libpsl-0.21.2_3 installed Jul 15 14:59:59 wiki3 pkg[1027]: libiconv-1.17 installed Jul 15 14:59:59 wiki3 pkg[1027]: libcbor-0.10.2 installed Jul 15 14:59:59 wiki3 pkg[1027]: ca_root_nss-3.89.1 installed Jul 15 14:59:59 wiki3 pkg[1027]: uchardet-0.0.8 installed Jul 15 15:00:00 wiki3 pkg[1027]: libedit-3.1.20221030,1 installed Jul 15 15:00:13 wiki3 pkg[1027]: icu-73.2,1 installed Jul 15 15:00:14 wiki3 pkg[1027]: openldap26-client-2.6.4 installed Jul 15 15:00:18 wiki3 pkg[1027]: groff-1.22.4_4 installed Jul 15 15:00:18 wiki3 pkg[1027]: hidapi-0.14.0 installed Jul 15 15:00:19 wiki3 pkg[1027]: libunwind-20211201_2 installed Jul 15 15:00:19 wiki3 pkg[1027]: zstd-1.5.5 installed Jul 15 15:00:20 wiki3 pkg[1027]: oniguruma-6.9.8_1 installed Jul 15 15:00:20 wiki3 pkg[1027]: php82-dom-8.2.7 installed Jul 15 15:00:24 wiki3 pkg[1027]: curl-8.1.2 installed Jul 15 15:00:25 wiki3 pkg[1027]: libfido2-1.13.0 installed Jul 15 15:00:25 wiki3 pkg[1027]: libevent-2.1.12 installed Jul 15 15:00:25 wiki3 pkg[1027]: php82-session-8.2.7 installed Jul 15 15:00:26 wiki3 pkg[1027]: php82-readline-8.2.7 installed Jul 15 15:00:26 wiki3 pkg[1027]: php82-mysqli-8.2.7 installed Jul 15 15:00:27 wiki3 pkg[1027]: php82-mbstring-8.2.7 installed Jul 15 15:00:27 wiki3 pkg[1027]: php82-sockets-8.2.7 installed Jul 15 15:00:27 wiki3 pkg[1027]: php82-xmlreader-8.2.7 installed Jul 15 15:00:27 wiki3 pkg[1027]: php82-ctype-8.2.7 installed Jul 15 15:00:27 wiki3 pkg[1027]: php82-zlib-8.2.7 installed Jul 15 15:00:27 wiki3 pkg[1027]: php82-xml-8.2.7 installed Jul 15 15:00:33 wiki3 pkg[1027]: mysql80-client-8.0.32_3 installed Jul 15 15:00:33 wiki3 pkg[1027]: php82-fileinfo-8.2.7 installed Jul 15 15:00:33 wiki3 pkg[1027]: php82-iconv-8.2.7 installed Jul 15 15:00:33 wiki3 pkg[1027]: php82-intl-8.2.7 installed Jul 15 15:00:33 wiki3 pkg[1027]: php82-filter-8.2.7 installed Jul 15 15:02:40 wiki3 pkg[1027]: mediawiki135-php82-1.35.11 installed
2023-07-15: vtbd0p2 - pkg - see which mediawiki packages are available
root@wiki3:~ # pkg search mediawiki libmediawiki-5.38.0 KDE library for accessing MediaWiki sites mediawiki135-php80-1.35.11 Wiki engine used by Wikipedia mediawiki135-php81-1.35.11 Wiki engine used by Wikipedia mediawiki135-php82-1.35.11 Wiki engine used by Wikipedia mediawiki135-php83-1.35.11 Wiki engine used by Wikipedia mediawiki138-php80-1.38.7 Wiki engine used by Wikipedia mediawiki138-php81-1.38.7 Wiki engine used by Wikipedia mediawiki138-php82-1.38.7 Wiki engine used by Wikipedia mediawiki138-php83-1.38.7 Wiki engine used by Wikipedia mediawiki139-php80-1.39.4 Wiki engine used by Wikipedia mediawiki139-php81-1.39.4 Wiki engine used by Wikipedia mediawiki139-php82-1.39.4 Wiki engine used by Wikipedia mediawiki139-php83-1.39.4 Wiki engine used by Wikipedia mediawiki140-php80-1.40.0 Wiki engine used by Wikipedia mediawiki140-php81-1.40.0 Wiki engine used by Wikipedia mediawiki140-php82-1.40.0 Wiki engine used by Wikipedia mediawiki140-php83-1.40.0 Wiki engine used by Wikipedia p5-HTML-WikiConverter-MediaWiki-0.59_1 Convert HTML to MediaWiki markup p5-MediaWiki-1.13_1 OOP MediaWiki engine client p5-MediaWiki-API-0.52 OOP MediaWiki engine client p5-WWW-Mediawiki-Client-0.31_4 Very simple cvs-like interface for Mediawiki websites
ok, so php 8 only.
2023-07-15: vtbd0p2 - pkg - check which repository is in use
root@wiki3:~ # pkg -vv | grep url url : "pkg+http://pkg.FreeBSD.org/FreeBSD:13:amd64/quarterly",
2023-07-15: c2 - bootstrap ansible onto this machie from c2
tingo@kg-core2:/zs/tingo/personal/projects/2020/ansible_fbsd/infrastructure_home $ ansible-playbook --become-method su --ask-become-pass fbsd-bootstrap.yml -l wiki3 BECOME password: [..] PLAY [all] ***************************************************************************************************************************************** TASK [pkg bootstrap] ******************************************************************************************************************************* changed: [wiki3] TASK [pkg update] ********************************************************************************************************************************** changed: [wiki3] TASK [install python and sudo] ********************************************************************************************************************* changed: [wiki3] TASK [set up wheel group to have passwordless sudo] ************************************************************************************************ changed: [wiki3] PLAY RECAP ***************************************************************************************************************************************** wiki3 : ok=4 changed=4 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0
and now it is in the os report too
tingo@kg-core2:/zs/tingo/personal/projects/2020/ansible_fbsd/infrastructure_home $ column -s, -t < os.csv hostname system distribution version release kg-vm2 FreeBSD FreeBSD 12.4 12.4-RELEASE-p1 kg-omni1 FreeBSD FreeBSD 11.4 11.4-RELEASE-p9 kg-v7 FreeBSD FreeBSD 11.4 11.4-STABLE proxy FreeBSD FreeBSD 11.4 11.4-RELEASE bvm6 FreeBSD FreeBSD 11.1 11.1-RELEASE-p4 wiki2 FreeBSD FreeBSD 11.4 11.4-RELEASE-p9 kg-vm3 FreeBSD FreeBSD 13.2 13.2-RELEASE-p1 wiki3 FreeBSD FreeBSD 13.2 13.2-RELEASE-p1 kg-bpi Linux Debian 12.0 bookworm kg-vm4 Linux Debian 12.0 bookworm hdmipi FreeBSD FreeBSD 13.0 13.0-RELEASE kg-f6 FreeBSD FreeBSD 11.1 11.1-STABLE rtl433 Linux Debian 10 buster www FreeBSD FreeBSD 13.1 13.1-RELEASE-p1 web2 FreeBSD FreeBSD 11.4 11.4-RELEASE-p9 kg-core1 FreeBSD FreeBSD 13.2 13.2-RELEASE-p1 kg-core2 FreeBSD FreeBSD 13.1 13.1-RELEASE-p6
2023-07-15: vtbd0p2 - reboot, FreeBSD 13.2-release-p1 is in
root@wiki3:~ # freebsd-version -ku 13.2-RELEASE-p1 13.2-RELEASE-p1
kernel
root@wiki3:~ # uname -a FreeBSD wiki3.kg4.no 13.2-RELEASE-p1 FreeBSD 13.2-RELEASE-p1 GENERIC amd64
2023-07-15: vtbd0p2 - freebsd-update fetch
root@wiki3:~ # freebsd-update fetch src component not installed, skipped Looking up update.FreeBSD.org mirrors... 2 mirrors found. Fetching public key from update2.freebsd.org... done. Fetching metadata signature for 13.2-RELEASE from update2.freebsd.org... done. Fetching metadata index... done. Fetching 2 metadata files... done. Inspecting system... done. Preparing to download files... done. Fetching 15 patches.....10.. done. Applying patches... done. The following files will be updated as part of updating to 13.2-RELEASE-p1: /bin/freebsd-version /boot/kernel/kernel /boot/kernel/mpr.ko /boot/loader /boot/loader.efi /boot/loader_4th /boot/loader_4th.efi /boot/loader_lua /boot/loader_lua.efi /boot/loader_simp /boot/loader_simp.efi /boot/pxeboot /boot/zfsloader /usr/lib/libpam.a /usr/lib/pam_krb5.so.6 /usr/lib32/libpam.a /usr/lib32/pam_krb5.so.6 /usr/share/man/man8/pam_krb5.8.gz
install
root@wiki3:~ # freebsd-update install src component not installed, skipped Installing updates... Restarting sshd after upgrade Performing sanity check on sshd configuration. Stopping sshd. Waiting for PIDS: 710. Performing sanity check on sshd configuration. Starting sshd. Scanning //usr/share/certs/blacklisted for certificates... Scanning //usr/share/certs/trusted for certificates... done.
2023-07-15: I created this page.
2023-07-15: vm3 - the wiki3 machine was created and FreeBSD 13.2-release installed on it.