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
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
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
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.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Erwan Lerale 06 10 31 52 28 Soundcloudhttps://soundcloud.com/erwan-lerale
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]
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 https://soundcloud.com/erwan-lerale
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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
perfectly understandable answer :)
we shall all ignore it for the moment until it is committed and ready for testing!
SASmith Simon Smith --------------------------------------- IT Tech for Hestor Ltd http://www.hestor.com Administrator of zeplin.co.uk ---------------------------------------
On 18 January 2018 at 12:48, Adam Armstrong adama@observium.org wrote:
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'][$e ntity]['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 https://soundcloud.com/erwan-lerale
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
participants (5)
-
Adam Armstrong -
erwan＠thiscow.fr -
Kennet Bjerg -
Rowlands Mark -
Simon Mousey Smith