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