User:Alvonruff/ISFDB2 Notes

The isfdb2 staging system is a minimal system, with few packages installed, which uses dnf instead of apt-get.

Prerequisites

The staging system a minimum configuration AlmaLinux system, which is a variant of Fedora Core. It's really intended for tight cloud installations, so almost everything is missing, and installation of packages is done with yum/dnf.

• dnf install gcc
• dnf install make
• dnf install tar
• dnf install zip.x86_64
• dnf install bzip2.x86_64
• dnf install wget
• dnf install mod_dav_svn subversion

Apache

• dnf install httpd
• firewall-cmd --add-service=http --add-service=https --permanent
• service httpd start

MySQL

• dnf update
• dnf module enable mysql:8.0
• dnf install @mysql
• systemctl enable mysqld
• systemctl start mysqld
• Issue: mysql
• While in mysql, issue the command: create database isfdb;
• While in mysql, issue the command: use isfdb;
• While in mysql, issue the command: alter database isfdb character set latin1 collate latin1_swedish_ci;
• While in mysql, issue the command: source <<backupfile>>;'
• GRANT ALL PRIVILEGES ON isfdb.* TO 'isfdb1'@'localhost';

Python 2.7.18

• dnf install python2.x86_64
• dnf install python2-devel.x86_64
• dnf install mysql-devel.x86_64
• pip2 install mysqlclient
• alternatives --set python /usr/bin/python2

PHP

• dnf module reset php
• dnf module enable php:7.4
• dnf install php php-common php-opcache php-cli php-gd php-curl php-mysqlnd
• systemctl start php-fpm
• systemctl enable php-fpm
• php -v
• systemctl stop httpd
• systemctl start httpd

MediaWiki

• cd to /var/www/html
• Fetch the current stable long-term support release of MediaWiki:
  • wget https://releases.wikimedia.org/mediawiki/1.35/mediawiki-1.35.6.zip
• unzip mediawiki-1.35.6.zip
• mv mediawiki-1.35.6 wiki
• cd wiki && place the old isfdb version of LocalSettings.php here
• Edit LocalSettings.php and make the follow changes:
  • Change wgServer
  • Change wgDBuser
  • Change wgDBpassword
  • Comment out the ConfirmEdit extension
  • Comment out the SyntaxHighlight extension
  • Comment out the SVGtag extension
• php maintenance/update.php
  • Wait a very long time for the update to finish. This will perform hundreds of thousands of revision updates, but it issues a constant stream of progress lines. There is a web-based alternative, but I recommend against that, as the long processing time will generate a 504 error from Apache.
• Add the following lines to the end of LocalSettings.php and remove the old commented out versions:
  • wfLoadSkin( 'Vector' );
  • wfLoadExtension( 'ConfirmEdit' );
  • wfLoadExtension( 'SyntaxHighlight_GeSHi' );

Isfdb2-Specific Changes

• Edit the navbar by searching for MediaWiki:Sidebar, and change isfdb.org entries to isfdb2.org

Versions

• Linux: 4.18.0-240.15.1.el8_3.x86_64 x86_64
• Apache: Apache/2.4.37 (AlmaLinux)
• MySQL: 8.0.26
• Python: 2.7.18
• PHP: 7.4.19
• MediaWiki: 1.35.6