Page 2 of 3
Re: VMWare setup
Posted: Mon Mar 03, 2014 12:31 pm
by Sbergonzi
I seem to have spoken to soon. I can access the IP though when trying http://<IP>/nagiosxi/ all I see is a blank screen. Tried in IE11, Chrome, Firefox and checked to confirm all services are running.
Log file shows:
Warning: mysql_pconnect(): Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (111) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
File does not exist: /var/www/html/favicon.ico
Re: VMWare setup
Posted: Mon Mar 03, 2014 12:37 pm
by tmcdonald
I'm guessing by "reboot" you mean a VM-level restart, not a "shutdown -h now" from the command line? If so that's your problem. Doing a VM-level restart is like pulling the plug on a running server: bad news. You will need to run the following:
Code: Select all
service mysqld stop
/usr/local/nagiosxi/scripts/repairmysql.sh nagios
service mysqld start
See the following for more detail:
http://assets.nagios.com/downloads/nagi ... tabase.pdf
Re: VMWare setup
Posted: Mon Mar 03, 2014 12:44 pm
by Sbergonzi
Looks like that worked though an error on the start:
Another MySQL daemon already running with the same unix socket.
Starting mysqld: FAILED
Re: VMWare setup
Posted: Mon Mar 03, 2014 12:49 pm
by slansing
Do the following to resolve that issue:
Code: Select all
service mysqld stop
rm -rf /var/lib/mysql/mysql.sock
service mysqld start
Re: VMWare setup
Posted: Mon Mar 03, 2014 12:53 pm
by Sbergonzi
bingo!! mysqld is now started.
thank you!!
Re: VMWare setup
Posted: Mon Mar 03, 2014 12:57 pm
by slansing
Excellent, how's everything working out?
Re: VMWare setup
Posted: Mon Mar 03, 2014 1:02 pm
by Sbergonzi
Too soon to tell...I'm just in.
Re: VMWare setup
Posted: Mon Mar 03, 2014 1:41 pm
by slansing
Alrighty! Well keep us apprised
.
Re: VMWare setup
Posted: Mon Mar 03, 2014 6:22 pm
by Sbergonzi
how do I close down gracefully the VMWare Player session? I tried the Power Off and that did not allow mysql to start again. I had to run those cleanup commands again.
Re: VMWare setup
Posted: Tue Mar 04, 2014 10:49 am
by slansing
Mentioned previously by Tmcdonald about 5 posts up, you need to use: