' . PHP_EOL;
*/
$query_device_permitted = generate_query_permitted(array('device'), array('device_table' => 'D', 'hide_ignored' => TRUE));
$query_port_permitted = generate_query_permitted(array('port'), array('port_table' => 'I', 'hide_ignored' => TRUE));
// Show Device Status
if ($options['devices'])
{
$query = 'SELECT * FROM `devices` AS D';
$query .= ' WHERE D.`status` = 0' . $query_device_permitted;
$query .= ' ORDER BY D.`hostname` ASC';
$entries = dbFetchRows($query);
foreach ($entries as $device)
{
$string .= ' ' . PHP_EOL;
$string .= ' | ' . generate_device_link_short($device) . ' | ' . PHP_EOL;
// $string .= ' Device | ' . PHP_EOL;
$string .= ' Device Down | ' . PHP_EOL;
$string .= ' ' . generate_device_link_short($device) . ' | ' . PHP_EOL;
// $string .= ' ' . escape_html(truncate($device['location'], 30)) . ' | ' . PHP_EOL;
$string .= ' ' . deviceUptime($device, 'short') . ' | ' . PHP_EOL;
$string .= '
' . PHP_EOL;
}
}
// Uptime
if ($options['uptime'])
{
if (filter_var($config['uptime_warning'], FILTER_VALIDATE_FLOAT) !== FALSE && $config['uptime_warning'] > 0)
{
$query = 'SELECT * FROM `devices` AS D';
// Since reboot event more complicated than just device uptime less than some time
//$query .= ' WHERE D.`status` = 1 AND D.`uptime` > 0 AND D.`uptime` < ' . $config['uptime_warning'];
$query .= ' WHERE D.`status` = 1 AND D.`uptime` > 0 AND D.`last_rebooted` > ?';
$query .= $query_device_permitted;
$query .= 'ORDER BY D.`hostname` ASC';
$entries = dbFetchRows($query, array($config['time']['now'] - $config['uptime_warning'] - 10));
foreach ($entries as $device)
{
$string .= ' ' . PHP_EOL;
$string .= ' | ' . generate_device_link_short($device) . ' | ' . PHP_EOL;
// $string .= ' Device | ' . PHP_EOL;
$string .= ' Device Rebooted | ' . PHP_EOL;
$string .= ' ' . generate_device_link_short($device) . ' | ' . PHP_EOL;
// $string .= ' ' . escape_html(truncate($device['location'], 30)) . ' | ' . PHP_EOL;
$string .= ' Uptime ' . format_uptime($device['uptime'], 'short') . ' | ' . PHP_EOL;
$string .= '
' . PHP_EOL;
}
}
}
// Ports Down
if ($options['ports'] || $options['neighbours'] || $options['links'])
{
$options['neighbours'] = $options['neighbours'] && !$options['ports']; // Disable 'neighbours' if 'ports' already enabled
$query = 'SELECT * FROM `ports` AS I ';
if ($options['neighbours'])
{
$query .= 'INNER JOIN `neighbours` AS L ON I.`port_id` = L.`port_id` ';
}
$query .= 'LEFT JOIN `devices` AS D ON I.`device_id` = D.`device_id` ';
$query .= "WHERE D.`status` = 1 AND D.ignore = 0 AND I.ignore = 0 AND I.deleted = 0 AND I.`ifAdminStatus` = 'up' AND (I.`ifOperStatus` = 'lowerLayerDown' OR I.`ifOperStatus` = 'down') ";
if ($options['neighbours'])
{
$query .= ' AND L.`active` = 1 ';
}
$query .= $query_port_permitted;
$query .= ' AND I.`ifLastChange` >= DATE_SUB(NOW(), INTERVAL '.$max_interval.' HOUR) ';
if ($options['neighbours']) { $query .= 'GROUP BY L.`port_id` '; }
$query .= 'ORDER BY I.`ifLastChange` DESC, D.`hostname` ASC, I.`ifDescr` * 1 ASC ';
$entries = dbFetchRows($query);
$i = 1;
foreach ($entries as $port)
{
if ($i > $max_count)
{
$string .= ' | Port | ';
$string .= 'Port Down | ';
$string .= 'Too many ports down. See All DOWN ports. |
' . PHP_EOL;
break;
}
humanize_port($port);
$string .= ' ' . PHP_EOL;
$string .= ' | ' . generate_device_link_short($port) . ' | ' . PHP_EOL;
// $string .= ' Port | ' . PHP_EOL;
$string .= ' Port Down | ' . PHP_EOL;
$string .= ' ' . get_icon('port') . ' ' . generate_port_link_short($port) . ' | ' . PHP_EOL;
// $string .= ' ' . escape_html(truncate($port['location'], 30)) . ' | ' . PHP_EOL;
$string .= ' Down for ' . format_uptime($config['time']['now'] - strtotime($port['ifLastChange']), 'short'); // This is like deviceUptime()
if ($options['links']) { $string .= ' ('.nicecase($port['protocol']).': ' .$port['remote_hostname'].' / ' .$port['remote_port'] .')'; }
$string .= ' | ' . PHP_EOL;
$string .= '
' . PHP_EOL;
$i++;
}
}
// Ports Errors (only deltas)
if ($options['errors'])
{
$query = 'SELECT * FROM `ports` AS I ';
//$query .= 'LEFT JOIN `ports-state` AS E ON I.`port_id` = E.`port_id` ';
$query .= 'LEFT JOIN `devices` AS D ON I.`device_id` = D.`device_id` ';
$query .= "WHERE D.`status` = 1 AND I.`ifOperStatus` = 'up' AND (I.`ifInErrors_delta` > 0 OR I.`ifOutErrors_delta` > 0)";
$query .= $query_port_permitted;
$query .= 'ORDER BY D.`hostname` ASC, I.`ifDescr` * 1 ASC';
$entries = dbFetchRows($query);
foreach ($entries as $port)
{
humanize_port($port);
$string .= ' ' . PHP_EOL;
$string .= ' | ' . generate_device_link_short($port) . ' | ' . PHP_EOL;
// $string .= ' Port | ' . PHP_EOL;
$string .= ' Port Errors | ' . PHP_EOL;
$string .= ' ' . get_icon('port') . ' ' . generate_port_link_short($port, NULL, 'port_errors') . ' | ' . PHP_EOL;
// $string .= ' ' . escape_html(truncate($port['location'], 30)) . ' | ' . PHP_EOL;
$string .= ' Errors ';
if ($port['ifInErrors_delta']) { $string .= 'In: ' . $port['ifInErrors_delta']; }
if ($port['ifInErrors_delta'] && $port['ifOutErrors_delta']) { $string .= ', '; }
if ($port['ifOutErrors_delta']) { $string .= 'Out: ' . $port['ifOutErrors_delta']; }
$string .= ' | ' . PHP_EOL;
$string .= '
' . PHP_EOL;
}
}
// BGP
if ($options['bgp'])
{
if (isset($config['enable_bgp']) && $config['enable_bgp'])
{
// Description for BGP states
$bgpstates = 'IDLE - Router is searching routing table to see whether a route exists to reach the neighbor.
';
$bgpstates .= 'CONNECT - Router found a route to the neighbor and has completed the three-way TCP handshake.
';
$bgpstates .= 'OPEN SENT - Open message sent, with parameters for the BGP session.
';
$bgpstates .= 'OPEN CONFIRM - Router received agreement on the parameters for establishing session.
';
$bgpstates .= 'ACTIVE - Router did not receive agreement on parameters of establishment.
';
//$bgpstates .= 'ESTABLISHED - Peering is established; routing begins.';
$query = 'SELECT * FROM `devices` AS D ';
$query .= 'LEFT JOIN `bgpPeers` AS B ON B.`device_id` = D.`device_id` ';
$query .= "WHERE D.`status` = 1 AND (`bgpPeerAdminStatus` = 'start' OR `bgpPeerAdminStatus` = 'running') AND `bgpPeerState` != 'established' ";
$query .= $query_device_permitted;
$query .= 'ORDER BY D.`hostname` ASC';
$entries = dbFetchRows($query);
foreach ($entries as $peer)
{
humanize_bgp($peer);
$peer_ip = generate_entity_link("bgp_peer", $peer, $peer['human_remoteip']);
$string .= ' ' . PHP_EOL;
$string .= ' | ' . generate_device_link_short($peer, [ 'tab' => 'routing', 'proto' => 'bgp' ]) . ' | ' . PHP_EOL;
// $string .= ' BGP | ' . PHP_EOL;
$string .= ' BGP ' . nicecase($peer['bgpPeerState']) . ' | ' . PHP_EOL;
$string .= ' ' . $peer_ip . ' | ' . PHP_EOL;
// $string .= ' ' . escape_html(truncate($peer['location'], 30)) . ' | ' . PHP_EOL;
$string .= ' AS' . $peer['human_remote_as'] . ' : ' . $peer['astext'] . ' | ' . PHP_EOL;
$string .= '
' . PHP_EOL;
}
}
}
// $string .= ' ' . PHP_EOL;
$string .= '