peacestgt
Initiate
Joined: 31 Jan 2007
Posts: 1
|
 Posted: Wed Jan 31, 2007 2:55 pm Post subject: MySQL Update Failed. |
 |
|
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:
| Code: |
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.
|
whats wrong?
thx for help
regards
mike
ps: i`ve use the 0.19 version |
|
