Nagios Support Forum

Errors in the Postgres database log file when you tried to delete the entries: ERROR: syntax error at or near "LIMIT" at character 53 STATEMENT: DELETE FROM xi_cmp_trapdata WHERE trapdata_id = 542 LIMIT 1 Let's check to see if there were any errors in the Postgres database log file when yo...

But the Trap Definition record not deleted.

tgriep wrote:That message is truly just a "PHP Notice" so you can ignore it.

Log http error: [Wed Aug 01 11:17:54 2018] [error] [client 172.16.68.223] PHP Notice: Undefined variable: restart in /usr/local/nagiosxi/html/includes/components/nxti/index.php on line 0, referer: http://10.22.99.50/nagiosxi/includes/components/nxti/index.php Go in to the SNMP Trap Interface and cli...

Output: [root@nagios ~]# ls -l /usr/local/nagiosxi/ total 40 drwxr-xr-x 2 nagios nagios 4096 Jul 2 13:04 cron drwxr-xr-x 3 nagios nagios 4096 Aug 14 2015 etc drwxr-x--- 20 nagios nagios 4096 Jul 9 17:31 html -rw-r--r-- 1 nagios nagios 0 Feb 5 2015 is.installed drwxr-xr-x 3 nagios nagios 4096 Feb 5 2...

tgriep wrote:When you ran the nxti.php example, it should of put in an entry in to the database.
Can you go to the SNMP Trap Interface menu in the XI GUI and see if the Test Trap is there?

Go to the SNMP Trap Interface menu in the XI GUI and see the Test Trap

I run php /usr/local/nagiosxi/scripts/nxti.php does not error out. But try the One click Systems Test not works I think one of the Postgres tables is not large enough to store the data from the nxti.php example so to increase it, run the following as root. echo 'ALTER TABLE xi_cmp_trapdata_log ALTER...

Error happen: [root@nagios ~]# php /usr/local/nagiosxi/scripts/nxti.php --event_name="Test Event" --event_oid=".1.3.6.1.4.1.8072.2.3.0.1" --numeric_oid=".1.3.6.1.4.1.8072.2.3.0.1" --symbolic_oid="NET-SNMP-EXAMPLES-MIB::.iso.org.dod.internet.private.enterprises.netS...

duhd wrote:here al file you need.

info.rar

sharesnmp.tgz

snmp.tgz

tgriep wrote:Your server is probably still using the Postgres database for the nagiosxi database so you will have to run this command instead.

Code: Select all

echo 'select * from xi_cmp_trapdata;' |psql nagiosxi nagiosxi >>/tmp/info.txt

here al file you need.

tgriep wrote:Your server is probably still using the Postgres database for the nagiosxi database so you will have to run this command instead.

Code: Select all

echo 'select * from xi_cmp_trapdata;' |psql nagiosxi nagiosxi >>/tmp/info.txt

mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | nagios | | nagiosna | | nagiosql | | performance_schema | | sys | | test | +--------------------+ 8 rows in set (0.01 sec) [root@nagios ~]# echo 'select * from xi_cmp_trapdata;' |mysq...