Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support
It is currently Mon Apr 21, 2014 5:01 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Error adding SNMP options
PostPosted: Thu Sep 16, 2010 7:59 am 
Offline

Joined: Tue Dec 01, 2009 4:08 pm
Posts: 23
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.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Sep 16, 2010 10:23 am 
Offline

Joined: Fri Apr 16, 2010 11:19 am
Posts: 14
in regards to your second question, the IEEE oui website has been down for the past few days.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Sep 16, 2010 10:33 am 
Offline

Joined: Tue Dec 01, 2009 4:08 pm
Posts: 23
Well, that's one thing down!


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 18, 2010 2:44 pm 
Offline
Developer
User avatar

Joined: Tue May 14, 2002 5:08 pm
Posts: 14861
Location: MI, USA
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
Gandalfs Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 20, 2010 12:18 pm 
Offline

Joined: Tue Dec 01, 2009 4:08 pm
Posts: 23
http://standards.ieee.org/regauth/oui/oui.txt

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


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 21, 2010 8:54 pm 
Offline
Developer
User avatar

Joined: Tue May 14, 2002 5:08 pm
Posts: 14861
Location: MI, USA
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
Gandalfs Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 22, 2010 1:23 pm 
Offline

Joined: Tue Dec 01, 2009 4:08 pm
Posts: 23
Yep, the IEEE db is back up.


Top
 Profile  
 
 Post subject: Re: Error adding SNMP options
PostPosted: Thu Sep 23, 2010 4:13 pm 
Offline

Joined: Fri Feb 10, 2006 2:59 pm
Posts: 44
Location: Orange County, CA
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...


Top
 Profile  
 
 Post subject: Re: Error adding SNMP options
PostPosted: Thu Nov 04, 2010 12:52 pm 
Offline
User avatar

Joined: Sun Apr 09, 2006 4:16 pm
Posts: 40
Location: Spain
ceyounger wrote:
digitlman wrote:
8.7g with mactrack 2.9 fresh install. Followed directions posted: How I installed mactrack v2.0 with cacti 0.8.7e

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,


Top
 Profile  
 
 Post subject: Re: Error adding SNMP options
PostPosted: Wed Dec 08, 2010 3:04 am 
Offline

Joined: Fri Dec 03, 2010 2:05 am
Posts: 1
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"]);


Top
 Profile  
 
 Post subject: Re: Error adding SNMP options
PostPosted: Mon Oct 24, 2011 8:45 am 
Offline
Developer
User avatar

Joined: Tue May 14, 2002 5:08 pm
Posts: 14861
Location: MI, USA
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
Gandalfs Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group