This is super long term work in progress stuff. Trying to support Wifi stuff is really painful because the vendors all model it differently, thus the code isn't fully committed (though a bit of it leaked through), and the db structure isn't committed.
adam. On 2018-01-18 10:17:21, Simon Mousey Smith simonsmith5521@gmail.com wrote: what did you do Adam...
shouldn't the be a table there lol
SASmith Simon Smith --------------------------------------- Administrator of Zeplin.co.uk [http://Zeplin.co.uk] Administrator of Gigzx.com ---------------------------------------
On 17 January 2018 at 17:10, Adam Armstrong <adama@observium.org [mailto:adama@observium.org]> wrote:
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 [mailto: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 [mailto:observium-bounces@observium.org]] On Behalf Of erwan@thiscow.fr [mailto:erwan@thiscow.fr] Sent: den 17 januari 2018 11:24 To: observium@observium.org [mailto: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]
_______________________________________________ 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 http://postman.memetic.org/cgi-bin/mailman/listinfo/observium