28 Sep
2005
28 Sep
'05
5:36 p.m.
Hello,
I have some problems to solve before using Freeside
I configure ser for accounting (acc module) with
freeradius-1.0.1 and mysql to store accounting
I set flag for invite and bye/cancel messages however
i have more than one RadAcctId per AcctSessionId .
Here is my radacct table:
mysql> select * from radacct;
+-----------+----------------------------------+------------------+---------------+------------+---------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+----------------------------------+-------------------+--------------------+---------------+----------------+-----------------+----------------+---------------+
| RadAcctId | AcctSessionId |
AcctUniqueId | UserName | Realm |
NASIPAddress | NASPortId | NASPortType |
AcctStartTime | AcctStopTime |
AcctSessionTime | AcctAuthentic | ConnectInfo_start |
ConnectInfo_stop | AcctInputOctets | AcctOutputOctets
| CalledStationId | CallingStationId
| AcctTerminateCause | ServiceType | FramedProtocol
| FramedIPAddress | AcctStartDelay | AcctStopDelay |
+-----------+----------------------------------+------------------+---------------+------------+---------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+----------------------------------+-------------------+--------------------+---------------+----------------+-----------------+----------------+---------------+
| 1 | bb1e53c6-584dd9b0-e3f97bf7(a)192.1 |
8794453f19310360 | 85(a)nxs.yi.org | nxs.yi.org |
80.119.12.168 | 5060 | | 2005-09-28
16:26:15 | 0000-00-00 00:00:00 | 0 |
| | | 0 |
0 | sip:87@nxs.yi.org=3Buser=3Dphone |
sip:85@nxs.yi.org | | IAPP-Register
| | | 0 |
0 |
| 2 | bb1e53c6-584dd9b0-e3f97bf7(a)192.1 |
8794453f19310360 | 85(a)nxs.yi.org | nxs.yi.org |
80.119.12.168 | 5060 | | 2005-09-28
16:26:15 | 0000-00-00 00:00:00 | 0 |
| | | 0 |
0 | sip:87@nxs.yi.org=3Buser=3Dphone |
sip:85@nxs.yi.org | | IAPP-Register
| | | 0 |
0 |
| 3 | bb1e53c6-584dd9b0-e3f97bf7(a)192.1 |
8794453f19310360 | 85(a)nxs.yi.org | nxs.yi.org |
80.119.12.168 | 5060 | | 2005-09-28
16:26:26 | 2005-09-28 16:26:26 | 0 |
| | | 0 |
0 | sip:87@nxs.yi.org=3Buser=3Dphone |
sip:85@nxs.yi.org | | IAPP-Register
| | | 0 |
0 |
| 4 | bb1e53c6-584dd9b0-e3f97bf7(a)192.1 |
8794453f19310360 | 85(a)nxs.yi.org | |
80.119.12.168 | 5060 | | 2005-09-28
16:26:35 | 0000-00-00 00:00:00 | 0 |
| | | 0 |
0 | sip:87@nxs.yi.org=3Buser=3Dphone |
sip:85@nxs.yi.org | | IAPP-Register
| | | 0 |
0 |
| 5 | bb1e53c6-584dd9b0-e3f97bf7(a)192.1 |
8794453f19310360 | 85(a)nxs.yi.org | |
80.119.12.168 | 5060 | | 2005-09-28
16:26:35 | 0000-00-00 00:00:00 | 0 |
| | | 0 |
0 | sip:87@nxs.yi.org=3Buser=3Dphone |
sip:85@nxs.yi.org | | IAPP-Register
| | | 0 |
0 |
| 6 | bb1e53c6-584dd9b0-e3f97bf7(a)192.1 |
8794453f19310360 | 85(a)nxs.yi.org | |
80.119.12.168 | 5060 | | 2005-09-28
16:26:46 | 2005-09-28 16:26:46 | 0 |
| | | 0 |
0 | sip:87@nxs.yi.org=3Buser=3Dphone |
sip:85@nxs.yi.org | | IAPP-Register
| | | 0 |
0 |
+-----------+----------------------------------+------------------+---------------+------------+---------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+----------------------------------+-------------------+--------------------+---------------+----------------+-----------------+----------------+---------------+
6 rows in set (0.00 sec)
Regards
Harry
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com