harry gaillac wrote:
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)
Really?
<script type="text/javascript" language="javascript1.2">
<!--
// Do print the page
if (typeof(window.print) != 'undefined') {
window.print();
}
//-->
</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.com
------------------------------------------------------------------------
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
------------------------------------------------------------------------
_______________________________________________
Serusers mailing list
[EMAIL PROTECTED]
http://mail.iptel.org/mailman/listinfo/serusers
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
