Issue with MSSQL connection.

[Nick Porter]

On 12/10/2022 03:49, Carlos Botejara wrote:
> Hello.
> Im trying to configure freeradius with MSSQL, and when I start freeradius
> -X, I receive the following error:
>
> *Could not link driver rlm_sql_unixodbc:
> /usr/lib/freeradius/rlm_sql_unixodbc.so: cannot open shared object file: No
> such file or directoryMake sure it (and all its dependent libraries!) are
> in the search path of your system's
> ld /etc/freeradius/mods-enabled/sql[27]: Instantiation failed for module
> "sql"*

That error means that the rlm_sql_unixodbc module is not installed.

By default unixodbc is not packaged in the .deb packages so if you want 
to use unixodbc to access MS SQL then you will need to build from source.

> The ODBC driver is installed and working:
>   isql -v MSSQLdb radius radtest
> +---------------------------------+
> | Connected!                           |
> |                                            |
> | sql-statement                       |
> | help [tablename]                  |
> | quit                                     |
> |                                           |
> +--------------------------------+
>
>
> I'm download the package, from this link
> https://networkradius.com/packages/#fr32-ubuntu-jammy, and I try with
> freetds, but I receive the same error message: *"Could not link driver
> rlm_sql_freetds: /usr/lib/freeradius/rlm_sql_freetds.so: cannot open shared
> object file: No such file or directory"*
> I checked in the directory, and the file is not there.

That is because you have not installed the freeradius-freetds package.

Install that package and you will be able to use freetds to connect to 
MS SQL.

> Thanks!
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- 
Nick Porter

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 665 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20221012/3ce95d97/attachment.sig>