Mysql monitoring

[Mike]

Hi,

I am trying to monitor mysql server
i am getting below error on the status information :

SQL Server message 18456, severity 14, state 1, line 1:

while monitoring mysql do we need to install any plugin or agent in the nagios server to monitor mysql like oracle monitroing?

i have installed nsclient++ in windows mysql server is there anything i ahve to install in nagios server or windows server



thanks,

[slansing]

Have you tried using the Mysql monitoring wizard?

i am getting below error on the status information :

SQL Server message 18456, severity 14, state 1, line 1:

Is this for a specific service added by the wizard...or..?

[Mike]

hi,


yes i tried a monitoring wizard of mysql and i am getting for evry parameters from that wizard


thanks

[sreinhardt]

Are you sure this is mysql and not mssql? This particular error is for a mssql server saying the authentication failed.

[Mike]

Hello,


YES,

its mssql server ,
and i am trying to monitoring through mssql wizard


.

[sreinhardt]

Are you using domain authentication? The mssql wizard will only work with sql users. Anything with a domain\user will not work.

[Mike]

Yes Srein, they were using domain/user , i have informed them on this and they gonna come back with the mssql enginer to send the details of sql user details list.

Is there any more details we should be aware of ?

Thanks,

[abrist]

Not really, just remember that this is an mssql server, not a mysql server and that the credentials for the check must match an actual database user's credentials.

[Mike]

Hello,

Thanks ,

We are able to monitor now,
we were providing domain/user as username that's why it was showing error.

[slansing]

Thank you for getting back to us, closing thread.