[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