public function SysLogEquipo()
{
$device = Input::get('id');
$ip = Equipos::find($device)->ifaddr;
$conn = DB::connection('SysLog');
$select = "select fo, host, facility, priority, level, program, msg from logs where host='{$ip}' order by fo";
$result = $conn->select($select);
$datos = array();
foreach ($result as $syslog) {
$datos[] = $syslog;
}
$datos = json_encode($datos);
DB::disconnect('SysLog');
return $datos;
}
public function generateGraphs()
{
$serviceid = Input::get('serviceid');
$conn = DB::connection('mysql');
$select = "select on_device as idhost from glpi_networking_ports where name like '%{$serviceid}%'";
$result = $conn->select($select);
if (isset($result[0]->idhost)) {
$idhost = $result[0]->idhost;
}
if (isset($idhost)) {
$equipo = Equipos::find($idhost);
$filetemp = "/usr/local/scripts/cactigraphs/log/log_{$serviceid}_{$idhost}.txt";
// $commando = "perl /usr/local/scripts/cactigraphs/create_graphs.pl {$equipo->ifaddr} {$serviceid} > {$filetemp} 2>&1";
$commando = "perl /usr/local/scripts/cactigraphs/create_graphs.pl {$equipo->ifaddr} {$serviceid}";
// $result = $commando;
// $result = system($commando);
$result = system($commando);
//$result = `cat $filetemp`;
} else {
$result = "Este servicio no tiene Host relacionado";
}
return $result;
}
