MediaWiki REL1_30
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.
153 $status = Status::newGood();
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() {
203 $status = Status::newGood();
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}
$wgDBuser
Database username.
$wgDBWindowsAuthentication
Use Windows Authentication instead of $wgDBuser / $wgDBpassword for MS SQL Server.
$wgDBpassword
Database user's password.
Base class for DBMS-specific installation helper classes.
static checkExtension( $name)
Convenience function.
Database $db
The database connection.
getPasswordBox( $var, $label, $attribs=[], $helpData="")
Get a labelled password box to configure a local variable.
setVarsFromRequest( $varNames)
Convenience function to set variables based on form data.
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.
getVar( $var, $default=null)
Get a variable, taking local defaults into account.
getTextBox( $var, $label, $attribs=[], $helpData="")
Get a labelled text box to configure a local variable.
setVar( $name, $value)
Convenience alias for $this->parent->setVar()
setupSchemaVars()
Set appropriate schema variables in the current database connection.
getRadioSet( $params)
Get a set of labelled radio buttons.
Class for setting up the MediaWiki database using Microsoft SQL Server.
canCreateAccounts()
Return true if the install user can create accounts.
getSchemaVars()
Get variables to substitute into tables.sql and the SQL patch files.
getLocalSettings()
Get the DBMS-specific options for LocalSettings.php generation.
userExists( $user)
Try to see if the user account exists We assume we already have the appropriate database selected.
getGlobalDefaults()
Get a name=>value map of MW configuration globals for the default values.
catalogExists( $catalogName)
Try to see if a given fulltext catalog exists We assume we already have the appropriate database sele...
databaseExists( $dbName)
Try to see if a given database exists.
preInstall()
Allow DB installers a chance to make last-minute changes before installation occurs.
createTables()
Create database tables from scratch.
loginExists( $user)
Try to see if the login exists.
static $notMiniumumVerisonMessage
preUpgrade()
Allow DB installers a chance to make checks before upgrade.
submitConnectForm()
Set variables based on the request array, assuming it was submitted via the form returned by getConne...
schemaExists( $schemaName)
Try to see if a given schema exists We assume we already have the appropriate database selected.
Relational database abstraction object.
Definition Database.php:45
$res
Definition database.txt:21
design txt This is a brief overview of the new design More thorough and up to date information is available on the documentation wiki at etc Handles the details of getting and saving to the user table of the and dealing with sessions and cookies OutputPage Encapsulates the entire HTML page that will be sent in response to any server request It is used by calling its functions to add text
Definition design.txt:18
either a plain
Definition hooks.txt:2026
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 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;div ...>$1&lt;/div>"). - flags Integer display flags(NO_ACTION_LINK, NO_EXTRA_USER_LINKS) 'LogException':Called before an exception(or PHP error) is logged. This is meant for integration with external error aggregation services
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. '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). '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:1049
returning false will NOT prevent logging $e
Definition hooks.txt:2146