A.L.M.Buxey@lboro.ac.uk wrote:
now - whilst radsqlrelay is recommended for those whose accounting DB systems cannot keep up with the real flow of packets - and we recommend it - its not productive to have imho a broken default config. the issues which i can see from this are the following
(1) the queries are configured in two places. This is bad. It's much better to update rlm_sql to have a "query_filename" configuration. If it exists, then queries are logged to the file, and the databases are *not* used. That's probably less than 100 lines of code.
so what I'd propose is we get a few folk who are successfully using this function, get their radiusd.conf entries, and have 2 sections for uncommenting - one for postgres and one for mysql.
Or, delete the sql_log queries, and use the ones from rlm_sql that are known to work. Alan DeKok.