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
On Sep 27, 2020, at 12:18 PM, MEjaz <mejaz@cyberia.net.sa> wrote:
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.
You already edited the correct file. The issue is that you're using MSSQL, and you copied the SQL syntax from another database. Which isn't compatible. So... go edit the same file. mods-config/sql/main/mssql/queries.conf And use the correct MSSQL syntax. Alan DeKok.
participants (2)
-
Alan DeKok -
MEjaz