Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Thu Mar 10 18:04:04 2022 : Debug: (3) Received Access-Request Id 149 from 202.163.100.244:58994 to 192.168.207.150:1812 length 190
- Thu Mar 10 18:04:04 2022 : Debug: (3) User-Name = "noctest"
- Thu Mar 10 18:04:04 2022 : Debug: (3) User-Password = "noctest"
- Thu Mar 10 18:04:04 2022 : Debug: (3) Service-Type = Framed-User
- Thu Mar 10 18:04:04 2022 : Debug: (3) Framed-Protocol = PPP
- Thu Mar 10 18:04:04 2022 : Debug: (3) Chargeable-User-Identity = 0x00
- Thu Mar 10 18:04:04 2022 : Debug: (3) Acct-Session-Id = "153707649"
- Thu Mar 10 18:04:04 2022 : Debug: (3) Calling-Station-Id = "8c-16-45-de-f7-05"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Dhcp-Mac-Addr = "8c16.45de.f705"
- Thu Mar 10 18:04:04 2022 : Debug: (3) NAS-Identifier = "202.163.100.244"
- Thu Mar 10 18:04:04 2022 : Debug: (3) NAS-Port = 55
- Thu Mar 10 18:04:04 2022 : Debug: (3) NAS-Port-Id = ":1301-55"
- Thu Mar 10 18:04:04 2022 : Debug: (3) NAS-Port-Type = Ethernet
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Pppoe-Description = "pppoe 8c:16:45:de:f7:05"
- Thu Mar 10 18:04:04 2022 : Debug: (3) NAS-IP-Address = 202.163.100.244
- Thu Mar 10 18:04:04 2022 : Debug: (3) session-state: No State attribute
- Thu Mar 10 18:04:04 2022 : Debug: (3) # Executing section authorize from file /etc/freeradius/sites-enabled/default
- Thu Mar 10 18:04:04 2022 : Debug: (3) authorize {
- Thu Mar 10 18:04:04 2022 : Debug: (3) policy filter_username {
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name) {
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name) -> TRUE
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name) {
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name =~ / /) {
- Thu Mar 10 18:04:04 2022 : Debug: No old matches
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name =~ / /) -> FALSE
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name =~ /@[^@]*@/ ) {
- Thu Mar 10 18:04:04 2022 : Debug: No old matches
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name =~ /@[^@]*@/ ) -> FALSE
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name =~ /\.\./ ) {
- Thu Mar 10 18:04:04 2022 : Debug: No old matches
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name =~ /\.\./ ) -> FALSE
- Thu Mar 10 18:04:04 2022 : Debug: (3) if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/)) {
- Thu Mar 10 18:04:04 2022 : Debug: No old matches
- Thu Mar 10 18:04:04 2022 : Debug: (3) if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/)) -> FALSE
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name =~ /\.$/) {
- Thu Mar 10 18:04:04 2022 : Debug: No old matches
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name =~ /\.$/) -> FALSE
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name =~ /@\./) {
- Thu Mar 10 18:04:04 2022 : Debug: No old matches
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&User-Name =~ /@\./) -> FALSE
- Thu Mar 10 18:04:04 2022 : Debug: (3) } # if (&User-Name) = notfound
- Thu Mar 10 18:04:04 2022 : Debug: (3) } # policy filter_username = notfound
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: calling preprocess (rlm_preprocess)
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: returned from preprocess (rlm_preprocess)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [preprocess] = ok
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: calling suffix (rlm_realm)
- Thu Mar 10 18:04:04 2022 : Debug: (3) suffix: Checking for suffix after "@"
- Thu Mar 10 18:04:04 2022 : Debug: (3) suffix: No '@' in User-Name = "noctest", looking up realm NULL
- Thu Mar 10 18:04:04 2022 : Debug: (3) suffix: No such realm "NULL"
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: returned from suffix (rlm_realm)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [suffix] = noop
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: calling sql (rlm_sql)
- Thu Mar 10 18:04:04 2022 : Debug: %{User-Name}
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> User-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND %{User-Name}
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> noctest
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: SQL-User-Name set to 'noctest'
- Thu Mar 10 18:04:04 2022 : Debug: rlm_sql (sql): Reserved connection (3)
- Thu Mar 10 18:04:04 2022 : Debug: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: literal --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> SQL-User-Name
- Thu Mar 10 18:04:04 2022 : Debug: literal --> ' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'noctest' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'noctest' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: User found in radcheck table
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Conditional check items matched, merging assignment check items
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Cleartext-Password := "noctest"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: FROM 1 TO 0 MAX 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining Cleartext-Password
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING Cleartext-Password FROM 0 TO 0
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: TO in 0 out 0
- Thu Mar 10 18:04:04 2022 : Debug: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: literal --> SELECT id, username, attribute, value, op FROM radreply WHERE username = '
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> SQL-User-Name
- Thu Mar 10 18:04:04 2022 : Debug: literal --> ' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'noctest' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'noctest' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: User found in radreply table, merging reply items
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Framed-IP-Address = 172.19.255.255
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: FROM 1 TO 0 MAX 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining Framed-IP-Address
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING Framed-IP-Address FROM 0 TO 0
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: TO in 0 out 0
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ... falling-through to group processing
- Thu Mar 10 18:04:04 2022 : Debug: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: literal --> SELECT groupname FROM radusergroup WHERE username = '
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> SQL-User-Name
- Thu Mar 10 18:04:04 2022 : Debug: literal --> ' ORDER BY priority
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> SELECT groupname FROM radusergroup WHERE username = 'noctest' ORDER BY priority
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'noctest' ORDER BY priority
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: User found in the group table
- Thu Mar 10 18:04:04 2022 : Debug: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: literal --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> SQL-Group
- Thu Mar 10 18:04:04 2022 : Debug: literal --> ' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'NBB-Pro-100-KHI' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'NBB-Pro-100-KHI' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Group "NBB-Pro-100-KHI": Conditional check items matched
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Group "NBB-Pro-100-KHI": Merging assignment check items
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Simultaneous-Use := 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: FROM 1 TO 1 MAX 2
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining Simultaneous-Use
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING Simultaneous-Use FROM 0 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: TO in 1 out 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: to[0] = Cleartext-Password
- Thu Mar 10 18:04:04 2022 : Debug: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: literal --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> SQL-Group
- Thu Mar 10 18:04:04 2022 : Debug: literal --> ' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'NBB-Pro-100-KHI' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'NBB-Pro-100-KHI' ORDER BY id
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Group "NBB-Pro-100-KHI": Merging reply items
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Egress-Policy-Name = "flt_hsi35m_cdn65m_st_out"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Ingress-Policy-Name = "flt_hsi35m_cdn65m_st_in"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Service-Activate:1 = "svc_hsi35m_cdn65m_st"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Egress-Policy-Name = "flt_hsi35m_cdn65m_st_out"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Ingress-Policy-Name = "flt_hsi35m_cdn65m_st_in"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Service-Activate:1 = "svc_hsi35m_cdn65m_st"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Egress-Policy-Name = "flt_hsi35m_cdn65m_st_out"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Ingress-Policy-Name = "flt_hsi35m_cdn65m_st_in"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Service-Activate:1 = "svc_hsi35m_cdn65m_st"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Egress-Policy-Name = "flt_hsi35m_cdn65m_st_out"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Ingress-Policy-Name = "flt_hsi35m_cdn65m_st_in"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ERX-Service-Activate:1 = "svc_hsi35m_cdn65m_st"
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: FROM 12 TO 1 MAX 13
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Egress-Policy-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Egress-Policy-Name FROM 0 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Ingress-Policy-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Ingress-Policy-Name FROM 1 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Service-Activate
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Service-Activate FROM 2 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Egress-Policy-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Egress-Policy-Name FROM 3 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Ingress-Policy-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Ingress-Policy-Name FROM 4 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Service-Activate
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Service-Activate FROM 5 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Egress-Policy-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Egress-Policy-Name FROM 6 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Ingress-Policy-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Ingress-Policy-Name FROM 7 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Service-Activate
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Service-Activate FROM 8 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Egress-Policy-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Egress-Policy-Name FROM 9 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Ingress-Policy-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Ingress-Policy-Name FROM 10 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: Examining ERX-Service-Activate
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: APPENDING ERX-Service-Activate FROM 11 TO 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: TO in 1 out 1
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ::: to[0] = Framed-IP-Address
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: ... falling-through to profile processing
- Thu Mar 10 18:04:04 2022 : Debug: rlm_sql (sql): Released connection (3)
- Thu Mar 10 18:04:04 2022 : Info: Need 1 more connections to reach min connections (3)
- Thu Mar 10 18:04:04 2022 : Info: Need more connections to reach 10 spares
- Thu Mar 10 18:04:04 2022 : Info: rlm_sql (sql): Opening additional connection (8), 1 of 30 pending slots used
- Thu Mar 10 18:04:04 2022 : Debug: rlm_sql_mysql: Starting connect to MySQL server
- Thu Mar 10 18:04:04 2022 : Debug: rlm_sql_mysql: Connected to database 'nbbdb_radius' on Localhost via UNIX socket, server version 8.0.23-14.1, protocol version 10
- Thu Mar 10 18:04:04 2022 : Debug: rlm_sql (sql): You probably need to lower "min"
- Thu Mar 10 18:04:04 2022 : Info: rlm_sql (sql): Closing expired connection (7) - Hit idle_timeout limit
- Thu Mar 10 18:04:04 2022 : Debug: rlm_sql_mysql: Socket destructor called, closing socket
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: returned from sql (rlm_sql)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [sql] = ok
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: calling expiration (rlm_expiration)
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: returned from expiration (rlm_expiration)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [expiration] = noop
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: calling logintime (rlm_logintime)
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: returned from logintime (rlm_logintime)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [logintime] = noop
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: calling pap (rlm_pap)
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authorize]: returned from pap (rlm_pap)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [pap] = updated
- Thu Mar 10 18:04:04 2022 : Debug: (3) } # authorize = updated
- Thu Mar 10 18:04:04 2022 : Debug: (3) Found Auth-Type = PAP
- Thu Mar 10 18:04:04 2022 : Debug: (3) # Executing group from file /etc/freeradius/sites-enabled/default
- Thu Mar 10 18:04:04 2022 : Debug: (3) Auth-Type PAP {
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authenticate]: calling pap (rlm_pap)
- Thu Mar 10 18:04:04 2022 : Debug: (3) pap: Login attempt with password "noctest" (7)
- Thu Mar 10 18:04:04 2022 : Debug: (3) pap: Comparing with "known good" Cleartext-Password "noctest" (7)
- Thu Mar 10 18:04:04 2022 : Debug: (3) pap: User authenticated successfully
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[authenticate]: returned from pap (rlm_pap)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [pap] = ok
- Thu Mar 10 18:04:04 2022 : Debug: (3) } # Auth-Type PAP = ok
- Thu Mar 10 18:04:04 2022 : Debug: (3) # Executing section session from file /etc/freeradius/sites-enabled/default
- Thu Mar 10 18:04:04 2022 : Debug: (3) session {
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[session]: calling sql (rlm_sql)
- Thu Mar 10 18:04:04 2022 : Debug: %{User-Name}
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> User-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND %{User-Name}
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> noctest
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: SQL-User-Name set to 'noctest'
- Thu Mar 10 18:04:04 2022 : Debug: rlm_sql (sql): Reserved connection (3)
- Thu Mar 10 18:04:04 2022 : Debug: SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: literal --> SELECT COUNT(*) FROM radacct WHERE username = '
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> SQL-User-Name
- Thu Mar 10 18:04:04 2022 : Debug: literal --> ' AND acctstoptime IS NULL
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> SELECT COUNT(*) FROM radacct WHERE username = 'noctest' AND acctstoptime IS NULL
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Executing select query: SELECT COUNT(*) FROM radacct WHERE username = 'noctest' AND acctstoptime IS NULL
- Thu Mar 10 18:04:04 2022 : Debug: rlm_sql (sql): Released connection (3)
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[session]: returned from sql (rlm_sql)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [sql] = ok
- Thu Mar 10 18:04:04 2022 : Debug: (3) } # session = ok
- Thu Mar 10 18:04:04 2022 : Debug: (3) # Executing section post-auth from file /etc/freeradius/sites-enabled/default
- Thu Mar 10 18:04:04 2022 : Debug: (3) post-auth {
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[post-auth]: calling sql (rlm_sql)
- Thu Mar 10 18:04:04 2022 : Debug: .query
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: literal --> .query
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND .query
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> .query
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Using query template 'query'
- Thu Mar 10 18:04:04 2022 : Debug: rlm_sql (sql): Reserved connection (8)
- Thu Mar 10 18:04:04 2022 : Debug: %{User-Name}
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> User-Name
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND %{User-Name}
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> noctest
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: SQL-User-Name set to 'noctest'
- Thu Mar 10 18:04:04 2022 : Debug: INSERT INTO radpostauth (username, pass, reply, authdate ) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S.%M' )
- Thu Mar 10 18:04:04 2022 : Debug: Parsed xlat tree:
- Thu Mar 10 18:04:04 2022 : Debug: literal --> INSERT INTO radpostauth (username, pass, reply, authdate ) VALUES ( '
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> SQL-User-Name
- Thu Mar 10 18:04:04 2022 : Debug: literal --> ', '
- Thu Mar 10 18:04:04 2022 : Debug: XLAT-IF {
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> User-Password
- Thu Mar 10 18:04:04 2022 : Debug: }
- Thu Mar 10 18:04:04 2022 : Debug: XLAT-ELSE {
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> CHAP-Password
- Thu Mar 10 18:04:04 2022 : Debug: }
- Thu Mar 10 18:04:04 2022 : Debug: literal --> ', '
- Thu Mar 10 18:04:04 2022 : Debug: attribute --> Packet-Type
- Thu Mar 10 18:04:04 2022 : Debug: literal --> ', '
- Thu Mar 10 18:04:04 2022 : Debug: percent --> S
- Thu Mar 10 18:04:04 2022 : Debug: literal --> .
- Thu Mar 10 18:04:04 2022 : Debug: percent --> M
- Thu Mar 10 18:04:04 2022 : Debug: literal --> ' )
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: EXPAND INSERT INTO radpostauth (username, pass, reply, authdate ) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S.%M' )
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: --> INSERT INTO radpostauth (username, pass, reply, authdate ) VALUES ( 'noctest', 'noctest', 'Access-Accept', '2022-03-10 18:04:04.723393' )
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: Executing query: INSERT INTO radpostauth (username, pass, reply, authdate ) VALUES ( 'noctest', 'noctest', 'Access-Accept', '2022-03-10 18:04:04.723393' )
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: SQL query returned: success
- Thu Mar 10 18:04:04 2022 : Debug: (3) sql: 1 record(s) updated
- Thu Mar 10 18:04:04 2022 : Debug: rlm_sql (sql): Released connection (8)
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[post-auth]: returned from sql (rlm_sql)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [sql] = ok
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[post-auth]: calling exec (rlm_exec)
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[post-auth]: returned from exec (rlm_exec)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [exec] = noop
- Thu Mar 10 18:04:04 2022 : Debug: (3) policy remove_reply_message_if_eap {
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&reply:EAP-Message && &reply:Reply-Message) {
- Thu Mar 10 18:04:04 2022 : Debug: (3) if (&reply:EAP-Message && &reply:Reply-Message) -> FALSE
- Thu Mar 10 18:04:04 2022 : Debug: (3) else {
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[post-auth]: calling noop (rlm_always)
- Thu Mar 10 18:04:04 2022 : Debug: (3) modsingle[post-auth]: returned from noop (rlm_always)
- Thu Mar 10 18:04:04 2022 : Debug: (3) [noop] = noop
- Thu Mar 10 18:04:04 2022 : Debug: (3) } # else = noop
- Thu Mar 10 18:04:04 2022 : Debug: (3) } # policy remove_reply_message_if_eap = noop
- Thu Mar 10 18:04:04 2022 : Debug: (3) } # post-auth = ok
- Thu Mar 10 18:04:04 2022 : Debug: (3) Sent Access-Accept Id 149 from 192.168.207.150:1812 to 202.163.100.244:58994 length 394
- Thu Mar 10 18:04:04 2022 : Debug: (3) Framed-IP-Address = 172.19.255.255
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Egress-Policy-Name = "flt_hsi35m_cdn65m_st_out"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Ingress-Policy-Name = "flt_hsi35m_cdn65m_st_in"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Service-Activate:1 = "svc_hsi35m_cdn65m_st"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Egress-Policy-Name = "flt_hsi35m_cdn65m_st_out"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Ingress-Policy-Name = "flt_hsi35m_cdn65m_st_in"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Service-Activate:1 = "svc_hsi35m_cdn65m_st"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Egress-Policy-Name = "flt_hsi35m_cdn65m_st_out"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Ingress-Policy-Name = "flt_hsi35m_cdn65m_st_in"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Service-Activate:1 = "svc_hsi35m_cdn65m_st"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Egress-Policy-Name = "flt_hsi35m_cdn65m_st_out"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Ingress-Policy-Name = "flt_hsi35m_cdn65m_st_in"
- Thu Mar 10 18:04:04 2022 : Debug: (3) ERX-Service-Activate:1 = "svc_hsi35m_cdn65m_st"
- Thu Mar 10 18:04:04 2022 : Debug: (3) Finished request
- Thu Mar 10 18:04:04 2022 : Debug: Waking up in 4.9 seconds.
- Thu Mar 10 18:04:09 2022 : Debug: (3) Cleaning up request packet ID 149 with timestamp +1201
- Thu Mar 10 18:04:09 2022 : Info: Ready to process requests
Add Comment
Please, Sign In to add comment