Facing issue with radtest

[Somanath Mishra]

On Wed, August 29, 2018 1:04 pm, Somanath Mishra wrote:
> Hi All,
>
>
> I have configured freeradius3. Now i am facing issue with radtest.
> I am getting Accept-Reject response.
>
>
>
> My request:
>
>
>
> radius3 at radius3:~$ radtest testuser testpassword localhost 1812
> testing123 Sent Access-Request Id 141 from 0.0.0.0:57910 to 127.0.0.1:1812
> length 78 User-Name = "testuser"
> User-Password = "testpassword"
> NAS-IP-Address = 127.0.1.1
> NAS-Port = 1812
> Message-Authenticator = 0x00
> Cleartext-Password = "testpassword"
> Received Access-Reject Id 141 from 127.0.0.1:1812 to 0.0.0.0:0 length 20
> (0) -: Expected Access-Accept got Access-Reject
>
>
>
> radius DB:
>
>
>
> +----+--------------------+--------------------+----+--------------+
> | id | username           | attribute          | op | value        |
> +----+--------------------+--------------------+----+--------------+
> |  1 | testuser           | Cleartext-Password | := | testpassword |
> |  2 | testuser at gmail.com | Cleartext-Password | := | testpassword |
> |  3 | user at gmail.com     | user-password      | := | password     |
>
>
>
>
> and my debug log:
>
>
>
> Ready to process requests
> (0) Received Access-Request Id 141 from 127.0.0.1:57910 to 127.0.0.1:1812
> length 78
> (0)   User-Name = "testuser"
> (0)   User-Password = "testpassword"
> (0)   NAS-IP-Address = 127.0.1.1
> (0)   NAS-Port = 1812
> (0)   Message-Authenticator = 0x8c4403cf542c7a3facd04010b82c4b76
> (0) # Executing section authorize from file
> /etc/freeradius/sites-enabled/defaul
> t(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 !~ /@(.+)\.(.+)$/))
> -> FALS
> E
> (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] = noop
> (0)     [mschap] = noop
> (0)     [digest] = noop
> (0) suffix: Checking for suffix after "@"
> (0) suffix: No '@' in User-Name = "testuser", 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:    --> testuser
> (0) sql: SQL-User-Name set to 'testuser'
> rlm_sql (sql): Reserved connection (1) (0) sql: EXPAND SELECT id, username,
> attribute, value, op FROM radcheck WHERE us
> ername = '%{SQL-User-Name}' ORDER BY id (0) sql:    --> SELECT id,
> username, attribute, value, op FROM radcheck WHERE us
> ername = 'testuser' ORDER BY id (0) sql: Executing select query: SELECT id,
> username, attribute, value, op FROM
> radcheck WHERE username = 'testuser' ORDER BY id (0) sql: EXPAND SELECT
> groupname FROM radusergroup WHERE username = '%{SQL-User-
> Name}' ORDER BY priority
> (0) sql:    --> SELECT groupname FROM radusergroup WHERE username =
> 'testuser' O
> RDER BY priority
> (0) sql: Executing select query: SELECT groupname FROM radusergroup WHERE
> userna me = 'testuser' ORDER BY priority (0) sql: User not found in any
> groups rlm_sql (sql): Released connection (1) Need 4 more connections to
> reach 10 spares rlm_sql (sql): Opening additional connection (6), 1 of 26
> pending slots used (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 ava ilable (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 /etc/freeradius/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 (2) (0) sql: EXPAND %{User-Name}
> (0) sql:    --> testuser
> (0) sql: SQL-User-Name set to 'testuser'
> (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
> ( 'testuser', 'testpassword', 'Access-Reject',
> '2018-08-29 08:26:50')
> (0) sql: Executing query: INSERT INTO radpostauth (username, pass, reply,
> authda te) VALUES ( 'testuser', 'testpassword', 'Access-Reject',
'2018-08-29
> 08:26:50')
> (0) sql: SQL query returned: success
> (0) sql: 1 record(s) updated
> rlm_sql (sql): Released connection (2) (0)     [sql] = ok
> (0) attr_filter.access_reject: EXPAND %{User-Name}
> (0) attr_filter.access_reject:    --> testuser
> (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) 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 141 from 127.0.0.1:1812 to 127.0.0.1:57910
> length 20 Waking up in 3.9 seconds.
> (0) Cleaning up request packet ID 141 with timestamp +47
> Ready to process requests
>
>
>
> Please help me on that.Thanks
>
>
>
>
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html