failure to login after run upgrade to latest version

[KPham]

hello Tech support,
i am not able to login after ran upgrade to the latest version (5.2.6 to 5.2.7)
please i really need someone to help me take a look at this issue
i following the instruction to run the command cli to repair the database mysql and it showing error

[bheden]

What operating system are you on?

I'm going to assume you're on CentOS, but if you aren't, please adjust the following lines to fit your operating system..

Can we see the output of:

Code: Select all

cat /var/log/mysqld.log

Code: Select all

service mysqld restart

Code: Select all

cat /etc/my.cnf

Thanks.

[KPham]

the Nagiosxi currently running on VMWare esxi 5.5

[rkennedy]

What OS is the virtual machine running on? Can you please show us the output of the 3 commands mentioned above?

[KPham]

i am using Nagiosxi template image (CentOS)
after run the command showing run out of space
i am not sure the logs was increased causing running out of space?
i already increased double space from 200GB to 500GB

[rkennedy]

Looks like your out of space. There was an issue with a debug file filling up in 5.2.6. Please run rm /tmp/xisupport.debug.log and attempt to start SQL. It should now work.

If not, please post the output of df -H

[KPham]

i can restart mysqld service without error
but i am still unable to login

i run this command without error /usr/local/nagiosxi/scripts/repair_databases.sh
but still unable to login

[rkennedy]

Did you run the commands I mentioned above? We'll need the output of df -H and ls -l /tmp/.

[KPham]

the issue is fixed now after i rebooted the server

thank you so much for your help and supporting


Kevin

[rkennedy]

No problem, it took seeing the output to see what was going on.

Closing this one out, but feel free to make a new thread if you have any questions in the future.