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')
