wiki2 - new wiki machine
guest os: FreeBSD / amd64
cpu: 2
memory size: 1408 MB (was: 1024 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
This machine was originally named bhyve_bvm7.
Work log
2023-07-16: vtbd0p2 - tar up the images
root@wiki2# tar cvf /home/tingo/work/2023/0716_mediawiki_images/images.tar.gz --exclude README * [..]
2023-07-15: vtbd0p2 - mysqldump, backup the mediawki database
$ mysqldump -h localhost -u wikiuser -p --default-character-set=binary wikidb > wikidb.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. mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
try with '--no-tablespaces'
$ mysqldump -h localhost -u wikiuser -p --no-tablespaces --default-character-set=binary wikidb > wikidb.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.
better. Do a XML dump as well
$ mysqldump -h localhost -u wikiuser -p --no-tablespaces --default-character-set=binary --xml wikidb > wikidb.xml 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.
check the dumps.
2021-04-29: wiki2 - increase memory from 1024 to 1408 MB (add 384 = 128 + 256). do this on the host
root@kg-vm3# pwd /zs/vms root@kg-vm3# grep memory wiki2/wiki2.conf memory="1408M"
then reboot the machine, and check
root@wiki2# dmesg | grep memory real memory = 1073741824 (1024 MB) avail memory = 995299328 (949 MB)
ah, of course a reboot isn't enough, I need to stop and start the vm. From the host
root@kg-vm3# vm stop wiki2 Sending ACPI shutdown to wiki2
then wait until 'vm list' shows it stopped, and do
root@kg-vm3# vm start wiki2 Starting wiki2 * found guest in /zs/vms/wiki2 * booting...
and then check
root@wiki2# dmesg | grep memory real memory = 1476395008 (1408 MB) avail memory = 1385697280 (1321 MB)
good.
2021-04-25: wiki2 - vtbd0p2 - this shows
root@wiki2# convert -list delegate | grep 'svg =' svg => "rsvg-convert' -o '%o' '%i"
and rsvg-convert exists
root@wiki2# which rsvg-convert /usr/local/bin/rsvg-convert root@wiki2# rsvg-convert --version rsvg-convert version 2.40.21
still mediawiki complains when I upload SVGs, that it can't create thumbnails. Hm.
2021-04-25: wiki2 - vtbd0p2 - reboot, FreeBSD 11.4-release-p9 is in
root@wiki2# freebsd-version -ku 11.4-RELEASE-p9 11.4-RELEASE-p9
kernel
root@wiki2# uname -a FreeBSD wiki2.kg4.no 11.4-RELEASE-p9 FreeBSD 11.4-RELEASE-p9 #0: Tue Apr 6 09:27:45 UTC 2021 root@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC amd64
ok
2021-04-25: wiki2 - vtbd0p2 - freebsd-update upgrade to 11.4-release
root@wiki2# freebsd-update -r 11.4-RELEASE upgrade [..] The following components of FreeBSD seem to be installed: kernel/generic world/base The following components of FreeBSD do not seem to be installed: kernel/generic-dbg world/base-dbg world/doc world/lib32 world/lib32-dbg Does this look reasonable (y/n)? y [..] The following files will be removed as part of updating to 11.4-RELEASE-p9: The following files will be added as part of updating to 11.4-RELEASE-p9: The following files will be updated as part of updating to 11.4-RELEASE-p9: [..] /var/yp/Makefile.dist To install the downloaded upgrades, run "/usr/sbin/freebsd-update install".
install
root@wiki2# freebsd-update install src component not installed, skipped Installing updates... Kernel updates have been installed. Please reboot and run "/usr/sbin/freebsd-update install" again to finish installing updates.
reboot, then
root@wiki2# freebsd-update install src component not installed, skipped Installing updates... done.
ok.
2021-04-25: wiki2 - vtbd0p2 - rsvg-convert still doesn't work
root@wiki2# rsvg-convert --help /lib/libc.so.7: version FBSD_1.6 required by /usr/local/lib/libepoll-shim.so.0 not found
ok
2021-04-25: wiki2 - vtbd0p2 - reboot, FreeBSD 11.3-release-p14 installed
root@wiki2# freebsd-version -ku 11.3-RELEASE-p13 11.3-RELEASE-p14
kernel
root@wiki2# uname -a FreeBSD wiki2.kg4.no 11.3-RELEASE-p13 FreeBSD 11.3-RELEASE-p13 #0: Tue Sep 1 06:56:51 UTC 2020 root@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC amd64
ok
2021-04-25: wiki2 - vtbd0p2 - freebsd-update
root@wiki2# freebsd-update fetch [..] The following files will be removed as part of updating to 11.3-RELEASE-p14: [..] The following files will be added as part of updating to 11.3-RELEASE-p14: [..] The following files will be updated as part of updating to 11.3-RELEASE-p14: [..] /var/db/mergemaster.mtree WARNING: FreeBSD 11.3-RELEASE-p7 HAS PASSED ITS END-OF-LIFE DATE. Any security issues discovered after Wed Sep 30 02:00:00 CEST 2020 will not have been corrected.
install
root@wiki2# freebsd-update install src component not installed, skipped Installing updates...install: ///usr/lib/debug/usr/sbin/local-unbound-anchor.debug: No such file or directory install: ///usr/lib/debug/usr/sbin/local-unbound-checkconf.debug: No such file or directory install: ///usr/lib/debug/usr/sbin/local-unbound-control.debug: No such file or directory install: ///usr/lib/debug/usr/sbin/local-unbound.debug: No such file or directory done.
ok
2021-04-25: wiki2 - vtbd0p2 - pkg - upgrade
Apr 25 20:56:33 wiki2 pkg: xorgproto upgraded: 2019.2 -> 2020.1 Apr 25 20:56:34 wiki2 pkg: libxml2 upgraded: 2.9.10 -> 2.9.10_3 Apr 25 20:56:34 wiki2 pkg: readline upgraded: 8.0.4 -> 8.1.0 Apr 25 20:56:50 wiki2 pkg: libxcb upgraded: 1.13.1 -> 1.14_1 Apr 25 20:56:51 wiki2 pkg: gettext-runtime upgraded: 0.20.1 -> 0.21 Apr 25 20:57:43 wiki2 pkg: python37 upgraded: 3.7.7 -> 3.7.10 Apr 25 20:57:45 wiki2 pkg: pcre upgraded: 8.43_2 -> 8.44 Apr 25 20:57:46 wiki2 pkg: libiconv upgraded: 1.14_11 -> 1.16 Apr 25 20:57:52 wiki2 pkg: libX11 upgraded: 1.6.9,1 -> 1.6.12,1 Apr 25 20:57:53 wiki2 pkg: gmp upgraded: 6.2.0 -> 6.2.1 Apr 25 20:57:53 wiki2 pkg: expat upgraded: 2.2.8 -> 2.2.10 Apr 25 20:57:54 wiki2 pkg: png upgraded: 1.6.37 -> 1.6.37_1 Apr 25 20:57:54 wiki2 pkg: libtasn1 upgraded: 4.15.0 -> 4.16.0_1 Apr 25 20:57:55 wiki2 pkg: jpeg-turbo upgraded: 2.0.4 -> 2.0.6 Apr 25 20:58:00 wiki2 pkg: glib upgraded: 2.56.3_7,1 -> 2.66.7_1,1 Apr 25 20:58:01 wiki2 pkg: dbus upgraded: 1.12.16 -> 1.12.20_3 Apr 25 20:58:01 wiki2 pkg: ca_root_nss upgraded: 3.51.1 -> 3.63 Apr 25 20:58:05 wiki2 pkg: trousers upgraded: 0.3.14_2 -> 0.3.14_3 Apr 25 20:58:07 wiki2 pkg: tiff upgraded: 4.1.0 -> 4.2.0 Apr 25 20:58:09 wiki2 pkg: pcre2 upgraded: 10.34 -> 10.36 Apr 25 20:58:10 wiki2 pkg: p11-kit upgraded: 0.23.18.1 -> 0.23.22_1 Apr 25 20:58:12 wiki2 pkg: nettle upgraded: 3.5.1_1 -> 3.7.2_1 Apr 25 20:58:12 wiki2 pkg: libevent upgraded: 2.1.11 -> 2.1.12 Apr 25 20:58:15 wiki2 pkg: gobject-introspection upgraded: 1.56.1,1 -> 1.66.1,1 Apr 25 20:58:15 wiki2 pkg: gdbm upgraded: 1.18.1_1 -> 1.19 Apr 25 20:58:17 wiki2 pkg: freetype2 upgraded: 2.10.1 -> 2.10.4 Apr 25 20:58:17 wiki2 pkg: webp upgraded: 1.1.0 -> 1.2.0 Apr 25 20:58:21 wiki2 pkg: php74 upgraded: 7.4.4 -> 7.4.16 Apr 25 20:58:22 wiki2 pkg: libnghttp2 upgraded: 1.40.0 -> 1.43.0 Apr 25 20:58:30 wiki2 pkg: gnutls upgraded: 3.6.13 -> 3.6.15 Apr 25 20:58:31 wiki2 pkg: fontconfig upgraded: 2.13.92_1,1 -> 2.13.93,1 Apr 25 20:58:32 wiki2 pkg: avahi-app upgraded: 0.7_3 -> 0.8 Apr 25 20:58:37 wiki2 pkg: protobuf upgraded: 3.11.4,1 -> 3.14.0,1 Apr 25 20:58:40 wiki2 pkg: poppler-data upgraded: 0.4.9_2 -> 0.4.10 Apr 25 20:58:40 wiki2 pkg: php74-dom upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:16 wiki2 pkg: perl5 upgraded: 5.30.2 -> 5.32.1_1 Apr 25 20:59:17 wiki2 pkg: oniguruma upgraded: 6.9.4 -> 6.9.6 Apr 25 20:59:17 wiki2 pkg: liblz4 upgraded: 1.9.2_1,1 -> 1.9.3,1 Apr 25 20:59:18 wiki2 pkg: libedit upgraded: 3.1.20191211,1 -> 3.1.20210216,1 Apr 25 20:59:18 wiki2 pkg: lcms2 upgraded: 2.9 -> 2.12 Apr 25 20:59:19 wiki2 pkg: jbig2dec upgraded: 0.18 -> 0.19 Apr 25 20:59:25 wiki2 pkg: icu upgraded: 66.1,1 -> 68.2,1 Apr 25 20:59:29 wiki2 pkg: curl upgraded: 7.69.1 -> 7.76.0 Apr 25 20:59:35 wiki2 pkg: cups upgraded: 2.2.13 -> 2.3.3op2 Apr 25 20:59:35 wiki2 pkg: libgd-2.3.1,1 installed Apr 25 20:59:35 wiki2 pkg: jansson-2.13.1 installed Apr 25 20:59:36 wiki2 pkg: pkgconf upgraded: 1.6.3,1 -> 1.7.4,1 Apr 25 20:59:38 wiki2 pkg: php74-zlib upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:38 wiki2 pkg: php74-xmlreader upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:38 wiki2 pkg: php74-xml upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:38 wiki2 pkg: php74-sockets upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:38 wiki2 pkg: php74-session upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:38 wiki2 pkg: php74-readline upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:39 wiki2 pkg: php74-openssl upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:39 wiki2 pkg: php74-mysqli upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:40 wiki2 pkg: php74-mbstring upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:40 wiki2 pkg: php74-json upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:40 wiki2 pkg: php74-intl upgraded: 7.4.4_1 -> 7.4.16 Apr 25 20:59:41 wiki2 pkg: php74-iconv upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:41 wiki2 pkg: php74-fileinfo upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:41 wiki2 pkg: php74-ctype upgraded: 7.4.4 -> 7.4.16 Apr 25 20:59:41 wiki2 pkg: openjpeg upgraded: 2.3.1 -> 2.4.0 Apr 25 20:59:45 wiki2 pkg: mysql57-client upgraded: 5.7.29_1 -> 5.7.33 Apr 25 20:59:47 wiki2 pkg: libwmf-nox11 upgraded: 0.2.8.4_15 -> 0.2.12 Apr 25 20:59:48 wiki2 pkg: libraw upgraded: 0.19.5 -> 0.20.2 Apr 25 20:59:55 wiki2 pkg: ghostscript9-agpl-base upgraded: 9.52_1 -> 9.52_15 Apr 25 20:59:55 wiki2 pkg: fftw3 upgraded: 3.3.8_5 -> 3.3.9 Apr 25 21:00:11 wiki2 pkg: apache24 upgraded: 2.4.43 -> 2.4.46_2 Apr 25 21:00:20 wiki2 pkg: mysql57-server upgraded: 5.7.29_1 -> 5.7.33 Apr 25 21:00:21 wiki2 pkg: mod_php74 upgraded: 7.4.4 -> 7.4.16 Apr 25 21:02:02 wiki2 pkg: mediawiki131-php74 upgraded: 1.31.7 -> 1.31.10 Apr 25 21:02:22 wiki2 pkg: ImageMagick7-nox11 upgraded: 7.0.9.20 -> 7.0.10.24_2
ok
2021-04-25: wiki2 - vtbd0p2 - pkg - install librsvg2-rust to get rsvg-convert, which is used by ImageMagick's convert for SVG images.
Apr 25 20:36:32 wiki2 pkg: pciids-20210223 installed Apr 25 20:36:32 wiki2 pkg: libXrender-0.9.10_2 installed Apr 25 20:36:33 wiki2 pkg: libffi upgraded: 3.2.1_3 -> 3.3_1 Apr 25 20:36:33 wiki2 pkg: libfontenc-1.1.4 installed Apr 25 20:36:33 wiki2 pkg: libXext-1.3.4,1 installed Apr 25 20:36:34 wiki2 pkg: libXfixes-5.0.3_2 installed Apr 25 20:36:34 wiki2 pkg: libepoll-shim-0.0.20210322 installed Apr 25 20:36:34 wiki2 pkg: libpciaccess-0.16 installed Apr 25 20:36:34 wiki2 pkg: mkfontscale-1.2.1 installed Apr 25 20:36:34 wiki2 pkg: libxshmfence-1.3 installed Apr 25 20:36:35 wiki2 pkg: libXxf86vm-1.1.4_3 installed Apr 25 20:36:35 wiki2 pkg: libXrandr-1.5.2 installed Apr 25 20:36:35 wiki2 pkg: libXdamage-1.1.5 installed Apr 25 20:36:35 wiki2 pkg: wayland-1.19.0 installed Apr 25 20:36:36 wiki2 pkg: libdrm-2.4.104,1 installed Apr 25 20:36:37 wiki2 pkg: libunwind-20201110 installed Apr 25 20:36:37 wiki2 pkg: zstd-1.4.8 installed Apr 25 20:36:40 wiki2 pkg: font-misc-meltho-1.0.3_4 installed Apr 25 20:36:44 wiki2 pkg: font-misc-ethiopic-1.0.4 installed Apr 25 20:36:47 wiki2 pkg: font-bh-ttf-1.0.3_4 installed Apr 25 20:36:47 wiki2 pkg: encodings-1.0.5,1 installed Apr 25 20:36:51 wiki2 pkg: dejavu-2.37_1 installed Apr 25 20:36:52 wiki2 pkg: graphite2-1.3.14 installed Apr 25 20:36:52 wiki2 pkg: pixman-0.40.0_1 installed Apr 25 20:36:53 wiki2 pkg: mesa-libs-20.2.3 installed Apr 25 20:36:53 wiki2 pkg: xorg-fonts-truetype-7.7_1 installed Apr 25 20:36:53 wiki2 pkg: libXft-2.3.3 installed Apr 25 20:36:54 wiki2 pkg: harfbuzz-2.8.0 installed Apr 25 20:36:56 wiki2 pkg: cairo-1.16.0_1,3 installed Apr 25 20:36:56 wiki2 pkg: fribidi-1.0.10 installed Apr 25 20:37:03 wiki2 pkg: shared-mime-info-2.0 installed Apr 25 20:37:04 wiki2 pkg: pango-1.42.4_5 installed Apr 25 20:37:12 wiki2 pkg: gdk-pixbuf2-2.40.0 installed Apr 25 20:37:15 wiki2 pkg: librsvg2-rust-2.50.3_2 installed Apr 25 20:37:15 wiki2 pkg: libffi321-3.2.1_2 installed
but it does not work:
root@wiki2# rsvg-convert --help /lib/libc.so.7: version FBSD_1.6 required by /usr/local/lib/libepoll-shim.so.0 not found
deinstall librsvg2-rust
Apr 25 20:46:03 wiki2 pkg: librsvg2-rust-2.50.3_2 deinstalled
install librsvg2 instead
Apr 25 20:46:22 wiki2 pkg: libcroco-0.6.13 installed Apr 25 20:46:23 wiki2 pkg: libgsf-1.14.47_1 installed Apr 25 20:46:24 wiki2 pkg: librsvg2-2.40.21 installed
but same problem
root@wiki2# rsvg-convert --help /lib/libc.so.7: version FBSD_1.6 required by /usr/local/lib/libepoll-shim.so.0 not found
oh, well.
2021-04-25: wiki2 - vtbd0p2 - pkg - upgrade pkg
Apr 25 20:30:58 wiki2 pkg: pkg upgraded: 1.13.2 -> 1.16.3
ok
2020-09-13: wiki2 - vtbd0p2 - upon restart of the vm (the host got upgraded and rebooted) mysql-server didn't start, and 'service mysql-server start' failed too. But /var/db/mysql/wiki2.kg4.no.err gave me a clue
root@wiki2# grep ERROR /var/db/mysql/wiki2.kg4.no.err 2020-09-13T10:14:14.779190Z 0 [ERROR] Unix socket lock file is empty /tmp/mysql.sock.lock. 2020-09-13T10:14:14.779259Z 0 [ERROR] Unable to setup unix socket lock file. 2020-09-13T10:14:14.779325Z 0 [ERROR] Aborting 2020-09-13T13:40:32.423181Z 0 [ERROR] Unix socket lock file is empty /tmp/mysql.sock.lock. 2020-09-13T13:40:32.423252Z 0 [ERROR] Unable to setup unix socket lock file. 2020-09-13T13:40:32.423319Z 0 [ERROR] Aborting
so I just removed the empty /tmp/mysql.sock file, and did a 'service mysql-server start' again. Good now
root@wiki2# service mysql-server status mysql is running as pid 4964.
ok
2020-06-21: bvm7 - I'm changing to vm-bhyve, and as part of the change the vm's get a better name. This one is 'wiki2' now
root@kg-vm3# pwd /zs/vms root@kg-vm3# mv bvm7 wiki2
add config file
root@kg-vm3# more wiki2/wiki.conf loader="bhyveload" cpu="2" memory="1024M" network0_type="virtio-net" network0_switch="public" disk0_type="virtio-blk" disk0_name="guest-bvm7.img"
and test the machine
eh - it helps if the file has the correct name
root@kg-vm3# mv wiki2/wiki.conf wiki2/wiki2.conf
now then - yes, it works. Here are the currently running vms on vm3 host
root@kg-vm3# vm list NAME DATASTORE LOADER CPU MEMORY VNC AUTOSTART STATE music3 default bhyveload 1 512M - No Running (11953) trap2 default bhyveload 1 256M - No Running (10299) tv default bhyveload 2 1536M - No Running (9278) web default bhyveload 2 1280M - No Running (12591) wiki default bhyveload 2 1024M - No Running (8672) wiki2 default bhyveload 2 1024M - No Running (13342)
ok.
2020-04-19: bvm7 - vtbd0p2 - mediawiki change $wgServer in LocalSettings.php
root@wiki2:~ # grep wgServer /usr/local/www/mediawiki/LocalSettings.php #$wgServer = "http://10.1.161.15"; $wgServer = "http://wiki2";
that's it.
2020-04-19: bvm7 - vtbd0p2 - fix dhclient.conf (and named and isc-dhcpd on the other side) so that the machine has wiki2 as a dns-resolvable name
root@wiki2:~ # grep send /etc/dhclient.conf send dhcp-client-identifier "wiki2.kg4.no";
and reboot the machine.
2020-04-19: bvm7 - vtbd0p2 - mediawiki "upgrade" procedure. 1) I created a new install using the wikitest database, copying php, apache and LocalSettings.php info from the old machine as required. Also added the CharInsert extension by downloading and installing it. 2) I tared up the contents of the images directory on the old server, and transferred to the new one, untaring in the images directory there. 3) I changed to the real database wikidb in LocalSettings.php and started the upgrade script.
2020-04-19: bvm7 - vtbd0p2 - mysql - create an empty database to use for an install first
root@localhost [mysql]> create database wikitest; Query OK, 1 row affected (0.02 sec) root@localhost [mysql]> GRANT ALL PRIVILEGES ON wikitest.* to wikiuser with grant option; Query OK, 0 rows affected (0.02 sec)
ok
2020-04-19: bvm7 - vtbd0p2 - pkg - install ImageMagick7-nox11
messages
Message from python37-3.7.7: -- Note that some standard Python modules are provided as separate ports as they require additional dependencies. They are available as: py37-gdbm databases/py-gdbm@py37 py37-sqlite3 databases/py-sqlite3@py37 py37-tkinter x11-toolkits/py-tkinter@py37 ===== Message from trousers-0.3.14_2: -- To run tcsd automatically, add the following line to /etc/rc.conf: tcsd_enable="YES" You might want to edit /usr/local/etc/tcsd.conf to reflect your setup. If you want to use tcsd with software TPM emulator, use the following configuration in /etc/rc.conf: tcsd_enable="YES" tcsd_mode="emulator" tpmd_enable="YES" To use TPM, add your_account to '_tss' group like following: # pw groupmod _tss -m your_account ===== Message from freetype2-2.10.1: -- The 2.7.x series now uses the new subpixel hinting mode (V40 port's option) as the default, emulating a modern version of ClearType. This change inevitably leads to different rendering results, and you might change port's options to adapt it to your taste (or use the new "FREETYPE_PROPERTIES" environment variable). The environment variable "FREETYPE_PROPERTIES" can be used to control the driver properties. Example: FREETYPE_PROPERTIES=truetype:interpreter-version=35 \ cff:no-stem-darkening=1 \ autofitter:warping=1 This allows to select, say, the subpixel hinting mode at runtime for a given application. If LONG_PCF_NAMES port's option was enabled, the PCF family names may include the foundry and information whether they contain wide characters. For example, "Sony Fixed" or "Misc Fixed Wide", instead of "Fixed". This can be disabled at run time with using pcf:no-long-family-names property, if needed. Example: FREETYPE_PROPERTIES=pcf:no-long-family-names=1 How to recreate fontconfig cache with using such environment variable, if needed: # env FREETYPE_PROPERTIES=pcf:no-long-family-names=1 fc-cache -fsv The controllable properties are listed in the section "Controlling FreeType Modules" in the reference's table of contents (/usr/local/share/doc/freetype2/reference/site/index.html, if documentation was installed). ===== Message from ghostscript9-agpl-base-9.52_1: -- This package installs a script named dvipdf that depends on dvips. If you want to use this script you need to install print/tex-dvipsk. ===== Message from liblqr-1-0.4.2: -- NOTE: In order to compile examples for liblqr, you will also need pngwriter port (/usr/ports/graphics/pngwriter). Examples are located in /usr/local/share/examples/liblqr-1
packages
Apr 19 16:55:59 wiki2 pkg: xorgproto-2019.2 installed Apr 19 16:55:59 wiki2 pkg: libXdmcp-1.1.3 installed Apr 19 16:55:59 wiki2 pkg: libXau-1.0.9 installed Apr 19 16:56:00 wiki2 pkg: libpthread-stubs-0.4 installed Apr 19 16:56:00 wiki2 pkg: libffi-3.2.1_3 installed Apr 19 16:56:14 wiki2 pkg: libxcb-1.13.1 installed Apr 19 16:56:14 wiki2 pkg: libICE-1.0.10,1 installed Apr 19 16:56:15 wiki2 pkg: gmp-6.2.0 installed Apr 19 16:57:05 wiki2 pkg: python37-3.7.7 installed Apr 19 16:57:12 wiki2 pkg: libX11-1.6.9,1 installed Apr 19 16:57:12 wiki2 pkg: libSM-1.2.3,1 installed Apr 19 16:57:13 wiki2 pkg: tpm-emulator-0.7.4_2 installed Apr 19 16:57:14 wiki2 pkg: libtasn1-4.15.0 installed Apr 19 16:57:15 wiki2 pkg: libunistring-0.9.10_1 installed Apr 19 16:57:20 wiki2 pkg: glib-2.56.3_7,1 installed Apr 19 16:57:21 wiki2 pkg: dbus-1.12.16 installed Apr 19 16:57:22 wiki2 pkg: trousers-0.3.14_2 installed Apr 19 16:57:23 wiki2 pkg: p11-kit-0.23.18.1 installed Apr 19 16:57:24 wiki2 pkg: nettle-3.5.1_1 installed Apr 19 16:57:25 wiki2 pkg: libidn2-2.3.0_1 installed Apr 19 16:57:25 wiki2 pkg: gnome_subr-1.0 installed Apr 19 16:57:25 wiki2 pkg: libdaemon-0.14_1 installed Apr 19 16:57:27 wiki2 pkg: gobject-introspection-1.56.1,1 installed Apr 19 16:57:28 wiki2 pkg: dbus-glib-0.110 installed Apr 19 16:57:29 wiki2 pkg: jpeg-turbo-2.0.4 installed Apr 19 16:57:29 wiki2 pkg: jbigkit-2.1_1 installed Apr 19 16:57:31 wiki2 pkg: freetype2-2.10.1 installed Apr 19 16:57:31 wiki2 pkg: libpaper-1.1.24.4 installed Apr 19 16:57:39 wiki2 pkg: gnutls-3.6.13 installed Apr 19 16:57:41 wiki2 pkg: avahi-app-0.7_3 installed Apr 19 16:57:44 wiki2 pkg: tiff-4.1.0 installed Apr 19 16:57:45 wiki2 pkg: png-1.6.37 installed Apr 19 16:57:46 wiki2 pkg: fontconfig-2.13.92_1,1 installed Apr 19 16:57:52 wiki2 pkg: cups-2.2.13 installed Apr 19 16:57:55 wiki2 pkg: poppler-data-0.4.9_2 installed Apr 19 16:57:55 wiki2 pkg: jbig2dec-0.18 installed Apr 19 16:57:56 wiki2 pkg: libidn-1.35 installed Apr 19 16:57:57 wiki2 pkg: giflib-5.2.1 installed Apr 19 16:57:59 wiki2 pkg: lcms2-2.9 installed Apr 19 16:58:01 wiki2 pkg: gsfonts-8.11_8 installed Apr 19 16:58:08 wiki2 pkg: ghostscript9-agpl-base-9.52_1 installed Apr 19 16:58:09 wiki2 pkg: fftw3-3.3.8_5 installed Apr 19 16:58:09 wiki2 pkg: webp-1.1.0 installed Apr 19 16:58:10 wiki2 pkg: openjpeg-2.3.1 installed Apr 19 16:58:12 wiki2 pkg: libwmf-nox11-0.2.8.4_15 installed Apr 19 16:58:13 wiki2 pkg: libraw-0.19.5 installed Apr 19 16:58:13 wiki2 pkg: liblqr-1-0.4.2 installed Apr 19 16:58:13 wiki2 pkg: pkgconf-1.6.3,1 installed Apr 19 16:58:14 wiki2 pkg: libltdl-2.4.6 installed Apr 19 16:58:26 wiki2 pkg: ImageMagick7-nox11-7.0.9.20 installed
ok
2020-04-19: bvm7 - vtbd0p2 - mysql - import data from the old database
$ mysql -u wikiuser -p wikidb < wikidb.sql Enter password:
and done.
2020-04-19: bvm7 - vtbd0p2 - mysql - create database for wiki
root@localhost [mysql]> create database wikidb; Query OK, 1 row affected (0.00 sec) root@localhost [mysql]> create user wikiuser identified by 'password'; Query OK, 0 rows affected (0.01 sec) root@localhost [mysql]> grant all on wikidb.* to wikiuser; Query OK, 0 rows affected (0.00 sec) root@localhost [mysql]>
(no, the password isn't 'password') 2020-04-19: bvm7 - vtbd0p2 - mysql - secure the server using the script provide for that.
2020-04-19: bvm7 - vtbd0p2 - add mysql_server and apache24 to /etc/rc.conf
# enable database engine mysql_enable="YES" # enable web server apache24_enable="YES"
ok
2020-04-19: bvm7 - vtbd0p2 - pkg - apache and mod_php74 is also needed
messages
Message from apr-1.7.0.1.6.1_1: -- The Apache Portable Runtime project removed support for FreeTDS with version 1.6. Users requiring MS-SQL connectivity must migrate configurations to use the added ODBC driver and FreeTDS' ODBC features. ===== Message from apache24-2.4.43: -- To run apache www server from startup, add apache24_enable="yes" in your /etc/rc.conf. Extra options can be found in startup script. Your hostname must be resolvable using at least 1 mechanism in /etc/nsswitch.conf typically DNS or /etc/hosts or apache might have issues starting depending on the modules you are using. - apache24 default build changed from static MPM to modular MPM - more modules are now enabled per default in the port - icons and error pages moved from WWWDIR to DATADIR If build with modular MPM and no MPM is activated in httpd.conf, then mpm_prefork will be activated as default MPM in etc/apache24/modules.d to keep compatibility with existing php/perl/python modules! Please compare the existing httpd.conf with httpd.conf.sample and merge missing modules/instructions into httpd.conf! ===== Message from mod_php74-7.4.4: -- ****************************************************************************** Make sure index.php is part of your DirectoryIndex. You should add the following to your Apache configuration file: <FilesMatch "\.php$"> SetHandler application/x-httpd-php </FilesMatch> <FilesMatch "\.phps$"> SetHandler application/x-httpd-php-source </FilesMatch> ****************************************************************************** If you are building PHP-based ports in poudriere(8) or Synth with ZTS enabled, add WITH_MPM=event to /etc/make.conf to prevent build failures. ******************************************************************************
packages
Apr 19 01:35:11 wiki2 pkg: gettext-runtime-0.20.1 installed Apr 19 01:35:12 wiki2 pkg: expat-2.2.8 installed Apr 19 01:35:12 wiki2 pkg: gdbm-1.18.1_1 installed Apr 19 01:35:28 wiki2 pkg: db5-5.3.28_7 installed Apr 19 01:35:30 wiki2 pkg: pcre-8.43_2 installed Apr 19 01:35:31 wiki2 pkg: apr-1.7.0.1.6.1_1 installed Apr 19 01:35:43 wiki2 pkg: apache24-2.4.43 installed Apr 19 01:35:44 wiki2 pkg: mod_php74-7.4.4 installed
ok
2020-04-19: bvm7 - vtbd0p2 - pkg - install mediawiki 1.31.x since it is a LTS release message from mediawiki
Message from mediawiki131-php74-1.31.7: -- Remember to check /usr/local/www/mediawiki/INSTALL and /usr/local/www/mediawiki/UPGRADE for details
packages
Apr 19 01:04:43 wiki2 pkg: libxml2-2.9.10 installed Apr 19 01:04:43 wiki2 pkg: libargon2-20190702 installed Apr 19 01:04:45 wiki2 pkg: pcre2-10.34 installed Apr 19 01:04:45 wiki2 pkg: indexinfo-0.3.1 installed Apr 19 01:04:45 wiki2 pkg: libnghttp2-1.40.0 installed Apr 19 01:04:46 wiki2 pkg: ca_root_nss-3.51.1 installed Apr 19 01:04:50 wiki2 pkg: php74-7.4.4 installed Apr 19 01:04:50 wiki2 pkg: readline-8.0.4 installed Apr 19 01:04:57 wiki2 pkg: icu-66.1,1 installed Apr 19 01:04:59 wiki2 pkg: cyrus-sasl-2.1.27_1 installed Apr 19 01:05:36 wiki2 pkg: perl5-5.30.2 installed Apr 19 01:05:40 wiki2 pkg: curl-7.69.1 installed Apr 19 01:05:43 wiki2 pkg: protobuf-3.11.4,1 installed Apr 19 01:05:44 wiki2 pkg: libevent-2.1.11 installed Apr 19 01:05:44 wiki2 pkg: libedit-3.1.20191211,1 installed Apr 19 01:05:45 wiki2 pkg: liblz4-1.9.2_1,1 installed Apr 19 01:05:45 wiki2 pkg: oniguruma-6.9.4 installed Apr 19 01:05:46 wiki2 pkg: libiconv-1.14_11 installed Apr 19 01:05:46 wiki2 pkg: php74-session-7.4.4 installed Apr 19 01:05:46 wiki2 pkg: php74-xmlreader-7.4.4 installed Apr 19 01:05:46 wiki2 pkg: php74-xml-7.4.4 installed Apr 19 01:05:46 wiki2 pkg: php74-dom-7.4.4 installed Apr 19 01:05:46 wiki2 pkg: php74-ctype-7.4.4 installed Apr 19 01:05:47 wiki2 pkg: php74-fileinfo-7.4.4 installed Apr 19 01:05:47 wiki2 pkg: php74-openssl-7.4.4 installed Apr 19 01:05:47 wiki2 pkg: php74-sockets-7.4.4 installed Apr 19 01:05:47 wiki2 pkg: php74-readline-7.4.4 installed Apr 19 01:05:47 wiki2 pkg: php74-json-7.4.4 installed Apr 19 01:05:47 wiki2 pkg: php74-intl-7.4.4_1 installed Apr 19 01:05:47 wiki2 pkg: php74-mysqli-7.4.4 installed Apr 19 01:05:50 wiki2 pkg: mysql57-client-5.7.29_1 installed Apr 19 01:05:52 wiki2 pkg: php74-mbstring-7.4.4 installed Apr 19 01:05:52 wiki2 pkg: php74-iconv-7.4.4 installed Apr 19 01:05:52 wiki2 pkg: php74-zlib-7.4.4 installed Apr 19 01:07:28 wiki2 pkg: mediawiki131-php74-1.31.7 installed
mysql57-server is also required message
Message from mysql57-server-5.7.29_1:
--
Initial password for first time use of MySQL is saved in $HOME/.mysql_secret
ie. when you want to use "mysql -u root -p" first you should see password
in /root/.mysql_secret
MySQL57 has a default %%ETCDIR%%/my.cnf,
remember to replace it wit your own
or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.
package
Apr 19 01:14:03 wiki2 pkg: mysql57-server-5.7.29_1 installed
ok
2020-04-19: bvm7 - vtbd0p2 - bootstrap pkg
Bootstrapping pkg from pkg+http://pkg.FreeBSD.org/FreeBSD:11:amd64/quarterly, please wait... Verifying signature with trusted certificate pkg.freebsd.org.2013102301... done Installing pkg-1.13.2... Extracting pkg-1.13.2: 100%
ok.
2020-04-18: bvm7 - vtbd0p2 - one reboot later
root@wiki2:~ # freebsd-version -ku 11.3-RELEASE-p7 11.3-RELEASE-p7
kernel
root@wiki2:~ # uname -a FreeBSD wiki2.kg4.no 11.3-RELEASE-p7 FreeBSD 11.3-RELEASE-p7 #0: Tue Mar 17 08:32:23 UTC 2020 root@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC amd64
ok
2020-04-18: bvm7 - vtbd0p2 - freebsd-update
fetch
root@wiki2:~ # freebsd-update fetch [..] The following files will be updated as part of updating to 11.3-RELEASE-p7: [..] /usr/share/zoneinfo/Pacific/Norfolk WARNING: FreeBSD 11.3-RELEASE is approaching its End-of-Life date. It is strongly recommended that you upgrade to a newer release within the next 2 months.
install
root@wiki2:~ # freebsd-update install src component not installed, skipped Installing updates... done.
ok
2020-04-18: vm3 - ada0p2 - set up a new machine bvm7 - 2 cpu, 1024M memory, 13G disk (use as new wiki)
config
root@kg-vm3# grep bvm7 /etc/rc.conf.local # bvm7 - wiki2 - new wiki bhyve_profiles="bvm1 bvm2 bvm3 bvm4 bvm5 bvm6 bvm7" bhyve_bvm7_tapdev="tap6" bhyve_bvm7_diskdev="/zs/vms/bvm7/guest-bvm7.img" bhyve_bvm7_ncpu="2" bhyve_bvm7_memsize="1024"
creation
root@kg-vm3# cd /zs/vms root@kg-vm3# mkdir bvm7 root@kg-vm3# truncate -s 13G bvm7/guest-bvm7.img create network interface and add to bridge root@kg-vm3# ifconfig tap6 create root@kg-vm3# sysctl net.link.tap.up_on_open net.link.tap.up_on_open: 1 root@kg-vm3# ifconfig bridge0 addm tap6
install
root@kg-vm3# sh /usr/share/examples/bhyve/vmrun.sh -c 2 -t tap6 -d /zs/vms/bvm7/guest-bvm7.img -i -I /zs/tingo/dl/bsd/FreeBSD-11.3-RELEASE-amd64-disc1.iso bhyve_bvm7
select xterm, unselect lib32, ports, Guided disk setup, entire disk,gpt, 11G root and 2G swap. Network configuration DHCP, services sshd, ntpd, dumpdev. On exit, it reboots, just select "reboot" from the boot menu.
start it
root@kg-vm3# service bhyve start bvm7 Starting bhyve.
check
root@kg-vm3# service bhyve status bvm7 bhyve_bvm7 is running.
connect via tmux
root@kg-vm3# tmux attach -t bhyve_bvm7
ok