Class for setting up the MediaWiki database using Microsoft SQL Server. More...

Inheritance diagram for MssqlInstaller:

Collaboration diagram for MssqlInstaller:

[legend]

Public Member Functions
	canCreateAccounts ()
	Return true if the install user can create accounts.

	createTables ()
	Create database tables from scratch.

	getConnectForm ()

	getGlobalDefaults ()
	Get a name=>value map of MW configuration globals for the default values.

	getLocalSettings ()
	Get the DBMS-specific options for LocalSettings.php generation.

	getName ()

	getSchemaVars ()
	Get variables to substitute into tables.sql and the SQL patch files.

	getSettingsForm ()

	isCompiled ()

	openConnection ()

	preInstall ()
	Allow DB installers a chance to make last-minute changes before installation occurs.

	preUpgrade ()
	Allow DB installers a chance to make checks before upgrade.

	setupDatabase ()

	setupUser ()

	submitConnectForm ()
	Set variables based on the request array, assuming it was submitted via the form returned by getConnectForm().

	submitSettingsForm ()

Public Member Functions inherited from DatabaseInstaller
	__construct ( $parent)
	Construct and initialise parent.

	checkPrerequisites ()
	Checks for installation prerequisites other than those checked by isCompiled()

	createExtensionTables ()
	Create the tables for each extension the user enabled.

	doUpgrade ()
	Perform database upgrades.

	enableLB ()
	Set up LBFactory so that wfGetDB() etc.

	getCheckBox ( $var, $label, $attribs=[], $helpData="")
	Get a labelled checkbox to configure a local boolean variable.

	getConnection ()
	Connect to the database using the administrative user/password currently defined in the session.

	getGlobalNames ()
	Get an array of MW configuration globals that will be configured by this class.

	getInstallUserBox ()
	Get a standard install-user fieldset.

	getInternalDefaults ()
	Get a name=>value map of internal variables used during installation.

	getPasswordBox ( $var, $label, $attribs=[], $helpData="")
	Get a labelled password box to configure a local variable.

	getRadioSet ( $params)
	Get a set of labelled radio buttons.

	getReadableName ()
	Get the internationalised name for this DBMS.

	getSchemaPath ( $db)
	Return a path to the DBMS-specific schema file, otherwise default to tables.sql.

	getTextBox ( $var, $label, $attribs=[], $helpData="")
	Get a labelled text box to configure a local variable.

	getUpdateKeysPath ( $db)
	Return a path to the DBMS-specific update key file, otherwise default to update-keys.sql.

	getVar ( $var, $default=null)
	Get a variable, taking local defaults into account.

	getWebUserBox ( $noCreateMsg=false)
	Get a standard web-user fieldset.

	insertUpdateKeys ()
	Insert update keys into table to prevent running unneded updates.

	needsUpgrade ()
	Determine whether an existing installation of MediaWiki is present in the configured administrative connection.

	outputHandler ( $string)

	populateInterwikiTable ()
	Common function for databases that don't understand the MySQLish syntax of interwiki.sql.

	setupSchemaVars ()
	Set appropriate schema variables in the current database connection.

	setVar ( $name, $value)
	Convenience alias for $this->parent->setVar()

	setVarsFromRequest ( $varNames)
	Convenience function to set variables based on form data.

	submitInstallUserBox ()
	Submit a standard install user fieldset.

	submitWebUserBox ()
	Submit the form from getWebUserBox().

Public Attributes
	$webUserPrivs

Public Attributes inherited from DatabaseInstaller
Database	$db = null
	The database connection.

WebInstaller	$parent
	The Installer object.

Static Public Attributes
static	$minimumVersion = '9.00.1399'

Static Public Attributes inherited from DatabaseInstaller
static string	$minimumVersion
	Set by subclasses.

Protected Attributes
	$globalNames

	$internalDefaults

Protected Attributes inherited from DatabaseInstaller
array	$globalNames = []
	Array of MW configuration globals this class uses.

array	$internalDefaults = []
	Internal variables for installation.

Static Protected Attributes
static	$notMiniumumVerisonMessage = 'config-mssql-old'

Static Protected Attributes inherited from DatabaseInstaller
static string	$notMiniumumVerisonMessage
	Set by subclasses.

Private Member Functions
	catalogExists ( $catalogName)
	Try to see if a given fulltext catalog exists We assume we already have the appropriate database selected.

	databaseExists ( $dbName)
	Try to see if a given database exists.

	loginExists ( $user)
	Try to see if the login exists.

	schemaExists ( $schemaName)
	Try to see if a given schema exists We assume we already have the appropriate database selected.

	userExists ( $user)
	Try to see if the user account exists We assume we already have the appropriate database selected.

Additional Inherited Members
Static Public Member Functions inherited from DatabaseInstaller
static	meetsMinimumRequirement ( $serverVersion)
	Whether the provided version meets the necessary requirements for this type.

Static Protected Member Functions inherited from DatabaseInstaller
static	checkExtension ( $name)
	Convenience function.

Detailed Description

Class for setting up the MediaWiki database using Microsoft SQL Server.

Since: 1.23

Definition at line 34 of file MssqlInstaller.php.

Member Function Documentation

◆ canCreateAccounts()

MssqlInstaller::canCreateAccounts ( )

Return true if the install user can create accounts.

Returns: bool

Definition at line 260 of file MssqlInstaller.php.

References $res, and(), databaseExists(), DatabaseInstaller\getConnection(), DatabaseInstaller\getVar(), and schemaExists().

Referenced by getSettingsForm(), and submitSettingsForm().

◆ catalogExists()

MssqlInstaller::catalogExists ( $catalogName )

private

Try to see if a given fulltext catalog exists We assume we already have the appropriate database selected.

Parameters

string $catalogName Catalog name to check

Returns: bool

Definition at line 708 of file MssqlInstaller.php.

References $res.

Referenced by setupDatabase().

◆ createTables()

MssqlInstaller::createTables ( )

Create database tables from scratch.

Returns: Status

Reimplemented from DatabaseInstaller.

Definition at line 634 of file MssqlInstaller.php.

References DatabaseInstaller\getVar().

◆ databaseExists()

MssqlInstaller::databaseExists ( $dbName )

private

Try to see if a given database exists.

Parameters

string $dbName Database name to check

Returns: bool

Definition at line 686 of file MssqlInstaller.php.

References $res.

Referenced by canCreateAccounts(), and setupDatabase().

◆ getConnectForm()

MssqlInstaller::getConnectForm ( )

Returns: string

Reimplemented from DatabaseInstaller.

Definition at line 85 of file MssqlInstaller.php.

References DatabaseInstaller\getPasswordBox(), DatabaseInstaller\getRadioSet(), DatabaseInstaller\getTextBox(), DatabaseInstaller\getVar(), text, and wfMessage().

◆ getGlobalDefaults()

MssqlInstaller::getGlobalDefaults ( )

Get a name=>value map of MW configuration globals for the default values.

Returns: array

Reimplemented from DatabaseInstaller.

Definition at line 652 of file MssqlInstaller.php.

References and().

◆ getLocalSettings()

MssqlInstaller::getLocalSettings ( )

Get the DBMS-specific options for LocalSettings.php generation.

Returns: string

Reimplemented from DatabaseInstaller.

Definition at line 727 of file MssqlInstaller.php.

References DatabaseInstaller\getVar().

◆ getName()

MssqlInstaller::getName ( )

Returns: string

Reimplemented from DatabaseInstaller.

Definition at line 71 of file MssqlInstaller.php.

◆ getSchemaVars()

MssqlInstaller::getSchemaVars ( )

Get variables to substitute into tables.sql and the SQL patch files.

Returns: array

Reimplemented from DatabaseInstaller.

Definition at line 718 of file MssqlInstaller.php.

References DatabaseInstaller\getVar().

◆ getSettingsForm()

MssqlInstaller::getSettingsForm ( )

Returns: string

Reimplemented from DatabaseInstaller.

Definition at line 357 of file MssqlInstaller.php.

References $s, canCreateAccounts(), DatabaseInstaller\getCheckBox(), DatabaseInstaller\getPasswordBox(), DatabaseInstaller\getRadioSet(), DatabaseInstaller\getTextBox(), DatabaseInstaller\getVar(), plain, text, and wfMessage().

◆ isCompiled()

MssqlInstaller::isCompiled ( )

Returns: bool

Reimplemented from DatabaseInstaller.

Definition at line 78 of file MssqlInstaller.php.

References DatabaseInstaller\checkExtension().

◆ loginExists()

MssqlInstaller::loginExists ( $user )

private

Try to see if the login exists.

Parameters

string $user Username to check

Returns: bool

Definition at line 665 of file MssqlInstaller.php.

References $res.

Referenced by setupUser().

◆ openConnection()

MssqlInstaller::openConnection ( )

Returns: Status

Reimplemented from DatabaseInstaller.

Definition at line 201 of file MssqlInstaller.php.

References DatabaseInstaller\$db, $e, $wgDBWindowsAuthentication, and DatabaseInstaller\getVar().

◆ preInstall()

MssqlInstaller::preInstall ( )

Allow DB installers a chance to make last-minute changes before installation occurs.

This happens before setupDatabase() or createTables() is called, but long after the constructor. Helpful for things like modifying setup steps :)

Reimplemented from DatabaseInstaller.

Definition at line 478 of file MssqlInstaller.php.

References and().

◆ preUpgrade()

MssqlInstaller::preUpgrade ( )

Allow DB installers a chance to make checks before upgrade.

Reimplemented from DatabaseInstaller.

Definition at line 234 of file MssqlInstaller.php.

References $wgDBpassword, $wgDBuser, DatabaseInstaller\getConnection(), and DatabaseInstaller\getVar().

◆ schemaExists()

MssqlInstaller::schemaExists ( $schemaName )

private

Try to see if a given schema exists We assume we already have the appropriate database selected.

Parameters

string $schemaName Schema name to check

Returns: bool

Definition at line 697 of file MssqlInstaller.php.

References $res.

Referenced by canCreateAccounts(), and setupDatabase().

◆ setupDatabase()

MssqlInstaller::setupDatabase ( )

Returns: Status

Reimplemented from DatabaseInstaller.

Definition at line 490 of file MssqlInstaller.php.

References catalogExists(), databaseExists(), DatabaseInstaller\getConnection(), DatabaseInstaller\getVar(), schemaExists(), and DatabaseInstaller\setupSchemaVars().

◆ setupUser()

MssqlInstaller::setupUser ( )

Returns: Status

Definition at line 526 of file MssqlInstaller.php.

References and(), DatabaseInstaller\getConnection(), DatabaseInstaller\getVar(), loginExists(), DatabaseInstaller\setupSchemaVars(), and userExists().

◆ submitConnectForm()

MssqlInstaller::submitConnectForm ( )

Set variables based on the request array, assuming it was submitted via the form returned by getConnectForm().

Validate the connection settings by attempting to connect with them.

If this is called, $this->parent can be assumed to be a WebInstaller.

Returns: Status

Reimplemented from DatabaseInstaller.

Definition at line 143 of file MssqlInstaller.php.

References and(), DatabaseInstaller\getConnection(), DatabaseInstaller\setVar(), and DatabaseInstaller\setVarsFromRequest().

◆ submitSettingsForm()

MssqlInstaller::submitSettingsForm ( )

Returns: Status

Reimplemented from DatabaseInstaller.

Definition at line 411 of file MssqlInstaller.php.

References $e, and(), canCreateAccounts(), DatabaseInstaller\getVar(), DatabaseInstaller\setVar(), and DatabaseInstaller\setVarsFromRequest().

◆ userExists()

MssqlInstaller::userExists ( $user )

private

Try to see if the user account exists We assume we already have the appropriate database selected.

Parameters

string $user Username to check

Returns: bool

Definition at line 676 of file MssqlInstaller.php.

References $res.

Referenced by setupUser().

Member Data Documentation

◆ $globalNames

MssqlInstaller::$globalNames

protected

Initial value:

= [
        'wgDBserver',
        'wgDBname',
        'wgDBuser',
        'wgDBpassword',
        'wgDBmwschema',
        'wgDBprefix',
        'wgDBWindowsAuthentication',
    ]

Definition at line 36 of file MssqlInstaller.php.

◆ $internalDefaults

MssqlInstaller::$internalDefaults

protected

Initial value:

= [
        '_InstallUser' => 'sa',
        '_InstallWindowsAuthentication' => 'sqlauth',
        '_WebWindowsAuthentication' => 'sqlauth',
    ]

Definition at line 46 of file MssqlInstaller.php.

◆ $minimumVersion

MssqlInstaller::$minimumVersion = '9.00.1399'

static

Definition at line 54 of file MssqlInstaller.php.

◆ $notMiniumumVerisonMessage

MssqlInstaller::$notMiniumumVerisonMessage = 'config-mssql-old'

staticprotected

Definition at line 55 of file MssqlInstaller.php.

◆ $webUserPrivs

MssqlInstaller::$webUserPrivs

Initial value:

= [
        'DELETE',
        'INSERT',
        'SELECT',
        'UPDATE',
        'EXECUTE',
    ]

Definition at line 60 of file MssqlInstaller.php.

The documentation for this class was generated from the following file:

includes/installer/MssqlInstaller.php

Public Member Functions

Public Attributes

Static Public Attributes

Protected Attributes

Static Protected Attributes

Private Member Functions

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ canCreateAccounts()

◆ catalogExists()

◆ createTables()

◆ databaseExists()

◆ getConnectForm()

◆ getGlobalDefaults()

◆ getLocalSettings()

◆ getName()

◆ getSchemaVars()

◆ getSettingsForm()

◆ isCompiled()

◆ loginExists()

◆ openConnection()

◆ preInstall()

◆ preUpgrade()

◆ schemaExists()

◆ setupDatabase()

◆ setupUser()

◆ submitConnectForm()

◆ submitSettingsForm()

◆ userExists()

Member Data Documentation

◆ $globalNames

◆ $internalDefaults

◆ $minimumVersion

◆ $notMiniumumVerisonMessage

◆ $webUserPrivs