<div>Hello Alan,</div>
<div> </div>
<div>Thank you so much for your quick response!</div>
<div> </div>
<div>Please check my comments inline below:</div>
<div> </div>
<div class="gmail_quote">
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="Ih2E3d">> Problem: When I have the attribute Session-Timeout in the radcheck<br>> table, I get a Segmentation Fault after the query as run, no matter if<br>> it returns results or not.<br></div> doc/bugs
</blockquote>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><span id=""></span>
<div class="Ih2E3d"><br>> a) I've noticed that freeradius performs Accounting-Request when this<br>> attribute is set, is this normal?<br><br></div> I have no idea what you mean by that. FreeRADIUS doesn't magically
<br>create Accounting-Requests if it sees a Session-Timeout.</blockquote>
<div> </div>
<div>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.</div>
<div> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><span id=""></span>
<div class="Ih2E3d"><br>> b) Is there a limit to the sql query length?<br><br></div> In 1.1.x, yes. About 253 octets in many cases. If the queries are in<br>the configuration (e.g. rlm_sql_ippool), then the queries can be very long.
</blockquote>
<div> </div>
<div>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?
</div>
<div> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><br> In 2.0, the queries in "unlang" can be about 7k in length.<br>
<div class="Ih2E3d"></div></blockquote>
<div> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="Ih2E3d"><span id=""></span><br>> c) Is there a limit to the field name, i.e., should I use "SELECT<br>> This_is_a_very_long_field_name_having_ifs_nulls_etc AS ShortFieldName"<br>> or is it irrelevant?
<br><br></div> There is no limit to field names imposed by FreeRADIUS.<br>
<div class="Ih2E3d"><br>> d) The particular query performs a join to another table, may this be<br>> the source of the problem?<br><br></div> Maybe, if you're using MySQL and an old version of the server. See<br>
doc/ChangeLog in 1.1.7.<br>
<div class="Ih2E3d"><br>> e) Is it mandatory that a query returns results?<br><br></div> Yes.<br>
<div class="Ih2E3d"><br>> f) Can I use multiple 'query' in radius.conf, using the values from a<br>> first query to feed the next one?<br><br></div> Yes, so long as the output from a query goes into a RADIUS attribute.
</blockquote>
<div> </div>
<div>Can you please elaborate, Alan, maybe with a small example or pointer to documentation?</div>
<div> </div>
<div>Thank you for your time! :-)</div>
<div> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><span id=""></span><br><font color="#888888"><br> Alan DeKok.<br>-<br>List info/subscribe/unsubscribe? See
<a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br></font></blockquote></div><br>