The best solution is to use two different tables for start and stop
accounting.
Have a look in the sql.conf file in FreeRADIUS
Problem is that SER replaces the Username in the stop-message, with
whoever hung up...
Therefore the default queries in FreeRADIUS won't find the corresponding
record.
To get the CDR just join the two tables on AcctSessionId.
I have experienced problems joining on the AcctSessionId in MySQL
versions prior to 4.1, for some reason.
Bjorn
Show replies by date