[FreeRADIUS 3.0.16][rlm_sql] ODBC

[Sergio NNX]

Ciao.

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.

/etc/raddb/mods-enabled/sql file

sql {
    # The sub-module to use to execute queries. This should match
    # the database you're attempting to connect to.
    #
    #    * rlm_sql_mysql
    #    * rlm_sql_mssql
    #    * rlm_sql_oracle
    #    * rlm_sql_postgresql
    #    * rlm_sql_sqlite
    #    * rlm_sql_null (log queries to disk)
    #
    driver = "rlm_sql_unixodbc"

    ...
    ...
    ...
    # The dialect of SQL you want to use, this should usually match
    # the driver you selected above.
    #
    # If you're using rlm_sql_null, then it should be the type of
    # database the logged queries are going to be executed against.
    dialect = "unixodbc"

    # Connection info:
    #
    server = "MSSQLTestServer"
#    port = 3306
    login = "testsqluser"
    password = "xxxxxxx"
    ...
    ...


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

Thanks in advance.


radiusd -X output:

FreeRADIUS Version 3.0.16
Copyright (C) 1999-2017 The FreeRADIUS server project and contributors
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE
You may redistribute copies of FreeRADIUS under the terms of the
GNU General Public License
For more information about these matters, see the file named COPYRIGHT
Starting - reading configuration files ...
including dictionary file \freeradius-server-3.0.16\share\freeradius/dictionary
including dictionary file \freeradius-server-3.0.16\share\freeradius/dictionary.dhcp
including dictionary file \freeradius-server-3.0.16\share\freeradius/dictionary.vqp
including configuration file \freeradius-server-3.0.16\etc\raddb/radiusd.conf
including configuration file \freeradius-server-3.0.16\etc\raddb/proxy.conf
including configuration file \freeradius-server-3.0.16\etc\raddb/clients.conf
including files in directory \freeradius-server-3.0.16\etc\raddb/mods-enabled/
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/always
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/attr_filter
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/chap
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/date
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/detail
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/digest
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/eap
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/echo
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/exec
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/expiration
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/expr
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/files
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/logintime
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/mschap
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/pap
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/preprocess
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/radutmp
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/realm
including configuration file \freeradius-server-3.0.16\etc\raddb/mods-enabled/sql
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