Place Your Feature Requests & Bug Reports Here

[TheWitness]

Hi,

one error : PHP Fatal error: Call to undefined function mactrack_find_host_graphs() in /var/www/cacti/mactrack/lib/macktrack_functions on line 784

It also doesn't scan that device that run then.

I also get "No Non Interface graphs in cacti" when hovering over the graphs icon in mac addresses and interfaces.

No errors in the log.

Thanks,

Joris.

In SVN now. It'll take a few minutes to sync to the public SVN.

[JorisFRST]

rev 813 ?

[TheWitness]

rev 813 ?

Yes.

[JorisFRST]

Hi, now some errors in the log, and non of the interfaces or mac addresses you can click the graph icon.

03/25/2010 12:53:24 PM - SYSTEM MACTRACK STATS: Time:411.6421 ConcurrentProcesses:7 Devices:82
03/25/2010 12:47:26 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM mac_track_interface_graphs WHERE present=0 AND device_id=9 AND host_id=28'
03/25/2010 12:47:26 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"INSERT INTO mac_track_interface_graphs (ifIndex, ifName, local_graph_id, device_id, host_id, snmp_query_id, graph_template_id, field_value, field_name, present) VALUES (10138,'Gi1/0/38',143,9,28,25,1,'Gi1/0/38','ifName', 1), (10138,'Gi1/0/38',144,9,28,33,1,'Gi1/0/38','ifName', 1), (10613,'Gi2/0/13',139,9,28,25,1,'Gi2/0/13','ifName', 1), (10613,'Gi2/0/13',142,9,28,33,1,'Gi2/0/13','ifName', 1), (10612,'Gi2/0/12',138,9,28,25,1,'Gi2/0/12','ifName', 1), (10612,'Gi2/0/12',141,9,28,33,1,'Gi2/0/12','ifName', 1), (10611,'Gi2/0/11',137,9,28,25,1,'Gi2/0/11','ifName', 1), (10611,'Gi2/0/11',140,9,28,33,1,'Gi2/0/11','ifName', 1), (10148,'Gi1/0/48',505,9,28,67,1,'Gi1/0/48','ifName', 1), (5002,'Po2',115,9,28,33,1,'Po2','ifName', 1), (5002,'Po2',119,9,28,25,1,'Po2','ifName', 1), (5001,'Po1',114,9,28,33,1,'Po1','ifName', 1), (5001,'Po1',118,9,28,25,1,'Po1','ifName', 1) ON DUPLICATE KEY UPDATE snmp_query_id=VALUES(snmp_query_id), graph_template_id=VALUES(graph_template_id), field_value=VALUES(field_value), field_name=VALUES(field_name), present=VALUES(present)'
03/25/2010 12:47:26 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"UPDATE mac_track_interface_graphs SET present=0 WHERE device_id=9 AND host_id=28'
03/25/2010 12:46:59 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM mac_track_interface_graphs WHERE present=0 AND device_id=11 AND host_id=30'
03/25/2010 12:46:59 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"INSERT INTO mac_track_interface_graphs (ifIndex, ifName, local_graph_id, device_id, host_id, snmp_query_id, graph_template_id, field_value, field_name, present) VALUES (5002,'Po2',123,11,30,25,1,'Po2','ifName', 1), (5001,'Po1',122,11,30,25,1,'Po1','ifName', 1) ON DUPLICATE KEY UPDATE snmp_query_id=VALUES(snmp_query_id), graph_template_id=VALUES(graph_template_id), field_value=VALUES(field_value), field_name=VALUES(field_name), present=VALUES(present)'
03/25/2010 12:46:59 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"UPDATE mac_track_interface_graphs SET present=0 WHERE device_id=11 AND host_id=30'
03/25/2010 12:46:39 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM mac_track_interface_graphs WHERE present=0 AND device_id=3 AND host_id=37'
03/25/2010 12:46:39 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"INSERT INTO mac_track_interface_graphs (ifIndex, ifName, local_graph_id, device_id, host_id, snmp_query_id, graph_template_id, field_value, field_name, present) VALUES (11101,'Gi3/0/1',959,3,37,124,1,'Gi3/0/1','ifName', 1), (10601,'Gi2/0/1',958,3,37,124,1,'Gi2/0/1','ifName', 1), (10101,'Gi1/0/1',957,3,37,124,1,'Gi1/0/1','ifName', 1) ON DUPLICATE KEY UPDATE snmp_query_id=VALUES(snmp_query_id), graph_template_id=VALUES(graph_template_id), field_value=VALUES(field_value), field_name=VALUES(field_name), present=VALUES(present)'
03/25/2010 12:46:39 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"UPDATE mac_track_interface_graphs SET present=0 WHERE device_id=3 AND host_id=37'
03/25/2010 12:46:37 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM mac_track_interface_graphs WHERE present=0 AND device_id=90 AND host_id=58'
03/25/2010 12:46:37 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"INSERT INTO mac_track_interface_graphs (ifIndex, ifName, local_graph_id, device_id, host_id, snmp_query_id, graph_template_id, field_value, field_name, present) VALUES (10101,'Gi0/1',436,90,58,25,1,'Gi0/1','ifName', 1) ON DUPLICATE KEY UPDATE snmp_query_id=VALUES(snmp_query_id), graph_template_id=VALUES(graph_template_id), field_value=VALUES(field_value), field_name=VALUES(field_name), present=VALUES(present)'
03/25/2010 12:46:37 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"UPDATE mac_track_interface_graphs SET present=0 WHERE device_id=90 AND host_id=58'
03/25/2010 12:46:37 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM mac_track_interface_graphs WHERE present=0 AND device_id=50 AND host_id=35'
03/25/2010 12:46:37 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"INSERT INTO mac_track_interface_graphs (ifIndex, ifName, local_graph_id, device_id, host_id, snmp_query_id, graph_template_id, field_value, field_name, present) VALUES (10609,'Gi2/0/9',406,50,35,33,1,'Gi2/0/9','ifName', 1), (10609,'Gi2/0/9',412,50,35,67,1,'Gi2/0/9','ifName', 1), (10608,'Gi2/0/8',207,50,35,25,1,'Gi2/0/8','ifName', 1), (10607,'Gi2/0/7',405,50,35,33,1,'Gi2/0/7','ifName', 1), (10607,'Gi2/0/7',411,50,35,67,1,'Gi2/0/7','ifName', 1), (10606,'Gi2/0/6',220,50,35,2,1,'Gi2/0/6','ifName', 1), (10651,'Gi2/0/51',157,50,35,25,1,'Gi2/0/51','ifName', 1), (10651,'Gi2/0/51',170,50,35,33,1,'Gi2/0/51','ifName', 1), (10650,'Gi2/0/50',156,50,35,25,1,'Gi2/0/50','ifName', 1), (10650,'Gi2/0/50',169,50,35,33,1,'Gi2/0/50','ifName', 1), (10649,'Gi2/0/49',155,50,35,25,1,'Gi2/0/49','ifName', 1), (10649,'Gi2/0/49',168,50,35,33,1,'Gi2/0/49','ifName', 1), (10152,'Gi1/0/52',167,50,35,33,1,'Gi1/0/52','ifName', 1), (10151,'Gi1/0/51',166,50,35,33,1,'Gi1/0/51','ifName', 1), (10150,'Gi1/0/50',165,50,35,33,1,'Gi1/0/50','ifName', 1), (10149,'Gi1/0/49',164,50,35,33,1,'Gi1/0/49','ifName', 1), (10148,'Gi1/0/48',154,50,35,25,1,'Gi1/0/48','ifName', 1), (10148,'Gi1/0/48',163,50,35,33,1,'Gi1/0/48','ifName', 1), (10147,'Gi1/0/47',153,50,35,25,1,'Gi1/0/47','ifName', 1), (10147,'Gi1/0/47',162,50,35,33,1,'Gi1/0/47','ifName', 1), (10146,'Gi1/0/46',152,50,35,25,1,'Gi1/0/46','ifName', 1), (10146,'Gi1/0/46',161,50,35,33,1,'Gi1/0/46','ifName', 1), (10143,'Gi1/0/43',430,50,35,2,1,'Gi1/0/43','ifName', 1), (10143,'Gi1/0/43',431,50,35,32,1,'Gi1/0/43','ifName', 1), (10143,'Gi1/0/43',432,50,35,22,1,'Gi1/0/43','ifName', 1), (10143,'Gi1/0/43',433,50,35,33,1,'Gi1/0/43','ifName', 1), (10122,'Gi1/0/22',404,50,35,33,1,'Gi1/0/22','ifName', 1), (10122,'Gi1/0/22',410,50,35,67,1,'Gi1/0/22','ifName', 1), (10120,'Gi1/0/20',321,50,35,71,1,'Gi1/0/20','ifName', 1), (10120,'Gi1/0/20',403,50,35,33,1,'Gi1/0/20','ifName', 1), (10120,'Gi1/0/20',409,50,35,67,1,'Gi1/0/20','ifName', 1), (10108,'Gi1/0/8',206,50,35,25,1,'Gi1/0/8','ifName', 1), (10106,'Gi1/0/6',219,50,35,2,1,'Gi1/0/6','ifName', 1), (5021,'Po21',402,50,35,33,1,'Po21','ifName', 1), (5021,'Po21',408,50,35,67,1,'Po21','ifName', 1), (5020,'Po20',401,50,35,33,1,'Po20','ifName', 1), (5020,'Po20',407,50,35,67,1,'Po20','ifName', 1), (5003,'Po3',151,50,35,25,1,'Po3','ifName', 1), (5003,'Po3',160,50,35,33,1,'Po3','ifName', 1), (5002,'Po2',150,50,35,25,1,'Po2','ifName', 1), (5002,'Po2',159,50,35,33,1,'Po2','ifName', 1), (5001,'Po1',149,50,35,25,1,'Po1','ifName', 1), (5001,'Po1',158,50,35,33,1,'Po1','ifName', 1) ON DUPLICATE KEY UPDATE snmp_query_id=VALUES(snmp_query_id), graph_template_id=VALUES(graph_template_id), field_value=VALUES(field_value), field_name=VALUES(field_name), present=VALUES(present)'
03/25/2010 12:46:37 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"UPDATE mac_track_interface_graphs SET present=0 WHERE device_id=50 AND host_id=35'


It however did scan the devices.

Thanks,

Joris.

[TheWitness]

Joris,

Modify the plugin_config table and reduce your version to 2.2.0 there, then goto Plugin Management and see if that table get's created as it should.

Let me know right away. Have to goto the office in a few minutes.

TheWitness

[TheWitness]

I found an issue with the database upgrade (create table script) that was causing a failure. I committed 814 and will do 815 shortly. Got to got to work though.

TheWitness

[TheWitness]

815 is in. You have to change the version back to 2.2.0, then upgrade by going to Plugin Management. I expect the 1146's to be gone then. Let's hope that's it.

TheWitness

[JorisFRST]

oh,

just missed your message, i'll put it back to 2.2.0 and update to the latest rev then.

Thanks,

Joris.

[toe_cutter]

815 is in. You have to change the version back to 2.2.0, then upgrade by going to Plugin Management. I expect the 1146's to be gone then. Let's hope that's it.

TheWitness

The 1146's are gone, but when browsing the tabs...

Code: Select all

03/25/2010 01:26:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT local_graph_id FROM mac_track_interface_graphs WHERE host_id=46 AND ifName=Fa0/28"

Also, my previous error is still there, i dont use any access method for my devices and thus leaved the username/password fields blank, i tried with a username/password but no difference.

Edit: my mactrack poll is taking ~300s, i must have upgraded in the middle of a poll or something, going to remove all the files and download them again...
Edit2: nope, same SQL-error, and the undefined indexes. Apparently im missing an IP-scan function for Cisco devices too? :S get_CTAlias doesnt work...

[JorisFRST]

SELECT * FROM mac_track_interface_graphs;
Empty Set (0.00 Sec),

so the table has been created.

Running the poller again, and don't see the 1146's.

I'll give an update when it has finished.

Thanks,

Joris.

[JorisFRST]

I only get the option "view non interface graphs".

I'll try and look at some more switches.

Thanks,

Joris.

[TheWitness]

This one needs to be corrected in mactrack_functions.php. You need to add single quotes around ifName.

Code: Select all

03/25/2010 01:26:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT local_graph_id FROM mac_track_interface_graphs WHERE host_id=46 AND ifName=Fa0/28"

Simple fix, but I can't do anything about it at the moment. There are also a few more indexes that are/should be required. More on that later.

TheWitness

[toe_cutter]

This one needs to be corrected in mactrack_functions.php. You need to add single quotes around ifName.

Code: Select all

03/25/2010 01:26:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT local_graph_id FROM mac_track_interface_graphs WHERE host_id=46 AND ifName=Fa0/28"

Simple fix, but I can't do anything about it at the moment. There are also a few more indexes that are/should be required. More on that later.

TheWitness

Yep, fixed it, replace line 2304 with:

Code: Select all

WHERE host_id=" . $device["host_id"] . " AND ifName='" . $ifName . "'");

[TheWitness]

This one needs to be corrected in mactrack_functions.php. You need to add single quotes around ifName.

Code: Select all

03/25/2010 01:26:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT local_graph_id FROM mac_track_interface_graphs WHERE host_id=46 AND ifName=Fa0/28"

Simple fix, but I can't do anything about it at the moment. There are also a few more indexes that are/should be required. More on that later.

TheWitness

Yep, fixed it, replace line 2304 with:

Code: Select all

WHERE host_id=" . $device["host_id"] . " AND ifName='" . $ifName . "'");

So, are the Interface/Device Graph Icons working as expected then?

TheWitness

[toe_cutter]

So, are the Interface/Device Graph Icons working as expected then?

TheWitness

Seems like it, from the Interface tab it directs me to the preview-style non-interface graphs (cpu/mem), but i dont have any graphs of regular access interfaces. Edit: checking ignored interfaces, these direct me to a preview-style graph (trunk/uplink interfaces are graphed).
From the Device tab it directs me to the preview-style graph-page of all graphs for the device.
Edit: going from the mactrack tab to the graphs tab, it doesnt roll back to regular treeview mode. It sticks to preview-style.

The only things not working is the old cisco IP-scan function (get_CTAlias is the only one avail) and ive got 4 devices (same model/IOS as the others) that dont reply to the ifIndex oid. Still trying to debug this.
Edit: increased the SNMP-timeout to 1s, seems odd over a LAN, but im blaming 10yo devices...