CheongMeng submitted a patch to allow the SQL module to fail-over. I've reformatted it, and put it up at:
http://www.striker.ottawa.on.ca/~aland/rlm_sql.diff Right now, if the SQL module cannot connect to the server, it returns 'OK'. This means it's impossible to have two SQL modules, with the server failing over to the second, when the first one is down. The patch makes the code return FAIL, if the server is down. I'm inclined to add the patch. I'm not sure how it interacts with Todd's work on SQL re-connect, but I think that *both* patches are a good idea. i.e. If the server is down, try to reconnect. If the reconnect fails, the module should return FAIL. Maybe Todd can integrate this patch into his work... Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
