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
|
module(..., package.seeall)
-- Load libraries
require("modelfunctions")
require("fs")
require("format")
-- Set variables
local processname = "postgresql"
local packagename = "postgresql"
local datadirectory = "/var/lib/postgresql/data/"
local pidfile = "postmaster.pid"
local path = "PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin "
local filelist = fs.find_files_as_array(".*\.conf", datadirectory)
-- ################################################################################
-- LOCAL FUNCTIONS
-- ################################################################################
-- PUBLIC FUNCTIONS
function startstop_service(action)
-- Custom startstop to enable setup option
local result = cfe({ label="Start/Stop result" })
if (string.lower(action) == "start") or (string.lower(action) == "stop") or (string.lower(action) == "restart") or (string.lower(action) == "setup") then
local file = io.popen(path .. "/etc/init.d/" .. processname .. " " .. string.lower(action) .. " 2>&1" )
if file ~= nil then
result.value = file:read( "*a" ) or ""
file:close()
end
posix.sleep(2)-- Wait for the process to start|stop
else
result.errtxt = "Unknown command!"
end
return result
end
function getstatus()
local status = modelfunctions.getstatus(processname, packagename, "Postgresql Status")
-- Enabled status is unique for postgresql
-- Look for pid file stored in data_directory .. /postmaster.pid
local file = datadirectory .. pidfile
-- check to see if there's a matching proc directory and that it was created slightly after the pid file
-- this allows us to avoid the problem with proc numbers wrapping
local tmp = string.match(fs.read_file(file) or "", "%d+")
if tmp then
local dir = "/proc/" .. tmp
filetime = posix.stat(file, "ctime")
dirtime = posix.stat(dir, "ctime")
if dirtime and (tonumber(dirtime) - tonumber(filetime) < 100) then
status.value.status.value = "Running"
end
end
return status
end
function getstatusdetails()
return cfe({ type="longtext", value="", label="Postgresql Status Details" })
end
function getfilelist()
local listed_files = {}
for i,name in ipairs(filelist) do
local filedetails = fs.stat(name) or {}
table.insert ( listed_files , {filename=name, mtime=filedetails.mtime or "---", filesize=filedetails.size or "0"} )
end
table.sort(listed_files, function (a,b) return (a.filename < b.filename) end )
return cfe({ type="list", value=listed_files, label="Postgresql File List" })
end
function getfiledetails(filename)
return modelfunctions.getfiledetails(filename, filelist)
end
function updatefiledetails(filedetails)
return modelfunctions.setfiledetails(filedetails, filelist)
end
|