Opticon ESL
ESL Server manual
v1.0.62.2
97
Supported Base station actions
The following list of SQL-commands is currently supported to initiate a base-station-action.
Successfully executed and discarded commands will be moved to the action results-table.
Timeout in sec (min 30, max 900)
INSERT INTO `actions_staging`(`ACTION`, `MAC`, `PARAM1`) VALUES ('REACTIVATE_START',
'00126AF5FFF8', 180);
INSERT INTO `actions_staging`(`ACTION`, `MAC`) VALUES ('REACTIVATE_STOP', '00126AF5FFF8');
Start range
(MAC-Address (16)
End range
(MAC-Address 16)
INSERT INTO `actions_staging`(`ACTION`, `MAC`, `PARAM1`) VALUES ('DEACTIVATE',
'3889DC0001000000', '3889DC000100FFFF');
INSERT INTO `actions_staging`(`ACTION`, `MAC`) VALUES ('DISCOVER', '');
(Use preferably once a day)
INSERT INTO `actions_staging`(`ACTION`, `MAC`) VALUES ('BALANCE_ESLS', '');
(Warning: Refreshing effects battery life!)
INSERT INTO `actions_staging`(`ACTION`, `MAC`) VALUES ('REFRESH_ESLS', '');
INSERT INTO `actions_staging`(`ACTION`, `MAC`) VALUES ('RESET', '00126AF5FFF8');
INSERT INTO `actions_staging`(`ACTION`, `MAC`) VALUES ('ADD', '00126AF5FFF8');
INSERT INTO `actions_staging`(`ACTION`, `MAC`) VALUES ('REMOVE', '00126AF5FFF8');
INSERT INTO `actions_staging`(`ACTION`, `MAC`, `PARAM1`) VALUES ('FIRMWARE_UPDATE',
'00126AF5FFF8', 'EBS40-IBUV0052.bin');
Supported Base station settings
The following list of SQL-commands is currently supported to change a base-station-setting.
Successfully executed and disgarded commands will be moved to the action results-table.
RF-Channel (int) (default 11, min 11, max 26)
INSERT INTO `actions_staging`(`ACTION`, `MAC`, `PARAM1`) VALUES
('CHANNEL','00126AF5FFF8',15);
PAN-ID (4) (default: last 4 digits of MAC)
INSERT INTO `actions_staging`(`ACTION`, `MAC`, `PARAM1`) VALUES
('PANID','00126AF5FFF8','12AB');
LAN-ID (4) (default 0000, min 0000, max FFFE)
INSERT INTO `actions_staging`(`ACTION`, `MAC`, `PARAM1`) VALUES
('LANID','00126AF5FFF8','0003');
LAN-ID (4) (default 0000, min 0000, max FFFE)
INSERT INTO `actions_staging`(`ACTION`, `MAC`, `PARAM1`) VALUES
('LOCAL_NAME','00126AF5FFF8','FIRST_FLOOR');