[SOLVED] mactrack - Error: Save Failed

Support questions about the MAC Track plugin

Moderators: Developers, Moderators

Post Reply
jffrybauer
Posts: 1
Joined: Thu Jan 04, 2007 12:25 am

[SOLVED] mactrack - Error: Save Failed

Post by jffrybauer »

Hey...I'm quite a newb with cacti, and am trying to set up mactrack. The Device Tracking section on the console is present, and all the pages seem to display fine. I have granted view and update permissions.

When I try to add a new site, I get the Error: Save Failed when I try to create it.

EDIT//I got this fixed...I didn't know the .sql wasn't imported automatically. Now that that's set, it's starting to look good...//

Here's what I'm running....thanks
Cacti Version - 0.8.6i
Plugin Architecture - 1.0
Poller Type - CMD.php
Server Info - Windows NT 5.2
Web Server - Apache/2.0.59 (Win32) PHP/5.1.6
PHP - 5.1.6
PHP Extensions - bcmath, calendar, com_dotnet, ctype, date, ftp, hash, iconv, odbc, pcre, Reflection, session, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, apache2handler, mysql, snmp, sockets
MySQL - 5.0.27-community-nt
RRDTool - 1.2.15
SNMP - 5.4
Plugins
  • Thresholds (thold - v0.3.0)
    Device Monitoring (monitor - v0.7)
    Host Info (hostinfo - v0.1)
    Network Tools (tools - v0.2)
    Update Checker (update - v0.3)
    Network Discovery (discovery - v0.7)
    PHP Network Weathermap (weathermap - v0.82)
    Device Tracking (mactrack - v0.0.1b)
Top
User avatar
kjmattakat
Posts: 15
Joined: Fri Oct 12, 2007 3:03 pm

mactrack: Error: Save Failed

Post by kjmattakat »

I am having the same issue and wondering if i am missing something else.

I installed mactrack as i would any other plugin and can not add devices or sites - just get "Error: Save Failed" - the cacti log showed errors when trying to access tables in the DB, checked and none of the mactrack tables were there so i used MySQL Administrator to restore the tables into the cacti db from the .sql file. (was this the wrong way to import them?) I do not see any more errors in the cacti.log and was then able to update the IEEE vendor macs, so DB communication appears to be working fine. Still getting getting 'save' error.

The poller also seems to be working - times are updating on the utilities>process tab.

also get this error when using the 'add' link on the venor macs page:
Notice: Undefined index: mactrack_vendormacs.php:edit in D:\websites\cacti\lib\functions.php on line 1455

Running Cacti 8.7 on IIS with mactrack 1.1

Thanks for the help.
Top
User avatar
zgamer
Cacti User
Posts: 86
Joined: Sat Sep 23, 2006 7:50 pm
Location: WI, USA

Post by zgamer »

I had this problem and after some digging around found that the mac_track_devices table is missing two columns being called. The 'notes' and 'device_name' columns are missing from the table causing the error. I altered the table to add both which fixed the error but I'm still unable to create a site. Granted i took a guess at the column specs which might be part of the problem, if anyone has the correct version of the table could you please post it.
Top
User avatar
chrisgapske
Cacti User
Posts: 278
Joined: Tue May 22, 2007 7:56 am
Location: Pensacola, Fl - Padacuh, Ky-Alpena, MI-Gulf Shores,AL

Post by chrisgapske »

I ran into the same problem this morning..

I resolved the problem by manualy running the database_upgrade.php.

It so far has seemed to resolve my problems.
Top
User avatar
zgamer
Cacti User
Posts: 86
Joined: Sat Sep 23, 2006 7:50 pm
Location: WI, USA

Post by zgamer »

Needed to run it twice but fixed the problem.
Top
tomvang
Posts: 8
Joined: Fri Jan 18, 2008 3:44 pm

database_update.php

Post by tomvang »

zgamer wrote:Needed to run it twice but fixed the problem.
what is the command to run this script under windows xp? I have cygwin Bash shell installed and tried the following commands but it didn't :-? work.

./database_upgrade.php
php database_upgrade.php
Top
User avatar
zgamer
Cacti User
Posts: 86
Joined: Sat Sep 23, 2006 7:50 pm
Location: WI, USA

Post by zgamer »

php database_upgrade.php under freebsd.
Top
Gplamondon
Posts: 4
Joined: Fri May 30, 2008 12:13 pm

Post by Gplamondon »

I am also getting the Error: Save Failed. when trying to add a site.
Windows XP
Apache 2.2
Mysql 5
Lataest Cacti 0.8.7b
Spine
Mactrack 1.1

I imported the mactrack.sql and mactrack.sql.0.0.1
I also ran the php database_upgrade.

Code: Select all

Date Fri, 30 May 2008 13:59:58 -0400 
Cacti Version 0.8.7b 
Cacti OS win32 
SNMP Version net-snmp 
RRDTool Version RRDTool 1.2.x  
Hosts 115 
Graphs 714 
Data Sources Script/Command: 12
SNMP: 85
SNMP Query: 583
Script Query - Script Server: 50
Total: 730 
Poller Information 
Interval 300 
Type spine 
Items Action[0]: 1455
Action[1]: 12
Action[2]: 72
Total: 1539 
Concurrent Processes 1 
Max Threads 1 
PHP Servers 1 
Script Timeout 25 
Max OID 10 
Last Run Statistics Time:90.4306 Method:spine Processes:1 Threads:1 Hosts:116 HostsPerProcess:116 DataSources:1539 RRDsProcessed:724 
PHP Information 
PHP Version 5.2.6 
PHP OS WINNT 
PHP uname Windows NT SNOOPY 5.1 build 2600 
PHP SNMP Installed 
max_execution_time 30 
memory_limit 128M 
MySQL Table Information 
Name Rows Engine Collation Check Status 
cdef 7 MyISAM latin1_swedish_ci OK 
cdef_items 19 MyISAM latin1_swedish_ci OK 
colors 104 MyISAM latin1_swedish_ci OK 
data_input 22 MyISAM latin1_swedish_ci OK 
data_input_data 8336 MyISAM latin1_swedish_ci OK 
data_input_fields 95 MyISAM latin1_swedish_ci OK 
data_local 730 MyISAM latin1_swedish_ci OK 
data_template 67 MyISAM latin1_swedish_ci OK 
data_template_data 797 MyISAM latin1_swedish_ci OK 
data_template_data_rra 3313 MyISAM latin1_swedish_ci OK 
data_template_rrd 1681 MyISAM latin1_swedish_ci OK 
graph_local 714 MyISAM latin1_swedish_ci OK 
graph_template_input 120 MyISAM latin1_swedish_ci OK 
graph_template_input_defs 434 MyISAM latin1_swedish_ci OK 
graph_templates 50 MyISAM latin1_swedish_ci OK 
graph_templates_gprint 5 MyISAM latin1_swedish_ci OK 
graph_templates_graph 764 MyISAM latin1_swedish_ci OK 
graph_templates_item 6654 MyISAM latin1_swedish_ci OK 
graph_tree 1 MyISAM latin1_swedish_ci OK 
graph_tree_items 124 MyISAM latin1_swedish_ci OK 
host 115 MyISAM latin1_swedish_ci OK 
host_graph 91 MyISAM latin1_swedish_ci OK 
host_snmp_cache 6530 MyISAM latin1_swedish_ci OK 
host_snmp_query 148 MyISAM latin1_swedish_ci OK 
host_template 9 MyISAM latin1_swedish_ci OK 
host_template_graph 24 MyISAM latin1_swedish_ci OK 
mac_track_approved_macs 0 MyISAM latin1_swedish_ci OK 
mac_track_device_types 42 MyISAM latin1_swedish_ci OK 
mac_track_devices 0 MyISAM latin1_swedish_ci OK 
mac_track_interfaces 0 MyISAM latin1_swedish_ci OK 
mac_track_ip_ranges 0 MyISAM latin1_swedish_ci OK 
mac_track_ips 0 MEMORY latin1_swedish_ci The storage engine for the table doesn't support check 
mac_track_macauth 0 MyISAM latin1_swedish_ci OK 
mac_track_macwatch 0 MyISAM latin1_swedish_ci OK 
mac_track_oui_database 11521 MyISAM latin1_swedish_ci OK 
mac_track_ports 0 MyISAM latin1_swedish_ci OK 
mac_track_processes 0 MyISAM latin1_swedish_ci OK 
mac_track_scan_dates 0 MyISAM latin1_swedish_ci OK 
mac_track_scanning_functions 14 MyISAM latin1_swedish_ci OK 
mac_track_sites 0 MyISAM latin1_swedish_ci OK 
mac_track_temp_ports 0 MEMORY latin1_swedish_ci The storage engine for the table doesn't support check 
mac_track_vlans 0 MyISAM latin1_swedish_ci OK 
plugin_config 0 MyISAM latin1_swedish_ci OK 
plugin_db_changes 0 MyISAM latin1_swedish_ci OK 
plugin_discover_hosts 112 MyISAM latin1_swedish_ci OK 
plugin_discover_template 15 MyISAM latin1_swedish_ci OK 
plugin_hooks 2 MyISAM latin1_swedish_ci OK 
plugin_realms 1 MyISAM latin1_swedish_ci OK 
plugin_update_info 7 MyISAM latin1_swedish_ci OK 
poller 0 MyISAM latin1_swedish_ci OK 
poller_command 0 MyISAM latin1_swedish_ci OK 
poller_item 1539 MyISAM latin1_swedish_ci OK 
poller_output 0 MyISAM latin1_swedish_ci OK 
poller_reindex 144 MyISAM latin1_swedish_ci OK 
poller_time 1 MyISAM latin1_swedish_ci OK 
rra 5 MyISAM latin1_swedish_ci OK 
rra_cf 10 MyISAM latin1_swedish_ci OK 
settings 106 MyISAM latin1_swedish_ci OK 
settings_graphs 33 MyISAM latin1_swedish_ci OK 
settings_tree 2 MyISAM latin1_swedish_ci OK 
snmp_query 8 MyISAM latin1_swedish_ci OK 
snmp_query_graph 19 MyISAM latin1_swedish_ci OK 
snmp_query_graph_rrd 39 MyISAM latin1_swedish_ci OK 
snmp_query_graph_rrd_sv 59 MyISAM latin1_swedish_ci OK 
snmp_query_graph_sv 40 MyISAM latin1_swedish_ci OK 
user_auth 4 MyISAM latin1_swedish_ci OK 
user_auth_perms 2 MyISAM latin1_swedish_ci OK 
user_auth_realm 47 MyISAM latin1_swedish_ci OK 
user_log 71 MyISAM latin1_swedish_ci OK 
version 1 MyISAM latin1_swedish_ci OK 
 
PHP Module Information 
apache2handler
--------------------------------------------------------------------------------

Apache Version  Apache/2.2.8 (Win32) PHP/5.2.6  
Apache API Version  20051115  
Server Administrator  
Hostname:Port  snoopy.mtstrans.com:0  
Max Requests  Per Child: 0 - Keep Alive: on - Max Per Connection: 100  
Timeouts  Connection: 300 - Keep-Alive: 5  
Virtual Server  No  
Server Root  C:/Apache  
Loaded Modules  core mod_win32 mpm_winnt http_core mod_so mod_actions mod_alias mod_asis mod_auth_basic mod_authn_default mod_authn_file mod_authz_default mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dir mod_env mod_include mod_isapi mod_log_config mod_mime mod_negotiation mod_setenvif mod_php5  

Directive Local Value Master Value 
engine 1 1 
last_modified 0 0 
xbithack 0 0 


Apache Environment
Variable Value 
HTTP_ACCEPT  image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*  
HTTP_REFERER  http://snoopy/cacti/utilities.php  
HTTP_ACCEPT_LANGUAGE  en-us  
HTTP_UA_CPU  x86  
HTTP_ACCEPT_ENCODING  gzip, deflate  
HTTP_USER_AGENT  Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; InfoPath.2)  
HTTP_HOST  snoopy  
HTTP_CONNECTION  Keep-Alive  
HTTP_COOKIE  clickedFoldert2=1%5E100%5E101%5E; highlightedTreeviewLinkt2=101; Cacti=dq6t7tksi0dq56sh7k80gec380  
PATH  C:\Perl\site\bin;C:\Perl\bin;C:\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Intel\DMIX;C:\MySQL\bin;C:\Net-SNMP\bin;c:\cygwin\bin  
SystemRoot  C:\WINDOWS  
COMSPEC  C:\WINDOWS\system32\cmd.exe  
PATHEXT  .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH  
WINDIR  C:\WINDOWS  
SERVER_SIGNATURE  no value  
SERVER_SOFTWARE  Apache/2.2.8 (Win32) PHP/5.2.6  
SERVER_NAME  snoopy  
SERVER_ADDR  192.168.10.3  
SERVER_PORT  80  
REMOTE_ADDR  192.168.10.140  
DOCUMENT_ROOT  C:/Apache/htdocs  
SERVER_ADMIN  
SCRIPT_FILENAME  C:/Apache/htdocs/cacti/utilities.php  
REMOTE_PORT  2749  
GATEWAY_INTERFACE  CGI/1.1  
SERVER_PROTOCOL  HTTP/1.1  
REQUEST_METHOD  GET  
QUERY_STRING  action=view_tech  
REQUEST_URI  /cacti/utilities.php?action=view_tech  
SCRIPT_NAME  /cacti/utilities.php  


HTTP Headers Information
HTTP Request Headers 
HTTP Request  GET /cacti/utilities.php?action=view_tech HTTP/1.1  
Accept  image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*  
Referer  http://snoopy/cacti/utilities.php  
Accept-Language  en-us  
UA-CPU  x86  
Accept-Encoding  gzip, deflate  
User-Agent  Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; InfoPath.2)  
Host  snoopy  
Connection  Keep-Alive  
Cookie  clickedFoldert2=1%5E100%5E101%5E; highlightedTreeviewLinkt2=101; Cacti=dq6t7tksi0dq56sh7k80gec380  
HTTP Response Headers 
X-Powered-By  PHP/5.2.6  
Expires  Thu, 19 Nov 1981 08:52:00 GMT  
Last-Modified  Fri, 30 May 2008 17:59:57 GMT  
Cache-Control  no-store, no-cache, must-revalidate, post-check=0, pre-check=0  
Pragma  no-cache  


bcmath
--------------------------------------------------------------------------------

BCMath support  enabled  


calendar
--------------------------------------------------------------------------------

Calendar support  enabled  


com_dotnet
--------------------------------------------------------------------------------

COM support enabled 
DCOM support disabled 
.Net support enabled 

Directive Local Value Master Value 
com.allow_dcom 0 0 
com.autoregister_casesensitive 1 1 
com.autoregister_typelib 0 0 
com.autoregister_verbose 0 0 
com.code_page no value no value 
com.typelib_file no value no value 


ctype
--------------------------------------------------------------------------------

ctype functions  enabled  


date
--------------------------------------------------------------------------------

date/time support  enabled  
"Olson" Timezone Database Version  2008.2  
Timezone Database  internal  
Default timezone  America/New_York  

Directive Local Value Master Value 
date.default_latitude 31.7667 31.7667 
date.default_longitude 35.2333 35.2333 
date.sunrise_zenith 90.583333 90.583333 
date.sunset_zenith 90.583333 90.583333 
date.timezone no value no value 


dom
--------------------------------------------------------------------------------

DOM/XML  enabled  
DOM/XML API Version  20031129  
libxml Version  2.6.32  
HTML Support  enabled  
XPath Support  enabled  
XPointer Support  enabled  
Schema Support  enabled  
RelaxNG Support  enabled  


filter
--------------------------------------------------------------------------------

Input Validation and Filtering  enabled  
Revision  $Revision: 1.52.2.42 $  

Directive Local Value Master Value 
filter.default unsafe_raw unsafe_raw 
filter.default_flags no value no value 


ftp
--------------------------------------------------------------------------------

FTP support  enabled  


hash
--------------------------------------------------------------------------------

hash support  enabled  
Hashing Engines  md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5  


iconv
--------------------------------------------------------------------------------

iconv support  enabled  
iconv implementation  "libiconv"  
iconv library version  1.11  

Directive Local Value Master Value 
iconv.input_encoding ISO-8859-1 ISO-8859-1 
iconv.internal_encoding ISO-8859-1 ISO-8859-1 
iconv.output_encoding ISO-8859-1 ISO-8859-1 


json
--------------------------------------------------------------------------------

json support  enabled  
json version  1.2.1  


libxml
--------------------------------------------------------------------------------

libXML support  active  
libXML Version  2.6.32  
libXML streams  enabled  


mysql
--------------------------------------------------------------------------------

MySQL Support enabled 
Active Persistent Links  1  
Active Links  1  
Client API version  5.0.51a  

Directive Local Value Master Value 
mysql.allow_persistent On On 
mysql.connect_timeout 60 60 
mysql.default_host no value no value 
mysql.default_password no value no value 
mysql.default_port no value no value 
mysql.default_socket no value no value 
mysql.default_user no value no value 
mysql.max_links Unlimited Unlimited 
mysql.max_persistent Unlimited Unlimited 
mysql.trace_mode Off Off 


odbc
--------------------------------------------------------------------------------

ODBC Support enabled 
Active Persistent Links  0  
Active Links  0  
ODBC library  Win32  

Directive Local Value Master Value 
odbc.allow_persistent On On 
odbc.check_persistent On On 
odbc.default_db no value no value 
odbc.default_pw no value no value 
odbc.default_user no value no value 
odbc.defaultbinmode return as is return as is 
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes 
odbc.max_links Unlimited Unlimited 
odbc.max_persistent Unlimited Unlimited 


pcre
--------------------------------------------------------------------------------

PCRE (Perl Compatible Regular Expressions) Support  enabled  
PCRE Library Version  7.6 2008-01-28  

Directive Local Value Master Value 
pcre.backtrack_limit 100000 100000 
pcre.recursion_limit 100000 100000 


Reflection
--------------------------------------------------------------------------------

Reflection enabled 
Version  $Id: php_reflection.c,v 1.164.2.33.2.50 2008/03/13 15:56:21 iliaa Exp $  


session
--------------------------------------------------------------------------------

Session Support  enabled  
Registered save handlers  files user  
Registered serializer handlers  php php_binary wddx  

Directive Local Value Master Value 
session.auto_start Off Off 
session.bug_compat_42 Off Off 
session.bug_compat_warn On On 
session.cache_expire 180 180 
session.cache_limiter nocache nocache 
session.cookie_domain no value no value 
session.cookie_httponly Off Off 
session.cookie_lifetime 0 0 
session.cookie_path / / 
session.cookie_secure Off Off 
session.entropy_file no value no value 
session.entropy_length 0 0 
session.gc_divisor 1000 1000 
session.gc_maxlifetime 1440 1440 
session.gc_probability 1 1 
session.hash_bits_per_character 5 5 
session.hash_function 0 0 
session.name Cacti PHPSESSID 
session.referer_check no value no value 
session.save_handler files files 
session.save_path C:\WINDOWS\Temp C:\WINDOWS\Temp 
session.serialize_handler php php 
session.use_cookies On On 
session.use_only_cookies Off Off 
session.use_trans_sid 0 0 


SimpleXML
--------------------------------------------------------------------------------

Simplexml support enabled 
Revision  $Revision: 1.151.2.22.2.39 $  
Schema support  enabled  


snmp
--------------------------------------------------------------------------------

UCD-SNMP Support  enabled  
UCD-SNMP Version  ucd-snmp-4.2.3  


sockets
--------------------------------------------------------------------------------

Sockets Support  enabled  


SPL
--------------------------------------------------------------------------------

SPL support enabled 
Interfaces  Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject  
Classes  AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException  


standard
--------------------------------------------------------------------------------

Regex Library  Bundled library enabled  
Dynamic Library Support  enabled  
Internal Sendmail Support for Windows  enabled  

Directive Local Value Master Value 
assert.active 1 1 
assert.bail 0 0 
assert.callback no value no value 
assert.quiet_eval 0 0 
assert.warning 1 1 
auto_detect_line_endings 0 0 
default_socket_timeout 60 60 
safe_mode_allowed_env_vars PHP_ PHP_ 
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH 
url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry 
user_agent no value no value 


tokenizer
--------------------------------------------------------------------------------

Tokenizer Support  enabled  


wddx
--------------------------------------------------------------------------------

WDDX Support enabled 
WDDX Session Serializer  enabled  


xml
--------------------------------------------------------------------------------

XML Support  active  
XML Namespace Support  active  
libxml2 Version  2.6.32  


xmlreader
--------------------------------------------------------------------------------

XMLReader  enabled  


xmlwriter
--------------------------------------------------------------------------------

XMLWriter  enabled  


zlib
--------------------------------------------------------------------------------

ZLib Support  enabled  
Stream Wrapper support  compress.zlib://  
Stream Filter support  zlib.inflate, zlib.deflate  
Compiled Version  1.2.3  
Linked Version  1.2.3  

Directive Local Value Master Value 
zlib.output_compression Off Off 
zlib.output_compression_level -1 -1 
zlib.output_handler no value no value



Any help would be greatly appreciated.

Thanks.
Top
Gplamondon
Posts: 4
Joined: Fri May 30, 2008 12:13 pm

Post by Gplamondon »

Update:
I manually entered a site into the mactrack_sites table to test.
I added an Cisco 3560 the normal way through the GUI.

I am getting these errors in the Cacti log:

Code: Select all

05/30/2008 03:24:59 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1364', SQL:"INSERT INTO mac_track_interfaces (site_id, device_id, ifIndex, ifType, ifName, ifAlias, linkPort, vlan_id, vlan_name, vlan_trunk, ifSpeed, ifDescr, ifMtu, ifPhysAddress, ifAdminStatus, ifOperStatus, ifLastChange, ifInDiscards, ifInErrors, ifInUnknownProtos, ifOutDiscards, ifOutErrors, int_discards_present, int_errors_present, last_down_time, last_up_time, stateChanges, present) VALUES ('1', '3', '1', '53', 'Vl1', '', '1', '', '', '', '1000000000', 'Vlan1', '1500', '00:16:9D:01:0F:C0', '1', '1', '5239', '0', '0', '48', '0', '0', '', '', '0', '2008-05-30 15:24:57', '0', '1'),('1', '3', '10001', '6', 'Fa0/1', '', '', '', '', '', '100000000', 'FastEthernet0/1', '1500', '00:16:9D:01:0F:83', '1', '2', '1763622311', '0', '5', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10002', '6', 'Fa0/2', 'Shop-N AP', '', '', '', '', '100000000', 'FastEthernet0/2', '1500', '00:16:9D:01:0F:84', '1', '1', '2891387710', '0', '26', '0', '0', '0', '', '', '0', '2008-05-30 15:24:57', '0', '1'),('1', '3', '10003', '6', 'Fa0/3', '', '', '', '', '', '100000000', 'FastEthernet0/3', '1500', '00:16:9D:01:0F:85', '1', '2', '1779192905', '0', '10', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10004', '6', 'Fa0/4', '', '', '', '', '', '100000000', 'FastEthernet0/4', '1500', '00:16:9D:01:0F:86', '1', '2', '1762505943', '0', '3', '636', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10005', '6', 'Fa0/5', '', '', '', '', '', '100000000', 'FastEthernet0/5', '1500', '00:16:9D:01:0F:87', '1', '2', '716731718', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10006', '6', 'Fa0/6', '', '', '', '', '', '100000000', 'FastEthernet0/6', '1500', '00:16:9D:01:0F:88', '1', '2', '1762396753', '0', '11', '47244', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10007', '6', 'Fa0/7', '', '', '', '', '', '100000000', 'FastEthernet0/7', '1500', '00:16:9D:01:0F:89', '1', '2', '4863', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10008', '6', 'Fa0/8', '', '', '', '', '', '100000000', 'FastEthernet0/8', '1500', '00:16:9D:01:0F:8A', '1', '2', '1762398091', '0', '1', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10009', '6', 'Fa0/9', '', '', '', '', '', '100000000', 'FastEthernet0/9', '1500', '00:16:9D:01:0F:8B', '1', '2', '1763518764', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10010', '6', 'Fa0/10', '', '', '', '', '', '100000000', 'FastEthernet0/10', '1500', '00:16:9D:01:0F:8C', '1', '2', '1762479486', '0', '1', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10011', '6', 'Fa0/11', '', '', '', '', '', '100000000', 'FastEthernet0/11', '1500', '00:16:9D:01:0F:8D', '1', '2', '4864', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10012', '6', 'Fa0/12', '', '', '', '', '', '100000000', 'FastEthernet0/12', '1500', '00:16:9D:01:0F:8E', '1', '2', '629713128', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10013', '6', 'Fa0/13', '', '', '', '', '', '100000000', 'FastEthernet0/13', '1500', '00:16:9D:01:0F:8F', '1', '2', '2084218169', '0', '16', '192469', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10014', '6', 'Fa0/14', '', '', '', '', '', '100000000', 'FastEthernet0/14', '1500', '00:16:9D:01:0F:90', '1', '2', '3180030704', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10015', '6', 'Fa0/15', '', '', '', '', '', '100000000', 'FastEthernet0/15', '1500', '00:16:9D:01:0F:91', '1', '2', '4864', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10016', '6', 'Fa0/16', '', '', '', '', '', '100000000', 'FastEthernet0/16', '1500', '00:16:9D:01:0F:92', '1', '2', '4865', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10017', '6', 'Fa0/17', '', '', '', '', '', '100000000', 'FastEthernet0/17', '1500', '00:16:9D:01:0F:93', '1', '2', '4865', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10018', '6', 'Fa0/18', '', '', '', '', '', '100000000', 'FastEthernet0/18', '1500', '00:16:9D:01:0F:94', '1', '2', '2057502579', '0', '0', '3', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10019', '6', 'Fa0/19', '', '', '', '', '', '100000000', 'FastEthernet0/19', '1500', '00:16:9D:01:0F:95', '1', '2', '4865', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:57', '0', '0', '1'),('1', '3', '10020', '6', 'Fa0/20', '', '', '', '', '', '100000000', 'FastEthernet0/20', '1500', '00:16:9D:01:0F:96', '1', '2', '760576176', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:58', '0', '0', '1'),('1', '3', '10021', '6', 'Fa0/21', '', '', '', '', '', '100000000', 'FastEthernet0/21', '1500', '00:16:9D:01:0F:97', '1', '2', '4865', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:58', '0', '0', '1'),('1', '3', '10022', '6', 'Fa0/22', '', '', '', '', '', '100000000', 'FastEthernet0/22', '1500', '00:16:9D:01:0F:98', '1', '2', '580574513', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:58', '0', '0', '1'),('1', '3', '10023', '6', 'Fa0/23', '', '', '', '', '', '100000000', 'FastEthernet0/23', '1500', '00:16:9D:01:0F:99', '1', '2', '4866', '0', '0', '0', '0', '0', '', '', '2008-05-30 15:24:58', '0', '0', '1'),('1', '3', '10024', '6', 'Fa0/24', '', '', '', '', '', '100000000', 'FastEthernet0/24', '1500', '00:16:9D:01:0F:9A', '1', '1', '1779249481', '0', '0', '0', '0', '0', '', '', '0', '2008-05-30 15:24:58', '0', '1'),('1', '3', '10101', '6', 'Gi0/1', 'to G02 - GR-3524-B', '', '', '', '', '1000000000', 'GigabitEthernet0/1', '1500', '00:16:9D:01:0F:81', '1', '1', '1098767689', '0', '0', '0', '0', '0', '', '', '0', '2008-05-30 15:24:58', '0', '1'),('1', '3', '10102', '6', 'Gi0/2', '', '', '', '', '', '1000000000', 'GigabitEthernet0/2', '1500', '00:16:9D:01:0F:82', '1', '1', '1745599459', '0', '0', '0', '0', '0', '', '', '0', '2008-05-30 15:24:58', '0', '1'),('1', '3', '14501', '1', 'Nu0', '', '', '', '', '', '4294967295', 'Null0', '1500', 'NOT USER', '1', '1', '0', '0', '0', '0', '0', '0', '', '', '0', '2008-05-30 15:24:58', '0', '1') ON DUPLICATE KEY UPDATE ifType=VALUES(ifType), ifName=VALUES(ifName), ifAlias=VALUES(ifAlias), linkPort=VALUES(linkPort), vlan_id=VALUES(vlan_id), vlan_name=VALUES(vlan_name), vlan_trunk=VALUES(vlan_trunk), ifSpeed=VALUES(ifSpeed), ifDescr=VALUES(ifDescr), ifMtu=VALUES(ifMtu), ifPhysAddress=VALUES(ifPhysAddress), ifAdminStatus=VALUES(ifAdminStatus), ifOperStatus=VALUES(ifOperStatus), ifLastChange=VALUES(ifLastChange), ifInDiscards=VALUES(ifInDiscards), ifInErrors=VALUES(ifInErrors), ifInUnknownProtos=VALUES(ifInUnknownProtos), ifOutDiscards=VALUES(ifOutDiscards), ifOutErrors=VALUES(ifOutErrors), int_discards_present=VALUES(int_discards_present), int_errors_present=VALUES(int_errors_present), last_down_time=VALUES(last_down_time), last_up_time=VALUES(last_up_time), stateChanges=VALUES(stateChanges), present='1''
Top
User avatar
TheWitness
Developer
Posts: 17061
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by TheWitness »

You did not perform the database upgrade as those tables now don't exist. This is why you are getting this error.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
ltdanmp
Posts: 2
Joined: Tue Jul 01, 2008 1:52 pm

database upgrade

Post by ltdanmp »

I did the import and the database upgrade but I still cannot add new devices. What other option or suggestions do you have? Thanks, Dan
Top
User avatar
streaker69
Cacti Pro User
Posts: 712
Joined: Mon Mar 27, 2006 10:35 am
Location: Psychic Amish Network Administrator

Re: database upgrade

Post by streaker69 »

ltdanmp wrote:I did the import and the database upgrade but I still cannot add new devices. What other option or suggestions do you have? Thanks, Dan
Are you using FireFox 3.0 or one of the 3.0 beta's?
[b]Cacti Version[/b] - 0.8.7d
[b]Plugin Architecture[/b] - 2.4
[b]Poller Type[/b] - Cactid v
[b]Server Info[/b] - Linux 2.6.18-128.1.6.el5
[b]Web Server[/b] - Apache/2.2.3 (CentOS)
[b]PHP[/b] - 5.2.9
[b]MySQL[/b] - 5.0.45-log
[b]RRDTool[/b] - 1.3.0
[b]SNMP[/b] - 5.3.2.2
[b]Plugins[/b]PHP Network Managing v0.6.1, Global Plugin Settings v0.6,thold v0.4.1,XMLPort v0.3.5,CactiCam v0.1.5,NetTools v0.1.5,pollperf v0.32,RRD Cleaner v1.1,sqlqueries v0.2,superlinks v0.8,syslog v0.5.2,update v0.4,discovery v0.9,zond v0.34a,hostinfo v0.2,Bloom v0.6.5,mactrack v1.1,weathermap v0.96a,mobile v0.1
Top
ltdanmp
Posts: 2
Joined: Tue Jul 01, 2008 1:52 pm

Post by ltdanmp »

I am using firefox 2.0.0.14. thanks, Dan
Top
User avatar
Howie
Cacti Guru User
Posts: 5508
Joined: Thu Sep 16, 2004 5:53 am
Location: United Kingdom
Contact:
Contact Howie

Post by Howie »

Hmm. No (readable) docs, imported both SQL files, using IE, and still can't save a site or device.

The only error in the log is:

Code: Select all

09/02/2008 10:27:56 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"delete from mac_track_processes where start_date < '2008-09-02 10:07:56''
The table exists but is empty, so the query should work OK. I noticed that the line ends with two ', but starts with " (one double quotes character). Is that Cacti's log printing, or the actual SQL? it's not clear.

Also - with no database tables, the OUI update thingy doesn't report any error at all.
Cacti Version - 0.8.7b
Plugin Architecture - 2.0
Poller Type - Cactid
PHP - 5.2.6
MySQL - 5.0.51a
RRDTool - 1.2.26
SNMP - 5.4.1
Plugins
  • SSL Redirector (ssl - v0.1)
    Global Plugin Settings (settings - v0.5)
    Thresholds (thold - v0.3.9hj)
    PHP Network Weathermap (weathermap - v0.96test1)
    Update Checker (update - v0.4)
    Host Info (hostinfo - v0.2)
    ReportIt (ReportIt - v0.5.1)
    Create Aggregate Graphs (aggregate - v0.63)
    SuperLinks (superlinks - v0.72)
    Uptime (uptime - v0.3hj)
    SNMPTT viewer for cacti (snmptt - v0.0.16b)
    Device Tracking (mactrack - v1.1)
Weathermap 0.98a is out! & QuickTree 1.0. Superlinks is over there now (and built-in to Cacti 1.x).
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)
Top
User avatar
obeygiant
Posts: 2
Joined: Thu Mar 26, 2009 6:01 pm

re: save failed

Post by obeygiant »

I'm also getting this error on a new Cacti-EZ install. Anyone have any ideas on how to fix this on cent-os?
Top
Post Reply

Return to “Plugin: (MAC Track)”

Who is online

Users browsing this forum: No registered users and 3 guests