Re: Frerradius with M$ SQL-Problem with query.conf
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@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.
On Aug 24, 2022, at 3:05 PM, Niko Reinhard <reiniko@web.de> wrote:
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.
If you don't need Python, just delete rlm_python. it's fine. And you should be able to just do `make rpm` or `make deb`, and it will build the packages. That's how we build the packages hosted at NetworkRadius.com.
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!
OK, that's good.
So it seems to me the problem lays on the unixodbc driver for release CentOS/RH 8. Could that be possible?
Yes.
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..
We'll see if we can reproduce the problem here. Alan DeKok.
Ok. Thanks, Alan, for your help. Am 24.08.2022 um 21:21 schrieb Alan DeKok:
On Aug 24, 2022, at 3:05 PM, Niko Reinhard <reiniko@web.de> wrote:
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.
If you don't need Python, just delete rlm_python. it's fine.
And you should be able to just do `make rpm` or `make deb`, and it will build the packages. That's how we build the packages hosted at NetworkRadius.com.
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!
OK, that's good.
So it seems to me the problem lays on the unixodbc driver for release CentOS/RH 8. Could that be possible?
Yes.
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..
We'll see if we can reproduce the problem here.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Alan DeKok -
Niko Reinhard