Issue with MSSQL connection.

[Carlos Botejara]

Thanks Nick I build freeradius from the source with freetds and all works
fine.
Thanks again for your help.
best regards.

El mié, 12 oct 2022 a las 6:12, Nick Porter (<nick at portercomputing.co.uk>)
escribió:

> I would recommend trying freetds first - I have successfully used it to
> connect to MS SQL databases - that way you can use the official packages.
>
> Building from source will require you to install quite a lot of
> development libraries - if you're not used to building packages from
> source I would not recommend going down that route.
>
>
> https://github.com/FreeRADIUS/freeradius-server/blob/master/doc/antora/modules/installation/pages/source.adoc
> gives the overview of how to build from source, though that focuses on
> building the latest development version.  You would want to checkout the
> v3.2.x branch to build the stable release.
>
> On 12/10/2022 10:06, Ihsan wrote:
> > 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.Â
> >
> > -
> > 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
>


-- 
Carlos Botejara
IT Analyst
cbotejara at gmail.com
NEUQUEN - ARGENTINA
C: 0299-154230346
LINKEDIN: http://www.linkedin.com/in/carlosbotejara

Este correo está dirigido únicamente a la persona o entidad que figura en
el destinatario y puede contener información confidencial y/o privilegiada.
La copia, reenvío, o distribución de este mensaje por personas o entidades
diferentes al destinatario está prohibido.
Si Ud. ha recibido este correo por error, por favor contáctese con el
remitente inmediatamente y borre el material de cualquier computadora.
Este correo puede estar siendo monitoreado en cumplimiento de esta política.