-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I'd meant there "head -1" by itself, which means "show the first
line." BTW, if you wanted to show just the last line, that would be
"tail -1".
On 10/05/2012 09:46 AM, Don Kuhlman wrote:
Thanks Cynthia, Larry, and Ryan!
I modified the client-local.cfg file as below: [MYSQLSERVER01]
file:`find /Volumes/MySQL_Backups/ -name "*.sql" -mtime 0
2>/dev/null | sort -r |head -1 --lines=1`
The webpage shows the file is present -
Fri Oct 5 08:35:16 CDT 2012 - Files ok
green /Volumes/MySQL_Backups/mysql_backup_20121005.sql
<http://srmxymon.ambrosi.com/xymon-cgi/svcstatus.sh?CLIENT=MYSQLSERVER01&;
SECTION=file:/Volumes/MySQL_Backups/mysql_backup_20121005.sql>
If I click the link on the webpage it gives this:
[file:/Volumes/MySQL_Backups/mysql_backup_20121005.sql]
type:100000 (file) mode:644 (-rw-r--r--) linkcount:1 owner:0
(root) group:0 (root) size:501060 clock:1349444303
(2012/10/05-08:38:23) atime:1349425844 (2012/10/05-03:30:44)
ctime:1349413801 (2012/10/05-00:10:01) mtime:1349413801
(2012/10/05-00:10:01)
Next I changed the directory so no file matches the find command
and then the files icon goes white and gives me the "No files
checked" message.
Fri Oct 5 08:45:23 CDT 2012 - Files ok
No files checked
Can anyone advise how I translate that into an email to our DBA to
indicate the file doesn't exist ?
Thanks
Don K
From: "Novosielski, Ryan" <user-ae4522577e16@xymon.invalid
<mailto:user-ae4522577e16@xymon.invalid>> Date: Fri, 5 Oct 2012 01:33:14 -0400
To: "'user-6ef9c2864140@xymon.invalid <mailto:'user-6ef9c2864140@xymon.invalid>'"
<user-6ef9c2864140@xymon.invalid <mailto:user-6ef9c2864140@xymon.invalid>>, Don Kuhlman
<user-5eb2bfadc6c6@xymon.invalid <mailto:user-5eb2bfadc6c6@xymon.invalid>> Cc:
"'xymon at xymon.com <mailto:'xymon at xymon.com>'" <xymon at xymon.com
<mailto:xymon at xymon.com>> Subject: Re: [Xymon] File monitor not
working in Xymon - using file list generated by wildcard
head -1 is probably a lot more standard (I've been encountering a
lot of GNU scripts lately that have made me crazy).
*From*: Larry Barber [mailto:user-6ef9c2864140@xymon.invalid] *Sent*: Thursday,
October 04, 2012 05:39 PM *To*: Don Kuhlman <user-5eb2bfadc6c6@xymon.invalid
<mailto:user-5eb2bfadc6c6@xymon.invalid>> *Cc*: Xymon Email List
<xymon at xymon.com <mailto:xymon at xymon.com>> *Subject*: Re: [Xymon]
File monitor not working in Xymon - using file list generated by
wildcard
Perhaps if you set up your client-local.cfg entry like:
file:`find /Volumes/MySQL_Backups/ -name '*.sql' -mtime 0
2>/dev/null | sort -r | head --lines=1`
so that only the most recent file (by name) will be returned.
Thanks, Larry Barber
On Thu, Oct 4, 2012 at 4:11 PM, Don Kuhlman
<user-5eb2bfadc6c6@xymon.invalid <mailto:user-5eb2bfadc6c6@xymon.invalid>> wrote:
Hi folks. I've been trying to figure this out for a while and
would appreciate any help.
I'm trying to monitor for a sql backup by watching for a set of
files that are created every morning at 00:05 AM by a cron job on
a server. There are several files created each night the sql dump
runs. It creates them as filename_backup__yyyymmdd.sql So each day
there are new file names created (never the same name) I want to
alert if the file doesn't get created each day with the new name.
I have configured the client-local.cfg file as follows:
[MYSQLSERVER01] # dir:`find /Volumes/MySQL_Backups/ -name '*.sql'
-mtime 0 2>/dev/null` #
file:/Volumes/MySQL_Backups/mysql_backup_20121004.sql file:`find
/Volumes/MySQL_Backups/ -name '*.sql' -mtime 0 2>/dev/null`
Analysis.cfg is as follows: HOST=MYSQLSERVER01 FILE %^.sql
COLOR=red mtime<600 # FILE
/Volumes/MySQL_Backups/mysql_backup_20121004.sql red mtime<600 #
FILE /Volumes/MySQL_Backups/mysql_backup_20121004.sql COLOR=red
mtime<600 # FILE /Volumes/MySQL_Backups/mysql_backup_20121004.sql
red mtime>86400 # FILE
/Volumes/MySQL_Backups/mysql_backup_20121004.sql red mtime<86400 #
FILE /Volumes/MySQL_Backups/mysql_backup_20121004.sql red
mtime>600 # FILE /Volumes/MySQL_Backups/mysql_backup_20121004.sql
mtime>86400 noexist
Xymon generates this msg when I use the full filename eg
mysqlbackup20121004.sql in analysis.cfg It doesn't work when I try
to use a wildcard name (which I need because the filename will
change each day) - eg FILE %^.sql
Example alert is below using full real filename:
Thu Oct 4 16:02:11 CDT 2012 - Files NOT ok
red /Volumes/MySQL_Backups/mysql_backup_20121004.sql
<http://srmxymon.ambrosi.com/xymon-cgi/svcstatus.sh?CLIENT=MYSQLSERVER01&;
SECTION=file:/Volumes/MySQL_Backups/mysql_backup_20121004.sql>
File was modified 57134 seconds ago - should be <600
green /Volumes/MySQL_Backups/herbalife_backup_20121004.sql
<http://srmxymon.ambrosi.com/xymon-cgi/svcstatus.sh?CLIENT=MYSQLSERVER01&;
SECTION=file:/Volumes/MySQL_Backups/herbalife_backup_20121004.sql>
Example below using %^.sql:
Thu Oct 4 16:10:15 CDT 2012 - Files ok
green /Volumes/MySQL_Backups/mysql_backup_20121004.sql
<http://srmxymon.ambrosi.com/xymon-cgi/svcstatus.sh?CLIENT=MYSQLSERVER01&;
SECTION=file:/Volumes/MySQL_Backups/mysql_backup_20121004.sql>green
/Volumes/MySQL_Backups/herbalife_backup_20121004.sql
<http://srmxymon.ambrosi.com/xymon-cgi/svcstatus.sh?CLIENT=MYSQLSERVER01&;
SECTION=file:/Volumes/MySQL_Backups/herbalife_backup_20121004.sql>
Thanks
Don K
- -- - ---- _ _ _ _ ___ _ _ _
|Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Sr. Systems Programmer
|$&| |__| | | |__/ | \| _| |user-ae4522577e16@xymon.invalid - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.|IST/EI-Academic Svcs. - ADMC 450, Newark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/
iEYEARECAAYFAlBu6cYACgkQmb+gadEcsb4+nwCgmDPWgoqU3CArx2qcUMklTceW
ky8An1+npPWhxkVCANKk+DUu8sXkrIXO
=7gwh
-----END PGP SIGNATURE-----