Hello,
I try to setup ser-0.9.4 for accounting with
freeradius-1.0.2 and mysql-4.
Here is a part of my ser.cfg file
# -- acc params --
modparam("acc", "db_url",
"mysql://xxx:[EMAIL PROTECTED]/ser")
modparam("acc", "radius_config",
"/etc/radiusclient-ng/radiusclient.conf")
modparam("acc", "log_fmt", "miocfsp")
modparam("acc", "failed_transactions", 1)
modparam("acc", "db_flag", 2)
modparam("acc", "db_missed_flag", 3)
modparam("acc", "service_type", 16)
modparam("acc", "report_cancels", 1)
modparam("acc", "report_ack", 1)
modparam("acc", "radius_flag", 4)
modparam("acc", "radius_missed_flag", 5)
I set "setflag(4);" for INVITE BYE and CANCEL
messages.
Look at my sql.php.html file (no script)
I can't fix Acct-Start-Time and Acct-Stop-Time to
calculate Acct-Session-Time with freeside
How can I do it ?
Thanks for help
Regards
Harry
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.comTitle: Résultat de la requête SQL - phpMyAdmin 2.6.2
Résultat de la requête SQL
Serveur: localhost
Base de données: radius
Généré le : Dimanche 16 Octobre 2005 à 17:19
Généré par: phpMyAdmin 2.6.2 / MySQL 4.0.24_Debian-10sarge1-log
requête SQL: SELECT * FROM `radacct` LIMIT 0, 30;
Enregistrements: 5
|
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] |
368b436f04276620 |
[EMAIL PROTECTED] |
nxs.yi.org |
80.119.13.76 |
5060 |
|
2005-10-16 17:10:10 |
0000-00-00 00:00:00 |
0 |
|
|
|
0 |
0 |
sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] |
|
IAPP-AP-Check |
|
|
0 |
0 |
| 2 |
[EMAIL PROTECTED] |
368b436f04276620 |
[EMAIL PROTECTED] |
nxs.yi.org |
80.119.13.76 |
5060 |
|
2005-10-16 17:10:10 |
0000-00-00 00:00:00 |
0 |
|
|
|
0 |
0 |
sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] |
|
IAPP-AP-Check |
|
|
0 |
0 |
| 3 |
[EMAIL PROTECTED] |
368b436f04276620 |
[EMAIL PROTECTED] |
|
80.119.13.76 |
5060 |
|
2005-10-16 17:10:30 |
0000-00-00 00:00:00 |
0 |
|
|
|
0 |
0 |
sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] |
|
IAPP-AP-Check |
|
|
0 |
0 |
| 4 |
[EMAIL PROTECTED] |
368b436f04276620 |
[EMAIL PROTECTED] |
|
80.119.13.76 |
5060 |
|
2005-10-16 17:10:30 |
0000-00-00 00:00:00 |
0 |
|
|
|
0 |
0 |
sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] |
|
IAPP-AP-Check |
|
|
0 |
0 |
| 5 |
[EMAIL PROTECTED] |
368b436f04276620 |
[EMAIL PROTECTED] |
|
80.119.13.76 |
5060 |
|
2005-10-16 17:10:32 |
2005-10-16 17:10:32 |
0 |
|
|
|
0 |
0 |
sip:[EMAIL PROTECTED] |
sip:[EMAIL PROTECTED] |
|
IAPP-AP-Check |
|
|
0 |
0 |
|
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
