Nagios Support Forum

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

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!

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

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]#

Please cd into /tmp/nagiosxi/
And run this command: Then rerun the installation and let us know if it completes successfully.

scottwilkerson wrote: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...

daviddief wrote:

scottwilkerson wrote: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

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...

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?

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.