Problem with MySQL and Accouting-On record

[Alan DeKok]

On Nov 10, 2020, at 4:23 AM, Ángel L. Mateo <amateo at um.es> wrote:
> 
> 	Ok. I think I'm closer to the problem.
> 
> 	I have attached 2 debug files, for 2 different tests I have run. Boths tests have been run with an empty mysql.

  That's good.
...
> 	In the debug_dontwork.txt I have done this:
> 
> * Start freeradius
> * 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)
> * 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.
> * Send accouting stop record for the previous user (request (5)). This request is never been processed from buffered files, because (6) and later always tries to make first the pending "Accouting-On"

  OK, the issue is that there's no "fall back" query which runs when there "accounting-on" packet doesn't update any rows.

  I've pushed fixes which will be part of 3.0.22.

  This kind of feedback is *exactly* what I need in order to find and fix problems.

  Alan DeKok.