API tools faq
paste
Guest User

freeradius

a guest
Dec 2nd, 2014
351
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.26 KB | None | 0 0
raw download clone embed print report
  1. Received Access-Request Id 13 from 192.168.40.102:44609 to 192.168.40.12:1812 length 185
  2. NAS-Port-Type = Wireless-802.11
  3. Calling-Station-Id = '30:39:26:86:CC:EA'
  4. Called-Station-Id = 'hotspot1'
  5. NAS-Port-Id = 'citystore_test'
  6. User-Name = 'kostas2'
  7. NAS-Port = 2163212291
  8. Acct-Session-Id = '80f00003'
  9. Framed-IP-Address = 10.5.50.253
  10. Mikrotik-Host-IP = 10.5.50.253
  11. User-Password = 'kostas2'
  12. Service-Type = Login-User
  13. WISPr-Logoff-URL = 'http://10.5.50.1/logout'
  14. NAS-Identifier = 'MikroTik'
  15. NAS-IP-Address = 192.168.40.102
  16. (0) Received Access-Request packet from host 192.168.40.102 port 44609, id=13, length=185
  17. (0) NAS-Port-Type = Wireless-802.11
  18. (0) Calling-Station-Id = '30:39:26:86:CC:EA'
  19. (0) Called-Station-Id = 'hotspot1'
  20. (0) NAS-Port-Id = 'citystore_test'
  21. (0) User-Name = 'kostas2'
  22. (0) NAS-Port = 2163212291
  23. (0) Acct-Session-Id = '80f00003'
  24. (0) Framed-IP-Address = 10.5.50.253
  25. (0) Mikrotik-Host-IP = 10.5.50.253
  26. (0) User-Password = 'kostas2'
  27. (0) Service-Type = Login-User
  28. (0) WISPr-Logoff-URL = 'http://10.5.50.1/logout'
  29. (0) NAS-Identifier = 'MikroTik'
  30. (0) NAS-IP-Address = 192.168.40.102
  31. (0) # Executing section authorize from file /etc/freeradius/sites-enabled/default
  32. (0) authorize {
  33. (0) filter_username filter_username {
  34. (0) if (!&User-Name)
  35. (0) if (!&User-Name) -> FALSE
  36. (0) if (&User-Name =~ / /)
  37. (0) if (&User-Name =~ / /) -> FALSE
  38. (0) if (&User-Name =~ /@.*@/ )
  39. (0) if (&User-Name =~ /@.*@/ ) -> FALSE
  40. (0) if (&User-Name =~ /\\.\\./ )
  41. (0) if (&User-Name =~ /\\.\\./ ) -> FALSE
  42. (0) if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\\.(.+)$/))
  43. (0) if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\\.(.+)$/)) -> FALSE
  44. (0) if (&User-Name =~ /\\.$/)
  45. (0) if (&User-Name =~ /\\.$/) -> FALSE
  46. (0) if (&User-Name =~ /@\\./)
  47. (0) if (&User-Name =~ /@\\./) -> FALSE
  48. (0) } # filter_username filter_username = notfound
  49. (0) [preprocess] = ok
  50. (0) [chap] = noop
  51. (0) [mschap] = noop
  52. (0) [digest] = noop
  53. (0) suffix : Checking for suffix after "@"
  54. (0) suffix : No '@' in User-Name = "kostas2", looking up realm NULL
  55. (0) suffix : No such realm "NULL"
  56. (0) [suffix] = noop
  57. (0) eap : No EAP-Message, not doing EAP
  58. (0) [eap] = noop
  59. (0) [files] = noop
  60. (0) sql : EXPAND %{User-Name}
  61. (0) sql : --> kostas2
  62. (0) sql : SQL-User-Name set to 'kostas2'
  63. rlm_sql (sql): Reserved connection (4)
  64. (0) sql : EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id
  65. (0) sql : --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'kostas2' ORDER BY id
  66. rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'kostas2' ORDER BY id'
  67. (0) sql : User found in radcheck table
  68. (0) sql : Check items matched
  69. (0) sql : EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id
  70. (0) sql : --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'kostas2' ORDER BY id
  71. rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radreply WHERE username = 'kostas2' ORDER BY id'
  72. (0) sql : EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority
  73. (0) sql : --> SELECT groupname FROM radusergroup WHERE username = 'kostas2' ORDER BY priority
  74. rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup WHERE username = 'kostas2' ORDER BY priority'
  75. (0) sql : User found in the group table
  76. (0) sql : EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id
  77. (0) sql : --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'd4M' ORDER BY id
  78. rlm_sql (sql): Executing query: 'SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'd4M' ORDER BY id'
  79. (0) sql : Group "d4M" check items matched
  80. (0) sql : EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id
  81. (0) sql : --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'd4M' ORDER BY id
  82. rlm_sql (sql): Executing query: 'SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'd4M' ORDER BY id'
  83. (0) sql : Group "d4M" reply items processed
  84. rlm_sql (sql): Released connection (4)
  85. rlm_sql (sql): Closing connection (0), from 1 unused connections
  86. rlm_sql_mysql: Socket destructor called, closing socket
  87. (0) [sql] = ok
  88. (0) WARNING: checkthetime : Couldn't find control attribute 'control:Max-Hour-Used'
  89. (0) [checkthetime] = noop
  90. (0) [expiration] = noop
  91. (0) [logintime] = noop
  92. (0) [pap] = updated
  93. (0) } # authorize = updated
  94. (0) Found Auth-Type = PAP
  95. (0) # Executing group from file /etc/freeradius/sites-enabled/default
  96. (0) Auth-Type PAP {
  97. (0) pap : Login attempt with password
  98. (0) pap : User authenticated successfully
  99. (0) [pap] = ok
  100. (0) } # Auth-Type PAP = ok
  101. (0) # Executing section post-auth from file /etc/freeradius/sites-enabled/default
  102. (0) post-auth {
  103. (0) sql : EXPAND .query
  104. (0) sql : --> .query
  105. (0) sql : Using query template 'query'
  106. rlm_sql (sql): Reserved connection (4)
  107. (0) sql : EXPAND %{User-Name}
  108. (0) sql : --> kostas2
  109. (0) sql : SQL-User-Name set to 'kostas2'
  110. (0) sql : EXPAND INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')
  111. (0) sql : --> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'kostas2', 'kostas2', 'Access-Accept', '2014-12-02 09:22:53')
  112. rlm_sql (sql): Executing query: 'INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'kostas2', 'kostas2', 'Access-Accept', '2014-12-02 09:22:53')'
  113. rlm_sql (sql): Released connection (4)
  114. (0) [sql] = ok
  115. (0) [exec] = noop
  116. (0) remove_reply_message_if_eap remove_reply_message_if_eap {
  117. (0) if (&reply:EAP-Message && &reply:Reply-Message)
  118. (0) if (&reply:EAP-Message && &reply:Reply-Message) -> FALSE
  119. (0) else else {
  120. (0) [noop] = noop
  121. (0) } # else else = noop
  122. (0) } # remove_reply_message_if_eap remove_reply_message_if_eap = noop
  123. (0) } # post-auth = ok
  124. (0) Sending Access-Accept packet to host 192.168.40.102 port 44609, id=13, length=0
  125. (0) WISPr-Bandwidth-Max-Down = 4194304
  126. (0) Fall-Through = No
  127. Sending Access-Accept Id 13 from 192.168.40.12:1812 to 192.168.40.102:44609
  128. WISPr-Bandwidth-Max-Down = 4194304
  129. (0) Finished request
  130. Waking up in 0.3 seconds.
  131. Received Accounting-Request Id 14 from 192.168.40.102:34577 to 192.168.40.12:1813 length 48
  132. Acct-Status-Type = Accounting-On
  133. NAS-Identifier = 'MikroTik'
  134. Acct-Delay-Time = 0
  135. NAS-IP-Address = 192.168.40.102
  136. (1) Received Accounting-Request packet from host 192.168.40.102 port 34577, id=14, length=48
  137. (1) Acct-Status-Type = Accounting-On
  138. (1) NAS-Identifier = 'MikroTik'
  139. (1) Acct-Delay-Time = 0
  140. (1) NAS-IP-Address = 192.168.40.102
  141. (1) # Executing section preacct from file /etc/freeradius/sites-enabled/default
  142. (1) preacct {
  143. (1) [preprocess] = ok
  144. (1) acct_unique acct_unique {
  145. (1) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i)
  146. (1) EXPAND %{string:Class}
  147. (1) -->
  148. (1) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) -> FALSE
  149. (1) else else {
  150. (1) update request {
  151. (1) EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}}
  152. (1) --> 9ebe59f84575ccc7480343079348853b
  153. (1) Acct-Unique-Session-Id := "9ebe59f84575ccc7480343079348853b"
  154. (1) } # update request = noop
  155. (1) } # else else = noop
  156. (1) } # acct_unique acct_unique = noop
  157. (1) [suffix] = noop
  158. (1) [files] = noop
  159. (1) } # preacct = ok
  160. (1) # Executing section accounting from file /etc/freeradius/sites-enabled/default
  161. (1) accounting {
  162. (1) detail : EXPAND /var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d
  163. (1) detail : --> /var/log/freeradius/radacct/192.168.40.102/detail-20141202
  164. (1) detail : /var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/freeradius/radacct/192.168.40.102/detail-20141202
  165. (1) detail : EXPAND %t
  166. (1) detail : --> Tue Dec 2 09:22:53 2014
  167. (1) [detail] = ok
  168. (1) [unix] = noop
  169. (1) radutmp : EXPAND /var/log/freeradius/radutmp
  170. (1) radutmp : --> /var/log/freeradius/radutmp
  171. (1) radutmp : NAS mikrotik restarted (Accounting-On packet seen)
  172. (1) [radutmp] = ok
  173. (1) sql : EXPAND %{tolower:type.%{Acct-Status-Type}.query}
  174. (1) sql : --> type.accounting-on.query
  175. (1) sql : Using query template 'query'
  176. rlm_sql (sql): Reserved connection (4)
  177. (1) sql : EXPAND %{User-Name}
  178. (1) sql : -->
  179. (1) sql : SQL-User-Name set to ''
  180. (1) sql : EXPAND UPDATE radacct SET acctstoptime = FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime = '%{integer:Event-Timestamp}' - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE acctstoptime IS NULL AND nasipaddress = '%{NAS-IP-Address}' AND acctstarttime <= FROM_UNIXTIME(%{integer:Event-Timestamp})
  181. (1) sql : --> UPDATE radacct SET acctstoptime = FROM_UNIXTIME(1417504973), acctsessiontime = '1417504973' - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = 'NAS-Reboot' WHERE acctstoptime IS NULL AND nasipaddress = '192.168.40.102' AND acctstarttime <= FROM_UNIXTIME(1417504973)
  182. rlm_sql (sql): Executing query: 'UPDATE radacct SET acctstoptime = FROM_UNIXTIME(1417504973), acctsessiontime = '1417504973' - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = 'NAS-Reboot' WHERE acctstoptime IS NULL AND nasipaddress = '192.168.40.102' AND acctstarttime <= FROM_UNIXTIME(1417504973)'
  183. rlm_sql_mysql: Rows matched: 0 Changed: 0 Warnings: 0
  184. (1) sql : No records updated
  185. (1) sql : No additional queries configured
  186. rlm_sql (sql): Released connection (4)
  187. (1) [sql] = noop
  188. (1) [exec] = noop
  189. (1) attr_filter.accounting_response : EXPAND %{User-Name}
  190. (1) attr_filter.accounting_response : -->
  191. (1) [attr_filter.accounting_response] = noop
  192. (1) } # accounting = ok
  193. (1) Sending Accounting-Response packet to host 192.168.40.102 port 34577, id=14, length=0
  194. Sending Accounting-Response Id 14 from 192.168.40.12:1813 to 192.168.40.102:34577
  195. (1) Finished request
  196. Received Accounting-Request Id 15 from 192.168.40.102:58481 to 192.168.40.12:1813 length 148
  197. Acct-Status-Type = Start
  198. NAS-Port-Type = Wireless-802.11
  199. Calling-Station-Id = '30:39:26:86:CC:EA'
  200. Called-Station-Id = 'hotspot1'
  201. NAS-Port-Id = 'citystore_test'
  202. User-Name = 'kostas2'
  203. NAS-Port = 2163212291
  204. Acct-Session-Id = '80f00003'
  205. Framed-IP-Address = 10.5.50.253
  206. Mikrotik-Host-IP = 10.5.50.253
  207. Event-Timestamp = 'Oct 9 2014 23:27:34 EEST'
  208. NAS-Identifier = 'MikroTik'
  209. Acct-Delay-Time = 0
  210. NAS-IP-Address = 192.168.40.102
  211. (2) Received Accounting-Request packet from host 192.168.40.102 port 58481, id=15, length=148
  212. (2) Acct-Status-Type = Start
  213. (2) NAS-Port-Type = Wireless-802.11
  214. (2) Calling-Station-Id = '30:39:26:86:CC:EA'
  215. (2) Called-Station-Id = 'hotspot1'
  216. (2) NAS-Port-Id = 'citystore_test'
  217. (2) User-Name = 'kostas2'
  218. (2) NAS-Port = 2163212291
  219. (2) Acct-Session-Id = '80f00003'
  220. (2) Framed-IP-Address = 10.5.50.253
  221. (2) Mikrotik-Host-IP = 10.5.50.253
  222. (2) Event-Timestamp = 'Oct 9 2014 23:27:34 EEST'
  223. (2) NAS-Identifier = 'MikroTik'
  224. (2) Acct-Delay-Time = 0
  225. (2) NAS-IP-Address = 192.168.40.102
  226. (2) # Executing section preacct from file /etc/freeradius/sites-enabled/default
  227. (2) preacct {
  228. (2) [preprocess] = ok
  229. (2) acct_unique acct_unique {
  230. (2) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i)
  231. (2) EXPAND %{string:Class}
  232. (2) -->
  233. (2) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) -> FALSE
  234. (2) else else {
  235. (2) update request {
  236. (2) EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}}
  237. (2) --> 9fbe5d4f79bb6c8b3a1ac1036e4bd343
  238. (2) Acct-Unique-Session-Id := "9fbe5d4f79bb6c8b3a1ac1036e4bd343"
  239. (2) } # update request = noop
  240. (2) } # else else = noop
  241. (2) } # acct_unique acct_unique = noop
  242. (2) suffix : Checking for suffix after "@"
  243. (2) suffix : No '@' in User-Name = "kostas2", looking up realm NULL
  244. (2) suffix : No such realm "NULL"
  245. (2) [suffix] = noop
  246. (2) [files] = noop
  247. (2) } # preacct = ok
  248. (2) # Executing section accounting from file /etc/freeradius/sites-enabled/default
  249. (2) accounting {
  250. (2) detail : EXPAND /var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d
  251. (2) detail : --> /var/log/freeradius/radacct/192.168.40.102/detail-20141202
  252. (2) detail : /var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/freeradius/radacct/192.168.40.102/detail-20141202
  253. (2) detail : EXPAND %t
  254. (2) detail : --> Tue Dec 2 09:22:53 2014
  255. (2) [detail] = ok
  256. (2) [unix] = ok
  257. (2) radutmp : EXPAND /var/log/freeradius/radutmp
  258. (2) radutmp : --> /var/log/freeradius/radutmp
  259. (2) radutmp : EXPAND %{User-Name}
  260. (2) radutmp : --> kostas2
  261. (2) [radutmp] = ok
  262. (2) sql : EXPAND %{tolower:type.%{Acct-Status-Type}.query}
  263. (2) sql : --> type.start.query
  264. (2) sql : Using query template 'query'
  265. rlm_sql (sql): Reserved connection (4)
  266. (2) sql : EXPAND %{User-Name}
  267. (2) sql : --> kostas2
  268. (2) sql : SQL-User-Name set to 'kostas2'
  269. (2) sql : EXPAND INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', FROM_UNIXTIME(%{integer:Event-Timestamp}), FROM_UNIXTIME(%{integer:Event-Timestamp}), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')
  270. (2) sql : --> INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('80f00003', '9fbe5d4f79bb6c8b3a1ac1036e4bd343', 'kostas2', '', '192.168.40.102', '2163212291', 'Wireless-802.11', FROM_UNIXTIME(1412886454), FROM_UNIXTIME(1412886454), NULL, '0', '', '', '', '0', '0', 'hotspot1', '30:39:26:86:CC:EA', '', '', '', '10.5.50.253')
  271. rlm_sql (sql): Executing query: 'INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('80f00003', '9fbe5d4f79bb6c8b3a1ac1036e4bd343', 'kostas2', '', '192.168.40.102', '2163212291', 'Wireless-802.11', FROM_UNIXTIME(1412886454), FROM_UNIXTIME(1412886454), NULL, '0', '', '', '', '0', '0', 'hotspot1', '30:39:26:86:CC:EA', '', '', '', '10.5.50.253')'
  272. rlm_sql (sql): Released connection (4)
  273. (2) [sql] = ok
  274. (2) [exec] = noop
  275. (2) attr_filter.accounting_response : EXPAND %{User-Name}
  276. (2) attr_filter.accounting_response : --> kostas2
  277. (2) attr_filter.accounting_response : Matched entry DEFAULT at line 12
  278. (2) [attr_filter.accounting_response] = updated
  279. (2) } # accounting = updated
  280. (2) Sending Accounting-Response packet to host 192.168.40.102 port 58481, id=15, length=0
  281. Sending Accounting-Response Id 15 from 192.168.40.12:1813 to 192.168.40.102:58481
  282. (2) Finished request
  283. Waking up in 0.2 seconds.
  284. (1) Cleaning up request packet ID 14 with timestamp +39
  285. (2) Cleaning up request packet ID 15 with timestamp +39
  286. Waking up in 4.4 seconds.
  287. (0) Cleaning up request packet ID 13 with timestamp +39
  288. Ready to process requests
  289. Received Accounting-Request Id 16 from 192.168.40.102:37947 to 192.168.40.12:1813 length 196
  290. Acct-Status-Type = Stop
  291. Acct-Terminate-Cause = User-Request
  292. NAS-Port-Type = Wireless-802.11
  293. Calling-Station-Id = '30:39:26:86:CC:EA'
  294. Called-Station-Id = 'hotspot1'
  295. NAS-Port-Id = 'citystore_test'
  296. User-Name = 'kostas2'
  297. NAS-Port = 2163212291
  298. Acct-Session-Id = '80f00003'
  299. Framed-IP-Address = 10.5.50.253
  300. Mikrotik-Host-IP = 10.5.50.253
  301. Event-Timestamp = 'Oct 9 2014 23:53:00 EEST'
  302. Acct-Input-Octets = 106630
  303. Acct-Output-Octets = 1094450
  304. Acct-Input-Gigawords = 0
  305. Acct-Output-Gigawords = 0
  306. Acct-Input-Packets = 1061
  307. Acct-Output-Packets = 1129
  308. Acct-Session-Time = 1526
  309. NAS-Identifier = 'MikroTik'
  310. Acct-Delay-Time = 0
  311. NAS-IP-Address = 192.168.40.102
  312. (3) Received Accounting-Request packet from host 192.168.40.102 port 37947, id=16, length=196
  313. (3) Acct-Status-Type = Stop
  314. (3) Acct-Terminate-Cause = User-Request
  315. (3) NAS-Port-Type = Wireless-802.11
  316. (3) Calling-Station-Id = '30:39:26:86:CC:EA'
  317. (3) Called-Station-Id = 'hotspot1'
  318. (3) NAS-Port-Id = 'citystore_test'
  319. (3) User-Name = 'kostas2'
  320. (3) NAS-Port = 2163212291
  321. (3) Acct-Session-Id = '80f00003'
  322. (3) Framed-IP-Address = 10.5.50.253
  323. (3) Mikrotik-Host-IP = 10.5.50.253
  324. (3) Event-Timestamp = 'Oct 9 2014 23:53:00 EEST'
  325. (3) Acct-Input-Octets = 106630
  326. (3) Acct-Output-Octets = 1094450
  327. (3) Acct-Input-Gigawords = 0
  328. (3) Acct-Output-Gigawords = 0
  329. (3) Acct-Input-Packets = 1061
  330. (3) Acct-Output-Packets = 1129
  331. (3) Acct-Session-Time = 1526
  332. (3) NAS-Identifier = 'MikroTik'
  333. (3) Acct-Delay-Time = 0
  334. (3) NAS-IP-Address = 192.168.40.102
  335. (3) # Executing section preacct from file /etc/freeradius/sites-enabled/default
  336. (3) preacct {
  337. (3) [preprocess] = ok
  338. (3) acct_unique acct_unique {
  339. (3) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i)
  340. (3) EXPAND %{string:Class}
  341. (3) -->
  342. (3) if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) -> FALSE
  343. (3) else else {
  344. (3) update request {
  345. (3) EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}}
  346. (3) --> 9fbe5d4f79bb6c8b3a1ac1036e4bd343
  347. (3) Acct-Unique-Session-Id := "9fbe5d4f79bb6c8b3a1ac1036e4bd343"
  348. (3) } # update request = noop
  349. (3) } # else else = noop
  350. (3) } # acct_unique acct_unique = noop
  351. (3) suffix : Checking for suffix after "@"
  352. (3) suffix : No '@' in User-Name = "kostas2", looking up realm NULL
  353. (3) suffix : No such realm "NULL"
  354. (3) [suffix] = noop
  355. (3) [files] = noop
  356. (3) } # preacct = ok
  357. (3) # Executing section accounting from file /etc/freeradius/sites-enabled/default
  358. (3) accounting {
  359. (3) detail : EXPAND /var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d
  360. (3) detail : --> /var/log/freeradius/radacct/192.168.40.102/detail-20141202
  361. (3) detail : /var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/freeradius/radacct/192.168.40.102/detail-20141202
  362. (3) detail : EXPAND %t
  363. (3) detail : --> Tue Dec 2 09:48:19 2014
  364. (3) [detail] = ok
  365. (3) [unix] = ok
  366. (3) radutmp : EXPAND /var/log/freeradius/radutmp
  367. (3) radutmp : --> /var/log/freeradius/radutmp
  368. (3) radutmp : EXPAND %{User-Name}
  369. (3) radutmp : --> kostas2
  370. (3) [radutmp] = ok
  371. (3) sql : EXPAND %{tolower:type.%{Acct-Status-Type}.query}
  372. (3) sql : --> type.stop.query
  373. (3) sql : Using query template 'query'
  374. rlm_sql (sql): Reserved connection (4)
  375. (3) sql : EXPAND %{User-Name}
  376. (3) sql : --> kostas2
  377. (3) sql : SQL-User-Name set to 'kostas2'
  378. (3) sql : EXPAND UPDATE radacct SET acctstoptime = FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}', connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'
  379. (3) sql : --> UPDATE radacct SET acctstoptime = FROM_UNIXTIME(1412887980), acctsessiontime = '1526', acctinputoctets = '0' << 32 | '106630', acctoutputoctets = '0' << 32 | '1094450', acctterminatecause = 'User-Request', connectinfo_stop = '' WHERE acctsessionid = '80f00003' AND username = 'kostas2' AND nasipaddress = '192.168.40.102'
  380. rlm_sql (sql): Executing query: 'UPDATE radacct SET acctstoptime = FROM_UNIXTIME(1412887980), acctsessiontime = '1526', acctinputoctets = '0' << 32 | '106630', acctoutputoctets = '0' << 32 | '1094450', acctterminatecause = 'User-Request', connectinfo_stop = '' WHERE acctsessionid = '80f00003' AND username = 'kostas2' AND nasipaddress = '192.168.40.102''
  381. rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0
  382. rlm_sql (sql): Released connection (4)
  383. rlm_sql (sql): Closing connection (3): Hit idle_timeout, was idle for 1565 seconds
  384. rlm_sql (sql): You probably need to lower "min"
  385. rlm_sql_mysql: Socket destructor called, closing socket
  386. rlm_sql (sql): Closing connection (2): Hit idle_timeout, was idle for 1565 seconds
  387. rlm_sql (sql): You probably need to lower "min"
  388. rlm_sql_mysql: Socket destructor called, closing socket
  389. rlm_sql (sql): Closing connection (1): Hit idle_timeout, was idle for 1565 seconds
  390. rlm_sql (sql): You probably need to lower "min"
  391. rlm_sql_mysql: Socket destructor called, closing socket
  392. (3) [sql] = ok
  393. (3) [exec] = noop
  394. (3) attr_filter.accounting_response : EXPAND %{User-Name}
  395. (3) attr_filter.accounting_response : --> kostas2
  396. (3) attr_filter.accounting_response : Matched entry DEFAULT at line 12
  397. (3) [attr_filter.accounting_response] = updated
  398. (3) } # accounting = updated
  399. (3) Sending Accounting-Response packet to host 192.168.40.102 port 37947, id=16, length=0
  400. Sending Accounting-Response Id 16 from 192.168.40.12:1813 to 192.168.40.102:37947
  401. (3) Finished request
  402. Waking up in 0.3 seconds.
  403. (3) Cleaning up request packet ID 16 with timestamp +1565
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!