Accept any request using freeradius.db

[Yağız Önen]

Hello everyone,



I am trying to accept all incoming requests using freeradius.db. SQL is
connected to freeradius and working fine. I added an entry in radcheck
table:

DEFAULT | Auth-Type        | := | Accept



However, I cannot get Accept-Accept. When I add the entry in raddb/users:



DEFAULT   Auth-Type := Accept



I get Accept-Accept from all users. What am I doing wrong in database?



Thank you.



The response is:

(0) Received Access-Request Id 164 from 192.168.67.229:41667 to
192.168.67.229:1812 length 74

(0)   User-Name = "test"

(0)   User-Password = "hellasdo1"

(0)   NAS-IP-Address = 127.0.1.1

(0)   NAS-Port = 10

(0)   Message-Authenticator = 0x5728f535d2d332599c9c4dd351860896

(0) # Executing section authorize from file
/opt/sinecins/bin/freeradius/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 !~ /@(.+)\.(.+)$/)
</@(.+)%5C.(.+)$/)>)  {

(0)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/)
</@(.+)%5C.(.+)$/)>)   -> 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)     [digest] = noop

(0) suffix: Checking for suffix after "@"

(0) suffix: No '@' in User-Name = "test", looking up realm NULL

(0) suffix: No such realm "NULL"

(0)     [suffix] = noop

(0) IPASS: Checking for prefix before "/"

(0) IPASS: No '/' in User-Name = "test", looking up realm NULL

(0) IPASS: No such realm "NULL"

(0)     [IPASS] = noop

(0) ntdomain: Checking for prefix before "\"

(0) ntdomain: No '\' in User-Name = "test", looking up realm NULL

(0) ntdomain: No such realm "NULL"

(0)     [ntdomain] = noop

(0) eap: No EAP-Message, not doing EAP

(0)     [eap] = noop

(0)     [files] = noop

(0) sql: EXPAND %{User-Name}

(0) sql:    --> test

(0) sql: SQL-User-Name set to 'test'

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 = 'test' ORDER BY id

(0) sql: Executing select query: SELECT id, username, attribute, value, op
FROM radcheck WHERE username = 'test' ORDER BY id rlm_sql (sql): Reserved
connection (2) rlm_sql (sql): Released connection (2) Need 5 more
connections to reach 10 spares rlm_sql (sql): Opening additional connection
(6), 1 of 26 pending slots used

rlm_sql_sqlite: Opening SQLite database "/opt/sinecins/bin/freeradius.db"

(0) sql: EXPAND SELECT groupname FROM radusergroup WHERE username =
'%{SQL-User-Name}' ORDER BY priority

(0) sql:    --> SELECT groupname FROM radusergroup WHERE username = 'test'
ORDER BY priority

(0) sql: Executing select query: SELECT groupname FROM radusergroup WHERE
username = 'test' ORDER BY priority

(0) sql: User not found in any groups

rlm_sql (sql): Released connection (1)

(0)     [sql] = notfound

(0)     [expiration] = noop

(0)     [logintime] = noop

(0) pap: WARNING: No "known good" password found for the user.  Not setting
Auth-Type

(0) pap: WARNING: Authentication will fail unless a "known good" password
is available

(0)     [pap] = noop

(0)   } # authorize = ok

(0) ERROR: No Auth-Type found: rejecting the user via Post-Auth-Type =
Reject

(0) Failed to authenticate the user

(0) Using Post-Auth-Type Reject

(0) # Executing group from file
/opt/sinecins/bin/freeradius/etc/raddb/sites-enabled/default

(0)   Post-Auth-Type REJECT {

(0) sql: EXPAND .query

(0) sql:    --> .query

(0) sql: Using query template 'query'

rlm_sql (sql): Reserved connection (3)

(0) sql: EXPAND %{User-Name}

(0) sql:    --> test

(0) sql: SQL-User-Name set to 'test'

(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 ( 'test', 'hellasdo1', 'Access-Reject', '2020-04-27 19:10:59')

(0) sql: Executing query: INSERT INTO radpostauth (username, pass, reply,
authdate) VALUES ( 'test', 'hellasdo1', 'Access-Reject', '2020-04-27
19:10:59')

(0) sql: SQL query returned: success

(0) sql: 1 record(s) updated

rlm_sql (sql): Released connection (3)

(0)     [sql] = ok

(0) attr_filter.access_reject: EXPAND %{User-Name}

(0) attr_filter.access_reject:    --> test

(0) attr_filter.access_reject: Matched entry DEFAULT at line 11

(0)     [attr_filter.access_reject] = updated

(0)     [eap] = 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-Type REJECT = updated

(0) Login incorrect (No Auth-Type found: rejecting the user via
Post-Auth-Type = Reject): [test] (from client client1 port 10)

(0) Delaying response for 1.000000 seconds Waking up in 0.3 seconds.

Waking up in 0.6 seconds.

(0) Sending delayed response

(0) Sent Access-Reject Id 164 from 192.168.67.229:1812 to
192.168.67.229:41667 length 20 Waking up in 3.9 seconds.

(0) Cleaning up request packet ID 164 with timestamp +4 Ready to process
requests