-simeltenious-1

[MEjaz]

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… 

 

Ejaz 

 

 

 

 

 

-----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. 

 

  Ok...

 

> 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