Changes

This page describes the configuration of the two new research computing machines: '''Father''' (Windows Server 2019) and '''Mother''' (Ubuntu Server 20. This configuration runs on our [[Research Computing Hardware]]04). Note that the configuration of the [[DIGITS DevBoxRDP Software Configuration]] is describes the software installed on its own pageFather.

The hardware description and complete build notes and configuration information for '''Bastard''', our blisteringly fast, multi-GPU, A.I. estimation platform, are on the [[DIGITS DevBox]] page. The hardware descriptions for Father and Mother are on the [[Research Computing Hardware]] page. See also: [[Recovering Astarte]] for notes on moving content from an old mediawiki installation to a new one. ==Both machines(Father and Mother)==

==RDP Server(Father)==

==Dbase Server(Mother)==

#Note: change passwords from hints hint before running

UPDATE mysql.user SET Password = PASSWORD('tsnhint') WHERE User = 'root'; UPDATE mysql.user SET Password = PASSWORD('tsnhint') WHERE User = 'debian-sys-maint'; UPDATE mysql.user SET Password = PASSWORD('tsnhint') WHERE User = 'mcnair_wp';

===Mediawiki Redux=== ====Mobile Front End====

====Does php have mbstring support?====

====Check the skin====

===Upgrade mediawiki===

====Backup====

====New Install====

====Extensions==== =====Retrieve and configure include extensions=====

I tried various methods to get MathML to work and always failed. It looks like the community bet on Mathoid working out, but there's been no development on it for 5 months now, and it looks dead. The good news, if is that MathJax works just fine right out of the box:

#$wgSmjInlineMath = [ [ "$", "$" ], [ "\\(", "\\)" ] ]; Note: the last line lets you demark math with LaTeX-like syntax. I disabled it, as I use $ signs way too much in other contexts.

<nowiki>{{#set: Visible to=whitelist|Visible to group::=team}}</nowiki>

=====BibTeX=====

=====Upload Multiple Files===== Although the Upload multiple files extension installed fine, it is unmaintained and seems to have an issue. I removed its line from LocalSettings.php and deleted its extension directory. I then installed [https://www.mediawiki.org/wiki/Extension:SimpleBatchUpload Simple Batch Upload] using a tarball: in mediawiki/installs wget https://github.com/ProfessionalWiki/SimpleBatchUpload/archive/1.6.0.tar.gz tar -xzf 1.6.0.tar.gz -C /var/lib/mediawiki/extensions mv /var/lib/mediawiki/extensions/SimpleBatchUpload-1.6.0 /var/lib/mediawiki/extensions/SimpleBatchUpload In LocalSettings.php: wfLoadExtension( 'SimpleBatchUpload' ); $wgSimpleBatchUploadMaxFilesPerBatch = ['*' => 10,]; I had previously added Special:MultiUpload|Upload multiple files to http://www.edegan.com/wiki/MediaWiki:Sidebar. I replaced it with a link to [[Special:BatchUpload]]. =====Allow SVG images===== See https://www.mediawiki.org/wiki/Manual:Image_administration#SVG. Essentially, add svg to $wgFileExtensions, then install and designate an image converter. I went with rsvg: apt-get install librsvg2-bin vi LocalSettings.php $wgSVGConverter = 'rsvg'; =====Add HitCounters=====  wget https://extdist.wmflabs.org/dist/extensions/HitCounters-REL1_34-48dd6cb.tar.gz tar -xzf HitCounters-REL1_34-48dd6cb.tar.gz -C /var/lib/mediawiki/extensions vi ../LocalSettings.php wfLoadExtension( 'HitCounters' ); cd ../maintenance php update.php ====Change the Dbase====

I tried to 'rename' the dbase, creating a dedicated dbase user that has access to just the wiki's dbase, and resetting its password.

===Import Template=Setting up for advanced template(s)import==== =====Robelbox=====

I did this for the [https://ts.wikipedia.org/wiki/Template:Robelbox Robelbox template], which I got from https://en.wikiversity.org/wiki/Special:Export, however, it wasn't useableand I couldn't work out why. I ultimately deleted Robelbox, having found better boxes (see below) but I expect that my process for fixing the later issues would have sorted out the problems here too.

=====Fixing Template Issues===== I got Template:Box-round from mediawiki.org: https://www.mediawiki.org/wiki/Template:Box-round. It required installation of TemplateStyles to give '', which in turn might need JsonConfig:

Get the system up to dateI added: apt-get update$wgJsonConfigEnableLuaSupport = true;which gave: apt-Lua error: bad argument #1 to "get upgrade" (not a valid title).

During So instead, I put all the upgrade I chosefollowing into LocalSettings.php to configure JsonConfig (see [https://www.mediawiki.org/wiki/Topic:Vdtgrltwf1e5bmdx]):*keep the local smb // Safety: before extension.json, these values were initialized by JsonConfig.confphp if ( !isset( $wgJsonConfigModels ) ) {*keep the local grub $wgJsonConfigModels = []; } if ( !isset(new version $wgJsonConfigs ) ) { $wgJsonConfigs = []; } $wgJsonConfigEnableLuaSupport = true; // https://www.mediawiki.org/wiki/Extension:JsonConfig#Configuration $wgJsonConfigModels['Tabular.JsonConfig'] = 'JsonConfig\JCTabularContent'; $wgJsonConfigs['Tabular.JsonConfig'] = [ 'namespace' => 486, 'nsName' => 'Data', // page name must end in ".tab", and contain at least one symbol 'pattern' => '/.\.tab$/', 'license' => 'CC0-1.0', 'isLocal' => false, ]; // Enable Tabular data namespace on Commons - T148745 $wgJsonConfigInterwikiPrefix = 'commons'; $wgJsonConfigs['Tabular.JsonConfig']['remote'] = [ 'url' => 'https://commons.wikimedia.org/tmpw/grubapi.php' ]; Then I copied over Module:Documentation/styles.css from mediawiki.org, commenting out the background image in line 168. And everything seems to work fine...l1gqsHmubw)

There were dependcy problem and other warnings during I got the processfollowing templates from mediawiki (via [https://www. It finished withmediawiki.org/wiki/Special:Export mediawiki's Special:Export] to get dependencies): Errors were encountered while processing*Template:Colored box keyboard-configuration*Template:Navbox xserver-xorg-core xserver-xorg-input-wacom console-setup-linux console-setup ubuntu-minimal*Template:Help box E*Template: Sub-process /usr/bin/dpkg returned an error code (1)Side box W*Template: Operation was interrupted before it could finishNote

I rebooted the server. It came up ok and everything seemed fine (I'm doing Note that this over terminal)overwrote Template:Tl, but it is still claiming Template:TNT, and others that there are updatesI resolved issues with previously. The issue might be related to a known Ubuntu bug: https://bugs.launchpad.net/ubuntu/+source/console-setup/+bug/1770482. The solution(s) might be [https://unix.stackexchange.com/questions/202671/circular-dependency-in-ubuntu-release-upgrade]:

Look at Now a new set of issues has emerged. These include JsonConfig problems (again), and template loops (which I think are coming from Module:Template translation), and missing dependencies (e.g, Template:Mbox and Module:Color contrast). Moreover, most of the keyboard config file: cat /etc/default/keyboard # KEYBOARD CONFIGURATION FILE # Consult templates render the keyboardif and other conditional logic statements, rather then executing them. I installed ParserFunctions (5which I should have done before) manual page. XKBMODEL="pc105" XKBLAYOUT="us" XKBVARIANT="" XKBOPTIONS=""and it solved everything outstanding!

Remove and reinstall the keyboard-configuration:In mediawiki/installs apt-get remove keyboard-configuration aptwget https://extdist.wmflabs.org/dist/extensions/ParserFunctions-get install keyboardREL1_34-configuration Note that this launches a screen where the only options are Afghani variants.4de6f30.tar. so cancel it!gz DEBIAN_FRONTEND=noninteractive apttar -xzf ParserFunctions-get install keyboardREL1_34-configuration This ran and changed the keyboard layout file to the default: # KEYBOARD CONFIGURATION FILE # Consult the keyboard(5) manual page4de6f30. XKBMODEL="pc105" XKBLAYOUT="us,af" XKBVARIANT="," XKBOPTIONS="grp_led:scroll" vi /etc/default/keyboard I manually removed the af option and the commas, essentially reverting the file (I like a scroll light)tar. cd /usrgz -C /sharevar/X11lib/xkbmediawiki/symbolsextensions ln -s us en This was the other solution offered. I was missing an en option, so that might be itAdd to LocalSettings.php apt-get install keyboard-configurationwfLoadExtension( 'ParserFunctions' ); Now it says that there is nothing to do, which is promising. $wgPFEnableStringFunctions = true;

On bootTo do the front page, I copied the box reportssource of [https: Welcome to Ubuntu 18//www.mediawiki.04org/w/index.5 LTS php?title=Template:Main_page&action=edit Template:Main page] from mediawiki to a page (GNUcalled Test) and created [Template:Main page/Linux 4styles.15css] using [https://www.0-45-generic x86_64) mediawiki.org/w/index.php?title=Template:Main_page/styles. 36 packages can be updated. 30 updates are security updatescss&action=edit mediawiki's code].Then I rejigged the contents of the page!

Running aptThe only minor but non-get upgrade givesobvious change, was that I used h2 headings inside each mainpage_box, rather than h3's. As a consequence, I needed to add the following to [[Template:Main_page/styles.css]]: The following packages have been kept back:.mainpage_box h2 { fwupd fwupdate fwupdate border-signed libfwup1 libgl1-mesa-dri libreoffice-avmedia-backend-gstreamer libreoffice-base-corebottom: none; libreoffice-calc libreoffice-core libreoffice-draw libreoffice-gnome libreoffice-gtk3 libreoffice-impress libreoffice-math } libreoffice-ogltrans libreoffice-writer libxatracker2 linux-generic linux-headers-generic linux-image-generic netplan .mainpage_box h2 .ioheader_icon { python3 margin-software-properties python3-uno software-properties-common software-properties-gtkright: 5px; 0 upgraded, 0 newly installed, 0 to remove and 25 not upgraded.}

The latest LTS version (at the time of writing) is 20.04.1 (see Old instructions[https://wikiwww.ubuntumediawiki.comorg/Releases)wiki/Topic:R1j08xhjgrtkpj6q] suggest using [[Special:ExpandTemplate]] on mediawiki's wiki, with the input text <nowiki>{{:MediaWiki}}</nowiki>. So I could do an: apt-get dist-upgradeBut I should really do a full backup and everything first, so that this isn't going to happen todaynecessary as the template doesn't need expanding in its current (at the time of writing) incarnation. Naturally, the page works well on MobileFrontend.

==Reviewing Wordpress==Mass Edit====

There's a useful wordpress article on Get the basics of the approach, albeit from a hosted install perspective: httpssystem up to date://www.wpbeginner.com/wp-tutorials/how-to-restore-a-wordpress-site-with-just apt-databaseget update apt-backup/get upgrade

The main install instructions are: httpsDuring the upgrade I chose:*keep the local smb.conf*keep the local grub (new version in /tmp/wordpressgrub.org/support/article/how-to-install-wordpress/l1gqsHmubw)

For theme customization beyond that done in There were dependcy problem and other warnings during the interface, or through a plugin (like Code Snippets [httpsprocess. It finished with: Errors were encountered while processing://wordpress.org/plugins/code keyboard-configuration xserver-xorg-snippets/], wordpress says the best approach is to create a child theme [https://www.wpbeginner.com/wpcore xserver-themes/howxorg-toinput-createwacom console-asetup-wordpresslinux console-childsetup ubuntu-thememinimal E: Sub-videoprocess /]. usr/bin/dpkg returned an error code (1) W: Operation was interrupted before it could finish

Choosing I rebooted the theme server. It came up ok and everything seemed fine (I'm doing this over terminal), but it is still claiming that there are updates. The issue might be related to a known Ubuntu bug: https://wordpressbugs.orglaunchpad.net/themesubuntu/ and +source/console-setup/+bug/1770482. The solution(s) might be [https://wordpressunix.stackexchange.com/themes) is a major decision. This time I want a much more standard theme, that has better plugin and widget support, is responsive and gives a good mobile interface. I also don't want to pay but will have to trade that off against doing customization to make it look distinct. questions/202671/circular-dependency-in-ubuntu-release-upgrade]:

It seems that Twenty Fifteen has Look at the most active installs, but all the Twenty series, which are [httpskeyboard config file: cat //wordpress.org/themes/author/wordpressdotorgetc/ default themes] made by wordpress are wildly popular. It might be worth using [https://wordpress.org/themes/twentytwenty/ Twenty Twenty], as it is the most recent and takes advantage of keyboard # KEYBOARD CONFIGURATION FILE # Consult the block editor keyboard(Twenty Nineteen does too but gets mediocre reviews5), and I like the look of [https://wordpress.org/themes/twentyfourteen/ Twenty Fourteen]manual page. XKBMODEL="pc105" XKBLAYOUT="us" XKBVARIANT="" XKBOPTIONS=""

Outside of Remove and reinstall the defaults, [httpskeyboard-configuration://wordpress apt-get remove keyboard-configuration apt-get install keyboard-configuration Note that this launches a screen where the only options are Afghani variants.org/themes/oceanwp/ OceanWP] is eCommerce oriented but looks good and is very popular. [https://wordpress.org/themes/neve/ Neve] sits between OceanWP so cancel it! DEBIAN_FRONTEND=noninteractive apt-get install keyboard-configuration This ran and [httpschanged the keyboard layout file to the default://wordpress # KEYBOARD CONFIGURATION FILE # Consult the keyboard(5) manual page.org XKBMODEL="pc105" XKBLAYOUT="us,af" XKBVARIANT="," XKBOPTIONS="grp_led:scroll" vi /themesetc/generatepressdefault/ GeneratePress]keyboard I manually removed the af option and the commas, which has essentially reverting the file (I like a more magazinescroll light). cd /news focus, and all three take advantage of the new block editor ([https:usr/share/wordpress.orgX11/gutenbergxkb/ Gutenberg])symbols ln -s us en This was the other solution offered. I was missing an en option, which was introduced in WPv5 (initial release in 2018)so that might be it. ===Pre apt-get install===keyboard-configuration Now it says that there is nothing to do, which is promising.

Check PHP and MySQL. I need PHP >=7.3 and MySQL >=5.6 butTry the update again: php apt-get update && apt-versionget upgrade PHP 7Nothing happened and everything seems fine.2.24-0ubuntu0.18.04.6 (cli) (built: May 26 2020 13:09:11) ( NTS ) mysql shutdown --version mysql Ver 14.14 Distrib 5.7.31, for Linux (x86_64) using EditLine wrapperr now

I might be able On boot, the box reports: Welcome to upgrade my version of PhP without upgrading Ubuntu 18.04.5 LTS (see https:GNU//linuxizeLinux 4.15.com/post/how0-to45-install-php-on-ubuntu-18-04/generic x86_64) .. However, it is probably a good idea to just fix everything. 36 packages can be updated. 30 updates are security updates.

So it turns out that I shouldn't have done that last updateThe latest LTS version (at the time of writing) is 20.04.1 (see https://wiki.ubuntu.com/Releases). So I could do have an Xwindows Server on the box, running Gnome, : apt-get dist-upgradeBut I should really do a full backup and now I can't log in using the GUI on the box itself (it loops back to the login screen). This box doesn't contain the GPUs, just the database servereverything first, so the GUI that isn't key, but it would be nice going to have it working again. Hopefully, an upgrade will fix that, as well as other issueshappen today.

===Backing offWordpress===

Back up Rather than trying to update wordpress, I think it best to install the databases: psql postgres /l As researcher latest version and in /bulk/backups/ mv lbo_Fcuse the old dbase.dump lbo_FcThis will likely cause problems with images.dump.org pg_dump -Fc allpatentsprocessed > allpatentsprocessed_Fc.dump pg_dump but we made several suboptimal choices when we built the last version, including using a non-Fc accelerators > accelerators_Fcstandard theme and customizing it in a way that prevented updates.dump pg_dump -Fc grants > grants_Fc.dump pg_dump -Fc incubators > incubators_FcThere's a useful wordpress article on the basics of the approach, albeit from a hosted install perspective: https://www.dump pg_dump -Fc lbo > lbo_Fcwpbeginner.dump pg_dump com/wp-Fc stockmarket > stockmarket_Fc.dump pg_dump tutorials/how-Fc crunchbase3 > crunchbase3_Fc.dump pg_dump to-Fc vcdb20h1 > vcdb20h1_Fc.dump pg_dump restore-Fc vcdb4 > vcdb4_Fc.dump mysql a-u root wordpress-p SHOW DATABASES; \q mysqldump site-with-databases just-database-password mcnair > mcnair.sql mysqldump --databases --password wordpress > wordpress.sql mysqldump --password mcnair > mediawiki.sqlbackup/

Do the file transfers mkdir The main install instructions are: https:/media/usbwordpress.org/mother-2020-08-09 mkdir /mediasupport/usbarticle/motherhow-2020to-08install-09/bulk rsync -av --progress --exclude="mcnair" /bulk/ /media/usb/mother-2020-08-09/bulk/ mkdir /media/usb/mother-2020-08-09/html rsync -av --progress /var/www/html/ /media/usb/mother-2020-08-09/htmlwordpress/

FinallyFor theme customization beyond that done in the interface, or through a plugin (like Code Snippets [https: umount /media/usbwordpress.org/plugins/code-snippets/], wordpress says the best approach is to create a child theme [https://www.wpbeginner.com/wp-themes/how-to-create-a-wordpress-child-theme-video/].

===Do Choosing the upgrade===theme (https://wordpress.org/themes/ and https://wordpress.com/themes) is a major decision. This time I want a much more standard theme, that has better plugin and widget support, is responsive and gives a good mobile interface. I also don't want to pay but will have to trade that off against doing customization to make it look distinct.

RunIt seems that Twenty Fifteen has the most active installs, but all the Twenty series, which are [https: apt update apt upgrade apt dist-upgrade apt autoremove//wordpress.org/themes/author/wordpressdotorg/ default themes] made by wordpress are wildly popular. It might be worth using [https://wordpress.org/themes/twentytwenty/ Twenty Twenty], as it is the most recent and takes advantage of the block editor (Twenty Nineteen does too but gets mediocre reviews), and I like the look of [https://wordpress.org/themes/twentyfourteen/ Twenty Fourteen].

do-release-upgrade if no release found because you are too earlyOutside of the defaults, [https://wordpress.org/themes/oceanwp/ OceanWP] is eCommerce oriented but looks good and is very popular. [https://wordpress.org/themes/neve/ Neve] sits between OceanWP and [https://wordpress.org/themes/generatepress/ GeneratePress], which has a more magazine/news focus, add and all three take advantage of the -d to allow development new block editor (it will still install LTS if that's available[https://wordpress.org/gutenberg/ Gutenberg]) do-, which was introduced in WPv5 (initial release-upgrade -din 2018).

This failed on the first attempt. So I did: grep ERROR /var/log/dist====Pre-upgrade/main.log grep BROKEN /var/log/dist-upgrade/apt.log apt-get remove postgresql-10-postgis-2.4install====

ThenCheck PHP and MySQL. I need PHP >=7.3 and MySQL >=5.6 but: php --version doPHP 7.2.24-release0ubuntu0.18.04.6 (cli) (built: May 26 2020 13:09:11) ( NTS ) mysql -upgrade -dversion I selected some choices (keep smd mysql Ver 14.14 Distrib 5.7.conf31, don't notify me of whatever, etc.for Linux (x86_64)using EditLine wrapper  I let it replace postgres10 but it still gave me an "Obsolete Major Version" warning might be able to upgrade my version of PhP without upgrading Ubuntu (see https://linuxize.com/post/how-to-install-php-on postgres (I said ok-ubuntu-18-04/). However, it is probably a good idea to just fix everything...

===Address the upgrade issuesUpgrading Linux Distro===

The first casualty of So it turns out that I shouldn't have done that last update... I do have an Xwindows Server on the upgrade was box, running Gnome, and now I can't log in using the GUI on the box itself (it loops back to the networking configurationlogin screen). YouThis box doesn't contain the GPUs, just the database server, so the GUI isn'd think that developers t key, but it would be nice to have figured it working again. Hopefully, an upgrade will fix that one out, as remote upgrades would leave boxes DOA until someone could get physical access. Nevertheless, the fix is straight forwardwell as other issues.

Now everything looks good for a foundation - apache2 is workingFirst, SSH is working, but I need to do a minor config fix for mount the wikiUSB drive. apt-get install php-mbstring apachectl restart And Find what's mounted and what the wiki comes back up but with a error notice. The issue seems to be with PHP 7.4, and it looks like it affects both mediawiki and wordpress, though wordpress might have fixed it. Regardless, it dev is possible to install 7.3 as well, as use that with apache2. add-apt-repository ppa:ondrej/php apt-get update apt-get install php7.3 apt-get install php7.3-cli php7.3-common php7.3-json php7.3-opcache php7.3-mysql php7.3-mbstring php7.3mount -zip php7.3-fpm php7.3-intl php7.3-simplexmlt ext4 Note we may need to fix some config again as it said: Creating config file /etc/php/7.3/apache2/php.ini a2dismod php7.4 a2enmod php7.3 I ignored the following notices (or just mount for now: NOTICE: To enable PHP 7.3 FPM in Apache2 do: NOTICE: a2enmod proxy_fcgi setenvif NOTICE: a2enconf php7.3-fpm systemctl restart apache2everything) updatels -alternatives --set php l /usrdev/bindisk/php7.3 update-alternatives -by-set phar id/usr/bin/phar7.3usb* update (or fdisk -alternatives --set phar.phar /usr/bin/phar.phar7.3l or lsblk) update-alternatives -mkdir -set phpize p /usrmedia/bin/phpize7.3usb update-alternatives --set php-config mount /dev/usrsda1 /binmedia/php-config7.3 error: no alternatives for php-config (ignored for now)usb

And Back up the wiki now seems happy!databases: psql postgresI also checked postgres and everything seemed ok: /l su As researcherand in /bulk/backups/ mv lbo_Fc.dump lbo_Fc.dump.org pg_dump -Fc allpatentsprocessed > allpatentsprocessed_Fc.dump pg_dump -Fc accelerators > accelerators_Fc.dump pg_dump -Fc grants > grants_Fc.dump pg_dump -Fc incubators > incubators_Fc.dump pg_dump -Fc lbo > lbo_Fc.dump psql pg_dump -Fc stockmarket > stockmarket_Fc.dump pg_dump -Fc crunchbase3 > crunchbase3_Fc.dump pg_dump -Fc vcdb20h1 > vcdb20h1_Fc.dump pg_dump -Fc vcdb4> vcdb4_Fc.dump mysql -u root -p SHOW DATABASES; \lq They are all theremysqldump --databases --password mcnair > mcnair.sql \dx mysqldump --databases --password wordpress > wordpress.sql All my extensions report backmysqldump --password mcnair > mediawiki.sql

Do the file transfers mkdir /media/usb/mother-2020-08-09 mkdir /media/usb/mother-2020-08-09/bulk rsync -av --progress --exclude===Other Fixes==="mcnair" /bulk/ /media/usb/mother-2020-08-09/bulk/ mkdir /media/usb/mother-2020-08-09/html rsync -av --progress /var/www/html/ /media/usb/mother-2020-08-09/html/

Remove redundant user accountsFinally: cat umount /etcmedia/passwdusb userdel -r username====Do the upgrade====

I need to get Xwindows set up again. My best guess as to the cause of this issue is leftover Nvidia drivers from my attempts to install the GPUs on this box went bad in an earlier Run: apt update apt upgrade aptdist-get upgrade but I can't see them listed: dpkg -l | grep nvidia-driverapt autoremove

There is a .Xauthority file, and an .ICEauthority file do-release-upgrade if no release found because you are too early, in /home/ed and both are owned by ed:ed. The former is empty (0 bytes) and add the latter has some non-UTF8 d to allow development (I think?) characters in it. Iwill still install LTS if that'm not sure if either is an issue.s available) do-release-upgrade -d

I didn't see xserver-xorg-video-nouvea in This failed on the package list or any video driver module, so first attempt. So I installed nouveaudid: dpkg grep ERROR /var/log/dist-lupgrade/main.log lsmod | moregrep BROKEN /var/log/dist-upgrade/apt.log apt install xserver-xorgget remove postgresql-10-videopostgis-nouveau I'm not sure if I should be fixing my boot image or not..2. shutdown -r now lsmod | more4

After doing this the login would give a local desktop but neither the keyboard nor mouse worked. I tried uninstalling and reinstalled the keyboardThen: do-configuration again. aptrelease-get remove keyboardupgrade -configurationd apt-get install keyboard-configuration I selected some choices (keep smd.conf, don't notify me of whatever, etc.) shutdown -r now I let it replace postgres10 but it still gave me an "Obsolete Major Version" warning on postgres (I said ok).

And it worked even before a reboot. After a reboot, I had a different login screen but The first casualty of the actual desktop looked upgrade was the samenetworking configuration. The .Xauthority file is now 51 bytes big and I suddenly You'd think that developers would have a .xsession-errorsfigured that one out, which contains a list of environment settings taking placeas remote upgrades would leave boxes DOA until someone could get physical access... HoweverNevertheless, the machine then silently crashed that night and again the following morningfix is straight forward. I couldn't find a specific cause in the logs but there did seem to be a number X and GNOME problems: journalctl -b -1 journalctl --since "1 hour ago"

I ran an update from the GUI, which may have helpedThe old ifup and down and eth0 etc. Howeverinterface system is gone now, there was a warning about an issue taking its config with a screensaver it. To get the first time that networking back: ifconfig Outdated now, I loaded lightdmthink, and but it still shows what's up... ip -a This will get you the names of the crashes seemed to happen sometime after interfaces etc. I already had a clean boot. So yaml under a different interface name that set up DHCP, so I uninstalled lightdm, and installed gdm (which failed used it as installed already) and rebooted but got no GUI. Then a template for the interface that I uninstalled and reinstalled gdm and everything seems fine now.wanted up that way aptcp /etc/network/01-get remove lightdmnetcfg.yaml /etc/network/99_config.yaml apt-get remove gdm3vi /etc/network/99_config.yaml change the interface name to eno0 apt-get install gdm3netplan apply

IncidentallyNow everything looks good for a foundation - apache2 is working, SSH is working, but I left need to do a clock running in a terminal so that I could see when minor config fix for the box went down if it crashed againwiki. The clock code is: while [ 1 ] ; do echo apt-get install php-en "$(date +%T)\r" ; sleep 1; donembstring apachectl restart===Important Moves===  I kept And the old versions of wiki comes back up but with a error notice. The issue seems to be with PHP 7.4, and it looks like it affects both mediawiki and wordpress and moved them , though wordpress might have fixed it. Regardless, it is possible to install 7.3 as well, as use that with apache2. add-apt-repository ppa:ondrej/bulk/retired (using yyymmdd dates)php apt-get update apt-get install php7.3 mv apt-get install php7.3-cli php7.3-common php7.3-json php7.3-opcache php7.3-mysql php7.3-mbstring php7.3-zip php7.3-fpm php7.3-intl php7.3-simplexml Note we may need to fix some config again as it said: Creating config file /varetc/libphp/mediawiki26082020 7.3/apache2/php.ini a2dismod php7.4 a2enmod php7.3 I ignored the following notices for now: NOTICE: To enable PHP 7.3 FPM in Apache2 do: NOTICE: a2enmod proxy_fcgi setenvif NOTICE: a2enconf php7.3-fpm systemctl restart apache2 update-alternatives --set php /bulkusr/retiredbin/php7.3 mv update-alternatives --set phar /bulkusr/retiredbin/mediawiki26082020 phar7.3 update-alternatives --set phar.phar /bulkusr/retiredbin/mediawiki20200826phar.phar7.3 mv update-alternatives --set phpize /varusr/wwwbin/htmlphpize7.3 update-alternatives --set php-config /blog20200809 usr/bulk/retiredbin/php-config7.3 error: no alternatives for php-config (ignored for now)

===Install==PostGIS Issues=====

First, move the old folder to a new name, so that it is there for backup I also checked postgres and then get the new install and unpack it.everything seemed ok: cd /bulk/installssu researcher wget https://wordpress.org/latest.tar.gzpsql vcdb4 mv /var/www/html/blog /var/www/html/blog20200809\l tar -xzf latest.tar.gz -C /var/www/html/ They are all there cd /var/www/html/\dx mv wordpress/ blog/ chown -R www-data:www-data blog All my extensions report back.

Put an Update: It seems something did go wrong.htaccess file in Just because the extensions report back doesn't mean they work! When I try to run queries that folder to restrict access while we workuse PostGIS, I get: vi blogSQL Error [58P01]: ERROR: could not access file "$libdir/.htaccess <RequireAny> Require ip 192.168.postgis-2.1 </RequireAny>4": No such file or directory

Then set up But that didn't fix anything. I checked the dbase versions: select version(); PostgreSQL 10.14 (Ubuntu 10.14-0ubuntu0.18.04.1) on x86_64-pc-linux-gnu, compiled by editing wpgcc (Ubuntu 7.5.0-config3ubuntu1~18.php (it's easiest to modify the sample04)7.5.0, 64-bit cp blog/wp -config-sample.php blog/wp-config.phpSo somehow I'm still running version 10! select PostGIS_full_version(); ERROR: vi blogcould not access file "$libdir/wppostgis-config2.php4": No such file or directory Note get some keys fromCONTEXT: https://api SQL statement "SELECT public.wordpress.org/secret-key/1.1/saltpostgis_lib_version()" PL/pgSQL function postgis_full_version() line 25 at SQL statement

Then So I backed off the backend works - go to http://www.edegan.com/blog/wp-admin! However data from the health check shows a missing required module and two missing recommended modules. Fix dbases thatI'd used since the upgrade: aptpg_dump -get install php7Fc stockmarket > stockmarket_Fc_20201023.3-gddump aptpg_dump -get install php7Fc vcdb4 > vcdb4_Fc_20201023.3-curldump apt-get install php7.3-imagick apachectl restart #FAILED!

IronicallyThe second backoff failed: pg_dump: [archiver (db)] query failed: ERROR: could not access file "$libdir/postgis-2.4": No such file or directory pg_dump: [archiver (db)] query was: SELECT a.attnum, a.attname, a.atttypmod, a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, a.attisdropped, a.attlen, a.attalign, a.attislocal, pg_catalog.format_type(t.oid, it then recommends that I upgrade to PHP7a.4atttypmod) AS atttypname, array_to_string(a.attoptions, ', ') AS attoptions, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE 0 END AS attcollation, a.attidentity, pg_catalog.array_to_string(ARRAY(SELECT pg_catalog.quote_ident(option_name) || ' ' || pg_catalog. but that would just give issues for mediawikiquote_literal(option_value) FROM pg_catalog. On the other handpg_options_to_table(attfdwoptions) ORDER BY option_name), E', everything is now green and just 4 groups of recommendations remain ') AS attfdwoptions FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = '19998614'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum

===Config===Postgres Upgrade Attempt (Failed)======

See [[Wordpress Blog Site (Tool)]] for the McNair CenterMy changes weren's buildt substantial, so I proceeded with an upgrade.First I checked to see if I had postgres12 installed and listening on another port or not: locate postgres ls /usr/bin/postgres dpkg --get-selections | grep postgres pg_lsclusters Ver Cluster Port Status Owner Data directory Log file 10 main 5432 online postgres /data/postgres /var/log/postgresql/postgresql-10-main.log 12 main 5433 online postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log pg_upgradecluster 10 main #This failed: pg_dump: error: query failed: ERROR: could not access file "$libdir/postgis-2.4": No such file or directory

Using wwwSo.edegan.com. I can't automatically upgrade without first fixing the issue with v10 and postgis. add-apt-repository http:/blog/wpapt.postgresql.org/pub/repos/apt But that put the following into /etc/apt/sources-admin I configured the blog as followslist:*Select Twenty Twenty as the theme deb http://apt.postgresql.org/pub/repos/apt focal main*Add the permalink code vi it to the (see https://wiki.postgresql.org/wiki/Apt): deb http://apt.postgresql.htaccess file, so that the URLs will work with postnamesorg/pub/repos/apt focal-pgdg *Copy over images to wp wget --quiet -O -contenthttp:/uploads (use cp /apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add - apt-get update #Throws a to maintain permissions)warning:*Change the site name to https (after fixing the https setup, see below) N: Skipping acquire of configured file 'main/binary-i386/Packages' as repository 'http://apt.postgresql.org/pub/repos/apt focal-pgdg InRelease' doesn't support architecture 'i386'

Install pluginsBut the wretched thing still doesn't seem to be available:*Yoast SEO apt-get install postgresql-10-postgis-2.4 Package postgresql-10-postgis-2.4 is not available, but is referred to by another package.*Wordfence Security*Disable CommentsTrying a manual approach. [https://packages.ubuntu.com/bionic/i386/postgresql-10-postgis-2.4/download Get the file], put it in /bulk/temp and cd there. Then: apt-get install ./postgresql-10-postgis-2.4_2.4.3+dfsg-4_i386.deb #This failed too - there are unmet dependencies and they are 'not installable'.*Site Kit by Google (set up once live!)*Pixabay======Switching over the installations======

So, I also addedtook the alternative approach of changing the data folders [https:*CoBlocks (free)*Advanced Gutenberg (free)*Otter//www.tutorialspoint.com/how-to-change-postgresql-data-folder-location-on-ubuntu-16-04].

I didnThe plan:#Take version 10 offline#Move version 10't add Co-Authors Plus s data to a new location (https:/var/wordpress.orglib/pluginspostgresql/co-authors-plus10/main) as it hasn#Switch the ports of versions 10 and 12#Move version 12't been tested on s data to /data#Put version 12 online#Load up the latest data in version of wordpress. There are other plugins that offer equivalent functionality if I need one later.12!#Optionally wipe out the old installation

Other plugins I might want areShut it down:*Revive Old Post (share with twitter) pg_ctlcluster 12 master start*Optimole (optimize images) pg_lsclusters*WP Rocket (implement cache) #The cluster Ver Cluster Port Status Owner Data directory Log file 10 main 5432 online postgres /data/postgres /var/log/postgresql/postgresql-10-main.log 12 master 5433 online postgres /var/lib/postgresql/12/master /var/log/postgresql/postgresql-12-master.logg systemctl stop postgresql systemctl status postgresql

NotesEdit the config files: vi /etc/postgresql/10/main/postgresql.conf data_directory = '/var/lib/postgresql/10/main' port = 5433 vi /etc/postgresql/12/master/postgresql.conf data_directory = '/data/postgres' port = 5432 listen_addresses = '*Twitter embedding: https' #While we are here do some performance tuning: shared_buffers = 512MB huge_pages = try temp_buffers = 8G work_mem = 4GB maintenance_work_mem = 64 effective_cache_size = 384GB #Note that I didn't reduce the number of connections (and the max_wal_senders, which must be < max connections), or change max_stack_depth (which gives an error if you set it too high) vi /etc/postgresql/www.wpbeginner.com12/wp-tutorialsmaster/how-pg_hba.conf Copy over the config to-display-recent-tweets-in-wordpress-with-twitter-widgets/allow access from inside the network

I hardened Do the wordpress installationinstalls for some extensions: https://wordpress.org/support/article/hardening apt-get install postgresql-12-plr apt-get install postgresql-plperl-12 postgresql-plpython3-wordpress/12

This includedCheck it all works:*Fixing file ownership: For fully hardened, change ownership psql postgres CREATE EXTENSION postgis; CREATE EXTENSION plr; CREATE EXTENSION plperl; CREATE EXTENSION plpython3u; \dx List of everything to rootinstalled extensions Name | Version | Schema | Description---------+---------+------------+--------------------------------------------------------------------- plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language postgis | 3.0.0 | public | PostGIS geometry, except wflogsgeography, uploads and themes raster spatial types and functions (2 rows) Make the user: createuser --interactive researcher Then restore the databases (as researcher in wp/bulk/backup): createdb stockmarket pg_restore -Fc -d stockmarket stockmarket_Fc_20201023.dump createdb vcdb4 pg_restore -content, which should be owned by wwwFc -datad vcdb4 vcdb4_Fc. Howeverdump The restore threw some errors related to not having extension plpythonu, then you won't but otherwise seemed fine. The issue seems to be able to install plugins etc. A compromise that pythonu is -R rootpython2[https:root for blog and then //www.postgresql.org/docs/12/plpython-data:www-data for wp-contentpython23.*Check file permissions: Everything is 644html], except wp-content which and python2 is 755*Checking dbase rights and setting new passwords.*Changing passwords on old accounts not available for postgres 12 (with posts, so the accounts shouldn't it might be deletedhere: https://wiki.postgresql.org/wiki/Apt) to random strong strings: apt-cache search ".*Fixing up plpython*.htaccess file to impose restrictions*Install Sucuri *Enable more logging"

Checking user rights in the dbase and changing their password: mysql -user=root -p use wordpress SELECT User FROM mysql.user; SHOW GRANTS FOR 'username'@'localhost'; SET PASSWORD FOR 'username'@'localhost'='newpassword'; (Note that this shouldn't be logged in clear on the server, but might be on a client. Delete .mysql_history at the end of your session.)==Other Fixes====

.htaccess in wp-includesRemove redundant user accounts: # Block the include-only files. <IfModule mod_rewrite.c> RewriteEngine On RewriteBase cat / RewriteRule ^wp-adminetc/includes/ - [F,L] RewriteRule !^wp-includes/ - [S=3]passwd RewriteRule ^wpuserdel -includes/[^/]+\.php$ - [F,L] RewriteRule ^wp-includes/js/tinymce/langs/.+\.php - [F,L] RewriteRule ^wp-includes/theme-compat/ - [F,L] </IfModule> # BEGIN WordPressr username

The #BEGIN WordPress tag is redundant I need to get Xwindows set up again. My best guess as to the file cause of this issue is 644 root.leftover Nvidia drivers from my attempts to install the GPUs on this box went bad in an earlier apt-get upgrade but I can't see them listed: dpkg -l | grep nvidia-driver

Add the following to There is a .Xauthority file, and an .htaccess ICEauthority file, in /home/ed and both are owned by ed:ed. The former is empty (0 bytes) and the wordpress dir: <files wplatter has some non-configUTF8 (I think?) characters in it. I'm not sure if either is an issue.php> order allow,deny deny from all </files>

If there are plugin installation issues then add to wpI didn't see xserver-xorg-video-nouvea in the package list or any video driver module, so I installed nouveau: dpkg -l lsmod | more apt install xserver-xorg-video-confignouveau I'm not sure if I should be fixing my boot image or not...php define('FS_METHOD','direct');shutdown -r now lsmod | more

Once I'm all done with After doing this the login would give a local desktop but neither the theme etckeyboard nor mouse worked., I can uncomment tried uninstalling and reinstalled the following from wpkeyboard-configconfiguration again.php define('DISALLOW_FILE_EDIT', true);apt-get remove keyboard-configuration apt-get install keyboard-configuration shutdown -r now

And it worked even before a reboot. After a reboot, I had a different login screen but the actual desktop looked the same. The .Xauthority file is now 51 bytes big and I built suddenly have a .xsession-errors, which contains a [[Branding]] palettelist of environment settings taking place... However, to standardize the colorsmachine then silently crashed that night and again the following morning. And I installed couldn't find a specific cause in the Twentig plugin, logs but there did seem to give extra configuration options.be a number X and GNOME problems: journalctl -b -1 journalctl --since "1 hour ago"

I changed ran an update from the site colorsGUI, added which may have helped. However, there was a warning about an issue with a screensaver the logo first time that I loaded lightdm, and the tag linecrashes seemed to happen sometime after a clean boot. So I uninstalled lightdm, and made other config changesinstalled gdm (which failed as installed already) and rebooted but got no GUI. Then I uninstalled and reinstalled gdm and everything seems fine now. apt-get remove lightdm apt-get remove gdm3 apt-get install gdm3

ThenIncidentally, I added custom CSS as followsleft a clock running in a terminal so that I could see when the box went down if it crashed again.The clock code is: while [ 1 ] ; do echo -en "$(date +%T)\r" ; sleep 1; done

To remove I kept the title from the landing page:old versions of mediawiki and wordpress and moved them to /bulk/retired (using yyymmdd dates) .page-id-2169 .entry-title{ display:none !important;mv /var/lib/mediawiki26082020 /bulk/retired/ }mv /bulk/retired/mediawiki26082020 /bulk/retired/mediawiki20200826 .page-id-2169 .entry-header {mv /var/www/html/blog20200809 /bulk/retired/ padding: 0; }===Wordpress Redux===

I tried First, move the following blocks plugins:*'''Ultimate Addons for Guttenberg'''*It's free and adds some nice basic functionality**Post blocks include: Post Carouselold folder to a new name, Post Grid, Post Masonry, Post Timeline, Advanced Columns -- but customization so that it is limited there for backup and I can't do one post*'''Getwid''':**Pretty highly customizable. **Can specify which posts to show in 3 blocks (Custom Post Type, Post Carousel, and Post Slider) and can build custom templates to arrange how they are displayed**Post blocks: Recent Posts, Custom Post Type, Post Carousel, and Post Slider*'''Redux''' -- It's a templates library. You then get 5 for free the new install and they upsell hard.*'''ZeGuten''' - Couldn't find unpack it*'''Advanced Gutenberg''' - It's free and widely used... *'''CoBlocks''' -- Does the basics cd /bulk/installs**Posts -- Can't specify specific posts wget https://wordpress. Can do categoryorg/latest.**Post Carousel -- Likewisetar.gz*'''Stackable''': mv /var/www/html/blog /var/www/html/blog20200809**It requested opt tar -in, which I didn't like, and it wants you to 'Go Premium'xzf latest. **It has settings for everything! By far the most detailed configurationtar.**Useful blocks:***Posts gz -- can't seem to specify a specific postC /var/www/html/***Advanced Columns and Grids -- for layout cd /var/www/html/***Card -- could make posts links with buttons***Feature mv wordpress/ blog/Feature Grid -- likewise***Container? Might be helpful*'''Gutenberg Post Blocks'''**Untested with my version. Seems to work. **Has lots of options but does full chown -page things. Can limit to a post using include but has next page links...**Tried to push for an update to pro.*'''Magical Posts Display''' R www-data:www- I dumped it for being too weird.*'''Otter Blocks'''**Google maps block and other useful things... I just don't need it right now.data blog

Built-Put an .htaccess file inthat folder to restrict access while we work:*Latest Posts vi blog/.htaccess <RequireAny> Require ip 192.168.2.1 </RequireAny> ====Set up==== Then set up the dbase by editing wp-config.php (widgetit's easiest to modify the sample). cp blog/wp-config-sample.php blog/wp-config.php vi blog/wp-config.php Note get some keys from: https://api.wordpress.org/secret-key/1.1/salt/

Chosen block pluginsThen the backend works - go to http://www.edegan.com/blog/wp-admin! However the health check shows a missing required module and two missing recommended modules. Fix that:*'''Getwid''' apt-get install php7.3- It's outstanding and embraces templates for serious bespoke customizationgd*'''Stackable''' apt-get install php7.3-curl apt- For its optionget install php7.3-based customizationimagick*I might add back '''coblocks''', '''Advanced Gutenberg''' and '''Ultimate Addons for Gutenberg''' apachectl restart

Install it and make some directories... apt update apt install certbot openssl dhparam -out /etc/ssl/certs/dhparamSee [[Wordpress Blog Site (Tool)]] for the McNair Center's build.pem 2048 takes ~20 secs mkdir -p /var/lib/letsencrypt/.well-known chgrp www-data /var/lib/letsencrypt chmod g+s /var/lib/letsencrypt

Set up the config files vi Using www.edegan.com/etcblog/apache2/confwp-available/letsencryptadmin I configured the blog as follows:*Select Twenty Twenty as the theme*Add the permalink code to the .confhtaccess file, so that the URLs will work with postnames Alias /.well-known/acme-challenge/ "/var/lib/letsencrypt/.well*Copy over images to wp-knowncontent/acmeuploads (use cp -challenge/"a to maintain permissions) <Directory "/var/lib/letsencrypt/"> AllowOverride None Options MultiViews Indexes SymLinksIfOwnerMatch IncludesNoExec Require method GET POST OPTIONS </Directory>*Change the site name to https (after fixing the https setup, see below)

vi /etc/apache2/conf-available/ssl-params.conf SSLProtocol all -SSLv3 -TLSv1 -TLSv1.1 SSLCipherSuite ECDHE-ECDSA-AES128-GCM-SHA256Install plugins:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA- CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384 SSLHonorCipherOrder off*Yoast SEO SSLSessionTickets off*Wordfence Security *Disable Comments SSLUseStapling On SSLStaplingCache "shmcb:logs/ssl_stapling*Site Kit by Google (32768set up once live!)" SSLOpenSSLConfCmd DHParameters "/etc/ssl/certs/dhparam.pem" Header always set Strict-Transport-Security "max-age=63072000"*Pixabay

Run certbot! certbot certonly --agree-tos --email ed@edegan.com --webroot I didn't add Co-w Authors Plus (https:/var/libwordpress.org/letsencryptplugins/ co-d edegan.com authors-d www.edeganplus/) as it hasn't been tested on the latest version of wordpress.com Note There are other plugins that offer equivalent functionality if I needed an @ entry in my A record for edegan.com pointed to my IP address to get the main challenge to succeedneed one later.

Then set up a new apache2 config file Other plugins I might want are:*Revive Old Post (in /etc/apacheshare with twitter): mv sites-available/000-default.conf sites-available/000-default.conf.bak vi sites-available/edegan.com.conf*Optimole (optimize images) <VirtualHost *:80>WP Rocket (implement cache) ServerName www.edegan.com ServerAdmin ed@edegan.comNotes: Redirect permanent / *Twitter embedding: https://www.edeganwpbeginner.com/ <wp-tutorials/how-to-display-recent-tweets-in-wordpress-with-twitter-widgets/VirtualHost> <VirtualHost *:443>====Hardening Wordpress==== ServerName www.edegan.com Protocols h2 httpI hardened the wordpress installation: https://1wordpress.1 DocumentRoot org/varsupport/wwwarticle/html ErrorLog ${APACHE_LOG_DIR}hardening-wordpress/error.log CustomLog ${APACHE_LOG_DIR}/access.log combined SSLEngine OnThis included: SSLCertificateFile /etc/letsencrypt/live/edegan.com/fullchain*Fixing file ownership: For fully hardened, change ownership of everything to root, except wflogs, uploads and themes in wp-content, which should be owned by www-data.pem SSLCertificateKeyFile /However, then you won't be able to install plugins etc/letsencrypt/live/edegan.com/privkeyA compromise is -R root:root for blog and then www-data:www-data for wp-content.pem # Other Apache Configuration*Check file permissions: Everything is 644, except wp-content which is 755 Alias /wiki /var/www/html/mediawiki/index*Checking dbase rights and setting new passwords.php RewriteEngine On*Changing passwords on old accounts (with posts, so the accounts shouldn't be deleted) to random strong strings. RewriteRule ^/*$ %{DOCUMENT_ROOT}/mediawiki/indexFixing up .php [L]htaccess file to impose restrictions </VirtualHost>*Install Sucuri ln -s sites-available/edegan.com.conf sites-enabled/edegan.com.conf systemctl reload apache2*Enable more logging

Test it by going to httpsChecking user rights in the dbase and changing their password://www mysql -user=root -p use wordpress SELECT User FROM mysql.ssllabsuser; SHOW GRANTS FOR 'username'@'localhost'; SET PASSWORD FOR 'username'@'localhost'='newpassword'; (Note that this shouldn't be logged in clear on the server, but might be on a client.com/ssltest/Delete .mysql_history at the end of your session.)

Finally.htaccess in wp-includes: # Block the include-only files. <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / RewriteRule ^wp-admin/includes/ - [F, edit L] RewriteRule !^wp-includes/etc- [S=3] RewriteRule ^wp-includes/cron[^/]+\.d/certbot and append the following to the last line (after php$ -renew):[F,L] RewriteRule ^wp-includes/js/tinymce/langs/.+\.php -renew-hook "systemctl reload apache2"[F,L] certbot renew RewriteRule ^wp-includes/theme-drycompat/ -run[F,L] Tests the renewal! </IfModule> # BEGIN WordPress

Enabling and requiring HTTPS causes an issue with PDFEmbed on mediawiki, where you get a blank frame. The PDF is still there, other images load fine, but the PDF frame won't render Add the PDFfollowing to . The problem is actually that the PDF is served with HTTP and htaccess in the rest of the page is served with HTTPS, and Chrome (and perhaps other browsers) don't render the insecure content as a consequence (see [httpswordpress dir://www <files wp-config.mediawiki.orgphp> order allow,deny deny from all </wiki/Topic:Uhgnq0wbmzfurbj0] for a description of the symptoms, but not the solution.).files>

The solution is If there are plugin installation issues then add to edit mediawiki/extensions/PDFEmbed/PDFEmbed.hookswp-config.php. For me it was line 103 that previously said: 'src' => $file->getFullUrldefine().'#page=FS_METHOD'.$page,I changed this line to: 'srcdirect' => preg_replace("/^http:/i", "https:", $file->getFullUrl()).'#page='.$page,;

This is mentioned in a comment on a topic pageOnce I'm all done with the theme etc., though presumably for an earlier version: https://wwwI can uncomment the following from wp-config.mediawiki.org/wiki/Topic:Syxow0why4c0cvvmphp define('DISALLOW_FILE_EDIT', true);

{{Colored box|title=Notice|content=Install VSFTPD==With hardened permissions, you won't be able to update Wordpress from the dashboard. To fix this, set ownership of the entire wordpress directory to www-data:www-data (i.e., chown -R www-data:www-data blog/), run the update, and then revert the ownership to root (or some other account).}}

apt-get install vsftpd cp /etc/vsftpd.conf /etc/vsftpd.conf_orig vi /etc/vsftpdI built a [[Branding]] palette, to standardize the colors.conf #Change the following write_enable=YES local_umask=022 ssl_enable=YES #Add And I installed the following (forces ssl) allow_anon_ssl=NO force_local_data_ssl=YES force_local_logins_ssl=YES ssl_tlsv1=YES ssl_sslv2=YES ssl_sslv3=YES /etc/initTwentig plugin, to give extra configuration options.d/vsftpd restart

I changed the site colors, added the logo and the tag line, and made other config changes. Then add a user and set it up, I added custom CSS as follows. To reduce the header spacing: useradd .header-m bloginner { padding: 1.5rem 0; passwd blog} To remove the title from the landing page: usermod .page-a id-G www2169 .entry-data blogtitle{ display:none !important; } usermod .page-d /var/www/html/blog blogid-2169 .entry-header { padding: 0; }

To do:*I need to add social media icons! That might be as easy as adding the social media menu [https://wordpress.org/support/article/twenty-twenty/#add-social-icons].*Get a '''related posts widget'''? There's Yet Another Related Posts Plugin, Contextual Related Posts, and Inline Related Posts... I went with YARPP, as it is the most popular. It is apparently resource-heavy. I tried the following blocks plugins:*'''Ultimate Addons for Guttenberg'''*It's free and adds some nice basic functionality**Post blocks include: Post Carousel, Post Grid, Post Masonry, Post Timeline, Advanced Columns -- but customization is limited and I can't do one post*'''Getwid''':**Pretty highly customizable. **Can specify which posts to show in 3 blocks (Custom Post Type, Post Carousel, and Post Slider) and can build custom templates to arrange how they are displayed**Post blocks: Recent Posts, Custom Post Type, Post Carousel, and Post Slider*'''Redux''' -- It's a templates library. You get 5 for free and they upsell hard.*'''ZeGuten''' - Couldn't find it*'''Advanced Gutenberg''' - It's free and widely used... *'''CoBlocks''' -- Does the basics**Posts -- Can't specify specific posts. Can do category.**Post Carousel -- Likewise.*'''Stackable''':**It requested opt-in, which I didn't like, and it wants you to 'Go Premium'. **It has settings for everything! By far the most detailed configuration.**Useful blocks:***Posts -- can't seem to specify a specific post***Advanced Columns and Grids -- for layout***Card -- could make posts links with buttons***Feature/Feature Grid -- likewise***Container? Might be helpful*'''Gutenberg Post Blocks'''**Untested with my version. Seems to work. **Has lots of options but does full-page things. Can limit to a post using include but has next page links...**Tried to push for an update to pro.*'''Magical Posts Display''' -- I dumped it for being too weird.*'''Otter Blocks'''**Google maps block and other useful things... I just don't need it right now. Built-in:*Latest Posts (widget) Chosen block plugins:*'''Getwid''' -- It's outstanding and embraces templates for serious bespoke customization*'''Stackable''' -- For its option-based customization*I might add back '''coblocks''', '''Advanced Gutenberg''' and '''Ultimate Addons for Gutenberg''' ====Email==== I installed WP Mail SMTP Lite. I first set it up to use Google. Essentially you need to sign in to Google and set up an API in the console: https://console.developers.google.com/flows/enableapi?apiid=gmail&pli=1. However, this seemed to introduce a massive security hole unless you have G Suite, so I abandoned this approach. I had previously set up SMTP through Google for the wiki (See [[Research_Computing_Configuration#Confirm_Account]]). So, I used the same approach with Wordpress. In WP Mail SMTP Lite choose 'Other' (see the [https://www.wpbeginner.com/plugins/how-to-send-email-in-wordpress-using-the-gmail-smtp-server/ second method]). Then [https://wpmailsmtp.com/docs/how-to-secure-smtp-settings-by-using-constants/ edit wp-config.php to hardcode the values] (this ensures that the password, which is stored plain-text, is a little more secure.): define( 'WPMS_ON', true ); //You MUST set this if you want hardcoded values to work! define( 'WPMS_LICENSE_KEY', '' ); define( 'WPMS_MAIL_FROM', 'blog@edegan.com' ); define( 'WPMS_MAIL_FROM_FORCE', true ); define( 'WPMS_MAIL_FROM_NAME', 'The Blog at EdEgan.com' ); define( 'WPMS_MAIL_FROM_NAME_FORCE', true ); define( 'WPMS_MAILER', 'smtp' ); // Possible values: 'mail', 'gmail', 'mailgun', 'sendgrid', 'smtp'. define( 'WPMS_SET_RETURN_PATH', true ); define( 'WPMS_SMTP_HOST', 'ssl://smtp.gmail.com' ); define( 'WPMS_SMTP_PORT', 465 ); define( 'WPMS_SSL', 'ssl' ); // Possible values '', 'ssl', 'tls' - note TLS is not STARTTLS. define( 'WPMS_SMTP_AUTH', true ); define( 'WPMS_SMTP_USER', 'username@gmail.com' ); // SMTP authentication username, only used if WPMS_SMTP_AUTH is true. define( 'WPMS_SMTP_PASS', 'password generated by Google' ); define( 'WPMS_SMTP_AUTOTLS', true ); =====Author Comments===== The blog supports multiple authors and by default, Wordpress emails an author whenever one of their posts gets a comment. If you'd like to disable author comment emails but keep the moderator emails, there's a simple fix: '''Just go to wp-admin/options.php and set 'comments_notify' to 0.''' (See https://codex.wordpress.org/Option_Reference) More complicated methods involve writing your own plugin [https://wordpress.stackexchange.com/questions/150125/disabling-comment-notifications-for-post-author] to refine wp_new_comment_notify_postauthor[https://developer.wordpress.org/reference/functions/wp_new_comment_notify_postauthor/] or changing the hooks[https://developer.wordpress.org/reference/hooks/notify_post_author/] used in wp-includes/comment.php: $maybe_notify = apply_filters( 'notify_post_author', $maybe_notify, $comment_ID ); ====Social Media Integration==== Getting the social media icons on the menu and correctly linked up is very straight forward. Follow the [https://wordpress.org/support/article/twenty-fifteen/#add-social-icons guide for twenty-fifteen], which also works for 2020. Getting some share buttons was more problematic, particular as my planned social media usage is somewhat atypical (Twitter, LinkedIn, and Reddit, really in reverse order), and because I don't want to pay anything.  The free version of [https://revive.social/plugins/revive-old-post/ Revive Old Posts] lets you push content to Twitter and Facebook, but they want you pay to push to LinkedIn. The best free options seem to be:*[https://wordpress.org/plugins/add-to-any/ AddToAny Share Buttons] - Integrates with Google Analytics*[https://wordpress.org/plugins/simple-social-icons/ Simple Social Icons] - The simplest option*[https://wordpress.org/plugins/shared-counts/ Shared Counts] -- Counts hits (but using a 3rd party for data?)*[https://wordpress.org/plugins/wordpress-social-login/ WordPress Social Login] - if you want users to log in using their SM accounts (note: has a bimodal ratings distro)*[https://wordpress.org/plugins/jetpack/ JetPack] -- The plugin used by wordpress.com for this functionality. The free version should suffice, but this thing is a monster. It also uses an account on the wordpress.com cloud, which is a pain for those who are self-hosting. I went with AddToAny, as it had the most installations, is entirely open-source, and offers all the functionality I need. ====Avoiding JetPack==== I tried to add a profile picture, but by default, WordPress uses [https://en.gravatar.com/ Gravitar], which, surprise, surprise, links to your WordPress.com account... and to add a self-hosted site, you have to install JetPack. At this point, I felt harassed and doubly so because I didn't install JetPack and yet, some how, the profile picture correctly updated from the one I'd posted on Gravitar. What the hecK? ===SEO=== I used Site Kit plugin for wordpess, and for mediawiki I made a sitemap to submit to Google. See https://www.mediawiki.org/wiki/Manual:GenerateSitemap.php In mediawiki: mkdir sitemap php maintenance/generateSitemap.php --memory-limit=50M --fspath=/var/www/html/mediawiki/sitemap/ --identifier=edegancom --urlpath=/sitemap/ --server=https://www.edegan.com --compress=yes Then submit it to Google... I did this by making an alias in apache2.conf from sitemap to /var/www/html/mediawiki/sitemap/, then submitting https://www.edegan.com/sitemap/sitemap-index-edegancom.xml #in retrospect, I wish I'd used an identifier with 'wiki' in it but what the hey. And with that success behind you, install Google XML Sitemaps on Wordpress, chose some settings (on Settings -> XML-Sitemap), and then post the URL to Google: https://www.edegan.com/blog/sitemap.xml It seems Yoast already builds a sitemap, you just need to submit to it Google... (I uninstalled XML Sitemaps): https://www.edegan.com/blog/sitemap_index.xml ===HTTPS=== To set up HTTPS using Let's Encrypt, see https://linuxize.com/post/secure-apache-with-let-s-encrypt-on-ubuntu-20-04/ Install it and make some directories... apt update apt install certbot openssl dhparam -out /etc/ssl/certs/dhparam.pem 2048 takes ~20 secs mkdir -p /var/lib/letsencrypt/.well-known chgrp www-data /var/lib/letsencrypt chmod g+s /var/lib/letsencrypt Set up the config files vi /etc/apache2/conf-available/letsencrypt.conf Alias /.well-known/acme-challenge/ "/var/lib/letsencrypt/.well-known/acme-challenge/" <Directory "/var/lib/letsencrypt/"> AllowOverride None Options MultiViews Indexes SymLinksIfOwnerMatch IncludesNoExec Require method GET POST OPTIONS </Directory>  vi /etc/apache2/conf-available/ssl-params.conf SSLProtocol all -SSLv3 -TLSv1 -TLSv1.1 SSLCipherSuite ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA- CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384 SSLHonorCipherOrder off SSLSessionTickets off SSLUseStapling On SSLStaplingCache "shmcb:logs/ssl_stapling(32768)" SSLOpenSSLConfCmd DHParameters "/etc/ssl/certs/dhparam.pem" Header always set Strict-Transport-Security "max-age=63072000" Enable some apache2 mods! a2enmod ssl a2enmod headers a2enconf letsencrypt a2enconf ssl-params sudo a2enmod http2 systemctl reload apache2 Run certbot! certbot certonly --agree-tos --email ed@edegan.com --webroot -w /var/lib/letsencrypt/ -d edegan.com -d www.edegan.com Note that I needed an @ entry in my A record for edegan.com pointed to my IP address to get the main challenge to succeed. Then set up a new apache2 config file (in /etc/apache): mv sites-available/000-default.conf sites-available/000-default.conf.bak vi sites-available/edegan.com.conf <VirtualHost *:80> ServerName www.edegan.com ServerAdmin ed@edegan.com Redirect permanent / https://www.edegan.com/ </VirtualHost> <VirtualHost *:443> ServerName www.edegan.com Protocols h2 http/1.1 DocumentRoot /var/www/html ErrorLog ${APACHE_LOG_DIR}/error.log CustomLog ${APACHE_LOG_DIR}/access.log combined SSLEngine On SSLCertificateFile /etc/letsencrypt/live/edegan.com/fullchain.pem SSLCertificateKeyFile /etc/letsencrypt/live/edegan.com/privkey.pem # Other Apache Configuration Alias /wiki /var/www/html/mediawiki/index.php RewriteEngine On RewriteRule ^/*$ %{DOCUMENT_ROOT}/mediawiki/index.php [L] </VirtualHost> ln -s sites-available/edegan.com.conf sites-enabled/edegan.com.conf systemctl reload apache2 Test it by going to https://www.ssllabs.com/ssltest/ Finally, edit /etc/cron.d/certbot and append the following to the last line (after -renew): --renew-hook "systemctl reload apache2" certbot renew --dry-run Tests the renewal! ====PDFEmbed Issue==== Enabling and requiring HTTPS causes an issue with PDFEmbed on mediawiki, where you get a blank frame. The PDF is still there, other images load fine, but the PDF frame won't render the PDF. The problem is actually that the PDF is served with HTTP and the rest of the page is served with HTTPS, and Chrome (and perhaps other browsers) don't render the insecure content as a consequence (see [https://www.mediawiki.org/wiki/Topic:Uhgnq0wbmzfurbj0] for a description of the symptoms, but not the solution.). The solution is to edit mediawiki/extensions/PDFEmbed/PDFEmbed.hooks.php. For me it was line 103 that previously said: 'src' => $file->getFullUrl().'#page='.$page,I changed this line to: 'src' => preg_replace("/^http:/i", "https:", $file->getFullUrl()).'#page='.$page, This is mentioned in a comment on a topic page, though presumably for an earlier version: https://www.mediawiki.org/wiki/Topic:Syxow0why4c0cvvm ====Another Issue==== Interestingly, I started getting a message from Google Chrome whenever I went to post wiki entries saying: "The information you’re about to submit is not secure". There's an option to "Proceed anyway" or "Go back".  This started after I had MultiTail running viewing apache's logs, but I couldn't see, beyond some kind of file lock examination, how it could work. I figured that it was a coincidence and something else might have happened.  My first thought was that my SSL certificate might have expired. However, the certificate looks valid and good, and the issue survived a reboot. By inspecting the webpages (in Chrome) and then reviewing the Console, I could see that it was caused by a mixed content problem: Mixed Content: The page at '<URL>' was loaded over HTTPS, but requested an insecure font '<URL>'. This request has been blocked; the content must be served over HTTPS. It seemed that I somehow have some font addresses hardcoded somewhere: Mixed Content: The page at ... was loaded over HTTPS, but requested an insecure font 'http://128.42.44.180/mediawiki/resources/assets/fonts/BonvenoCF-Light.otf'. This request has been blocked; the content must be served over HTTPS. The copy of Chrome on my desktop must somehow have been upgraded? Or something else changed to cause a change in behavior... The IP is from the old web server at the McNair Center, suggesting that when I migrated the McNair database into the new wiki, I migrated this issue. (Note that it doesn't appear to be something hardcoded into a .css file, or similar -- I can't find any trace on the filesystem and besides, this wiki was built from a fresh install.)  I found the URLs hardcoded in [[MediaWiki:Common.css]] (it must have been moved with the last big batch of pages and I somehow didn't notice!) but then couldn't edit it! It seems that following [https://www.mediawiki.org/wiki/MediaWiki_1.32/interface-admin Mediawiki 1.32], the rights to edit the interface were separated out, and users now need the editinterface right to change anything in the Mediawiki namespace. So, I went to [[Special:UserRights]] and gave myself permission. Then I edited the page, which changed the look-and-feel of my editor (I have no idea why), removed the consol messages, but left the problem (even after ctrl-shift-r cache flush on Chrome). ===Install VSFTPD=== With the security restrictions on wordpress, I now need an FTP server to get files for themes, plugins, etc. I like VSFTPD, as its simple, secure, and has a nice standalone config. Old documentation on an earlier install on the old [[Wordpress Blog Site (Tool)]] page. Instructions are here: https://linuxconfig.org/how-to-setup-ftp-server-on-ubuntu-20-04-focal-fossa-linux  apt-get install vsftpd cp /etc/vsftpd.conf /etc/vsftpd.conf_orig vi /etc/vsftpd.conf #Change the following write_enable=YES local_umask=022 ssl_enable=YES #Add the following (forces ssl) allow_anon_ssl=NO force_local_data_ssl=YES force_local_logins_ssl=YES ssl_tlsv1=YES ssl_sslv2=YES ssl_sslv3=YES /etc/init.d/vsftpd restart Then add a user and set it up: useradd -m blog passwd blog usermod -a -G www-data blog usermod -d /var/www/html/blog blog Test it: ftp 127.0.0.1 sftp 127.0.0.1

*http://praveen.kumar.in/2009/05/31/setting-up-ftps-using-vsftpd-for-wordpress-plugins-auto-upgrade/*https://askubuntu.com/questions/14371/how-to-setup-ftp-to-use-in-locally-hosted-wordpress To address some of the issues with the FTP server's file permissions in wordpress add to wp-config.php: define( 'WP_CONTENT_DIR', 'wp-content' ); define( 'FTP_BASE', '/var/www/html/blog/' ); If I chmod blog:blog /var/www/html/blog then everything seems to work find when I sftp but wordpress is unable to create a directory... I can't work out why this is happening. I expect it has to do with the need for another wordpress specific define() statement, but I'm spending too much time on it. So I'm going to use direct installation of plugins instead, and remove the FTP server as it is a point of vulnerability. apt-get remove vsftpd userdel blog ===Final Configuration Changes to Apache=== Lock down apache somewhat further (as now there are directories that shouldn't be listable, etc.) cd /etc/apache2 vi apache2.conf #Change the directory definitions. Notes that if -SomeOption is used then other options must have + or - in front of them: <Directory /var/www/html> Options -Indexes +FollowSymLinks AllowOverride All Require all granted </Directory> systemctl reload apache2 #To debug: systemctl status apache2.service ====Remove the debug setup==== In the wiki (LocalSettings.php), comment the debug lines (I can't see when I added them from the documentation, but if you want to see error messages during the config, you'd want them uncommented): #error_reporting( -1 ); #ini_set( 'display_errors',1 ); #$wgShowExceptionDetails = true; #$wgShowDBErrorBacktrace = true; #$wgShowSQLErrors = true; Check the permissions set using $wgGroupPermissions - see https://www.mediawiki.org/wiki/Manual:User_rights Run all the updates to the blog, etc., from the consol before locking it down. Then in wp-config.php, lock down the ability to install plugins, etc., by commenting: #define('FS_METHOD','direct'); Edit the .htaccess files in blog and mediawiki to allow access but with appropriate restrictions. Note that the rewrite rules for the blog are in its .htaccess file <IfModule mod_rewrite.c> RewriteEngine On RewriteBase /blog/ RewriteRule ^index\.php$ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /blog/index.php [L] </IfModule> To make the blog the default, edit /etc/apache/sites-available-edegan.com.conf, add an alias (don't alias to index.php as it will cause design issues, the rewrite rule for that is already in the .htaccess file!): Alias /blog /var/www/html/blog/ And change: RewriteRule ^/*$ %{DOCUMENT_ROOT}/mediawiki/index.php [L] To: RewriteRule ^/*$ %{DOCUMENT_ROOT}/blog/index.php [L] Then: systemctl reload apache2 Note: Don't change the DocumentRoot to the blog, as this will destroy the design of the wiki. The last rewrite rule will decide the default site! ===Changing the Wordpress url=== It seems likely that some Reddit bots are automatically blocking postings with the word blog in their URL. So I decided to move my Wordpress installation from /blog to /journal.  Note that I briefly tried 'article' (singular to save letters). I also considered 'paper', which is shorter but not quite right. Likewise study, etc. Also digest (which was a close second), review, bulletin, and pub (which was just too ambiguous). The problem with article is that although it looks good for article URLS, the landing URL is then www.edegan.com/article. A collection word is better. And journal appeals to the academic in me. To do this takes about 10 minutes (see https://wordpress.org/support/article/moving-wordpress/). You have to:#Make the change in Wordpress through wp-admin (you have to do this first!) - Set both the Wordpress Address (URL) and Site Address (URL) fields#Move the directory to the new name (at this point I could access www.edegan.com/article)#Fix aliases in apache and the default subdomain for landing (see below)#Fix the permalinks (update the .htaccess file)#Fix the links hardcoded in menus#(Create and) load up a new icon image (it is set under Appearance -> Customize -> Site Identity)#Run any updates etc.#Reconnect Google site kit#Rerun Yoast SEO optimizer To fix the main alias in apache: vi /etc/apache2/sites-available/edegan.com.conf Change: Alias /blog /var/www/html/blog/ RewriteRule ^/*$ %{DOCUMENT_ROOT}/blog/index.php [L] systemctl reload apache2 I also needed to:#Perform a backup (I really should have done this before moving the site but hey...)#Fix the images etc. (they initially fine... but I came to suspect that they were cached and an HTML inspected revealed the wrong URLs) Do the backup (with a user that has process privileges): cd /bulk/backups mysqldump --add-drop-table -h localhost -u user -p wordpress | gzip > wordpress-20210209.sql.gz or mysqldump --add-drop-table -h localhost -u user -p wordpress > wordpress-20210209.sql Then install and use Velvet Blues (see https://www.wpbeginner.com/plugins/how-to-update-urls-when-moving-your-wordpress-site/) and use it to change the URLs (use https:// as a page inspection shows that this is correct) ===Another Change to the Wordpress URL and some updates === As root get the mysql dbase details: mysql -p #hint: tsn select host, user from mysql.user; show databases; Read mail: less /var/mail/$(whoami) Look in wp-config.php for dbase, user, pword etc. cat /var/www/html/journal/wp-config.php Back up the dbase mysqldump --add-drop-table -h localhost -u root -p wordpress > wordpress-20220814.sql Change settings (on https://www.edegan.com/journal/wp-admin/options-general.php)* WordPress Address (URL)** https://www.edegan.com/articles* Site Address (URL)** https://www.edegan.com/articles Move the folder: cd /var/www/html/ mv journal articles Reload: https://www.edegan.com/articles/wp-admin/options-general.php? Fix the .htaccess file to do the permalinks cd articles vi .htaccess #change 2 instances of journal to articles Fix the links in the menu on https://www.edegan.com/articles/wp-admin/customize.php?* Change links in menus! (2 instances - then publish) Upgrade php to 7.4 sudo apt-add-repository ppa:ondrej/php apt update apt install -y php7.4 php7.4-cli php7.4-common php7.4-fpm apt install -y php7.4-mysql php7.4-dom php7.4-simplexml php7.4-ssh2 php7.4-xml php7.4-xmlreader php7.4-curl php7.4-exif php7.4-ftp php7.4-gd php7.4-iconv php7.4-imagick php7.4-json php7.4-mbstring php7.4-posix php7.4-sockets php7.4-tokenizer apt install -y php7.4-mysqli php7.4-pdo php7.4-sqlite3 php7.4-ctype php7.4-fileinfo php7.4-zip php7.4-exif a2dismod php7.3 a2enmod php7.4 a2enmod proxy_fcgi setenvif a2enconf php7.4-fpm systemctl reload apache2 Update wordpress* Note that I have wordpress chown -R root:root for articles and then www-data:www-data for wp-content.* Didn't read: https://www.edegan.com/articles/wp-admin/update-core.php?action=do-core-upgrade Do the update /var/www/html# chown -R www-data:www-data articles/ run update in wp-admin * Update all the plugins* Update themes* Wordfence** Update .htaccess for extended protection. Reharden: chown -R root:root articles/ chown -R www-data:www-data articles/wp-content/ Fix the alias in apache! vi /etc/apache2/sites-available/edegan.com.conf Alias /journal /var/www/html/articles Alias /articles /var/www/html/article Alias /blog /var/www/html/blog RewriteRule ^/*$ %{DOCUMENT_ROOT}/articles/index.php [L] #Redirect the journal root to articles Redirect permanent /journal https://www.edegan.com/articles systemctl reload apache2 Plugins etc.* Site Kit by Google** Setup! (sign in using dredegan@gmail.com)* Yoast SEO** Rerun optimization Fix image links, etc.* I repointed the /journal and /blog aliases* Run the velvet blues plugin Fix the icon:* https://www.edegan.com/articles/wp-content/uploads/2021/02/edegandotcomslashjournal-LightGreyOnDarkBlue.png* In Z:\projects\WebDesign\LogosV2.xcf* Export as edegandotcomslasharticles-LightGreyOnDarkBlue.png* Set under Site Identity ===Useful tools=== ====Multitail==== I installed [https://www.vanheusden.com/multitail/manual.php Multitail]: apt-get multitail The [https://www.vanheusden.com/multitail/manual.php manual] is pretty weak, but the [https://www.vanheusden.com/multitail/examples.php examples] are good and the [https://www.vanheusden.com/multitail/features.php feature list] is excellent. Here's some useful commands to review log files: multitail -cS apache -ev "Bot" /var/log/apache2/access.log -ci white -e "Bot" -I /var/log/apache2/access.log multitail -cS apache -ev "Bot" -ev "bot" -ev "internal dummy connection" /var/log/apache2/access.log ====Traceroute====  apt install traceroute Note: [https://zmap.io/ Zmap] seems popular nowadays, based on traffic logs. ====Other==== Connect with smb from Mother to Father: smbclient //192.168.2.200/sharename -U Domainname/username Note that you need to specify the domain. Mount a thru connection: mount -t cifs -o user=username //192.168.2.200/sharename /mnt/father ln -s /mnt/father/whatever/ /bulk/whatever ==Old machines== For the configuration of the servers built for the McNair Center, see the old [[Center IT]] page or the pages below:*[[Database Server Documentation]]*[[RDP Documentation]]**[[Server Backup Policy]]**[[Power Backup]]*[[Test Web Server Documentation]]*[[Web Server Documentation]]**[[Wiki Configuration]]**[[Security on the wiki]] Some of this information is still useful! In addition, at UC Berkeley, Ed designed and built three machines - two postgresql database servers and a wiki server. The documentation is here:*[[Haas PhD Server Configuration]]*[[Posgres Server Configuration]] -- documents the build of postgres2

In addition, at UC Berkeley, Ed designed and built three machines - two postgresql database servers and a wiki server. The documentation is here:*Some [[Haas PhD Server Private Configuration]]*[[Posgres Server Configuration]] -- documents changes to the research computing setup are not recorded on the build of postgres2public wiki pages.