mac_track_interfaces table doesn't exist
Moderators: Developers, Moderators
mac_track_interfaces table doesn't exist
I just installed mactrack 2.4 and don't have the mac_track_interfaces table. Rather than try to create that table manually and hope that's all I'm missing, is there some other course of action? I've tried uninstalling and reinstalling with the same result.
-
- Posts: 14
- Joined: Fri Apr 16, 2010 11:19 am
I just recently pulled from the svn and that same table wouldn't generate for me, i just grabbed the create table code from the setup.php for the mac_track_interfaces and jumped into mysql:
CREATE TABLE `mac_track_interfaces` (
`site_id` int(10) unsigned NOT NULL default '0',
`device_id` int(10) unsigned NOT NULL default '0',
`sysUptime` int(10) unsigned NOT NULL default '0',
`ifIndex` int(10) unsigned NOT NULL default '0',
`ifName` varchar(128) NOT NULL,
`ifAlias` varchar(255) NOT NULL,
`ifDescr` varchar(128) NOT NULL,
`ifType` int(10) unsigned NOT NULL default '0',
`ifMtu` int(10) unsigned NOT NULL default '0',
`ifSpeed` int(10) unsigned NOT NULL default '0',
`ifHighSpeed` int(10) unsigned NOT NULL default '0',
`ifDuplex` int(10) unsigned NOT NULL default '0',
`ifMauAutoNegAdminStatus` integer UNSIGNED NOT NULL default '0'
`ifMauAutoNegRemoteSignaling` integer UNSIGNED NOT NULL default '0'
`ifPhysAddress` varchar(20) NOT NULL,
`ifAdminStatus` int(10) unsigned NOT NULL default '0',
`ifOperStatus` int(10) unsigned NOT NULL default '0',
`ifLastChange` int(10) unsigned NOT NULL default '0',
`linkPort` tinyint(3) unsigned NOT NULL default '0',
`vlan_id` int(10) unsigned NOT NULL,
`vlan_name` varchar(128) NOT NULL,
`vlan_trunk` tinyint(3) unsigned NOT NULL,
`vlan_trunk_status` int(10) unsigned NOT NULL,
`ifInOctets` int(10) unsigned NOT NULL default '0',
`ifOutOctets` int(10) unsigned NOT NULL default '0',
`ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInDiscards` int(10) unsigned NOT NULL default '0',
`ifInErrors` int(10) unsigned NOT NULL default '0',
`ifInUnknownProtos` int(10) unsigned NOT NULL default '0',
`ifOutDiscards` int(10) unsigned default '0',
`ifOutErrors` int(10) unsigned default '0',
`inBound` double NOT NULL default '0',
`outBound` double NOT NULL default '0',
`int_ifInOctets` int(10) unsigned NOT NULL default '0',
`int_ifOutOctets` int(10) unsigned NOT NULL default '0',
`int_ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInDiscards` float unsigned NOT NULL default '0',
`int_ifInErrors` float unsigned NOT NULL default '0',
`int_ifInUnknownProtos` float unsigned NOT NULL default '0',
`int_ifOutDiscards` float unsigned NOT NULL default '0',
`int_ifOutErrors` float unsigned NOT NULL default '0',
`last_up_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`last_down_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`stateChanges` int(10) unsigned NOT NULL default '0',
`int_discards_present` tinyint(3) unsigned NOT NULL default '0',
`int_errors_present` tinyint(3) unsigned NOT NULL default '0',
`present` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`site_id`,`device_id`,`ifIndex`),
KEY `ifDescr` (`ifDescr`),
KEY `ifType` (`ifType`),
KEY `ifSpeed` (`ifSpeed`),
KEY `ifMTU` (`ifMtu`),
KEY `ifAdminStatus` (`ifAdminStatus`),
KEY `ifOperStatus` (`ifOperStatus`),
KEY `ifInDiscards` USING BTREE (`ifInUnknownProtos`),
KEY `ifInErrors` USING BTREE (`ifInUnknownProtos`))
ENGINE=MyISAM;
CREATE TABLE `mac_track_interfaces` (
`site_id` int(10) unsigned NOT NULL default '0',
`device_id` int(10) unsigned NOT NULL default '0',
`sysUptime` int(10) unsigned NOT NULL default '0',
`ifIndex` int(10) unsigned NOT NULL default '0',
`ifName` varchar(128) NOT NULL,
`ifAlias` varchar(255) NOT NULL,
`ifDescr` varchar(128) NOT NULL,
`ifType` int(10) unsigned NOT NULL default '0',
`ifMtu` int(10) unsigned NOT NULL default '0',
`ifSpeed` int(10) unsigned NOT NULL default '0',
`ifHighSpeed` int(10) unsigned NOT NULL default '0',
`ifDuplex` int(10) unsigned NOT NULL default '0',
`ifMauAutoNegAdminStatus` integer UNSIGNED NOT NULL default '0'
`ifMauAutoNegRemoteSignaling` integer UNSIGNED NOT NULL default '0'
`ifPhysAddress` varchar(20) NOT NULL,
`ifAdminStatus` int(10) unsigned NOT NULL default '0',
`ifOperStatus` int(10) unsigned NOT NULL default '0',
`ifLastChange` int(10) unsigned NOT NULL default '0',
`linkPort` tinyint(3) unsigned NOT NULL default '0',
`vlan_id` int(10) unsigned NOT NULL,
`vlan_name` varchar(128) NOT NULL,
`vlan_trunk` tinyint(3) unsigned NOT NULL,
`vlan_trunk_status` int(10) unsigned NOT NULL,
`ifInOctets` int(10) unsigned NOT NULL default '0',
`ifOutOctets` int(10) unsigned NOT NULL default '0',
`ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInDiscards` int(10) unsigned NOT NULL default '0',
`ifInErrors` int(10) unsigned NOT NULL default '0',
`ifInUnknownProtos` int(10) unsigned NOT NULL default '0',
`ifOutDiscards` int(10) unsigned default '0',
`ifOutErrors` int(10) unsigned default '0',
`inBound` double NOT NULL default '0',
`outBound` double NOT NULL default '0',
`int_ifInOctets` int(10) unsigned NOT NULL default '0',
`int_ifOutOctets` int(10) unsigned NOT NULL default '0',
`int_ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInDiscards` float unsigned NOT NULL default '0',
`int_ifInErrors` float unsigned NOT NULL default '0',
`int_ifInUnknownProtos` float unsigned NOT NULL default '0',
`int_ifOutDiscards` float unsigned NOT NULL default '0',
`int_ifOutErrors` float unsigned NOT NULL default '0',
`last_up_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`last_down_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`stateChanges` int(10) unsigned NOT NULL default '0',
`int_discards_present` tinyint(3) unsigned NOT NULL default '0',
`int_errors_present` tinyint(3) unsigned NOT NULL default '0',
`present` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`site_id`,`device_id`,`ifIndex`),
KEY `ifDescr` (`ifDescr`),
KEY `ifType` (`ifType`),
KEY `ifSpeed` (`ifSpeed`),
KEY `ifMTU` (`ifMtu`),
KEY `ifAdminStatus` (`ifAdminStatus`),
KEY `ifOperStatus` (`ifOperStatus`),
KEY `ifInDiscards` USING BTREE (`ifInUnknownProtos`),
KEY `ifInErrors` USING BTREE (`ifInUnknownProtos`))
ENGINE=MyISAM;
-
- Posts: 14
- Joined: Fri Apr 16, 2010 11:19 am
CORRECTION! sorry i forgot when i ran it his code was missing 2 commas at the end of the ifMauAutoNegAdminStatus and ifMauAutoNegRemoteSignaling lines, so this is the corrected one:
CREATE TABLE `mac_track_interfaces` (
`site_id` int(10) unsigned NOT NULL default '0',
`device_id` int(10) unsigned NOT NULL default '0',
`sysUptime` int(10) unsigned NOT NULL default '0',
`ifIndex` int(10) unsigned NOT NULL default '0',
`ifName` varchar(128) NOT NULL,
`ifAlias` varchar(255) NOT NULL,
`ifDescr` varchar(128) NOT NULL,
`ifType` int(10) unsigned NOT NULL default '0',
`ifMtu` int(10) unsigned NOT NULL default '0',
`ifSpeed` int(10) unsigned NOT NULL default '0',
`ifHighSpeed` int(10) unsigned NOT NULL default '0',
`ifDuplex` int(10) unsigned NOT NULL default '0',
`ifMauAutoNegAdminStatus` integer UNSIGNED NOT NULL default '0',
`ifMauAutoNegRemoteSignaling` integer UNSIGNED NOT NULL default '0',
`ifPhysAddress` varchar(20) NOT NULL,
`ifAdminStatus` int(10) unsigned NOT NULL default '0',
`ifOperStatus` int(10) unsigned NOT NULL default '0',
`ifLastChange` int(10) unsigned NOT NULL default '0',
`linkPort` tinyint(3) unsigned NOT NULL default '0',
`vlan_id` int(10) unsigned NOT NULL,
`vlan_name` varchar(128) NOT NULL,
`vlan_trunk` tinyint(3) unsigned NOT NULL,
`vlan_trunk_status` int(10) unsigned NOT NULL,
`ifInOctets` int(10) unsigned NOT NULL default '0',
`ifOutOctets` int(10) unsigned NOT NULL default '0',
`ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInDiscards` int(10) unsigned NOT NULL default '0',
`ifInErrors` int(10) unsigned NOT NULL default '0',
`ifInUnknownProtos` int(10) unsigned NOT NULL default '0',
`ifOutDiscards` int(10) unsigned default '0',
`ifOutErrors` int(10) unsigned default '0',
`inBound` double NOT NULL default '0',
`outBound` double NOT NULL default '0',
`int_ifInOctets` int(10) unsigned NOT NULL default '0',
`int_ifOutOctets` int(10) unsigned NOT NULL default '0',
`int_ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInDiscards` float unsigned NOT NULL default '0',
`int_ifInErrors` float unsigned NOT NULL default '0',
`int_ifInUnknownProtos` float unsigned NOT NULL default '0',
`int_ifOutDiscards` float unsigned NOT NULL default '0',
`int_ifOutErrors` float unsigned NOT NULL default '0',
`last_up_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`last_down_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`stateChanges` int(10) unsigned NOT NULL default '0',
`int_discards_present` tinyint(3) unsigned NOT NULL default '0',
`int_errors_present` tinyint(3) unsigned NOT NULL default '0',
`present` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`site_id`,`device_id`,`ifIndex`),
KEY `ifDescr` (`ifDescr`),
KEY `ifType` (`ifType`),
KEY `ifSpeed` (`ifSpeed`),
KEY `ifMTU` (`ifMtu`),
KEY `ifAdminStatus` (`ifAdminStatus`),
KEY `ifOperStatus` (`ifOperStatus`),
KEY `ifInDiscards` USING BTREE (`ifInUnknownProtos`),
KEY `ifInErrors` USING BTREE (`ifInUnknownProtos`))
ENGINE=MyISAM;
CREATE TABLE `mac_track_interfaces` (
`site_id` int(10) unsigned NOT NULL default '0',
`device_id` int(10) unsigned NOT NULL default '0',
`sysUptime` int(10) unsigned NOT NULL default '0',
`ifIndex` int(10) unsigned NOT NULL default '0',
`ifName` varchar(128) NOT NULL,
`ifAlias` varchar(255) NOT NULL,
`ifDescr` varchar(128) NOT NULL,
`ifType` int(10) unsigned NOT NULL default '0',
`ifMtu` int(10) unsigned NOT NULL default '0',
`ifSpeed` int(10) unsigned NOT NULL default '0',
`ifHighSpeed` int(10) unsigned NOT NULL default '0',
`ifDuplex` int(10) unsigned NOT NULL default '0',
`ifMauAutoNegAdminStatus` integer UNSIGNED NOT NULL default '0',
`ifMauAutoNegRemoteSignaling` integer UNSIGNED NOT NULL default '0',
`ifPhysAddress` varchar(20) NOT NULL,
`ifAdminStatus` int(10) unsigned NOT NULL default '0',
`ifOperStatus` int(10) unsigned NOT NULL default '0',
`ifLastChange` int(10) unsigned NOT NULL default '0',
`linkPort` tinyint(3) unsigned NOT NULL default '0',
`vlan_id` int(10) unsigned NOT NULL,
`vlan_name` varchar(128) NOT NULL,
`vlan_trunk` tinyint(3) unsigned NOT NULL,
`vlan_trunk_status` int(10) unsigned NOT NULL,
`ifInOctets` int(10) unsigned NOT NULL default '0',
`ifOutOctets` int(10) unsigned NOT NULL default '0',
`ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`ifInDiscards` int(10) unsigned NOT NULL default '0',
`ifInErrors` int(10) unsigned NOT NULL default '0',
`ifInUnknownProtos` int(10) unsigned NOT NULL default '0',
`ifOutDiscards` int(10) unsigned default '0',
`ifOutErrors` int(10) unsigned default '0',
`inBound` double NOT NULL default '0',
`outBound` double NOT NULL default '0',
`int_ifInOctets` int(10) unsigned NOT NULL default '0',
`int_ifOutOctets` int(10) unsigned NOT NULL default '0',
`int_ifHCInOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifHCOutOctets` bigint(20) unsigned NOT NULL default '0',
`int_ifInNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutNUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifOutUcastPkts` int(10) unsigned NOT NULL default '0',
`int_ifInDiscards` float unsigned NOT NULL default '0',
`int_ifInErrors` float unsigned NOT NULL default '0',
`int_ifInUnknownProtos` float unsigned NOT NULL default '0',
`int_ifOutDiscards` float unsigned NOT NULL default '0',
`int_ifOutErrors` float unsigned NOT NULL default '0',
`last_up_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`last_down_time` timestamp NOT NULL default '0000-00-00 00:00:00',
`stateChanges` int(10) unsigned NOT NULL default '0',
`int_discards_present` tinyint(3) unsigned NOT NULL default '0',
`int_errors_present` tinyint(3) unsigned NOT NULL default '0',
`present` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`site_id`,`device_id`,`ifIndex`),
KEY `ifDescr` (`ifDescr`),
KEY `ifType` (`ifType`),
KEY `ifSpeed` (`ifSpeed`),
KEY `ifMTU` (`ifMtu`),
KEY `ifAdminStatus` (`ifAdminStatus`),
KEY `ifOperStatus` (`ifOperStatus`),
KEY `ifInDiscards` USING BTREE (`ifInUnknownProtos`),
KEY `ifInErrors` USING BTREE (`ifInUnknownProtos`))
ENGINE=MyISAM;
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Oops. I did not test that. I'll be releasing a 2.5 next week. That'll be fixed in a few minutes though.
TheWitness
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?
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?
I have similar errors in my log after installing 2.4:
This is when I try to enter device.
This is when I browse devices.
This is when I try to enter device.
Code: Select all
04/19/2010 05:21:54 PM - MACTRACK: Poller[0] ERROR: Cacti Device: (0/875): 10.14.2.2, error on save: a:26:{s:9:"device_id";s:1:"0";s:7:"host_id";s:3:"875";s:7:"site_id";s:1:"0";s:8:"hostname";s:9:"10.14.2.2";s:11:"device_name";s:15:"Sofia-DLE65-MSR";s:5:"notes";s:0:"";s:9:"scan_type";s:1:"1";s:12:"snmp_options";s:1:"0";s:15:"snmp_readstring";s:13:"management!@#";s:12:"snmp_version";s:1:"2";s:13:"snmp_username";s:4:"root";s:13:"snmp_password";s:9:"XXkibik00";s:18:"snmp_auth_protocol";s:3:"MD5";s:20:"snmp_priv_passphrase";s:0:"";s:18:"snmp_priv_protocol";s:3:"DES";s:12:"snmp_context";s:0:"";s:9:"snmp_port";s:3:"161";s:12:"snmp_timeout";s:3:"500";s:12:"snmp_retries";s:1:"3";s:8:"max_oids";s:2:"50";s:9:"user_name";s:0:"";s:13:"user_password";s:0:"";s:11:"ignorePorts";s:0:"";s:9:"term_type";s:1:"1";s:16:"private_key_path";s:0:"";s:8:"disabled";s:0:"";}
Code: Select all
04/19/2010 05:38:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_device_types.description as device_type, mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.host_id, mac_track_devices.device_name, mac_track_devices.notes, mac_track_devices.hostname, mac_track_devices.snmp_options, mac_track_devices.snmp_readstring, mac_track_devices.snmp_version, mac_track_devices.snmp_username, mac_track_devices.snmp_password, mac_track_devices.snmp_auth_protocol, mac_track_devices.snmp_priv_passphrase, mac_track_devices.snmp_priv_protocol, mac_track_devices.snmp_context, mac_track_devices.snmp_port, mac_track_devices.snmp_timeout, mac_track_devices.snmp_retries, mac_track_devices.max_oids, 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 LEFT JOIN mac_track_device_types ON mac_track_devices.device_type_id=mac_track_device_types.device_type_id ORDER BY site_name ASC LIMIT 0,30"
Cacti user
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
v2.5 is in SVN. I will be releasing to the docs site in a bit.
TheWitness
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?
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?
I am writing in this topic, because of the my previous post, but it also relates to "update 1.x to 2.5 problems":
On another machine, which has not mactrack installed, after installing v2.5 and select mactrack tab I received in log:
After selecting devices in Console:
Any suggestions ?
On another machine, which has not mactrack installed, after installing v2.5 and select mactrack tab I received in log:
Code: Select all
04/21/2010 02:38:02 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 LEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id) WHERE (mac_track_devices.hostname LIKE '%%' OR mac_track_devices.notes LIKE '%%' OR mac_track_devices.device_name LIKE '%%' OR mac_track_sites.site_name LIKE '%%')"
04/21/2010 02:38:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_devices.*, mac_track_device_types.description AS device_type, mac_track_sites.site_name FROM mac_track_sites RIGHT JOIN mac_track_devices ON (mac_track_devices.site_id=mac_track_sites.site_id) LEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id) WHERE (mac_track_devices.hostname LIKE '%%' OR mac_track_devices.notes LIKE '%%' OR mac_track_devices.device_name LIKE '%%' OR mac_track_sites.site_name LIKE '%%') ORDER BY site_name ASC LIMIT 0,30"
04/21/2010 02:38:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT device_id, device_name, hostname FROM mac_track_devices ORDER BY device_name"
Code: Select all
04/21/2010 02:44:32 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_device_types.description as device_type, mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.host_id, mac_track_devices.device_name, mac_track_devices.notes, mac_track_devices.hostname, mac_track_devices.snmp_options, mac_track_devices.snmp_readstring, mac_track_devices.snmp_version, mac_track_devices.snmp_username, mac_track_devices.snmp_password, mac_track_devices.snmp_auth_protocol, mac_track_devices.snmp_priv_passphrase, mac_track_devices.snmp_priv_protocol, mac_track_devices.snmp_context, mac_track_devices.snmp_port, mac_track_devices.snmp_timeout, mac_track_devices.snmp_retries, mac_track_devices.max_oids, 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 LEFT JOIN mac_track_device_types ON mac_track_devices.device_type_id=mac_track_device_types.device_type_id ORDER BY site_name ASC LIMIT 0,30"
Cacti user
-
- Posts: 14
- Joined: Fri Apr 16, 2010 11:19 am
I recreated mac_track_interfaces table as you suggest, but result is the same as before.
1.When I select Devices from Device Tracking section:
2.When I select mactrack Tab:
[/code]
1.When I select Devices from Device Tracking section:
Code: Select all
04/23/2010 02:17:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_device_types.description as device_type, mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.host_id, mac_track_devices.device_name, mac_track_devices.notes, mac_track_devices.hostname, mac_track_devices.snmp_options, mac_track_devices.snmp_readstring, mac_track_devices.snmp_version, mac_track_devices.snmp_username, mac_track_devices.snmp_password, mac_track_devices.snmp_auth_protocol, mac_track_devices.snmp_priv_passphrase, mac_track_devices.snmp_priv_protocol, mac_track_devices.snmp_context, mac_track_devices.snmp_port, mac_track_devices.snmp_timeout, mac_track_devices.snmp_retries, mac_track_devices.max_oids, 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 LEFT JOIN mac_track_device_types ON mac_track_devices.device_type_id=mac_track_device_types.device_type_id ORDER BY site_name ASC LIMIT 0,30"
Code: Select all
04/23/2010 02:18:43 PM - 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 LEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id) WHERE (mac_track_devices.hostname LIKE '%%' OR mac_track_devices.notes LIKE '%%' OR mac_track_devices.device_name LIKE '%%' OR mac_track_sites.site_name LIKE '%%')"
04/23/2010 02:18:43 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_devices.*, mac_track_device_types.description AS device_type, mac_track_sites.site_name FROM mac_track_sites RIGHT JOIN mac_track_devices ON (mac_track_devices.site_id=mac_track_sites.site_id) LEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id) WHERE (mac_track_devices.hostname LIKE '%%' OR mac_track_devices.notes LIKE '%%' OR mac_track_devices.device_name LIKE '%%' OR mac_track_sites.site_name LIKE '%%') ORDER BY site_name ASC LIMIT 0,30"
04/23/2010 02:18:43 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT device_id, device_name, hostname FROM mac_track_devices ORDER BY device_name"
Cacti user
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Yes, you database upgrade was not complete. If you were doing point upgrades from 2.x, you may have encountered the problem. If you take the lib/database.php from SVN, you will get more informative errors so you can fix the problem.
TheWitness
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?
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?
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Well, if there are no more errors
TheWitness
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?
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?
Who is online
Users browsing this forum: No registered users and 0 guests