Hi, the accounting queries in sql.conf and the sample sql_log module in radiusd.conf are not identical. For consistency, I'd expect to find the same things there. Any specific reason, or can I just copy over the usual queries from sql.conf into that module and expect them to work? Greetings, Stefan Winter -- Stefan WINTER Stiftung RESTENA - Réseau Téléinformatique de l'Education Nationale et de la Recherche Ingenieur Forschung & Entwicklung 6, rue Richard Coudenhove-Kalergi L-1359 Luxembourg E-Mail: stefan.winter@restena.lu Tel.: +352 424409-1 http://www.restena.lu Fax: +352 422473
Stefan Winter wrote:
the accounting queries in sql.conf and the sample sql_log module in radiusd.conf are not identical. For consistency, I'd expect to find the same things there. Any specific reason, or can I just copy over the usual queries from sql.conf into that module and expect them to work?
In short: you can copy your queries into sql_log and it'll work. The sample queries in rlm_sql_log are a little simpler than rlm_sql because there is no retry mechanism with alternative queries in rlm_sql_log. The alternative queries are not really needed anymore because since MySQL 4.1 you can write "INSERT ... ON DUPLICATE KEY UPDATE ..." in a single statement. However I have no idea if this syntax can work with other databases than MySQL. -- Nicolas Baradakis
participants (2)
-
Nicolas Baradakis -
Stefan Winter