// Delete rows, iterating if (DEBUG) { echo "Deleting current list from HBase\n"; } try { while (true) { $row = $client->scannerGet($scanner); if (sizeof($row) == 0) { break; } if (DEBUG) { $values = $row[0]->columns; $ip = $values["rep:ip"]->value; echo "Deleting {$ip} from list {$listName}/{$listType}\n"; } $client->deleteAllRow("hogzilla_reputation", $row[0]->row, array()); } $client->scannerClose($scanner); // Iterate file while (($ip = fgets($fileHandle)) !== false) { // Parse preg_replace("/\r|\n/", "", $ip); $ip = trim($ip); // Create mutation $mutations = array(); $dataIP = array('column' => "rep:ip", 'value' => $ip); $dataListName = array('column' => "rep:list", 'value' => $listName); $dataListType = array('column' => "rep:list_type", 'value' => $listType); $dataListDesc = array('column' => "rep:description", 'value' => ""); $mutations[] = new Hbase\Mutation($dataIP); $mutations[] = new Hbase\Mutation($dataListName);
echo "Start row: {$startrow} \n"; } $lastHBaseID = 0; // Get HBase pointer //$scanner = $client->scannerOpenWithStop("hogzilla_events",$startrow,"", $scanner = $client->scannerOpenWithStop("hogzilla_events", "", "", array("event:lower_ip", "event:upper_ip", "event:note", "event:signature_id", "event:lower_ip_str", "event:upper_ip_str", "event:ports", "event:title"), array()); // Loop events to insert into MySQL/GrayLog while (true) { $row = $client->scannerGet($scanner); //if($lastHBaseID==0 and $startrow!=0) { $lastHBaseID=$startrow; continue; } /* dismiss the first */ if (sizeof($row) == 0) { break; } saveEvent($row, $con, $cid++); $lastHBaseID = $row[0]->row; $client->deleteAllRow("hogzilla_events", $row[0]->row, array()); if (DEBUG) { echo "Last HBaseID: {$lastHBaseID} \n"; } } // Update last CID on MySQL, this counter will be used on last access if (MYSQL) { saveLastCID($sensorid, $cid, $con); } // Save last seen HBase event saveNextHBaseRow($lastHBaseID); // Close HBase scanner $client->scannerClose($scanner); /* * Add information about clustering *