BiTel

Информация о версии:

  Клиент: вер. 6.1.842 / 31.03.2015 18:02:43
    os: Windows 8.1; java: Java HotSpot(TM) 64-Bit Server VM, v.1.7.0_65
  Сервер: вер. 6.1.1059 / 01.04.2015 17:20:44
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.7.0_60

  bill: вер. 6.1.257 / 20.03.2015 15:47:58
  card: вер. 6.1.205 / 11.03.2015 20:02:46
  inet: вер. 6.1.683 / 01.04.2015 17:21:10
    ВНИМАНИЕ: клиентская версия: 6.1.685 / 03.04.2015 15:11:32
  npay: вер. 6.1.187 / 18.03.2015 18:27:11
    ВНИМАНИЕ: клиентская версия: 6.1.189 / 03.04.2015 15:11:33
  phone: вер. 6.1.250 / 23.03.2015 19:26:46
  reports: вер. 6.1.199 / 30.03.2015 17:25:55
  rscm: вер. 6.1.173 / 24.03.2015 17:34:55

04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] RadiusListenerWorker - REQUEST:
Packet type: Access-Request
Identifier: 246
Authenticator: {B1 61 7F 51 77 CE 44 43 F5 90 80 F3 F7 1D F2 A4}
Attributes:
  User-Name=758
  NAS-Port-Id=2/15 vlan-id 131 pppoe 1167
  NAS-Identifier=RedBack
  CHAP-Password={01 7F E8 E4 23 E9 BD 2F 95 E2 66 1A 44 F2 A5 B7 BC}
  NAS-IP-Address=172.16.0.4
  NAS-Port=788530319
  Service-Type=2
  Framed-Protocol=1
  NAS-Port-Type=5
  CHAP-Challenge= a.Qw DC     .
  Platform-Type=4
  Medium-Type=11
  OS-Version=12.1.1.5p2
  Mac-Addr=30-b5-c2-8a-46-69
  NAS-Real-Port=788529283

04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetNas - Search by username=758
04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetRadiusProcessor - [username=758] Authenticated as inetServId:780
04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetApplication - TariffOptionMap: {}
04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetApplication - inetServ[id=780] balance ok: -300.00 [-2000.00]
04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetApplication - OptionSet: [5, 10]
04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetRadiusProcessor - Not found free IP-address in serv
04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetRadiusProcessor - Set ip from pool
04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetRadiusProcessor - Write new waiting connection to DB
04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetRadiusProcessor - New connection id=4463600
04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetRadiusProcessor - Return code=0
04-22/17:13:56  INFO [rdsLstnr-p-8-t-8] InetRadiusListenerWorker - RESPONSE:

Информация о версии:

Клиент: вер. 6.1.740 / 18.06.2014 14:18:26
os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.7.0_65
Сервер: вер. 6.1.908 / 18.06.2014 16:01:14
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.7.0_60

bill: вер. 6.1.247 / 18.06.2014 14:18:24
card: вер. 6.1.198 / 18.06.2014 14:18:25
inet: вер. 6.1.543 / 16.06.2014 15:41:34
npay: вер. 6.1.172 / 23.04.2014 15:37:50
phone: вер. 6.1.235 / 18.06.2014 14:18:44
reports: вер. 6.1.178 / 14.05.2014 16:07:03
rscm: вер. 6.1.167 / 14.04.2014 12:46:03

radius 05-12/13:34:07 ERROR [rdsLstnr-p-8-t-10] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:07 ERROR [rdsLstnr-p-8-t-10] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:07 ERROR [rdsLstnr-p-8-t-1] IpResourceReserveManager - Skip batch reserve for IP-addresses due to almost empty pull.
radius 05-12/13:34:07 ERROR [rdsLstnr-p-8-t-1] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:07 ERROR [rdsLstnr-p-8-t-1] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:08 ERROR [rdsLstnr-p-8-t-2] IpResourceReserveManager - Skip batch reserve for IP-addresses due to almost empty pull.
radius 05-12/13:34:08 ERROR [rdsLstnr-p-8-t-2] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:08 ERROR [rdsLstnr-p-8-t-2] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:10 ERROR [rdsLstnr-p-8-t-4] IpResourceReserveManager - Skip batch reserve for IP-addresses due to almost empty pull.
radius 05-12/13:34:10 ERROR [rdsLstnr-p-8-t-4] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:10 ERROR [rdsLstnr-p-8-t-4] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:16 ERROR [rdsLstnr-p-8-t-9] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:16 ERROR [rdsLstnr-p-8-t-9] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:21 ERROR [rdsLstnr-p-8-t-7] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:21 ERROR [rdsLstnr-p-8-t-7] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:24 ERROR [rdsLstnr-p-8-t-5] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:24 ERROR [rdsLstnr-p-8-t-5] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:25 ERROR [rdsLstnr-p-8-t-8] IpResourceReserveManager - Skip batch reserve for IP-addresses due to almost empty pull.
radius 05-12/13:34:25 ERROR [rdsLstnr-p-8-t-8] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:25 ERROR [rdsLstnr-p-8-t-8] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:25 ERROR [rdsLstnr-p-8-t-6] IpResourceReserveManager - Skip batch reserve for IP-addresses due to almost empty pull.
radius 05-12/13:34:25 ERROR [rdsLstnr-p-8-t-6] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:25 ERROR [rdsLstnr-p-8-t-6] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:32 ERROR [rdsLstnr-p-8-t-3] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:32 ERROR [rdsLstnr-p-8-t-3] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:32 ERROR [rdsLstnr-p-8-t-10] IpResourceReserveManager - Skip batch reserve for IP-addresses due to almost empty pull.
radius 05-12/13:34:32 ERROR [rdsLstnr-p-8-t-10] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:32 ERROR [rdsLstnr-p-8-t-10] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:41 ERROR [rdsLstnr-p-8-t-2] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:41 ERROR [rdsLstnr-p-8-t-2] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:42 ERROR [rdsLstnr-p-8-t-4] IpResourceReserveManager - Skip batch reserve for IP-addresses due to almost empty pull.
radius 05-12/13:34:42 ERROR [rdsLstnr-p-8-t-4] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:42 ERROR [rdsLstnr-p-8-t-4] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:43 ERROR [rdsLstnr-p-8-t-9] IpResourceReserveManager - Skip batch reserve for IP-addresses due to almost empty pull.
radius 05-12/13:34:43 ERROR [rdsLstnr-p-8-t-9] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:43 ERROR [rdsLstnr-p-8-t-9] InetRadiusProcessor - Can't reserve ip address!
radius 05-12/13:34:44 ERROR [rdsLstnr-p-8-t-7] IpResourceReserveManager - Skip batch reserve for IP-addresses due to almost empty pull.
radius 05-12/13:34:44 ERROR [rdsLstnr-p-8-t-7] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
radius 05-12/13:34:44 ERROR [rdsLstnr-p-8-t-7] InetRadiusProcessor - Can't reserve ip address!

05-12/13:34:44  INFO [rdsLstnr-p-8-t-7] RadiusListenerWorker - REQUEST:
Packet type: Access-Request
Identifier: 73
Authenticator: {AE F5 29 85 1F 2E 03 25 68 61 37 A8 4B 80 A9 9D}
Attributes:
  User-Name=194
  NAS-Port-Id=2/15 vlan-id 121 pppoe 3138
  NAS-Identifier=RedBack
  CHAP-Password={01 0A 84 C0 9E 71 24 99 FD C0 7C 9D F6 A3 65 A4 87}
  NAS-IP-Address=172.16.0.4
  NAS-Port=788532290
  Service-Type=2
  Framed-Protocol=1
  NAS-Port-Type=5
  CHAP-Challenge=  ) .%ha7 K   
  Platform-Type=4
  Medium-Type=11
  OS-Version=12.1.1.5p2
  Mac-Addr=1c-7e-e5-8e-86-2f
  NAS-Real-Port=788529273

05-12/13:34:44  INFO [rdsLstnr-p-8-t-7] InetNas - Search by username=194
05-12/13:34:44  INFO [rdsLstnr-p-8-t-7] InetRadiusProcessor - [username=194] Authenticated as inetServId:207
05-12/13:34:44  INFO [rdsLstnr-p-8-t-7] InetApplication - inetServ[id=207] contract status not active.
05-12/13:34:44 ERROR [rdsLstnr-p-8-t-7] IpResourceReserveManager - Skip batch reserve for IP-addresses due to almost empty pull.
05-12/13:34:44 ERROR [rdsLstnr-p-8-t-7] InetNas - Can't reserve ip address for inetNas:4 and realm: disable!
05-12/13:34:44 ERROR [rdsLstnr-p-8-t-7] InetRadiusProcessor - Can't reserve ip address!
05-12/13:34:44  INFO [rdsLstnr-p-8-t-7] InetRadiusProcessor - Return code=80
05-12/13:34:44  INFO [rdsLstnr-p-8-t-7] InetRadiusListenerWorker - RESPONSE:
Packet type: Access-Reject
Identifier: 73
Authenticator: {97 C3 10 7E 16 56 71 D2 E6 7E 7F 10 08 C6 1D CF}
Attributes:
  Reply-Message=80

Process time auth: 2

SELECT INET_NTOA(CONV(HEX(s.address), 16, 10)), s.* FROM inv_ip_resource_subscription_dyn_<mid>_201505 as s
LEFT JOIN inet_connection_<mid> as c ON s.ipResourceId=c.ipResourceId AND s.address=c.ipAddress AND c.status=1
WHERE s.timeTo IS NULL AND c.id IS NULL