// All rights reserved. // Redistribution and use in source and binary forms, with or without // modification, are permitted provided that the following conditions // are met: // 1. Redistributions of source code must retain the above copyright // notice, this list of conditions and the following disclaimer. // 2. Redistributions in binary form must reproduce the above copyright // notice, this list of conditions and the following disclaimer in the // documentation and/or other materials provided with the distribution. // THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS'' AND // ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE // IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE // ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE // FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL // DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS // OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) // HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT // LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY // OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF // SUCH DAMAGE. include_once 'db.inc.php'; include_once 'swreg/swreg.inc.php'; require_once 'Log.php'; require_once 'functions.php'; $dsn = "$db_driver:host=$db_host;dbname=$db_name"; $options = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ]; try { $dbh = new PDO($dsn, $db_user, $db_pass, $options); } catch (PDOException $e) { die($e->getMessage()); } $logger = Log::singleton('file', LOGFILE, TOOL_NAME . ' : Port Profiles'); if ($logger === false) { die("Failed to open logfile.\n"); } $mask = Log::MAX(LOG_LEVEL); $logger->setMask($mask); $base = get_base($_SERVER['SCRIPT_NAME']); $ruser = ''; if (isset($_SERVER['REMOTE_USER'])) { $ruser = $_SERVER['REMOTE_USER']; } $errors = array(); if (isset($_REQUEST['submit'])) { $d = $_REQUEST['delete']; foreach ($d as $profile => $value) { if ($value == 1) { $sql = "DELETE FROM EXCEPTIONS WHERE name=:name"; try { $sth = $dbh->prepare($sql); $sth->execute(['name' => $profile]); $sth->closeCursor(); unlink(PORT_PROFILE_DIR . "/{$profile}.tmpl"); $logger->info("User {$ruser} deleted port profile {$profile}"); } catch (PDOException $e) { array_push($errors, "Failed to delete {$profile}: {$e->getMessage()}"); } } } } $wc = ''; $params = null; if (isset($_REQUEST['filter'])) { if ($_REQUEST['filter'] != 'All') { $wc = " WHERE pid = :pid"; $params = ['pid' => $_REQUEST['filter']]; } } $sql = 'SELECT EXCEPTIONS.* FROM EXCEPTIONS ' . $wc . ' ORDER BY name'; if (isset($_REQUEST['profile_name'])) { $sql = "SELECT * FROM EXCEPTIONS WHERE name LIKE :name ORDER BY name"; $params = ['name' => "%{$_REQUEST['profile_name']}%"]; } $res = null; try { $res = $dbh->prepare($sql); $res->execute($params); } catch (PDOException $e) { echo "

Error querying for port profiles: {$e->getMessage()}

\r\n"; exit(1); } $profiles = array(); while ($row = $res->fetch()) { array_push($profiles, $row); } $filter = ''; if (isset($_REQUEST['filter'])) { $filter = $_REQUEST['filter']; } print_header(TOOL_NAME . ': Port Profiles'); ?>

Add Port Profile | Logical Switches

$value) { ?>

Row No.	Delete?	Name	Product ID	File Name	View
.					&dname=", "Config for profile ", "height=650,width=980"); return false;'>View