Page 2 of 3
Re: Nagios XI to Monitor MS Exchange 2010
Posted: Wed Jan 21, 2015 11:19 am
by JohnFLi
Outstanding!!! it's looking all green now. thank you.
As for the 4 commands you posted.... WHere do I type that in?
Re: Nagios XI to Monitor MS Exchange 2010
Posted: Wed Jan 21, 2015 5:08 pm
by Box293
Excellent.
Establish an SSH session to the Nagios XI host to run those commands (copy and paste is recommended).
Re: Nagios XI to Monitor MS Exchange 2010
Posted: Wed Jan 21, 2015 5:22 pm
by slansing
Please let us know how you get along John! Thanks!
Re: Nagios XI to Monitor MS Exchange 2010
Posted: Wed Jan 21, 2015 5:31 pm
by 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
Re: Nagios XI to Monitor MS Exchange 2010
Posted: Wed Jan 21, 2015 5:32 pm
by 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.
Re: Nagios XI to Monitor MS Exchange 2010
Posted: Wed Jan 21, 2015 5:49 pm
by JohnFLi
Ok, I ran the scrips
I didn't see any error messages..... just returned ->
Re: Nagios XI to Monitor MS Exchange 2010
Posted: Wed Jan 21, 2015 5:54 pm
by 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
->
Re: Nagios XI to Monitor MS Exchange 2010
Posted: Wed Jan 21, 2015 6:18 pm
by Box293
Have you changed the password for mysql?
This command uses the default password nagiosxi
(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;
Re: Nagios XI to Monitor MS Exchange 2010
Posted: Wed Jan 21, 2015 6:45 pm
by 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
Re: Nagios XI to Monitor MS Exchange 2010
Posted: Wed Jan 21, 2015 6:58 pm
by Box293
Awesome, it's great to get to the end of a problem with everything fixed and all questions answered
