duplicate radacct entries

[Fajar A. Nugraha]

On Thu, Feb 16, 2012 at 10:13 AM, Ski Mountain
<ski_the_mountain at yahoo.com> wrote:
> The problem appears to be that for the second entry there is never a acctstoptime entered into the databse,

Both entries have DIFFERENT acctsessionid (and thus, different
acctuniqueid). That means the NAS is sending acct for two different
sessions.

> or is there a way to make it so only entry is entered into the database.  where is just says 0000-00-00 00:00:00.

Blame the NAS.

It's possible that:
- on the first record, the NAS is only sending acct-stop
- an acct-stop packet is lost
- you modified the default scheme, since by default an accounting
record without acct-stop would have NULL in acctstoptime

I suggest you:

(1) log acct packets to detail file as well. e.g.

accounting {
...
detail
sql
...
}

that way you can examine the detail file later to see what packets FR
recieved from the NAS. That way you can correctly determine which of
the three possibilites above actually happen

(2) add an additional column: acct-status-type, and modify the sql
queries accordingly.
Similar to the above, but this way you can quickly determine whether
an acct-stop packet is lost.

-- 
Fajar