MySQL Update Failed.

peacestgt

31-01-2007 09:55:36

i have the netmrt at a linux server wirh mysqlserver 5
the destination is a winxp SP2 workstation.
the community is pulbic and on the winxp client is snmp access allowed...

if i make ./netmrg-gatherer -sm under root i get

[code140bfbd8784]ccnagios:/usr/local/bin# ./netmrg-gatherer -sm
NetMRG starting.
Creating Lockfile.
Initializing SNMP library.
Initializing RRDTOOL pipe.
[ACTIVE] Last: 0, Now: 0
[Dev: 0004] Starting device thread at 2007-01-31 15:15:47.
[Dev: 0004] MySQL connection established.
[Dev: 0004] cc055 / <Field Omitted>
[Dev: 0004] SNMP Uptime is 01:54:37 (687766 centiseconds)
[Dev: 0004] Device has returned from SNMP-death.
[Dev: 0004] Number of Interfaces is 2
[Dev: 0004] Number of interfaces changed from 0 to 2
[Dev: 0004] Performing SNMP Recache.
[Dev: 0004] MySQL Update Failed. (INSERT INTO snmp_disk_cache SET dev_id = 4, disk_index = No more variables left in this MIB View (It is past the end of the MIB tree), disk_device = NULL, disk_path = NULL) (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'more variables left in this MIB View (It is past the end of the MIB tree), disk_' at line 1)
[Dev: 0004] Trimming device event log.
[Dev: 0004] Ending device thread at 2007-01-31 15:15:48, after a duration of 1 seconds.
Closed MySQL connection.
Runtime: 1
Closed RRDTOOL pipe.
Cleaned up SNMP.
[/code140bfbd8784]

whats wrong?


thx for help

regards

mike

ps i`ve use the 0.19 version

balleman

21-02-2007 19:06:14

What version of net-snmp are you using?