Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Nagios and mysql
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Unsupported Software
View previous topic :: View next topic  
Author Message
babbles
n00b
n00b


Joined: 06 Apr 2008
Posts: 5

PostPosted: Sun Apr 06, 2008 7:06 am    Post subject: Nagios and mysql Reply with quote

hi guys. i have a problem about nagios and mysql. i already installed the plugins form mysql but still there was an error saying :

configure: error: You need the official plugins to compile this one
:)

hope you guys can help me out.
Back to top
View user's profile Send private message
bunder
Bodhisattva
Bodhisattva


Joined: 10 Apr 2004
Posts: 5834

PostPosted: Sun Apr 06, 2008 12:29 pm    Post subject: Reply with quote

turns out nagios dropped mysql support in nagios v2...

edit: i found this, but one thing to think about, is if your remote mysql server goes down, nagios can't log its up/down statuses. https://forums.gentoo.org/viewtopic-t-477730-highlight-nagios+mysql.html
_________________
overlay | patches
Neddyseagoon wrote:
The problem with leaving is that you can only do it once and it reduces your influence.
Back to top
View user's profile Send private message
babbles
n00b
n00b


Joined: 06 Apr 2008
Posts: 5

PostPosted: Sun Apr 06, 2008 3:02 pm    Post subject: Reply with quote

bunder wrote:
turns out nagios dropped mysql support in nagios v2...

edit: i found this, but one thing to think about, is if your remote mysql server goes down, nagios can't log its up/down statuses. https://forums.gentoo.org/viewtopic-t-477730-highlight-nagios+mysql.html


you mean the new version of nagios is not compatible with mysql.?i'm using nagios v 3.0.1..

how do i configure the mysql command in localhost?

define service{
use local-service
host_name localhost
service_description mysql
check_command check_mysql_perf
notifications_enabled 0}

there was an error saying that

One or more problems was encountered while running the pre-flight check...

Check your configuration file(s) to ensure that they contain valid
directives and data defintions. If you are upgrading from a previous
version of Nagios, you should be aware that some variables/definitions
may have been removed or modified in this version. Make sure to read
the HTML documentation regarding the config files, as well as the
'Whats New' section to find out what has changed.
Back to top
View user's profile Send private message
bunder
Bodhisattva
Bodhisattva


Joined: 10 Apr 2004
Posts: 5834

PostPosted: Sun Apr 06, 2008 7:38 pm    Post subject: Reply with quote

Moved from Networking & Security to Unsupported Software.

oh, you're trying to use nagios to monitor mysql... gotcha.

if you were using a stable nagios, i'd say compile nagios-plugins with USE=mysql, but since you're not, you'll have to make sure mysql support gets built when you compile it. ( ./configure --enable-mysql or something)

cheers
_________________
overlay | patches
Neddyseagoon wrote:
The problem with leaving is that you can only do it once and it reduces your influence.
Back to top
View user's profile Send private message
gimpel
Advocate
Advocate


Joined: 15 Oct 2004
Posts: 2720
Location: Munich, Bavaria

PostPosted: Sun Apr 06, 2008 10:08 pm    Post subject: Reply with quote

AFAIK check_mysql_perf is not included in nagios-plugins (there is check_mysql and check_mysql_query IIRC)

check_mysql_perf is an extra plugin:
http://www.consol.com/opensource/nagios/check-mysql-perf

And to compile it, you need to have the nagios-plugins package installed it seems.

Check
Code:
layman -a dertobi123

to ease things up with nagios-3.x (and help bringing it into portage)

To monitor mysql availability I use check_proc and check_mysql with a SELECT-only user. mysql performance is not really interesting, as we use Oracle where performance matters (and at home I use postgresql)

And you will most likely have to define a command in your (misc)commands.cfg that calls check_mysql_perf prior to defining a service that uses it. Services call defined commands, and not plugins directly.
_________________
http://proaudio.tuxfamily.org/wiki - pro-audio software overlay
Back to top
View user's profile Send private message
bunder
Bodhisattva
Bodhisattva


Joined: 10 Apr 2004
Posts: 5834

PostPosted: Mon Apr 07, 2008 12:01 am    Post subject: Reply with quote

check_mysql returns this for me:

Code:
Uptime: 1274080 Threads: 14 Questions: 20424016 Slow queries: 31 Opens: 4993 Flush tables: 1 Open tables: 64 Queries per second avg: 16.030


not sure what kind of data check_mysql_perf is supposed to return, but this is good enough for me. if i need more i can always check with phpmyadmin. :wink:
_________________
overlay | patches
Neddyseagoon wrote:
The problem with leaving is that you can only do it once and it reduces your influence.
Back to top
View user's profile Send private message
babbles
n00b
n00b


Joined: 06 Apr 2008
Posts: 5

PostPosted: Mon Apr 07, 2008 10:56 am    Post subject: Reply with quote

To monitor mysql availability I use check_proc and check_mysql with a SELECT-only user. mysql performance is not really interesting, as we use Oracle where performance matters (and at home I use postgresql)

how can i use check_proc and check_mysql?
Back to top
View user's profile Send private message
babbles
n00b
n00b


Joined: 06 Apr 2008
Posts: 5

PostPosted: Mon Apr 07, 2008 10:58 am    Post subject: Reply with quote

bunder wrote:
check_mysql returns this for me:

Code:
Uptime: 1274080 Threads: 14 Questions: 20424016 Slow queries: 31 Opens: 4993 Flush tables: 1 Open tables: 64 Queries per second avg: 16.030


not sure what kind of data check_mysql_perf is supposed to return, but this is good enough for me. if i need more i can always check with phpmyadmin. :wink:


if i use check_mysql do i need to install some plugins?or it is already configure?

how will i use check_mysql?
Back to top
View user's profile Send private message
gimpel
Advocate
Advocate


Joined: 15 Oct 2004
Posts: 2720
Location: Munich, Bavaria

PostPosted: Mon Apr 07, 2008 5:07 pm    Post subject: Reply with quote

babbles wrote:
bunder wrote:
check_mysql returns this for me:

Code:
Uptime: 1274080 Threads: 14 Questions: 20424016 Slow queries: 31 Opens: 4993 Flush tables: 1 Open tables: 64 Queries per second avg: 16.030


not sure what kind of data check_mysql_perf is supposed to return, but this is good enough for me. if i need more i can always check with phpmyadmin. :wink:


if i use check_mysql do i need to install some plugins?or it is already configure?

how will i use check_mysql?

Just emerge nagios-plugins with USE="mysql" enabled, or enable it on ./configure if you compile manually.
Then define a check_mysql command, and use it in some service. See nagios docs for help on how to do that.
_________________
http://proaudio.tuxfamily.org/wiki - pro-audio software overlay
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Unsupported Software All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum