Error adding SNMP options

[digitlman]

8.7g with mactrack 2.9 fresh install. Followed directions posted: http://forums.cacti.net/viewtopic.php?t=34718

Adding SNMP options I get this error:

09/16/2010 08:57:08 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
09/16/2010 08:57:08 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="
09/16/2010 08:57:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
09/16/2010 08:57:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="

Deleted all devices and tried again with the same result.

Also getting:
MacTrack OUI Database Import Results

Getting OUI Database from IEEE
OUI Database Download from IEEE Complete

There were '0' Entries Added/Updated in the database.
There were '0' Records Removed from the database.

When trying to update IEEE DB.

[shadowmanr6]

in regards to your second question, the IEEE oui website has been down for the past few days.

[digitlman]

Well, that's one thing down!

[TheWitness]

in regards to your second question, the IEEE oui website has been down for the past few days.

Really. Hmm. I guess that's a problem. If you find out if the url changed, post that information here.

Not sure about that SNMP error. Contact Gandalf. He did that integration. Likely you have used a settings to provide a 'strong' integration between Cacti and MacTrack, and have identified a 'bug' in how it behaves.

TheWitness

[digitlman]

http://standards.ieee.org/regauth/oui/oui.txt

That appears to be the "database" as it were.

[TheWitness]

Seems to be working...

[digitlman]

Yep, the IEEE db is back up.

[ceyounger]

8.7g with mactrack 2.9 fresh install. Followed directions posted: http://forums.cacti.net/viewtopic.php?t=34718

Adding SNMP options I get this error:

09/16/2010 08:57:08 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
09/16/2010 08:57:08 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="
09/16/2010 08:57:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
09/16/2010 08:57:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="

Deleted all devices and tried again with the same result.

Also getting:
MacTrack OUI Database Import Results

Getting OUI Database from IEEE
OUI Database Download from IEEE Complete

There were '0' Entries Added/Updated in the database.
There were '0' Records Removed from the database.

When trying to update IEEE DB.

I don't have the SQL errors in my logfile, but I am getting the "Error: Save Failed: Field Input Error (Check Red Fields) when I try to save SNMP options. Also, no fields are shown in red...

[chercen]

8.7g with mactrack 2.9 fresh install. Followed directions posted: http://forums.cacti.net/viewtopic.php?t=34718

Adding SNMP options I get this error:

09/16/2010 08:57:08 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
09/16/2010 08:57:08 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="
09/16/2010 08:57:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
09/16/2010 08:57:05 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="

Deleted all devices and tried again with the same result.

Also getting:
MacTrack OUI Database Import Results

Getting OUI Database from IEEE
OUI Database Download from IEEE Complete

There were '0' Entries Added/Updated in the database.
There were '0' Records Removed from the database.

When trying to update IEEE DB.

I don't have the SQL errors in my logfile, but I am getting the "Error: Save Failed: Field Input Error (Check Red Fields) when I try to save SNMP options. Also, no fields are shown in red...

Same error here... logfile says this:

11/04/2010 06:50:06 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
11/04/2010 06:50:06 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="

Regards,

[zhoughan]

I have know how to fix it.
just modify the file mactrack_snmp.php

find following lines

html_start_box("<strong>Mactrack SNMP Options</strong>", "100%", $colors["header"], "3",
"center", htmlspecialchars("mactrack_snmp.php?action=item_edit&id=" . $_GET["id"]));
print "<tr bgcolor='#" . $colors["header_panel"] . "'>";
DrawMatrixHeaderItem("Item",$colors["header_text"],1);
DrawMatrixHeaderItem("Version",$colors["header_text"],1);
DrawMatrixHeaderItem("Community",$colors["header_text"],1);
DrawMatrixHeaderItem("Port",$colors["header_text"],1);
DrawMatrixHeaderItem("Timeout",$colors["header_text"],1);
DrawMatrixHeaderItem("Retries",$colors["header_text"],1);
DrawMatrixHeaderItem("Max OIDs",$colors["header_text"],1);
DrawMatrixHeaderItem("Username",$colors["header_text"],1);
DrawMatrixHeaderItem("Password",$colors["header_text"],1);
DrawMatrixHeaderItem("Auth Proto",$colors["header_text"],1);

modify htmlspecialchars("mactrack_snmp.php?action=item_edit&id=" . $_GET["id"]));
to
"mactrack_snmp.php?action=item_edit&id=" . $_GET["id"]);

[TheWitness]

This is fixed in SVN now.

[dpsguard]

Hi,

Since included version 3 of MacTracker in CactiEZ was not working, I did some research and someone here advised to use latest version 2.9. I downloaded and installed it and it brought back mactracker tab. However, I still had the Red error message when trying to add a SNMP set. So as @zhoughan mentioned, I needed to update the snmp php file in the mactracker directory and that resolved it.

Thanks so much zhoughan and developers.