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 the hosts table and creates checks in the check 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 the name 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: the id of the host in the hosts 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 in checks keys in the config file eg diskspace, mysql, …
  • enabled: if this contains 0 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.