Page 1 of 1
SNMP Walk Wizard error - SQL Error [nagiosxi] : Unknown colu
Posted: Tue Sep 10, 2019 10:25 am
by GldRush98
Seeing this error at the top of the new SNMP Walk wizard... Both prod and dev servers showing the same error.
SQL Error [nagiosxi] : Unknown column 'trapdata_parent_mib_name' in 'where clause'
snmp_walk_wizard_error.PNG
Re: SNMP Walk Wizard error - SQL Error [nagiosxi] : Unknown
Posted: Tue Sep 10, 2019 11:53 am
by scottwilkerson
It looks like part of a DB migration may not have happened properly
Can you run the following:
Code: Select all
cd /tmp
rm -rf nagiosxi xi*
wget https://assets.nagios.com/downloads/nagiosxi/xi-latest.tar.gz
tar xzf xi-latest.tar.gz
cd /tmp/nagiosxi
psql nagiosxinagiosxi -f nagiosxi/nagiosxi-db/mods/pgsql/schema_05.sql
Re: SNMP Walk Wizard error - SQL Error [nagiosxi] : Unknown
Posted: Tue Sep 10, 2019 12:46 pm
by GldRush98
Code: Select all
[root@nagios nagiosxi]# psql nagiosxinagiosxi -f nagiosxi/nagiosxi-db/mods/pgsql/schema_05.sql
-bash: psql: command not found
[root@nagios nagiosxi]# which psql
/usr/bin/which: no psql in (/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
edit: I believe both are fully mysql systems with not postgres on them. Pretty sure I converted/upgraded them a bit ago.
Re: SNMP Walk Wizard error - SQL Error [nagiosxi] : Unknown
Posted: Tue Sep 10, 2019 1:02 pm
by scottwilkerson
Sorry, for some reason I thought you might have been on a older postgresql system
lets run the following if you have changes your root mysql password to somethign other than nagiosxi adjust
-pnagiosxi accordingly
Code: Select all
cd /tmp/nagiosxi
mysql -pnagiosxi --database=nagiosxi --force < nagiosxi/nagiosxi-db/mods/mysql/schema_05.sql
Re: SNMP Walk Wizard error - SQL Error [nagiosxi] : Unknown
Posted: Tue Sep 10, 2019 1:06 pm
by GldRush98
Yeah, sorry I converted these to fully mysql a while back.
Ok, that command seemed to have worked, I'm not seeing that error on the config wizard screen any more. Thank you!
Re: SNMP Walk Wizard error - SQL Error [nagiosxi] : Unknown
Posted: Tue Sep 10, 2019 1:25 pm
by scottwilkerson
GldRush98 wrote:Yeah, sorry I converted these to fully mysql a while back.
Ok, that command seemed to have worked, I'm not seeing that error on the config wizard screen any more. Thank you!
Great!
Locking