Issue with MSSQL connection.

[Ihsan]

Thanks for the reply.

how do i build from scource some people use apt install freeradius*

note the *

> Op 12 okt. 2022, om 11:04 heeft Nick Porter <nick at portercomputing.co.uk> het volgende geschreven:
> 
> 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
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


E-maildisclaimer: Aan dit bericht, waaronder ook de eventuele bijlagen worden bedoeld, kunnen geen rechten worden ontleend. Dit bericht is uitsluitend bestemd voor de geadresseerde en bevat persoonlijke en vertrouwelijke informatie. Het bekend maken, kopieren en verspreiden van een bericht dat niet voor u bestemd is, is niet toegestaan. Als u dit bericht per ongeluk heeft ontvangen, verzoeken wij u vriendelijk het direct te vernietigen en de afzender te informeren. Twijfelt u over de juistheid of volledigheid van dit bericht? Neem dan contact op met de afzender.Â