(0) Received Access-Request Id 122 from 127.0.0.1:45005 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 = 0x1f2ef452c1b6ffc80eea3fec73366161
(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
rlm_sql_unixodbc: 42000 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'select'.
(0) sql: ERROR: Unknown error
(0) sql: ERROR: SQL query error getting reply attributes
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] = fail
(0)   } # authorize = fail
(0) Invalid user (sql: Unknown error): [testnesma@1024.corp.nesma.net.sa] (from client localhost port 0)
(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,NASPORTTYPE,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,NASPORTTYPE,SERVICETYPE,CALLERID) values ('testnesma@1024.corp.nesma.net.sa','212.71.40.32',0,'',Cast ('57' as datetime),'','','','')
(0) sql: Executing query: insert into RADONLINE (USERNAME,NASIDENTIFIER,NASPORT,ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NASPORTTYPE,SERVICETYPE,CALLERID) values ('testnesma@1024.corp.nesma.net.sa','212.71.40.32',0,'',Cast ('57' as datetime),'','','','')
rlm_sql_unixodbc: 22007 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting date and/or time from character string.
(0) sql: SQL query returned: <INVALID>
rlm_sql_unixodbc: HY010 [unixODBC][Driver Manager]Function sequence error
(0) sql: -1 record(s) updated
(0) sql: No additional queries configured
rlm_sql (sql): Released connection (1)
(0)     [sql] = noop
(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
Waking up in 0.3 seconds.
Waking up in 0.6 seconds.
(0) Sending delayed response
(0) Sent Access-Reject Id 122 from 127.0.0.1:1812 to 127.0.0.1:45005 length 20
Waking up in 3.9 seconds.
(0) Cleaning up request packet ID 122 with timestamp +4
Ready to process requests