|
|
| Author |
Message |
jffrybauer
Joined: 04 Jan 2007
Posts: 1
|
 Posted: Thu Jan 04, 2007 12:31 am Post subject: mactrack - Error: Save Failed |
 |
|
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
| Quote: | 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
PluginsThresholds (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) |
|
|
| Back to top |
|
 |
kjmattakat
Joined: 12 Oct 2007
Posts: 15
|
| Posted: Tue Nov 06, 2007 12:12 pm Post subject: mactrack: Error: Save Failed |
|
|
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. |
|
| Back to top |
|
|
zgamer
Joined: 23 Sep 2006
Posts: 44
Location: WI, USA
|
| Posted: Thu Dec 20, 2007 9:47 am Post subject: |
|
|
| 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. |
|
| Back to top |
|
|
chrisgapske
Cacti User
Joined: 22 May 2007
Posts: 264
Location: Padacuh, Ky-Alpena, MI-Gulf Shores,AL
|
| Posted: Thu Dec 20, 2007 9:58 am Post subject: |
|
|
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. |
|
| Back to top |
|
|
zgamer
Joined: 23 Sep 2006
Posts: 44
Location: WI, USA
|
| Posted: Thu Dec 20, 2007 11:08 am Post subject: |
|
|
| Needed to run it twice but fixed the problem. |
|
| Back to top |
|
|
tomvang
Joined: 18 Jan 2008
Posts: 8
|
| Posted: Fri Jan 18, 2008 3:51 pm Post subject: database_update.php |
|
|
| 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 |
|
| Back to top |
|
|
zgamer
Joined: 23 Sep 2006
Posts: 44
Location: WI, USA
|
| Posted: Mon Jan 21, 2008 9:14 pm Post subject: |
|
|
| php database_upgrade.php under freebsd. |
|
| Back to top |
|
|
Gplamondon
Joined: 30 May 2008
Posts: 2
|
| Posted: Fri May 30, 2008 12:21 pm Post subject: |
|
|
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: | 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. |
|
| Back to top |
|
|
Gplamondon
Joined: 30 May 2008
Posts: 2
|
| Posted: Fri May 30, 2008 2:31 pm Post subject: |
|
|
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: | | 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'' |
|
|
| Back to top |
|
|
TheWitness
Developer
Joined: 14 May 2002
Posts: 9689
Location: MI, USA
|
| Posted: Sun Jun 01, 2008 7:18 am Post subject: |
|
|
You did not perform the database upgrade as those tables now don't exist. This is why you are getting this error.
TheWitness |
|
| Back to top |
|
|
ltdanmp
Joined: 01 Jul 2008
Posts: 2
|
| Posted: Tue Jul 01, 2008 1:54 pm Post subject: database upgrade |
|
|
| 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 |
|
| Back to top |
|
|
streaker69
Cacti Pro User
Joined: 27 Mar 2006
Posts: 647
Location: Psychic Amish Network Administrator
|
| Posted: Tue Jul 01, 2008 2:22 pm Post subject: Re: database upgrade |
|
|
| 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? |
|
| Back to top |
|
|
ltdanmp
Joined: 01 Jul 2008
Posts: 2
|
| Posted: Tue Jul 01, 2008 3:14 pm Post subject: |
|
|
| I am using firefox 2.0.0.14. thanks, Dan |
|
| Back to top |
|
|
Howie
Cacti Guru User
Joined: 16 Sep 2004
Posts: 2162
Location: United Kingdom
|
| Posted: Tue Sep 02, 2008 4:39 am Post subject: |
|
|
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: |
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.
| Quote: | 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
PluginsSSL 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) |
|
|
| Back to top |
|
|
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
