<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi All,<div><br></div><div>Alan mercilessly ripped out all the connection pool logic in rlm_sql and replaced it with calls to the generic connection pool API which is new in 3.0.</div><div><br></div><div>In anyone's running an SQL DB and wants to test it'd be much appreciated.</div><div><br></div><div>New code is in Master@HEAD.</div><div><br></div><div>WARNING: This change breaks compatibility with V2.0 configs, you will need an empty pool { } stanza in each instance of rlm_sql configuration or the server will fail to load. See here <a href="https://github.com/alandekok/freeradius-server/blob/master/raddb/modules/sql">https://github.com/alandekok/freeradius-server/blob/master/raddb/modules/sql</a> for the full pool configuration sub-section.</div><div><br></div><div>The following configuration items no longer have any effect: num_sql_socks, connect_failure_retry_delay, lifetime, max_queries. Their equivalents are, (start, mix, max, spare), *none* , lifetime, uses.</div><div><br></div><div><br></div><div>DEVELOPERS NOTE: From this point onwards any new modules which use a pool of connections, or would benefit from a pool of connections but doesn't use the connection API, will not be accepted. </div><div><br></div><div>Code for connection pool is here:</div><div><a href="https://github.com/alandekok/freeradius-server/blob/master/src/main/connection.c">https://github.com/alandekok/freeradius-server/blob/master/src/main/connection.c</a></div><div><br></div><div>#include <freeradius-devel/connection.h></div><div><br></div><div>-Arran</div><div><br></div><div><div apple-content-edited="true">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Arran Cudbard-Bell<br><a href="mailto:a.cudbardb@freeradius.org">a.cudbardb@freeradius.org</a><br><br>Betelwiki, Betelwiki, Betelwiki....<span class="Apple-converted-space"> </span>http://wiki.freeradius.org/ !</div></div>
</div>
<br></div></body></html>