I'm afraid that the patch doesn't work with my config. I have run the same problem test with the patch applied (now I'm running 3.0.21 with the patch) 1. Start freeradius 2. Send accounting start record for one user (request (1)). This record is stored in mysql and deleted from the buffered file. This NAS (155.54.213.5) is different than the one sending Accouting-On packets (155.54.213.6) 3. Send "Accouting-On" packet from other NAS than previous (request (2) and (3)). This request updates no record (line 3267) and is not deleted from the buffered file. It doesn't update any record because I don't any record stored from this NAS, so it's correct not to update any record. 4. Send accouting stop record for the previous user (request (4) and (5)). This request is never been processed from buffered files. After step 3, there is a eduroam_sql.work file with the content of the "Accounting-On" request. And after step 4, there is also a eduroam_sql file with the content of the Stop request, and the eduroam_sql.work is still there with the same content (Accounting-On). I guess the "SELECT true" statement doesn't make the desire behaviour. This is what is shown in the debug (the whole debug in in the attached debug.txt file): (3) sql: Executing query: UPDATE radacct SET acctstoptime = FROM_UNIXTIME(1605258058), acctsessiontime = '1605258058' - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = 'NAS-Reboot' WHERE acctstoptime IS NULL AND nasipaddress = '155.54.213.6' AND acctstarttime <= FROM_UNIXTIME(1605258058) rlm_sql_mysql: Rows matched: 0 Changed: 0 Warnings: 0 (3) sql: SQL query returned: success (3) sql: 0 record(s) updated (3) sql: Trying next query... (3) sql: EXPAND SELECT true (3) sql: --> SELECT true (3) sql: Executing query: SELECT true (3) sql: SQL query returned: success (3) sql: -1 record(s) updated (3) sql: No additional queries configured rlm_sql (sql): Released connection (0) (3) [sql] = noop (3) } # accounting = noop To run the test, I'm sending accounting packets with radclient from the localhost, not from the real NAS. I have also attached the files with packets I'm sending. The command I use is: cat acct_stop.txt | radclient -d /etc/freeradius/3.0/ -x localhost:1813 acct <SECRET> El 12/11/20 a las 14:42, Alan DeKok escribió:
On Nov 12, 2020, at 8:01 AM, Ángel L. Mateo <amateo@um.es> wrote:
Is there any place where I can take it and apply to my installation? I can't find it at github. I don't know if it isn't there or that I don't find it.
You can just download the updated file here:
https://github.com/FreeRADIUS/freeradius-server/blob/v3.0.x/raddb/mods-confi...
This kind of feedback is *exactly* what I need in order to find and fix problems. I'm sorry about not providing the correct information since the beginning.
Thanks. It's why I'm so fanatical about asking for the debug output. Nothing else really helps.
Thank you for your help.
Despite my general crankiness, it's what I do. You're welcome/
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Angel L. Mateo Martínez Sección de Telemática Área de Tecnologías de la Información y las Comunicaciones Aplicadas (ATICA) http://www.um.es/atica Tfo: 868889150 Fax: 868888337