Manually modifying hosts and checks
All configured checks are stored in the checks
table in the database. Every check is related to one host from the hosts
table. The various server-monitor
commands manipulate the data these two tables:
-
server-monitor:add-host
adds a host in thehosts
table and creates checks in thecheck
table related to that host. -
server-monitor:delete-host
deletes a host and all related checks -
server-monitor:list-hosts
lists all hosts -
server-monitor:list-checks
lists detailed information about all checks
You can also manually manipulate the rows of both tables. These fields can be manipulated in the hosts
table:
-
name
: the name of the host that will be checked. -
ssh_user
: the name of the ssh user the package should use when connecting to the remote server. -
port
: the port that should be used when connecting to the server. If this is empty port 22 will be used. -
ip
: if this field contains an ip-address we'll use that instead of thename
when connecting to a server -
custom_properties
: see the section on using custom properties
These are the fields you can manipulate in the checks
table:
-
host_id
: theid
of the host in thehosts
table on which this check will be performed. -
type
: this value determines which check should be performed. The value should correspond to one of the keys inchecks
keys in the config file egdiskspace
,mysql
, ... -
enabled
: if this contains0
the check won't be executed. -
custom_properties
: see the section on using custom properties
All other fields in the checks
and hosts
tables are managed by the package and should not be manually modified.