|
|
| Author |
Message |
tbaror
Joined: 05 Jun 2006
Posts: 49
|
 Posted: Wed Jan 02, 2008 3:50 am Post subject: cant add either device or site |
 |
|
Hello,
i have added recently Mactrack plug-in, when am trying to add either device or site i get error "Error Save:Failed".
when look in cacti log i can identified sql error as follows below.
please advise
Thanks
| Code: |
01/02/2008 10:47:10 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT COUNT(mac_track_devices.device_id) FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id WHERE ((mac_track_devices.hostname like '%%%%' OR mac_track_devices.device_name like '%%%%' OR mac_track_devices.notes like '%%%%'))"
01/02/2008 10:47:10 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.device_name, mac_track_devices.notes, mac_track_devices.hostname, mac_track_devices.snmp_readstring, mac_track_devices.snmp_readstrings, mac_track_devices.snmp_version, mac_track_devices.snmp_port, mac_track_devices.snmp_timeout, mac_track_devices.snmp_retries, mac_track_devices.snmp_status, mac_track_devices.ignorePorts, mac_track_devices.disabled, mac_track_devices.scan_type, mac_track_devices.ips_total, mac_track_devices.ports_total, mac_track_devices.ports_active, mac_track_devices.ports_trunk, mac_track_devices.macs_active, mac_track_devices.last_rundate, mac_track_devices.last_runmessage, mac_track_devices.last_runduration FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id WHERE ((mac_track_devices.hostname like '%%%%' OR mac_track_devices.device_name like '%%%%' OR mac_track_devices.notes like '%%%%')) ORDER BY site_name ASC LIMIT 0,30"
|
| Quote: | Cacti Version - 0.8.7a
Plugin Architecture - 1.4
Poller Type - CMD.php
Server Info - Windows NT 5.2
Web Server - Microsoft-IIS/6.0
PHP - 5.2.4
PHP Extensions - bcmath, calendar, com_dotnet, ctype, session, filter, ftp, hash, iconv, json, odbc, pcre, Reflection, date, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, ISAPI, soap, gd, mysql, snmp, sockets, xmlrpc
MySQL - 5.0.45-community-nt
RRDTool - 1.2.15
SNMP - snmpwalk [OPTIONS] AGENT [OID]
Version: 5.4.1
Web: http://www.net-snmp.org/
Email: net-snmp-coders@lists.sourceforge.net
OPTIONS:
-h, --help display this help message
-H display configuration file directives understood
-v 1|2c|3 specifies SNMP version to use
-V, --version display package version number
SNMP Version 1 or 2c specific
-c COMMUNITY set the community string
SNMP Version 3 specific
-a PROTOCOL set authentication protocol (MD5|SHA)
-A PASSPHRASE set authentication protocol pass phrase
-e ENGINE-ID set security engine ID (e.g. 800000020109840301)
-E ENGINE-ID set context engine ID (e.g. 800000020109840301)
-l LEVEL set security level (noAuthNoPriv|authNoPriv|authPriv)
-n CONTEXT set context name (e.g. bridge1)
-u USER-NAME set security name (e.g. bert)
-x PROTOCOL set privacy protocol (DES)
-X PASSPHRASE set privacy protocol pass phrase
-Z BOOTS,TIME set destination engine boots/time
General communication options
-r RETRIES set the number of retries
-t TIMEOUT set the request timeout (in seconds)
Debugging
-d dump input/output packets in hexadecimal
-D TOKEN[,...] turn on debugging output for the specified TOKENs
(ALL gives extremely verbose debugging output)
General options
-m MIB[:...] load given list of MIBs (ALL loads everything)
-M DIR[:...] look in given list of directories for MIBs
-P MIBOPTS Toggle various defaults controlling MIB parsing:
u: allow the use of underlines in MIB symbols
c: disallow the use of "--" to terminate comments
d: save the DESCRIPTIONs of the MIB objects
e: disable errors when MIB symbols conflict
w: enable warnings when MIB symbols conflict
W: enable detailed warnings when MIB symbols conflict
R: replace MIB symbols from latest module
-O OUTOPTS Toggle various defaults controlling output display:
0: print leading 0 for single-digit hex characters
a: print all strings in ascii format
b: do not break OID indexes down
e: print enums numerically
E: escape quotes in string indices
f: print full OIDs on output
n: print OIDs numerically
q: quick print for easier parsing
Q: quick print with equal-signs
s: print only last symbolic element of OID
S: print MIB module-id plus last element
t: print timeticks unparsed as numeric integers
T: print human-readable text along with hex strings
u: print OIDs using UCD-style prefix suppression
U: don't print units
v: print values only (not OID = value)
x: print all strings in hex format
X: extended index format
-I INOPTS Toggle various defaults controlling input parsing:
b: do best/regex matching to find a MIB node
h: don't apply DISPLAY-HINTs
r: do not check values for range/type legality
R: do random access to OID labels
u: top-level OIDs must have '.' prefix (UCD-style)
s SUFFIX: Append all textual OIDs with SUFFIX before parsing
S PREFIX: Prepend all textual OIDs with PREFIX before parsing
-L LOGOPTS Toggle various defaults controlling logging:
e: log to standard error
o: log to standard output
n: don't log at all
f file: log to the specified file
s facility: log to syslog (via the specified facility)
(variants)
[EON] pri: log to standard error, output or /dev/null for level 'pri' and above
[EON] p1-p2: log to standard error, output or /dev/null for levels 'p1' to 'p2'
[FS] pri token: log to file/syslog for level 'pri' and above
[FS] p1-p2 token: log to file/syslog for levels 'p1' to 'p2'
-C APPOPTS Set various application specific behaviours:
p: print the number of variables found
i: include given OID in the search range
I: don't include the given OID, even if no results are returned
c: do not check returned OIDs are increasing
t: Display wall-clock time to complete the request
PluginsGlobal Plugin Settings (settings - v0.3)
Update Checker (update - v0.4)
Thresholds (thold - v0.3.
Network Discovery (discovery - v0.8.3)
PHP Network Weathermap (weathermap - v0.941)
ReportIt (ReportIt - v0.5.1)
Real-time statistics (zond - v0.32)
Device Tracking (mactrack - v1.1)
Host Info (hostinfo - v0.2) |
[/quote]
|
|
| Back to top |
|
 |
streaker69
Cacti Pro User
Joined: 27 Mar 2006
Posts: 647
Location: Psychic Amish Network Administrator
|
| Posted: Wed Jan 02, 2008 8:44 am Post subject: |
|
|
| Did you import the MacTrack SQL file that needs to be imported?
|
|
| Back to top |
|
|
tbaror
Joined: 05 Jun 2006
Posts: 49
|
| Posted: Wed Jan 02, 2008 9:16 am Post subject: |
|
|
Hi,
yes i did
| Description: |
|
| Filesize: |
4.28 KB |
| Viewed: |
1560 Time(s) |
|
|
|
| Back to top |
|
|
ptaylor874
Joined: 04 Jan 2008
Posts: 22
|
| Posted: Tue Jan 22, 2008 3:42 pm Post subject: |
|
|
I'm having exactly the same problem. Whenever I attempt to add a site, it gives me a "Save Failed" message.
I'm running version 0.8.7a. (Original install was CactiEZ 0.3.)
Paul
|
|
| Back to top |
|
|
ptaylor874
Joined: 04 Jan 2008
Posts: 22
|
| Posted: Tue Jan 22, 2008 3:46 pm Post subject: |
|
|
| Doh! Just found the other (more recent!) post about this problem.. Nevermind! database upgrade fixed it.
|
|
| Back to top |
|
|
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
