SNMP Walk Wizard error - SQL Error [nagiosxi] : Unknown colu

[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

[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

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

[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

[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!

[scottwilkerson]

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