def get_overviewServers(): listhap = sql.get_dick_permit() commands = ["top -u haproxy -b -n 1"] for server in sorted(listhap): print('<tr><td class="overviewTr first-collumn"><a name="' + server[1] + '"></a><h3 title="IP ' + server[2] + '">' + server[1] + ':</h3></td>') print( '<td class="overviewTd" style="padding-top: 10px;"><pre style="font-size: 12px;">' ) cmd = 'echo "show info" |nc %s 1999 |grep -e "Ver\|CurrConns\|SessRate\|Maxco\|MB\|Uptime:"' % server[ 2] out = funct.subprocess_execute(cmd) for k in out: if "Ncat: Connection refused." not in k: for r in k: print(r) else: print("Can\'t connect to HAproxy") print( '</pre></td><td style="padding-top: 10px;"><pre style="font-size: 12px; padding-left: 0px;">' ) funct.ssh_command(server[2], commands) print('</td><td style="padding: 10px;font-size: 12px;">') funct.show_backends(server[2]) print('</pre></td><td></td></tr>')
def get_overviewServers(): listhap = sql.get_dick_permit() commands = [ "uname -smor", "haproxy -v |head -1", status_command + "|grep Active | sed 's/^[ \t]*//'" ] commands1 = [ "top -u haproxy -b -n 1" ] for server in sorted(listhap): print('<tr><td class="overviewTr first-collumn"><a name="'+server[1]+'"></a><h3 title="IP ' + server[2] + '">' + server[1] + ':</h3></td>') print('<td class="overviewTd"><pre>') funct.ssh_command(server[2], commands) print('</pre></td><td><pre>') funct.ssh_command(server[2], commands1) print('</td><td style="padding-top: 10px; padding-bottom: 10px;">') funct.show_backends(server[2]) print('</pre></td><td></td></tr>')
def get_overviewServers(): import http.cookies from jinja2 import Environment, FileSystemLoader env = Environment(loader=FileSystemLoader('templates/ajax')) template = env.get_template('overviewServers.html') cookie = http.cookies.SimpleCookie(os.environ.get("HTTP_COOKIE")) user_id = cookie.get('uuid') haproxy_sock_port = sql.get_setting('haproxy_sock_port') listhap = sql.get_dick_permit() commands = ["top -u haproxy -b -n 1"] servers = [] for server in sorted(listhap): server_status = () cmd = 'echo "show info" |nc %s %s |grep -e "Ver\|CurrConns\|SessRate\|Maxco\|MB\|Uptime:"' % ( server[2], haproxy_sock_port) out = funct.subprocess_execute(cmd) out1 = "" for k in out: if "Ncat: Connection refused." not in k: for r in k: out1 += r out1 += "<br />" else: out1 = "Can\'t connect to HAproxy" server_status = (server[1], server[2], out1, funct.ssh_command(server[2], commands), funct.show_backends(server[2], ret=1)) servers.append(server_status) template = template.render(service_status=servers, role=sql.get_user_role_by_uuid(user_id.value)) print(template)
def get_overviewServers(): template = env.get_template('overviewServers.html') commands = ["top -u haproxy -b -n 1"] for server in sorted(listhap): cmd = 'echo "show info" |nc %s %s |grep -e "Ver\|CurrConns\|SessRate\|Maxco\|MB\|Uptime:"' % ( server[2], haproxy_sock_port) out = funct.subprocess_execute(cmd) out1 = "" for k in out: if "Ncat: Connection refused." not in k: for r in k: out1 += r out1 += "<br />" else: out1 = "Can\'t connect to HAproxy" server_status = (server[1], server[2], out1, funct.ssh_command(server[2], commands), funct.show_backends(server[2], ret=1)) servers.append(server_status) template = template.render(service_status=servers) print(template)
async def async_get_overviewServers(serv1, serv2, desc): commands = [ "top -u haproxy -b -n 1" ] cmd = 'echo "show info" |nc %s %s |grep -e "Ver\|CurrConns\|SessRate\|Maxco\|MB\|Uptime:"' % (serv2, haproxy_sock_port) out = funct.subprocess_execute(cmd) out1 = "" for k in out: if "Ncat: Connection refused." not in k: for r in k: out1 += r out1 += "<br />" else: out1 = "Can\'t connect to HAproxy" server_status = (serv1,serv2, out1, funct.ssh_command(serv2, commands),funct.show_backends(serv2, ret=1), desc) return server_status
def show_backends(server_id): data = {} try: servers = check_permit_to_server(server_id) for s in servers: out = funct.show_backends(s[2], ret=1) data = {server_id: out} except: data = {server_id: {"error": "Cannot find the server"}} return dict(error=data) return dict(backends=data)
async def async_get_overviewServers(serv1, serv2, desc): # commands = [ "top -u haproxy -b -n 1" ] # commands = [ "top -u haproxy -b -n 1 -o %MEM |grep -e 'haproxy\|PID' |awk '{print $1\"\t\"$5\"\t\"$9\"\t\"$10\"\t\"$11}'" ] commands = [ "top -u haproxy -b -n 1 -w 67 |grep -e 'haproxy\|PID\|Cpu\|KiB' |grep -v Swap" ] if desc == "hapservers.py": cmd = 'echo "show info" |nc %s %s -w 1|grep -e "Ver\|CurrConns\|Maxco\|MB\|Uptime:"' % ( serv2, haproxy_sock_port) else: cmd = 'echo "show info" |nc %s %s -w 1|grep -e "Ver\|CurrConns\|SessRate\|Maxco\|MB\|Uptime:"' % ( serv2, haproxy_sock_port) out = funct.subprocess_execute(cmd) out1 = "" user_id = cookie.get('uuid') role = sql.get_user_role_by_uuid(user_id.value) hap_configs_dir = funct.get_config_var('configs', 'haproxy_save_configs_dir') cfg = hap_configs_dir + serv2 + "-" + funct.get_data('config') + ".cfg" funct.get_config(serv2, cfg) backends = funct.get_sections(cfg) os.system("/bin/rm -f " + cfg) for k in out: if "Ncat: Connection refused." not in k and "Ncat: Connection timed out." not in k: for r in k: out1 += r out1 += "<br />" else: out1 = "Can\'t connect to HAproxy" if role <= 2: server_status = (serv1, serv2, out1, funct.ssh_command(serv2, commands), backends, desc) else: server_status = (serv1, serv2, out1, funct.ssh_command(serv2, commands), funct.show_backends(serv2, ret=1), desc) return server_status
for master in MASTERS: if master[0] != None: funct.upload(master[0], cert_path, name) try: funct.upload(serv, cert_path, name) except Exception as e: funct.logging('localhost', e.args[0], haproxywi=1) try: os.system("mv %s %s" % (name, cert_local_dir)) except OSError as e: funct.logging('localhost', e.args[0], haproxywi=1) funct.logging(serv, "add.py#ssl upload new ssl cert %s" % name) if form.getvalue('backend') is not None: funct.show_backends(serv) if form.getvalue('ip') is not None and serv is not None: commands = [ "sudo ip a |grep inet |egrep -v '::1' |awk '{ print $2 }' |awk -F'/' '{ print $1 }'" ] funct.ssh_command(serv, commands, ip="1") if form.getvalue('showif'): commands = [ "sudo ip link|grep 'UP' |grep -v 'lo'| awk '{print $2}' |awk -F':' '{print $1}'" ] funct.ssh_command(serv, commands, ip="1") if form.getvalue('action_hap') is not None and serv is not None: action = form.getvalue('action_hap')