Upgrade Issue through Web Interface

[jdalrymple]

It looks like you've adjusted your nagiosql credentials from the default. Can you verify that they're still working:

Code: Select all

echo "show tables;" | mysql -u nagiosxi -p<yourpassword> nagiosql

[Berto]

Hello,

When I try echo "show tables;" | mysql -u nagiosxi -p <password> nagiosql, I get

bash: !0: event not found

--Berto

[tmcdonald]

Try wrapping your password in quotes:

echo "show tables;" | mysql -u nagiosxi -p'<yourpassword>' nagiosql

It likely has an exclamation point in it that can throw things off.

[Berto]

Hello,

Yea I should have got that, here is the output after escaping the special character:

Enter password:
ERROR 1045 (28000): Access denied for user 'nagiosxi'@'localhost' (using password: YES)


--Berto

[tmcdonald]

• Do you have an offloaded database?
• Have you or anyone else made any security-related changes?
• When you type in <yourpassword> is it the password of the Linux user you are logged in as?

Try the following:

echo "SELECT User FROM mysql.user" | mysql -u root -pnagiosxi

It should provide a list of users. Are "nagiosql" and "ndoutils" present? What about "nagiosxi"?

[Berto]

Hello,

When I run "echo "SELECT User FROM mysql.user" | mysql -u root -pnagiosxi", this is the output;

echo "SELECT User FROM mysql.user" | mysql -u root -pnagiosxi
User
root

root

nagiosql
ndoutils
root

When you say offloaded do you mean a database on a separate server? If that is what you mean, then no it's not offloaded.

No one has made any related security-related issues on the server. I ran into this issue when trying to do an upgrade through the interface but due to our corp proxy had to manually run the script and edit the upgrade script to use the --no-check-certificate for wget. Then ran the upgrade and everything was looking until I got NagioSql login error.

I used the password for current user which would have been root. I have a nagios user in my ldap environment but not a nagiosxi user.

--Berto

[jolson]

Interesting. Please give this a try:

Code: Select all

su nagios
cd /usr/local/nagiosxi/scripts
./reconfigure_nagios.sh &> /tmp/reconfig.txt

Sent us the resulting reconfig.txt file - it performs the same NagiosQL login that the upgrade script fails on. I'm interested if you see the same failure here.

[Berto]

Hello,

I've uploaded the requested file.

--Berto

[ssax]

Go to Admin > System Config > Reset Security Credentials
- Don't change anything, just click the Update Credentials button and then try it again.

Let us know how it goes.

Thank you

[Berto]

Hello,

I was out of plant last Friday and just now to getting around to this. I navigated to our Nagios XI server interface page and I just get a blank screen to display. I see that nagios and httpd are both running, so not sure why a blank page is just displaying.

--Berto