Error adding SNMP options

Support questions about the MAC Track plugin

Moderators: Moderators, Developers

Post Reply
Author
Message
digitlman
Posts: 23
Joined: Tue Dec 01, 2009 4:08 pm

Error adding SNMP options

#1 Post by digitlman » Thu Sep 16, 2010 7:59 am

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
Posts: 14
Joined: Fri Apr 16, 2010 11:19 am
Contact:

#2 Post by shadowmanr6 » Thu Sep 16, 2010 10:23 am

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

digitlman
Posts: 23
Joined: Tue Dec 01, 2009 4:08 pm

#3 Post by digitlman » Thu Sep 16, 2010 10:33 am

Well, that's one thing down!

User avatar
TheWitness
Developer
Posts: 14804
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

#4 Post by TheWitness » Sat Sep 18, 2010 2:44 pm

shadowmanr6 wrote: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
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

digitlman
Posts: 23
Joined: Tue Dec 01, 2009 4:08 pm

#5 Post by digitlman » Mon Sep 20, 2010 12:18 pm

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

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

User avatar
TheWitness
Developer
Posts: 14804
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

#6 Post by TheWitness » Tue Sep 21, 2010 8:54 pm

Seems to be working...
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

digitlman
Posts: 23
Joined: Tue Dec 01, 2009 4:08 pm

#7 Post by digitlman » Wed Sep 22, 2010 1:23 pm

Yep, the IEEE db is back up.

ceyounger
Posts: 44
Joined: Fri Feb 10, 2006 2:59 pm
Location: Orange County, CA
Contact:

Re: Error adding SNMP options

#8 Post by ceyounger » Thu Sep 23, 2010 4:13 pm

digitlman wrote: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...

User avatar
chercen
Posts: 41
Joined: Sun Apr 09, 2006 4:16 pm
Location: Spain

Re: Error adding SNMP options

#9 Post by chercen » Thu Nov 04, 2010 12:52 pm

ceyounger wrote:
digitlman wrote: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
Posts: 1
Joined: Fri Dec 03, 2010 2:05 am

Re: Error adding SNMP options

#10 Post by zhoughan » Wed Dec 08, 2010 3:04 am

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"]);

User avatar
TheWitness
Developer
Posts: 14804
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Error adding SNMP options

#11 Post by TheWitness » Mon Oct 24, 2011 8:45 am

This is fixed in SVN now.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

dpsguard
Posts: 29
Joined: Tue Apr 05, 2016 10:22 pm

Re: Error adding SNMP options

#12 Post by dpsguard » Tue Jul 05, 2016 10:01 am

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.

Post Reply