1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
|
--
-- (C) 2013-22 - ntop.org
--
dirs = ntop.getDirs()
package.path = dirs.installdir .. "/scripts/lua/modules/?.lua;" .. package.path
-- io.write ("Session:".._SESSION["session"].."\n")
require "lua_utils"
local page_utils = require("page_utils")
sendHTTPContentTypeHeader('text/html')
page_utils.print_header_minimal()
local prefs = ntop.getPrefs()
local dbname = (prefs.mysql_dbname or '')
-- read the db activities to notify the user about what is going on in the database
local res = ntop.execSingleSQLQuery("show full processlist")
print [[
<div class="container-narrow">
<style type="text/css">
body {
padding-top: 40px;
padding-bottom: 40px;
background-color: #f5f5f5;
}
.please-wait {
max-width: 600px;
padding: 9px 29px 29px;
margin: 0 auto 20px;
background-color: #fff;
border: 1px solid #e5e5e5;
-webkit-border-radius: 5px;
-moz-border-radius: 5px;
border-radius: 5px;
-webkit-box-shadow: 0 1px 2px rgba(0,0,0,.05);
-moz-box-shadow: 0 1px 2px rgba(0,0,0,.05);
box-shadow: 0 1px 2px rgba(0,0,0,.05);
}
.please-wait .please-wait-heading,
</style>
<div class="container please-wait">
<div style="text-align: center; vertical-align: middle">
]]
addLogoSvg()
print[[
</div>
<div>
<br>
]]
print(" "..i18n("please_wait_page.waiting_for_db_msg", {dbname=dbname}))
print[[
</div>
<br>
<div>]]
if res == nil then res = {} end
if #res >= 1 then
print[[
<br>
]] print(i18n("please_wait_page.operations_on_database_msg")) print [[
<small>
<br><br>
<table class="table table-bordered table-striped" width=100%>
<thead>
<tr>
<th>]] print(i18n("please_wait_page.database")) print[[</th><th>]] print(i18n("please_wait_page.state")) print[[</th><th>]] print(i18n("please_wait_page.command")) print[[</th><th>]] print(i18n("please_wait_page.id")) print[[</th><th>]] print(i18n("please_wait_page.user")) print[[</th><th>]] print(i18n("please_wait_page.time")) print[[</th><th>]] print(i18n("please_wait_page.info")) print[[</th><th>]] print(i18n("please_wait_page.host")) print[[</th>
</tr>
</thead>
<tbody>
]]
for i,p in ipairs(res) do
if p["Command"] ~= "Sleep" then
print('<tr>')
print('<td>'..(p["db"] or '')..'</td><td>'..(p["State"] or '')..'</td><td>'..(p["Command"] or '')..'</td><td>'..(p["Id"] or '')..'</td>')
print('<td>'..(p["User"] or '')..'</td><td>'..secondsToTime(tonumber((p["Time"] or '')))..'</td>')
print('<td title="'..(p["Info"] or '')..'">'..shortenString((p["Info"] or ''))..'</td><td>'..(p["Host"] or '')..'</td>')
print('</tr>')
local msg = ""
for k, v in pairs(p) do
msg = msg..k..": "..v.." "
end
end
end
print[[
</tbody>
</table>
</small>
]]
end
local host
if not isEmptyString(_GET["referer"]) then
host = getHttpUrlPrefix().._GET["referer"]
else
host = _SERVER["HTTP_HOST"] .. ntop.getHttpPrefix() .. "/lua/index.lua"
end
print[[</div>
</div> <!-- /container -->
<script type="text/javascript">
var intervalID = setInterval(
function() {
window.location.replace("]] print(host) print[[");
},
5000);
</script>
</body>
</html>
]]
|
