Nagios Virtual Machine

[yctsai1]

Just downloaded the VM and created a Hyper-V VM.

Following the Nagio's installation procedure, I've logged in, changed root password but when I try to change the mysqladmin password, I get an error, Access Denied. I've used the command as described,

mysqladmin -u root -p'nagiosxi' password mypass1

[nscott]

Can you access the nagiosxi database with nagiosxi?

mysql -u root -pnagiosxi nagios

Does that return ok?

[yctsai1]

> my sql -u root -pnagiosxi nagios

Error 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[yctsai1]

Access Denied

[nscott]

yctsai1,

Would you mind posting a screenshot of what you see when you attempt to login? I'm a bit confused about which error you're getting and it would be quickest to rectify it if you just posted a screenshot.

[yctsai1]

Looks like it must have something to do with MySQL not running.

Now after creating a Web check and a ping check for google.com, Service Status gives the same errors on both checks...

SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_programstatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_programstatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_programstatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_programstatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_programstatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_programstatus'

[lmiltchev]

If you need to setup your mysql password or you lost it and need to recover it, you may try using the following two links (at your own risk!):

http://www.cyberciti.biz/faq/mysql-chan ... -password/

http://www.cyberciti.biz/tips/recover-m ... sword.html