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; }