Skip to content
Nick Horvath edited this page May 25, 2022 · 2 revisions

Log Files

Debug log files are stored at /var/log/sprinklers_pi. To view the log file just type cat /var/log/sprinklers_pi from the shell prompt.

Settings

Settings are stored in the file /usr/local/etc/sprinklers_pi/settings. This is a binary file that's essentially a mirror of the EEPROM if this system was compiled to run on the Arduino platform. It's not (easily) edited. You can delete this file to return the system to factory defaults.

Running Zone Database

Every time a zone is turned on or off, an entry is written to a sqlite3 database table along with a number of parameters (e.g. which schedule turned it on, was it a manual action, was it a quickstart, was there a seasonal adjust parameter and what was it, was there a weather underground adjustment, etc.) This file is located at /usr/local/etc/sprinklers_pi/db.sql. You can actually launch a sqlite3 session and query the file via SQL. Just type sudo sqlite3 /usr/local/etc/sprinklers_pi/db.sql from a shell prompt.

Clearing zone log

From time to time, you may want to clear your zone log database, you can do so with the following procedure:

  1. Stop the sprinklerspi service.
  2. Then you should be able to run sqlite commands on the db (make a backup copy first!). The query is DELETE FROM zonelog; which will truncate the table. So run the command: sudo sqlite3 /usr/local/etc/sprinklers_pi/db.sql "DELETE FROM zonelog;"
  3. Start the service again.

Executable

The sprinklers_pi executable is located at /usr/local/sbin/sprinklers_pi

Clone this wiki locally