Altes-koeln/2024-09-20

cd /Users/wf/Projekte/2024/altes_koeln
profiwiki -rp -fu -cn akoeln -bp 9071 -sp 9070 --all -f
docker exec -it akoeln-db /bin/bash
unzip bassi_2024-09-20_12-54-02.sql.zip
docker volume ls
DRIVER    VOLUME NAME
local     akoeln_mysql-data
local     akoeln_wiki-etc
local     akoeln_wiki-www
docker cp bassi_2024-09-20_12-54-02.sql akoeln-db:/altes-koeln.sql
Successfully copied 436MB to akoeln-db:/altes-koeln.sql
docker exec -i akoeln-db mysql -u root -p"******" wiki < bassi_2024-09-20_12-54-02.sql
docker volume inspect akoeln_wiki-www
[
    {
        "CreatedAt": "2024-09-20T13:42:14Z",
        "Driver": "local",
        "Labels": {
            "com.docker.compose.project": "akoeln",
            "com.docker.compose.version": "2.28.1",
            "com.docker.compose.volume": "wiki-www"
        },
        "Mountpoint": "/var/lib/docker/volumes/akoeln_wiki-www/_data",
        "Name": "akoeln_wiki-www",
        "Options": null,
        "Scope": "local"
    }
]
docker cp altes-koeln.tgz akoeln-mw:/tmp
# grant credentials (with Claude AI help for howto) ...
-- Create the database if it doesn't exist
CREATE DATABASE IF NOT EXISTS wiki;

-- Create the user if it doesn't exist
CREATE USER IF NOT EXISTS 'exciting-bassi'@'%' IDENTIFIED BY '******';

-- Grant necessary permissions to the user
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON wiki.* TO 'exciting-bassi'@'%';

-- Apply the changes
FLUSH PRIVILEGES;
php maintenance/update.php --skip-config-validation
Done in 8 min 20 s.

http://localhost:9071/

2024-09-20 21:45

$wgLanguageCode = "de";
composer require --no-update mediawiki/chameleon-skin:~4.0
composer update mediawiki/chameleon-skin --no-dev

Extensions

grep wfLoad LocalSettings.php 
wfLoadSkin( 'MinervaNeue' );
wfLoadSkin( 'MonoBook' );
wfLoadSkin( 'Timeless' );
wfLoadSkin( 'Vector' );
#wfLoadSkin( 'chameleon' );
# wfLoadExtension( 'ExtensionName' );
wfLoadExtension( 'Bootstrap' );
wfLoadExtension( 'CategoryTree' );
wfLoadExtension( 'Cite' );
wfLoadExtension( 'CiteThisPage' );
wfLoadExtension( 'CookieWarning' );
wfLoadExtension( 'Gadgets' );
wfLoadExtension( 'ImageMap' );
wfLoadExtension( 'InputBox' );
wfLoadExtension( 'MultimediaViewer' );
wfLoadExtension( 'ParserFunctions' );
wfLoadExtension( 'PdfHandler' );
wfLoadExtension( 'PageForms' );
wfLoadExtension( 'Scribunto' );
wfLoadExtension( 'Scss' );
wfLoadExtension( 'SecureLinkFixer' );
wfLoadExtension( 'SemanticMediaWiki' );
wfLoadExtension( 'SpamBlacklist' );
wfLoadExtension( 'SyntaxHighlight_GeSHi' );
wfLoadExtension( 'TemplateData' );
wfLoadExtension( 'TextExtracts' );
wfLoadExtension( 'VisualEditor' );
wfLoadExtension( 'Widgets' );
wfLoadExtension( 'PDFEmbed' );
wfLoadExtension( 'NoTitle' );
#wfLoadExtension( 'Maps' );
wfLoadExtension('Iframe');
# wfLoadExtension('Kartographer');

- name: CategoryTree
  url: https://www.mediawiki.org/wiki/Extension:CategoryTree
  extension: CategoryTree
  purpose: provides a dynamic view of the wiki's category structure as a tree
  giturl: https://github.com/wikimedia/mediawiki-extensions-CategoryTree
  wikidata_id: Q21676245

- name: Cite
  url: https://www.mediawiki.org/wiki/Extension:Cite
  extension: Cite
  purpose: Adds <ref[ name=id]>...</ref> and <references/> tags for citations

- name: CiteThisPage
  url: https://www.mediawiki.org/wiki/Extension:CiteThisPage
  extension: CiteThisPage
  purpose: Adds a special page for easy citation of pages

- name: CookieWarning
  url: https://www.mediawiki.org/wiki/Extension:CookieWarning
  extension: CookieWarning
  purpose: Adds a cookie warning to comply with EU regulations

- name: Gadgets
  url: https://www.mediawiki.org/wiki/Extension:Gadgets
  extension: Gadgets
  purpose: Allows users to select custom CSS and JavaScript gadgets

- name: InputBox
  url: https://www.mediawiki.org/wiki/Extension:InputBox
  extension: InputBox
  purpose: Allow inclusion of predefined HTML forms
  giturl: https://github.com/wikimedia/mediawiki-extensions-InputBox
  wikidata_id: Q8615333

- name: MultimediaViewer
  url: https://www.mediawiki.org/wiki/Extension:MultimediaViewer
  extension: MultimediaViewer
  purpose: Displays images in a fullscreen interface

- name: PdfHandler
  url: https://www.mediawiki.org/wiki/Extension:PdfHandler
  extension: PdfHandler
  purpose: Handler for viewing PDF files in image mode

- name: Scribunto
  url: https://www.mediawiki.org/wiki/Extension:Scribunto
  extension: Scribunto
  purpose: Framework for embedding scripting languages in MediaWiki

- name: Scss
  url: https://www.mediawiki.org/wiki/Extension:Scss
  extension: Scss
  purpose: Allows using SCSS in wiki pages

- name: SecureLinkFixer
  url: https://www.mediawiki.org/wiki/Extension:SecureLinkFixer
  extension: SecureLinkFixer
  purpose: Rewrites HTTP links to HTTPS for known HTTPS-supporting sites

- name: SpamBlacklist
  url: https://www.mediawiki.org/wiki/Extension:SpamBlacklist
  extension: SpamBlacklist
  purpose: Anti-spam tool using blacklists

- name: TemplateData
  url: https://www.mediawiki.org/wiki/Extension:TemplateData
  extension: TemplateData
  purpose: Implements data storage for template parameters

- name: TextExtracts
  url: https://www.mediawiki.org/wiki/Extension:TextExtracts
  extension: TextExtracts
  purpose: Provides plain-text or limited HTML extracts of page content

- name: VisualEditor
  url: https://www.mediawiki.org/wiki/Extension:VisualEditor
  extension: VisualEditor
  purpose: Visual editor for wiki pages

- name: Widgets
  url: https://www.mediawiki.org/wiki/Extension:Widgets
  extension: Widgets
  purpose: Allows adding free-form widgets to wiki

- name: NoTitle
  url: https://www.mediawiki.org/wiki/Extension:NoTitle
  extension: NoTitle
  purpose: Adds magic word __NOTITLE__ to hide page title

- name: Iframe
  url: https://www.mediawiki.org/wiki/Extension:Iframe
  extension: Iframe
  purpose: Adds <iframe> tag to allow embedding external pages