duplicate radacct entries

[Ski Mountain]

I guess I did make some updates to that version that actully broke the Simultaneous-Use := 1 that I needed.  Below is the current version, where i reinstated the default sechema.  I think the heart of the problem is the fact that below is just one connection(that created two entries), then I disconnected.  It only updates acctstoptime in one of the entries.  




mysql> select * from radacct;
+-----------+----------------+------------------+-----------------+-----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+----------------------+
| radacctid | acctsessionid  | acctuniqueid     | username        | groupname | realm | nasipaddress | nasportid | nasporttype | acctstarttime       | acctstoptime        | acctsessiontime | acctauthentic | connectinfo_start | connectinfo_stop | acctinputoctets | acctoutputoctets | calledstationid | callingstationid | acctterminatecause | servicetype | framedprotocol | framedipaddress | acctstartdelay | acctstopdelay | xascendsessionsvrkey |
+-----------+----------------+------------------+-----------------+-----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+----------------------+
|         1 | 4F3C899014E700 | c72b782da444ddad | user at domain.com |           |       | 108.59.9.35  | 0         | Async       | 2012-02-16 05:44:00 | NULL                |               0 | RADIUS        |                   |                  |               0 |                0 |                 | 146.115.45.88    |                    | Framed-User | PPP            | 10.80.72.1      |              0 |             0 |                      |
|         2 | 4F3C899014E701 | 3a28576fec37b3cd | user at domain.com |           |       | 108.59.9.35  | 0         | Async       | 2012-02-16 05:44:00 | 2012-02-16 05:44:02 |               2 | RADIUS        |                   |                  |             792 |                0 |                 | 146.115.45.88    | User-Request       | Framed-User | PPP            | 10.80.72.1      |              0 |             0 |                      |
+-----------+----------------+------------------+-----------------+-----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+----------------------+
2 rows in set (0.00 sec)





----- Original Message -----
From: Fajar A. Nugraha <list at fajar.net>
To: Ski Mountain <ski_the_mountain at yahoo.com>
Cc: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Sent: Wednesday, February 15, 2012 11:38 PM
Subject: Re: duplicate radacct entries

On Thu, Feb 16, 2012 at 11:21 AM, Ski Mountain
<ski_the_mountain at yahoo.com> wrote:
> I did not modify the default schema.
>

are you REALLY sure? the default sql schema does NOT have a last
update column :)

> I am just using the radius client that is in debian in order to authenicate pptp clients. Everything is on the same server so it is not a issue with packets being lost.

then most likely something's wrong with the NAS configuration

>
>
> i   radiusclient1                                                                 - /bin/login replacement which uses the RADIUS protocol for authentication
>
> I do blame the nas and have cursed at pptp quite a bit, not I just want the dam thing to only send one radacct packet.

I have setup poptop and openvpn setup which can send acct packets just fine.

As usual, if you're still having problems, ask an expert to help you.

-- 
Fajar