-<?php\r
-/**\r
- * IBM_DB2-specific installer.\r
- *\r
- * @file\r
- * @ingroup Deployment\r
- */\r
-\r
-/**\r
- * Class for setting up the MediaWiki database using IBM_DB2.\r
- *\r
- * @ingroup Deployment\r
- * @since 1.17\r
- */\r
-class Ibm_db2Installer extends DatabaseInstaller {\r
-\r
-\r
- protected $globalNames = array(\r
- 'wgDBserver',\r
- 'wgDBport',\r
- 'wgDBname',\r
- 'wgDBuser',\r
- 'wgDBpassword',\r
- 'wgDBmwschema',\r
- );\r
-\r
- /**\r
- * Get the DB2 database extension name\r
- * @return string\r
- */\r
- public function getName(){\r
- return 'ibm_db2';\r
- }\r
-\r
- /**\r
- * Determine whether the DB2 database extension is currently available in PHP\r
- * @return boolean\r
- */\r
- public function isCompiled() {\r
- return self::checkExtension( 'ibm_db2' );\r
- }\r
-\r
- /**\r
- * Generate a connection form for a DB2 database\r
- * @return string\r
- */\r
- public function getConnectForm() {\r
- return\r
- $this->getTextBox( 'wgDBserver', 'config-db-host', array(), $this->parent->getHelpBox( 'config-db-host-help' ) ) .\r
- $this->getTextBox( 'wgDBport', 'config-db-port', array(), $this->parent->getHelpBox( 'config-db-port' ) ) .\r
- Html::openElement( 'fieldset' ) .\r
- Html::element( 'legend', array(), wfMsg( 'config-db-wiki-settings' ) ) .\r
- $this->getTextBox( 'wgDBname', 'config-db-name', array(), $this->parent->getHelpBox( 'config-db-name-help' ) ) .\r
- $this->getTextBox( 'wgDBmwschema', 'config-db-schema', array(), $this->parent->getHelpBox( 'config-db-schema-help' ) ) .\r
- Html::closeElement( 'fieldset' ) .\r
- $this->getInstallUserBox();\r
- }\r
-\r
- /**\r
- * Validate and then execute the connection form for a DB2 database\r
- * @return Status\r
- */\r
- public function submitConnectForm() {\r
- // Get variables from the request\r
- $newValues = $this->setVarsFromRequest( \r
- array( 'wgDBserver', 'wgDBport', 'wgDBname', \r
- 'wgDBmwschema', 'wgDBuser', 'wgDBpassword' ) );\r
-\r
- // Validate them\r
- $status = Status::newGood();\r
- if ( !strlen( $newValues['wgDBname'] ) ) {\r
- $status->fatal( 'config-missing-db-name' );\r
- } elseif ( !preg_match( '/^[a-zA-Z0-9_]+$/', $newValues['wgDBname'] ) ) {\r
- $status->fatal( 'config-invalid-db-name', $newValues['wgDBname'] );\r
- }\r
- if ( !strlen( $newValues['wgDBmwschema'] ) ) {\r
- $status->fatal( 'config-invalid-schema' );\r
- }\r
- elseif ( !preg_match( '/^[a-zA-Z0-9_]*$/', $newValues['wgDBmwschema'] ) ) {\r
- $status->fatal( 'config-invalid-schema', $newValues['wgDBmwschema'] );\r
- }\r
- if ( !strlen( $newValues['wgDBport'] ) ) {\r
- $status->fatal( 'config-invalid-port' );\r
- }\r
- elseif ( !preg_match( '/^[0-9_]*$/', $newValues['wgDBport'] ) ) {\r
- $status->fatal( 'config-invalid-port', $newValues['wgDBport'] );\r
- }\r
-\r
- // Submit user box\r
- if ( $status->isOK() ) {\r
- $status->merge( $this->submitInstallUserBox() );\r
- }\r
- if ( !$status->isOK() ) {\r
- return $status;\r
- }\r
-\r
- global $wgDBport;\r
- $wgDBport = $newValues['wgDBport'];\r
-\r
- // Try to connect\r
- $status->merge( $this->getConnection() );\r
- if ( !$status->isOK() ) {\r
- return $status;\r
- }\r
-\r
- $this->parent->setVar( 'wgDBuser', $this->getVar( '_InstallUser' ) );\r
- $this->parent->setVar( 'wgDBpassword', $this->getVar( '_InstallPassword' ) );\r
-\r
- return $status;\r
- \r
- }\r
-\r
- /**\r
- * Open a DB2 database connection\r
- * @return Status\r
- */\r
- public function openConnection() {\r
- $status = Status::newGood();\r
- try {\r
- $db = new DatabaseIbm_db2(\r
- $this->getVar( 'wgDBserver' ),\r
- $this->getVar( '_InstallUser' ),\r
- $this->getVar( '_InstallPassword' ),\r
- $this->getVar( 'wgDBname' ),\r
- 0,\r
- $this->getVar( 'wgDBmwschema' )\r
- );\r
- $status->value = $db;\r
- } catch ( DBConnectionError $e ) {\r
- $status->fatal( 'config-connection-error', $e->getMessage() );\r
- }\r
- return $status;\r
- }\r
-\r
- /**\r
- * Create a DB2 database for MediaWiki\r
- * @return Status\r
- */\r
- public function setupDatabase() {\r
- $status = $this->getConnection();\r
- if ( !$status->isOK() ) {\r
- return $status;\r
- }\r
- $conn = $status->value;\r
- $dbName = $this->getVar( 'wgDBname' );\r
- if( !$conn->selectDB( $dbName ) ) {\r
- $conn->query( "CREATE DATABASE "\r
- . $conn->addIdentifierQuotes( $dbName ) \r
- . " AUTOMATIC STORAGE YES"\r
- . " USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM"\r
- . " PAGESIZE 32768", __METHOD__ );\r
- $conn->selectDB( $dbName );\r
- }\r
- $this->setupSchemaVars();\r
- return $status;\r
- }\r
-\r
- /**\r
- * Create tables from scratch.\r
- * First check if pagesize >= 32k.\r
- *\r
- * @return Status\r
- */\r
- public function createTables() {\r
- $status = $this->getConnection();\r
- if ( !$status->isOK() ) {\r
- return $status;\r
- }\r
- $this->db->selectDB( $this->getVar( 'wgDBname' ) );\r
-\r
- if( $this->db->tableExists( 'user' ) ) {\r
- $status->warning( 'config-install-tables-exist' );\r
- return $status;\r
- }\r
-\r
- /* Check for pagesize */\r
- $status = $this->checkPageSize();\r
- if ( !$status->isOK() ) {\r
- return $status;\r
- }\r
-\r
- $this->db->setFlag( DBO_DDLMODE ); // For Oracle's handling of schema files\r
- $this->db->begin( __METHOD__ );\r
-\r
- $error = $this->db->sourceFile( $this->db->getSchema() );\r
- if( $error !== true ) {\r
- $this->db->reportQueryError( $error, 0, '', __METHOD__ );\r
- $this->db->rollback( __METHOD__ );\r
- $status->fatal( 'config-install-tables-failed', $error );\r
- } else {\r
- $this->db->commit( __METHOD__ );\r
- }\r
- // Resume normal operations\r
- if( $status->isOk() ) {\r
- $this->enableLB();\r
- }\r
- return $status;\r
- }\r
-\r
- /**\r
- * Check if database has a tablspace with pagesize >= 32k.\r
- *\r
- * @return Status\r
- */\r
- public function checkPageSize() {\r
- $status = $this->getConnection();\r
- if ( !$status->isOK() ) {\r
- return $status;\r
- }\r
- $this->db->selectDB( $this->getVar( 'wgDBname' ) );\r
-\r
- try {\r
- $result = $this->db->query( 'SELECT PAGESIZE FROM SYSCAT.TABLESPACES' );\r
- if( $result == false ) {\r
- $status->fatal( 'config-connection-error', '' );\r
- }\r
- else {\r
- $nRows = $this->db->numRows( $result );\r
- while ( $row = $row = $this->db->fetchRow( $result ) ) {\r
- if( $row[0] >= 32768 ) {\r
- return $status;\r
- }\r
- }\r
- $status->fatal( 'config-ibm_db2-low-db-pagesize', '' );\r
- }\r
- } catch ( DBUnexpectedError $e ) {\r
- $status->fatal( 'config-connection-error', $e->getMessage() );\r
- }\r
-\r
- return $status;\r
- }\r
-\r
- /**\r
- * Generate the code to store the DB2-specific settings defined by the configuration form\r
- * @return string\r
- */\r
- public function getLocalSettings() {\r
- $schema = LocalSettingsGenerator::escapePhpString( $this->getVar( 'wgDBmwschema' ) );\r
- $port = LocalSettingsGenerator::escapePhpString( $this->getVar( 'wgDBport' ) );\r
- return\r
-"# IBM_DB2 specific settings\r
-\$wgDBmwschema = \"{$schema}\";\r
-\$wgDBport = \"{$port}\";";\r
- }\r
-\r
- public function __construct($parent) {\r
- parent::__construct($parent);\r
- }\r
-}\r
-?>\r
+<?php
+/**
+ * IBM_DB2-specific installer.
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License along
+ * with this program; if not, write to the Free Software Foundation, Inc.,
+ * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
+ * http://www.gnu.org/copyleft/gpl.html
+ *
+ * @file
+ * @ingroup Deployment
+ */
+
+/**
+ * Class for setting up the MediaWiki database using IBM_DB2.
+ *
+ * @ingroup Deployment
+ * @since 1.17
+ */
+class Ibm_db2Installer extends DatabaseInstaller {
+
+
+ protected $globalNames = array(
+ 'wgDBserver',
+ 'wgDBport',
+ 'wgDBname',
+ 'wgDBuser',
+ 'wgDBpassword',
+ 'wgDBmwschema',
+ );
+
+ protected $internalDefaults = array(
+ '_InstallUser' => 'db2admin'
+ );
+
+ /**
+ * Get the DB2 database extension name
+ * @return string
+ */
+ public function getName() {
+ return 'ibm_db2';
+ }
+
+ /**
+ * Determine whether the DB2 database extension is currently available in PHP
+ * @return boolean
+ */
+ public function isCompiled() {
+ return self::checkExtension( 'ibm_db2' );
+ }
+
+ /**
+ * Generate a connection form for a DB2 database
+ * @return string
+ */
+ public function getConnectForm() {
+ return
+ $this->getTextBox( 'wgDBserver', 'config-db-host', array(), $this->parent->getHelpBox( 'config-db-host-help' ) ) .
+ $this->getTextBox( 'wgDBport', 'config-db-port', array(), $this->parent->getHelpBox( 'config-db-port' ) ) .
+ Html::openElement( 'fieldset' ) .
+ Html::element( 'legend', array(), wfMessage( 'config-db-wiki-settings' )->text() ) .
+ $this->getTextBox( 'wgDBname', 'config-db-name', array(), $this->parent->getHelpBox( 'config-db-name-help' ) ) .
+ $this->getTextBox( 'wgDBmwschema', 'config-db-schema', array(), $this->parent->getHelpBox( 'config-db-schema-help' ) ) .
+ Html::closeElement( 'fieldset' ) .
+ $this->getInstallUserBox();
+ }
+
+ /**
+ * Validate and then execute the connection form for a DB2 database
+ * @return Status
+ */
+ public function submitConnectForm() {
+ // Get variables from the request
+ $newValues = $this->setVarsFromRequest(
+ array( 'wgDBserver', 'wgDBport', 'wgDBname',
+ 'wgDBmwschema', 'wgDBuser', 'wgDBpassword' ) );
+
+ // Validate them
+ $status = Status::newGood();
+ if ( !strlen( $newValues['wgDBname'] ) ) {
+ $status->fatal( 'config-missing-db-name' );
+ } elseif ( !preg_match( '/^[a-zA-Z0-9_]+$/', $newValues['wgDBname'] ) ) {
+ $status->fatal( 'config-invalid-db-name', $newValues['wgDBname'] );
+ }
+ if ( !strlen( $newValues['wgDBmwschema'] ) ) {
+ $status->fatal( 'config-invalid-schema' );
+ }
+ elseif ( !preg_match( '/^[a-zA-Z0-9_]*$/', $newValues['wgDBmwschema'] ) ) {
+ $status->fatal( 'config-invalid-schema', $newValues['wgDBmwschema'] );
+ }
+ if ( !strlen( $newValues['wgDBport'] ) ) {
+ $status->fatal( 'config-invalid-port' );
+ }
+ elseif ( !preg_match( '/^[0-9_]*$/', $newValues['wgDBport'] ) ) {
+ $status->fatal( 'config-invalid-port', $newValues['wgDBport'] );
+ }
+
+ // Submit user box
+ if ( $status->isOK() ) {
+ $status->merge( $this->submitInstallUserBox() );
+ }
+ if ( !$status->isOK() ) {
+ return $status;
+ }
+
+ global $wgDBport;
+ $wgDBport = $newValues['wgDBport'];
+
+ // Try to connect
+ $status->merge( $this->getConnection() );
+ if ( !$status->isOK() ) {
+ return $status;
+ }
+
+ $this->parent->setVar( 'wgDBuser', $this->getVar( '_InstallUser' ) );
+ $this->parent->setVar( 'wgDBpassword', $this->getVar( '_InstallPassword' ) );
+
+ return $status;
+ }
+
+ /**
+ * Open a DB2 database connection
+ * @return Status
+ */
+ public function openConnection() {
+ $status = Status::newGood();
+ try {
+ $db = new DatabaseIbm_db2(
+ $this->getVar( 'wgDBserver' ),
+ $this->getVar( '_InstallUser' ),
+ $this->getVar( '_InstallPassword' ),
+ $this->getVar( 'wgDBname' ),
+ 0,
+ $this->getVar( 'wgDBmwschema' )
+ );
+ $status->value = $db;
+ } catch ( DBConnectionError $e ) {
+ $status->fatal( 'config-connection-error', $e->getMessage() );
+ }
+ return $status;
+ }
+
+ /**
+ * Create a DB2 database for MediaWiki
+ * @return Status
+ */
+ public function setupDatabase() {
+ $status = $this->getConnection();
+ if ( !$status->isOK() ) {
+ return $status;
+ }
+ /**
+ * @var $conn DatabaseBase
+ */
+ $conn = $status->value;
+ $dbName = $this->getVar( 'wgDBname' );
+ if( !$conn->selectDB( $dbName ) ) {
+ $conn->query( "CREATE DATABASE "
+ . $conn->addIdentifierQuotes( $dbName )
+ . " AUTOMATIC STORAGE YES"
+ . " USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM"
+ . " PAGESIZE 32768", __METHOD__ );
+ $conn->selectDB( $dbName );
+ }
+ $this->setupSchemaVars();
+ return $status;
+ }
+
+ /**
+ * Create tables from scratch.
+ * First check if pagesize >= 32k.
+ *
+ * @return Status
+ */
+ public function createTables() {
+ $status = $this->getConnection();
+ if ( !$status->isOK() ) {
+ return $status;
+ }
+ $this->db->selectDB( $this->getVar( 'wgDBname' ) );
+
+ if( $this->db->tableExists( 'user' ) ) {
+ $status->warning( 'config-install-tables-exist' );
+ return $status;
+ }
+
+ /* Check for pagesize */
+ $status = $this->checkPageSize();
+ if ( !$status->isOK() ) {
+ return $status;
+ }
+
+ $this->db->setFlag( DBO_DDLMODE ); // For Oracle's handling of schema files
+ $this->db->begin( __METHOD__ );
+
+ $error = $this->db->sourceFile( $this->db->getSchemaPath() );
+ if( $error !== true ) {
+ $this->db->reportQueryError( $error, 0, '', __METHOD__ );
+ $this->db->rollback( __METHOD__ );
+ $status->fatal( 'config-install-tables-failed', $error );
+ } else {
+ $this->db->commit( __METHOD__ );
+ }
+ // Resume normal operations
+ if( $status->isOk() ) {
+ $this->enableLB();
+ }
+ return $status;
+ }
+
+ /**
+ * Check if database has a tablspace with pagesize >= 32k.
+ *
+ * @return Status
+ */
+ public function checkPageSize() {
+ $status = $this->getConnection();
+ if ( !$status->isOK() ) {
+ return $status;
+ }
+ $this->db->selectDB( $this->getVar( 'wgDBname' ) );
+
+ try {
+ $result = $this->db->query( 'SELECT PAGESIZE FROM SYSCAT.TABLESPACES FOR READ ONLY' );
+ if( $result == false ) {
+ $status->fatal( 'config-connection-error', '' );
+ } else {
+ $row = $this->db->fetchRow( $result );
+ while ( $row ) {
+ if( $row[0] >= 32768 ) {
+ return $status;
+ }
+ $row = $this->db->fetchRow( $result );
+ }
+ $status->fatal( 'config-ibm_db2-low-db-pagesize', '' );
+ }
+ } catch ( DBUnexpectedError $e ) {
+ $status->fatal( 'config-connection-error', $e->getMessage() );
+ }
+
+ return $status;
+ }
+
+ /**
+ * Generate the code to store the DB2-specific settings defined by the configuration form
+ * @return string
+ */
+ public function getLocalSettings() {
+ $schema = LocalSettingsGenerator::escapePhpString( $this->getVar( 'wgDBmwschema' ) );
+ $port = LocalSettingsGenerator::escapePhpString( $this->getVar( 'wgDBport' ) );
+ return
+"# IBM_DB2 specific settings
+\$wgDBmwschema = \"{$schema}\";
+\$wgDBport = \"{$port}\";";
+ }
+
+ public function __construct( $parent ) {
+ parent::__construct( $parent );
+ }
+}
dépôts / lhc / web / wiklou.git / blobdiff