Frerradius with M$ SQL-Problem with query.conf

[Niko Reinhard]

We did as Alan proposed and installed 3.0.20 with the same result.
Than we want to install 3.0.17 (which is the working version on CentOS
7), bute there were no packages at Freradius, therefore we tried to
build the packes from source. But this was impossible due to some
dependencies for python which we cant resolve.
So we used a package from CentOS' own repository directly, but all these
packages have an error - the packet "freeradius-config" (which will be
silently installed by package "freeradius" from networkradius) is
missed. As a workaround we copied the missing files from our working
Cent OS 7 installation and - it does also not work. So we give up.
Then we remembered the proposal from Nick Porter, we installed as he
recommended FR 3.2.0 with the packet freeradius-freetds and - it worked
at first go. Thanks Nick!
So it seems to me the problem lays on the unixodbc driver for release
CentOS/RH 8. Could that be possible?
One remark for someone who wants to install it as we did:
freeradius-freetds needs to bind the EPEL-repository because it installs
2 packets from Freetds.
Alan, we are able to test older versions with unixodbs on release 8 if
this helps, but this is only possible if you please provide us the rpm
packets from Freeradius. Install from scratch seems to be beyond our
skills..

Best regards
Niko Reinhard


Am 22.08.2022 um 23:17 schrieb Alan DeKok:
> On Aug 22, 2022, at 3:37 PM, Niko Reinhard <reiniko at web.de> wrote:
>> "My only suggestion here is to try tracking down...."
>> Hrmm. I can do that gladly, but I'm not so familiar with Freeradius and
>> I dont'know how to get the versions between 3.0.17 and .25... sorry.
>
>    You can use "git" to download the source, and then build it.
>
>> Networkradius offers all versions between 0.20 and 0.25, this should be
>> enough for the start, but - I dont know how to get them! The baseurl is:
>> baseurl=http://packages.networkradius.com/freeradius-3.0/centos/$releasever/
>> and this gives me only the latest version...  can you help me with this
>> please?
>
>    You can use a web browser to open that URL.  Then click around, and you'll see all of the RPMs available.  Right now, I see 3.0.20, 3.0.21, 3.0.22, and 3.0.24.
>
>    You can download them manually.
>
>> Regarding my annex: The file is
>> /etc/raddb/mods-config/sql/main/mssql/queries.conf and the original
>> varaible was ${..class.column_name}, whitch this radiusd does not start.
>> I changed the variable on line 212, 282,390 and 491 to
>> ${....class.column_name} and the the radiusd -X could be started.
>
>    That's already been fixed, thanks.
>
>    And please reply on the public list.  That way other people can see answers, too.
>
>    Alan DeKok.
>