apricoti

NagiosCheckMysqlSlave

email.hidden@example.com (Jonathan Buhacoff) — Wed, 20 Aug 2008 07:35:12 +0000

Jonathan Buhacoff edited NagiosCheckMysqlSlave

Current version is 0.1, posted on 19 August 2008.
Tar/Gzip
http://www.openparty.net/2008/software/NagiosCheckMysqlSlave/archive/check_mysql_slave-0.1.tar.gzhttp://www.openparty.net/2008/software/NagiosCheckMysqlSlave/archive/check_mysql_slave-0.1.1.tar.gz
Zip
http://www.openparty.net/2008/software/NagiosCheckMysqlSlave/archive/check_mysql_slave-0.1.ziphttp://www.openparty.net/2008/software/NagiosCheckMysqlSlave/archive/check_mysql_slave-0.1.1.zip
Compatibility
This plugin has been tested with MySQL versions 3.23, 4.1, and 5.0.

NagiosCheckMysqlSlave

email.hidden@example.com (Jonathan Buhacoff) — Wed, 20 Aug 2008 07:31:48 +0000

Jonathan Buhacoff edited NagiosCheckMysqlSlave

Here is a table of minimum versions known to work together (if you know of
lower version number combinations that work, please let me know):
Server Client Perl | Perl
Client
Perl
Perl Modules
mysql-3.23 mysql-3.23 5.8.0 | DBI-1.21,
mysql-3.23
5.8.0
DBI-1.21, DBD-mysql-2.11
mysql-4.1 mysql-4.1 5.8.1 | DBI-1.67,
mysql-4.1
5.8.1
DBI-1.67, DBD-mysql-4.008
mysql-5.0 mysql-5.0 5.8.1 | DBI-1.67,
mysql-5.0
5.8.1
DBI-1.67, DBD-mysql-4.008
Usage Notes
None right now.

NagiosCheckMysqlSlave

email.hidden@example.com (Jonathan Buhacoff) — Wed, 20 Aug 2008 07:31:10 +0000

Jonathan Buhacoff edited NagiosCheckMysqlSlave

Here is a table of minimum versions known to work together (if you know of
lower version number combinations that work, please let me know):
Perl Perl Modulesmysql-3.23 | Perl Modules
mysql-3.23 mysql-3.23 5.8.0 DBI-1.21, DBD-mysql-2.11mysql-4.1 | DBI-1.21, DBD-mysql-2.11
mysql-4.1 mysql-4.1 5.8.1 DBI-1.67, DBD-mysql-4.008mysql-5.0 | DBI-1.67, DBD-mysql-4.008
mysql-5.0 mysql-5.0 5.8.1 DBI-1.67, | DBI-1.67, DBD-mysql-4.008
Usage Notes
None right now.

NagiosCheckMysqlSlave

email.hidden@example.com (Jonathan Buhacoff) — Wed, 20 Aug 2008 07:30:55 +0000

Jonathan Buhacoff edited NagiosCheckMysqlSlave

However, newer versions of MySQL server are not always compatible
with old MySQL clients and perl modules. If the plugin fails with
about upgrading, upgrading, take the advice.
Here is a table of minimum versions known to work together (if you know of
lower version number combinations that work, please let me know):
Server Client Perl Perl Modulesmysql-3.23 mysql-3.23 5.8.0 DBI-1.21, DBD-mysql-2.11mysql-4.1 mysql-4.1 5.8.1 DBI-1.67, DBD-mysql-4.008mysql-5.0 mysql-5.0 5.8.1 DBI-1.67, Client Perl Perl Modulesmysql-3.23 mysql-3.23 5.8.0 DBI-1.21, DBD-mysql-2.11mysql-4.1 mysql-4.1 5.8.1 DBI-1.67, DBD-mysql-4.008mysql-5.0 mysql-5.0 5.8.1 DBI-1.67, DBD-mysql-4.008
Usage Notes
None right now.

NagiosCheckMysqlSlave

email.hidden@example.com (Jonathan Buhacoff) — Wed, 20 Aug 2008 07:28:33 +0000

Jonathan Buhacoff edited NagiosCheckMysqlSlave

NagiosCheckMysqlSlave

email.hidden@example.com (Jonathan Buhacoff) — Wed, 20 Aug 2008 07:28:07 +0000

Jonathan Buhacoff edited NagiosCheckMysqlSlave

check_mysql_slave_epn - same script but modified to work with Nagios EPN
Documentation:
I use these plugins on my networks so I'm open to suggestions for improvements and to assist you with some difficulties if you use these plugins.
The plugin is documented with perl POD. Use the --help option to view it or see the manual, or read the HTML version at this URL:
http://www.openparty.net/2008/software/NagiosCheckMysqlSlave/check_mysql_slave.html
Features of check_smtp_send:Features
works with MySQL versions 3.23, 4.1, and 5.0
I use these plugins on my networks so I'm openhelpful error messages are printed next to suggestions for improvements and to assist you with some difficulties if you use these plugins.
The plugin is documented CRITICAL status like access denied, mysql client version incompatible with perl POD. Use the --help option to view it or see the manual.
Download server, etc.

NagiosCheckMysqlSlave

email.hidden@example.com (Jonathan Buhacoff) — Wed, 20 Aug 2008 07:22:02 +0000

Jonathan Buhacoff edited NagiosCheckMysqlSlave

None right now.
Troubleshooting
No tips yet. Waiting for feedback from you!I see "UNKNOWN" and "no output!" in the Nagios web interface
The plugin fails with UNKNOWN status code when required
perl modules are missing, and it prints a list of missing
modules, but when I view this on my nagios website it says
"no output!". Try prepending /usr/bin/perl to the command_line
to make sure it does not run in Nagios embedded perl.
Future Improvements
Open to suggestions... please email me at jonathan@buhacoff.net

NagiosCheckMysqlSlave

email.hidden@example.com (Jonathan Buhacoff) — Tue, 19 Aug 2008 19:28:04 +0000

Jonathan Buhacoff edited NagiosCheckMysqlSlave

http://www.openparty.net/2008/software/NagiosCheckMysqlSlave/archive/check_mysql_slave-0.1.tar.gz
Zip
http://www. openparty.net/2008/software/NagiosCheckMysqlSlave/archive/check_mysql_slave-0.1.ziphttp://www.openparty.net/2008/software/NagiosCheckMysqlSlave/archive/check_mysql_slave-0.1.zip
How to Install
Copy the included scripts to your nagios plugin folder.

NagiosCheckMysqlSlave

email.hidden@example.com (Jonathan Buhacoff) — Tue, 19 Aug 2008 19:27:44 +0000

Jonathan Buhacoff edited NagiosCheckMysqlSlave

Current version is 0.1, posted on 19 August 2008.
Tar/Gzip
http://www.buhacoff.net/2008/projects/nagios/check_mysql_slave-0.1.tar.gzhttp://www.openparty.net/2008/software/NagiosCheckMysqlSlave/archive/check_mysql_slave-0.1.tar.gz
Zip
http://www.buhacoff.net/2008/projects/nagios/check_mysql_slave-0.1.ziphttp://www. openparty.net/2008/software/NagiosCheckMysqlSlave/archive/check_mysql_slave-0.1.zip
How to Install
Copy the included scripts to your nagios plugin folder.

NagiosCheckMysqlSlave

email.hidden@example.com (Jonathan Buhacoff) — Tue, 19 Aug 2008 19:03:41 +0000

Jonathan Buhacoff added NagiosCheckMysqlSlave

! Intro/Background

The check_mysql_slave plugin allows you to check that a particular MySQL replication slave is running and (coming soon) is within a threshold bytes or seconds behind its master.

This project includes:

check_mysql_slave - connects to a MySQL replication slave and checks its status
check_mysql_slave_epn - same script but modified to work with Nagios EPN

Documentation:

http://www.openparty.net/2008/software/NagiosCheckMysqlSlave/check_mysql_slave.html

Features of check_smtp_send:
* works with MySQL versions 3.23, 4.1, and 5.0

I use these plugins on my networks so I\'m open to suggestions for improvements and to assist you with some difficulties if you use these plugins.

The plugin is documented with perl POD. Use the --help option to view it or see the manual.

! Download

Current version is 0.1, posted on 19 August 2008.

!! Tar/Gzip

http://www.buhacoff.net/2008/projects/nagios/check_mysql_slave-0.1.tar.gz

!! Zip

http://www.buhacoff.net/2008

FrontPage

email.hidden@example.com (Jonathan Buhacoff) — Tue, 19 Aug 2008 18:54:02 +0000

Jonathan Buhacoff edited FrontPage

SpamAssassinImapClient
NagiosCheckEmailDelivery
NagiosCheckMysqlSlave
TomcatStartup
SpamAssassinManual

MysqlRecipeBook

email.hidden@example.com (jonathan) — Mon, 11 Aug 2008 16:09:42 +0000

jonathan added MysqlRecipeBook

! MySQL

!! Generate SQL statements to create a copy of a specific database (for making a sample etc)

mysqldump $dbname > $dbname.sql

!! Create the new database using above SQL statements

mysql -e \"create database $dbname\"
mysql $dbname < $dbname.sql

!! Add another database user to mysql permission tables

mysql mysql -e \"INSERT INTO user SET Host=\'localhost\',User=\'$dbuser\',Password=password(\'$dbpasswd\');\"
mysql mysql -e \"INSERT INTO db SET Host=\'localhost\',Db=\'$dbname\',User=\'$dbuser\',Select_priv=\'Y\',Insert_priv=\'Y\',Update_priv=\'Y\',Delete_priv=\'Y\';\"
mysqladmin reload

Another way to do this:

mysql -e \"GRANT DELETE,INSERT,SELECT,UPDATE ON $dbname.* TO \'$dbuser\'@\'localhost\' IDENTIFIED BY \'$dbpasswd\';\"

By the way, \"localhost\" in the above statements should match the FIRST entry for 127.0.0.1 in /etc/hosts. So if you have an entry like \"127.0.0.1 localhost.localdomain\" then you should use that instead, or change your hosts file to have \"loca

FrontPage

email.hidden@example.com (jonathan) — Mon, 11 Aug 2008 16:09:33 +0000

jonathan edited FrontPage

PerlShellQuotingModuleShellf
SoftwareRecipeBook
MysqlRecipeBook
MacProblems
WebsiteDesign

SoftwareRecipeBook

email.hidden@example.com (jonathan) — Mon, 11 Aug 2008 16:09:09 +0000

jonathan edited SoftwareRecipeBook

MySQL
Generate SQL statements to create a copy of a specific database (for making a sample etc)
mysqldump $dbname > $dbname.sql
Create the new database using above SQL statements
mysql -e "create database $dbname"mysql $dbname < $dbname.sql
Add another database user to mysql permission tables
mysql mysql -e "INSERT INTO user SET Host='localhost',User='$dbuser',Password=password('$dbpasswd');"mysql mysql -e "INSERT INTO db SET Host='localhost',Db='$dbname',User='$dbuser',Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y';"mysqladmin reload
Another way to do this:
mysql -e "GRANT DELETE,INSERT,SELECT,UPDATE ON $dbname.* TO '$dbuser'@'localhost' IDENTIFIED BY '$dbpasswd';"
By the way, "localhost" in the above statements should match the FIRST entry for 127.0.0.1 in /etc/hosts. So if you have an entry like "127.0.0.1 localhost.localdomain" then you should use that instead, or change your hosts file to ha

InterestingPeople

email.hidden@example.com (jonathan) — Mon, 11 Aug 2008 15:21:03 +0000

jonathan added InterestingPeople

http://www.longnow.org/people/board/

FrontPage

email.hidden@example.com (jonathan) — Mon, 11 Aug 2008 15:20:54 +0000

jonathan edited FrontPage

AutomatorRsync
TinyDns
InterestingPeople

NagiosCheckEmailDelivery

no.email.given@example.com (Anonymous) — Wed, 16 Jul 2008 09:52:10 +0000

Anonymous edited NagiosCheckEmailDelivery

check_imap_receive - connects to and searches an IMAP account for messages
check_email_delivery - sends email and verifies delivery using other plugins
Documentation:
http://www.openparty.net/2008/software/NagiosCheckEmailDelivery/check_smtp_send.html
http://www.openparty.net/2008/software/NagiosCheckEmailDelivery/check_imap_receive.html
http://www.openparty.net/2008/software/NagiosCheckEmailDelivery/check_email_delivery.html
You can use check_smtp_send and check_imap_receive independently, and you can use check_email_delivery to check that an email loop is working.
Features of check_smtp_send:

TinyDns

email.hidden@example.com (Jonathan Buhacoff) — Thu, 03 Jul 2008 23:11:16 +0000

Jonathan Buhacoff edited TinyDns

I really like D.J. Bernstein's TinyDNS server (see http://cr.yp.to/).
as root. You'll want to edit the first root:
edit these two lines to contain your name and the IP address to which TinyDNS should bind to listen for incoming connections:
MYNAME='First Last'
DNSIP='11.22.33.44'
reference: http://cr.yp.to
create /package folder for djb's programs
mkdir -p /package

TinyDns

email.hidden@example.com (Jonathan Buhacoff) — Thu, 03 Jul 2008 23:09:45 +0000

Jonathan Buhacoff added TinyDns

I really like D.J. Bernstein\'s TinyDNS server (see http://cr.yp.to/).

Here is a complete installation script that works on Fedora 9. Execute it as root. You\'ll want to edit the first two lines to contain your name and the IP address to which TinyDNS should bind to listen for connections:



MYNAME=\'First Last\'


DNSIP=\'11.22.33.44\'





# reference: http://cr.yp.to





# create /package folder for djb\'s programs


mkdir -p /package


chmod 1755 /package





# install daemontools


cd /package


wget http://cr.yp.to/daemontools/daemontools-0.76.tar.gz


gunzip -c daemontools-0.76.tar.gz | tar xf -


cd admin/daemontools-0.76


cp src/error.h src/error.h.original


sed -e \"s/extern int errno;/#include /\" src/error.h.original > src/error.h


package/install


mail djb-sysdeps@cr.yp.to < /package/admin/daemontools/compile/sysdeps





# install ucspi-tcp


cd /package


wget http://cr.yp.to/ucspi-tcp/ucspi-tcp-0.88.tar.gz


gunzip -c ucspi-tcp-0.88.tar.gz | tar xf -


cd ucspi-tcp-0.88


cp error.h error.h

FrontPage

email.hidden@example.com (Jonathan Buhacoff) — Thu, 03 Jul 2008 23:05:33 +0000

Jonathan Buhacoff edited FrontPage

SshNotes
AutomatorRsync
TinyDNSTinyDns