apt-cache policy mediawiki

mediawiki:
  Installed: (none)
  Candidate: 1:1.35.6-1
  Version table:
     1:1.35.6-1 500
        500 http://archive.ubuntu.com/ubuntu jammy/universe amd64 Packages

apt-get update
apt-get install -y apache2 mysql-server php php-mysql php-xml php-mbstring \
  php-intl php-apcu php-curl php-gd php-zip libapache2-mod-php \
  software-properties-common wget curl

Setting up php (2:8.1+92ubuntu1) ...
Setting up libcgi-fast-perl (1:2.15-1) ...
Processing triggers for php8.1-cli (8.1.2-1ubuntu2.28) ...
Processing triggers for libapache2-mod-php8.1 (8.1.2-1ubuntu2.28) ...

php -v | head -1
mysql --version
apache2 -v

PHP 8.1.2-1ubuntu2.28 (cli) (built: Oct 19 2026 18:54:45) (NTS)
mysql  Ver 8.0.46-0ubuntu0.22.04.4 for Linux on x86_64 ((Ubuntu))
Server version: Apache/2.4.52 (Ubuntu)
Server built:   2026-10-08T19:59:46

systemctl enable apache2
systemctl enable mysql
systemctl start apache2
systemctl start mysql

Executing: /lib/systemd/systemd-sysv-install enable apache2

systemctl is-active apache2
systemctl is-active mysql

active
active

mysql_secure_installation

VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?

Press y|Y for Yes, any other key for No: n
Skipping password set for root as authentication with auth_socket is used by default.
If you would like to use password authentication instead, this can be done with the "ALTER_USER" command.
See https://dev.mysql.com/doc/refman/8.0/en/alter-user.html#alter-user-password-management for more information.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
 ... skipping.
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
 ... skipping.
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
 - Dropping test database...
Success.
 - Removing privileges on test database...
Success.
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
Success.

All done!

mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'q1w2e3r4'; FLUSH PRIVILEGES;"

mysql -uroot -pq1w2e3r4 -e 'SELECT VERSION();'

VERSION()
8.0.46-0ubuntu0.22.04.4

cd /root
curl -fLO https://releases.wikimedia.org/mediawiki/1.46/mediawiki-1.46.2.tar.gz
ls -lh mediawiki-1.46.2.tar.gz
sha256sum mediawiki-1.46.2.tar.gz

  0     0    0     0    0     0      0      0 --:--:--  0:00:54 --:--:--     0
curl: (35) OpenSSL SSL_connect: Connection reset by peer in connection to releases.wikimedia.org:443

100 94.4M  100 94.4M    0     0  13.6M      0  0:00:06  0:00:06 --:--:-- 21.1M
-rw-r--r-- 1 root root 95M Oct 21 21:41 /root/mediawiki-1.46.2.tar.gz
8f7f937f8bbc1acd4cef1c5362a95f248dcd242020f2588798eb2f73ac2e69ba  /root/mediawiki-1.46.2.tar.gz

cd /var/www
tar -xzf /root/mediawiki-1.46.2.tar.gz
mv mediawiki-1.46.2 mediawiki
ls -ld /var/www/mediawiki

drwxr-xr-x 15 root root 4096 Oct 21 21:41 /var/www/mediawiki

cat > /etc/apache2/conf-available/mediawiki.conf <<'EOF'
Alias /mediawiki /var/www/mediawiki
<Directory /var/www/mediawiki>
    Options -Indexes +FollowSymLinks
    AllowOverride All
    Require all granted
</Directory>
EOF
a2enconf mediawiki
systemctl reload apache2

Enabling conf mediawiki.
To activate the new configuration, you need to run:
  systemctl reload apache2

curl -s http://localhost/mediawiki/ | sed 's/<[^>]*>//g' | grep -A2 'internal error'

MediaWiki 1.46 internal error
MediaWiki 1.46 requires PHP 8.3.0 or higher; you are using PHP 8.1.2-1ubuntu2.28.

add-apt-repository -y ppa:ondrej/php
apt-get install -y php8.3 php8.3-mysql php8.3-xml php8.3-mbstring php8.3-intl \
  php8.3-apcu php8.3-curl php8.3-gd php8.3-zip libapache2-mod-php8.3

Adding repository.
Adding deb entry to /etc/apt/sources.list.d/ondrej-ubuntu-php-jammy.list
Adding disabled deb-src entry to /etc/apt/sources.list.d/ondrej-ubuntu-php-jammy.list
Adding key to /etc/apt/trusted.gpg.d/ondrej-ubuntu-php.gpg with fingerprint B8DC7E53946656EFBCE4C1DD71DAEAAB4AD4CAB6

update-alternatives --set php /usr/bin/php8.3
a2dismod php8.1
a2enmod php8.3
systemctl restart apache2
php -v | head -1

update-alternatives: using /usr/bin/php8.3 to provide /usr/bin/php (php) in manual mode
Module php8.1 already disabled
Module php8.3 already enabled
PHP 8.3.36 (cli) (built: Oct 21 2026 14:31:50) (NTS)

php -m | grep -iE 'mbstring|xml|intl|apcu|mysqli|gd|curl|zip' | tr '\n' ' '

apcu curl gd intl libxml mbstring mysqli mysqlnd pdo_mysql SimpleXML xml xmlreader xmlwriter zip

cd /var/www/mediawiki
php maintenance/run.php install --help

CLI-based MediaWiki installation and configuration.
Default options are indicated in parentheses.
If no options are provided, the script will run in interactive mode.

Usage: php maintenance/run.php install [OPTION]... [name] [admin]

Script specific options:
    --confpath <CONFPATH>: Path to write LocalSettings.php to
        (/var/www/mediawiki)
    --dbname <DBNAME>: The database name (my_wiki)
    --dbserver <DBSERVER>: The database host (localhost)
    --dbtype <DBTYPE>: The type of database (mysql)
    --installdbuser <INSTALLDBUSER>: The user to use for installing
        (root)
    --pass <PASS>: The password for the wiki administrator.
    --lang <LANG>: The language to use (en)
    --scriptpath <SCRIPTPATH>: ...

php maintenance/run.php install --lang=zh --dbname=wikidb \
  --dbserver=localhost --dbuser=root --dbpass=q1w2e3r4 \
  --pass='QzuoAdmin2026' --scriptpath=/mediawiki 'Qzuo Wiki' admin

PHP 8.3.36已安装。
ICU 70.1已安装（支持Unicode 14.0.0）。
已找到内建的GD图形库。 如果你启用了上传功能，缩略图功能也将被启用。
Git版本控制软件未找到，您可以暂时忽略它，另请注意Special:Version不会显示commit的哈希值。
使用服务器名“http://localhost”。
使用服务器URL“http://localhost/mediawiki”。
警告：在CLI安装过程中，没有对您的默认上传目录（/var/www/mediawiki/images/）进行执行任意脚本的漏洞检查。
警告：您上传目录中的图像请求应使用HTTP标头X-Content-Type-Options: nosniff进行响应，以保护浏览器免受潜在不安全文件的侵害。 强烈建议在启用上传之前，在您的网络服务器上配置适当的响应标头。
环境检查已经完成。 您可以安装MediaWiki。
正在包含扩展程序... 完成
正在配置数据库... 完成
正在创建数据表... 完成
初始化统计... 完成
正在填充默认的跨wiki数据表... 完成
防止运行不需要的更新... 完成
正在恢复MediaWiki服务... 完成
正在创建显示默认内容的首页... 完成
正在创建管理员用户账号... 完成
已成功创建数据库
MediaWiki已成功安装。您现在可以访问<http://localhost/mediawiki>以查看您的wiki。如果您有问题，请阅览我们的常见问题列表：<https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ>或使用在该页面上链接的支持论坛之一。

mysql -uroot -pq1w2e3r4 -e 'SHOW DATABASES;'

Database
information_schema
mysql
performance_schema
sys
wikidb

ls -l /var/www/mediawiki/LocalSettings.php

-rw-r--r-- 1 root root 4366 Oct 21 21:54 /var/www/mediawiki/LocalSettings.php

curl -sI http://localhost/mediawiki/ | head -3

HTTP/1.1 301 Moved Permanently
Date: Wed, 21 Oct 2026 21:54:55 GMT
Server: Apache/2.4.52 (Ubuntu)

MediaWiki 1.46.2

apt-cache policy mediawiki
apt-get install -y mediawiki

# 测试环境放宽密码策略（生产环境务必保持默认 10 位 + 常见口令清单校验）
$wgPasswordPolicy['policies']['sysop']['MinimalPasswordLength'] = 8;
$wgPasswordPolicy['policies']['bureaucrat']['MinimalPasswordLength'] = 8;
$wgPasswordPolicy['policies']['interface-admin']['MinimalPasswordLength'] = 8;
$wgPasswordPolicy['policies']['bot']['MinimalPasswordLength'] = 8;
$wgPasswordPolicy['policies']['sysop']['PasswordNotInCommonList'] = false;
$wgPasswordPolicy['policies']['bureaucrat']['PasswordNotInCommonList'] = false;
$wgPasswordPolicy['policies']['interface-admin']['PasswordNotInCommonList'] = false;
$wgPasswordPolicy['policies']['default']['PasswordNotInCommonList'] = false;

php maintenance/run.php changePassword --user=admin --password=q1w2e3r4

Password set for Admin
Invalidated sessions for user Admin

$wgScriptExtension = "php";
$wgArticlePath = "/wiki/$1";
$wgUsePathInfo = true;

cat > /etc/apache2/conf-available/mediawiki.conf <<'EOF'
Alias /wiki /var/www/mediawiki/index.php
Alias /mediawiki /var/www/mediawiki
<Directory /var/www/mediawiki>
    Options -Indexes +FollowSymLinks
    AllowOverride All
    Require all granted
</Directory>
EOF
systemctl reload apache2

curl -s -o /dev/null -w '/wiki/首页 => %{http_code}\n' 'http://localhost/wiki/首页'
curl -s -o /dev/null -w '/wiki/CLI测试页 => %{http_code}\n' 'http://localhost/wiki/CLI测试页'

/wiki/首页 => 200
/wiki/CLI测试页 => 200

$wgEnableUploads = true;
$wgFileExtensions = [ 'png', 'gif', 'jpg', 'jpeg', 'webp', 'pdf', 'svg' ];

chown -R www-data:www-data /var/www/mediawiki/images

curl -s -o /dev/null -w '%{http_code}\n' 'http://localhost/mediawiki/index.php/Special:Upload'

200

# 1) 备份（数据库 + 配置 + 上传文件）
mysqldump -uroot -pq1w2e3r4 wikidb > /root/wikidb-$(date +%F).sql
cp -a /var/www/mediawiki/LocalSettings.php /root/
tar -czf /root/images-$(date +%F).tgz -C /var/www/mediawiki images

# 2) 下载新版 tarball，解压覆盖代码目录（LocalSettings.php/images/extensions 保留）
# 3) 跑数据库迁移与缓存刷新
cd /var/www/mediawiki
php maintenance/run.php update

Adding empty categories with description pages...
Removing empty categories without description pages...
Category cleanup complete.
Fixing log entries with log_title starting with 'User:#'
done.
Skipped 34 updates that were already applied.
Purging caches...
Done in 0.1 s.

php maintenance/run.php Version

MediaWiki version: 1.46.2 (built: 2026年10月21日 (三) 21:58)

# 1) 删除数据库与专用账号（如有）
mysql -uroot -pq1w2e3r4 -e "DROP DATABASE IF EXISTS wikidb;"

# 2) 移除 Apache 挂载
a2disconf mediawiki
systemctl reload apache2
rm -f /etc/apache2/conf-available/mediawiki.conf

# 3) 删除程序与数据目录
rm -rf /var/www/mediawiki

# 4) 如需彻底移除 LAMP
apt-get purge -y apache2 mysql-server 'php*'
apt-get autoremove -y