API tools faq
paste
Guest User

daily time limit reach

a guest
May 27th, 2017
60
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.53 KB | None | 0 0
raw download clone embed print report
  1. rad_recv: Access-Request packet from host 171.79.18.10 port 49645, id=56, length=316
  2. ChilliSpot-Version = "1.3.1-svn"
  3. User-Name = "919958968054"
  4. User-Password = "5929a778bc5ae"
  5. Service-Type = Login-User
  6. Acct-Session-Id = "5929a76d00000002"
  7. Framed-IP-Address = 20.17.0.2
  8. NAS-Port-Type = Wireless-802.11
  9. NAS-Port = 2
  10. NAS-Port-Id = "00000002"
  11. Calling-Station-Id = "C0-EE-FB-DC-ED-23"
  12. Called-Station-Id = "F4-F2-6D-68-7D-AC"
  13. NAS-IP-Address = 20.17.0.1
  14. NAS-Identifier = "F4-F2-6D-68-7D-AC"
  15. WISPr-Location-ID = "isocc=,cc=,ac=,network=Wifitics_OpenWRT_Coova,"
  16. WISPr-Location-Name = "hotspot_wifitics"
  17. WISPr-Logoff-URL = "http://20.17.0.1:3990/logoff"
  18. Message-Authenticator = 0x81135335b34c94baa5430eb72e401716
  19. # Executing section authorize from file /etc/freeradius/sites-enabled/default
  20. +group authorize {
  21. ++[preprocess] = ok
  22. ++[chap] = noop
  23. ++[mschap] = noop
  24. ++[digest] = noop
  25. [suffix] No '@' in User-Name = "919958968054", looking up realm NULL
  26. [suffix] No such realm "NULL"
  27. ++[suffix] = noop
  28. [eap] No EAP-Message, not doing EAP
  29. ++[eap] = noop
  30. ++[files] = noop
  31. [sql] expand: %{User-Name} -> 919958968054
  32. [sql] sql_set_user escaped user --> '919958968054'
  33. rlm_sql (sql): Reserving sql socket id: 4
  34. [sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '919958968054' ORDER BY id
  35. [sql] User found in radcheck table
  36. [sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = '919958968054' ORDER BY id
  37. [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '919958968054' ORDER BY priority
  38. [sql] expand: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'F4-F2-6D-68-7D-AC' ORDER BY id
  39. [sql] User found in group F4-F2-6D-68-7D-AC
  40. [sql] expand: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'F4-F2-6D-68-7D-AC' ORDER BY id
  41. rlm_sql (sql): Released sql socket id: 4
  42. ++[sql] = ok
  43. rlm_sqlcounter: Entering module authorize code
  44. WARNING: Please replace '%k' with '${key}'
  45. sqlcounter_expand: 'SELECT SUM(acctsessiontime - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '%{User-Name}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200''
  46. [dailycounter] expand: SELECT SUM(acctsessiontime - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '%{User-Name}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200' -> SELECT SUM(acctsessiontime - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '919958968054' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200'
  47. WARNING: Please replace '%S' with '${sqlmod-inst}'
  48. sqlcounter_expand: '%{sql:SELECT SUM(acctsessiontime - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '919958968054' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200'}'
  49. [dailycounter] sql_xlat
  50. [dailycounter] expand: %{User-Name} -> 919958968054
  51. [dailycounter] sql_set_user escaped user --> '919958968054'
  52. [dailycounter] expand: SELECT SUM(acctsessiontime - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '919958968054' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200' -> SELECT SUM(acctsessiontime - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '919958968054' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200'
  53. rlm_sql (sql): Reserving sql socket id: 3
  54. [dailycounter] sql_xlat finished
  55. rlm_sql (sql): Released sql socket id: 3
  56. [dailycounter] expand: %{sql:SELECT SUM(acctsessiontime - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '919958968054' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200'} -> 17002
  57. rlm_sqlcounter: (Check item - counter) is less than zero
  58. rlm_sqlcounter: Rejected user 919958968054, check_item=900, counter=17002
  59. ++[dailycounter] = reject
  60. ++? if (reject)
  61. ? Evaluating (reject) -> TRUE
  62. ++? if (reject) -> TRUE
  63. ++if (reject) {
  64. +++update reply {
  65. +++} # update reply = noop
  66. ++} # if (reject) = noop
  67. rlm_sqlcounter: Entering module authorize code
  68. WARNING: Please replace '%k' with '${key}'
  69. sqlcounter_expand: 'SELECT SUM(acctinputoctets - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0))+ SUM(acctoutputoctets -GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='%{User-Name}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200''
  70.  
  71. [chillispot_max_bytes_daily] expand: SELECT SUM(acctinputoctets - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0))+ SUM(acctoutputoctets -GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='%{User-Name}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200' -> SELECT SUM(acctinputoctets - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0))+ SUM(acctoutputoctets -GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='919958968054' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200'
  72. WARNING: Please replace '%S' with '${sqlmod-inst}'
  73. sqlcounter_expand: '%{sql:SELECT SUM(acctinputoctets - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0))+ SUM(acctoutputoctets -GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='919958968054' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200'}'
  74. [chillispot_max_bytes_daily] sql_xlat
  75. [chillispot_max_bytes_daily] expand: %{User-Name} -> 919958968054
  76. [chillispot_max_bytes_daily] sql_set_user escaped user --> '919958968054'
  77. [chillispot_max_bytes_daily] expand: SELECT SUM(acctinputoctets - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0))+ SUM(acctoutputoctets -GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='919958968054' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200' -> SELECT SUM(acctinputoctets - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0))+ SUM(acctoutputoctets -GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='919958968054' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200'
  78. rlm_sql (sql): Reserving sql socket id: 2
  79. [chillispot_max_bytes_daily] sql_xlat finished
  80. rlm_sql (sql): Released sql socket id: 2
  81. [chillispot_max_bytes_daily] expand: %{sql:SELECT SUM(acctinputoctets - GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0))+ SUM(acctoutputoctets -GREATEST((1495843200 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='919958968054' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1495843200'} -> 206370502
  82. rlm_sqlcounter: Check item is greater than query result
  83. rlm_sqlcounter: Authorized user 919958968054, check_item=2000000000, counter=206370502
  84. rlm_sqlcounter: Sent Reply-Item for user 919958968054, Type=ChilliSpot-Max-Total-Octets, value=1793629498
  85. ++[chillispot_max_bytes_daily] = ok
  86. ++? if (reject)
  87. ? Evaluating (reject) -> FALSE
  88. ++? if (reject) -> FALSE
  89. ++[expiration] = noop
  90. ++[logintime] = noop
  91. ++[pap] = updated
  92. +} # group authorize = updated
  93. Found Auth-Type = PAP
  94. # Executing group from file /etc/freeradius/sites-enabled/default
  95. +group PAP {
  96. [pap] login attempt with password "5929a778bc5ae"
  97. [pap] Using clear text password "5929a778bc5ae"
  98. [pap] User authenticated successfully
  99. ++[pap] = ok
  100. +} # group PAP = ok
  101. # Executing section post-auth from file /etc/freeradius/sites-enabled/default
  102. +group post-auth {
  103. [reply_log] expand: /var/log/freeradius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d -> /var/log/freeradius/radacct/171.79.18.10/reply-detail-20170527
  104. [reply_log] /var/log/freeradius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d expands to /var/log/freeradius/radacct/171.79.18.10/reply-detail-20170527
  105. [reply_log] expand: %t -> Sat May 27 16:21:19 2017
  106. ++[reply_log] = ok
  107. [sql] expand: %{User-Name} -> 919958968054
  108. [sql] sql_set_user escaped user --> '919958968054'
  109. [sql] expand: %{User-Password} -> 5929a778bc5ae
  110. [sql] expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S') -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '919958968054', '5929a778bc5ae', 'Access-Accept', '2017-05-27 16:21:19')
  111. rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '919958968054', '5929a778bc5ae', 'Access-Accept', '2017-05-27 16:21:19')
  112. rlm_sql (sql): Reserving sql socket id: 1
  113. rlm_sql (sql): Released sql socket id: 1
  114. ++[sql] = ok
  115. ++[exec] = noop
  116. +} # group post-auth = ok
  117. Sending Access-Accept of id 56 to 171.79.18.10 port 49645
  118. Session-Timeout = 900
  119. Idle-Timeout = 1500
  120. WISPr-Bandwidth-Max-Up = 1000000
  121. WISPr-Bandwidth-Max-Down = 1000000
  122. Reply-Message = "Daily Time Limit reached."
  123. ChilliSpot-Max-Total-Octets = 1793629498
  124. Finished request 16.
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!