[FreeRADIUS 3.0.16][rlm_sql] ODBC

[Alan DeKok]

On Feb 7, 2018, at 3:09 PM, Sergio NNX <sfhacker at hotmail.com> wrote:
> We are upgrading from FR 2.0.x to 3.0.16 slowly and gradually.
> We use ODBC to connect M$SQL Server.
> We are unsure about how to set it up in v3.0.x.

> Should the dialect be the same as the driver (as suggested in the config file) or ....?

  Usually, yes.
> 
> including configuration file \freeradius-server-3.0.16\etc/raddb/mods-config/sql/main/unixodbc/queries.conf
> Unable to open file "\freeradius-server-3.0.16\etc/raddb/mods-config/sql/main/unixodbc/queries.conf": No such file or directory
> Errors reading or parsing \freeradius-server-3.0.16\etc\raddb/radiusd.conf

  In this case, you should use "dialect = mssql"

  Alan DeKok.