freeradius 3.0.21 rlm_sql_freetds problem

[Alan DeKok]

On Apr 16, 2020, at 4:39 PM, Ali Arslan via Freeradius-Users <freeradius-users at lists.freeradius.org> wrote:
> 
> Hello,
> 
> I have installed freeradius 3.0.21 on ubuntu 18.04 server. I wanted to use mssql as radius database server, so i installed freetds as
>     apt-get install freetds-dev freetds-bin tdsodbc

  But not the freetds driver used by FreeRADIUS.

> and configured
>     /etc/freetds/freetds.conf file as 
>         [RadiusSqlServer]
>             host = sqlserver_ip_address
>             port = 1433
>             tds version = 7.0
> 
> and configured /etc/freeradius/mods-available/sql file to use rlm_sql_freetds as deriver.
> 
> But I got error: 
>     
> Could not link driver rlm_sql_freetds: : 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
> /etc/freeradius/mods-enabled/sql[27]: Instantiation failed for module "sql" 

  You need to install the rlm_sql_freetds driver.

> Installation of freeradius does not create file /usr/lib/freeradius/rlm_sql_freetds.so.

  Yes.  Installing FreeRADIUS only installs FreeRADIUS.  It doesn't install all of the libraries needed by the server.

> To create this  file  i first install  freeradius 3.0.16 (standard  on ubuntu 18.04) then copy file to another location and uninstall freeradius 3.0.16 and install 3.0.21 and copy file back to/usr/lib/freeradius/  folder.
> 
> Is this a bug in freeradius 3.0.21 package?

  The server is split into multiple packages.  There should be one just for rlm_sql_freetds.

  Where did you get the 3.0.21 packages from?

  Alan DeKok.