/**
* execute the installation steps
*
* @return boolean
*/
function install($aConfig)
{
$this->oLogger->setLogFile('install.log');
$this->oLogger->deleteLogFile();
// Always use lower case prefixes for new installs
$aConfig['table']['prefix'] = strtolower($aConfig['table']['prefix']);
if ($aConfig['database']['localsocket'] == true) {
$aConfig['database']['protocol'] = 'unix';
} else {
$aConfig['database']['protocol'] = 'tcp';
}
$this->aDsn['database'] = $aConfig['database'];
$this->aDsn['table'] = $aConfig['table'];
$this->oLogger->log('Installation started ' . OA::getNow());
$this->oLogger->log('Attempting to connect to database ' . $this->aDsn['database']['name'] . ' with user ' . $this->aDsn['database']['username']);
if (!$this->_createDatabase()) {
$this->oLogger->logError('Installation failed to create the database ' . stripslashes($this->aDsn['database']['name']));
return false;
}
$this->oLogger->log('Connected to database ' . $this->oDbh->connected_database_name);
/**
* validate table prefix before creating DB since it does not
* make much sense to create a DB and then be unable to add tables
*/
if (PEAR::isError(OA_DB::validateTableName($aConfig['table']['prefix']))) {
$this->oLogger->logError('Illegal characters in table prefix ' . stripslashes($aConfig['table']['prefix']));
return false;
}
if (!$this->checkExistingTables()) {
if (!$this->oLogger->errorExists) {
$this->oLogger->logError();
}
return false;
}
if (!$this->checkPermissionToCreateTable()) {
$this->oLogger->logError('Insufficient database permissions or incorrect database settings to install');
return false;
}
if (!$this->initDatabaseConnection()) {
$this->oLogger->logError('Installation failed to connect to the database ' . $this->aDsn['database']['name']);
$this->_dropDatabase();
return false;
}
$aConfig = $this->initDatabaseParameters($aConfig);
if (!$this->createCoreTables()) {
$this->oLogger->logError('Installation failed to create the core tables');
$this->_dropDatabase();
return false;
}
$this->oLogger->log('Installation created the core tables');
$this->oAuditor->setKeyParams(array('upgrade_name' => 'install_' . OA_VERSION, 'version_to' => OA_VERSION, 'version_from' => 0, 'logfile' => basename($this->oLogger->logFile)));
if (!$this->oVersioner->putSchemaVersion('tables_core', $this->oTable->aDefinition['version'])) {
$this->_auditInstallationFailure('Installation failed to update the schema version to ' . $oTable->aDefinition['version']);
$this->_dropDatabase();
return false;
}
$this->oLogger->log('Installation updated the schema version to ' . $this->oTable->aDefinition['version']);
if (!$this->oVersioner->putApplicationVersion(OA_VERSION)) {
$this->_auditInstallationFailure('Installation failed to update the application version to ' . OA_VERSION);
$this->_dropDatabase();
return false;
}
$this->oLogger->log('Installation updated the application version to ' . OA_VERSION);
$this->oConfiguration->getInitialConfig();
if (!$this->saveConfigDB($aConfig)) {
$this->_auditInstallationFailure('Installation failed to write database details to the configuration file ' . $this->oConfiguration->configFile);
if (file_exists($this->oConfiguration->configPath . $this->oConfiguration->configFile)) {
@unlink($this->oConfiguration->configPath . $this->oConfiguration->configFile);
$this->oLogger->log('Installation deleted the configuration file ' . $this->oConfiguration->configFile);
}
$this->_dropDatabase();
return false;
}
$this->oAuditor->logAuditAction(array('description' => 'UPGRADE_COMPLETE', 'action' => UPGRADE_ACTION_UPGRADE_SUCCEEDED));
if ($this->upgrading_from_milestone_version) {
if (!$this->removeUpgradeTriggerFile()) {
$this->oLogger->log('failed to remove the UPGRADE trigger file');
}
}
return true;
}
/**
* Method to test function validateDatabaseName in MDB2 Manager modules
*/
function testValidateTableName()
{
$aConf = $GLOBALS['_MAX']['CONF'];
OA::disableErrorHandling();
$vals = array(0, 32, 33, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 58, 59, 60, 61, 62, 63, 64, 91, 92, 93, 94, 96, 123, 124, 125, 126, 156, 255);
//$pattern = '';
foreach ($vals as $i) {
//$pattern.= '\\x'.dechex($i);
$result = OA_DB::validateTableName('o' . chr($i) . '_table');
$this->assertTrue(PEAR::isError($result), 'chr(' . $i . ') /' . dechex($i));
}
if ($aConf['database']['type'] == 'mysql') {
$result = OA_DB::validateTableName('abcdefghij1234567890123456789012345678901234567890123456789012345');
//65 chars
$this->assertTrue(PEAR::isError($result));
$this->assertTrue(OA_DB::validateTableName('abcdefghij123456789012345678901234567890123456789012345678901234'));
//64 chars
$this->assertTrue(OA_DB::validateTableName('aBcDeFgHiJkLmNoPqRsTuVwXyZ_$1234567890'));
$result = OA_DB::validateTableName('2_$');
$this->assertFalse(PEAR::isError($result));
$result = OA_DB::validateTableName('$_2');
$this->assertFalse(PEAR::isError($result));
$result = OA_DB::validateTableName('_$2');
$this->assertFalse(PEAR::isError($result));
}
if ($aConf['database']['type'] == 'pgsql') {
$result = OA_DB::validateTableName('abcdefghij123456789012345678901234567890123456789012345678901234');
//64 chars
$this->assertTrue(PEAR::isError($result));
$this->assertTrue(OA_DB::validateTableName('abcdefghij12345678901234567890123456789012345678901234567890123'));
//63 chars
$result = OA_DB::validateTableName('0x_table');
$this->assertTrue(PEAR::isError($result));
$result = OA_DB::validateTableName(' x_table');
$this->assertTrue(PEAR::isError($result));
$this->assertTrue(OA_DB::validateTableName('aBcDeFgHiJkLmNoPqRsTuVwXyZ_$1234567890'));
$result = OA_DB::validateTableName('2_$');
$this->assertTrue(PEAR::isError($result));
$result = OA_DB::validateTableName('$_2');
$this->assertTrue(PEAR::isError($result));
$result = OA_DB::validateTableName('_$2');
$this->assertFalse(PEAR::isError($result));
}
OA::enableErrorHandling();
}
