MediaWiki  1.33.0
MssqlInstaller.php
Go to the documentation of this file.
1 <?php
27 
35 
36  protected $globalNames = [
37  'wgDBserver',
38  'wgDBname',
39  'wgDBuser',
40  'wgDBpassword',
41  'wgDBmwschema',
42  'wgDBprefix',
43  'wgDBWindowsAuthentication',
44  ];
45 
46  protected $internalDefaults = [
47  '_InstallUser' => 'sa',
48  '_InstallWindowsAuthentication' => 'sqlauth',
49  '_WebWindowsAuthentication' => 'sqlauth',
50  ];
51 
52  // SQL Server 2005 RTM
53  // @todo Are SQL Express version numbers different?)
54  public static $minimumVersion = '9.00.1399';
55  protected static $notMiniumumVerisonMessage = 'config-mssql-old';
56 
57  // These are schema-level privs
58  // Note: the web user will be created will full permissions if possible, this permission
59  // list is only used if we are unable to grant full permissions.
60  public $webUserPrivs = [
61  'DELETE',
62  'INSERT',
63  'SELECT',
64  'UPDATE',
65  'EXECUTE',
66  ];
67 
71  public function getName() {
72  return 'mssql';
73  }
74 
78  public function isCompiled() {
79  return self::checkExtension( 'sqlsrv' );
80  }
81 
85  public function getConnectForm() {
86  if ( $this->getVar( '_InstallWindowsAuthentication' ) == 'windowsauth' ) {
87  $displayStyle = 'display: none;';
88  } else {
89  $displayStyle = 'display: block;';
90  }
91 
92  return $this->getTextBox(
93  'wgDBserver',
94  'config-db-host',
95  [],
96  $this->parent->getHelpBox( 'config-db-host-help' )
97  ) .
98  Html::openElement( 'fieldset' ) .
99  Html::element( 'legend', [], wfMessage( 'config-db-wiki-settings' )->text() ) .
100  $this->getTextBox( 'wgDBname', 'config-db-name', [ 'dir' => 'ltr' ],
101  $this->parent->getHelpBox( 'config-db-name-help' ) ) .
102  $this->getTextBox( 'wgDBmwschema', 'config-db-schema', [ 'dir' => 'ltr' ],
103  $this->parent->getHelpBox( 'config-db-schema-help' ) ) .
104  $this->getTextBox( 'wgDBprefix', 'config-db-prefix', [ 'dir' => 'ltr' ],
105  $this->parent->getHelpBox( 'config-db-prefix-help' ) ) .
106  Html::closeElement( 'fieldset' ) .
107  Html::openElement( 'fieldset' ) .
108  Html::element( 'legend', [], wfMessage( 'config-db-install-account' )->text() ) .
109  $this->getRadioSet( [
110  'var' => '_InstallWindowsAuthentication',
111  'label' => 'config-mssql-auth',
112  'itemLabelPrefix' => 'config-mssql-',
113  'values' => [ 'sqlauth', 'windowsauth' ],
114  'itemAttribs' => [
115  'sqlauth' => [
116  'class' => 'showHideRadio',
117  'rel' => 'dbCredentialBox',
118  ],
119  'windowsauth' => [
120  'class' => 'hideShowRadio',
121  'rel' => 'dbCredentialBox',
122  ]
123  ],
124  'help' => $this->parent->getHelpBox( 'config-mssql-install-auth' )
125  ] ) .
126  Html::openElement( 'div', [ 'id' => 'dbCredentialBox', 'style' => $displayStyle ] ) .
127  $this->getTextBox(
128  '_InstallUser',
129  'config-db-username',
130  [ 'dir' => 'ltr' ],
131  $this->parent->getHelpBox( 'config-db-install-username' )
132  ) .
133  $this->getPasswordBox(
134  '_InstallPassword',
135  'config-db-password',
136  [ 'dir' => 'ltr' ],
137  $this->parent->getHelpBox( 'config-db-install-password' )
138  ) .
139  Html::closeElement( 'div' ) .
140  Html::closeElement( 'fieldset' );
141  }
142 
143  public function submitConnectForm() {
144  // Get variables from the request.
145  $newValues = $this->setVarsFromRequest( [
146  'wgDBserver',
147  'wgDBname',
148  'wgDBmwschema',
149  'wgDBprefix'
150  ] );
151 
152  // Validate them.
154  if ( !strlen( $newValues['wgDBserver'] ) ) {
155  $status->fatal( 'config-missing-db-host' );
156  }
157  if ( !strlen( $newValues['wgDBname'] ) ) {
158  $status->fatal( 'config-missing-db-name' );
159  } elseif ( !preg_match( '/^[a-z0-9_]+$/i', $newValues['wgDBname'] ) ) {
160  $status->fatal( 'config-invalid-db-name', $newValues['wgDBname'] );
161  }
162  if ( !preg_match( '/^[a-z0-9_]*$/i', $newValues['wgDBmwschema'] ) ) {
163  $status->fatal( 'config-invalid-schema', $newValues['wgDBmwschema'] );
164  }
165  if ( !preg_match( '/^[a-z0-9_]*$/i', $newValues['wgDBprefix'] ) ) {
166  $status->fatal( 'config-invalid-db-prefix', $newValues['wgDBprefix'] );
167  }
168  if ( !$status->isOK() ) {
169  return $status;
170  }
171 
172  // Check for blank schema and remap to dbo
173  if ( $newValues['wgDBmwschema'] === '' ) {
174  $this->setVar( 'wgDBmwschema', 'dbo' );
175  }
176 
177  // User box
178  $this->setVarsFromRequest( [
179  '_InstallUser',
180  '_InstallPassword',
181  '_InstallWindowsAuthentication'
182  ] );
183 
184  // Try to connect
185  $status = $this->getConnection();
186  if ( !$status->isOK() ) {
187  return $status;
188  }
192  $conn = $status->value;
193 
194  // Check version
195  return static::meetsMinimumRequirement( $conn->getServerVersion() );
196  }
197 
201  public function openConnection() {
204  $user = $this->getVar( '_InstallUser' );
205  $password = $this->getVar( '_InstallPassword' );
206 
207  if ( $this->getVar( '_InstallWindowsAuthentication' ) == 'windowsauth' ) {
208  // Use Windows authentication for this connection
209  $wgDBWindowsAuthentication = true;
210  } else {
212  }
213 
214  try {
215  $db = Database::factory( 'mssql', [
216  'host' => $this->getVar( 'wgDBserver' ),
217  'port' => $this->getVar( 'wgDBport' ),
218  'user' => $user,
219  'password' => $password,
220  'dbname' => false,
221  'flags' => 0,
222  'schema' => $this->getVar( 'wgDBmwschema' ),
223  'tablePrefix' => $this->getVar( 'wgDBprefix' ) ] );
224  $db->prepareStatements( false );
225  $db->scrollableCursor( false );
226  $status->value = $db;
227  } catch ( DBConnectionError $e ) {
228  $status->fatal( 'config-connection-error', $e->getMessage() );
229  }
230 
231  return $status;
232  }
233 
234  public function preUpgrade() {
235  global $wgDBuser, $wgDBpassword;
236 
237  $status = $this->getConnection();
238  if ( !$status->isOK() ) {
239  $this->parent->showStatusError( $status );
240 
241  return;
242  }
246  $conn = $status->value;
247  $conn->selectDB( $this->getVar( 'wgDBname' ) );
248 
249  # Normal user and password are selected after this step, so for now
250  # just copy these two
251  $wgDBuser = $this->getVar( '_InstallUser' );
252  $wgDBpassword = $this->getVar( '_InstallPassword' );
253  }
254 
260  public function canCreateAccounts() {
261  $status = $this->getConnection();
262  if ( !$status->isOK() ) {
263  return false;
264  }
266  $conn = $status->value;
267 
268  // We need the server-level ALTER ANY LOGIN permission to create new accounts
269  $res = $conn->query( "SELECT permission_name FROM sys.fn_my_permissions( NULL, 'SERVER' )" );
270  $serverPrivs = [
271  'ALTER ANY LOGIN' => false,
272  'CONTROL SERVER' => false,
273  ];
274 
275  foreach ( $res as $row ) {
276  $serverPrivs[$row->permission_name] = true;
277  }
278 
279  if ( !$serverPrivs['ALTER ANY LOGIN'] ) {
280  return false;
281  }
282 
283  // Check to ensure we can grant everything needed as well
284  // We can't actually tell if we have WITH GRANT OPTION for a given permission, so we assume we do
285  // and just check for the permission
286  // https://technet.microsoft.com/en-us/library/ms178569.aspx
287  // The following array sets up which permissions imply whatever permissions we specify
288  $implied = [
289  // schema database server
290  'DELETE' => [ 'DELETE', 'CONTROL SERVER' ],
291  'EXECUTE' => [ 'EXECUTE', 'CONTROL SERVER' ],
292  'INSERT' => [ 'INSERT', 'CONTROL SERVER' ],
293  'SELECT' => [ 'SELECT', 'CONTROL SERVER' ],
294  'UPDATE' => [ 'UPDATE', 'CONTROL SERVER' ],
295  ];
296 
297  $grantOptions = array_flip( $this->webUserPrivs );
298 
299  // Check for schema and db-level permissions, but only if the schema/db exists
300  $schemaPrivs = $dbPrivs = [
301  'DELETE' => false,
302  'EXECUTE' => false,
303  'INSERT' => false,
304  'SELECT' => false,
305  'UPDATE' => false,
306  ];
307 
308  $dbPrivs['ALTER ANY USER'] = false;
309 
310  if ( $this->databaseExists( $this->getVar( 'wgDBname' ) ) ) {
311  $conn->selectDB( $this->getVar( 'wgDBname' ) );
312  $res = $conn->query( "SELECT permission_name FROM sys.fn_my_permissions( NULL, 'DATABASE' )" );
313 
314  foreach ( $res as $row ) {
315  $dbPrivs[$row->permission_name] = true;
316  }
317 
318  // If the db exists, we need ALTER ANY USER privs on it to make a new user
319  if ( !$dbPrivs['ALTER ANY USER'] ) {
320  return false;
321  }
322 
323  if ( $this->schemaExists( $this->getVar( 'wgDBmwschema' ) ) ) {
324  // wgDBmwschema is validated to only contain alphanumeric + underscore, so this is safe
325  $res = $conn->query( "SELECT permission_name FROM sys.fn_my_permissions( "
326  . "'{$this->getVar( 'wgDBmwschema' )}', 'SCHEMA' )" );
327 
328  foreach ( $res as $row ) {
329  $schemaPrivs[$row->permission_name] = true;
330  }
331  }
332  }
333 
334  // Now check all the grants we'll need to be doing to see if we can
335  foreach ( $this->webUserPrivs as $permission ) {
336  if ( ( isset( $schemaPrivs[$permission] ) && $schemaPrivs[$permission] )
337  || ( isset( $dbPrivs[$implied[$permission][0]] )
338  && $dbPrivs[$implied[$permission][0]] )
339  || ( isset( $serverPrivs[$implied[$permission][1]] )
340  && $serverPrivs[$implied[$permission][1]] )
341  ) {
342  unset( $grantOptions[$permission] );
343  }
344  }
345 
346  if ( count( $grantOptions ) ) {
347  // Can't grant everything
348  return false;
349  }
350 
351  return true;
352  }
353 
357  public function getSettingsForm() {
358  if ( $this->canCreateAccounts() ) {
359  $noCreateMsg = false;
360  } else {
361  $noCreateMsg = 'config-db-web-no-create-privs';
362  }
363 
364  $wrapperStyle = $this->getVar( '_SameAccount' ) ? 'display: none' : '';
365  $displayStyle = $this->getVar( '_WebWindowsAuthentication' ) == 'windowsauth'
366  ? 'display: none'
367  : '';
368  $s = Html::openElement( 'fieldset' ) .
369  Html::element( 'legend', [], wfMessage( 'config-db-web-account' )->text() ) .
370  $this->getCheckBox(
371  '_SameAccount', 'config-db-web-account-same',
372  [ 'class' => 'hideShowRadio', 'rel' => 'dbOtherAccount' ]
373  ) .
374  Html::openElement( 'div', [ 'id' => 'dbOtherAccount', 'style' => $wrapperStyle ] ) .
375  $this->getRadioSet( [
376  'var' => '_WebWindowsAuthentication',
377  'label' => 'config-mssql-auth',
378  'itemLabelPrefix' => 'config-mssql-',
379  'values' => [ 'sqlauth', 'windowsauth' ],
380  'itemAttribs' => [
381  'sqlauth' => [
382  'class' => 'showHideRadio',
383  'rel' => 'dbCredentialBox',
384  ],
385  'windowsauth' => [
386  'class' => 'hideShowRadio',
387  'rel' => 'dbCredentialBox',
388  ]
389  ],
390  'help' => $this->parent->getHelpBox( 'config-mssql-web-auth' )
391  ] ) .
392  Html::openElement( 'div', [ 'id' => 'dbCredentialBox', 'style' => $displayStyle ] ) .
393  $this->getTextBox( 'wgDBuser', 'config-db-username' ) .
394  $this->getPasswordBox( 'wgDBpassword', 'config-db-password' ) .
395  Html::closeElement( 'div' );
396 
397  if ( $noCreateMsg ) {
398  $s .= $this->parent->getWarningBox( wfMessage( $noCreateMsg )->plain() );
399  } else {
400  $s .= $this->getCheckBox( '_CreateDBAccount', 'config-db-web-create' );
401  }
402 
403  $s .= Html::closeElement( 'div' ) . Html::closeElement( 'fieldset' );
404 
405  return $s;
406  }
407 
411  public function submitSettingsForm() {
412  $this->setVarsFromRequest( [
413  'wgDBuser',
414  'wgDBpassword',
415  '_SameAccount',
416  '_CreateDBAccount',
417  '_WebWindowsAuthentication'
418  ] );
419 
420  if ( $this->getVar( '_SameAccount' ) ) {
421  $this->setVar( '_WebWindowsAuthentication', $this->getVar( '_InstallWindowsAuthentication' ) );
422  $this->setVar( 'wgDBuser', $this->getVar( '_InstallUser' ) );
423  $this->setVar( 'wgDBpassword', $this->getVar( '_InstallPassword' ) );
424  }
425 
426  if ( $this->getVar( '_WebWindowsAuthentication' ) == 'windowsauth' ) {
427  $this->setVar( 'wgDBuser', '' );
428  $this->setVar( 'wgDBpassword', '' );
429  $this->setVar( 'wgDBWindowsAuthentication', true );
430  } else {
431  $this->setVar( 'wgDBWindowsAuthentication', false );
432  }
433 
434  if ( $this->getVar( '_CreateDBAccount' )
435  && $this->getVar( '_WebWindowsAuthentication' ) == 'sqlauth'
436  && strval( $this->getVar( 'wgDBpassword' ) ) == ''
437  ) {
438  return Status::newFatal( 'config-db-password-empty', $this->getVar( 'wgDBuser' ) );
439  }
440 
441  // Validate the create checkbox
442  $canCreate = $this->canCreateAccounts();
443  if ( !$canCreate ) {
444  $this->setVar( '_CreateDBAccount', false );
445  $create = false;
446  } else {
447  $create = $this->getVar( '_CreateDBAccount' );
448  }
449 
450  if ( !$create ) {
451  // Test the web account
452  $user = $this->getVar( 'wgDBuser' );
453  $password = $this->getVar( 'wgDBpassword' );
454 
455  if ( $this->getVar( '_WebWindowsAuthentication' ) == 'windowsauth' ) {
456  $user = 'windowsauth';
457  $password = 'windowsauth';
458  }
459 
460  try {
461  Database::factory( 'mssql', [
462  'host' => $this->getVar( 'wgDBserver' ),
463  'user' => $user,
464  'password' => $password,
465  'dbname' => false,
466  'flags' => 0,
467  'tablePrefix' => $this->getVar( 'wgDBprefix' ),
468  'schema' => $this->getVar( 'wgDBmwschema' ),
469  ] );
470  } catch ( DBConnectionError $e ) {
471  return Status::newFatal( 'config-connection-error', $e->getMessage() );
472  }
473  }
474 
475  return Status::newGood();
476  }
477 
478  public function preInstall() {
479  # Add our user callback to installSteps, right before the tables are created.
480  $callback = [
481  'name' => 'user',
482  'callback' => [ $this, 'setupUser' ],
483  ];
484  $this->parent->addInstallStep( $callback, 'tables' );
485  }
486 
490  public function setupDatabase() {
491  $status = $this->getConnection();
492  if ( !$status->isOK() ) {
493  return $status;
494  }
496  $conn = $status->value;
497  $dbName = $this->getVar( 'wgDBname' );
498  $schemaName = $this->getVar( 'wgDBmwschema' );
499  if ( !$this->databaseExists( $dbName ) ) {
500  $conn->query(
501  "CREATE DATABASE " . $conn->addIdentifierQuotes( $dbName ),
502  __METHOD__
503  );
504  }
505  $conn->selectDB( $dbName );
506  if ( !$this->schemaExists( $schemaName ) ) {
507  $conn->query(
508  "CREATE SCHEMA " . $conn->addIdentifierQuotes( $schemaName ),
509  __METHOD__
510  );
511  }
512  if ( !$this->catalogExists( $schemaName ) ) {
513  $conn->query(
514  "CREATE FULLTEXT CATALOG " . $conn->addIdentifierQuotes( $schemaName ),
515  __METHOD__
516  );
517  }
518  $this->setupSchemaVars();
519 
520  return $status;
521  }
522 
526  public function setupUser() {
527  $dbUser = $this->getVar( 'wgDBuser' );
528  if ( $dbUser == $this->getVar( '_InstallUser' )
529  || ( $this->getVar( '_InstallWindowsAuthentication' ) == 'windowsauth'
530  && $this->getVar( '_WebWindowsAuthentication' ) == 'windowsauth' ) ) {
531  return Status::newGood();
532  }
533  $status = $this->getConnection();
534  if ( !$status->isOK() ) {
535  return $status;
536  }
537 
538  $this->setupSchemaVars();
539  $dbName = $this->getVar( 'wgDBname' );
540  $this->db->selectDB( $dbName );
541  $password = $this->getVar( 'wgDBpassword' );
542  $schemaName = $this->getVar( 'wgDBmwschema' );
543 
544  if ( $this->getVar( '_WebWindowsAuthentication' ) == 'windowsauth' ) {
545  $dbUser = 'windowsauth';
546  $password = 'windowsauth';
547  }
548 
549  if ( $this->getVar( '_CreateDBAccount' ) ) {
550  $tryToCreate = true;
551  } else {
552  $tryToCreate = false;
553  }
554 
555  $escUser = $this->db->addIdentifierQuotes( $dbUser );
556  $escDb = $this->db->addIdentifierQuotes( $dbName );
557  $escSchema = $this->db->addIdentifierQuotes( $schemaName );
558  $grantableNames = [];
559  if ( $tryToCreate ) {
560  $escPass = $this->db->addQuotes( $password );
561 
562  if ( !$this->loginExists( $dbUser ) ) {
563  try {
564  $this->db->begin();
565  $this->db->selectDB( 'master' );
566  $logintype = $this->getVar( '_WebWindowsAuthentication' ) == 'windowsauth'
567  ? 'FROM WINDOWS'
568  : "WITH PASSWORD = $escPass";
569  $this->db->query( "CREATE LOGIN $escUser $logintype" );
570  $this->db->selectDB( $dbName );
571  $this->db->query( "CREATE USER $escUser FOR LOGIN $escUser WITH DEFAULT_SCHEMA = $escSchema" );
572  $this->db->commit();
573  $grantableNames[] = $dbUser;
574  } catch ( DBQueryError $dqe ) {
575  $this->db->rollback();
576  $status->warning( 'config-install-user-create-failed', $dbUser, $dqe->getMessage() );
577  }
578  } elseif ( !$this->userExists( $dbUser ) ) {
579  try {
580  $this->db->begin();
581  $this->db->selectDB( $dbName );
582  $this->db->query( "CREATE USER $escUser FOR LOGIN $escUser WITH DEFAULT_SCHEMA = $escSchema" );
583  $this->db->commit();
584  $grantableNames[] = $dbUser;
585  } catch ( DBQueryError $dqe ) {
586  $this->db->rollback();
587  $status->warning( 'config-install-user-create-failed', $dbUser, $dqe->getMessage() );
588  }
589  } else {
590  $status->warning( 'config-install-user-alreadyexists', $dbUser );
591  $grantableNames[] = $dbUser;
592  }
593  }
594 
595  // Try to grant to all the users we know exist or we were able to create
596  $this->db->selectDB( $dbName );
597  foreach ( $grantableNames as $name ) {
598  try {
599  // First try to grant full permissions
600  $fullPrivArr = [
601  'BACKUP DATABASE', 'BACKUP LOG', 'CREATE FUNCTION', 'CREATE PROCEDURE',
602  'CREATE TABLE', 'CREATE VIEW', 'CREATE FULLTEXT CATALOG', 'SHOWPLAN'
603  ];
604  $fullPrivList = implode( ', ', $fullPrivArr );
605  $this->db->begin();
606  $this->db->query( "GRANT $fullPrivList ON DATABASE :: $escDb TO $escUser", __METHOD__ );
607  $this->db->query( "GRANT CONTROL ON SCHEMA :: $escSchema TO $escUser", __METHOD__ );
608  $this->db->commit();
609  } catch ( DBQueryError $dqe ) {
610  // If that fails, try to grant the limited subset specified in $this->webUserPrivs
611  try {
612  $privList = implode( ', ', $this->webUserPrivs );
613  $this->db->rollback();
614  $this->db->begin();
615  $this->db->query( "GRANT $privList ON SCHEMA :: $escSchema TO $escUser", __METHOD__ );
616  $this->db->commit();
617  } catch ( DBQueryError $dqe ) {
618  $this->db->rollback();
619  $status->fatal( 'config-install-user-grant-failed', $dbUser, $dqe->getMessage() );
620  }
621  // Also try to grant SHOWPLAN on the db, but don't fail if we can't
622  // (just makes a couple things in mediawiki run slower since
623  // we have to run SELECT COUNT(*) instead of getting the query plan)
624  try {
625  $this->db->query( "GRANT SHOWPLAN ON DATABASE :: $escDb TO $escUser", __METHOD__ );
626  } catch ( DBQueryError $dqe ) {
627  }
628  }
629  }
630 
631  return $status;
632  }
633 
634  public function createTables() {
635  $status = parent::createTables();
636 
637  // Do last-minute stuff like fulltext indexes (since they can't be inside a transaction)
638  if ( $status->isOK() ) {
639  $searchindex = $this->db->tableName( 'searchindex' );
640  $schema = $this->db->addIdentifierQuotes( $this->getVar( 'wgDBmwschema' ) );
641  try {
642  $this->db->query( "CREATE FULLTEXT INDEX ON $searchindex (si_title, si_text) "
643  . "KEY INDEX si_page ON $schema" );
644  } catch ( DBQueryError $dqe ) {
645  $status->fatal( 'config-install-tables-failed', $dqe->getMessage() );
646  }
647  }
648 
649  return $status;
650  }
651 
652  public function getGlobalDefaults() {
653  // The default $wgDBmwschema is null, which breaks Postgres and other DBMSes that require
654  // the use of a schema, so we need to set it here
655  return array_merge( parent::getGlobalDefaults(), [
656  'wgDBmwschema' => 'mediawiki',
657  ] );
658  }
659 
665  private function loginExists( $user ) {
666  $res = $this->db->selectField( 'sys.sql_logins', 1, [ 'name' => $user ] );
667  return (bool)$res;
668  }
669 
676  private function userExists( $user ) {
677  $res = $this->db->selectField( 'sys.sysusers', 1, [ 'name' => $user ] );
678  return (bool)$res;
679  }
680 
686  private function databaseExists( $dbName ) {
687  $res = $this->db->selectField( 'sys.databases', 1, [ 'name' => $dbName ] );
688  return (bool)$res;
689  }
690 
697  private function schemaExists( $schemaName ) {
698  $res = $this->db->selectField( 'sys.schemas', 1, [ 'name' => $schemaName ] );
699  return (bool)$res;
700  }
701 
708  private function catalogExists( $catalogName ) {
709  $res = $this->db->selectField( 'sys.fulltext_catalogs', 1, [ 'name' => $catalogName ] );
710  return (bool)$res;
711  }
712 
718  public function getSchemaVars() {
719  return [
720  'wgDBname' => $this->getVar( 'wgDBname' ),
721  'wgDBmwschema' => $this->getVar( 'wgDBmwschema' ),
722  'wgDBuser' => $this->getVar( 'wgDBuser' ),
723  'wgDBpassword' => $this->getVar( 'wgDBpassword' ),
724  ];
725  }
726 
727  public function getLocalSettings() {
728  $schema = LocalSettingsGenerator::escapePhpString( $this->getVar( 'wgDBmwschema' ) );
729  $prefix = LocalSettingsGenerator::escapePhpString( $this->getVar( 'wgDBprefix' ) );
730  $windowsauth = $this->getVar( 'wgDBWindowsAuthentication' ) ? 'true' : 'false';
731 
732  return "# MSSQL specific settings
733 \$wgDBWindowsAuthentication = {$windowsauth};
734 \$wgDBmwschema = \"{$schema}\";
735 \$wgDBprefix = \"{$prefix}\";";
736  }
737 }
$status
Status::newGood()` to allow deletion, and then `return false` from the hook function. Ensure you consume the 'ChangeTagAfterDelete' hook to carry out custom deletion actions. $tag:name of the tag $user:user initiating the action & $status:Status object. See above. 'ChangeTagsListActive':Allows you to nominate which of the tags your extension uses are in active use. & $tags:list of all active tags. Append to this array. 'ChangeTagsAfterUpdateTags':Called after tags have been updated with the ChangeTags::updateTags function. Params:$addedTags:tags effectively added in the update $removedTags:tags effectively removed in the update $prevTags:tags that were present prior to the update $rc_id:recentchanges table id $rev_id:revision table id $log_id:logging table id $params:tag params $rc:RecentChange being tagged when the tagging accompanies the action, or null $user:User who performed the tagging when the tagging is subsequent to the action, or null 'ChangeTagsAllowedAdd':Called when checking if a user can add tags to a change. & $allowedTags:List of all the tags the user is allowed to add. Any tags the user wants to add( $addTags) that are not in this array will cause it to fail. You may add or remove tags to this array as required. $addTags:List of tags user intends to add. $user:User who is adding the tags. 'ChangeUserGroups':Called before user groups are changed. $performer:The User who will perform the change $user:The User whose groups will be changed & $add:The groups that will be added & $remove:The groups that will be removed 'Collation::factory':Called if $wgCategoryCollation is an unknown collation. $collationName:Name of the collation in question & $collationObject:Null. Replace with a subclass of the Collation class that implements the collation given in $collationName. 'ConfirmEmailComplete':Called after a user 's email has been confirmed successfully. $user:user(object) whose email is being confirmed 'ContentAlterParserOutput':Modify parser output for a given content object. Called by Content::getParserOutput after parsing has finished. Can be used for changes that depend on the result of the parsing but have to be done before LinksUpdate is called(such as adding tracking categories based on the rendered HTML). $content:The Content to render $title:Title of the page, as context $parserOutput:ParserOutput to manipulate 'ContentGetParserOutput':Customize parser output for a given content object, called by AbstractContent::getParserOutput. May be used to override the normal model-specific rendering of page content. $content:The Content to render $title:Title of the page, as context $revId:The revision ID, as context $options:ParserOptions for rendering. To avoid confusing the parser cache, the output can only depend on parameters provided to this hook function, not on global state. $generateHtml:boolean, indicating whether full HTML should be generated. If false, generation of HTML may be skipped, but other information should still be present in the ParserOutput object. & $output:ParserOutput, to manipulate or replace 'ContentHandlerDefaultModelFor':Called when the default content model is determined for a given title. May be used to assign a different model for that title. $title:the Title in question & $model:the model name. Use with CONTENT_MODEL_XXX constants. 'ContentHandlerForModelID':Called when a ContentHandler is requested for a given content model name, but no entry for that model exists in $wgContentHandlers. Note:if your extension implements additional models via this hook, please use GetContentModels hook to make them known to core. $modeName:the requested content model name & $handler:set this to a ContentHandler object, if desired. 'ContentModelCanBeUsedOn':Called to determine whether that content model can be used on a given page. This is especially useful to prevent some content models to be used in some special location. $contentModel:ID of the content model in question $title:the Title in question. & $ok:Output parameter, whether it is OK to use $contentModel on $title. Handler functions that modify $ok should generally return false to prevent further hooks from further modifying $ok. 'ContribsPager::getQueryInfo':Before the contributions query is about to run & $pager:Pager object for contributions & $queryInfo:The query for the contribs Pager 'ContribsPager::reallyDoQuery':Called before really executing the query for My Contributions & $data:an array of results of all contribs queries $pager:The ContribsPager object hooked into $offset:Index offset, inclusive $limit:Exact query limit $descending:Query direction, false for ascending, true for descending 'ContributionsLineEnding':Called before a contributions HTML line is finished $page:SpecialPage object for contributions & $ret:the HTML line $row:the DB row for this line & $classes:the classes to add to the surrounding< li > & $attribs:associative array of other HTML attributes for the< li > element. Currently only data attributes reserved to MediaWiki are allowed(see Sanitizer::isReservedDataAttribute). 'ContributionsToolLinks':Change tool links above Special:Contributions $id:User identifier $title:User page title & $tools:Array of tool links $specialPage:SpecialPage instance for context and services. Can be either SpecialContributions or DeletedContributionsPage. Extensions should type hint against a generic SpecialPage though. 'ConvertContent':Called by AbstractContent::convert when a conversion to another content model is requested. Handler functions that modify $result should generally return false to disable further attempts at conversion. $content:The Content object to be converted. $toModel:The ID of the content model to convert to. $lossy:boolean indicating whether lossy conversion is allowed. & $result:Output parameter, in case the handler function wants to provide a converted Content object. Note that $result->getContentModel() must return $toModel. 'ContentSecurityPolicyDefaultSource':Modify the allowed CSP load sources. This affects all directives except for the script directive. If you want to add a script source, see ContentSecurityPolicyScriptSource hook. & $defaultSrc:Array of Content-Security-Policy allowed sources $policyConfig:Current configuration for the Content-Security-Policy header $mode:ContentSecurityPolicy::REPORT_ONLY_MODE or ContentSecurityPolicy::FULL_MODE depending on type of header 'ContentSecurityPolicyDirectives':Modify the content security policy directives. Use this only if ContentSecurityPolicyDefaultSource and ContentSecurityPolicyScriptSource do not meet your needs. & $directives:Array of CSP directives $policyConfig:Current configuration for the CSP header $mode:ContentSecurityPolicy::REPORT_ONLY_MODE or ContentSecurityPolicy::FULL_MODE depending on type of header 'ContentSecurityPolicyScriptSource':Modify the allowed CSP script sources. Note that you also have to use ContentSecurityPolicyDefaultSource if you want non-script sources to be loaded from whatever you add. & $scriptSrc:Array of CSP directives $policyConfig:Current configuration for the CSP header $mode:ContentSecurityPolicy::REPORT_ONLY_MODE or ContentSecurityPolicy::FULL_MODE depending on type of header 'CustomEditor':When invoking the page editor Return true to allow the normal editor to be used, or false if implementing a custom editor, e.g. for a special namespace, etc. $article:Article being edited $user:User performing the edit 'DatabaseOraclePostInit':Called after initialising an Oracle database $db:the DatabaseOracle object 'DeletedContribsPager::reallyDoQuery':Called before really executing the query for Special:DeletedContributions Similar to ContribsPager::reallyDoQuery & $data:an array of results of all contribs queries $pager:The DeletedContribsPager object hooked into $offset:Index offset, inclusive $limit:Exact query limit $descending:Query direction, false for ascending, true for descending 'DeletedContributionsLineEnding':Called before a DeletedContributions HTML line is finished. Similar to ContributionsLineEnding $page:SpecialPage object for DeletedContributions & $ret:the HTML line $row:the DB row for this line & $classes:the classes to add to the surrounding< li > & $attribs:associative array of other HTML attributes for the< li > element. Currently only data attributes reserved to MediaWiki are allowed(see Sanitizer::isReservedDataAttribute). 'DeleteUnknownPreferences':Called by the cleanupPreferences.php maintenance script to build a WHERE clause with which to delete preferences that are not known about. This hook is used by extensions that have dynamically-named preferences that should not be deleted in the usual cleanup process. For example, the Gadgets extension creates preferences prefixed with 'gadget-', and so anything with that prefix is excluded from the deletion. &where:An array that will be passed as the $cond parameter to IDatabase::select() to determine what will be deleted from the user_properties table. $db:The IDatabase object, useful for accessing $db->buildLike() etc. 'DifferenceEngineAfterLoadNewText':called in DifferenceEngine::loadNewText() after the new revision 's content has been loaded into the class member variable $differenceEngine->mNewContent but before returning true from this function. $differenceEngine:DifferenceEngine object 'DifferenceEngineLoadTextAfterNewContentIsLoaded':called in DifferenceEngine::loadText() after the new revision 's content has been loaded into the class member variable $differenceEngine->mNewContent but before checking if the variable 's value is null. This hook can be used to inject content into said class member variable. $differenceEngine:DifferenceEngine object 'DifferenceEngineMarkPatrolledLink':Allows extensions to change the "mark as patrolled" link which is shown both on the diff header as well as on the bottom of a page, usually wrapped in a span element which has class="patrollink". $differenceEngine:DifferenceEngine object & $markAsPatrolledLink:The "mark as patrolled" link HTML(string) $rcid:Recent change ID(rc_id) for this change(int) 'DifferenceEngineMarkPatrolledRCID':Allows extensions to possibly change the rcid parameter. For example the rcid might be set to zero due to the user being the same as the performer of the change but an extension might still want to show it under certain conditions. & $rcid:rc_id(int) of the change or 0 $differenceEngine:DifferenceEngine object $change:RecentChange object $user:User object representing the current user 'DifferenceEngineNewHeader':Allows extensions to change the $newHeader variable, which contains information about the new revision, such as the revision 's author, whether the revision was marked as a minor edit or not, etc. $differenceEngine:DifferenceEngine object & $newHeader:The string containing the various #mw-diff-otitle[1-5] divs, which include things like revision author info, revision comment, RevisionDelete link and more $formattedRevisionTools:Array containing revision tools, some of which may have been injected with the DiffRevisionTools hook $nextlink:String containing the link to the next revision(if any) $status
Definition: hooks.txt:1266
Wikimedia\Rdbms\Database
Relational database abstraction object.
Definition: Database.php:48
$user
return true to allow those checks to and false if checking is done & $user
Definition: hooks.txt:1476
MssqlInstaller\submitSettingsForm
submitSettingsForm()
Definition: MssqlInstaller.php:411
MssqlInstaller\$notMiniumumVerisonMessage
static $notMiniumumVerisonMessage
Definition: MssqlInstaller.php:55
MssqlInstaller\submitConnectForm
submitConnectForm()
Set variables based on the request array, assuming it was submitted via the form returned by getConne...
Definition: MssqlInstaller.php:143
MssqlInstaller\loginExists
loginExists( $user)
Try to see if the login exists.
Definition: MssqlInstaller.php:665
DatabaseInstaller\checkExtension
static checkExtension( $name)
Convenience function.
Definition: DatabaseInstaller.php:441
captcha-old.count
count
Definition: captcha-old.py:249
DatabaseInstaller\getConnection
getConnection()
Connect to the database using the administrative user/password currently defined in the session.
Definition: DatabaseInstaller.php:181
StatusValue\newFatal
static newFatal( $message)
Factory function for fatal errors.
Definition: StatusValue.php:68
MssqlInstaller\$webUserPrivs
$webUserPrivs
Definition: MssqlInstaller.php:60
DatabaseInstaller\getTextBox
getTextBox( $var, $label, $attribs=[], $helpData="")
Get a labelled text box to configure a local variable.
Definition: DatabaseInstaller.php:513
$s
$s
Definition: mergeMessageFileList.php:186
$res
$res
Definition: database.txt:21
MssqlInstaller\setupUser
setupUser()
Definition: MssqlInstaller.php:526
MssqlInstaller\createTables
createTables()
Create database tables from scratch.
Definition: MssqlInstaller.php:634
$wgDBpassword
$wgDBpassword
Database user's password.
Definition: DefaultSettings.php:1883
MssqlInstaller\getLocalSettings
getLocalSettings()
Get the DBMS-specific options for LocalSettings.php generation.
Definition: MssqlInstaller.php:727
php
injection txt This is an overview of how MediaWiki makes use of dependency injection The design described here grew from the discussion of RFC T384 The term dependency this means that anything an object needs to operate should be injected from the the object itself should only know narrow no concrete implementation of the logic it relies on The requirement to inject everything typically results in an architecture that based on two main types of and essentially stateless service objects that use other service objects to operate on the value objects As of the beginning MediaWiki is only starting to use the DI approach Much of the code still relies on global state or direct resulting in a highly cyclical dependency which acts as the top level factory for services in MediaWiki which can be used to gain access to default instances of various services MediaWikiServices however also allows new services to be defined and default services to be redefined Services are defined or redefined by providing a callback the instantiator that will return a new instance of the service When it will create an instance of MediaWikiServices and populate it with the services defined in the files listed by thereby bootstrapping the DI framework Per $wgServiceWiringFiles lists includes ServiceWiring php
Definition: injection.txt:35
MssqlInstaller\isCompiled
isCompiled()
Definition: MssqlInstaller.php:78
$wgDBWindowsAuthentication
$wgDBWindowsAuthentication
Use Windows Authentication instead of $wgDBuser / $wgDBpassword for MS SQL Server.
Definition: DefaultSettings.php:2176
DatabaseInstaller\getPasswordBox
getPasswordBox( $var, $label, $attribs=[], $helpData="")
Get a labelled password box to configure a local variable.
Definition: DatabaseInstaller.php:540
MssqlInstaller\getConnectForm
getConnectForm()
Definition: MssqlInstaller.php:85
MssqlInstaller\getSchemaVars
getSchemaVars()
Get variables to substitute into tables.sql and the SQL patch files.
Definition: MssqlInstaller.php:718
DatabaseInstaller\setupSchemaVars
setupSchemaVars()
Set appropriate schema variables in the current database connection.
Definition: DatabaseInstaller.php:341
use
as see the revision history and available at free of to any person obtaining a copy of this software and associated documentation to deal in the Software without including without limitation the rights to use
Definition: MIT-LICENSE.txt:10
Wikimedia\Rdbms\DBQueryError
Definition: DBQueryError.php:27
DatabaseInstaller\getRadioSet
getRadioSet( $params)
Get a set of labelled radio buttons.
Definition: DatabaseInstaller.php:592
MssqlInstaller\catalogExists
catalogExists( $catalogName)
Try to see if a given fulltext catalog exists We assume we already have the appropriate database sele...
Definition: MssqlInstaller.php:708
$name
Allows to change the fields on the form that will be generated $name
Definition: hooks.txt:271
MssqlInstaller\setupDatabase
setupDatabase()
Definition: MssqlInstaller.php:490
$e
div flags Integer display flags(NO_ACTION_LINK, NO_EXTRA_USER_LINKS) 'LogException' returning false will NOT prevent logging $e
Definition: hooks.txt:2162
MssqlInstaller\$globalNames
$globalNames
Definition: MssqlInstaller.php:36
MssqlInstaller\userExists
userExists( $user)
Try to see if the user account exists We assume we already have the appropriate database selected.
Definition: MssqlInstaller.php:676
DatabaseInstaller\getVar
getVar( $var, $default=null)
Get a variable, taking local defaults into account.
Definition: DatabaseInstaller.php:483
StatusValue\newGood
static newGood( $value=null)
Factory function for good results.
Definition: StatusValue.php:81
MssqlInstaller\preInstall
preInstall()
Allow DB installers a chance to make last-minute changes before installation occurs.
Definition: MssqlInstaller.php:478
MssqlInstaller\schemaExists
schemaExists( $schemaName)
Try to see if a given schema exists We assume we already have the appropriate database selected.
Definition: MssqlInstaller.php:697
DatabaseInstaller
Base class for DBMS-specific installation helper classes.
Definition: DatabaseInstaller.php:35
plain
either a plain
Definition: hooks.txt:2046
MssqlInstaller\preUpgrade
preUpgrade()
Allow DB installers a chance to make checks before upgrade.
Definition: MssqlInstaller.php:234
MssqlInstaller\databaseExists
databaseExists( $dbName)
Try to see if a given database exists.
Definition: MssqlInstaller.php:686
text
This list may contain false positives That usually means there is additional text with links below the first Each row contains links to the first and second as well as the first line of the second redirect text
Definition: All_system_messages.txt:1267
MssqlInstaller
Class for setting up the MediaWiki database using Microsoft SQL Server.
Definition: MssqlInstaller.php:34
MssqlInstaller\getName
getName()
Definition: MssqlInstaller.php:71
MssqlInstaller\openConnection
openConnection()
Definition: MssqlInstaller.php:201
MssqlInstaller\canCreateAccounts
canCreateAccounts()
Return true if the install user can create accounts.
Definition: MssqlInstaller.php:260
MssqlInstaller\$minimumVersion
static $minimumVersion
Definition: MssqlInstaller.php:54
as
This document is intended to provide useful advice for parties seeking to redistribute MediaWiki to end users It s targeted particularly at maintainers for Linux since it s been observed that distribution packages of MediaWiki often break We ve consistently had to recommend that users seeking support use official tarballs instead of their distribution s and this often solves whatever problem the user is having It would be nice if this could such as
Definition: distributors.txt:9
DatabaseInstaller\setVar
setVar( $name, $value)
Convenience alias for $this->parent->setVar()
Definition: DatabaseInstaller.php:500
DatabaseInstaller\setVarsFromRequest
setVarsFromRequest( $varNames)
Convenience function to set variables based on form data.
Definition: DatabaseInstaller.php:606
Wikimedia\Rdbms\DBConnectionError
Definition: DBConnectionError.php:26
LocalSettingsGenerator\escapePhpString
static escapePhpString( $string)
Returns the escaped version of a string of php code.
Definition: LocalSettingsGenerator.php:112
MssqlInstaller\getGlobalDefaults
getGlobalDefaults()
Get a name=>value map of MW configuration globals for the default values.
Definition: MssqlInstaller.php:652
$wgDBuser
$wgDBuser
Database username.
Definition: DefaultSettings.php:1878
DatabaseInstaller\$db
Database $db
The database connection.
Definition: DatabaseInstaller.php:61
MssqlInstaller\getSettingsForm
getSettingsForm()
Definition: MssqlInstaller.php:357
wfMessage
either a unescaped string or a HtmlArmor object after in associative array form externallinks including delete and has completed for all link tables whether this was an auto creation use $formDescriptor instead default is conds Array Extra conditions for the No matching items in log is displayed if loglist is empty msgKey Array If you want a nice box with a set this to the key of the message First element is the message additional optional elements are parameters for the key that are processed with wfMessage() -> params() ->parseAsBlock() - offset Set to overwrite offset parameter in $wgRequest set to '' to unset offset - wrap String Wrap the message in html(usually something like "&lt
MssqlInstaller\$internalDefaults
$internalDefaults
Definition: MssqlInstaller.php:46
DatabaseInstaller\getCheckBox
getCheckBox( $var, $label, $attribs=[], $helpData="")
Get a labelled checkbox to configure a local boolean variable.
Definition: DatabaseInstaller.php:566