> Problem: When I have the attribute Session-Timeout in the radcheck
> table, I get a Segmentation Fault after the query as run, no matter if
> it returns results or not.
doc/bugs
> a) I've noticed that freeradius performs Accounting-Request when this
> attribute is set, is this normal?
I have no idea what you mean by that. FreeRADIUS doesn't magically
create Accounting-Requests if it sees a Session-Timeout.
I think I've might misinterpreted a log. I've just tried to duplicate this behaviour without success, now I see only Access-Request packets. If this happens again, I'll try to be more informative.
> b) Is there a limit to the sql query length?
In 1.1.x, yes. About 253 octets in many cases. If the queries are in
the configuration (e.g. rlm_sql_ippool), then the queries can be very long.
Ok, this is certainly a problem for me. I can't change freeradius version (at least not now, maybe in the future) so I assume the only option is to 'exec' external scripts to perform more complex queries, am I right?
In 2.0, the queries in "unlang" can be about 7k in length.
> c) Is there a limit to the field name, i.e., should I use "SELECT
> This_is_a_very_long_field_name_having_ifs_nulls_etc AS ShortFieldName"
> or is it irrelevant?
There is no limit to field names imposed by FreeRADIUS.
> d) The particular query performs a join to another table, may this be
> the source of the problem?
Maybe, if you're using MySQL and an old version of the server. See
doc/ChangeLog in 1.1.7.
> e) Is it mandatory that a query returns results?
Yes.
> f) Can I use multiple 'query' in radius.conf, using the values from a
> first query to feed the next one?
Yes, so long as the output from a query goes into a RADIUS attribute.
Can you please elaborate, Alan, maybe with a small example or pointer to documentation?
Thank you for your time! :-)
Alan DeKok.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html