public bool CheckMySqlConnection() { bool result = false; _checkStep = ServerCheckStep.MySqlPing; try { OnWriteLog("MySql 서버 접속테스트..."); handler.Open(); result = handler.Ping(); if (result) { OnWriteLog("MySql 서버 접속테스트 성공"); } else { OnWriteLog("MySql 서버 접속테스트 실패"); } } catch (Exception e) { OnWriteLog("MySql 서버 접속테스트 에러 : " + e.ToString()); } finally { handler.Close(); } return result; }
/// <summary> ///3. 8882로 전송 ///4. 8883이 대기 및 수신 /// </summary> /// <returns></returns> public bool CheckBasicConnection() { _checkStep = ServerCheckStep.WDServerPing; _socHandler.SendUDP(8883, "127.0.0.1", 8882, "8881전송테스트"); return true; }
public bool SetWDServerFirewall() { MsgrLogger.WriteLog("WeDoServer방화벽 등록..."); _checkStep = ServerCheckStep.WDServerFirewallCheck; return _fwManager.AddProgram(WEDO_SERVER_NAME, WEDO_SERVER); }
public bool ReleaseWDServerFirewall() { MsgrLogger.WriteLog("WeDoServer방화벽 등록해제..."); _checkStep = ServerCheckStep.WDServerFirewallCheck; return _fwManager.RemoveProgram(WEDO_SERVER); }
public bool SetMySqlFirewall() { MsgrLogger.WriteLog("MySql port 방화벽 등록..."); _checkStep = ServerCheckStep.MySqlFirewallCheck; return _fwManager.AddProgram(WEDO_MYSQL_NAME, WEDO_MYSQL); }
public bool ReleaseMySqlFirewall() { MsgrLogger.WriteLog("MySql port 방화벽 등록해제..."); _checkStep = ServerCheckStep.MySqlFirewallCheck; return _fwManager.RemoveProgram(WEDO_MYSQL); }
/// <summary> /// 방화벽 활성화/비활성화 확인 /// </summary> /// <returns></returns> public bool IsFirewallEnabled() { MsgrLogger.WriteLog("방화벽 활성화 체크..."); _checkStep = ServerCheckStep.MySqlFirewallCheck; string fwStatus = ""; if (_fwManager.IsFirewallEnabled()) { fwStatus = "방화벽활성화상태"; } else { fwStatus = "방화벽비활성화상태"; } MsgrLogger.WriteLog("===>"+fwStatus); return _fwManager.IsFirewallEnabled(); }
/// <summary> /// 1. t_company /// 2. t_user /// 3. t_l_code /// 4. t_s_code /// </summary> /// <returns></returns> public string GetCompanyCd() { string result = null; _checkStep = ServerCheckStep.MySqlComCd; string sql = null; DataTable dt = null; try { OnWriteLog("회사코드 확인."); handler.Open(); //t_company sql = "select com_cd, com_nm from t_company"; handler.SetQuery(sql); OnWriteLog("실행쿼리문:"+sql); dt = handler.DoQuery(); foreach (DataRow dr in dt.Rows) { result += dr["com_cd"].ToString() + ":" + dr["com_nm"].ToString(); OnWriteLog(string.Format("회사코드[{0}]회사명[{1}]", dr["com_cd"].ToString(), dr["com_nm"].ToString())); } //t_user sql = "select com_cd, user_id, user_nm from t_user"; handler.SetQuery(sql); OnWriteLog("실행쿼리문:" + sql); dt = handler.DoQuery(); foreach (DataRow dr in dt.Rows) { result += dr["com_cd"].ToString() + ":" + dr["user_id"].ToString() + ":" + dr["user_nm"].ToString(); OnWriteLog(string.Format("회사코드[{0}]사용자ID[{1}]사용자명[{2}]", dr["com_cd"].ToString(), dr["user_id"].ToString(), dr["user_nm"].ToString())); } //t_l_code sql = "select com_cd, l_menu_cd, l_menu_nm from t_l_code"; handler.SetQuery(sql); OnWriteLog("실행쿼리문:" + sql); dt = handler.DoQuery(); foreach (DataRow dr in dt.Rows) { result += dr["com_cd"].ToString() + ":" + dr["l_menu_cd"].ToString() + ":" + dr["l_menu_nm"].ToString(); OnWriteLog(string.Format("회사코드[{0}]코드[{1}]코드명[{2}]", dr["com_cd"].ToString(), dr["l_menu_cd"].ToString(), dr["l_menu_nm"].ToString())); } //t_s_code sql = "select com_cd, l_menu_cd, s_menu_cd, s_menu_nm from t_s_code"; handler.SetQuery(sql); OnWriteLog("실행쿼리문:" + sql); dt = handler.DoQuery(); foreach (DataRow dr in dt.Rows) { result += dr["com_cd"].ToString() + ":" + dr["l_menu_cd"].ToString() + ":" + dr["s_menu_cd"].ToString() + ":" + dr["s_menu_nm"].ToString(); OnWriteLog(string.Format("회사코드[{0}]코드[{1}]코드명[{2}]", dr["com_cd"].ToString(), dr["s_menu_cd"].ToString(), dr["s_menu_nm"].ToString())); } } catch (Exception e) { OnWriteLog("회사코드 확인 에러 : " + e.ToString()); } finally { handler.Close(); } return result; }
//클라이언트 방화벽 확인 //1. WDMsg_Client.exe //2. 각종유틸 // ==> 상태확인 public string CheckWDServerFirewallStatus() { MsgrLogger.WriteLog("WeDoServer방화벽 체크중..."); _checkStep = ServerCheckStep.WDServerFirewallCheck; return _fwManager.GetByProgramPath(WEDO_SERVER); }
public string CheckMySqlFirewallStatus() { MsgrLogger.WriteLog("MySql 방화벽 체크중..."); _checkStep = ServerCheckStep.MySqlFirewallCheck; return _fwManager.GetByProgramPath(WEDO_MYSQL); }