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 | [EMAIL PROTECTED] |
8794453f19310360 | [EMAIL PROTECTED] | nxs.yi.org |
80.119.12.168 | 5060 | | 2005-09-28
16:26:15 | 0000-00-00 00:00:00 | 0 |
| | | 0 |
0 | sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] | | IAPP-Register
| | | 0 |
0 |
| 2 | [EMAIL PROTECTED] |
8794453f19310360 | [EMAIL PROTECTED] | nxs.yi.org |
80.119.12.168 | 5060 | | 2005-09-28
16:26:15 | 0000-00-00 00:00:00 | 0 |
| | | 0 |
0 | sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] | | IAPP-Register
| | | 0 |
0 |
| 3 | [EMAIL PROTECTED] |
8794453f19310360 | [EMAIL PROTECTED] | nxs.yi.org |
80.119.12.168 | 5060 | | 2005-09-28
16:26:26 | 2005-09-28 16:26:26 | 0 |
| | | 0 |
0 | sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] | | IAPP-Register
| | | 0 |
0 |
| 4 | [EMAIL PROTECTED] |
8794453f19310360 | [EMAIL PROTECTED] | |
80.119.12.168 | 5060 | | 2005-09-28
16:26:35 | 0000-00-00 00:00:00 | 0 |
| | | 0 |
0 | sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] | | IAPP-Register
| | | 0 |
0 |
| 5 | [EMAIL PROTECTED] |
8794453f19310360 | [EMAIL PROTECTED] | |
80.119.12.168 | 5060 | | 2005-09-28
16:26:35 | 0000-00-00 00:00:00 | 0 |
| | | 0 |
0 | sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] | | IAPP-Register
| | | 0 |
0 |
| 6 | [EMAIL PROTECTED] |
8794453f19310360 | [EMAIL PROTECTED] | |
80.119.12.168 | 5060 | | 2005-09-28
16:26:46 | 2005-09-28 16:26:46 | 0 |
| | | 0 |
0 | sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] | | 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
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
