[Users] Billing System

Klaus Darilion klaus.mailinglists at pernau.at
Wed Sep 28 17:31:00 CEST 2005


Sorry Harry, but this email is not readable.

you may try to attach it as .txt file in a readable format

regards
klaus

harry gaillac wrote:
> 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
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
> 
> 





More information about the Users mailing list