Nothing to see here folks. Don't look behind the curtain...
:D
adam. On 2018-01-17 15:40:22, Rowlands Mark mark.rowlands@riksbyggen.se wrote: SQL[SELECT * FROM `wifi_aps` WHERE `device_id` = '684'] SQL RUNTIME[0.00024199s] ERROR[Error in query: (Table 'observium.wifi_aps' doesn't exist) 1146] From: observium [mailto:observium-bounces@observium.org] On Behalf Of erwan@thiscow.fr Sent: den 17 januari 2018 11:24 To: observium@observium.org Subject: Re: [Observium] wifi_ap table missing? Hello, Same here (running r8998). Cheers Erwan Le 15/01/2018 à 12:11, Kennet Bjerg a écrit : same problem
[2018/01/15 07:00:55 +0100] discovery.php(25971): Failed dbQuery (#1146 - Table 'observium.wifi_aps' doesn't exist), Query: SELECT * FROM `wifi_aps` WHERE `device_id` = '33' [2018/01/15 07:01:23 +0100] discovery.php(25971): Failed dbQuery (#1146 - Table 'observium.wifi_aps' doesn't exist), Query: SELECT * FROM `wifi_aps` WHERE `device_id` = '31' [2018/01/15 07:03:17 +0100] discovery.php(25971): Failed dbQuery (#1146 - Table 'observium.wifi_aps' doesn't exist), Query: SELECT * FROM `wifi_aps` WHERE `device_id` = '6' [2018/01/15 07:04:18 +0100] discovery.php(25971): Failed dbQuery (#1146 - Table 'observium.wifi_aps' doesn't exist), Query: SELECT * FROM `wifi_aps` WHERE `device_id` = '100' [2018/01/15 07:05:20 +0100] discovery.php(25971): Failed dbQuery (#1146 - Table 'observium.wifi_aps' doesn't exist), Query: SELECT * FROM `wifi_aps` WHERE `device_id` = '99'
/Kennet
Den 14/01/2018 kl. 19.54 skrev Simon Mousey Smith:
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 _______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium] -- Erwan Lerale 06 10 31 52 28 Soundcloud [https://soundcloud.com/erwan-lerale]