Crmgo Blog

php skripta za zapisivanje u MySQL logove sa 3proxy

php skripta za zapisivanje u MySQL logove sa 3proxy

<?php /////////////////////////////////////primer konfiguracionog fajla 3PROXY/////////////////////////////// //log /var/log/3proxy/3proxy.log D //logformat "G%t|%C|%R:%r|%O|%I|%n|%T" //rotate 60 //daemon //users promo:CL:xxxx //auth strong //allow promo //proxy -p7777 -n -i192.168.x.xxx -exxx.xxx.xxx.xxx //flush //end /////////////////////////////////////MYSQL//////////////////////////////// //mysql -p //create database 3proxy; //use 3proxy; //CREATE TABLE logs (time datetime, ip_local…

php skripta za zapisivanje u MySQL logove sa 3proxy

<?php
/////////////////////////////////////primer konfig fajla 3PROXY///////////////////////////////
//log /var/log/3proxy/3proxy.log D
//logformat "G%t|%C|%R:%r|%O|%I|%n|%T"
//rotate 60
//daemon
//users promo:CL:xxxx
//auth strong
//allow promo
//proxy -p7777 -n -i192.168.x.xxx -exxx.xxx.xxx.xxx
//flush
//end
/////////////////////////////////////MYSQL////////////////////////////////
//mysql -p
//create database 3proxy;
//use 3proxy;
//CREATE TABLE logs (time datetime, ip_local char(15), ip_remote char(20), out_size int(11), in_size int(11), adr varchar(100));
//GRANT ALL PRIVILEGES ON 3proxy.* TO lomix@localhost IDENTIFIED BY 'lomixcomua' WITH GRANT OPTION;
///////////////////////////////////PHP////////////////////////////////////

$db_host = "localhost";
$db_user = "lomix";
$db_password = "lomixcomua";
$db_name = "3proxy";
$connection = mysql_connect ($db_host, $db_user, $db_password) or die ("error connection");
mysql_select_db($db_name, $connection) or die (mysql_error());

$date_time_array = getdate( time() );
$file_name ="/var/log/3proxy/3proxy.log.".$date_time_array['year'].".".date('m').".".$date_time_array['mday'];
$oldslovo="";
$array=file($file_name);
foreach ($array as $stroka)
{

$slovo = explode("|",$stroka);
//echo($oldslovo." - ".$slovo[5]."\n");
if ($oldslovo!=$slovo[5])
{
$newtime = date("Y:m:d:H:i:s",$slovo[0]);
$query = "Insert into logs values('".$newtime."' , '".$slovo[1]."','$slovo[2]','$slovo[3]',$slovo[4],'$slovo[5]')";
mysql_query ($query, $connection);
//print $query."\n";
//print mysql_error()."\n";
//die();
$oldslovo=$slovo[5];
}
}

//mysql_close($db_name);
?>

Napomena: tekst može biti uz pomoć AI uz ljudsku proveru. Odgovoran: Dmytro Lomaka, Kaltenkirchen.

Kategorije: PHP