Thanks for the information Thanks for your tips, Hello, As advised, I have tried set the MSSQL driver in SQL file but when I set this, ran into different problem with "could not link driver rlm_sql_mssqlo" Whereas I have successfully installed this MS-tools and I have made sure as below. [root@radius-1 ~]# rpm -qa | grep odbc msodbcsql17-17.6.1.1-1.x86_64 [root@radius-1 ~]# rpm -qa | grep -i unix unixODBC-devel-2.3.7-1.rh.x86_64 unixODBC-2.3.7-1.rh.x86_64 would this be enough or do we need to install any other dependencies. Please assist. ============================================================================================== Could not link driver rlm_sql_mssql: /usr/local/lib/rlm_sql_mssql.so: cannot open shared object file: No such file or directory Make sure it (and all its dependent libraries!) are in the search path of your system's ld /usr/local/etc/raddb/mods-enabled/sql[2]: Instantiation failed for module "sql" =========================================================== -----Original Message----- From: Freeradius-Users [mailto:freeradius-users-bounces+mejaz=cyberia.net.sa@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Monday, September 7, 2020 2:57 PM To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: auth-type-error On Sep 7, 2020, at 4:58 AM, MEjaz <mejaz@cyberia.net.sa> wrote:
I am trying to configure FreeRadius 3.0X with remote MSSQL and unixODBC, all basic tests have been passed sucefully.
You need to configure the "sql" module, to set "dialect", and maybe "driver". This is documented in the comments in mods-available/sql.
However, when I run radtest, on my radiusd server, I get the following error ... [root@radius-1 ~]# radtest testnesma@1024.corp.nesma.net.sa 112233 localhost 0 testing123
We do NOT need to see the output of "radtest". This is documented everywhere.
... The 'rlm_sql_null' driver CANNOT be used for SELECTS.
Please update the 'sql' module configuration to use a real database.
Set 'driver = ...' to the database you want to use.
That seems pretty clear. It helps to read the comments in the module, and the debug messages that the server produces. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html