auth-type-error

[mejaz at cyberia.net.sa]

Thank you so much for your guidance, I will go step by step for quries.conf. 

-----Original Message-----
From: Freeradius-Users [mailto:freeradius-users-bounces+mejaz=cyberia.net.sa at lists.freeradius.org] On Behalf Of Alan DeKok
Sent: Monday, September 7, 2020 9:25 PM
To: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Subject: Re: auth-type-error

On Sep 7, 2020, at 2:01 PM, <mejaz at cyberia.net.sa> <mejaz at cyberia.net.sa> wrote:
> Thanks for putting me in the right direction. Yes,  all the answers are available in the comment section, indeed great help 
> 
> however driver  Problem is fixed after setting the  right  driver.

  That's good...

> Really sorry to bother you but one more issue below is in short attached is the full debug. Would be great help, if you can take look. 
> ...
> (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
> rlm_sql_unixodbc: 42000 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'select'.

  You've edited the default queries.  The queries you've created are broken.  Just... READ THEM.

  Even if you fix the query so that it has the correct syntax, you're going to have other problems.  You can't just invent queries and expect FreeRADIUS to magically do what you want.

  Just use the default configuration.  Use the default queries.  Make SMALL changes.  Test the changes.

  This is all documented.  I have no idea why you're making this so complicated.  You're just making random changes without paying attention to how anything works.  All this does is break things, and annoy people.

  You are working HARD to make it complex, and to break things.  Do less work.  Do more thinking.  Understand things before making changes.

  Alan DeKok.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html