empty graphs and MySql errors

marros

04-11-2004 15:16:48

After setting up everything like in the basic tutorial (Chap 10), LastLog gives me
NetMRG starting.
[Dev 0006] Starting device thread at 2004-11-04 141000.
[Dev 0007] Starting device thread at 2004-11-04 141001.
[Dev 0006] Device is SNMP-dead. Avoiding SNMP tests.
[Dev 0007] Device is SNMP-dead. Avoiding SNMP tests.
[Dev 0007] Ending device thread at 2004-11-04 141001, after a duration of 0 seconds.
Thread Ended.
[Dev 0006] Ending device thread at 2004-11-04 141001, after a duration of 1 seconds.

and netmrg-gatherer -sm gives
NetMRG starting.
Creating Lockfile.
Initializing SNMP library.
Initializing RRDTOOL pipe.
[ACTIVE] Last 0, Now 0
[Dev 0006] Starting device thread at 2004-11-04 140931.
[Dev 0006] MySQL connection established.
[Dev 0006] fs2 / <Field Omitted>
[Dev 0007] Starting device thread at 2004-11-04 140931.
[Dev 0007] MySQL connection established.
[Dev 0006] SNMP Uptime is Zilch (0 centiseconds)
[Dev 0006] Device is SNMP-dead. Avoiding SNMP tests.
[Dev 0006] [Sub 0006] Starting Subdevice.
[Dev 0006] [Sub 0006] [Mon 0025] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0025] Avoided.
[Dev 0006] [Sub 0006] [Mon 0025] Value U
[Dev 0006] [Sub 0006] [Mon 0025] Value is not numeric.
[Dev 0006] [Sub 0006] [Mon 0022] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0022] Avoided.
[Dev 0006] [Sub 0006] [Mon 0022] Value U
[Dev 0006] [Sub 0006] [Mon 0022] Value is not numeric.
[Dev 0006] [Sub 0006] [Mon 0023] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0023] Avoided.
[Dev 0006] [Sub 0006] [Mon 0023] Value U
[Dev 0006] [Sub 0006] [Mon 0023] Value is not numeric.
[Dev 0006] [Sub 0006] [Mon 0024] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0024] Avoided.
[Dev 0006] [Sub 0006] [Mon 0024] Value U
[Dev 0006] [Sub 0006] [Mon 0024] Value is not numeric.
[Dev 0006] [Sub 0006] [Mon 0026] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0026] Avoided.
[Dev 0006] [Sub 0006] [Mon 0026] Value U
[Dev 0006] [Sub 0006] [Mon 0026] Value is not numeric.
[Dev 0006] [Sub 0006] [Mon 0027] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0027] Avoided.
[Dev 0006] [Sub 0006] [Mon 0027] Value U
[Dev 0006] [Sub 0006] [Mon 0027] Value is not numeric.
[Dev 0006] [Sub 0006] [Mon 0028] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0028] Avoided.
[Dev 0006] [Sub 0006] [Mon 0028] Value U
[Dev 0006] [Sub 0006] [Mon 0028] Value is not numeric.
[Dev 0006] [Sub 0006] [Mon 0029] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0029] Avoided.
[Dev 0006] [Sub 0006] [Mon 0029] Value U
[Dev 0006] [Sub 0006] [Mon 0029] Value is not numeric.
[Dev 0006] Trimming device event log.
[Dev 0006] Ending device thread at 2004-11-04 140931, after a duration of 0 seconds.
Thread Ended.
[Dev 0007] fs1 / <Field Omitted>
[Dev 0007] SNMP Uptime is Zilch (0 centiseconds)
[Dev 0007] Device is SNMP-dead. Avoiding SNMP tests.
[Dev 0007] [Sub 0007] Starting Subdevice.
[Dev 0007] [Sub 0007] [Mon 0031] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0031] Avoided.
[Dev 0007] [Sub 0007] [Mon 0031] Value U
[Dev 0007] [Sub 0007] [Mon 0031] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0030] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0030] Avoided.
[Dev 0007] [Sub 0007] [Mon 0030] Value U
[Dev 0007] [Sub 0007] [Mon 0030] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0032] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0032] Avoided.
[Dev 0007] [Sub 0007] [Mon 0032] Value U
[Dev 0007] [Sub 0007] [Mon 0032] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0037] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0037] Avoided.
[Dev 0007] [Sub 0007] [Mon 0037] Value U
[Dev 0007] [Sub 0007] [Mon 0037] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0038] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0038] Avoided.
[Dev 0007] [Sub 0007] [Mon 0038] Value U
[Dev 0007] [Sub 0007] [Mon 0038] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0039] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0039] Avoided.
[Dev 0007] [Sub 0007] [Mon 0039] Value U
[Dev 0007] [Sub 0007] [Mon 0039] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0036] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0036] Avoided.
[Dev 0007] [Sub 0007] [Mon 0036] Value U
[Dev 0007] [Sub 0007] [Mon 0036] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0035] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0035] Avoided.
[Dev 0007] [Sub 0007] [Mon 0035] Value U
[Dev 0007] [Sub 0007] [Mon 0035] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0034] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0034] Avoided.
[Dev 0007] [Sub 0007] [Mon 0034] Value U
[Dev 0007] [Sub 0007] [Mon 0034] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0033] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0033] Avoided.
[Dev 0007] [Sub 0007] [Mon 0033] Value U
[Dev 0007] [Sub 0007] [Mon 0033] Value is not numeric.
[Dev 0007] Trimming device event log.
[Dev 0007] Ending device thread at 2004-11-04 140931, after a duration of 0 seconds.
[PASSIVE] Last 0, Now 0
Closed MySQL connection.
Runtime 0
Closed RRDTOOL pipe.
Cleaned up SNMP.

And if I Disable SNMP Uptime Check netmrg-gatherer -sm gives
NetMRG starting.
Creating Lockfile.
Initializing SNMP library.
Initializing RRDTOOL pipe.
[ACTIVE] Last 0, Now 0
[Dev 0006] Starting device thread at 2004-11-04 141353.
[Dev 0006] MySQL connection established.
[Dev 0006] fs2 / <Field Omitted>
[Dev 0006] Not checking SNMP uptime as per configuration.
[Dev 0006] This option should only be used as a last resort.
[Dev 0006] Number of Interfaces is 0
[Dev 0006] Number of cached interfaces (3) doesn't match reported number of interfaces.
[Dev 0006] Performing SNMP Recache.
[Dev 0007] Starting device thread at 2004-11-04 141353.
[Dev 0007] MySQL connection established.
[Dev 0007] fs1 / <Field Omitted>
[Dev 0007] Not checking SNMP uptime as per configuration.
[Dev 0007] This option should only be used as a last resort.
[Dev 0007] Number of Interfaces is 0
[Dev 0007] [Sub 0007] Starting Subdevice.
[Dev 0007] [Sub 0007] [Mon 0031] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0031] Value .1.3.6.1.4.1.2021.11.50.0 4600447
[Dev 0007] [Sub 0007] [Mon 0031] Value is a decimal.
[Dev 0007] [Sub 0007] [Mon 0030] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0030] Value .1.3.6.1.4.1.2021.11.52.0 997000
[Dev 0007] [Sub 0007] [Mon 0030] Value is a decimal.
[Dev 0007] [Sub 0007] [Mon 0032] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0032] Value .1.3.6.1.4.1.2021.11.51.0 958523
[Dev 0007] [Sub 0007] [Mon 0032] Value is a decimal.
[Dev 0007] [Sub 0007] [Mon 0037] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0037] Value .1.3.6.1.4.1.2021.10.1.3.1 0.05
[Dev 0007] [Sub 0007] [Mon 0037] Value is a decimal.
[Dev 0007] [Sub 0007] [Mon 0038] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0038] Value .1.3.6.1.4.1.2021.10.1.3.2 0.03
[Dev 0007] [Sub 0007] [Mon 0038] Value is a decimal.
[Dev 0007] [Sub 0007] [Mon 0039] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0039] Value .1.3.6.1.4.1.2021.10.1.3.3 0.00
[Dev 0007] [Sub 0007] [Mon 0039] Value is a decimal.
[Dev 0007] [Sub 0007] [Mon 0036] Starting Monitor.
[Dev 0006] MySQL Update Failed. (UPDATE snmp_interface_cache SET ifIP = '192.168.87.240' WHERE dev_id=6 AND ifIndex=.1.3.6.1.2.1.4.20.1.2.192.168.87.240 2) (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 '.3.6.1.2.1.4.20.1.2.192.168.87.240 2' at line 1)
[Dev 0006] MySQL Update Failed. (UPDATE snmp_interface_cache SET ifIP = '127.0.0.1' WHERE dev_id=6 AND ifIndex=.1.3.6.1.2.1.4.20.1.2.127.0.0.1 1) (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 '.3.6.1.2.1.4.20.1.2.127.0.0.1 1' at line 1)
[Dev 0006] MySQL Update Failed. (INSERT INTO snmp_disk_cache SET dev_id = 6, disk_index = .1.3.6.1.4.1.2021.9.1.1.1 1, 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 '.3.6.1.4.1.2021.9.1.1.1 1, disk_device = NULL, disk_path = NU)
[Dev 0006] [Sub 0006] Starting Subdevice.
[Dev 0006] [Sub 0006] [Mon 0025] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0025] Value U
[Dev 0006] [Sub 0006] [Mon 0025] Value is not numeric.
[Dev 0006] [Sub 0006] [Mon 0022] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0022] Value .1.3.6.1.4.1.2021.11.52.0 350507
[Dev 0006] [Sub 0006] [Mon 0022] Value is a decimal.
[Dev 0006] [Sub 0006] [Mon 0023] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0023] Value .1.3.6.1.4.1.2021.11.50.0 3445490
[Dev 0006] [Sub 0006] [Mon 0023] Value is a decimal.
[Dev 0006] [Sub 0006] [Mon 0024] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0024] Value .1.3.6.1.4.1.2021.11.51.0 48748
[Dev 0006] [Sub 0006] [Mon 0024] Value is a decimal.
[Dev 0006] [Sub 0006] [Mon 0026] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0026] Value U
[Dev 0006] [Sub 0006] [Mon 0026] Value is not numeric.
[Dev 0006] [Sub 0006] [Mon 0027] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0027] Value .1.3.6.1.4.1.2021.10.1.3.1 0.19
[Dev 0006] [Sub 0006] [Mon 0027] Value is a decimal.
[Dev 0006] [Sub 0006] [Mon 0028] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0036] Value U
[Dev 0007] [Sub 0007] [Mon 0036] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0035] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0035] Value U
[Dev 0007] [Sub 0007] [Mon 0035] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0034] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0034] Value U
[Dev 0007] [Sub 0007] [Mon 0034] Value is not numeric.
[Dev 0007] [Sub 0007] [Mon 0033] Starting Monitor.
[Dev 0007] [Sub 0007] [Mon 0033] Value U
[Dev 0007] [Sub 0007] [Mon 0033] Value is not numeric.
[Dev 0007] Trimming device event log.
[Dev 0007] Ending device thread at 2004-11-04 141353, after a duration of 0 seconds.
Thread Ended.
[Dev 0006] [Sub 0006] [Mon 0028] Value .1.3.6.1.4.1.2021.10.1.3.2 0.19
[Dev 0006] [Sub 0006] [Mon 0028] Value is a decimal.
[Dev 0006] [Sub 0006] [Mon 0029] Starting Monitor.
[Dev 0006] [Sub 0006] [Mon 0029] Value .1.3.6.1.4.1.2021.10.1.3.3 0.17
[Dev 0006] [Sub 0006] [Mon 0029] Value is a decimal.
[Dev 0006] Trimming device event log.
[Dev 0006] Ending device thread at 2004-11-04 141353, after a duration of 0 seconds.
[PASSIVE] Last 0, Now 0
Closed MySQL connection.
Runtime 0
Thread Ended.
Closed RRDTOOL pipe.
Cleaned up SNMP.

All devices are working with snmp (both walk and get work, as all users...) And I am lost.

balleman

04-11-2004 15:38:10

This looks like issues with our parsing of the output from your SNMP library. What version of net-snmp are you using? Please provide your distro, version, etc, as well.

silfreed

04-11-2004 15:42:00

We've had a user report this problem before (in this thread) where the SNMP value included the OID and the value. Maybe look over that post and see if anything looks familiar?

-Doug

marros

05-11-2004 10:20:29

I am using Mandrake 10.1, with the updates from the official site. Net-snmp is net-snmp-5.1-7mdk.
In the database, table snmp_interface_cache has ifIndex is int(11), but the data is
ifIndex=.1.3.6.1.2.1.4.20.1.2.192.168.87.240 2 (direct copy, so the space is there also) which should be type varchar (or char) 255 maybe? Same with disk_index from snmp_disk_cache?

balleman

05-11-2004 10:24:55

The ".1.3.6.1.2.1.4.20.1.2.192.168.87.240 2" should actually just be "2". This is probably a problem with our parsing of the output from net-snmp, however I am not sure why your platform is behaving different than ours in this instance.

marros

05-11-2004 11:08:55

If I run snmpwalk with a -O v, it returns just the value 2. I have looked in the snmp.conf (snmp.local.conf) for a switch to make this the default behaviour, but to no avail. This seems to be a problem with Mandrake 10.x, as seen from another thread.

balleman

05-11-2004 14:25:13

We'll have to try to get a Mandrake 10.x box up to debug with... please bear with us.

silfreed

05-11-2004 14:54:49

Working on it..

-Doug

silfreed

05-11-2004 18:51:32

Looks like Mandrake's /etc/snmp/snmp.local.conf file has a line 'quickprinting yes'. If you could try disabling this and let us know how it works, that'd be great. If it works, we'll see what we can do as a more permanent solution instead of this workaround.

-Doug

marros

10-11-2004 13:01:13

Yes, changing the quickprinting to No has helped....I am getting data for the graphs. Netmrg-gatherer -sm also shows proper data, and I can now have snmp uptime allowed. Thanks for your help.

silfreed

10-11-2004 13:26:19

I guess I should also mention that the gatherer now sets this itself at runtime, so if you'd prefer to leave the setting in snmp.local.conf alone, you can.

-Doug