Error during upgrade from 5.5.9 to 5.6.2

[daviddief]

Get the following upgrade during the process:

INSTALL: Dashlets installed/updated OK.
ERROR 1060 (42S21) at line 25: Duplicate column name 'dependent_servicegroup_name'

Seems similar to another posting on the Phantom JS error which I looked at and ran the repair which seemed to get me past the Phantom JS error but now I have this one. Not sure if I need to re-run the DB repair line multiple times to finally finish this out?

Any ideas or extra information I can provide?

Thanks,

David

[daviddief]

this is an imported OVF from Nagios running on VMware and the application is running behind a proxy for internet. please let me know where i can find the logs you may need and i will get them posted ASAP. Thanks!

[daviddief]

I am just going to go ahead and run the manual upgrade I found in a similar post:

cd /tmp
rm -rf nagiosxi xi*.tar.gz
wget https://assets.nagios.com/downloads/nag ... 6.2.tar.gz
tar xzf xi-5.6.2.tar.gz
cd /tmp/nagiosxi

if it works i will let everyone know

[daviddief]

same problem still...


DASHLET NAME: rss_dashlet
CMD=grep register_dashlet /usr/local/nagiosxi/tmp/PLeGL/rss_dashl
et/rss_dashlet.inc.php | wc -l
1
OUT=1
Dashlet looks ok...
CMD: cp -rf /usr/local/nagiosxi/tmp/PLeGL/rss_dashlet /usr/local/
nagiosxi/html/includes/dashlets/
CMD: rm -rf /usr/local/nagiosxi/tmp/PLeGL
CMD: . /usr/local/nagiosxi/var/xi-sys.cfg && chown -R $nagiosuser
/usr/local/nagiosxi/html/includes/dashlets/rss_dashlet


Done!
INSTALL: Dashlets installed/updated OK.
ERROR 1060 (42S21) at line 25: Duplicate column name 'dependent_servicegroup_name'
[root@localhost nagiosxi]#

[scottwilkerson]

Please cd into /tmp/nagiosxi/
And run this command:

Code: Select all

touch mysql.5600.updated

Then rerun the installation and let us know if it completes successfully.

[daviddief]

Please cd into /tmp/nagiosxi/
And run this command:

Code: Select all

touch mysql.5600.updated

Then rerun the installation and let us know if it completes successfully.

Thanks! Running it again now...

[scottwilkerson]

Please cd into /tmp/nagiosxi/
And run this command:

Code: Select all

touch mysql.5600.updated

Then rerun the installation and let us know if it completes successfully.

Thanks! Running it again now...

Let us know if you have any other issues

[daviddief]

not sure if I am getting closer to finish or not as I have the Phantom JS trying to download yet the path is incorrect I think. I went head and copied the link to pull it manually and I got a space in the middle of 'downloads'.

http://assets.nagios.com/downl oads/nagiosxi/packages/phantomjs-2.1.1-linux-x86_64.tar.bz2


--2019-05-31 16:56:37-- (try: 2) http://assets.nagios.com/downl
oads/nagiosxi/packages/phantomjs-2.1.1-linux-x86_64.tar.bz2
Connecting to assets.nagios.com (assets.nagios.com)|72.14.181.71|
:80... failed: Connection timed out.
Connecting to assets.nagios.com (assets.nagios.com)|2600:f0
3c:91ff:fedf:b821|:80... failed: Connection timed out.
Retrying.

--2019-05-31 17:00:54-- (try: 3) http://assets.nagios.com/downl
oads/nagiosxi/packages/phantomjs-2.1.1-linux-x86_64.tar.bz2
Connecting to assets.nagios.com (assets.nagios.com)|72.14.181.71|
:80... failed: Connection timed out.
Connecting to assets.nagios.com (assets.nagios.com)|2600:f0
3c:91ff:fedf:b821|:80... failed: Connection timed out.
Retrying.

--2019-05-31 17:05:11-- (try: 4) http://assets.nagios.com/downl
oads/nagiosxi/packages/phantomjs-2.1.1-linux-x86_64.tar.bz2
Connecting to assets.nagios.com (assets.nagios.com)|72.14.181.71|
:80... failed: Connection timed out.
Connecting to assets.nagios.com (assets.nagios.com)|2600:f0
3c:91ff:fedf:b821|:80...

[scottwilkerson]

Is this server behind a proxy? If so is the proxy info set in /etc/wgetrc ?
https://support.nagios.com/kb/article.php?id=147

Is there a firewall blocking connections?

[daviddief]

Yep, you got it. I forgot to tweak the /etc/wgetrc file and now it is able to finish. Last step is to 'Copy new sudo permissions from './nagiosxi/nagiosxi.sudoers' to the /etc/sudoers file'. Is there a simple one-liner command for that? I am an idiot with Linux so I try not to get too adventurous.