auth-type-error

[MEjaz]

Hello all, 

 

 

 

I am trying to configure FreeRadius 3.0X  with remote MSSQL and unixODBC,
all basic tests have been passed sucefully.

 

However, when I run radtest, on my radiusd server, I get the following error
-

 

 

[root at radius-1 ~]#  radtest testnesma at 1024.corp.nesma.net.sa 112233
localhost 0 testing123

Sent Access-Request Id 108 from 0.0.0.0:45102 to 127.0.0.1:1812 length 102

        User-Name = "testnesma at 1024.corp.nesma.net.sa"

        User-Password = "112233"

        NAS-IP-Address = 212.71.40.32

        NAS-Port = 0

        Message-Authenticator = 0x00

        Cleartext-Password = "112233"

Received Access-Reject Id 108 from 127.0.0.1:1812 to 127.0.0.1:45102 length
20

(0)    -: Expected Access-Accept got Access-Reject

 

 

 

Debug output. 

 

(0) Received Access-Request Id 108 from 127.0.0.1:45102 to 127.0.0.1:1812
length 102

(0)   User-Name = "testnesma at 1024.corp.nesma.net.sa"

(0)   User-Password = "112233"

(0)   NAS-IP-Address = 212.71.40.32

(0)   NAS-Port = 0

(0)   Message-Authenticator = 0xcae0ae6cc9464e071bedb1119c825542

(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] = noop

(0)     [mschap] = noop

(0)     [digest] = noop

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

(0) suffix: Looking up realm "1024.corp.nesma.net.sa" for User-Name =
"testnesma at 1024.corp.nesma.net.sa"

(0) suffix: No such realm "1024.corp.nesma.net.sa"

(0)     [suffix] = noop

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

(0)     [eap] = noop

(0)     [files] = noop

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

(0) sql:    --> testnesma at 1024.corp.nesma.net.sa

(0) sql: SQL-User-Name set to 'testnesma at 1024.corp.nesma.net.sa'

rlm_sql (sql): Reserved connection (0)

(0) sql: EXPAND SELECT select password, replyattr, checkattr FROM
NB_Authentication_Nesma WHERE Username = '%{User-Name}' ORDER BY id

(0) sql:    --> SELECT select password, replyattr, checkattr FROM
NB_Authentication_Nesma WHERE Username = 'testnesma at 1024.corp.nesma.net.sa'
ORDER BY id

(0) sql: Executing select query: SELECT select password, replyattr,
checkattr FROM NB_Authentication_Nesma WHERE Username =
'testnesma at 1024.corp.nesma.net.sa' ORDER BY id

The 'rlm_sql_null' driver CANNOT be used for SELECTS.

Please update the 'sql' module configuration to use a real database.

Set 'driver = ...' to the database you want to use.

(0) sql: WARNING: Cannot do check groups when group_membership_query is not
set

rlm_sql (sql): Released connection (0)

Need 5 more connections to reach 10 spares

rlm_sql (sql): Opening additional connection (5), 1 of 27 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
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 /usr/local/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 (1)

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

(0) sql:    --> testnesma at 1024.corp.nesma.net.sa

(0) sql: SQL-User-Name set to 'testnesma at 1024.corp.nesma.net.sa'

(0) sql: EXPAND insert into RADONLINE
(USERNAME,NASIDENTIFIER,NASPORT,ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NAS
PORTTYPE,SERVICETYPE,CALLERID) values
('%{User-Name}','%{NAS-IP-Address}',%{NAS-Port},'%{Acct-Session-Id}',Cast
('%G' as
datetime),'%{Framed-IP-Address}','%{NAS-Port-Type}','%{Framed-Protocol}','%{
Calling-Station-Id}')

(0) sql:    --> insert into RADONLINE
(USERNAME,NASIDENTIFIER,NASPORT,ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NAS
PORTTYPE,SERVICETYPE,CALLERID) values
('testnesma at 1024.corp.nesma.net.sa','212.71.40.32',0,'',Cast ('39' as
datetime),'','','','')

(0) sql: Executing query: insert into RADONLINE
(USERNAME,NASIDENTIFIER,NASPORT,ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NAS
PORTTYPE,SERVICETYPE,CALLERID) values
('testnesma at 1024.corp.nesma.net.sa','212.71.40.32',0,'',Cast ('39' as
datetime),'','','','')

(0) sql: SQL query returned: success

(0) sql: 1 record(s) updated

rlm_sql (sql): Released connection (1)

(0)     [sql] = ok

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

(0) attr_filter.access_reject:    --> testnesma at 1024.corp.nesma.net.sa

(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