def do_ping(): color = str(settings.get_color()) check_database() cnx = mysql.connector.connect(user="******", password="******", host="localhost", database="iisc") cursor = cnx.cursor() cursor.execute("select ip from tree") for ip in cursor: if ip: update_database(str(ip[0])) graph_for_ping(str(ip[0]), color) else: pass cursor.close() cnx.close()
def get_host(): color = str(settings.get_color()) cnx = mysql.connector.connect(user='******', password='******', host='localhost', database='iisc') cursor = cnx.cursor() cursor.execute("select ip from host") for ip in cursor: last_hour(ip[0],color) last_24hour(ip[0],color) last_week(ip[0],color) last_4week(ip[0],color) last_6months(ip[0],color) last_1year(ip[0],color) cursor.close() cnx.close()
def internet_bandwidth_graph(): color = str(settings.get_color()) if not os.path.exists('database/proxy_ib.rrd'): rrdtool.create("database/proxy_ib.rrd", "--step", "300", "--start", "0", "DS:speed:GAUGE:600:U:U", "RRA:AVERAGE:0.5:1:10080", "RRA:AVERAGE:0.5:5:8934", "RRA:AVERAGE:0.5:60:8784", "RRA:AVERAGE:0.5:1440:3660" ) f = open("temp/speed.txt").readline().rstrip() rrdtool.update("database/proxy_ib.rrd","N:%s" % f) rrdtool.graph("images/proxy_ib.png", "-a", "PNG", "--title", "Internet Bandwidth", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp"+color+":Speed" ) rrdtool.graph("images/proxy_ib1hr.png", "-a", "PNG", "--title", "Internet Bandwidth", "--start", "end-1h", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp"+color+":Speed" ) rrdtool.graph("images/proxy_ib1week.png", "-a", "PNG", "--title", "Internet Bandwidth", "--end", "00:00", "--start", "end-1w", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp"+color+":Speed" ) rrdtool.graph("images/proxy_ib4week.png", "-a", "PNG", "--title", "Internet Bandwidth", "--end", "00:00", "--start", "end-4w", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp"+color+":Speed" ) rrdtool.graph("images/proxy_ib24week.png", "-a", "PNG", "--title", "Internet Bandwidth", "--end", "00:00", "--start", "end-24w", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp"+color+":Speed" ) rrdtool.graph("images/proxy_ib1year.png", "-a", "PNG", "--title", "Internet Bandwidth", "--end", "00:00", "--start", "end-1y", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp"+color+":Speed" )
def get_host(): color = str(settings.get_color()) cnx = mysql.connector.connect(user='******', password='******', host='localhost', database='iisc') cursor = cnx.cursor() cursor.execute("select ip from host") for ip in cursor: last_hour(ip[0], color) last_24hour(ip[0], color) last_week(ip[0], color) last_4week(ip[0], color) last_6months(ip[0], color) last_1year(ip[0], color) cursor.close() cnx.close()
def do_ping(): color = str(settings.get_color()) check_database() cnx = mysql.connector.connect(user='******', password='******', host='localhost', database='iisc') cursor = cnx.cursor() cursor.execute("select ip from tree") for ip in cursor: if ip: update_database(str(ip[0])) graph_for_ping(str(ip[0]), color) else: pass cursor.close() cnx.close()
def apply_histo_linecolor(wrps, colors=None): """ Uses ``histo.SetLineColor``. Colors from settings, if not given. :param wrps: HistoWrapper iterable :param colors: Integer list :yields: HistoWrapper """ n = 0 for wrp in wrps: if hasattr(wrp, "histo"): if colors: color = colors[n%len(colors)] n += 1 else: color = settings.get_color(wrp.sample) if color: wrp.histo.SetLineColor(color) yield wrp
def apply_histo_linecolor(wrps, colors=None): """ Uses ``histo.SetLineColor``. Colors from settings, if not given. :param wrps: HistoWrapper iterable :param colors: Integer list :yields: HistoWrapper """ n = 0 for wrp in wrps: if hasattr(wrp, "histo"): if colors: color = colors[n % len(colors)] n += 1 else: color = settings.get_color(wrp.sample) if color: wrp.histo.SetLineColor(color) yield wrp
def internet_bandwidth_graph(): color = str(settings.get_color()) if not os.path.exists('database/proxy_ib.rrd'): rrdtool.create("database/proxy_ib.rrd", "--step", "300", "--start", "0", "DS:speed:GAUGE:600:U:U", "RRA:AVERAGE:0.5:1:10080", "RRA:AVERAGE:0.5:5:8934", "RRA:AVERAGE:0.5:60:8784", "RRA:AVERAGE:0.5:1440:3660") f = open("temp/speed.txt").readline().rstrip() rrdtool.update("database/proxy_ib.rrd", "N:%s" % f) rrdtool.graph("images/proxy_ib.png", "-a", "PNG", "--title", "Internet Bandwidth", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp" + color + ":Speed") rrdtool.graph("images/proxy_ib1hr.png", "-a", "PNG", "--title", "Internet Bandwidth", "--start", "end-1h", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp" + color + ":Speed") rrdtool.graph("images/proxy_ib1week.png", "-a", "PNG", "--title", "Internet Bandwidth", "--end", "00:00", "--start", "end-1w", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp" + color + ":Speed") rrdtool.graph("images/proxy_ib4week.png", "-a", "PNG", "--title", "Internet Bandwidth", "--end", "00:00", "--start", "end-4w", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp" + color + ":Speed") rrdtool.graph("images/proxy_ib24week.png", "-a", "PNG", "--title", "Internet Bandwidth", "--end", "00:00", "--start", "end-24w", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp" + color + ":Speed") rrdtool.graph("images/proxy_ib1year.png", "-a", "PNG", "--title", "Internet Bandwidth", "--end", "00:00", "--start", "end-1y", "--width", "900", "--height", "200", "--vertical-label", "MB/s", "DEF:sp=database/proxy_ib.rrd:speed:AVERAGE", "AREA:sp" + color + ":Speed")
cnx.close() print """ |_ _|_ _/ ___| ___ | \ | | ___| |___ _____ _ __| | __ | | | |\___ \ / __| | \| |/ _ \ __\ \ /\ / / _ \| '__| |/ / | | | | ___) | (__ | |\ | __/ |_ \ V V / (_) | | | < |___|___|____/ \___| |_| \_|\___|\__| \_/\_/ \___/|_| |_|\_\ __ __ _ _ | \/ | ___ _ __ (_) |_ ___ _ __ | |\/| |/ _ \| '_ \| | __/ _ \| '__| | | | | (_) | | | | | || (_) | | Version: 0.2 |_| |_|\___/|_| |_|_|\__\___/|_| By: Shashank Suresh Kulal """ #i = 1 #while True: color = settings.get_color() do_ping(color) #sys.stdout.write("Ping done %s times.\r" % str(i)) #sys.stdout.flush() #i += 1 print "Entering Bandwidth function" functions.internet_bandwidth() print "Entering Bandwidth function" functions.internet_bandwidth_graph() print "Entering pingraph" pinggraph.get_host() print "Entering tree ping" tree.do_ping() #time.sleep(60) i_speed.check_db() print "Exiting python script"