duplicate radacct entries

Ski Mountain ski_the_mountain at yahoo.com
Thu Feb 16 04:13:38 CET 2012


I am using pptp with radiusclient, and a mysql backend.  The problem is that the radiusclient puts in too many entries into the database.  Below is a copy of one client connecting and disconnecting.  



The problem appears to be that for the second entry there is never a acctstoptime entered into the databse, 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.  



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 | LastUpdate          |
+-----------+----------------+------------------+-----------------+-----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+----------------------+---------------------+
|         1 | 4F3C72A5117D00 | 4fed5006f373739c | user at domain.com |           |       | 108.59.9.35  | 0         | Async       | 2012-02-16 04:06:13 | 0000-00-00 00:00:00 |               0 | RADIUS        |                   |                  |               0 |                0 |                 | 22.11.45.88    |                    | Framed-User | PPP            | 10.80.72.1      |              0 |             0 |                      | 2012-02-16 04:06:13 |
|         2 | 4F3C72A5117D01 | 19f60e897a312d37 | user at domain.com |           |       | 108.59.9.35  | 0         | Async       | 2012-02-16 04:06:13 | 2012-02-16 04:06:16 |               3 | RADIUS        |                   |                  |             792 |                0 |                 | 22.11.45.88    | User-Request       | Framed-User | PPP            | 10.80.72.1      |              0 |             0 |                      | 2012-02-16 04:06:16 |
+-----------+----------------+------------------+-----------------+-----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+----------------------+---------------------+
2 rows in set (0.00 sec)


Thanks





More information about the Freeradius-Users mailing list