MEjaz mejaz at cyberia.net.sa
Sun Sep 27 18:18:18 CEST 2020

Thanks for your usual  instant support. 


And sorry for annoying  you with the config files.  Rest assure that I will not repeat it  what you told not to,  however I revert back original queries.config for mssql. 


When I tested  to connect user multiple times through NTRadPing utility,  Yes they can connect which I don’t want. It should allow only once.  I noticed  following warning  in the debug level. 


" sql: WARNING: Simultaneous-Use checking requires 'simul_count_query' to be configured. Attached is full debug file your information "  


I have searched few forums for  where/how  to configure this statement "'simul_count_query'"  in which file? But  no luck. 


Would you please help. almost all done. Except this default simultaneous-use  to 1,  database side is already done. 



Once again thanks in advance… 








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


On Sep 20, 2020, at 11:33 AM, MEjaz < <mailto:mejaz at cyberia.net.sa> mejaz at cyberia.net.sa> wrote:

> So far I have successfully achieved the below request type through radpingutility 


> *         Authentication 

> *         Accounting start  

> *         Accounting stop 


  That's good.


> Now only remaining is to set default simultaneous-use  to 1.  As  i want to limit user's behavior, such as a username can login only once at the same time... 


> But got error as  “rlm_sql_unixodbc: 22002 [Microsoft][ODBC Driver 17 for SQL Server]Indicator variable required but not supplied (2) sql: ERROR: Error fetching row”  debug is attached fyi. 




> 1、modifiy default and inner-tunnel in


  For pretty much the last time... we do NOT need to see config files.  If I haven't gotten that point across before, please pay attention now.  If you keep posting config files when told not to, I will just start ignoring your messages.


> 2、modify queris.coonf  in /usr/local/etc/raddb/mods-config/sql/main/mssql, 


> below statment i have copeied from /usr/local/etc/raddb/mods-config/sql/main/mysql/quries.conf, as it was not exists  by default  under the msssql/queries.coonf


  Don't do that.


  The databases have different syntaxes.  You *cannot* just copy queries from one config file to another one.  There's a *reason* that the configuration files are different.


  Go fix the queries to be correct for MSSQL.  How?  I don't know.  I don't run MSSQL.


  Alan DeKok.




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

More information about the Freeradius-Users mailing list