def removeSsid5GhzRadius(): if request.method == 'GET': if session.get("username") is not None: conn = cardinalSql() status = request.args.get('status') removeSsidCursor = conn.cursor() removeSsidCursor.execute( "SELECT ap_ssid_id,ap_ssid_name FROM ssids_5ghz_radius") ssids = removeSsidCursor.fetchall() removeSsidCursor.close() conn.close() return render_template("remove-ssid-5ghz-radius.html", status=status, ssids=ssids) else: return msgAuthFailed, 401 elif request.method == 'POST': if session.get("username") is not None: conn = cardinalSql() ssidId = request.form["ssid_id"] apId = session.get('apId') apName = session.get('apName') ssidInfo = getSsidInfo(ssidId=ssidId, ssidType="ssid_5ghz_radius") checkSsidRelationship = ssidCheck(apId=apId, ssidId=ssidId, ssidType="ssid_5ghz_radius", action="remove", commit="False") if checkSsidRelationship: apInfoCursor = conn.cursor() apInfoCursor.execute( "SELECT ap_ip,ap_ssh_username,ap_ssh_password FROM access_points WHERE ap_id = %s", [apId]) apInfo = apInfoCursor.fetchall() apInfoCursor.close() encryptedSshPassword = bytes(apInfo[0][2], 'utf-8') apSshPassword = cipherSuite.decrypt( encryptedSshPassword).decode('utf-8') scout_ssid.scoutDeleteSsid5(ip=apInfo[0][0], username=apInfo[0][1], password=apSshPassword, ssid=ssidInfo[0][0], vlan=ssidInfo[0][1], radioSub=ssidInfo[0][3], gigaSub=ssidInfo[0][4]) commitRelationship = ssidCheck(apId=apId, ssidId=ssidId, ssidType="ssid_5ghz_radius", action="remove", commit="True") status = "Removal of 5GHz RADIUS SSID {0} for AP {1} Has Been Successfully Initiated!".format( ssidInfo[0][0], apName) conn.close() return redirect( url_for('cardinal_ssid_ops_bp.removeSsid5GhzRadius', status=status)) else: return msgAuthFailed, 401
def deploySsid5GhzRadiusGroup(): if request.method == 'GET': if session.get("username") is not None: conn = cardinalSql() status = request.args.get('status') deploySsidCursor = conn.cursor() deploySsidCursor.execute( "SELECT ap_ssid_id,ap_ssid_name FROM ssids_5ghz_radius") ssids = deploySsidCursor.fetchall() deploySsidCursor.close() conn.close() return render_template("deploy-ssid-5ghz-radius-group.html", status=status, ssids=ssids) else: return msgAuthFailed, 401 elif request.method == 'POST': if session.get("username") is not None: ssidId = request.form["ssid_id"] apGroupId = session.get('apGroupId') apGroupName = session.get('apGroupName') ssidInfo = getSsidInfo(ssidId=ssidId, ssidType="ssid_5ghz_radius") encryptedSharedSecret = bytes(ssidInfo[0][6], 'utf-8') sharedSecret = cipherSuite.decrypt(encryptedSharedSecret).decode( 'utf-8') apList = apGroupIterator(apGroupId=apGroupId, ssid=ssidInfo[0][0], vlan=ssidInfo[0][1], bridgeGroup=ssidInfo[0][2], radioSub=ssidInfo[0][3], gigaSub=ssidInfo[0][4], radiusIp=ssidInfo[0][5], sharedSecret=sharedSecret, authPort=ssidInfo[0][7], acctPort=ssidInfo[0][8], radiusTimeout=ssidInfo[0][9], radiusGroup=ssidInfo[0][10], methodList=ssidInfo[0][11]) startTime = time.time() task = processor(operation=scout_ssid.scoutCreateSsid5Radius, apInfo=apList) endTime = time.time() - startTime status = "Deployment of 5GHz SSID {0} for AP Group {1} Has Been Successfully Initiated!".format( ssidInfo[0][0], apGroupName) completionTime = printCompletionTime(endTime) return redirect( url_for('cardinal_ssid_ops_bp.deploySsid5GhzRadiusGroup', status=status)) else: return msgAuthFailed, 401
def removeSsid5GhzRadiusGroup(): if request.method == 'GET': if session.get("username") is not None: conn = cardinalSql() status = request.args.get('status') deploySsidCursor = conn.cursor() deploySsidCursor.execute( "SELECT ap_ssid_id,ap_ssid_name FROM ssids_5ghz_radius") ssids = deploySsidCursor.fetchall() deploySsidCursor.close() conn.close() return render_template("remove-ssid-5ghz-radius-group.html", status=status, ssids=ssids) else: return msgAuthFailed, 401 elif request.method == 'POST': if session.get("username") is not None: ssidId = request.form["ssid_id"] apGroupId = session.get('apGroupId') apGroupName = session.get('apGroupName') ssidInfo = getSsidInfo(ssidId=ssidId, ssidType="ssid_5ghz_radius") apList = apGroupIterator(apGroupId=apGroupId, ssid=ssidInfo[0][0], vlan=ssidInfo[0][1], radioSub=ssidInfo[0][3], gigaSub=ssidInfo[0][4]) startTime = time.time() task = processor(operation=scout_ssid.scoutDeleteSsid5, apInfo=apList) endTime = time.time() - startTime status = "Deployment of 5GHz RADIUS SSID {0} for AP Group {1} Has Been Successfully Initiated!".format( ssidInfo[0][0], apGroupName) completionTime = printCompletionTime(endTime) return redirect( url_for('cardinal_ssid_ops_bp.removeSsid5GhzRadiusGroup', status=status)) else: return msgAuthFailed, 401
def deploySsid24Ghz(): if request.method == 'GET': if session.get("username") is not None: conn = cardinalSql() status = request.args.get('status') deploySsidCursor = conn.cursor() deploySsidCursor.execute( "SELECT ap_ssid_id,ap_ssid_name FROM ssids_24ghz") ssids = deploySsidCursor.fetchall() deploySsidCursor.close() conn.close() return render_template("deploy-ssid-24ghz.html", status=status, ssids=ssids) else: return msgAuthFailed, 401 elif request.method == 'POST': if session.get("username") is not None: conn = cardinalSql() ssidId = request.form["ssid_id"] apId = session.get('apId') apName = session.get('apName') ssidInfo = getSsidInfo(ssidId=ssidId, ssidType="ssid_24ghz") encryptedWpa2Pass = bytes(ssidInfo[0][2], 'utf-8') wpa2Pass = cipherSuite.decrypt(encryptedWpa2Pass).decode('utf-8') checkSsidRelationship = ssidCheck(apId=apId, ssidId=ssidId, ssidType="ssid_24ghz", action="add", commit="False") if checkSsidRelationship: apInfoCursor = conn.cursor() apInfoCursor.execute( "SELECT ap_ip,ap_ssh_username,ap_ssh_password FROM access_points WHERE ap_id = %s", [apId]) apInfo = apInfoCursor.fetchall() apInfoCursor.close() encryptedSshPassword = bytes(apInfo[0][2], 'utf-8') apSshPassword = cipherSuite.decrypt( encryptedSshPassword).decode('utf-8') scout_ssid.scoutCreateSsid24(ip=apInfo[0][0], username=apInfo[0][1], password=apSshPassword, ssid=ssidInfo[0][0], vlan=ssidInfo[0][1], wpa2Pass=wpa2Pass, bridgeGroup=ssidInfo[0][3], radioSub=ssidInfo[0][4], gigaSub=ssidInfo[0][5]) commitRelationship = ssidCheck(apId=apId, ssidId=ssidId, ssidType="ssid_24ghz", action="add", commit="True") status = "Deployment of 2.4GHz SSID {0} for AP {1} Has Been Successfully Initiated!".format( ssidInfo[0][0], apName) conn.close() return redirect( url_for('cardinal_ssid_ops_bp.deploySsid24Ghz', status=status)) else: conn.close() status = "2.4GHz SSID {0} is already deployed on {1}".format( ssidInfo[0][0], apName) return redirect( url_for('cardinal_ssid_ops_bp.deploySsid24Ghz', status=status)) else: return msgAuthFailed, 401