Nagios XI to Monitor MS Exchange 2010

[JohnFLi]

Outstanding!!! it's looking all green now. thank you.

As for the 4 commands you posted.... WHere do I type that in?

[Box293]

Excellent.

Establish an SSH session to the Nagios XI host to run those commands (copy and paste is recommended).

[slansing]

Please let us know how you get along John! Thanks!

[JohnFLi]

I need to figure how to log into mysql.
I know the password, I just cant figure the syntax for loging into it.

WHen I copy and paste the command, it tells me access denied

[slansing]

Since those are echo statements, they can be ran from the shell directly, as long as you have not changed the database users, you should be able to paste them right into putty and pass them through.

[JohnFLi]

Ok, I ran the scrips

I didn't see any error messages..... just returned ->

[JohnFLi]

without logging into mysql and try, I get this

Code: Select all

[root@localhost ~]# echo "use nagios;alter table nagios_servicestatus modify output varchar(65535) not null;alter table nagios_servicestatus modify long_output varchar(65535) not null;alter table nagios_servicestatus modify perfdata varchar(65535) not null;" | mysql -pnagiosxi
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

when logged in, I get this:

Code: Select all

mysql> echo "use nagios;alter table nagios_servicestatus modify output varchar(65535) not null;alter table nagios_servicestatus modify long_output varchar(65535) not null;alter table nagios_servicestatus modify perfdata varchar(65535) not null;" | mysql -pnagiosxi
    ->    

[Box293]

Have you changed the password for mysql?

This command uses the default password nagiosxi

Code: Select all

-pnagiosxi

(this is the last part of each command)

Alternatively, if you are logged into mysql, execute the commands like so:

Code: Select all

use nagios;alter table nagios_servicestatus modify output varchar(65535) not null;alter table nagios_servicestatus modify long_output varchar(65535) not null;alter table nagios_servicestatus modify perfdata varchar(65535) not null;

use nagios;alter table nagios_hoststatus modify output varchar(65535) not null;alter table nagios_hoststatus modify long_output varchar(65535) not null;alter table nagios_hoststatus modify perfdata varchar(65535) not null;

use nagios;alter table nagios_servicechecks modify output varchar(65535) not null;alter table nagios_servicechecks modify long_output varchar(65535) not null;alter table nagios_servicechecks modify perfdata varchar(65535) not null;

use nagios;alter table nagios_hostchecks modify output varchar(65535) not null;alter table nagios_hostchecks modify long_output varchar(65535) not null;alter table nagios_hostchecks modify perfdata varchar(65535) not null;

[JohnFLi]

ah..... I didn't know the last item was a password.

I changed it to the current password and all 4 appears to have entered fine.
ANd I can see that on the services page, it is displaying more stuff.


Thank you

[Box293]

Awesome, it's great to get to the end of a problem with everything fixed and all questions answered