public static function install($data, &$fail, &$errno, &$error)
{
// Datenbank einrichten
if (!isset($data['action']) || $data['action'] != 'update') {
if (!$fail && (isset($data['DB']['db_override']) && $data['DB']['db_override'] === 'override')) {
$sql = "DROP SCHEMA IF EXISTS `" . $data['DB']['db_name'] . "`;";
$oldName = $data['DB']['db_name'];
$data['DB']['db_name'] = null;
$result = DBRequest::request($sql, false, $data);
if ($result["errno"] !== 0) {
$fail = true;
$errno = $result["errno"];
$error = isset($result["error"]) ? $result["error"] : '';
}
$data['DB']['db_name'] = $oldName;
}
}
if (!$fail) {
$add = isset($data['DB']['db_ignore']) && $data['DB']['db_ignore'] === 'ignore' || isset($data['action']) && $data['action'] == 'update' ? 'IF NOT EXISTS ' : '';
$sql = "CREATE SCHEMA {$add}`" . $data['DB']['db_name'] . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;";
$oldName = $data['DB']['db_name'];
$data['DB']['db_name'] = null;
$result = DBRequest::request($sql, false, $data);
if ($result["errno"] !== 0) {
$fail = true;
$errno = $result["errno"];
$error = isset($result["error"]) ? $result["error"] : '';
}
$data['DB']['db_name'] = $oldName;
}
// CControl+DBQuery2 einrichten
$res = array();
if (!$fail) {
$list = array('DB/CControl', 'DB/DBQuery2');
$platform = Installation::PlattformZusammenstellen($data);
for ($i = 0; $i < count($list); $i++) {
$url = $list[$i];
//$data['PL']['init'];
// inits all components
$result = Request::post($data['PL']['url'] . '/' . $url . '/platform', array(), Platform::encodePlatform($platform));
$res[$url] = array();
if (isset($result['content']) && isset($result['status']) && $result['status'] === 201) {
$res[$url]['status'] = 201;
} else {
$res[$url]['status'] = 409;
$fail = true;
if (isset($result['status'])) {
$errno = $result['status'];
$res[$url]['status'] = $result['status'];
}
///if (isset($result['content'])) echo $result['content'];
}
}
}
return $res;
}
public static function install($data, &$fail, &$errno, &$error)
{
if (!$fail && (isset($data['action']) && $data['action'] == 'update' || isset($data['DB']['db_user_override_operator']) && $data['DB']['db_user_override_operator'] === 'override')) {
$oldName = $data['DB']['db_name'];
$data['DB']['db_name'] = null;
$sql = "DROP USER '{$data['DB']['db_user_operator']}'@'%';";
$sql2 = "DROP USER '{$data['DB']['db_user_operator']}'@'localhost';";
$result = DBRequest::request2($sql, false, $data);
$result = DBRequest::request2($sql2, false, $data);
/*if ($result["errno"] !== 0){
$fail = true; $errno = $result["errno"];$error = isset($result["error"]) ? $result["error"] : '';
}*/
$data['DB']['db_name'] = $oldName;
}
$userExists = false;
if (!$fail) {
$oldName = $data['DB']['db_name'];
$data['DB']['db_name'] = null;
$sql = "SELECT count(1) as 'exists' FROM mysql.user WHERE user = '******'DB']['db_user_operator']}';";
$result = DBRequest::request($sql, false, $data);
if ($result["errno"] !== 0 || !isset($result["content"])) {
$fail = true;
$errno = $result["errno"];
$error = isset($result["error"]) ? $result["error"] : '';
} else {
$result = DBJson::getRows($result['content']);
if (count($result) > 0 && isset($result[0]['exists']) && $result[0]['exists'] > 0) {
$userExists = true;
}
}
$data['DB']['db_name'] = $oldName;
}
if (!$fail && !$userExists) {
$oldName = $data['DB']['db_name'];
$data['DB']['db_name'] = null;
$sql = "GRANT CREATE VIEW,EXECUTE,ALTER ROUTINE,CREATE ROUTINE,SHOW VIEW,CREATE TEMPORARY TABLES,INDEX,ALTER,SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,TRIGGER " . "ON `{$oldName}`.* " . "TO '{$data['DB']['db_user_operator']}'@'%' " . "IDENTIFIED BY '{$data['DB']['db_passwd_operator']}';";
$sql .= "GRANT CREATE VIEW,EXECUTE,ALTER ROUTINE,CREATE ROUTINE,SHOW VIEW,CREATE TEMPORARY TABLES,INDEX,ALTER,SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,TRIGGER " . "ON `{$oldName}`.* " . "TO '{$data['DB']['db_user_operator']}'@'localhost' " . "IDENTIFIED BY '{$data['DB']['db_passwd_operator']}';";
$result = DBRequest::request2($sql, false, $data);
if ($result[0]["errno"] !== 0 && (count($result) < 2 || $result[1]["errno"] !== 0)) {
$fail = true;
$errno = $result[0]["errno"];
$error = isset($result[0]["error"]) ? $result[0]["error"] : '';
}
$data['DB']['db_name'] = $oldName;
} elseif ($userExists) {
$fail = true;
$errno = 0;
$error = 'user already exists';
}
return null;
}
public static function install($data, &$fail, &$errno, &$error)
{
if (!$fail) {
$auth = new Authentication();
$salt = $auth->generateSalt();
$passwordHash = $auth->hashPassword($data['DB']['db_passwd_insert'], $salt);
$sql = "INSERT INTO `User` (`U_id`, `U_username`, `U_email`, `U_lastName`, `U_firstName`, `U_title`, `U_password`, `U_flag`, `U_salt`, `U_failed_logins`, `U_externalId`, `U_studentNumber`, `U_isSuperAdmin`, `U_comment`) VALUES (NULL, '{$data['DB']['db_user_insert']}', '{$data['DB']['db_email_insert']}', '{$data['DB']['db_last_name_insert']}', '{$data['DB']['db_first_name_insert']}', NULL, '{$passwordHash}', 1, '{$salt}', 0, NULL, NULL, 1, NULL);";
$result = DBRequest::request($sql, false, $data);
if ($result["errno"] !== 0) {
$fail = true;
$errno = $result["errno"];
$error = isset($result["error"]) ? $result["error"] : '';
}
}
return null;
}
public function getTableReferences()
{
Logger::Log('starts GET GetTableReferences', LogLevel::DEBUG);
if (!file_exists(dirname(__FILE__) . '/config.ini')) {
$this->_app->response->setStatus(409);
$this->_app->stop();
}
$conf = parse_ini_file(dirname(__FILE__) . '/config.ini', TRUE);
// starts a query
ob_start();
eval("?>" . file_get_contents(dirname(__FILE__) . '/Sql/GetTableReferences.sql'));
$sql = ob_get_contents();
ob_end_clean();
$result = DBRequest::request($sql, false, $conf);
// checks the correctness of the query
if ((!isset($result['errno']) || !$result['errno']) && $result['content']) {
$data = DBJson::getRows($result['content']);
$res = array();
foreach ($data as $dat) {
if (!isset($res)) {
$res[$dat['table_name']] = array();
}
$res[$dat['table_name']][] = $dat['referenced_table_name'];
}
$this->_app->response->setStatus(200);
$this->_app->response->setBody(json_encode($res));
} else {
Logger::Log('GET GetTableReferences failed', LogLevel::ERROR);
$this->_app->response->setStatus(409);
$this->_app->response->setBody('');
$this->_app->stop();
}
}
