(0) Received Access-Request Id 12 from CLIENT_IP:19731 to SERVER_IP:1812 length 269
(0)   NAS-Port-Type = Wireless-802.11
(0)   Calling-Station-Id = "CALLING_STSTION_ID"
(0)   Called-Station-Id = "CALLED_STATION_ID"
(0)   NAS-Port-Id = "wlan2-hotspot"
(0)   User-Name = "447086"
(0)   NAS-Port = 2157969410
(0)   Acct-Session-Id = "80a00002"
(0)   Framed-IP-Address = 192.168.20.197
(0)   Mikrotik-Host-IP = 192.168.20.197
(0)   WISPr-Location-Name = "CALLED_STATION_ID"
(0)   CHAP-Challenge = 0x8b10938e9770a389af6667748c2c828f
(0)   CHAP-Password = 0x1c622737c4c16c82df6c53aa231acaa988
(0)   Service-Type = Login-User
(0)   WISPr-Logoff-URL = "http://192.168.20.1/logout"
(0)   NAS-Identifier = "MikroTik"
(0)   NAS-IP-Address = 192.168.0.123
(0) # Executing section authorize from file /usr/local/etc/raddb/sites-enabled/default
(0)   authorize {
(0)     policy filter_username {
(0)       if (&User-Name) {
(0)       if (&User-Name)  -> TRUE
(0)       if (&User-Name)  {
(0)         if (&User-Name =~ / /) {
(0)         if (&User-Name =~ / /)  -> FALSE
(0)         if (&User-Name =~ /@[^@]*@/ ) {
(0)         if (&User-Name =~ /@[^@]*@/ )  -> FALSE
(0)         if (&User-Name =~ /\.\./ ) {
(0)         if (&User-Name =~ /\.\./ )  -> FALSE
(0)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))  {
(0)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))   -> FALSE
(0)         if (&User-Name =~ /\.$/)  {
(0)         if (&User-Name =~ /\.$/)   -> FALSE
(0)         if (&User-Name =~ /@\./)  {
(0)         if (&User-Name =~ /@\./)   -> FALSE
(0)       } # if (&User-Name)  = notfound
(0)     } # policy filter_username = notfound
(0)     [preprocess] = ok
(0) chap:   &control:Auth-Type := CHAP
(0)     [chap] = ok
(0)     [mschap] = noop
(0)     [digest] = noop
(0) suffix: Checking for suffix after "@"
(0) suffix: No '@' in User-Name = "447086", looking up realm NULL
(0) suffix: No such realm "NULL"
(0)     [suffix] = noop
(0) eap: No EAP-Message, not doing EAP
(0)     [eap] = noop
(0)     [files] = noop
(0) sql: EXPAND %{User-Name}
(0) sql:    --> 447086
(0) sql: SQL-User-Name set to '447086'
rlm_sql (sql): Reserved connection (1)
(0) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id
(0) sql:    --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '447086' ORDER BY id
(0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '447086' ORDER BY id
(0) sql: User found in radcheck table
(0) sql: Conditional check items matched, merging assignment check items
(0) sql:   Cleartext-Password := "d1lMP"
(0) sql:   Called-Station-Id := "CALLED_STATION_ID"
(0) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id
(0) sql:    --> SELECT id, username, attribute, value, op FROM radreply WHERE username = '447086' ORDER BY id
(0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = '447086' ORDER BY id
(0) sql: User found in radreply table, merging reply items
(0) sql:   Session-Timeout := 43200
(0) sql:   Idle-Timeout := 43200
(0) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority
(0) sql:    --> SELECT groupname FROM radusergroup WHERE username = '447086' ORDER BY priority
(0) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = '447086' ORDER BY priority
(0) sql: User not found in any groups
rlm_sql (sql): Released connection (1)
rlm_sql (sql): Need 4 more connections to reach 10 spares
rlm_sql (sql): Opening additional connection (6), 1 of 26 pending slots used
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX socket, server version 5.5.44-MariaDB-log, protocol version 10
(0)     [sql] = ok
(0)     [expiration] = noop
(0)     [logintime] = noop
(0) pap: WARNING: Auth-Type already set.  Not setting to PAP
(0)     [pap] = noop
(0)   } # authorize = ok
(0) Found Auth-Type = CHAP
(0) # Executing group from file /usr/local/etc/raddb/sites-enabled/default
(0)   Auth-Type CHAP {
(0) chap: Comparing with "known good" Cleartext-Password
(0) chap: CHAP user "447086" authenticated successfully
(0)     [chap] = ok
(0)   } # Auth-Type CHAP = ok
(0) # Executing section post-auth from file /usr/local/etc/raddb/sites-enabled/default
(0)   post-auth {
(0)     update {
(0)       No attributes updated
(0)     } # update = noop
(0) sql: EXPAND .query
(0) sql:    --> .query
(0) sql: Using query template 'query'
rlm_sql (sql): Reserved connection (2)
(0) sql: EXPAND %{User-Name}
(0) sql:    --> 447086
(0) sql: SQL-User-Name set to '447086'
(0) sql: EXPAND INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')
(0) sql:    --> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '447086', '0x1c622737c4c16c82df6c53aa231acaa988', 'Access-Accept', '2017-01-11 00:31:33')
(0) sql: Executing query: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '447086', '0x1c622737c4c16c82df6c53aa231acaa988', 'Access-Accept', '2017-01-11 00:31:33')
(0) sql: SQL query returned: success
(0) sql: 1 record(s) updated
rlm_sql (sql): Released connection (2)
(0)     [sql] = ok
(0)     [exec] = noop
(0)     policy remove_reply_message_if_eap {
(0)       if (&reply:EAP-Message && &reply:Reply-Message) {
(0)       if (&reply:EAP-Message && &reply:Reply-Message)  -> FALSE
(0)       else {
(0)         [noop] = noop
(0)       } # else = noop
(0)     } # policy remove_reply_message_if_eap = noop
(0)   } # post-auth = ok
(0) Sent Access-Accept Id 12 from SERVER_IP:1812 to CLIENT_IP:19731 length 0
(0)   Session-Timeout = 43200
(0)   Idle-Timeout = 43200
(0) Finished request
Waking up in 4.9 seconds.
Waking up in 7.0 seconds.
Waking up in 14.0 seconds.
(0) Cleaning up request packet ID 12 with timestamp +54
Ready to process requests