-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Jul 24, 2022 at 09:40 PM -- Server version: 5.7.38-0ubuntu0.18.04.1 -- PHP Version: 8.0.21 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `radius` -- -- -------------------------------------------------------- -- -- Table structure for table `nas` -- CREATE TABLE `nas` ( `id` int(10) NOT NULL, `nasname` varchar(128) NOT NULL, `shortname` varchar(32) DEFAULT NULL, `type` varchar(30) DEFAULT 'other', `ports` int(5) DEFAULT NULL, `secret` varchar(60) NOT NULL DEFAULT 'secret', `server` varchar(64) DEFAULT NULL, `community` varchar(50) DEFAULT NULL, `description` varchar(200) DEFAULT 'RADIUS Client' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `nas` -- INSERT INTO `nas` (`id`, `nasname`, `shortname`, `type`, `ports`, `secret`, `server`, `community`, `description`) VALUES (1, '192.168.137.2', 'mikrotik-client', 'other', NULL, 'murad2022', NULL, NULL, 'MikroTik Client Router'); -- -------------------------------------------------------- -- -- Table structure for table `radacct` -- CREATE TABLE `radacct` ( `radacctid` bigint(21) NOT NULL, `acctsessionid` varchar(64) NOT NULL DEFAULT '', `acctuniqueid` varchar(32) NOT NULL DEFAULT '', `username` varchar(64) NOT NULL DEFAULT '', `realm` varchar(64) DEFAULT '', `nasipaddress` varchar(15) NOT NULL DEFAULT '', `nasportid` varchar(15) DEFAULT NULL, `nasporttype` varchar(32) DEFAULT NULL, `acctstarttime` datetime DEFAULT NULL, `acctupdatetime` datetime DEFAULT NULL, `acctstoptime` datetime DEFAULT NULL, `acctinterval` int(12) DEFAULT NULL, `acctsessiontime` int(12) UNSIGNED DEFAULT NULL, `acctauthentic` varchar(32) DEFAULT NULL, `connectinfo_start` varchar(50) DEFAULT NULL, `connectinfo_stop` varchar(50) DEFAULT NULL, `acctinputoctets` bigint(20) DEFAULT NULL, `acctoutputoctets` bigint(20) DEFAULT NULL, `calledstationid` varchar(50) NOT NULL DEFAULT '', `callingstationid` varchar(50) NOT NULL DEFAULT '', `acctterminatecause` varchar(32) NOT NULL DEFAULT '', `servicetype` varchar(32) DEFAULT NULL, `framedprotocol` varchar(32) DEFAULT NULL, `framedipaddress` varchar(15) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `radacct` -- INSERT INTO `radacct` (`radacctid`, `acctsessionid`, `acctuniqueid`, `username`, `realm`, `nasipaddress`, `nasportid`, `nasporttype`, `acctstarttime`, `acctupdatetime`, `acctstoptime`, `acctinterval`, `acctsessiontime`, `acctauthentic`, `connectinfo_start`, `connectinfo_stop`, `acctinputoctets`, `acctoutputoctets`, `calledstationid`, `callingstationid`, `acctterminatecause`, `servicetype`, `framedprotocol`, `framedipaddress`) VALUES (1, '84000006', '20a68fb9ff5e9bd54ab98be369169688', 'bob', '', '192.168.137.2', '', '', '2022-07-19 22:38:39', '2022-07-19 22:38:39', '2022-07-19 22:39:27', NULL, 47, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (2, '84000007', '57c4aabd2e6b125a1b4e52ac1aecde94', 'bob', '', '192.168.137.2', '', '', '2022-07-19 22:38:39', '2022-07-19 22:38:39', '2022-07-19 22:39:27', NULL, 47, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (3, '84000008', '77dd7bef05b2ec6451f425d82715d7ef', 'bob', '', '192.168.137.2', '', '', '2022-07-19 22:38:40', '2022-07-19 22:38:40', '2022-07-19 22:39:27', NULL, 47, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (4, '8400000a', 'a212e7965fdbcea6e5244c94c11b14a6', 'bob', '', '192.168.137.2', '', '', '2022-07-19 22:38:40', '2022-07-19 22:38:40', '2022-07-19 22:39:27', NULL, 47, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (5, '84000009', '1522c1d6c4562fd3ee0cef17dc14b8b4', 'bob', '', '192.168.137.2', '', '', '2022-07-19 22:38:40', '2022-07-19 22:38:40', '2022-07-19 22:39:27', NULL, 47, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (6, '8400000b', '92dc9b6a8eadf128693bdcd44789641d', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 06:51:26', NULL, 526, '', '', '', 0, 0, '', '192.168.137.1', 'Admin-Reboot', 'Login-User', '', ''), (7, '8400000c', 'adf2bd6fc4b5213ad99cf4b5fb22d059', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 06:51:26', NULL, 526, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (8, '8400000f', 'ac0c61ebbc3379a5dbd21c1d567c78f0', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 06:51:26', NULL, 526, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (9, '8400000e', 'c210cbf99ade7e27e767dcde641bea11', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 06:51:26', NULL, 526, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (10, '8400000d', 'd0995cc9a4f98f018d8ddc6c3dbe765d', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 06:51:26', NULL, 526, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (21, '84000001', '0fe759c1941be7adfe8781496c563109', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 23:41:15', NULL, 1641, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (22, '84000002', '326d8e608834d5b4baa4629a440887bd', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 23:41:15', NULL, 1641, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (23, '84000003', '29904554283621db57049f697957f94b', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 23:41:15', NULL, 1641, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (24, '84000004', '6386fa64bed7989c08d965628aafaa6b', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 23:41:15', NULL, 1641, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (25, '84000005', 'f95dd07b80bf0e26aacf7432ee046195', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 23:41:15', NULL, 1641, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (28, '8400000b', 'bc346a499134111c0f6b7cc5579e8e9f', 'bob', '', '192.168.137.2', '', '', '2022-07-19 06:53:02', '2022-07-19 06:53:02', '2022-07-19 06:56:27', NULL, 204, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (29, '8400000c', '8181ce25484c8767f14b306abe9ad27c', 'bob', '', '192.168.137.2', '', '', '2022-07-19 06:53:02', '2022-07-19 06:53:02', '2022-07-19 06:56:27', NULL, 204, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (30, '8400000d', '9d234290662c3127e529e3ba5f5aab3e', 'bob', '', '192.168.137.2', '', '', '2022-07-19 06:53:02', '2022-07-19 06:53:02', '2022-07-19 06:56:27', NULL, 204, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (31, '80500007', 'b7911ab339ad4d1cff2fb2f3c5b5cccf', 'mehtab', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 13:39:59', '2022-07-19 13:39:59', '2022-07-19 15:33:08', NULL, 6789, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'NAS-Reboot', '', '', '192.168.250.254'), (37, '8060006a', 'cbd7cbc325081a0b7494b4f17e85a1e4', 'shawon', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 15:33:29', '2022-07-19 15:33:29', '2022-07-19 15:38:29', NULL, 300, '', '', '', 2360, 2132, 'hotspot1', '08:00:27:76:3E:6C', 'Session-Timeout', '', '', '192.168.250.219'), (38, '806000ad', '330c61525b3b2ae07666016269e23edd', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 16:10:13', '2022-07-19 16:10:13', '2022-07-19 17:06:00', NULL, 3347, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'NAS-Reboot', '', '', '192.168.250.219'), (44, '80700016', '59e076291e19e89aa3985a027435eb79', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 17:06:28', '2022-07-19 17:06:28', '2022-07-19 17:11:18', NULL, 290, '', '', '', 9038, 28722, 'hotspot1', '08:00:27:76:3E:6C', 'User-Request', '', '', '192.168.250.214'), (50, '80700061', 'ba7d561766c1311be4b254a120095d9b', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 17:11:30', '2022-07-19 17:11:30', '2022-07-19 17:12:50', NULL, 80, '', '', '', 14197, 329860, 'hotspot1', '08:00:27:76:3E:6C', 'User-Request', '', '', '192.168.250.214'), (51, '80700068', '2519bb516d74c6055cc85f5d4a532d8c', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 17:12:51', '2022-07-19 17:12:51', '2022-07-19 17:13:10', NULL, 19, '', '', '', 353, 52, 'hotspot1', '08:00:27:76:3E:6C', 'User-Request', '', '', '192.168.250.214'), (52, '80700070', 'a9be8441d78dbc1fc96b69faa6dc98e2', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 17:13:11', '2022-07-19 17:13:11', '2022-07-19 17:13:12', NULL, 1, '', '', '', 41, 52, 'hotspot1', '08:00:27:76:3E:6C', 'User-Request', '', '', '192.168.250.214'), (53, '80700071', 'd7ffb3c01f9046d7a7b88f83aa13ff6d', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 17:13:13', '2022-07-19 17:13:13', '2022-07-19 17:13:44', NULL, 31, '', '', '', 1917, 2216, 'hotspot1', '08:00:27:76:3E:6C', 'User-Request', '', '', '192.168.250.214'), (54, '80700072', '458871fc63f37da96ab76f5283b8ee4b', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 17:13:45', '2022-07-19 17:13:45', '2022-07-19 17:18:39', NULL, 294, '', '', '', 541268, 19524873, 'hotspot1', '08:00:27:76:3E:6C', 'User-Request', '', '', '192.168.250.214'), (55, '807000c7', '230c5e37b09f83376ac828588840315a', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 17:18:41', '2022-07-19 17:18:41', '2022-07-19 17:21:00', NULL, 139, '', '', '', 554207, 14145480, 'hotspot1', '08:00:27:76:3E:6C', 'User-Request', '', '', '192.168.250.214'), (56, '807000f2', '2e37d87648a279db0bbc92f72a604297', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 17:21:02', '2022-07-19 17:21:02', '2022-07-19 22:32:23', NULL, 18681, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'NAS-Reboot', '', '', '192.168.250.214'), (62, '8090000e', '5447ac3ea2294881aa1cd266dbd7990b', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 22:40:10', '2022-07-19 22:40:10', '2022-07-19 22:42:48', NULL, 158, '', '', '', 43571, 651966, 'hotspot1', '08:00:27:76:3E:6C', 'Admin-Reboot', '', '', '192.168.250.221'), (63, '80a00000', 'c42ee54366f60517803023ef0e338987', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 22:43:07', '2022-07-19 22:43:07', '2022-07-19 22:53:42', NULL, 635, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'NAS-Reboot', '', '', '192.168.250.222'), (69, '80000001', '074e4846469f435a4fc57e44cedec244', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 23:14:20', '2022-07-19 23:14:20', '2022-07-19 23:40:15', NULL, 1555, '', '', '', 450968, 10179295, 'hotspot1', '08:00:27:76:3E:6C', 'User-Request', '', '', '192.168.250.222'), (70, '81d00005', '42b51948b31a48f9ea97fa9338066653', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-19 23:18:37', '2022-07-19 23:18:37', '2022-07-19 23:33:42', NULL, 905, 'RADIUS', '', '', 1582091, 50424444, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'Lost-Carrier', 'Framed-User', 'PPP', '192.168.251.254'), (71, '84000006', 'df498afd98a3cf9fdf6dc76c21f207d2', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-19 23:41:15', NULL, 564, '', '', '', 0, 0, '', '192.168.137.1', 'User-Request', 'Login-User', '', ''), (72, '80000002', '0aba556c81b67f4abdc776e222527f65', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-19 23:40:17', '2022-07-19 23:40:17', '2022-07-19 23:42:33', NULL, 136, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'Lost-Service', '', '', '192.168.250.222'), (73, '81e00000', 'ddd0ad01290b9bde991e66da121c4208', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-20 15:45:00', '2022-07-20 15:45:00', '2022-07-20 15:57:00', NULL, 720, 'RADIUS', '', '', 0, 0, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'NAS-Reboot', 'Framed-User', 'PPP', '192.168.251.254'), (74, '81f00000', '58a439e94b3251a2e2c2a86247096959', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-20 15:59:47', '2022-07-20 15:59:47', '2022-07-20 16:17:26', NULL, 1059, 'RADIUS', '', '', 1487124, 18669163, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'User-Request', 'Framed-User', 'PPP', '192.168.251.254'), (75, '80200002', '9d5eca6fcff1cecafee176f4d1c0388c', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-20 16:05:17', '2022-07-20 16:05:17', '2022-07-20 16:17:36', NULL, 739, '', '', '', 218810, 4632649, 'hotspot1', '08:00:27:76:3E:6C', 'Admin-Reboot', '', '', '192.168.250.221'), (76, '81000000', '1dec8a05e850f6ab89467364543f1c8c', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-20 16:18:57', '2022-07-20 16:18:57', '2022-07-20 16:53:05', NULL, 2048, 'RADIUS', '', '', 502654, 2872698, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'Lost-Carrier', 'Framed-User', 'PPP', '192.168.251.254'), (77, '80300001', 'c04656787a6bcb5a910568e74d1b189e', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-20 16:53:36', '2022-07-20 16:53:36', '2022-07-20 17:07:18', NULL, 822, '', '', '', 33679, 465580, 'hotspot1', '08:00:27:76:3E:6C', 'Lost-Carrier', '', '', '192.168.250.221'), (78, '81000001', '632e28bf98d33ed92b81572068220ebb', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-20 17:04:30', '2022-07-20 17:04:30', '2022-07-20 17:06:44', NULL, 134, 'RADIUS', '', '', 343565, 887461, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'Lost-Carrier', 'Framed-User', 'PPP', '192.168.251.254'), (79, '81000002', 'a79b55408bc39f143cfacd04c3ada50f', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-20 17:40:02', '2022-07-20 17:40:02', '2022-07-20 17:55:17', NULL, 915, 'RADIUS', '', '', 854, 92, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'User-Request', 'Framed-User', 'PPP', '192.168.251.254'), (80, '80300003', 'e5c9a166635bc869abf8d380ec4de774', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-20 17:42:00', '2022-07-20 17:42:00', '2022-07-20 17:44:01', NULL, 121, '', '', '', 12631, 194139, 'hotspot1', '08:00:27:76:3E:6C', 'User-Request', '', '', '192.168.250.221'), (81, '80300004', '591db0dfdc68cde26533bef6dc3a8602', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-20 17:44:35', '2022-07-20 17:44:35', '2022-07-20 18:04:22', NULL, 1187, '', '', '', 11798, 35151, 'hotspot1', '08:00:27:76:3E:6C', 'User-Request', '', '', '192.168.250.221'), (82, '80300005', '18f751bce50aea727083d5331267401f', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-20 18:04:23', '2022-07-20 18:04:23', '2022-07-20 18:04:57', NULL, 34, '', '', '', 229, 0, 'hotspot1', '08:00:27:76:3E:6C', 'Admin-Reboot', '', '', '192.168.250.221'), (86, '84000010', '5eaa256386957096e37fffd59504a0a8', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-21 09:46:53', NULL, 42066, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (87, '84000011', 'bb13d4ea2f9ec9227a0a5605711c4b0b', 'murad', '', '192.168.137.2', '', '', '2022-07-20 22:05:47', '2022-07-20 22:05:47', '2022-07-21 09:46:53', NULL, 42066, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (88, '84000012', 'e096d9201428df757eb7f092bb637d24', 'murad', '', '192.168.137.2', '', '', '2022-07-20 22:05:47', '2022-07-20 22:05:47', '2022-07-21 09:46:53', NULL, 42066, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (89, '84000013', 'b235960af8137f53c3fc6df78e1cc692', 'murad', '', '192.168.137.2', '', '', '2022-07-20 22:05:47', '2022-07-20 22:05:47', '2022-07-21 09:46:53', NULL, 42066, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (90, '84000014', '757fa331c04fd63e3c219ca1d11ece03', 'murad', '', '192.168.137.2', '', '', '2022-07-20 22:05:47', '2022-07-20 22:05:47', '2022-07-21 09:46:53', NULL, 42066, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (91, '84000015', 'db745d578a0ce6dcbddf8a93cb91d94e', 'murad', '', '192.168.137.2', '', '', '2022-07-20 22:05:47', '2022-07-20 22:05:47', '2022-07-21 09:46:53', NULL, 42066, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (92, '84000016', 'b70fb1e433dd202aedae6a9bf13db701', 'murad', '', '192.168.137.2', '', '', '2022-07-20 22:05:47', '2022-07-20 22:05:47', '2022-07-21 09:46:53', NULL, 42066, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (93, '84000017', '09f10d69eefaa309d749fab28f90b588', 'murad', '', '192.168.137.2', '', '', '2022-07-20 22:05:47', '2022-07-20 22:05:47', '2022-07-21 09:46:53', NULL, 42066, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (94, '81100004', 'f38ed821f221d9361a5bdb38b01817e6', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-20 22:06:17', '2022-07-20 22:06:17', '2022-07-20 22:14:03', NULL, 466, 'RADIUS', '', '', 690384, 5342824, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'User-Request', 'Framed-User', 'PPP', '192.168.251.254'), (95, '80400001', '75a9b675805bc6bd5727e50137138393', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-20 22:17:25', '2022-07-20 22:17:25', '2022-07-20 22:21:45', NULL, 260, '', '', '', 8288, 187540, 'hotspot1', '08:00:27:76:3E:6C', 'Lost-Service', '', '', '192.168.250.221'), (96, '80400003', '8ce0addfcd54c5aa42f41518b46f472d', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-20 23:57:15', '2022-07-20 23:57:15', '2022-07-21 09:46:53', NULL, 35378, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'NAS-Reboot', '', '', '192.168.250.221'), (97, '81100005', '832393561e7a38d73578041967845c03', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-21 00:03:36', '2022-07-21 00:03:36', '2022-07-21 09:46:53', NULL, 34997, 'RADIUS', '', '', 0, 0, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'NAS-Reboot', 'Framed-User', 'PPP', '192.168.251.254'), (98, '80500001', 'df2a41b4232d01fb180e3bdc6c7466ab', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-21 10:39:10', '2022-07-21 10:39:10', '2022-07-21 12:31:39', NULL, 6749, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'NAS-Reboot', '', '', '192.168.250.221'), (99, '81200000', 'ac5032ca3722c2b86daccefb3dafd182', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-21 10:41:20', '2022-07-21 10:41:20', '2022-07-21 12:31:39', NULL, 6619, 'RADIUS', '', '', 0, 0, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'NAS-Reboot', 'Framed-User', 'PPP', '192.168.251.254'), (100, '80600001', '4a6a49fef2c839532ea6f314c7d07bad', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-21 12:31:42', '2022-07-21 12:31:42', '2022-07-21 12:41:06', NULL, 564, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'NAS-Reboot', '', '', '192.168.250.221'), (101, '81400000', 'bf75b565e3791d31bb6f4e920ed01613', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-21 12:43:05', '2022-07-21 12:43:05', '2022-07-21 18:43:41', NULL, 21636, 'RADIUS', '', '', 0, 0, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'NAS-Reboot', 'Framed-User', 'PPP', '192.168.251.254'), (108, '84000007', '7d4f543e73192697e76470c3fb4caf05', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-21 18:43:41', NULL, 21614, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (109, '84000008', '3223f1016d1bb91eb7e874e7cdfb1bd5', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-21 18:43:41', NULL, 21614, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (110, '84000009', 'f1413d72a606eba8f672ae09cc47e90c', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-21 18:43:41', NULL, 21614, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (111, '8400000a', '8bb13e93c6a2c9730989c7fb7f426e07', 'murad', '', '192.168.137.2', '', '', '2022-07-24 20:31:25', '2022-07-24 20:31:25', '2022-07-21 18:43:41', NULL, 21614, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (113, '80700001', 'd09a0794b5844f8c4748d10519ec1ec2', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-21 12:45:19', '2022-07-21 12:45:19', '2022-07-21 18:43:41', NULL, 21502, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'NAS-Reboot', '', '', '192.168.250.221'), (114, '81500000', '63c4fe2050b5c4c4e36b1efba9a6e5d5', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-21 18:46:33', '2022-07-21 18:46:33', '2022-07-21 18:50:22', NULL, 229, 'RADIUS', '', '', 23064, 92, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'User-Request', 'Framed-User', 'PPP', '192.168.251.254'), (115, '81500001', '117da13bb896e8b4e96d21724aec5cf1', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-21 18:50:26', '2022-07-21 18:50:26', '2022-07-21 22:44:18', NULL, 14032, 'RADIUS', '', '', 0, 0, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'NAS-Reboot', 'Framed-User', 'PPP', '192.168.251.254'), (116, '81600000', 'd00dd81e14f2d233022ed3c5eb0eb945', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-21 22:46:14', '2022-07-21 22:46:14', '2022-07-21 23:40:12', NULL, 3238, 'RADIUS', '', '', 2091161, 33205258, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'Lost-Carrier', 'Framed-User', 'PPP', '192.168.251.254'), (128, '80900001', '1ecf42c677d9913f30a8bd5f25a5cbeb', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-21 23:41:55', '2022-07-21 23:41:55', '2022-07-22 13:44:30', NULL, 50555, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'NAS-Reboot', '', '', '192.168.250.221'), (129, '80a00001', 'ff20cf309f91628ab1c7511fa3046d80', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-22 20:39:41', '2022-07-22 20:39:41', '2022-07-22 20:40:55', NULL, 74, '', '', '', 15822, 421938, 'hotspot1', '08:00:27:76:3E:6C', 'Admin-Reset', '', '', '192.168.250.221'), (130, '81700000', 'f29968fba0128170abeb44d5d49c0420', 'monir', '', '192.168.137.2', 'ether3', 'Ethernet', '2022-07-22 20:39:56', '2022-07-22 20:39:56', '2022-07-24 19:40:26', NULL, 169230, 'RADIUS', '', '', 0, 0, 'PPPoE_Server', '08:00:27:8E:CA:9C', 'NAS-Reboot', 'Framed-User', 'PPP', '192.168.251.254'), (131, '80a00002', '7f98f46cce380c92b97acbf1500b7da5', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-22 20:41:18', '2022-07-22 20:41:18', '2022-07-22 20:41:38', NULL, 20, '', '', '', 41, 52, 'hotspot1', '08:00:27:76:3E:6C', 'Admin-Reset', '', '', '192.168.250.221'), (132, '80a00003', '8c2c84959c0ea3084b1441d6c842be15', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-22 20:41:55', '2022-07-22 20:41:55', '2022-07-24 19:40:26', NULL, 169111, '', '', '', 0, 0, 'hotspot1', '08:00:27:76:3E:6C', 'NAS-Reboot', '', '', '192.168.250.221'), (133, '84000028', '5595b32c4ebe0146e42067048bd85226', 'murad', '', '192.168.137.2', '', '', '2022-07-22 20:42:41', '2022-07-22 20:42:41', '2022-07-24 19:40:26', NULL, 169065, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (134, '8400002d', 'df5ebb7726bd5070c22fb6a1fdab30f0', 'murad', '', '192.168.137.2', '', '', '2022-07-22 20:54:56', '2022-07-22 20:54:56', '2022-07-24 19:40:26', NULL, 168330, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (135, '8400002e', 'd4c98e796cc7ffd0665357f06458b450', 'murad', '', '192.168.137.2', '', '', '2022-07-22 20:56:47', '2022-07-22 20:56:47', '2022-07-24 19:40:26', NULL, 168219, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (136, '84000032', 'b6314b52a0bd2223a78cf97a6828aef7', 'murad', '', '192.168.137.2', '', '', '2022-07-22 21:00:15', '2022-07-22 21:00:15', '2022-07-24 19:40:26', NULL, 168011, '', '', '', 0, 0, '', '192.168.137.1', 'NAS-Reboot', 'Login-User', '', ''), (153, '80b00001', '1a63c49fea612010b174f6dcb52f4871', 'mamun', '', '192.168.137.2', 'ether2', 'Wireless-802.11', '2022-07-24 20:57:15', '2022-07-24 20:57:15', '2022-07-24 21:30:46', NULL, 2011, '', '', '', 19556, 4071, 'hotspot1', '08:00:27:76:3E:6C', 'Lost-Service', '', '', '192.168.250.221'); -- -------------------------------------------------------- -- -- Table structure for table `radcheck` -- CREATE TABLE `radcheck` ( `id` int(11) UNSIGNED NOT NULL, `username` varchar(64) NOT NULL DEFAULT '', `attribute` varchar(64) NOT NULL DEFAULT '', `op` char(2) NOT NULL DEFAULT '==', `value` varchar(253) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `radcheck` -- INSERT INTO `radcheck` (`id`, `username`, `attribute`, `op`, `value`) VALUES (1, 'murad', 'Cleartext-Password', ':=', '123456'), (2, 'mehtab', 'Cleartext-Password', ':=', '123456'), (3, 'mehtab', 'User-Profile', ':=', '2M_Profile'), (4, 'shawon', 'Cleartext-Password', ':=', '123456'), (5, 'shawon', 'User-Profile', ':=', '2M_Profile'), (6, 'shawon', 'Max-All-Session', ':=', '300'), (7, 'shawon', 'Access-Period', ':=', '360'), (8, 'mamun', 'Cleartext-Password', ':=', '123456'), (9, 'mamun', 'User-Profile', ':=', '2M_Profile'), (11, 'mamun', 'Mikrotik-Total-Limit', ':=', '150'), (12, 'monir', 'Cleartext-Password', ':=', '123456'), (13, 'monir', 'User-Profile', ':=', '5M_Profile'), (14, 'shawon', 'Cleartext-Password', ':=', '123456'), (15, 'shawon', 'User-Profile', ':=', '5M_Profile'); -- -------------------------------------------------------- -- -- Table structure for table `radgroupcheck` -- CREATE TABLE `radgroupcheck` ( `id` int(11) UNSIGNED NOT NULL, `groupname` varchar(64) NOT NULL DEFAULT '', `attribute` varchar(64) NOT NULL DEFAULT '', `op` char(2) NOT NULL DEFAULT '==', `value` varchar(253) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `radgroupcheck` -- INSERT INTO `radgroupcheck` (`id`, `groupname`, `attribute`, `op`, `value`) VALUES (1, '2M', 'Framed-Protocol', '==', 'PPP'), (2, '5M', 'Framed-Protocol', '==', 'PPP'); -- -------------------------------------------------------- -- -- Table structure for table `radgroupreply` -- CREATE TABLE `radgroupreply` ( `id` int(11) UNSIGNED NOT NULL, `groupname` varchar(64) NOT NULL DEFAULT '', `attribute` varchar(64) NOT NULL DEFAULT '', `op` char(2) NOT NULL DEFAULT '=', `value` varchar(253) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `radgroupreply` -- INSERT INTO `radgroupreply` (`id`, `groupname`, `attribute`, `op`, `value`) VALUES (1, '2M', 'Framed-Pool', '=', '2M_hpool'), (2, '2M', 'Mikrotik-Rate-Limit', '=', '2M/2M 4M/4M 2M/2M 40/40'), (3, '5M', 'Framed-Pool', '=', '5M_pppoe_pool'), (4, '5M', 'Mikrotik-Rate-Limit', '=', '5M/5M 10M/10M 5M/5M 40/40'); -- -------------------------------------------------------- -- -- Table structure for table `radpostauth` -- CREATE TABLE `radpostauth` ( `id` int(11) NOT NULL, `username` varchar(64) NOT NULL DEFAULT '', `pass` varchar(64) NOT NULL DEFAULT '', `reply` varchar(32) NOT NULL DEFAULT '', `authdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `radpostauth` -- INSERT INTO `radpostauth` (`id`, `username`, `pass`, `reply`, `authdate`) VALUES (1, 'bob', 'password', 'Access-Reject', '2022-07-18 17:26:46'), (2, 'bob', 'hello', 'Access-Reject', '2022-07-18 17:26:57'), (3, 'bob', 'password', 'Access-Reject', '2022-07-18 17:33:00'), (4, 'bob', 'hell0', 'Access-Reject', '2022-07-18 17:33:10'), (5, 'bob', 'hell0', 'Access-Reject', '2022-07-18 17:33:32'), (6, 'bob', 'hell0', 'Access-Reject', '2022-07-18 17:34:15'), (7, 'bob', 'password', 'Access-Reject', '2022-07-18 17:37:27'), (8, 'bob', 'hello', 'Access-Accept', '2022-07-18 17:37:34'), (9, 'murad', 'password', 'Access-Accept', '2022-07-18 17:38:39'), (10, 'murad', 'password', 'Access-Reject', '2022-07-18 17:40:28'), (11, 'murad', '123456', 'Access-Accept', '2022-07-18 17:40:42'), (12, 'bob', 'hello', 'Access-Accept', '2022-07-18 18:12:12'), (13, 'bob', '', 'Access-Accept', '2022-07-18 18:14:58'), (14, 'bob', '', 'Access-Accept', '2022-07-18 18:15:07'), (15, 'bob', '', 'Access-Accept', '2022-07-18 18:15:07'), (16, 'bob', '', 'Access-Accept', '2022-07-18 18:15:07'), (17, 'bob', '', 'Access-Accept', '2022-07-18 18:15:07'), (18, 'murad', '', 'Access-Accept', '2022-07-18 18:15:18'), (19, 'murad', '', 'Access-Accept', '2022-07-18 18:15:27'), (20, 'murad', '', 'Access-Accept', '2022-07-18 18:15:27'), (21, 'murad', '', 'Access-Accept', '2022-07-18 18:15:27'), (22, 'murad', '', 'Access-Accept', '2022-07-18 18:15:28'), (23, 'bob', 'hello', 'Access-Accept', '2022-07-19 02:57:05'), (24, 'murad', '123456', 'Access-Accept', '2022-07-19 02:57:17'), (25, 'murad', '123456', 'Access-Accept', '2022-07-19 03:00:31'), (26, 'murad', '123456', 'Access-Accept', '2022-07-19 03:02:41'), (27, 'murad', '123456', 'Access-Accept', '2022-07-19 03:04:47'), (28, 'murad', '123456', 'Access-Accept', '2022-07-19 03:05:35'), (29, 'bob', '', 'Access-Accept', '2022-07-19 06:41:27'), (30, 'bob', '', 'Access-Accept', '2022-07-19 06:41:27'), (31, 'bob', '', 'Access-Accept', '2022-07-19 06:41:27'), (32, 'bob', '', 'Access-Accept', '2022-07-19 06:41:27'), (33, 'bob', '', 'Access-Accept', '2022-07-19 06:41:27'), (34, 'murad', '', 'Access-Accept', '2022-07-19 06:42:40'), (35, 'murad', '', 'Access-Accept', '2022-07-19 06:42:41'), (36, 'murad', '', 'Access-Accept', '2022-07-19 06:42:41'), (37, 'murad', '', 'Access-Accept', '2022-07-19 06:42:41'), (38, 'murad', '', 'Access-Accept', '2022-07-19 06:42:41'), (39, 'murad', '', 'Access-Accept', '2022-07-19 06:52:53'), (40, 'murad', '', 'Access-Accept', '2022-07-19 06:52:53'), (41, 'murad', '', 'Access-Accept', '2022-07-19 06:52:53'), (42, 'murad', '', 'Access-Accept', '2022-07-19 06:52:53'), (43, 'murad', '', 'Access-Accept', '2022-07-19 06:52:53'), (44, 'bob', '', 'Access-Accept', '2022-07-19 06:53:02'), (45, 'bob', '', 'Access-Accept', '2022-07-19 06:53:02'), (46, 'bob', '', 'Access-Accept', '2022-07-19 06:53:02'), (47, 'bob', '', 'Access-Accept', '2022-07-19 06:53:02'), (48, 'bob', '', 'Access-Accept', '2022-07-19 06:53:02'), (49, 'shawon', '0xdee1a58c90b7c61e15fa3bf2ffc3d22e6c', 'Access-Reject', '2022-07-19 06:54:00'), (50, 'mehtab', '123456', 'Access-Accept', '2022-07-19 07:32:25'), (51, '08:00:27:82:76:C8', '', 'Access-Reject', '2022-07-19 07:39:33'), (52, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 07:39:36'), (53, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-19 07:39:36'), (54, 'mehtab', '0f6bb7e33378057ac1306b19766ef6c3', 'Access-Reject', '2022-07-19 07:39:49'), (55, 'mehtab', '0x1e651584e43d7e6731e20e5ea04c065044', 'Access-Accept', '2022-07-19 07:39:55'), (56, 'murad', '', 'Access-Accept', '2022-07-19 07:40:04'), (57, 'murad', '', 'Access-Accept', '2022-07-19 07:40:04'), (58, 'murad', '', 'Access-Accept', '2022-07-19 07:40:04'), (59, 'murad', '', 'Access-Accept', '2022-07-19 07:40:04'), (60, 'murad', '', 'Access-Accept', '2022-07-19 07:40:04'), (61, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 07:46:02'), (62, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 08:02:02'), (63, 'murad', '', 'Access-Accept', '2022-07-19 09:33:08'), (64, '08:00:27:76:3E:6C', '0xb7', 'Access-Reject', '2022-07-19 09:33:09'), (65, 'murad', '', 'Access-Accept', '2022-07-19 09:33:09'), (66, 'murad', '', 'Access-Accept', '2022-07-19 09:33:09'), (67, 'murad', '', 'Access-Accept', '2022-07-19 09:33:09'), (68, 'murad', '', 'Access-Accept', '2022-07-19 09:33:09'), (69, 'shawon', '0xb7fb87d5918a9159442829845d044b855e', 'Access-Accept', '2022-07-19 09:33:25'), (70, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:34:45'), (71, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:34:47'), (72, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:38:22'), (73, 'shawon', '0xb7fb87d5918a9159442829845d044b855e', 'Access-Reject', '2022-07-19 09:38:26'), (74, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:38:30'), (75, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:38:31'), (76, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:39:35'), (77, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:39:36'), (78, '08:00:27:82:76:C8', '', 'Access-Reject', '2022-07-19 09:57:49'), (79, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:57:49'), (80, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-19 09:57:50'), (81, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:57:50'), (82, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:58:48'), (83, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:58:49'), (84, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:58:50'), (85, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:58:51'), (86, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:59:03'), (87, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 09:59:04'), (88, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-19 09:59:05'), (89, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:02:00'), (90, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:02:01'), (91, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:07:31'), (92, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:07:33'), (93, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:07:35'), (94, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-19 10:10:01'), (95, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:10:01'), (96, 'mamun', '702ad510d6d46f45428a621b7c7e2c2b', 'Access-Reject', '2022-07-19 10:10:02'), (97, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:10:03'), (98, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:10:04'), (99, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:10:05'), (100, 'mamun', '0x853711c9c83ac5a4d69a1a24b437b71c30', 'Access-Accept', '2022-07-19 10:10:09'), (101, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:10:13'), (102, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:11:27'), (103, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:11:28'), (104, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:11:31'), (105, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 10:11:46'), (106, 'murad', '123456', 'Access-Accept', '2022-07-19 10:15:41'), (107, 'mamun', '123456', 'Access-Reject', '2022-07-19 10:15:56'), (108, 'mamun', '123456', 'Access-Reject', '2022-07-19 10:16:57'), (109, 'mamun', '123456', 'Access-Reject', '2022-07-19 10:23:51'), (110, 'mamun', '123456', 'Access-Accept', '2022-07-19 10:24:01'), (111, 'mamun', '123456', 'Access-Accept', '2022-07-19 10:41:05'), (112, 'murad', '123456', 'Access-Accept', '2022-07-19 11:01:23'), (113, 'mamun', '123456', 'Access-Accept', '2022-07-19 11:01:33'), (114, 'murad', '', 'Access-Accept', '2022-07-19 11:06:00'), (115, 'murad', '', 'Access-Accept', '2022-07-19 11:06:00'), (116, 'murad', '', 'Access-Accept', '2022-07-19 11:06:00'), (117, 'murad', '', 'Access-Accept', '2022-07-19 11:06:00'), (118, 'murad', '', 'Access-Accept', '2022-07-19 11:06:00'), (119, '08:00:27:82:76:C8', '', 'Access-Reject', '2022-07-19 11:06:00'), (120, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:01'), (121, '0A:00:27:00:00:11', '', 'Access-Reject', '2022-07-19 11:06:01'), (122, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:06'), (123, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:14'), (124, 'T-08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-19 11:06:15'), (125, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:17'), (126, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:21'), (127, 'mamun', '0xd40432c2ce9f052a8a20269525ec1f4bbb', 'Access-Accept', '2022-07-19 11:06:24'), (128, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:24'), (129, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:29'), (130, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:31'), (131, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:37'), (132, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:38'), (133, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:39'), (134, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:44'), (135, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:46'), (136, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:47'), (137, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:56'), (138, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:06:57'), (139, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:00'), (140, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:01'), (141, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:04'), (142, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:08'), (143, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:10'), (144, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:16'), (145, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:17'), (146, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:21'), (147, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:22'), (148, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:25'), (149, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:28'), (150, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:29'), (151, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:32'), (152, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:36'), (153, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:37'), (154, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:39'), (155, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:41'), (156, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:42'), (157, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:43'), (158, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:47'), (159, '0A:00:27:00:00:11', '', 'Access-Reject', '2022-07-19 11:07:48'), (160, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:49'), (161, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:50'), (162, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:55'), (163, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:07:56'), (164, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:08:01'), (165, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:08:02'), (166, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:08:16'), (167, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:08:20'), (168, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:08:43'), (169, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:08:48'), (170, 'murad', '', 'Access-Accept', '2022-07-19 11:09:06'), (171, 'murad', '', 'Access-Accept', '2022-07-19 11:09:06'), (172, 'murad', '', 'Access-Accept', '2022-07-19 11:09:06'), (173, 'murad', '', 'Access-Accept', '2022-07-19 11:09:06'), (174, 'murad', '', 'Access-Accept', '2022-07-19 11:09:06'), (175, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:09:35'), (176, 'mamun', '123456', 'Access-Accept', '2022-07-19 11:10:14'), (177, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:10:21'), (178, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:10:23'), (179, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:10:26'), (180, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:10:53'), (181, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:10:54'), (182, 'mamun', '123456', 'Access-Accept', '2022-07-19 11:10:55'), (183, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:10:55'), (184, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 11:11:26'), (185, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:11:32'), (186, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:11:34'), (187, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:11:36'), (188, 'mamun', '123456', 'Access-Accept', '2022-07-19 11:11:43'), (189, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:11:57'), (190, 'mamun', '123456', 'Access-Accept', '2022-07-19 11:12:38'), (191, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 11:12:47'), (192, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:13:00'), (193, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:13:02'), (194, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:13:03'), (195, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 11:13:07'), (196, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 11:13:08'), (197, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 11:13:41'), (198, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:13:50'), (199, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:13:52'), (200, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:14:11'), (201, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:14:40'), (202, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:14:42'), (203, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:14:43'), (204, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:14:48'), (205, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:14:49'), (206, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:14:58'), (207, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:15:08'), (208, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:15:10'), (209, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:15:12'), (210, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:15:42'), (211, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:03'), (212, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:04'), (213, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:06'), (214, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:07'), (215, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:08'), (216, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:09'), (217, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:17'), (218, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:25'), (219, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:26'), (220, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:32'), (221, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:49'), (222, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:51'), (223, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:52'), (224, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:54'), (225, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:55'), (226, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:57'), (227, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:16:59'), (228, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:00'), (229, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:01'), (230, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:06'), (231, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:14'), (232, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:15'), (233, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:16'), (234, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:31'), (235, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:32'), (236, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:33'), (237, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:35'), (238, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:36'), (239, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:37'), (240, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:40'), (241, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:41'), (242, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:43'), (243, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:44'), (244, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:17:45'), (245, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 11:18:37'), (246, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:18:55'), (247, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:18:57'), (248, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:01'), (249, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:02'), (250, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:04'), (251, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:05'), (252, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:08'), (253, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:10'), (254, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:24'), (255, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:25'), (256, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:26'), (257, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:31'), (258, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:32'), (259, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:40'), (260, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:41'), (261, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:42'), (262, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:43'), (263, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:45'), (264, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:47'), (265, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:50'), (266, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:19:57'), (267, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:20:00'), (268, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:20:09'), (269, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:20:15'), (270, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:20:16'), (271, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:20:18'), (272, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:20:57'), (273, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 11:20:58'), (274, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:20:59'), (275, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:01'), (276, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:14'), (277, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:15'), (278, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:16'), (279, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:17'), (280, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:18'), (281, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:20'), (282, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:24'), (283, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:25'), (284, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:27'), (285, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:28'), (286, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:29'), (287, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:30'), (288, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:32'), (289, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:33'), (290, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:34'), (291, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:36'), (292, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:37'), (293, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:38'), (294, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:46'), (295, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:47'), (296, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:49'), (297, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:50'), (298, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:51'), (299, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:54'), (300, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:55'), (301, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:21:56'), (302, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:22:22'), (303, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:22:24'), (304, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:22:27'), (305, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:22:39'), (306, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:22:58'), (307, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:22:59'), (308, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:01'), (309, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:05'), (310, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:08'), (311, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:09'), (312, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:10'), (313, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:12'), (314, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:19'), (315, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:20'), (316, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:22'), (317, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:26'), (318, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:29'), (319, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:30'), (320, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:32'), (321, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:33'), (322, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:34'), (323, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:35'), (324, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:38'), (325, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:40'), (326, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:48'), (327, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:49'), (328, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:53'), (329, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:23:56'), (330, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:14'), (331, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:15'), (332, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:17'), (333, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:19'), (334, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:20'), (335, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:21'), (336, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:23'), (337, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:24'), (338, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:25'), (339, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:27'), (340, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:28'), (341, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:24:55'), (342, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:25:01'), (343, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:25:02'), (344, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 11:25:03'), (345, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 16:32:11'), (346, '08:00:27:8E:CA:9C', '', 'Access-Reject', '2022-07-19 16:32:12'), (347, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 16:32:12'), (348, 'mamun', '', 'Access-Reject', '2022-07-19 16:34:32'), (349, 'mamun', '', 'Access-Reject', '2022-07-19 16:35:33'), (350, 'mamun', '', 'Access-Reject', '2022-07-19 16:36:34'), (351, 'mamun', '', 'Access-Reject', '2022-07-19 16:37:35'), (352, 'monir', '', 'Access-Reject', '2022-07-19 16:38:33'), (353, 'bob', '', 'Access-Accept', '2022-07-19 16:38:39'), (354, 'bob', '', 'Access-Accept', '2022-07-19 16:38:39'), (355, 'bob', '', 'Access-Accept', '2022-07-19 16:38:39'), (356, 'bob', '', 'Access-Accept', '2022-07-19 16:38:40'), (357, 'bob', '', 'Access-Accept', '2022-07-19 16:38:40'), (358, 'monir', '', 'Access-Reject', '2022-07-19 16:38:51'), (359, 'monir', '', 'Access-Reject', '2022-07-19 16:39:28'), (360, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 16:39:51'), (361, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 16:39:53'), (362, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 16:40:08'), (363, 'monir', '', 'Access-Reject', '2022-07-19 16:42:14'), (364, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 16:43:05'), (365, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 16:43:05'), (366, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 16:43:06'), (367, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 16:43:07'), (368, 'monir', '', 'Access-Reject', '2022-07-19 16:43:16'), (369, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 16:53:41'), (370, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 16:53:43'), (371, 'murad', '', 'Access-Accept', '2022-07-19 16:53:44'), (372, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 16:57:26'), (373, '08:00:27:38:CB:08', '', 'Access-Reject', '2022-07-19 17:05:06'), (374, 'murad', '', 'Access-Accept', '2022-07-19 17:13:44'), (375, 'murad', '', 'Access-Accept', '2022-07-19 17:13:44'), (376, 'murad', '', 'Access-Accept', '2022-07-19 17:13:44'), (377, 'murad', '', 'Access-Accept', '2022-07-19 17:13:44'), (378, 'murad', '', 'Access-Accept', '2022-07-19 17:13:44'), (379, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-19 17:13:56'), (380, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 17:14:16'), (381, 'monir', '', 'Access-Reject', '2022-07-19 17:14:39'), (382, 'monir', '', 'Access-Reject', '2022-07-19 17:15:01'), (383, 'mamun', '123456', 'Access-Accept', '2022-07-19 17:16:00'), (384, 'monir', '', 'Access-Reject', '2022-07-19 17:16:02'), (385, 'monir', '123456', 'Access-Accept', '2022-07-19 17:16:07'), (386, 'monir', '', 'Access-Reject', '2022-07-19 17:17:03'), (387, 'monir', '', 'Access-Reject', '2022-07-19 17:17:06'), (388, 'monir', '', 'Access-Accept', '2022-07-19 17:18:33'), (389, 'murad', '', 'Access-Accept', '2022-07-19 17:31:42'), (390, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-19 17:40:14'), (391, 'monir', '', 'Access-Accept', '2022-07-19 23:30:18'), (392, 'monir', '', 'Access-Accept', '2022-07-20 09:59:43'), (393, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-20 10:04:35'), (394, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-20 10:04:43'), (395, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-20 10:05:13'), (396, 'monir', '', 'Access-Accept', '2022-07-20 10:18:53'), (397, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-20 10:53:15'), (398, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-20 10:53:32'), (399, 'monir', '', 'Access-Accept', '2022-07-20 11:04:27'), (400, 'monir', '', 'Access-Accept', '2022-07-20 11:39:58'), (401, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-20 11:41:54'), (402, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-20 11:41:56'), (403, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-20 11:44:31'), (404, 'shawon', '', 'Access-Reject', '2022-07-20 11:55:18'), (405, 'shawon', '', 'Access-Reject', '2022-07-20 11:56:19'), (406, 'shawon', '', 'Access-Reject', '2022-07-20 11:57:20'), (407, 'shawon', '', 'Access-Reject', '2022-07-20 11:58:21'), (408, 'shawon', '', 'Access-Reject', '2022-07-20 12:04:07'), (409, 'mamun', '0xff02998d0698bbfd3a4136478eda0263ca', 'Access-Accept', '2022-07-20 12:04:20'), (410, 'shawon', '', 'Access-Reject', '2022-07-20 16:03:40'), (411, 'shawon', '', 'Access-Reject', '2022-07-20 16:04:46'), (412, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (413, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (414, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (415, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (416, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (417, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (418, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (419, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (420, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (421, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (422, 'murad', '', 'Access-Accept', '2022-07-20 16:05:47'), (423, 'shawon', '', 'Access-Reject', '2022-07-20 16:05:48'), (424, 'shawon', '', 'Access-Reject', '2022-07-20 16:06:03'), (425, 'monir', '', 'Access-Accept', '2022-07-20 16:06:14'), (426, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-20 16:16:58'), (427, 'mamun', '0xcedb8065af1642426ab4816c6576432b2a', 'Access-Accept', '2022-07-20 16:17:21'), (428, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-20 17:48:36'), (429, 'mamun', '0xcedb8065af1642426ab4816c6576432b2a', 'Access-Accept', '2022-07-20 17:57:11'), (430, 'monir', '', 'Access-Accept', '2022-07-20 18:03:33'), (431, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-21 04:39:05'), (432, 'mamun', '0xcedb8065af1642426ab4816c6576432b2a', 'Access-Accept', '2022-07-21 04:39:07'), (433, 'monir', '', 'Access-Accept', '2022-07-21 04:41:17'), (434, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-21 06:31:38'), (435, 'mamun', '0xcedb8065af1642426ab4816c6576432b2a', 'Access-Accept', '2022-07-21 06:31:39'), (436, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-21 06:42:05'), (437, 'monir', '', 'Access-Accept', '2022-07-21 06:43:02'), (438, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (439, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (440, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (441, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (442, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (443, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (444, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (445, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (446, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (447, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (448, 'murad', '', 'Access-Accept', '2022-07-21 06:43:27'), (449, 'mamun', '0xcedb8065af1642426ab4816c6576432b2a', 'Access-Accept', '2022-07-21 06:45:16'), (450, 'monir', '', 'Access-Accept', '2022-07-21 12:46:28'), (451, 'monir', '', 'Access-Accept', '2022-07-21 12:50:22'), (452, 'monir', '', 'Access-Accept', '2022-07-21 16:46:12'), (453, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (454, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (455, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (456, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (457, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (458, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (459, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (460, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (461, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (462, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (463, 'murad', '', 'Access-Accept', '2022-07-21 16:54:22'), (464, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-21 17:40:36'), (465, 'mamun', '0xcedb8065af1642426ab4816c6576432b2a', 'Access-Accept', '2022-07-21 17:41:53'), (466, 'murad', '', 'Access-Accept', '2022-07-22 10:49:50'), (467, 'murad', '', 'Access-Accept', '2022-07-22 10:49:50'), (468, 'murad', '', 'Access-Accept', '2022-07-22 10:49:50'), (469, 'murad', '', 'Access-Accept', '2022-07-22 10:49:50'), (470, 'murad', '', 'Access-Accept', '2022-07-22 10:49:51'), (471, 'murad', '', 'Access-Accept', '2022-07-22 10:49:51'), (472, 'murad', '', 'Access-Accept', '2022-07-22 10:49:51'), (473, 'murad', '', 'Access-Accept', '2022-07-22 10:49:51'), (474, 'murad', '', 'Access-Accept', '2022-07-22 10:49:51'), (475, 'murad', '', 'Access-Accept', '2022-07-22 10:49:51'), (476, 'murad', '', 'Access-Accept', '2022-07-22 10:49:51'), (477, 'murad', '', 'Access-Accept', '2022-07-22 11:15:10'), (478, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-22 14:31:44'), (479, 'mamun', '0xcedb8065af1642426ab4816c6576432b2a', 'Access-Accept', '2022-07-22 14:39:38'), (480, 'monir', '', 'Access-Accept', '2022-07-22 14:39:53'), (481, 'mamun', '0xcedb8065af1642426ab4816c6576432b2a', 'Access-Accept', '2022-07-22 14:41:15'), (482, 'mamun', '0xcedb8065af1642426ab4816c6576432b2a', 'Access-Accept', '2022-07-22 14:41:52'), (483, 'murad', '', 'Access-Accept', '2022-07-22 14:42:41'), (484, 'murad', '', 'Access-Accept', '2022-07-22 14:54:56'), (485, 'murad', '', 'Access-Accept', '2022-07-22 14:56:47'), (486, 'murad', '', 'Access-Accept', '2022-07-22 15:00:15'), (487, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (488, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (489, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (490, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (491, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (492, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (493, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (494, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (495, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (496, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (497, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (498, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (499, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (500, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (501, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (502, 'murad', '', 'Access-Accept', '2022-07-24 14:31:25'), (503, '08:00:27:76:3E:6C', '', 'Access-Reject', '2022-07-24 14:56:06'), (504, 'mamun', '0xcedb8065af1642426ab4816c6576432b2a', 'Access-Accept', '2022-07-24 14:57:11'); -- -------------------------------------------------------- -- -- Table structure for table `radreply` -- CREATE TABLE `radreply` ( `id` int(11) UNSIGNED NOT NULL, `username` varchar(64) NOT NULL DEFAULT '', `attribute` varchar(64) NOT NULL DEFAULT '', `op` char(2) NOT NULL DEFAULT '=', `value` varchar(253) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `radreply` -- INSERT INTO `radreply` (`id`, `username`, `attribute`, `op`, `value`) VALUES (1, 'murad', 'MikroTik-Group', ':=', 'full'); -- -------------------------------------------------------- -- -- Table structure for table `radusergroup` -- CREATE TABLE `radusergroup` ( `username` varchar(64) NOT NULL DEFAULT '', `groupname` varchar(64) NOT NULL DEFAULT '', `priority` int(11) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `radusergroup` -- INSERT INTO `radusergroup` (`username`, `groupname`, `priority`) VALUES ('2M_Profile', '2M', 10), ('5M_Profile', '5M', 10); -- -- Indexes for dumped tables -- -- -- Indexes for table `nas` -- ALTER TABLE `nas` ADD PRIMARY KEY (`id`), ADD KEY `nasname` (`nasname`); -- -- Indexes for table `radacct` -- ALTER TABLE `radacct` ADD PRIMARY KEY (`radacctid`), ADD UNIQUE KEY `acctuniqueid` (`acctuniqueid`), ADD KEY `username` (`username`), ADD KEY `framedipaddress` (`framedipaddress`), ADD KEY `acctsessionid` (`acctsessionid`), ADD KEY `acctsessiontime` (`acctsessiontime`), ADD KEY `acctstarttime` (`acctstarttime`), ADD KEY `acctinterval` (`acctinterval`), ADD KEY `acctstoptime` (`acctstoptime`), ADD KEY `nasipaddress` (`nasipaddress`); -- -- Indexes for table `radcheck` -- ALTER TABLE `radcheck` ADD PRIMARY KEY (`id`), ADD KEY `username` (`username`(32)); -- -- Indexes for table `radgroupcheck` -- ALTER TABLE `radgroupcheck` ADD PRIMARY KEY (`id`), ADD KEY `groupname` (`groupname`(32)); -- -- Indexes for table `radgroupreply` -- ALTER TABLE `radgroupreply` ADD PRIMARY KEY (`id`), ADD KEY `groupname` (`groupname`(32)); -- -- Indexes for table `radpostauth` -- ALTER TABLE `radpostauth` ADD PRIMARY KEY (`id`); -- -- Indexes for table `radreply` -- ALTER TABLE `radreply` ADD PRIMARY KEY (`id`), ADD KEY `username` (`username`(32)); -- -- Indexes for table `radusergroup` -- ALTER TABLE `radusergroup` ADD KEY `username` (`username`(32)); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `nas` -- ALTER TABLE `nas` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `radacct` -- ALTER TABLE `radacct` MODIFY `radacctid` bigint(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=154; -- -- AUTO_INCREMENT for table `radcheck` -- ALTER TABLE `radcheck` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `radgroupcheck` -- ALTER TABLE `radgroupcheck` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `radgroupreply` -- ALTER TABLE `radgroupreply` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `radpostauth` -- ALTER TABLE `radpostauth` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=505; -- -- AUTO_INCREMENT for table `radreply` -- ALTER TABLE `radreply` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;