freeradius 3.0.21 rlm_sql_freetds problem
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 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" Installation of freeradius does not create file /usr/lib/freeradius/rlm_sql_freetds.so.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?
On Apr 16, 2020, at 4:39 PM, Ali Arslan via Freeradius-Users <freeradius-users@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.
Hi Alan, > Where did you get the 3.0.21 packages from? I installed freeradius 3.0.21 by updating /etc/apt/sources.list on ubuntu 18.04 as https://networkradius.com/freeradius-packages/ suggests. FreeRADIUS Packages - Network RADIUS
Hm, I seen the following. https://packages.networkradius.com/releases/ubuntu-bionic/pool/main/f/freera... And i notice your install :
I have installed freeradius 3.0.21 on ubuntu 18.04 server. I want to use mssql as radius dadabase server, so i installed freetds as apt-get install freetds-dev freetds-bin tdsodbc
apt-cache policy freetds-dev Version table: 1.1.6-1.1 500 500 http://nl.archive.ubuntu.com/ubuntu focal/main amd64 Packages Only on ubuntu repo. I suggest you fall back to the official package from freeradius. As it looks like the following. The "ubuntu" version do have MSMSQl build in, while these Might have not : https://packages.networkradius.com/releases/ubuntu-bionic/pool/main/f/freera... I cant verify it since they dont share the source. But, if you enable the source of Ubuntu, and get the source online, you can recompile these to bionic. Personaly, i would upgrade the 18.04 server to 20.04, yes i know its not released yet, but thats next week. Then your at least on freeradius 3.0.20. I hope this helps you a bit. Greetz, Louis
-----Oorspronkelijk bericht----- Van: Freeradius-Users [mailto:freeradius-users-bounces+belle=bazuin.nl@lists.freerad ius.org] Namens Ali Arslan via Freeradius-Users Verzonden: vrijdag 17 april 2020 6:14 Aan: FreeRadius users mailing list CC: Ali Arslan Onderwerp: Re: freeradius 3.0.21 rlm_sql_freetds problem
Hi Alan,
> Where did you get the 3.0.21 packages from?
I installed freeradius 3.0.21 by updating /etc/apt/sources.list on ubuntu 18.04 as https://networkradius.com/freeradius-packages/ suggests.
FreeRADIUS Packages - Network RADIUS
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hai, I did bit more here for you. What i would do here personaly if you really want 3.0.21 Install Ubuntu Focal, released next week or so, i assume its safe to install and use it. Enable the sources in /etc/apt/sources.list for focal. apt update && apt-get source freeradius apt-get build-dep freeradius wget ftp://ftp.freeradius.org/pub/freeradius/freeradius-server-3.0.21.tar.gz Extract it.. cd freeradius-server-3.0.21 rmdir debian cd .. cp -R freeradius-3.0.20+dfsg/debian/ freeradius-server-3.0.21 editor freeradius-server-3.0.21/debian/changelog Add on top, use this version numbmer, when any other 3.0.21 hits ubuntu, its going to replace it again. freeradius (3.0.21-0.1) focal; urgency=medium * New upstream release -- Your Name <your@email.adres.com> Fri, 17 Apr 2020 11:00:13 +0200 ... ^^^change that line to your next but exact as it, correct date/time if needed. cd freeradius-server-3.0.21 dpkg-buildpackage -B And wait, then you have ubuntu compliant package with newest freeradious. All the deb's are created for you. I've verified the packages, the "missing" file is in these.. ;-) Google for a localrepo setup, folder of webserver, and your set. Good luck. Ps. If you really want to stay on 18.04, i've not tested it but above should also work for 18.04. Same steps. Greetz, Louis
-----Oorspronkelijk bericht----- Van: Freeradius-Users [mailto:freeradius-users-bounces+belle=bazuin.nl@lists.freerad ius.org] Namens L.P.H. van Belle via Freeradius-Users Verzonden: vrijdag 17 april 2020 10:46 Aan: FreeRadius users mailing list CC: L.P.H. van Belle Onderwerp: RE: freeradius 3.0.21 rlm_sql_freetds problem
Hm,
I seen the following.
https://packages.networkradius.com/releases/ubuntu-bionic/pool /main/f/freeradius/
And i notice your install :
I have installed freeradius 3.0.21 on ubuntu 18.04 server. I want to use mssql as radius dadabase server, so i installed freetds as apt-get install freetds-dev freetds-bin tdsodbc
apt-cache policy freetds-dev Version table: 1.1.6-1.1 500 500 http://nl.archive.ubuntu.com/ubuntu focal/main amd64 Packages Only on ubuntu repo.
I suggest you fall back to the official package from freeradius. As it looks like the following.
The "ubuntu" version do have MSMSQl build in, while these Might have not : https://packages.networkradius.com/releases/ubuntu-bionic/pool /main/f/freeradius/ I cant verify it since they dont share the source.
But, if you enable the source of Ubuntu, and get the source online, you can recompile these to bionic.
Personaly, i would upgrade the 18.04 server to 20.04, yes i know its not released yet, but thats next week. Then your at least on freeradius 3.0.20.
I hope this helps you a bit.
Greetz,
Louis
-----Oorspronkelijk bericht----- Van: Freeradius-Users [mailto:freeradius-users-bounces+belle=bazuin.nl@lists.freerad ius.org] Namens Ali Arslan via Freeradius-Users Verzonden: vrijdag 17 april 2020 6:14 Aan: FreeRadius users mailing list CC: Ali Arslan Onderwerp: Re: freeradius 3.0.21 rlm_sql_freetds problem
Hi Alan,
> Where did you get the 3.0.21 packages from?
I installed freeradius 3.0.21 by updating /etc/apt/sources.list on ubuntu 18.04 as https://networkradius.com/freeradius-packages/ suggests.
FreeRADIUS Packages - Network RADIUS
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 17/04/2020 09:46, L.P.H. van Belle via Freeradius-Users wrote:
The "ubuntu" version do have MSMSQl build in, while these Might have not : https://packages.networkradius.com/releases/ubuntu-bionic/pool/main/f/freera... I cant verify it since they dont share the source.
What do you mean, we don't share the source? The Jenkinsfiles and Dockerfiles used to build it are all in the FreeRADIUS source repository on github, right alongside the source to the software itself. Can't get much more open than that. To build the packages it essentially does "make deb", or "make rpm" in the source tree. See https://github.com/FreeRADIUS/freeradius-server/blob/master/scripts/jenkins/... It looks like the TDS libraries might not be included in the package dependencies, so it's likely nobody is building packages with support for it. Which probably goes to show how many people are using MS SQL server with FreeRADIUS. Easiest is to build on your own machine. Make sure freetds-dev etc packages are installed and then build from source. -- Matthew
Hai, Ah.. Cool thanks, i didnt see that. Sorry for my blundness.. I tried with deb-src in apt/source.list That didnt pull them, thats what i ment. I'll have a look at the github info, thank you for that. Greetz, Louis
-----Oorspronkelijk bericht----- Van: Freeradius-Users [mailto:freeradius-users-bounces+belle=bazuin.nl@lists.freerad ius.org] Namens Matthew Newton Verzonden: vrijdag 17 april 2020 14:47 Aan: freeradius-users@lists.freeradius.org Onderwerp: Re: freeradius 3.0.21 rlm_sql_freetds problem
On 17/04/2020 09:46, L.P.H. van Belle via Freeradius-Users wrote:
The "ubuntu" version do have MSMSQl build in, while these Might have not : https://packages.networkradius.com/releases/ubuntu-bionic/pool /main/f/freeradius/ I cant verify it since they dont share the source.
What do you mean, we don't share the source?
The Jenkinsfiles and Dockerfiles used to build it are all in the FreeRADIUS source repository on github, right alongside the source to the software itself. Can't get much more open than that.
To build the packages it essentially does "make deb", or "make rpm" in the source tree. See
https://github.com/FreeRADIUS/freeradius-server/blob/master/sc ripts/jenkins/Jenkinsfile.defs
It looks like the TDS libraries might not be included in the package dependencies, so it's likely nobody is building packages with support for it. Which probably goes to show how many people are using MS SQL server with FreeRADIUS.
Easiest is to build on your own machine. Make sure freetds-dev etc packages are installed and then build from source.
-- Matthew - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (4)
-
Alan DeKok -
Ali Arslan -
L.P.H. van Belle -
Matthew Newton