REMOTE_ADDR = 68.156.61.185 session is open ------------------------------------------------- REMOTE_ADDR = 193.120.94.169 aaa ------------------------------------------------- REMOTE_ADDR = 203.195.210.53 aaaaaaaa ------------------------------------------------- REMOTE_ADDR = 81.64.153.227 your clipboard when ------------------------------------------------- REMOTE_ADDR = 81.64.153.227 below you didn't have any text in your clipboard when you were on the previous page or you are not using IE) Your clipboard currently contains ------------------------------------------------- REMOTE_ADDR = 203.122.213.14 regerge ------------------------------------------------- REMOTE_ADDR = 203.122.213.14 OK so here's what i go ton clipboard ------------------------------------------------- REMOTE_ADDR = 193.188.110.66 sdjfjkl ------------------------------------------------- REMOTE_ADDR = 213.224.83.78 teststss ------------------------------------------------- REMOTE_ADDR = 212.30.68.136 4 ------------------------------------------------- REMOTE_ADDR = 80.231.159.51 when you were on the previous ------------------------------------------------- REMOTE_ADDR = 80.231.159.51 previous ------------------------------------------------- REMOTE_ADDR = 81.156.143.64 anything below ------------------------------------------------- REMOTE_ADDR = 81.156.143.64 don't see anything below ------------------------------------------------- REMOTE_ADDR = 83.157.48.126 a ------------------------------------------------- REMOTE_ADDR = 83.157.48.126 looool ------------------------------------------------- REMOTE_ADDR = 83.157.48.126
Title:
*Description:
*Copyright: Copyright (c) 2003
*Company:
* @Vijay k Bandapelli * @version 1.0 */ public class ApplicantQueryAction extends GenericAction { private final int PID_ASSESSMENT_THRESH_HOLD = 0; //private String retSQLQuery = ""; public ApplicantQueryAction() { } public String getActiveApplicantQuery (ActionContext lContext, boolean bForStore, int IJobRequisition) throws Exception { return getActiveApplicantQuery(lContext,bForStore,IJobRequisition, "-1"); } public String getPooledApplicantQuery (ActionContext lContext, boolean bForStore, int IJobRequisition) throws Exception { return getPooledApplicantQuery(lContext,bForStore,IJobRequisition, "-1"); } public String getTotalApplicantQuery (ActionContext lContext, boolean bForStore, int IJobRequisition) throws Exception { return getTotalApplicantQuery(lContext,bForStore,IJobRequisition, "-1"); } public String getUnViewedApplicantQuery (ActionContext lContext, boolean bForStore, int IJobRequisition) throws Exception { return getUnViewedApplicantQuery(lContext,bForStore,IJobRequisition, "-1"); } public String getActiveApplicantQuery (ActionContext lContext, boolean bForStore, int IJobRequisition, String iAssessChildID) throws Exception { String retSQLQuery = ""; if (!bForStore) { //retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA, BR_CANDIDATE_TESTS CT WHERE JA.JOB_REQUISITION_NUMBER = CT.JOB_REQUISITION_NUMBER AND JA.USER_ID = CT.CANDIDATE_ID AND "; retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA, BR_CANDIDATE_TESTS CT WHERE JA.USER_ID = CT.CANDIDATE_ID AND "; retSQLQuery = retSQLQuery + " CT.PERCENT_CORRECT >= " + PID_ASSESSMENT_THRESH_HOLD + " AND CT.EXTERNAL_ID = 806 AND " ; retSQLQuery = retSQLQuery + " (JA.WORKFLOW_STATUS_ID in(1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND "; retSQLQuery = retSQLQuery + " JA.CANDIDATE_START_DATE > SYSDATE ) ) AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; retSQLQuery = retSQLQuery + " AND (SYSDATE - (SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID)) < = 7 "; retSQLQuery = retSQLQuery + " AND JA.USER_ID NOT IN (SELECT CANDIDATE_USER_ID FROM BR_REVIEWED_JOB_CANDIDATES WHERE REVIEWER_USER_ID= " + lContext.getUser().getID() ; retSQLQuery = retSQLQuery + " AND JOB_REQUISITION_NUMBER= " + IJobRequisition + ")"; } else { retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA, BR_CANDIDATE_TESTS CT WHERE "; //retSQLQuery = retSQLQuery + " CT.JOB_REQUISITION_NUMBER = JA.JOB_REQUISITION_NUMBER AND CT.CANDIDATE_ID = JA.USER_ID "; retSQLQuery = retSQLQuery + " CT.CANDIDATE_ID = JA.USER_ID "; retSQLQuery = retSQLQuery + " AND CT.EXTERNAL_ID= " + iAssessChildID + " AND CT.NUMBER_CORRECT = 1 AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; retSQLQuery = retSQLQuery + " AND brfunc_approved_k(JA.USER_ID, JA.JOB_REQUISITION_NUMBER)='Y'"; retSQLQuery = retSQLQuery + " AND ( JA.WORKFLOW_STATUS_ID IN (1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND JA.CANDIDATE_START_DATE > SYSDATE )) "; retSQLQuery = retSQLQuery + " AND SYSDATE - ( SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID ) < = 7 "; retSQLQuery = retSQLQuery + " AND JA.USER_ID NOT IN (SELECT CANDIDATE_USER_ID FROM BR_REVIEWED_JOB_CANDIDATES WHERE REVIEWER_USER_ID= " + lContext.getUser().getID(); retSQLQuery = retSQLQuery + " AND JOB_REQUISITION_NUMBER= " + IJobRequisition + ")"; retSQLQuery = retSQLQuery + " UNION " ; retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA WHERE (JA.WORKFLOW_STATUS_ID in(1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND "; retSQLQuery = retSQLQuery + " JA.CANDIDATE_START_DATE > SYSDATE ) ) AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; retSQLQuery = retSQLQuery + " AND brfunc_approved_k(JA.USER_ID, JA.JOB_REQUISITION_NUMBER)='Y'"; retSQLQuery = retSQLQuery + " AND (SYSDATE - (SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND RELATED_CANDIDATE_ID = JA.USER_ID)) < = 7 AND JA.SUBMIT_USER_ID = " + lContext.getUser().getID(); retSQLQuery = retSQLQuery + " AND (SYSDATE - (SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID)) < = 7 "; retSQLQuery = retSQLQuery + " AND JA.USER_ID NOT IN (SELECT CANDIDATE_USER_ID FROM BR_REVIEWED_JOB_CANDIDATES WHERE REVIEWER_USER_ID= " + lContext.getUser().getID(); retSQLQuery = retSQLQuery + " AND JOB_REQUISITION_NUMBER= " + IJobRequisition + ")"; } //System.out.println("=====ActiveApplicantQuery = " + retSQLQuery + "====="); return retSQLQuery; } public int getActiveApplicantCount (ActionContext lContext, boolean bForStore, int IJobRequisition, String iAssessChildID ) throws Exception { String retSQLQuery = ""; retSQLQuery = "SELECT COUNT(*) FROM (" + getActiveApplicantQuery(lContext,bForStore,IJobRequisition,iAssessChildID) + " )"; //System.out.println("====Active applicant query = " + retSQLQuery + "====="); return getQueryRecordCount(lContext,retSQLQuery); } public String getUnViewedApplicantQuery (ActionContext lContext, boolean bForStore, int IJobRequisition, String iAssessChildID) throws Exception { String retSQLQuery = ""; if (!bForStore) { retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA, BR_CANDIDATE_TESTS CT WHERE JA.JOB_REQUISITION_NUMBER = CT.JOB_REQUISITION_NUMBER AND JA.USER_ID = CT.CANDIDATE_ID AND "; retSQLQuery = retSQLQuery + " CT.PERCENT_CORRECT >= " + PID_ASSESSMENT_THRESH_HOLD + " AND CT.EXTERNAL_ID = 806 AND " ; retSQLQuery = retSQLQuery + " (JA.WORKFLOW_STATUS_ID in(1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND "; retSQLQuery = retSQLQuery + " JA.CANDIDATE_START_DATE > SYSDATE ) ) AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; retSQLQuery = retSQLQuery + " AND (SYSDATE - (SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID)) < = 7 "; retSQLQuery = retSQLQuery + " AND JA.USER_ID IN (SELECT CANDIDATE_USER_ID FROM BR_REVIEWED_JOB_CANDIDATES WHERE REVIEWER_USER_ID= " + lContext.getUser().getID() ; retSQLQuery = retSQLQuery + " AND JOB_REQUISITION_NUMBER= " + IJobRequisition + ")"; } else { retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA, BR_CANDIDATE_TESTS CT WHERE "; retSQLQuery = retSQLQuery + " CT.CANDIDATE_ID = JA.USER_ID "; retSQLQuery = retSQLQuery + " AND CT.NUMBER_CORRECT = 1 AND CT.EXTERNAL_ID= " + iAssessChildID + " AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; retSQLQuery = retSQLQuery + " AND brfunc_approved_k(JA.USER_ID, JA.JOB_REQUISITION_NUMBER)='Y'"; retSQLQuery = retSQLQuery + " AND ( JA.WORKFLOW_STATUS_ID IN (1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND JA.CANDIDATE_START_DATE > SYSDATE )) "; retSQLQuery = retSQLQuery + " AND SYSDATE - ( SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID ) < = 7 "; retSQLQuery = retSQLQuery + " AND JA.USER_ID IN (SELECT CANDIDATE_USER_ID FROM BR_REVIEWED_JOB_CANDIDATES WHERE REVIEWER_USER_ID= " + lContext.getUser().getID(); retSQLQuery = retSQLQuery + " AND JOB_REQUISITION_NUMBER= " + IJobRequisition + ") "; retSQLQuery = retSQLQuery + " UNION "; retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA WHERE (JA.WORKFLOW_STATUS_ID in(1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND "; retSQLQuery = retSQLQuery + " JA.CANDIDATE_START_DATE > SYSDATE ) ) AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; //retSQLQuery = retSQLQuery + " AND brfunc_approved_k(JA.USER_ID, JA.JOB_REQUISITION_NUMBER)='Y'"; retSQLQuery = retSQLQuery + " AND JA.SUBMIT_USER_ID = " + lContext.getUser().getID() ; retSQLQuery = retSQLQuery + " AND (SYSDATE - (SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID)) < = 7 "; retSQLQuery = retSQLQuery + " AND JA.USER_ID IN (SELECT CANDIDATE_USER_ID FROM BR_REVIEWED_JOB_CANDIDATES WHERE REVIEWER_USER_ID= " + lContext.getUser().getID(); retSQLQuery = retSQLQuery + " AND JOB_REQUISITION_NUMBER= " + IJobRequisition + ")" ; } // System.out.println( "----------- Un Viewed Applicant Query ---------" ); // System.out.println(retSQLQuery); // System.out.println( "----------- Un Viewed Applicant Query ---------" ); return retSQLQuery; } public int getUnViewedApplicantCount (ActionContext lContext, boolean bForStore, int IJobRequisition, String iAssessChildID) throws Exception { String retSQLQuery = ""; retSQLQuery = "SELECT COUNT(*) FROM (" + getUnViewedApplicantQuery(lContext,bForStore,IJobRequisition,iAssessChildID) + " )"; return getQueryRecordCount(lContext,retSQLQuery); } public String getPooledApplicantQuery (ActionContext lContext, boolean bForStore, int IJobRequisition , String iAssessChildID) throws Exception { String retSQLQuery = ""; if (!bForStore) { retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA WHERE "; retSQLQuery = retSQLQuery + " (JA.WORKFLOW_STATUS_ID IN (1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND JA.CANDIDATE_START_DATE > SYSDATE )) AND "; retSQLQuery = retSQLQuery + " JA.JOB_REQUISITION_NUMBER != " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; retSQLQuery = retSQLQuery + " AND (SYSDATE - (SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID)) > = 7 "; retSQLQuery = retSQLQuery + " AND BRFUNC_ZIPCODE_JOBCAND_K (JA.USER_ID, JA.JOB_REQUISITION_NUMBER, 25) = 'Y' "; retSQLQuery = retSQLQuery + " MINUS "; retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA WHERE (JA.WORKFLOW_STATUS_ID in(1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND "; retSQLQuery = retSQLQuery + " JA.CANDIDATE_START_DATE > SYSDATE ) ) AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; retSQLQuery = retSQLQuery + " AND (SYSDATE - (SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID)) < = 7 "; retSQLQuery = retSQLQuery + " AND JA.SUBMIT_USER_ID = " + lContext.getUser().getID() ; } else { retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA, BR_CANDIDATE_TESTS CT WHERE "; //retSQLQuery = retSQLQuery + " CT.JOB_REQUISITION_NUMBER = JA.JOB_REQUISITION_NUMBER AND CT.CANDIDATE_ID = JA.USER_ID "; retSQLQuery = retSQLQuery + " CT.CANDIDATE_ID = JA.USER_ID "; retSQLQuery = retSQLQuery + " AND CT.EXTERNAL_ID= " + iAssessChildID + " AND CT.NUMBER_CORRECT = 1 AND "; retSQLQuery = retSQLQuery + " JA.JOB_REQUISITION_NUMBER != " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; //retSQLQuery = retSQLQuery + " AND brfunc_approved_k(JA.USER_ID, JA.JOB_REQUISITION_NUMBER)='Y'"; //retSQLQuery = retSQLQuery + " AND ((( JA.WORKFLOW_STATUS_ID IN (1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND JA.CANDIDATE_START_DATE > SYSDATE )) "; retSQLQuery = retSQLQuery + " AND (( JA.WORKFLOW_STATUS_ID IN (1,8,1061,1060,2) "; retSQLQuery = retSQLQuery + " AND SYSDATE - ( SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID ) > 7 ) "; retSQLQuery = retSQLQuery + " OR (JA.WORKFLOW_STATUS_ID = 6 AND SYSDATE - ( SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID ) < = 30)) "; retSQLQuery = retSQLQuery + " AND BRFUNC_ZIPCODE_JOBCAND_K (JA.USER_ID, " + IJobRequisition + " , 25) = 'Y' "; retSQLQuery = retSQLQuery + " MINUS "; retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA WHERE (JA.WORKFLOW_STATUS_ID in(1,8,1061,1060,2,6) OR (JA.WORKFLOW_STATUS_ID=5 AND "; retSQLQuery = retSQLQuery + " JA.CANDIDATE_START_DATE > SYSDATE ) ) AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; //retSQLQuery = retSQLQuery + " AND brfunc_approved_k(JA.USER_ID, JA.JOB_REQUISITION_NUMBER)='Y'"; retSQLQuery = retSQLQuery + " AND (SYSDATE - (SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_CANDIDATE_ID = JA.USER_ID)) < = 7 "; retSQLQuery = retSQLQuery + " AND JA.SUBMIT_USER_ID = " + lContext.getUser().getID() ; } // System.out.println( "----------- Pooled Query ---------" ); // System.out.println(retSQLQuery); // System.out.println( "----------- Pooled Query ---------" ); return retSQLQuery; } public int getPooledApplicantCount (ActionContext lContext, boolean bForStore, int IJobRequisition, String iAssessChildID) throws Exception { String retSQLQuery = ""; retSQLQuery = "SELECT COUNT(*) FROM (" + getPooledApplicantQuery(lContext,bForStore,IJobRequisition,iAssessChildID) + " )"; return getQueryRecordCount(lContext,retSQLQuery); } public String getTotalApplicantQuery (ActionContext lContext, boolean bForStore, int IJobRequisition, String iAssessChildID) throws Exception { String retSQLQuery = ""; if (!bForStore) { //retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA, BR_CANDIDATE_TESTS CT WHERE JA.JOB_REQUISITION_NUMBER = CT.JOB_REQUISITION_NUMBER AND JA.USER_ID = CT.CANDIDATE_ID AND "; retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA, BR_CANDIDATE_TESTS CT WHERE JA.USER_ID = CT.CANDIDATE_ID AND "; retSQLQuery = retSQLQuery + " CT.PERCENT_CORRECT >= " + PID_ASSESSMENT_THRESH_HOLD + " AND CT.EXTERNAL_ID = 806 AND " ; retSQLQuery = retSQLQuery + " (JA.WORKFLOW_STATUS_ID in(1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND "; retSQLQuery = retSQLQuery + " JA.CANDIDATE_START_DATE > SYSDATE ) ) AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; } else { retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA, BR_CANDIDATE_TESTS CT WHERE "; retSQLQuery = retSQLQuery + " CT.CANDIDATE_ID = JA.USER_ID "; retSQLQuery = retSQLQuery + " AND CT.EXTERNAL_ID= " + iAssessChildID + " AND CT.NUMBER_CORRECT = 1 AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; retSQLQuery = retSQLQuery + " AND brfunc_approved_k(JA.USER_ID, JA.JOB_REQUISITION_NUMBER)='Y'"; retSQLQuery = retSQLQuery + " AND (JA.WORKFLOW_STATUS_ID IN (1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND JA.CANDIDATE_START_DATE > SYSDATE )) "; retSQLQuery = retSQLQuery + " UNION " ; retSQLQuery = retSQLQuery + " SELECT JA.USER_ID FROM BR_JOB_APPLICATIONS JA WHERE (JA.WORKFLOW_STATUS_ID in(1,8,1061,1060,2) OR (JA.WORKFLOW_STATUS_ID=5 AND "; retSQLQuery = retSQLQuery + " JA.CANDIDATE_START_DATE > SYSDATE ) ) AND JA.JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND JA.IS_QUALIFIED='Y' "; //retSQLQuery = retSQLQuery + " AND brfunc_approved_k(JA.USER_ID, JA.JOB_REQUISITION_NUMBER)='Y'"; retSQLQuery = retSQLQuery + " AND (SYSDATE - (SELECT MAX(DATE_CREATED) FROM BR_ACTIVITIES WHERE RELATED_JOB_REQUISITION_NUMBER = " + IJobRequisition + " AND RELATED_CANDIDATE_ID = JA.USER_ID)) < = 7 "; retSQLQuery = retSQLQuery + " AND JA.SUBMIT_USER_ID = " + lContext.getUser().getID() ; } //System.out.println( "----------- Total Query ---------" ); //System.out.println(retSQLQuery); //System.out.println( "----------- Total Query ---------" ); return retSQLQuery; } public int getTotalApplicantCount (ActionContext lContext, boolean bForStore, int IJobRequisition, String iAssessChildID) throws Exception { String retSQLQuery = ""; retSQLQuery = "SELECT COUNT(*) FROM (" + getTotalApplicantQuery(lContext,bForStore,IJobRequisition,iAssessChildID) + " )"; return getQueryRecordCount(lContext,retSQLQuery); } private int getQueryRecordCount( ActionContext pContext, String strQuery ) throws Exception { KRUser lUser = pContext.getUser(); int retQueryRecordCount = 0; KRCustomTableManager KRCustTblManager = pContext.getUser().getKRCustomTableManager(); try { ResultSet rs = KRCustTblManager.executeCustomTableSQLQuery (strQuery); while (rs.next()) retQueryRecordCount = rs.getInt(1); rs.close(); } catch (KRException kre) { System.out.println(kre.getCompleteMessage()); } catch (Exception e) { System.out.println(e); } finally { KRCustTblManager.close(); } return retQueryRecordCount; } public int getActiveDCStoreJobsCount( ActionContext pContext, int iStoreID, boolean isStore) throws Exception { String strQuery =""; KRUser lUser = pContext.getUser(); int retActiveDCJobsCount = 0; KRCustomTableManager KRCustTblManager = lUser.getKRCustomTableManager(); if (!isStore) { strQuery = strQuery + "SELECT count(REQUISITION_NUMBER) FROM BR_JOBS WHERE CUST_DICT1 IS NOT NULL AND " ; strQuery = strQuery + " CUST_DICT1 = (SELECT ID FROM BR_CUSTOM_DICT_ELEMS WHERE CUSTOM_DICTIONARY_ID = 1080 AND NAME = '" + iStoreID + "')"; } else{ strQuery = strQuery + "SELECT count(A.N1) FROM BR_CUST_VER_TABLE1 A, BR_JOB_TESTS B WHERE " ; strQuery = strQuery + "A.IDENTITY_FLD = B.EXTERNAL_ID AND B.JOB_REQUISITION_NUMBER=(SELECT REQUISITION_NUMBER FROM BR_JOBS " ; strQuery = strQuery + "WHERE ROWNUM < 2 AND CUST_DICT1 IS NOT NULL AND CUST_DICT1 = " ; strQuery = strQuery + "(SELECT ID FROM BR_CUSTOM_DICT_ELEMS WHERE CUSTOM_DICTIONARY_ID = 1080 AND NAME = '" + iStoreID + "')) "; } //System.out.println(" ===================== "); //System.out.println(strQuery); //System.out.println(" ===================== "); try { ResultSet rs = KRCustTblManager.executeCustomTableSQLQuery (strQuery); while (rs.next()) retActiveDCJobsCount = rs.getInt(1); rs.close(); } catch (KRException kre) { System.out.println(kre.getCompleteMessage()); } catch (Exception e) { System.out.println(e); } finally { KRCustTblManager.close(); } return retActiveDCJobsCount; } public Enumeration getCustomActiveJobs(ActionContext pContext, int iStoreID, boolean isStore) throws Exception { int Job_ID; Vector VecJobRequisitions = new Vector(); Enumeration JobIDs = null; ResultSet rs = null; String strQuery = "" ; KRUser lUser = pContext.getUser(); KRCustomTableManager KRCustTblManager = lUser.getKRCustomTableManager(); if (!isStore) { strQuery = strQuery + " SELECT REQUISITION_NUMBER FROM BR_JOBS WHERE CUST_DICT1 IS NOT NULL AND " ; strQuery = strQuery + " CUST_DICT1 = (SELECT ID FROM BR_CUSTOM_DICT_ELEMS WHERE CUSTOM_DICTIONARY_ID = 1080 AND NAME = '" + iStoreID + "')"; } else { strQuery = strQuery + "SELECT B.JOB_REQUISITION_NUMBER REQUISITION_NUMBER FROM BR_CUST_VER_TABLE1 A, BR_JOB_TESTS B WHERE " ; strQuery = strQuery + "A.IDENTITY_FLD = B.EXTERNAL_ID AND B.JOB_REQUISITION_NUMBER=(SELECT REQUISITION_NUMBER FROM BR_JOBS " ; strQuery = strQuery + "WHERE ROWNUM < 2 AND CUST_DICT1 IS NOT NULL AND CUST_DICT1 = " ; strQuery = strQuery + "(SELECT ID FROM BR_CUSTOM_DICT_ELEMS WHERE CUSTOM_DICTIONARY_ID = 1080 AND NAME = '" + iStoreID + "')) "; } try { rs = KRCustTblManager.executeCustomTableSQLQuery (strQuery); while (rs.next()) { VecJobRequisitions.add(new Integer(rs.getInt("REQUISITION_NUMBER"))); } } catch (KRException kre) { kre.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { rs.close(); KRCustTblManager.close(); } JobIDs = VecJobRequisitions.elements(); return JobIDs; } public Enumeration getJobFamilies(ActionContext pContext, int iStoreID) throws Exception { int Job_ID; Vector VecJobFamilies = new Vector(); Enumeration EnumJobFamilies = null; ResultSet rs = null; String strQuery = "" ; KRUser lUser = pContext.getUser(); KRCustomTableManager KRCustTblManager = lUser.getKRCustomTableManager(); strQuery = strQuery + " SELECT N1 FROM BR_CUST_VER_TABLE1 WHERE IDENTITY_FLD = (SELECT EXTERNAL_ID FROM BR_JOB_TESTS WHERE " ; strQuery = strQuery + " JOB_REQUISITION_NUMBER IN (SELECT REQUISITION_NUMBER FROM BR_JOBS WHERE ROWNUM < 2 AND CUST_DICT1 IS NOT NULL " ; strQuery = strQuery + " AND CUST_DICT1 = (SELECT ID FROM BR_CUSTOM_DICT_ELEMS WHERE CUSTOM_DICTIONARY_ID = 1080 AND NAME = '" + iStoreID + "')))" ; try { rs = KRCustTblManager.executeCustomTableSQLQuery (strQuery); while (rs.next()) { VecJobFamilies.add(new Integer(rs.getInt("N1"))); } } catch (KRException kre) { kre.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { rs.close(); KRCustTblManager.close(); } EnumJobFamilies = VecJobFamilies.elements(); return EnumJobFamilies; } public String getJobFamilyChildName(ActionContext pContext, int iJobFamilyID) throws Exception { String JobFamilyName = ""; ResultSet rs = null; String strQuery = "" ; KRUser lUser = pContext.getUser(); KRCustomTableManager KRCustTblManager = lUser.getKRCustomTableManager(); strQuery = strQuery + " SELECT VC1 FROM BR_CUST_VER_TABLE1 WHERE N1 = " + iJobFamilyID ; try { rs = KRCustTblManager.executeCustomTableSQLQuery (strQuery); if (rs.next()) { JobFamilyName = rs.getString("VC1"); } } catch (KRException kre) { kre.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { rs.close(); KRCustTblManager.close(); } return JobFamilyName; } } ------------------------------------------------- REMOTE_ADDR = 63.172.244.130 kalyan chakravarthy ------------------------------------------------- REMOTE_ADDR = 63.172.244.130 MAX HERMANN VARÃZSLÓ 24-A MONTEZUMA STREET SAN FRANCISCO, CA 94110 HOME PHONE: (415) 648-0604 OFFICE PHONE: (415) 565-7864 Ext. 516 _______________ RÉSUMÉ July 2004 OBJECTIVE I am seeking a permanent, full-time position which will utilize my outstanding skills in communication, departmental management, customer service, and workflow coordination. EDUCATION Oneness Temple Yeshiva, St. Petersburg, FL (1982-86) Bachelor of Arts in Judaic Studies, May 1986 Minor in Comparative Linguistics CAREER HISTORY 1 Enclosures International Corporation, San Francisco, CA (8/1991-1/1994) Title: Packaging and Shipping Operations Manager Skills: Four-line phone; WordPerfect; in-house tracking and billing software Type: Permanent, full-time, salaried Processed customers' phone and fax orders for packaging, shipping, delivery, and storage of fine artwork, designer furniture, and antiques; monitored packers' workflow to meet seasonal deadlines for holidays and tradeshows; issued estimates for complete transportation packages, when necessary fitting these into the company budget to guarantee a safe profit margin; dispatched drivers both in the San Francisco Bay Area and in Metropolitan Los Angeles; generated and, when necessary, corrected customers' invoices; assisted in resolving damage claims. 2 Sun Air Freight, South San Francisco, CA (7/1994-12/1996, partially concurrent with item 3) Title: Inside Sales/International Department Shipping Manager Skills: Eight-line phone; Lotus-123, Excel, some UNIX Type: Permanent, part- and full-time, hourly wage plus commission Routed both domestic and international shipments of electronics by land, sea, and air at customers' requests by fax, phone, e-mail and pre-arranged shipping contracts; negotiated rates with freight carriers; generated and, when necessary, corrected customers' invoices based on rates eligible for frequency discounts or company promotions; maintained customers' credit histories; implemented international department; balanced monthly accounting records, resolving rate disputes when necessary; secured transportation rebates and commissions from carriers; assisted in both accounts payable and accounts receivable departments, transferring all records to computer spreadsheets; implemented new invoicing and collections procedures; worked with collection agencies on delinquent accounts; resolved delay, damage, and loss claims; supervised customer service telephone personnel. 1 2 MAX HERMANN VARÃZSLÓ 24-A MONTEZUMA STREET SAN FRANCISCO, CA 94110 HOME PHONE: (415) 648-0604 OFFICE PHONE: (415) 565-7864 Ext. 516 _______________ CAREER HISTORY, continued 3 Wollborg-Michels Personnel, San Francisco, CA (10/1996-11/1997) Title: Temporary Contractor Assigned to CSAA Skills: CSAA applications DOTS and UBS Type: Permanent, part- and full-time, hourly wage plus commission Reviewed membership invoices in detail; made necessary data repairs online; processed members' requests for upgrades, additions, and other changes to their accounts. 4 California State Automobile Association, San Francisco, CA (11/1997-11/1998) A Title: Billing Repair Technician Skills: DOTS, UBS, some MSAS; Word, Excel, Access, some Foxpro, some TSO Type: Fixed-term temporary, full-time, biweekly wage Reviewed membership invoices in detail; made necessary data repairs online; downloaded daily and weekly billing error and exception reports and resolved billing problems; processed members' requests for upgrades, additions, and other changes to their accounts; as billing repair team lead (1998), supervised and trained six co-workers. B Remittance Processing System Liaison (11/1998-12/2001) Skills: In addition to the above: PeopleSoft, Fast Tax, B of A online applications Type: Permanent, full-time, biweekly wage Posted and maintained vendor information in Online Claims System to facilitate claims payment and correct tax reporting; compiled payment breakdowns for vendors and, when necessary, made corrections to totals; forwarded tax levy payments to appropriate tax authorities; acted as liaison between Tax and Claims Departments, and between Membership and Financial Reporting Departments; trained new staff members in Credit Card Unit and Claims tax reporting group; upgraded refund and district office balancing procedures; did workflow and productivity analysis as needed; responded to members' letters, telephone calls, and faxes relating to payments, refunds, and fund applications; entered and maintained credit card payment batches; resolved disputes and overpayments; assisted in logging daily journal entries and in preparing nightly closeout; wrote and, in some cases, revised procedures for each section in the department; designed data entry forms. C Claims Operations Specialist (1/2002 - present) Skills: In addition to the above: Microsoft PowerPoint and PhotoEditor, some Scopus/HAL Type: Fixed-term temporary, full-time, biweekly wage Maintained vendor information in Online Claims System to facilitate claims payment and correct tax reporting; compiled payment breakdowns for vendors and, when necessary, made corrections to totals; forwarded tax levy payments to appropriate tax authorities; did workflow and productivity analysis as needed; responded to Claims vendors' letters, telephone calls, and faxes relating to tax agency holds and updates; updated data entry forms; reviewed and, when possible, resolved daily claims payment exceptions; searched for copies of cleared checks and drafts; did monthly tax filing; created new workflow databases; gave presentations to Claims managers outlining tax compliance issues. TECHNICAL SKILLS Operating Systems: Windows 98, NT Workstation, DOS Software Applications: Extensive Microsoft Excel, Word, Access, and Outlook; some PhotoShop and FrontPage Languages: Superlative oral and written skills in English; good knowledge of spoken and written Spanish, along with some French and German; limited proficiency in reading and writing many other languages Typing: 50 words per minute on most systems REFERENCES Available on request. ------------------------------------------------- REMOTE_ADDR = 63.172.244.130 MAX HERMANN VARÃZSLÓ 24-A MONTEZUMA STREET SAN FRANCISCO, CA 94110 HOME PHONE: (415) 648-0604 OFFICE PHONE: (415) 565-7864 Ext. 516 _______________ RÉSUMÉ July 2004 OBJECTIVE I am seeking a permanent, full-time position which will utilize my outstanding skills in communication, departmental management, customer service, and workflow coordination. EDUCATION Oneness Temple Yeshiva, St. Petersburg, FL (1982-86) Bachelor of Arts in Judaic Studies, May 1986 Minor in Comparative Linguistics CAREER HISTORY 1 Enclosures International Corporation, San Francisco, CA (8/1991-1/1994) Title: Packaging and Shipping Operations Manager Skills: Four-line phone; WordPerfect; in-house tracking and billing software Type: Permanent, full-time, salaried Processed customers' phone and fax orders for packaging, shipping, delivery, and storage of fine artwork, designer furniture, and antiques; monitored packers' workflow to meet seasonal deadlines for holidays and tradeshows; issued estimates for complete transportation packages, when necessary fitting these into the company budget to guarantee a safe profit margin; dispatched drivers both in the San Francisco Bay Area and in Metropolitan Los Angeles; generated and, when necessary, corrected customers' invoices; assisted in resolving damage claims. 2 Sun Air Freight, South San Francisco, CA (7/1994-12/1996, partially concurrent with item 3) Title: Inside Sales/International Department Shipping Manager Skills: Eight-line phone; Lotus-123, Excel, some UNIX Type: Permanent, part- and full-time, hourly wage plus commission Routed both domestic and international shipments of electronics by land, sea, and air at customers' requests by fax, phone, e-mail and pre-arranged shipping contracts; negotiated rates with freight carriers; generated and, when necessary, corrected customers' invoices based on rates eligible for frequency discounts or company promotions; maintained customers' credit histories; implemented international department; balanced monthly accounting records, resolving rate disputes when necessary; secured transportation rebates and commissions from carriers; assisted in both accounts payable and accounts receivable departments, transferring all records to computer spreadsheets; implemented new invoicing and collections procedures; worked with collection agencies on delinquent accounts; resolved delay, damage, and loss claims; supervised customer service telephone personnel. 1 2 MAX HERMANN VARÃZSLÓ 24-A MONTEZUMA STREET SAN FRANCISCO, CA 94110 HOME PHONE: (415) 648-0604 OFFICE PHONE: (415) 565-7864 Ext. 516 _______________ CAREER HISTORY, continued 3 Wollborg-Michels Personnel, San Francisco, CA (10/1996-11/1997) Title: Temporary Contractor Assigned to CSAA Skills: CSAA applications DOTS and UBS Type: Permanent, part- and full-time, hourly wage plus commission Reviewed membership invoices in detail; made necessary data repairs online; processed members' requests for upgrades, additions, and other changes to their accounts. 4 California State Automobile Association, San Francisco, CA (11/1997-11/1998) A Title: Billing Repair Technician Skills: DOTS, UBS, some MSAS; Word, Excel, Access, some Foxpro, some TSO Type: Fixed-term temporary, full-time, biweekly wage Reviewed membership invoices in detail; made necessary data repairs online; downloaded daily and weekly billing error and exception reports and resolved billing problems; processed members' requests for upgrades, additions, and other changes to their accounts; as billing repair team lead (1998), supervised and trained six co-workers. B Remittance Processing System Liaison (11/1998-12/2001) Skills: In addition to the above: PeopleSoft, Fast Tax, B of A online applications Type: Permanent, full-time, biweekly wage Posted and maintained vendor information in Online Claims System to facilitate claims payment and correct tax reporting; compiled payment breakdowns for vendors and, when necessary, made corrections to totals; forwarded tax levy payments to appropriate tax authorities; acted as liaison between Tax and Claims Departments, and between Membership and Financial Reporting Departments; trained new staff members in Credit Card Unit and Claims tax reporting group; upgraded refund and district office balancing procedures; did workflow and productivity analysis as needed; responded to members' letters, telephone calls, and faxes relating to payments, refunds, and fund applications; entered and maintained credit card payment batches; resolved disputes and overpayments; assisted in logging daily journal entries and in preparing nightly closeout; wrote and, in some cases, revised procedures for each section in the department; designed data entry forms. C Claims Operations Specialist (1/2002 - present) Skills: In addition to the above: Microsoft PowerPoint and PhotoEditor, some Scopus/HAL Type: Fixed-term temporary, full-time, biweekly wage Maintained vendor information in Online Claims System to facilitate claims payment and correct tax reporting; compiled payment breakdowns for vendors and, when necessary, made corrections to totals; forwarded tax levy payments to appropriate tax authorities; did workflow and productivity analysis as needed; responded to Claims vendors' letters, telephone calls, and faxes relating to tax agency holds and updates; updated data entry forms; reviewed and, when possible, resolved daily claims payment exceptions; searched for copies of cleared checks and drafts; did monthly tax filing; created new workflow databases; gave presentations to Claims managers outlining tax compliance issues. TECHNICAL SKILLS Operating Systems: Windows 98, NT Workstation, DOS Software Applications: Extensive Microsoft Excel, Word, Access, and Outlook; some PhotoShop and FrontPage Languages: Superlative oral and written skills in English; good knowledge of spoken and written Spanish, along with some French and German; limited proficiency in reading and writing many other languages Typing: 50 words per minute on most systems REFERENCES Available on request. ------------------------------------------------- REMOTE_ADDR = 63.172.244.130 MAX HERMANN VARÃZSLÓ 24-A MONTEZUMA STREET SAN FRANCISCO, CA 94110 HOME PHONE: (415) 648-0604 OFFICE PHONE: (415) 565-7864 Ext. 516 ------------------------------------------------- REMOTE_ADDR = 63.172.244.130 MAX HERMANN VARÃZSLÓ 24-A MONTEZUMA STREET SAN FRANCISCO, CA 94110 ------------------------------------------------- REMOTE_ADDR = 199.67.138.76 ------------------------------------------------- REMOTE_ADDR = 199.67.138.76 wccrs1-1:/opt/Marimba: ------------------------------------------------- REMOTE_ADDR = 199.67.138.76 wccrs1-1:/opt/Marimba: ------------------------------------------------- REMOTE_ADDR = 63.172.244.130 Hi There G-Money ------------------------------------------------- REMOTE_ADDR = 213.164.244.211 phreaker.net ------------------------------------------------- REMOTE_ADDR = 129.101.142.236 howdy here is some text ------------------------------------------------- REMOTE_ADDR = 12.9.138.11 6889-80U ------------------------------------------------- REMOTE_ADDR = 83.228.2.100 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Cisco Security Advisory: Cisco Telnet Denial of Service Vulnerability Revision 1.0 For Public Release 2004 August 27 1000 UTC - ------------------------------------------------------------------------- Contents Summary Affected Products Details Impact Software Versions and Fixes Obtaining Fixed Software Workarounds Exploitation and Public Announcements Status of This Notice: INTERIM Distribution Revision History Cisco Security Procedures - ------------------------------------------------------------------------- Summary ======= A specifically crafted Transmission Control Protocol (TCP) connection to a telnet or reverse telnet port of a Cisco device running Internetwork Operating System (IOS) may block further telnet, reverse telnet, Remote Shell (RSH), Secure Shell (SSH), and in some cases Hypertext Transport Protocol (HTTP) access to the Cisco device. Telnet, reverse telnet, RSH and SSH sessions established prior to exploitation are not affected. All other device services will operate normally. Services such as packet forwarding, routing protocols and all other communication to and through the device are not affected. Cisco will make free software available to address this vulnerability. Workarounds, identified below, are available that protect against this vulnerability. This vulnerability is documented in Cisco bug ID CSCef46191 ( registered customers only) . This Advisory is available at http://www.cisco.com/warp/public/707/cisco-sa-20040827-telnet.shtml. Affected Products ================= Vulnerable Products - ------------------- This vulnerability affects all Cisco devices that permit access via telnet or reverse telnet and are running an unfixed version of IOS. Products Confirmed Not Vulnerable - --------------------------------- Cisco products that do not run IOS are not affected. Details ======= Telnet, RSH and SSH are used for remote management of Cisco IOS devices. The SSH protocol is also used for Secure Copy (SCP), which allows an encryption-protected transfer of files to and from Cisco devices. HTTP is also used for management of certain Cisco devices. IOS versions prior to12.2(15)T include HTTP server version 1.0, which, if configured, will be unresponsive on a device that is under exploitation. IOS versions after and including 12.2(15)T include HTTP server version 1.1, which is unaffected. Reverse telnet is a feature that allows you to telnet to a Cisco device and then connect to a third device through an asynchronous serial connection. For more information on reverse telnet, consult the following documents: http://cisco.com/en/US/products/sw/iosswrel/ps1828/products_configuration_guide_chapter09186a00800871ec.html http://cisco.com/en/US/products/sw/iosswrel/ps1826/products_configuration_guide_chapter09186a00800d9bd8.html Cisco devices that are operating as a reverse telnet server may have ports open in the ranges of: * 2001 to 2999 * 3001 to 3099 * 6001 to 6999 * 7001 to 7099 After a specially crafted TCP connection to an IOS device on TCP port 23 or the reverse telnet ports listed above, all subsequent telnet, reverse telnet, RSH (TCP port 514), SSH, SCP (SSH and SCP use TCP port 22), and in some cases HTTP (TCP port 80) connections to the device experiencing exploitation will be unsuccessful. Any telnet, reverse telnet, RSH, SSH, SCP and HTTP sessions that are already established with the device will continue to function properly. In Cisco IOS, telnet, reverse telnet, RSH, SSH, SCP and some HTTP sessions are handled by a virtual terminal (VTY). Each telnet, reverse telnet, RSH, SSH and SCP session consumes a VTY. After successful exploitation, the Cisco device can no longer accept any subsequent VTY connections. Though it is not possible to establish new telnet, reverse telnet, RSH, SSH, SCP or HTTP connections to the device after a successful exploitation, the device is only vulnerable on TCP port 23 and the reverse telnet ports listed above. A successful exploitation of this vulnerability requires a complete 3-way TCP handshake, which makes it very difficult to spoof the source IP address. Only remote access services that use VTYs are affected. This includes telnet, reverse telnet, RSH, SSH, SCP and version 1.0 of the HTTP server. Other device services including, but not limited to, routing protocols, TACACS/RADIUS, Voice over IP (VoIP) and packet forwarding are not affected. This vulnerability is addressed by Cisco bug ID: * CSCef46191 ( registered customers only) To determine the software running on a Cisco product, log in to the device and issue the show version command to display the system banner. Cisco IOS software will identify itself as "Internetwork Operating System Software" or simply "IOS ®". On the next line of output, the image name will be displayed between parentheses, followed by "Version" and the IOS release name. Other Cisco devices will not have the show version command or will give different output. The following example identifies a Cisco product running IOS release 12.0(3) with an installed image name of C2500-IS-L: Cisco Internetwork Operating System Software IOS (TM) 2500 Software (C2500-IS-L), Version 12.0(3), RELEASE SOFTWARE The release train label is "12.0". The next example shows a product running IOS release 12.0(2a)T1 with an image name of C2600-JS-MZ: Cisco Internetwork Operating System Software IOS (tm) C2600 Software (C2600-JS-MZ), Version 12.0(2a)T1, RELEASE SOFTWARE (fc1) Additional information about Cisco IOS Banners is available at http://www.cisco.com/en/US/products/sw/iosswrel/ios_abcs_ios_networking_the_enterprise0900aecd800a4e15.html. Impact ====== Exploitation of this vulnerability may result in the denial of new telnet, reverse telnet, RSH, SSH, SCP and HTTP connections to a device running IOS. Other access to the device via the console or SNMP is not affected. The device will remain in this state until the problematic TCP connection is cleared, or the device is reloaded (which will clear the problematic session). If no other access methods are available, exploitation of this vulnerability could deny remote access to the device. Depending on your network architecture, workarounds may be available to mitigate this vulnerability. Software will be available to repair this vulnerability. Software Versions and Fixes =========================== Cisco is working to release fixes for this vulnerability in all currently maintained IOS releases. No software upgrade is required in order to mitigate this vulnerability. See the information below regarding the available configuration workarounds. The software fixes will appear in regularly scheduled maintenance releases of IOS software. As fixed software becomes available for public release, Cisco will update this section of the advisory. Obtaining Fixed Software ======================== Customers with Service Contracts - -------------------------------- As fixed software becomes available, customers with contracts should obtain the fixed software through their regular update channels. For most customers, this means that such software should be obtained through the Software Center on Cisco's worldwide website at http://www.cisco.com. Customers using Third-party Support Organizations - ------------------------------------------------- Customers whose Cisco products are provided or maintained through prior or existing agreement with third-party support organizations such as Cisco Partners, authorized resellers, or service providers should contact that support organization for assistance with the upgrade or fixed software, which should be free of charge. Customers without Service Contracts - ----------------------------------- Customers who purchase direct from Cisco but who do not hold a Cisco service contract and customers who purchase through third-party vendors but are unsuccessful at obtaining fixed software through their point of sale should get their fixed software by contacting the Cisco Technical Assistance Center (TAC). TAC contacts are as follows. * +1 800 553 2447 (toll free from within North America) * +1 408 526 7209 (toll call from anywhere in the world) * e-mail: tac@cisco.com Please have your product serial number available and give the URL of this notice as evidence of your entitlement to a free upgrade. Free upgrades for non-contract customers must be requested through the TAC. Please do not contact either "psirt@cisco.com" or "security-alert@cisco.com" for software upgrades. See http://www.cisco.com/warp/public/687/Directory/DirTAC.shtml for additional TAC contact information, including special localized telephone numbers and instructions and e-mail addresses for use in various languages. Customers may only install and expect support for the feature sets they have purchased. By installing, downloading, accessing or otherwise using such software upgrades, customers agree to be bound by the terms of Cisco's software license terms found at http://www.cisco.com/public/sw-license-agreement.html, or as otherwise set forth at Cisco.com Downloads at http://www.cisco.com/public/sw-center/sw-usingswc.shtml. Workarounds =========== The effectiveness of any workaround is dependent on specific customer situations such as product mix, network topology, traffic behavior, and organizational mission. Customers should consult with their service provider or support organization to ensure any applied workaround is the most appropriate for use in the intended network before it is deployed. Mitigation Strategies - --------------------- Not all of the mitigation strategies listed will work for all customers. Some of the workarounds listed are dependent on which versions and feature-sets of IOS you have in your network. Enabling SSH and disabling telnet - --------------------------------- Note: SSH support is only available in certain IOS feature sets and platforms Cisco devices that support SSH can enable it by following the steps listed here: http://cisco.com/en/US/products/sw/iosswrel/ps1835/products_configuration_guide_chapter09186a00800ca7d5.html#1001167 To disable telnet access to the device, configure the following on all your VTY lines: Router(config)# line vty 0 4 Router(config-line)# transport input ssh Note: Even if SSH is enabled, the IOS device is not protected until telnet access is disabled. Configuring a VTY Access Class - ------------------------------ It is possible to limit the exposure of the Cisco device by applying a VTY access class to permit only known, trusted devices to connect to the device via telnet, reverse telnet, RSH, SSH or SCP. For more information on restricting traffic to VTYs, please consult: http://cisco.com/en/US/products/sw/iosswrel/ps1835/products_command_reference_chapter09186a00800873c8.html#wp1017389 Configuring Interface Access Lists (ACLs) - ----------------------------------------- In addition to configuring a VTY Access Class, it may be desirable to block all telnet traffic from entering the network. The example below demonstrates how to block TCP port 23 and the reverse telnet traffic while permitting all other IP traffic. Router(config)# access-list 100 deny tcp any any eq telnet Router(config)# access-list 100 deny tcp any any range 2001 2999 Router(config)# access-list 100 deny tcp any any range 3001 3099 Router(config)# access-list 100 deny tcp any any range 6001 6999 Router(config)# access-list 100 deny tcp any any range 7001 7099 Router(config)# access-list 100 permit ip any any The access list must then be configured to block inbound traffic on all public-facing interfaces: Router(config)# interface Ethernet 0/0 Router(config-if)# ip access-group 100 in Telnet should be blocked as part of a Transit ACL controlling all access to the trusted network. Transit ACLs are considered a network security best practice and should be considered as a long-term addition to good network security, as well as a workaround for this specific vulnerability. The white paper entitled "Transit Access Control Lists: Filtering at Your Edge" presents guidelines and recommended deployment techniques for transit ACLs: http://www.cisco.com/warp/public/707/tacl.html Configuring Infrastructure Access Lists (iACLs) - ----------------------------------------------- Although it is often difficult to block traffic transiting your network, it is possible to identify traffic which should never be allowed to target your infrastructure devices and block that traffic at the border of your network. Infrastructure ACLs are considered a network security best practice and should be considered as a long-term addition to good network security as well as a workaround for this specific vulnerability. The white paper entitled "Protecting Your Core: Infrastructure Protection Access Control Lists" presents guidelines and recommended deployment techniques for infrastructure protection ACLs: http://www.cisco.com/warp/public/707/iacl.html Configuring Receive Access Lists (rACLs) - ---------------------------------------- For distributed platforms, rACLs may be an option starting in Cisco IOS Software Versions 12.0(21)S2 for the 12000 series GSR and 12.0(24)S for the 7500 series. The receive access lists protect the device from harmful traffic before the traffic can impact the route processor. Receive path ACLs are considered a network security best practice, and should be considered as a long-term addition to good network security, as well as a workaround for this specific vulnerability. The CPU load is distributed to the line card processors and helps mitigate load on the main route processor. The white paper entitled "GSR: Receive Access Control Lists" will help identify and allow legitimate traffic to your device and deny all unwanted packets: http://www.cisco.com/warp/public/707/racl.html Exploitation and Public Announcements ===================================== The Cisco PSIRT is aware of exploitation of this vulnerability and is recommending customers take action to protect themselves. Status of This Notice: INTERIM ============================== THIS ADVISORY IS PROVIDED ON AN "AS IS" BASIS AND DOES NOT IMPLY ANY KIND OF GUARANTEE OR WARRANTY. YOUR USE OF THE INFORMATION ON THE ADVISORY OR MATERIALS LINKED FROM THE ADVISORY IS AT YOUR OWN RISK. CISCO RESERVES THE RIGHT TO CHANGE OR UPDATE THIS NOTICE AT ANY TIME. CISCO EXPECTS TO UPDATE THIS NOTICE WITHIN 48 to 72 hours FROM THE ORIGINAL DATE OF THIS NOTICE. Distribution ============ This advisory will be posted on Cisco's worldwide website at http://www.cisco.com/warp/public/707/cisco-sa-20040827-telnet.shtml. In addition to worldwide web posting, a text version of this notice is clear-signed with the Cisco PSIRT PGP key and is posted to the following e-mail and Usenet news recipients. * cust-security-announce@cisco.com * first-teams@first.org (includes CERT/CC) * bugtraq@securityfocus.com * vulnwatch@vulnwatch.org * cisco@spot.colorado.edu * cisco-nsp@puck.nether.net * full-disclosure@lists.netsys.com * comp.dcom.sys.cisco@newsgate.cisco.com Future updates of this advisory, if any, will be placed on Cisco's worldwide website, but may or may not be actively announced on mailing lists or newsgroups. Users concerned about this problem are encouraged to check the above URL for any updates. Revision History ================ +---------------------------------------------+ | Revision | 2004-August-27 | Initial public | | 1.0 | | release. | +---------------------------------------------+ Cisco Security Procedures ========================= Complete information on reporting security vulnerabilities in Cisco products, obtaining assistance with security incidents, and registering to receive security information from Cisco, is available on Cisco's worldwide website at http://www.cisco.com/warp/public/707/sec_incident_response.shtml. This includes instructions for press inquiries regarding Cisco security notices. All Cisco security advisories are available at http://www.cisco.com/go/psirt. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFBLxMAezGozzK2tZARAj6eAJ0VX9vmrTBin4Vxt3FchPLIddKAlQCgvt20 dDYTV+/GnsCSHsRfmUz5eJw= =1fzl -----END PGP SIGNATURE----- ------------------------------------------------- REMOTE_ADDR = 66.35.239.94Your browser sent a request that this server could not understand.
Request header field is missing ':' separator.
......Credentials....(...password...nobody..userid...nobody.....amf_server_debug....`..