Manage Users: Unknown column 'login_attempts'

[gehogan3]

Hello Everyone,

I am attempting to split our Nagios monitoring infrastructure, so I figured the easiest way to accomplish this would be to build the new servers, install the latest version of NagiosXI and restore from a nagios backup of the other system. Then go through and remove what I do not want out of the new system.

The first problem that I have run into, when cleaning out users, is an error at the top of the "Manage Users" page which states:

SQL ERROR [nagiosxi] : Unknown column 'login_attempts' in 'where clause'

I am just wondering if it might be caused by the fact that the "old" system (from which the backup came) is version 5.2.3 and the new one is version 5.4.12.


And now that I have made it through cleaning out all of the stuff from the new servers that I do not want...I go to "Apply the Configuration" and get this error:

SQL Error [nagiosql] : Table 'nagiosql.tbl_session_locks' doesn't exist

Anyone run into this before? Help!

Thanks in advance!

-Emmett

[bolson]

Hello gehogan3,

Your guess is likely correct. It's likely that there were changes in the database between the two versions. It's a significant jump from 5.2.3 to 5.4.12. The best practice for your use case is to first upgrade your 5.2.3 to 5.4.12 and then do the backup and restore.

[gehogan3]

That's what I was afraid of.

Upgrading the "old" one isn't an option, so I guess I am going to have to try installing 5.2.3 on the NEW server, restore the data then upgrading.

Ugh.

[scottwilkerson]

If you restored a backup you likely are no longer on 5.4.12, the restore of backup should have downgraded you when restored

you should be able to no run the upgrade to the latest

[gehogan3]

The "restore" only restored the configs and database... I can "upgrade" even though the binaries and everything else is the latest version?

Also, can I do a "jump upgrade" from 5.2.3 all the way to 5.4.12?

(This would be great...I am not looking forward to tossing the install that I already have.)

[scottwilkerson]

What did you restore? Because a full backup contains all of the databases and all of the html files not just the configs.

Did you do this?
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

[gehogan3]

Yep...that's what I did.

Unfortunately...I cannot even go the "install old version and upgrade" route as someone let our support contract expire.
The upgrade scripts check that.

Thanks for your help.

[scottwilkerson]

If you did that your current version in the lower left should reflect the "old version"

Yes, you will need to upgrade either way, and current maintenance will be required.