Multiple snmp port fields i data template

[pemca]

Hi,

I have noticed when i create a new data template with 'Get SNMP Data' as input method i see multiple snmp port fields (5) in Custom Data section.
I have a suspicion that this has come after an import of templates.

Have anyone seen this, and are there some method to remove the extra fields ?

I'm running Cacti Version 0.8.8e on Redhat Linux 6.6.

Please find attached screen dump.

cacti_snmp.png (52.09 KiB) Viewed 1583 times

[BSOD2600]

Either a bug in Cacti.... or a template you imported overwrote your 'Get SNMP Data' as input method with a bad copy. Tried 0.8.8f yet?

[pemca]

Hi,

I can try to ugrade to 8.8.f

Will 'Get SNMP Data' as input method then be replaced ?

thanks
Peter

[pemca]

Hi,

I've now upgraded to cacti 0.8.8f without any luck, still 5 snmp port entries in the data templates.

Any ideas how to move on ?

Thanks,
Peter

[BSOD2600]

upgrading will not modify existing templates.

Well either you can manually fix the template but looking at them in data queries and the input fields section... or spin up a temp instance of Cacti, export the clean version of the broken template(s), and then import into your current install.

[pemca]

Hi,

Yes, i also thought of making a new instance of cacti and import the templates one by one to find out which template is faulty,
and try to correct it there. I have over 2000 graphs now, so starting over is no go..

thanks,
Peter

[pemca]

Hi,
I managed to find out, in the database how to remove the extra 'snmp port' fields caused by some
faulty export and import from an earlier version.

mysql> SELECT id,name,data_input_id FROM cacti.data_input_fields;
+-----+----------------------------------+---------------+
| id | name | data_input_id |
+-----+----------------------------------+---------------+
| 1 | SNMP IP Address | 1 |
| 2 | SNMP Community | 1 |
| 3 | SNMP Username | 1 |
| 4 | SNMP Password | 1 |
| 5 | SNMP Version (1, 2, or 3) | 1 |
| 6 | OID | 1 |
| 7 | SNMP IP Address | 2 |
| 8 | SNMP Community | 2 |
| 9 | SNMP Username (v3) | 2 |
| 10 | SNMP Password (v3) | 2 |
| 11 | SNMP Version (1, 2, or 3) | 2 |
| 12 | Index Type | 2 |
| 13 | Index Value | 2 |
| 14 | Output Type ID | 2 |
| 15 | Disk Partition | 3 |
| 16 | Kilobytes Free | 3 |
| 17 | 1 Minute Average | 4 |
| 18 | 5 Minute Average | 4 |
| 19 | 10 Minute Average | 4 |
| 20 | Username (Optional) | 5 |
| 21 | Logged In Users | 5 |
| 22 | Grep String | 6 |
| 23 | Result (in Kilobytes) | 6 |
| 24 | Number of Processes | 7 |
| 25 | Grep String | 8 |
| 26 | Connections | 8 |
| 27 | (Optional) Log Path | 9 |
| 28 | Web Hits | 9 |
| 29 | IP Address | 10 |
| 30 | Milliseconds | 10 |
| 31 | Index Type | 11 |
| 32 | Index Value | 11 |
| 33 | Output Type ID | 11 |
| 34 | Output Value | 11 |
| 35 | Index Type | 12 |
| 36 | Index Value | 12 |
| 37 | Output Type ID | 12 |
| 38 | Output Value | 12 |
| 39 | SNMP Port | 2 | FIELD OK
| 40 | SNMP Port | 1 | FIELD OK
| 41 | SNMP Authenticaion Protocol (v3) | 1 |
| 42 | SNMP Privacy Passphrase (v3) | 1 |
| 43 | SNMP Privacy Protocol (v3) | 1 |
| 44 | SNMP Authenticaion Protocol (v3) | 2 |
| 45 | SNMP Privacy Passphrase (v3) | 2 |
| 46 | SNMP Privacy Protocol (v3) | 2 |
47 | snmp port | 1 | FIELD NOT OK !
| 48 | Port | 1 | FIELD NOT OK !
| 49 | SNMP Port | 1 | FIELD NOT OK !
| 50 | SNMP Port | 1 | FIELD NOT OK !
| 51 | Port | 2 | FIELD NOT OK !
| 52 | hostname | 13 |
| 53 | vlan count | 13 |
| 54 | Display Name | 13 |
| 55 | hostname | 14 |
| 56 | nagiosdata | 14 |
| 57 | registers server side total | 14 |
| 58 | registers client side total | 14 |
| 59 | retransmissions server side | 14 |
| 60 | retransmissions client side | 14 |
| 61 | Hostname | 15 |
| 62 | IMS DCS Query | 15 |
| 63 | Counter from IMSDCS | 15 |
| 64 | Registrations from Alb | 16 |
| 65 | Registrations from Boa | 16 |
| 66 | hostname | 16 |
| 67 | hostname | 17 |
| 68 | CPU Load from Nagios | 17 |
| 69 | 1 minute cpu load | 17 |
| 70 | Hostname | 18 |
| 71 | CPU statistics from Nagios | 18 |
| 72 | User CPU time | 18 |
| 73 | System CPU time | 18 |
| 74 | Iowait CPU time | 18 |
| 75 | Idle CPU time | 18 |
| 76 | Hostname | 19 |
| 77 | Number of Processes | 19 |
| 78 | Number of Processes | 19 |
| 79 | hostname | 20 |
| 80 | nagiosdata | 20 |
| 81 | total memory | 20 |
| 82 | used memory | 20 |
| 83 | free memory | 20 |
| 84 | swap size | 20 |
| 85 | swap in use | 20 |
| 86 | cached memory | 20 |
| 87 | shared memory | 20 |
| 88 | memory buffers | 20 |
| 89 | hostname | 21 |
| 90 | read_ops | 21 |
| 91 | write_ops | 21 |
| 92 | net_data_recv | 21 |
| 93 | net_data_sent | 21 |
| 94 | disk_data_read | 21 |
| 95 | disk_data_written | 21 |
| 96 | hdd_data_read | 21 |
| 97 | hdd_data_written | 21 |
| 98 | cpu_busy | 21 |
| 99 | nfsv3_read_latency | 21 |
| 100 | nfsv3_write_latency | 21 |
| 101 | hostname | 22 |
| 102 | nagiosdata | 22 |
| 103 | used heap | 22 |
| 104 | total heap | 22 |
| 105 | size after clean | 22 |
| 106 | 60% mark | 22 |
| 107 | 68% mark | 22 |
| 108 | 85% mark | 22 |
+-----+----------------------------------+---------------+
108 rows in set (0.00 sec)

Remove the faulty fields

mysql> DELETE FROM cacti.data_input_data WHERE data_input_field_id = 47;
Query OK, 3362 rows affected (0.03 sec)

mysql> DELETE FROM cacti.data_input_data WHERE data_input_field_id = 48;
Query OK, 3411 rows affected (0.04 sec)

mysql> DELETE FROM cacti.data_input_data WHERE data_input_field_id = 49;
Query OK, 3426 rows affected (0.04 sec)

mysql> DELETE FROM cacti.data_input_data WHERE data_input_field_id = 50;
Query OK, 3410 rows affected (0.04 sec)

mysql> DELETE FROM cacti.data_input_data WHERE data_input_field_id = 51;
Query OK, 641 rows affected (0.01 sec)



mysql> DELETE FROM cacti.data_input_fields WHERE id =47;
Query OK, 1 row affected (0.27 sec)

mysql> DELETE FROM cacti.data_input_fields WHERE id =48;
Query OK, 1 row affected (0.46 sec)

mysql> DELETE FROM cacti.data_input_fields WHERE id =49;
Query OK, 1 row affected (0.48 sec)

mysql> DELETE FROM cacti.data_input_fields WHERE id =50;
Query OK, 1 row affected (0.06 sec)

mysql> DELETE FROM cacti.data_input_fields WHERE id =51;
Query OK, 1 row affected (0.55 sec)

thanks
Peter Calum
TDC Denmark

[BSOD2600]

In \cacti\cli\ there is a repair_template script you could try running too.

[pemca]

Hi,

I implemented the fault again in my lab an ran the repair script.

[root@khk9dsg36 cli]# php repair_templates.php
NOTE: Performing Check of Templates
NOTE: Performing Check of Data Templates
NOTE: No Damaged Data Templates Found
NOTE: Performing Check of Graph Templates
NOTE: No Damaged Graph Templates Found

But fault was still there

/Peter

[BSOD2600]

Well thats a bummer. On a clean 0.8.8f install, are you able to replicate this issue? If so, what are the steps?

[pemca]

Hi,

After clean up on my test system, i created a new host template with 6 graphs and underlying snmp data templates.
I exported them and imported them on my new installed Lab, but no errors and extra snmp ports after import.

I still have the corrupted exported host template, but this is from and old cacti installation.

I do not think it's worth the time to explore more in this.

thanks
Peter