<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=055130222-25092005><FONT face=Arial size=2>The best solution is
to use two different tables for start and stop accounting.</FONT></SPAN></DIV>
<DIV><SPAN class=055130222-25092005><FONT face=Arial size=2>Have a look in the
sql.conf file in FreeRADIUS</FONT></SPAN></DIV>
<DIV><SPAN class=055130222-25092005><FONT face=Arial size=2>Problem is that SER
replaces the Username in the stop-message, with whoever hung
up...</FONT></SPAN></DIV>
<DIV><SPAN class=055130222-25092005><FONT face=Arial size=2>Therefore the
default queries in FreeRADIUS won't find the corresponding
record.</FONT></SPAN></DIV>
<DIV><SPAN class=055130222-25092005></SPAN><SPAN class=055130222-25092005><FONT
face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=055130222-25092005><FONT face=Arial size=2>To get the CDR just
join the two tables on AcctSessionId.</FONT></SPAN></DIV>
<DIV><SPAN class=055130222-25092005><FONT face=Arial size=2>I have experienced
problems joining on the AcctSessionId in MySQL versions prior to 4.1, for some
reason.</FONT></SPAN></DIV>
<DIV><SPAN class=055130222-25092005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=055130222-25092005><FONT face=Arial
size=2>Bjorn</FONT></SPAN></DIV></BODY></HTML>