Upgrade to 1.4 not working

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Upgrade to 1.4 not working

Post by BanditBBS »

Trying to upgrade to 1.4 and receiving this:

Code: Select all

[clarkj@svphlnagios02 nagiosxi]$ sudo ./upgrade
OLD VERSION: 303
ERROR 1060 (42S21) at line 1: Duplicate column name 'locale'
Last edited by BanditBBS on Thu Jan 17, 2013 11:57 am, edited 1 time in total.
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
sreinhardt
-fno-stack-protector
Posts: 4366
Joined: Mon Nov 19, 2012 12:10 pm

Re: Upgrade to 1.4 not working

Post by sreinhardt »

It would seem that you are seeing a mysql error on line 371 if ./upgrade. Can you check if you currently have a locale column in the tbl_user table? If so, or if you have already ran the upgrade script once and it error-ed out, you may try commenting this line out.
Nagios-Plugins maintainer exclusively, unless you have other C language bugs with open-source nagios projects, then I am happy to help! Please pm or use other communication to alert me to issues as I no longer track the forum.
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: Upgrade to 1.4 not working

Post by BanditBBS »

sreinhardt wrote:It would seem that you are seeing a mysql error on line 371 if ./upgrade. Can you check if you currently have a locale column in the tbl_user table? If so, or if you have already ran the upgrade script once and it error-ed out, you may try commenting this line out.
Yes, there already is a locale field in that table. Any clue why it would be there if it is new to 1.4?
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: Upgrade to 1.4 not working

Post by BanditBBS »

Nevermind. I know why. I ran ./upgrade and forgot to use sudo first. So it probably ran that line before it errored out with a permission issue.
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
sreinhardt
-fno-stack-protector
Posts: 4366
Joined: Mon Nov 19, 2012 12:10 pm

Re: Upgrade to 1.4 not working

Post by sreinhardt »

It happens! Let me know if you run into any further issues!
Nagios-Plugins maintainer exclusively, unless you have other C language bugs with open-source nagios projects, then I am happy to help! Please pm or use other communication to alert me to issues as I no longer track the forum.
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: Upgrade to 1.4 not working

Post by BanditBBS »

Both servers upgraded fine :)
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
Locked