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@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Sunday, September 20, 2020 7:09 PM To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: auth-type-error On Sep 20, 2020, at 11:33 AM, MEjaz < <mailto:mejaz@cyberia.net.sa> mejaz@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