[Users] Billing System

[harry gaillac]

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 at 192.1 |
8794453f19310360 | 85 at 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 at nxs.yi.org=3Buser=3Dphone |
sip:85 at nxs.yi.org |                    | IAPP-Register
|                |                 |              0 | 
           0 |
|         2 | bb1e53c6-584dd9b0-e3f97bf7 at 192.1 |
8794453f19310360 | 85 at 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 at nxs.yi.org=3Buser=3Dphone |
sip:85 at nxs.yi.org |                    | IAPP-Register
|                |                 |              0 | 
           0 |
|         3 | bb1e53c6-584dd9b0-e3f97bf7 at 192.1 |
8794453f19310360 | 85 at 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 at nxs.yi.org=3Buser=3Dphone |
sip:85 at nxs.yi.org |                    | IAPP-Register
|                |                 |              0 | 
           0 |
|         4 | bb1e53c6-584dd9b0-e3f97bf7 at 192.1 |
8794453f19310360 | 85 at 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 at nxs.yi.org=3Buser=3Dphone |
sip:85 at nxs.yi.org |                    | IAPP-Register
|                |                 |              0 | 
           0 |
|         5 | bb1e53c6-584dd9b0-e3f97bf7 at 192.1 |
8794453f19310360 | 85 at 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 at nxs.yi.org=3Buser=3Dphone |
sip:85 at nxs.yi.org |                    | IAPP-Register
|                |                 |              0 | 
           0 |
|         6 | bb1e53c6-584dd9b0-e3f97bf7 at 192.1 |
8794453f19310360 | 85 at 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 at nxs.yi.org=3Buser=3Dphone |
sip:85 at 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