public static function deleteFeedbackByNode($node_whole, $idc) { if ($node_whole === NULL || $idc === NULL) { QconfMgrLog::err(__FILE__, __LINE__, "Parameter 'node_whole' or 'idc' is NULL"); return FALSE; } ArgsUtil::setSQLEscape($node_whole); ArgsUtil::setSQLEscape($idc); $update = "delete from qconf_feedback where node_whole='{$node_whole}' and idc='{$idc}'"; $res = self::executeQuery($update); if ($res === FALSE) { QconfMgrLog::err(__FILE__, __LINE__, "EXEC {$update} failed!"); return FALSE; } return TRUE; }
public static function recordOp($op_type_code, $hostname, $node_whole, $idc, $data_type, $value_md5, $update_time) { $op_time = date('Y-m-d H:i:s', time()); ArgsUtil::setSQLEscape($op_type_code); ArgsUtil::setSQLEscape($hostname); ArgsUtil::setSQLEscape($node_whole); ArgsUtil::setSQLEscape($idc); ArgsUtil::setSQLEscape($data_type); ArgsUtil::setSQLEscape($value_md5); ArgsUtil::setSQLEscape($update_time); ArgsUtil::setSQLEscape($op_time); $query = "insert into qconf_feedback_op (op_type_code, hostname, node_whole, idc, data_type, value_md5, update_time, op_time) \n values ('{$op_type_code}', '{$hostname}', '{$node_whole}', '{$idc}', '{$data_type}', '{$value_md5}', '{$update_time}', '{$op_time}')"; $res = self::executeQuery($query); if ($res === FALSE) { QconfMgrLog::err(__FILE__, __LINE__, "EXEC '{$query}' failed!"); return FALSE; } return TRUE; }
/** * modify feedback with feedback_id */ public static function modifyFeedback($fd_id, $ip, $value_md5, $value, $update_time) { if ($fd_id === NULL || $value_md5 === NULL) { QconfMgrLog::err(__FILE__, __LINE__, "fd_id or value_md5 is NULL"); return FALSE; } $exist = self::existFeedback($fd_id); if ($exist === FALSE) { QconfMgrLog::err(__FILE__, __LINE__, "feedback item with id({$fd_id}) does not exist!"); return FALSE; } ArgsUtil::setSQLEscape($ip); ArgsUtil::setSQLEscape($value_md5); ArgsUtil::setSQLEscape($value); ArgsUtil::setSQLEscape($update_time); $update = "update qconf_feedback set ip = '{$ip}', value_md5 = '{$value_md5}'," . " value = '{$value}', update_time = '{$update_time}' where feedback_id = '{$fd_id}'"; $res = self::executeQuery($update); if ($res === FALSE) { QconfMgrLog::err(__FILE__, __LINE__, "EXEC '{$query}' failed!"); return FALSE; } return TRUE; }
public function checkFeedbackAction() { $node_id = $this->getRequest("node_id", ""); $idc = $this->getRequest("idc", ""); $page = $this->getRequest("page", 1); $page_count = $this->getRequest("pageCount", 20); // 1. parameter is not right if ($node_id === "" || $idc === "") { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_BAD_ARGS); QconfMgrLog::err(__FILE__, __LINE__, "parameter node_id or idc is null!"); echo json_encode($res); return; } ArgsUtil::setVal($page); ArgsUtil::setVal($page_count); if ($page <= 0) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_BAD_ARGS); QconfMgrLog::err(__FILE__, __LINE__, "parameter page error!"); echo json_encode($res); return; } if ($page_count < 0) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_BAD_ARGS); QconfMgrLog::err(__FILE__, __LINE__, "parameter page_count error!"); echo json_encode($res); return; } // 2. idc zookeeper server not exist $idc_host = ZkConf::getZkHost($idc); if ($idc_host === NULL) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_IDC_NOT_EXIST); QconfMgrLog::err(__FILE__, __LINE__, "'{$idc}' is not int ZOOKEEPER_SVR!"); echo json_encode($res); return; } // 3. get the node info from database $dbnode = NodeServ::getNode($node_id); if ($dbnode === FALSE) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_NODE_NOT_EXIST); QconfMgrLog::err(__FILE__, __LINE__, "node : {$node_id} is not exist!"); echo json_encode($res); return; } $node_whole = $dbnode["node_whole"]; $node_type_code = $dbnode["node_type_code"]; $data_type = $node_type_code == InfoDescUtil::NODE_TYPE_SERV_FATHER ? InfoDescUtil::FEEDBACK_DATA_TYPE_SERVICE : InfoDescUtil::FEEDBACK_DATA_TYPE_VALUE; $cur_node_idc = $dbnode["idc"]; $cur_idcs_array = explode(',', $cur_node_idc); $exist_idc = in_array($idc, $cur_idcs_array); if ($exist_idc === FALSE) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_IDC_NOT_IN_DATABASE); QconfMgrLog::err(__FILE__, __LINE__, "node : {$node_id} does not exist on idc : {$idc}!"); echo json_encode($res); return; } // 4. get feedbacks on current node $start = ($page - 1) * $page_count; $qconf_path = PathUtil::getQconfPath($node_whole); $feedbacks = FeedbackServ::queryFeedbackByNode($qconf_path, $idc, $data_type, $start, $page_count); if ($feedbacks === FALSE) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_MYSQL_FAIL); QconfMgrLog::err(__FILE__, __LINE__, "failed to query feedbacks by node:{$node_whole},\n idc({$idc}), data_type({$data_type}), page({$page}), page_count({$page_count})!"); echo json_encode($res); return; } $total_count = FeedbackServ::feedbackAmountByNode($qconf_path, $idc, $data_type); if ($total_count === FALSE) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_MYSQL_FAIL); QconfMgrLog::err(__FILE__, __LINE__, "failed to get feedbacks amount by node:{$node_whole}, idc({$idc}), data_type({$data_type})"); echo json_encode($res); return; } // 5. calcuate value_md5 $zk_web = new QconfZkWebBase(Log::INFO); $zk_web->connect($idc_host); $retry_time = 0; if ($data_type == InfoDescUtil::FEEDBACK_DATA_TYPE_SERVICE) { // 5.1 calcuate value_md5 for service father node $services = -1; while ($services === -1 && $retry_time <= InfoDescUtil::ZK_MAX_RETRY_TIME) { QconfMgrLog::err(__FILE__, __LINE__, "retry {$retry_time} of " . InfoDescUtil::ZK_MAX_RETRY_TIME . " to get services {$node_whole} on {$idc_host}"); $services = $zk_web->get_group_services_with_status($qconf_path); $retry_time++; } if ($services === -1) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_ZOOKEEPER_FAIL); QconfMgrLog::err(__FILE__, __LINE__, "The children of path: {$qconf_path} are null!"); echo json_encode($res); return; } ksort($services); foreach ($services as $serv => $status) { $ser_combine .= "{$serv}#{$status},"; } $ser_combine = trim($ser_combine, ','); //echo $ser_combine; $node_md5 = md5($ser_combine); } else { // 5.2 calcuate value_md5 for value $node_val = -1; while ($node_val === -1 && $retry_time <= InfoDescUtil::ZK_MAX_RETRY_TIME) { QconfMgrLog::err(__FILE__, __LINE__, "retry {$retry_time} of " . InfoDescUtil::ZK_MAX_RETRY_TIME . " to get value of {$node_whole} on {$idc}"); $node_val = $zk_web->get_conf($qconf_path); $retry_time++; } if ($node_val === -1) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_ZOOKEEPER_FAIL); QconfMgrLog::err(__FILE__, __LINE__, "failed to get value of {$qconf_path}!"); echo json_encode($res); return; } $node_md5 = md5($node_val); } // 6. encapsulate feedback result $fd_result = array(); foreach ($feedbacks as $feedback) { $fd_one = array("feedback_id" => $feedback["feedback_id"], "hostname" => $feedback["hostname"], "ip" => $feedback["ip"], "status" => $feedback["value_md5"] == $node_md5 ? "0" : "1", "update_time" => $feedback["update_time"]); $fd_result[] = $fd_one; } $result = array("curPage" => "{$page}", "totalCount" => "{$total_count}", "listing" => $fd_result); $res = array("errno" => "0", "errmsg" => "", "data" => $result); $json = json_encode($res); echo $json; }
private function upOrOfflineService($op_type) { // 1.argument receive and preprocess $res = ""; $argus = self::commonArgusProcess($res); if ($argus === FALSE) { echo json_encode($res); return; } $user = $argus["user"]; $path = $argus["path"]; $idc = $argus["idc"]; $main_buss_id = $argus["main_buss_id"]; $sub_buss_id = $argus["sub_buss_id"]; $service_name = $this->getRequest("service_name", ""); if ($service_name === "") { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_BAD_ARGS); QconfMgrLog::err(__FILE__, __LINE__, "paramter: 'service_name({$service_name})'is required!"); echo json_encode($res); return; } $service_list = preg_split("/[,]+/", trim($service_name, ",")); //validate for ip_port if (ArgsUtil::ipPortsValidation($service_list) === FALSE) { //failed to add any new services $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_BAD_ARGS); QconfMgrLog::err(__FILE__, __LINE__, "ilegal services : {$service_name} under {$path}!"); echo json_encode($res); return; } // 2. check node exist and is node father type $check_res = ServiceController::checkServFatherNode($path, $main_buss_id); if ($check_res != InfoDescUtil::QCONF_OK) { $res = InfoDescUtil::getErrorMsg($check_res); echo json_encode($res); return; } // 3. do up or offline $op_type_msg = $op_type === InfoDescUtil::OP_TYPE_OFFLINE ? "offline" : "up"; $idc_list = preg_split("/[,]+/", $idc); // split by , foreach ($idc_list as $idc_each) { $idc_host = ZkConf::getZkHost($idc_each); $zk_web = new QconfZkWebBase(Log::INFO); $zk_web->connect($idc_host); $get_ret = ServiceController::getServicesAndStatusWithLink($zk_web, $path, $idc_each, $exist_services); if ($get_ret != InfoDescUtil::QCONF_OK) { $res = InfoDescUtil::getErrorMsg($get_ret); echo json_encode($res); return; } foreach ($service_list as $service) { $show_ser_path = PathUtil::unionPath($path, $service); // check service exist if (!array_key_exists($service, $exist_services)) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_SERVICE_NO_EXIST); echo json_encode($res); return; } if ($op_type === InfoDescUtil::OP_TYPE_OFFLINE) { //check up service cout for offline operation $is_last = TRUE; foreach ($exist_services as $one_exist_service => $service_status) { if ($service_status === InfoDescUtil::SERV_STATUS_UP && $one_exist_service != $service) { $is_last = FALSE; break; } } if ($is_last) { $res = InfoDescUtil::getErrorMsg(InfoDescUtil::ERR_OFFILE_SERVICE_ONLY); QconfMgrLog::err(__FILE__, __LINE__, "{$service} is the last up service under {$path}"); echo json_encode($res); return; } $ret = ServiceController::offlineServiceWithLink($zk_web, $path, $service, $idc_each); $exist_services[$service] = InfoDescUtil::SERV_STATUS_DOWN; } else { $ret = ServiceController::upServiceWithLink($zk_web, $path, $service, $idc_each); } if ($ret != InfoDescUtil::QCONF_OK) { $res = InfoDescUtil::getErrorMsg($ret); QconfMgrLog::err(__FILE__, __LINE__, "{$op_type_msg} service!"); OpServ::insert($op_type, $show_ser_path, $idc_each, InfoDescUtil::OP_STATUS_ZOO_FAILED, $main_buss_id, $sub_buss_id, $user, ""); echo json_encode($res); return; } OpServ::insert($op_type, $show_ser_path, $idc_each, InfoDescUtil::OP_STATUS_SUCCESS, $main_buss_id, $sub_buss_id, $user, $op_type === InfoDescUtil::OP_TYPE_OFFLINE ? InfoDescUtil::SERV_STATUS_OFFLINE : InfoDescUtil::SERV_STATUS_UP); } } $res = array("errno" => "0", "errmsg" => "", "data" => "{$op_type_msg} service success"); $json = json_encode($res); echo $json; return; }
public static function modNodeType($parent_node_id) { if ($parent_node_id === NULL || $parent_node_id === "") { QconfMgrLog::err(__FILE__, __LINE__, "'parent_node_id' is NULL"); return FALSE; } ArgsUtil::setVal($parent_node_id); $query = "select * from qconf_node where node_id = '{$parent_node_id}'"; $res = self::executeQuery($query); if ($res === FALSE) { return FALSE; } $p_row = mysql_fetch_array($res, MYSQL_ASSOC); if ($p_row === FALSE) { QconfMgrLog::err(__FILE__, __LINE__, "EXEC '{$query}' failed!"); return FALSE; } if ($p_row['node_type_code'] == InfoDescUtil::NODE_TYPE_NORMAL) { $update = "update qconf_node set node_type_code = '" . InfoDescUtil::NODE_TYPE_SERV_FATHER . "' where node_id = '{$parent_node_id}'"; $ret = self::executeQuery($update); if ($ret === FALSE) { QconfMgrLog::err(__FILE__, __LINE__, "EXEC '{$update}' failed!"); return FALSE; } } return TRUE; }
public static function delPermByIdc($perm_node, $main_buss_id, $idc) { if ($perm_node === NULL || $perm_node === "" || $main_buss_id === NULL || $main_buss_id === "" || $idc === NULL || $idc === "") { QconfMgrLog::err(__FILE__, __LINE__, "perm_node, main_buss_id or idc is NULL"); return FALSE; } ArgsUtil::setSQLEscape($perm_node); ArgsUtil::setSQLEscape($main_buss_id); ArgsUtil::setSQLEscape($idc); $query = "select * from qconf_perm where node = '{$perm_node}' and main_buss_id = '{$main_buss_id}'"; $res = self::executeQuery($query); if ($res === FALSE) { return FALSE; } // 1. not found the perm $num = mysql_num_rows($res); if ($num === 0) { QconfMgrLog::err(__FILE__, __LINE__, "EXEC '{$query}' failed!"); return FALSE; } $row = mysql_fetch_array($res, MYSQL_ASSOC); $perm_id = $row["perm_id"]; $idc_list = preg_split("/[,]+/", $row['idc']); foreach ($idc_list as $idc_tmp) { if (strcmp($idc, $idc_tmp) !== 0) { $idc_left .= ",{$idc_tmp}"; } } if (!isset($idc_left)) { $query = "delete from qconf_perm where perm_id = '{$perm_id}'"; } else { $idc_left = trim($idc_left, ","); $query = "update qconf_perm set idc = '{$idc_left}' where perm_id = '{$perm_id}'"; } // 2. update the idc info $res = self::executeQuery($query); if ($res === FALSE) { QconfMgrLog::err(__FILE__, __LINE__, "EXEC {$query} failed!"); return FALSE; } return TRUE; }
/** * insert a record into the database */ public static function insert($op_type_code, $node, $idc, $op_status_code, $main_buss_id, $sub_buss_id, $op_user, $msg) { $op_id = GuidUtil::guidGenerator(); $op_time = date('Y-m-d H:i:s', time()); ArgsUtil::setSQLEscape($op_type_code); ArgsUtil::setSQLEscape($node); ArgsUtil::setSQLEscape($idc); ArgsUtil::setSQLEscape($op_status_code); ArgsUtil::setVal($main_buss_id); ArgsUtil::setVal($sub_buss_id); ArgsUtil::setSQLEscape($op_user); ArgsUtil::setSQLEscape($msg); $query = "insert into qconf_op values (NULL, '{$op_id}', '{$op_type_code}', '{$node}', '{$idc}', '{$op_time}',\n '{$op_status_code}', {$main_buss_id}, {$sub_buss_id}, '{$op_user}', '{$msg}');"; return self::executeQuery($query); }
public function deleteNormal($normal_user, $node_whole) { if ($normal_user === NULL || $normal_user === "" || $node_whole === NULL || $node_whole === "") { QconfMgrLog::err(__FILE__, __LINE__, "normal_user or node is NULL"); return FALSE; } $node_whole = "/" . trim($node_whole, "/") . "/"; ArgsUtil::setSQLEscape($normal_user); ArgsUtil::setSQLEscape($node_whole); $query = "select count(*) from qconf_normal_perm where binary user_name = '{$normal_user}' and binary node = '{$node_whole}'"; $res = self::executeQuery($query); if ($res === FALSE) { return FALSE; } $ret_arr = mysql_fetch_array($res, MYSQL_NUM); if ($ret_arr[0] <= 0) { return InfoDescUtil::ERR_USER_PERM_NODE_NOT_EXIST; } $query = "delete from qconf_normal_perm where binary user_name = '{$normal_user}' and binary node = '{$node_whole}'"; $res = self::executeQuery($query); if ($res === FALSE) { return FALSE; } return InfoDescUtil::QCONF_OK; }