Тариф:
Вложение:
cto.png [ 28.24 КБ | Просмотров: 9212 ]
Договор:
Вложение:
cto-cid.png [ 34.61 КБ | Просмотров: 9212 ]
Вот при авторизации в логах access'а:
Код:
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] RadiusProcessor - Create new radius session.
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetNas - Search by username=9241252075
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetRadiusProcessor - [username=9241252075] Authenticated as inetServId:23311
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] InetNas - agentRemoteId=null
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] InetRadiusProcessor - Identifier from request: null
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] InetRadiusProcessor - MAC-address from request:
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetApplication - contract tariffOptions: {23=cto: 13337-23: 24.09.2017 23:19:04.0 - null}
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] TrafficRangeManager - Add to RangeKey[1752346675708:5:13337] 0 (50267703, 104857600)
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] TrafficRangeManager - Add to RangeKey[1752346675728:5:13337] 0 (18546835, 104857600)
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetApplication - inetServ[id=23311] balance ok: 0.00 [0]
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetApplication - OptionSet: []
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetRadiusProcessor - Write new waiting connection to DB
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetRadiusProcessor - New connection id=14273659
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetRadiusProcessor - Return code=0
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetConnectionKeyMap - Put auth accept 172.20.0.76
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetRadiusProcessor - RESPONSE_BEFORE_POSTPROCESS:
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetNas - Search by username=9241252075
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetRadiusProcessor - [username=9241252075] Authenticated as inetServId:23311
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] InetNas - agentRemoteId=null
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] InetRadiusProcessor - Identifier from request: null
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] InetRadiusProcessor - MAC-address from request:
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetApplication - contract tariffOptions: {23=cto: 13337-23: 24.09.2017 23:19:04.0 - null}
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] TrafficRangeManager - Add to RangeKey[1752346675708:5:13337] 0 (50267703, 104857600)
10-17/23:03:22 DEBUG [rdsLstnr-p-8-t-179] TrafficRangeManager - Add to RangeKey[1752346675728:5:13337] 0 (18546835, 104857600)
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetApplication - inetServ[id=23311] balance ok: 0.00 [0]
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetApplication - OptionSet: []
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetRadiusProcessor - Write new waiting connection to DB
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetRadiusProcessor - New connection id=14273659
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetRadiusProcessor - Return code=0
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetConnectionKeyMap - Put auth accept 172.20.0.76
10-17/23:03:22 INFO [rdsLstnr-p-8-t-179] InetRadiusProcessor - RESPONSE_BEFORE_POSTPROCESS:
А вот запрос:
Код:
select `tr`.`contractId` AS `contractId`,`tr`.`treeNodeId` AS `treeNodeId`,
((`tr`.`treeNodeId` & 0xffffffff00000000) >> 32) AS `treeId`,
(`tr`.`treeNodeId` & 0xffffffff) AS `nodeId`,
`tr`.`rangeKey` AS `rangeKey`,
(`tr`.`rangeKey` & 0xffffffffffffff) AS `ctoId`,
(`tr`.`rangeKey` >> 56) AS `modeId`,`tr`.`amount` AS `amount`,
`tr`.`counter` AS `counter`,`tr`.`maxAmount` AS `maxAmount`,`tr`.`yy` AS `yy`,`tr`.`mm` AS `mm`
from inet_tariff_traffic_range_1 tr
where contractId=12464 and rangeKey=(13337 | 0x100000000000000 | (4 << 56))
((`tr`.`treeNodeId` & 0xffffffff00000000) >> 32) AS `treeId`,
(`tr`.`treeNodeId` & 0xffffffff) AS `nodeId`,
`tr`.`rangeKey` AS `rangeKey`,
(`tr`.`rangeKey` & 0xffffffffffffff) AS `ctoId`,
(`tr`.`rangeKey` >> 56) AS `modeId`,`tr`.`amount` AS `amount`,
`tr`.`counter` AS `counter`,`tr`.`maxAmount` AS `maxAmount`,`tr`.`yy` AS `yy`,`tr`.`mm` AS `mm`
from inet_tariff_traffic_range_1 tr
where contractId=12464 and rangeKey=(13337 | 0x100000000000000 | (4 << 56))
И его результат:
Вложение:
cto-sql.png [ 15.45 КБ | Просмотров: 9212 ]
Т.е. как-будто за 9-й месяц траф не добавляется.
В данном примере суммарный трафик не превысил еще ограничение, просто сейчас нет живого примера с превышением.
BG 7.0
