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
Administrator of Gigzx.com
---------------------------------------

On 17 January 2018 at 17:10, Adam Armstrong <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> 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
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

 

--
Erwan Lerale
06 10 31 52 28
Soundcloud

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium