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@radius-1 ~]# radtest testnesma@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@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@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@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@1024.corp.nesma.net.sa (0) sql: SQL-User-Name set to 'testnesma@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@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@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@1024.corp.nesma.net.sa (0) sql: SQL-User-Name set to 'testnesma@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@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@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@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