VMWare setup

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Sbergonzi
Posts: 127
Joined: Wed Feb 19, 2014 4:21 pm

Re: VMWare setup

Post 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
Last edited by Sbergonzi on Mon Mar 03, 2014 12:37 pm, edited 1 time in total.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: VMWare setup

Post 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
Former Nagios employee
Sbergonzi
Posts: 127
Joined: Wed Feb 19, 2014 4:21 pm

Re: VMWare setup

Post 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
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: VMWare setup

Post 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
Sbergonzi
Posts: 127
Joined: Wed Feb 19, 2014 4:21 pm

Re: VMWare setup

Post by Sbergonzi »

bingo!! mysqld is now started.

thank you!!
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: VMWare setup

Post by slansing »

Excellent, how's everything working out?
Sbergonzi
Posts: 127
Joined: Wed Feb 19, 2014 4:21 pm

Re: VMWare setup

Post by Sbergonzi »

Too soon to tell...I'm just in. :)
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: VMWare setup

Post by slansing »

Alrighty! Well keep us apprised :).
Sbergonzi
Posts: 127
Joined: Wed Feb 19, 2014 4:21 pm

Re: VMWare setup

Post 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.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: VMWare setup

Post by slansing »

Mentioned previously by Tmcdonald about 5 posts up, you need to use:

Code: Select all

shutdown -h now
Locked