/php/netflow/netflow2_debug.php

<?

		
	 $node["jn"]["jn"][0] = 0;
	 $node["tc9"]["tc9"][0] = 0;


        $ip2node["10.31.10.0"] = "jn";
        $ip2node["10.11.128.0"] = "tc9";


	
	chdir("/opt/app/www/netflow");

	$dbh = mysql_connect('127.0.0.1:3306','root','');
        mysql_select_db('cdnlog',$dbh);

	$sumbyte = 0;
	$rbyte = 0;
	$tbyte = 0;
	$ip_list = array();

	$time = date("Y-m-d H:i:00",mktime()-60);


	$ts = strtotime($time);
	$ts += 60;
	
       // $dbh = mysql_connect('127.0.0.1:3306','root','');
       // mysql_select_db('cdnlog',$dbh);

           $query = "select * from netflow1 where time ='$time'";

	echo $query."\n";
  $result = mysql_query($query,$dbh);
   while($row = mysql_fetch_array($result))
        {


			
                        $ip = $row[2];
                        $ip1 = ip2long($ip) - ip2long($ip)%256;
                        $ip2 = long2ip($ip1);

			

			$name = $ip2node[$ip2];
		
			$node[$name][$ip][1] = $row[3];
			$node[$name][$ip][2] = $row[4];	
			




       }
        mysql_free_result($result);




		foreach( $site as $sitename => $svalue)
		 {

			$rbyte = 0;
			$tbyte = 0;
			$tvalue = NULL;
		

			foreach($node[$svalue] as $ip => $tvalue)
			    {

				$rbyte += $tvalue[1] *  (1024 * 1024);
				$tbyte += $tvalue[2] *  (1024 * 1024);

				$rx = $tvalue[1] *  (1024 * 1024);
				$tx =  $tvalue[2] *  (1024 * 1024);
	
			
				$fname = "/opt/app/www/netflow/".$sitename"_".$ip.".rrd";
				if ( !file_exists($fname)) 
				{
				$cmd = "rrdtool create ".$sitename"_".$ip.".rrd -s 60  --start 1284602820 DS:in:GAUGE:600:0:2000000000 DS:out:GAUGE:600:0:3000000000 RRA:AVERAGE:0.5:1:576 RRA:AVERAGE:0.5:6:672 RRA:AVERAGE:0.5:24:732 RRA:AVERAGE:0.5:144:1460;";
				system($cmd);
				 }


			

				$cmd = "rrdtool update /opt/app/www/netflow/".$sitename."_".$ip.".rrd -t in:out $ts:$rx:$tx";
				echo $cmd."\n";
				system($cmd);

				$cmd = 'rrdtool graph '.$sitename.'_'.$ip.'.png -t "traffic '.$sitename.'_'.$ip.' :: desc" --lazy -h  300  -w  800 -l 0 -u 2000000000 -a  PNG -v bits/sec "DEF:in='.$sitename.'_'.$ip.'.rrd:in:AVERAGE" "DEF:out='.$sitename.'_'.$ip.'.rrd:out:AVERAGE" "CDEF:cdefb=out,0,*" "AREA:in#32CD32:Incoming" "LINE1:in#336600" "GPRINT:in:MAX:  Max\\: %5.2lf %s" "GPRINT:in:AVERAGE: Avg\\: %5.2lf %S" "GPRINT:in:LAST: Current\\: %5.2lf %Sbits/sec\\n" "LINE1:out#4169E1:Outgoing" "LINE1:cdefb#0033CC" "GPRINT:out:MAX:  Max\\: %5.2lf %S" "GPRINT:out:AVERAGE: Avg\\: %5.2lf %S" "GPRINT:out:LAST: Current\\: %5.2lf %Sbits/sec" "COMMENT:\\n"';

	
				echo $cmd."\n";
				system($cmd);

			     }		
			
		
			echo $svalue.":";
			echo "rx:".$rbyte."\n";
			echo "tx:".$tbyte."\n";

			
			$cmd = "rrdtool update /opt/app/www/netflow/".$svalue."_".$svalue.".rrd -t in:out $ts:$rbyte:$tbyte";
			

			 echo $cmd."\n";
			system($cmd);

			 $cmd = 'rrdtool graph '.$svalue.'_'.$svalue.'.png -t "traffic '.$svalue.' :: desc" --lazy -h  300  -w  800 -l 0 -u 3000000000 -a  PNG -v bits/sec "DEF:in='.$svalue.'_'.$svalue.'.rrd:in:AVERAGE" "DEF:out='.$svalue.'_'.$svalue.'.rrd:out:AVERAGE" "CDEF:cdefb=out,0,*" "AREA:in#32CD32:Incoming" "LINE1:in#336600" "GPRINT:in:MAX:  Max\\: %5.2lf %s" "GPRINT:in:AVERAGE: Avg\\: %5.2lf %S" "GPRINT:in:LAST: Current\\: %5.2lf %Sbits/sec\\n" "LINE1:out#4169E1:Outgoing" "LINE1:cdefb#0033CC" "GPRINT:out:MAX:  Max\\: %5.2lf %S" "GPRINT:out:AVERAGE: Avg\\: %5.2lf %S" "GPRINT:out:LAST: Current\\: %5.2lf %Sbits/sec" "COMMENT:\\n"';

			echo $cmd."\n";
			system($cmd);


		   }




?>