Hi All
Has anybody else seen this issue?
It appears the wifi_aps table is missing? However I do have an wifi_accesspoints table?
[2018/01/12 00:33:21 +0000] discovery.php(1241): Failed dbQuery (#1146 - Table 'observium.wifi_aps' doesn't exist), Query: SELECT * FROM `wifi_aps` WHERE `device_id` = ’38'
SiMacBookPro:Observium Simon$ grep -r "wifi_aps" * html/pages/device.inc.php: $device_ap_count = dbFetchCell('SELECT COUNT(wifi_ap_id) FROM `wifi_aps` WHERE `device_id` = ?', array($device['device_id'])); html/pages/device/wifi/accesspoints.inc.php: $accesspoints = dbFetchRows('SELECT * FROM `wifi_aps` WHERE `device_id` = ? ORDER BY `ap_name` ASC', array($device['device_id'])); includes/discovery/wifi.inc.php:foreach (dbFetchRows("SELECT * FROM `wifi_aps` WHERE `device_id` = ?", array($device['device_id'])) as $ap) includes/discovery/wifi.inc.php: $GLOBALS['cache']['wifi_aps'][$ap['ap_index']] = $ap; includes/definitions/entities.inc.php:$config['entities'][$entity]['table'] = "wifi_aps"; includes/wifi.inc.php: if (is_array($GLOBALS['cache']['wifi_aps'][$ap['ap_index']])) includes/wifi.inc.php: $ap_db = $GLOBALS['cache']['wifi_aps'][$ap['ap_index']]; includes/wifi.inc.php: dbUpdate($update, 'wifi_aps', '`wifi_ap_id` = ?', array($ap_db['wifi_ap_id'])); includes/wifi.inc.php: $ap_id = dbInsert($insert, 'wifi_aps'); includes/wifi.inc.php: $GLOBALS['cache']['wifi_aps'][$ap['ap_index']] = $params;
SiMacBookPro:Observium Simon$ grep -r "wifi_accesspoints" * html/includes/print/dot1xtable.inc.php: $aps_db = dbFetchRows("SELECT `wifi_accesspoint_id`, `name`, `ap_number` FROM `wifi_accesspoints`"); html/includes/search/accesspoints.inc.php:$results = dbFetchRows("SELECT * FROM `wifi_accesspoints` html/includes/graphs/wifi/auth.inc.php: $radio = dbFetchRow("SELECT * FROM `wifi_accesspoints`, `wifi_radios` WHERE `wifi_accesspoints`.`wifi_accesspoint_id` = `wifi_radios`.`accesspoint_id` AND `wifi_radios`.`wifi_radio_id` = ? ", array($vars['id'])); html/pages/device/wifi/overview.inc.php: $radios = dbFetchRows("SELECT * FROM `wifi_accesspoints` LEFT JOIN `wifi_radios` ON `wifi_accesspoints`.`wifi_accesspoint_id` = `wifi_radios`.`radio_ap` WHERE `wifi_accesspoints`.`device_id` = ? ", array($device['device_id'])); html/pages/device/wifi/accesspoint.inc.php: $radios = dbFetchRows("SELECT * FROM `wifi_accesspoints`, `wifi_radios` WHERE `wifi_accesspoints`.`wifi_accesspoint_id` = `wifi_radios`.`radio_ap` AND `device_id` = ? AND `wifi_accesspoints`.`wifi_accesspoint_id` = ? ORDER BY `radio_number` ASC", array($device['device_id'], $vars['accesspoint'])); includes/polling/wifi/trapeze-networks-client-session-mib.inc.php:$radios_db = dbFetchRows("SELECT `wifi_radio_id`, `radio_number`,`ap_number`, `wifi_accesspoints`.`device_id` FROM `wifi_accesspoints`, `wifi_radios` WHERE `wifi_radios`.`radio_ap` = wifi_accesspoints.`wifi_accesspoint_id` AND wifi_accesspoints.`device_id` = ?", array($device['device_id'])); includes/definitions.inc.php: 'ucd_diskio', 'vlans', 'vlans_fdb', 'vminfo', 'vrfs', 'wifi_accesspoints', 'wifi_sessions', includes/discovery/wifi/trapeze-networks-ap-config-mib.inc.php:$accesspoints_db = dbFetchRows("SELECT `name`, `model`, `location`, `fingerprint`, `serial`, `device_id`, `ap_number` FROM `wifi_accesspoints` WHERE `device_id` = ?", array($device['device_id'])); includes/discovery/wifi/trapeze-networks-ap-config-mib.inc.php: $accesspoint_id = dbInsert($db_insert, 'wifi_accesspoints'); includes/discovery/wifi/trapeze-networks-ap-config-mib.inc.php: $updated = dbUpdate($db_insert, 'wifi_accesspoints', '`ap_number` = ? AND `device_id` = ?', array($ap_number, $device['device_id'])); includes/discovery/wifi/trapeze-networks-ap-config-mib.inc.php:$accesspoints_db = dbFetchRows("SELECT `wifi_accesspoint_id`, `ap_number` FROM `wifi_accesspoints` WHERE `device_id` = ?", array($device['device_id'])); update/db_schema_mysql.sql:-- Table structure for table `wifi_accesspoints` update/db_schema_mysql.sql:CREATE TABLE `wifi_accesspoints` ( update/db_schema_mysql.sql:-- Indexes for table `wifi_accesspoints` update/db_schema_mysql.sql:ALTER TABLE `wifi_accesspoints` update/db_schema_mysql.sql:-- AUTO_INCREMENT for table `wifi_accesspoints` update/db_schema_mysql.sql:ALTER TABLE `wifi_accesspoints` update/141.sql:CREATE TABLE `wifi_accesspoints` ( `wifi_accesspoint_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `ap_number` int(11) DEFAULT NULL, `name` varchar(45) DEFAULT NULL, `serial` varchar(45) DEFAULT NULL, `model` varchar(45) DEFAULT NULL, `location` varchar(45) DEFAULT NULL, `fingerprint` varchar(45) DEFAULT NULL, `delete` tinyint(4) DEFAULT NULL, PRIMARY KEY (`wifi_accesspoint_id`)); update/186.sql:ALTER TABLE `wifi_accesspoints` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; SiMacBookPro:Observium Simon$
I can see when looking threw the code quickly that the is a sql file for wifi_accesspoints but not one for wifi_aps
Can I just clone/copy the wifi_accesspoints table to wifi_aps?
Regards
Simon - Hestor Ltd