Mediawiki database config. php file for scalable and efficient content management. , use the backup and restore features of mysql as outlined above) After importing a wiki database, even if the database can work, some minor problems may arise: Find a list of over 100 prebuilt Microsoft 365 Copilot connectors, organized by categories, including a description and link to each connector website. Attention: In the current version, the domain name is case sensitive. LocalSettings. Also you can configure your database server to only accept connections from localhost - this should prevent access from outside in case of leaked credentials. Think of it like a huge LocalSettings. php maintenance script. While it is possible to visit comment pages directly in the CommentStreams namespace, for example if they are listed in Special:RecentChanges, this is not encouraged. php contains all the information needed by MediaWiki to run. (Perform backup of your data before executing the script). The following only works when using MediaWiki's default authentication provider and default password configuration. See Compatibility#Database for a list of supported versions. php file: wfLoadExtension( 'Linter' ); Copy Run the update script which will automatically create the necessary database tables that this extension needs. Add the following code at the bottom of your LocalSettings. Database layout By understanding how to configure database connections, customize the wiki’s appearance, enable extensions, and manage user permissions, you can create a MediaWiki wiki tailored to your specific needs. php or MySkin. Using the root user for MediaWiki poses a significant security risk. Customize your wiki with user accounts, permissions, and extensions for optimal use. php; add appropriate lines to LocalSettings. Consider a USA VPS to easily host your database. Aug 24, 2025 · If the MediaWiki application is compromised, the attacker won’t have access to other databases on the server. When I upload a large (>245 Mb) file to my MediaWiki wiki (using Upload file, same as for images), I see: Internal Server Error The server encountered an internal I can connect to the database via psql from inside the mediawiki container. Database Layout For information about the MediaWiki database layout, such as a description of the tables and their contents, please see: The manual Abstract schema of MediaWiki core MySQL schema (automatically generated) API To make a read query, something like this usually suffices: The MariaDB database engine is one of the most commonly-used database backends for MediaWiki. to create/execute PL/PgSQL scripts. Then, you'll need to call the script “update. The system administrator can specify in MediaWiki's configuration that there is one primary database server, and any number of replica database servers; a weight can be assigned to each server. Wiki front-end software: MediaWiki [1]. Since MariaDB is the relational database management system used by the Wikimedia Foundation websites, it is well-supported in MediaWiki. php. e. php file. In the default configuration, SQLite can be used to avoid a second container and write to flat-files. A full list of the extensions installed on a particular wiki can be seen on the wiki's Special:Version page. Installing MediaWiki takes around 10 to 30 minutes, and involves uploading/copying files, and running the installer script to configure the software. This means the MySQL root account and its password. The installation process involves setting up Apache, installing the MariaDB database server, adding PHP support, and configuring a secure environment for MediaWiki. After the configuration script has finished, download the generated configuration file LocalSettings. This tutorial provides a comprehensive, step-by-step guide on backing up and restoring your MediaWiki database and files, ensuring the continuity and integrity of The MariaDB database engine is one of the most commonly-used database backends for MediaWiki. php tends to work very well – it even works when upgrading from extremely old versions. Installation Look for this extension's name in Wikimedia's CommonSettings. If you are using an extension that modifies the authentication process (Like LDAPAuth), the following may not work. php, you would use require_once to call this PHP file: Sometimes you may need to test changes in a multi-wiki environment. php : Generic configuration such as including extensions or calling over piece of configuration. Most extensions will mention if this script needs to be run or not. This article provides a guide to installing MediaWiki with Apache on Ubuntu 24. Some information about database access in MediaWiki. The database most commonly used with MediaWiki is MySQL . This is an index of all supported configuration settings based on the MainConfigSchema. In the search result page, the page that the comment appears on, rather than the comment page in the CommentStreams namespace, appears in the search results. I get the following error when I try to install MediaWiki 1. git This option corrupts data input unpredictably by adding quotes in e. MediaWiki requires PostgreSQL 10. Always backup your database before doing any manual modification. If you enabled the "security" option, then you need to Use superuser account. 04. 1 for the database name. It contains information for developers and system administrators on installing, managing and developing for the MediaWiki software. MediaWiki, known for facilitating collaborative content creation and management, pairs well with the widely supported Apache web server. To install an extension with LocalSettings. This article provides an overview of database access and general database issues in MediaWiki. Member Parser\fetchCurrentRevisionRecordOfTitle This can be checked by viewing the $_SERVER['USERDOMAIN'] entry in your server's phpinfo() ). mediawiki with database. This results in the freshly created mediawiki instance not working Wikibase provides a few maintenance scripts which can be found in the maintenance subdirectory. 32. API. In addition, there are various optional dependencies which are required if you want to use certain advanced features (see below). From semantic-mediawiki. php”, located in MediaWiki's maintenance/ directory – it goes through the database and adds or modifies database tables to fit the new DB schema for this version. The files are dynamically generated and are perfectly up-to-date. Member MediaWiki\Config\ConfigRepository\getValueOf Matches: the(8) of(5) 95. When coding in MediaWiki, you will normally access the database only through MediaWiki's functions for the purpose. Describe the bug When using services. php, you would use require_once to call this PHP file: Do not remove the extension configuration present in LocalSettings. If it's installed elsewhere, you can set the MW_INSTALL_PATH environment variable to the path of your MediaWiki installation and the scripts will use it. To change the setting of any configuration The purpose of this page is to collect information and experiences about running MediaWiki on SQLite. For example: ALTER DATABASE wikidb SET search_path TO mediawiki,public; -- where "mediawiki" is the schema name as listed by \dn -- then restart psql. Much of the advice for MySQL and for MariaDB apply to each other. Installation A database server to store MediaWiki pages and data. One step in the setup is to initialize the database. php before MediaWiki 1. json Users will login with NT-Logon Username, also known as SAMAccountName attribute in a standard AD-schema. Database backend software: MySQL. The script will populate the database and write a configuration file. See Manual:Installation guide , where you will also find the minimum system requirements. The steps below assume that your main wiki's database is called my_wiki, and that you access it using wiki (short URLs), and w (long URLs), which are the default values in MediaWiki-Docker. Before MediaWiki 1. 0. php instead and amend them as appropriate. The MySQL database engine is one of the most commonly-used database backends for MediaWiki. Follow the MediaWiki installer's instructions, entering the user name, and password you wrote down during the "creating your database" step above. 17, but please note that this is second-class support, and you may likely run into some bugs. By Tim Starling, January 2006. wmf-config/InitialiseSettings. (similar to Mediawiki with docker. suppose access to the configuration screen is inadvertently restricted to a group of users with no members), it's easier to edit a config file than to find an alternative way to change the database and thereby restore the system This is a request for comments for MediaWiki to have a sensible and easy to use configuration interface through the wiki user interface. Add the suggested configuration: Done – Navigate to Special:Version on your wiki to verify that the extension is successfully Some information about database access in MediaWiki. g. docker. These sources can include external URLs and SOAP services, regular wiki pages, uploaded files, files on the local server, databases, LDAP directories and local programs output. In MediaWiki 1. Following the steps below will set up a two-wiki wiki farm using MediaWiki-Docker. This page explains all configuration parameters for Semantic MediaWiki. Member MediaWiki\Config\ConfigRepository\getDescriptionOf Matches: the(8) of(6) 94. The error message is independent from the database type (tried also mariadb - from https://hub. Is it necessary to create a separate database user for MediaWiki? Yes, it’s highly recommended to create a separate database user specifically for MediaWiki. Discover stable, supported methods for efficient database initialization. . This enhances security by limiting the privileges of the MediaWiki user to only the MediaWiki database. MediaWiki supports PostgreSQL since 1. wmf-config/ : The MediaWiki configuration for all database. Additionally, you can create a MySQL user, who is restricted to only the database used by the wiki and provide this user's credentials in LocalSettings. Did you forget to run your application's database schema updater after upgrading? This is a technical manual for the MediaWiki software. php and InitialiseSettings. Update your Linux machine's MySQL Database (e. 39) file. Feb 8, 2026 · The script will populate the database and write a configuration file. Configure Mediawiki to use LDAP settings from a single location - ldap. update. The purpose of this page is to collect information and experiences about running MediaWiki on SQLite. Since MySQL used to be the relational database management system used by the Wikimedia Foundation websites, it is well-supported in MediaWiki. org Semantic MediaWiki offers a number of configuration parameters that site administrators may modify according to the particular needs of their wiki. All site specifics must be defined as variables in a configuration file. Each of these files is also available in public version control in one of the following repositories: operations/mediawiki-config. Image dumps: See below. 38, we are introducing a new system for loading configuration into MediaWiki. Extension registration#Configs (Your extension/skins settings) - how to register new configuration variables for extensions and skins. wmf-config/CommonSettings. php If the extension requires changes to the MediaWiki database, you will need to run the update. This is a list of database tables and field prefixes added by various extensions. Database Layout For information about the MediaWiki database layout, such as a description of the tables and their contents, please see: The manual Abstract schema of MediaWiki core MySQL schema (automatically generated) API To make a read query, something like this usually suffices: The purpose of this page is to collect information and experiences about running MediaWiki on PostgreSQL. Database Layout For information about the MediaWiki database layout, such as a description of the tables and their contents, please see: The manual Abstract schema of MediaWiki core MySQL schema (automatically generated) API To make a read query, something like this usually suffices: Configuration. php configuration files to see where it's installed. If they don't, you can either change the entries in the database using UPDATE ldap_domains SET domain = "DomainNameAsInConfiguration"; or adapt the configuration. 7, but please note that this is second-class support, and you may likely run into some bugs. opened files, data received from database etc. Our configuration lives in /srv/mediawiki-staging/wmf-config on the deployment host, and tools such as scap sync this directory to /srv/mediawiki on cluster hosts. This tutorial explains how to customize MediaWiki using the LocalSettings. 6 I'm non-interactively setting up MediaWiki sites with containers, backed by a MariaDB database. git Feb 5, 2026 · Manual:Configuration for developers - how to set and retrieve configuration variables. The MariaDB database engine is one of the most commonly-used database backends for MediaWiki. \dt should now list the tables The MediaWiki user does not need to be the owner of the database, but appropriate rights are necessary, e. Use 127. All available configuration parameters can also be found in file DefaultSettings. type = "sqlite";, mediawiki-init. Registering your tables and field prefixes here helps other developers to avoid name collisions when they create their own tables and fields. You can use the MediaWiki search box to search for comments. org The semantic API modules (SMW API) are provided by Semantic MediaWiki and related extensions enabling external components or data services to access semantically annotated information stored in the Semantic MediaWiki database via several available interfaces using a standardized HTTP request. Wikibase must be installed in MediaWiki's extensions directory, extensions/Wikibase. References MediaWiki\Auth\AuthManager\ACTION_CHANGE, MediaWiki\Auth\AuthManager\ACTION_CREATE, MediaWiki\Auth\AuthManager\ACTION_LINK, MediaWiki\Auth\AuthManager\ACTION_LOGIN, and MediaWiki\Auth\AuthManager\ACTION_REMOVE. 0 on XAMPP: To download a subset of the database in XML format, such as a specific category or a list of articles see: Special:Export, usage of which is described at Help:Export. Conclusion Successfully configuring the database for your MediaWiki installation is a critical step in setting up your wiki. MediaWiki features Installation and configuration MediaWiki tutorial with screenshots: how to install and configure Mediawiki, how to change skins; how to add extensions Follow the MediaWiki installer's instructions, entering the user name, and password you wrote down during the "creating your database" step above. MediaWiki will refuse to install if this option is turned on. Below is a selection of Wikimedia configuration files available for easy viewing. Unable to install MediaWiki. Learn how to configure your MediaWiki database smoothly, even with an existing LocalSettings. Some parts of the new functionality are still experimental, but much of it is already being used in production by Wikimedia. See Phabricator for a list of issues. If the configuration gets messed up to the point that one can't even get to the configuration screen (e. 25, configuration for extensions and skins was done in a PHP file using the extension's or skin's name, for example MyExtension. Dec 18, 2023 · Follow the steps to download, create a database, configure your server, and run the installation script. Never edit MainConfigSchema. com/_/mediawiki) or even if I shut down the postgresql12 container I have also tried with IP instead of hostname in LocalSettings. More detailed instructions for different (more production-ready) database types follow. A database query error has occurred. There are multiple database types supported by this image, most easily used via standard container linking. php (or DefaultSettings. The External Data extension allows MediaWiki pages to retrieve, filter, and format structured data from one or more sources. wikidb) with the wiki database from your windows machine (i. MediaWiki supports SQLite since 1. Editing Some information about database access in MediaWiki. php : Per-wiki configuration. 0 or later, and PG database Definition at line 202 of file AbstractPasswordPrimaryAuthenticationProviderTest. service fails to run without errors. git operations/puppet. This RfC is based off a previous RfC and the Configure MediaWiki extension. php and place the file in the base directory of your MediaWiki installation. This is mostly shared among all wikis. rq5y, ysepap, lpsab, dl4bz, tulbq, n3yis, u1lic, gemtx, abtc, ohqr8,