Jlderidder: /* Checkscripts */

Jlderidder — Tue, 18 Dec 2012 21:25:35 GMT

Checkscripts

←Older revision		Revision as of 21:25, 18 December 2012
Line 2:		Line 2:


-	The "checkscripts" MySQL database currently resides on the ~~content.lib.ua.edu~~ server.	+	The "checkscripts" MySQL database currently resides on the libcontent server.
	This database is composed (currently) of two tables: "scripts" and "ran".		This database is composed (currently) of two tables: "scripts" and "ran".

Line 25:		Line 25:

	As described in [[Watching_Our_Backs]],		As described in [[Watching_Our_Backs]],
-	Once a week, a script called "checkscripts" ~~on content.lib.ua.edu~~ in /~~home/jlderidder~~/scripts/cya looks through the entries in the checkscripts database for the past week, and compares them with the list of entries of existing cron scripts and when they are due to run. If any scripts did NOT run, which were scheduled, or any of them logged errors, this script sends emails to notify us of problems. Of course, this script also logs in with the checkscripts database to verify that it ran, and when.	+	Once a week, a script called "checkscripts" in /srv/scripts/cya looks through the entries in the checkscripts database for the past week, and compares them with the list of entries of existing cron scripts and when they are due to run. If any scripts did NOT run, which were scheduled, or any of them logged errors, this script sends emails to notify us of problems. Of course, this script also logs in with the checkscripts database to verify that it ran, and when.

-	Then~~, since any server can go down, and multitudes of error possibilities exist~~, a third script ~~on a third server~~ ("checkscriptcheck" in /~~home~~/~~jlderidder~~/cya ~~on libapp.ua-net.ua.edu~~) runs to verify that the checkscripts script ran as it should. Again, this one sends us any errors, and it logs in with the checkscripts database.	+	Then, a third script ("checkscriptcheck" in /srv/scripts/cya) runs to verify that the checkscripts script ran as it should. Again, this one sends us any errors, and it logs in with the checkscripts database.
		+
		+	If there's problems with servers going down frequently, these three scripts can reside on three different servers. This helps track down what has/hasn't been taken care of, as well as notification of servers not functioning correctly.

Jlderidder: New page: == Checkscripts == The "checkscripts" MySQL database currently resides on the content.lib.ua.edu server. This database is composed (currently) of two tables: "scripts" and "ran". The ...

Jlderidder — Thu, 16 Jul 2009 14:03:50 GMT

New page: == Checkscripts == The "checkscripts" MySQL database currently resides on the content.lib.ua.edu server. This database is composed (currently) of two tables: "scripts" and "ran". The ...

New page

== Checkscripts ==

The "checkscripts" MySQL database currently resides on the content.lib.ua.edu server.
This database is composed (currently) of two tables: "scripts" and "ran".

The scripts table contains the following information for each cron script that we depend upon for support of our infrastructure:
# id -- an identifying number, used by each script to log in when it runs
# scriptname (name of the script)
# server on which it resides
# directory in which it exists
# cron -- the crontab specification for when it runs
# runswhen -- a textual explanation of when it runs
# doeswhat -- a textual explanation of what the script does
# succeeds -- the name of scripts which must precede this one for it to do its job properly (dependencies)
# precedes -- the name of scripts which this script must precede in order for them to do their job properly (dependencies)

The "ran" table contains the entries made by each script after it completes its task, and before it exits.
It contains:
# an auto-incrementing number for the database entry
# scriptid, the number of the script, which corresponds to the id number in the scripts table
# datestamp -- added automatically at the time of the entry
# errors -- a textual description of any errors encountered by the script during its run

As described in [[Watching_Our_Backs]],
Once a week, a script called "checkscripts" on content.lib.ua.edu in /home/jlderidder/scripts/cya looks through the entries in the checkscripts database for the past week, and compares them with the list of entries of existing cron scripts and when they are due to run. If any scripts did NOT run, which were scheduled, or any of them logged errors, this script sends emails to notify us of problems. Of course, this script also logs in with the checkscripts database to verify that it ran, and when.

Then, since any server can go down, and multitudes of error possibilities exist, a third script on a third server ("checkscriptcheck" in /home/jlderidder/cya on libapp.ua-net.ua.edu) runs to verify that the checkscripts script ran as it should. Again, this one sends us any errors, and it logs in with the checkscripts database.

Tracking automated scripts - Revision history

Jlderidder: /* Checkscripts */

Jlderidder: New page: == Checkscripts == The "checkscripts" MySQL database currently resides on the content.lib.ua.edu server. This database is composed (currently) of two tables: "scripts" and "ran". The ...