<br>
Hi ....<br>
<br>
I'm working openser + mysql + Freeradius....<br>
<br>
when i'm making a call for accounting, first it say "
Acct-Status-Type = Failed " and then its " Acct-Status-Type
= start " <br>
<br>
After that when the User hang up the call , it didn't update the Acct Stop time and inserting the t2 records ...<br>
<br>
And also what means this......<br>
<br>
rlm_sql (sql): Reserving sql socket id: 2<br>
radius_xlat: 'stop packet with zero session length. [user '<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>', nas '<a href="http://192.168.2.55">192.168.2.55</a>']'<br>
rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>', nas '<a href="http://192.168.2.55">192.168.2.55</a>']<br>
rlm_sql (sql): Released sql socket id: 2<br>
<br>
<br>
This query is not updating ---> " 'UPDATE radacct SET AcctStopTime = '2006-06-09 19:57:27',
AcctSessionTime = '', AcctInputOctets = '', AcctOutputOctets = '',
AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = ''
WHERE AcctSessionId =
'<a href="mailto:76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20">76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20</a>' AND NASIPAddress =
'<a href="http://192.168.2.55">192.168.2.55</a>'' " why ?<br>
<br>
<br>
and this query is inserting -----> " INSERT into radacct (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)
values('<a href="mailto:76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20">76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20</a>',
'63170499b83f412d', '<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>', '', '<a href="http://192.168.2.55">192.168.2.55</a>', '5060', '',
DATE_SUB('2006-06-09 19:57:27', INTERVAL (0 + 0) SECOND), '2006-06-09
19:57:27', '', '', '', '', '', '', '<a href="mailto:sip:555@192.168.2.55">sip:555@192.168.2.55</a>',
'<a href="mailto:sip:666@192.168.2.55">sip:666@192.168.2.55</a>', '', 'Sip-Session', '', '', '0', '0')' "<br>
<br>
Acct-Session-time is zero showing ? why ?<br>
<br>
<br>
Can U see the below one .... I need to change . please guys help me ,
this very important to complete the task .... please .<br>
<br>
rad_recv: Accounting-Request packet from host <a href="http://192.168.2.55:33879">192.168.2.55:33879</a>, id=219, length=233<br>
Acct-Status-Type = Stop<br>
Service-Type = Sip-Session<br>
Sip-Response-Code = 200<br>
Sip-Method = BYE<br>
User-Name = "<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>"<br>
Calling-Station-Id = "<a href="mailto:sip:666@192.168.2.55">sip:666@192.168.2.55</a>"<br>
Called-Station-Id = "<a href="mailto:sip:555@192.168.2.55">sip:555@192.168.2.55</a>"<br>
Sip-Translated-Request-URI = "sip:555@192.168.2.21:5060"<br>
Acct-Session-Id = "<a href="mailto:76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20">76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20</a>"<br>
Sip-To-Tag = "2044753626"<br>
Sip-From-Tag = "4110988557"<br>
Sip-Cseq = "57538"<br>
NAS-Port = 5060<br>
Acct-Delay-Time = 0<br>
NAS-IP-Address = <a href="http://192.168.2.55">192.168.2.55</a><br>
Processing the preacct section of radiusd.conf<br>
modcall: entering group preacct for request 2<br>
modcall[preacct]: module "preprocess" returns noop for request 2<br>
rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address =
<a href="http://192.168.2.55">192.168.2.55</a>,NAS-IP-Address = <a href="http://192.168.2.55">192.168.2.55</a>,Acct-Session-Id =
"<a href="mailto:76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20">76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20</a>",User-Name =
"<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>"'<br>
rlm_acct_unique: Acct-Unique-Session-ID = "63170499b83f412d".<br>
modcall[preacct]: module "acct_unique" returns ok for request 2<br>
rlm_realm: Looking up realm "<a href="http://192.168.2.55">192.168.2.55</a>" for User-Name = "<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>"<br>
rlm_realm: No such realm "<a href="http://192.168.2.55">192.168.2.55</a>"<br>
modcall[preacct]: module "suffix" returns noop for request 2<br>
modcall[preacct]: module "files" returns noop for request 2<br>
modcall: leaving group preacct (returns ok) for request 2<br>
Processing the accounting section of radiusd.conf<br>
modcall: entering group accounting for request 2<br>
radius_xlat: '/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060609'<br>
rlm_detail:
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to
/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060609<br>
modcall[accounting]: module "detail" returns ok for request 2<br>
radius_xlat: '/usr/local/var/log/radius/radutmp'<br>
radius_xlat: '<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>'<br>
modcall[accounting]: module "radutmp" returns ok for request 2<br>
radius_xlat: '<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>'<br>
rlm_sql (sql): sql_set_user escaped user --> '<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>'<br>
radius_xlat: 'UPDATE radacct SET AcctStopTime = '2006-06-09
19:57:27', AcctSessionTime = '', AcctInputOctets = '', AcctOutputOctets
= '', AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop =
'' WHERE AcctSessionId =
'<a href="mailto:76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20">76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20</a>' AND
NASIPAddress = '<a href="http://192.168.2.55">192.168.2.55</a>''<br>
rlm_sql (sql): Reserving sql socket id: 2<br>
radius_xlat: 'stop packet with zero session length. [user '<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>', nas '<a href="http://192.168.2.55">192.168.2.55</a>']'<br>
rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>', nas '<a href="http://192.168.2.55">192.168.2.55</a>']<br>
rlm_sql (sql): Released sql socket id: 2<br>
radius_xlat: 'INSERT into radacct (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)
values('<a href="mailto:76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20">76788233-9611-4A96-9FAA-E829F175C69C@192.168.2.20</a>',
'63170499b83f412d', '<a href="mailto:666@192.168.2.55">666@192.168.2.55</a>', '', '<a href="http://192.168.2.55">192.168.2.55</a>', '5060', '',
DATE_SUB('2006-06-09 19:57:27', INTERVAL (0 + 0) SECOND), '2006-06-09
19:57:27', '', '', '', '', '', '', '<a href="mailto:sip:555@192.168.2.55">sip:555@192.168.2.55</a>',
'<a href="mailto:sip:666@192.168.2.55">sip:666@192.168.2.55</a>', '', 'Sip-Session', '', '', '0', '0')'<br>
rlm_sql (sql): Released sql socket id: 2<br>
modcall[accounting]: module "sql" returns noop for request 2<br>
modcall: leaving group accounting (returns ok) for request 2<br>
Sending Accounting-Response of id 219 to <a href="http://192.168.2.55">192.168.2.55</a> port 33879<br>
<br clear="all"><br>-- <br> Thanks and Regards with cheers<br>Sunkara Ravi Prakash (Voip Developer)<br>Hyperion Technology<br><a href="http://www.hyperion-tech.com">www.hyperion-tech.com</a><br><b>