5.2.9 Upgrade to 5.3 Error.

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: 5.2.9 Upgrade to 5.3 Error.

Post by dwhitfield »

Assuming the issue is caused by the 5.3.0 bug, you won't need to comment anything out.
TBT
Posts: 625
Joined: Wed May 18, 2011 1:26 pm

Re: 5.2.9 Upgrade to 5.3 Error.

Post by TBT »

dwhitfield wrote:Assuming the issue is caused by the 5.3.0 bug, you won't need to comment anything out.
Just tried 5.3.1, error remains.
Done!
Dashlets installed/updated OK
ALTER TABLE
ALTER TABLE
UPDATE 6
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE SEQUENCE
CREATE TABLE
ERROR 1142 (42000) at line 39: ALTER command denied to user 'nagiosql'@'<IP of local machine>' for table 'tbl_lnkServiceToHost'
Nagios XI 2024R2.2.1 (8 Servers)
Nagios Fusion 2024R1.0.2
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: 5.2.9 Upgrade to 5.3 Error.

Post by dwhitfield »

We are going to need to dig into this a bit more. Can you please submit a support ticket via [email protected]?

Please update this thread when you have done so. Thanks!

UPDATE: Also, can you please PM me your nagios profile. Admin->System Profile->Download Profile
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: 5.2.9 Upgrade to 5.3 Error.

Post by ssax »

After looking at the 5.3.1 upgrade script it looks like it does check for that so you should not need to comment them out. Locking this thread, we will continue in the ticket.

Thank you
Locked