<br>
<br>
Hi&nbsp;&nbsp; <br>
<br>
I'm using openser and freeradius server . Accounting part in openser and radius by using the mysql.<br>
<br>
<br>
help me ...<br>
<br>
Below one&nbsp;&nbsp; is&nbsp; radius&nbsp; server&nbsp; in debug mode.....<br>
<br>
in that is didn't understand&nbsp; <br>
<br>
what is &quot; unsupported acct-status-type =15 &quot; and &quot; send packet with zero session length &quot; <br>
<br>
<br>
please help me.....<br>
<br>
<br clear="all">rad_recv: Accounting-Request packet from host <a href="http://192.168.2.55:35094">192.168.2.55:35094</a>,<br>
id=151, length=220<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Status-Type = Failed<br>
&nbsp; &nbsp; &nbsp; &nbsp;Service-Type = Sip-Session<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Response-Code = 0<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Method = INVITE<br>
&nbsp; &nbsp; &nbsp; &nbsp;User-Name = &quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Calling-Station-Id = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Called-Station-Id = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.55'); return false;" target="_blank">
555@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Translated-Request-URI = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.55'); return false;" target="_blank">
555@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Session-Id =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-To-Tag = &quot;n/a&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-From-Tag = &quot;757680932&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Cseq = &quot;18235&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;NAS-Port = 5060<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Delay-Time = 0<br>
&nbsp; &nbsp; &nbsp; &nbsp;NAS-IP-Address = <a href="http://192.168.2.55">192.168.2.55</a><br>
&nbsp;Processing the preacct section of radiusd.conf<br>
modcall: entering group preacct for request 2<br>
&nbsp;modcall[preacct]: module &quot;preprocess&quot; returns noop for request 2<br>
&nbsp; &nbsp;rlm_realm: Looking up realm &quot;<a href="http://192.168.2.55">192.168.2.55</a>&quot; for User-Name =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
&quot;<br>
&nbsp; &nbsp;rlm_realm: No such realm &quot;<a href="http://192.168.2.55">192.168.2.55</a>&quot;<br>
&nbsp;modcall[preacct]: module &quot;suffix&quot; returns noop for request 2<br>
modcall: leaving group preacct (returns noop) for request 2<br>
&nbsp;Processing the accounting section of radiusd.conf<br>
modcall: entering group accounting for request 2<br>
rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address =<br>
<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 =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>&quot;,User-Name =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
&quot;'<br>
rlm_acct_unique: Acct-Unique-Session-ID = &quot;5488f64bd8d99c57&quot;.<br>
&nbsp;modcall[accounting]: module &quot;acct_unique&quot; returns ok for request 2<br>
radius_xlat: <br>
'/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606'<br>
rlm_detail:<br>
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d<br>
expands to<br>
/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606<br>
&nbsp;modcall[accounting]: module &quot;detail&quot; returns ok for request 2<br>
&nbsp;modcall[accounting]: module &quot;unix&quot; returns noop for request 2<br>
radius_xlat: &nbsp;'/usr/local/var/log/radius/radutmp'<br>
rlm_radutmp: NAS radiusdtest port 5060 unknown packet type 15)<br>
&nbsp;modcall[accounting]: module &quot;radutmp&quot; returns noop for request 2<br>
rlm_sql (sql): Unsupported Acct-Status-Type = 15<br>
&nbsp;modcall[accounting]: module &quot;sql&quot; returns noop for request 2<br>
modcall: leaving group accounting (returns ok) for request 2<br>
Sending Accounting-Response of id 151 to <a href="http://192.168.2.55">192.168.2.55</a> port 35094<br>
Finished request 2<br>
Going to the next request<br>
--- Walking the entire request list ---<br>
Waking up in 6 seconds...<br>
--- Walking the entire request list ---<br>
Cleaning up request 2 ID 151 with timestamp 44857cc6<br>
Nothing to do. &nbsp;Sleeping until we see a request.<br>
rad_recv: Accounting-Request packet from host <a href="http://192.168.2.55:35096">192.168.2.55:35096</a>,<br>
id=152, length=232<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Status-Type = Start<br>
&nbsp; &nbsp; &nbsp; &nbsp;Service-Type = Sip-Session<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Response-Code = 200<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Method = ACK<br>
&nbsp; &nbsp; &nbsp; &nbsp;User-Name = &quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Calling-Station-Id = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Called-Station-Id = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.55'); return false;" target="_blank">
555@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Translated-Request-URI = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.21'); return false;" target="_blank">
555@192.168.2.21</a>:5060&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Session-Id =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-To-Tag = &quot;2710541959&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-From-Tag = &quot;757680932&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Cseq = &quot;18235&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;NAS-Port = 5060<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Delay-Time = 0<br>
&nbsp; &nbsp; &nbsp; &nbsp;NAS-IP-Address = <a href="http://192.168.2.55">192.168.2.55</a><br>
&nbsp;Processing the preacct section of radiusd.conf<br>
modcall: entering group preacct for request 3<br>
&nbsp;modcall[preacct]: module &quot;preprocess&quot; returns noop for request 3<br>
&nbsp; &nbsp;rlm_realm: Looking up realm &quot;<a href="http://192.168.2.55">192.168.2.55</a>&quot; for User-Name =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
&quot;<br>
&nbsp; &nbsp;rlm_realm: No such realm &quot;<a href="http://192.168.2.55">192.168.2.55</a>&quot;<br>
&nbsp;modcall[preacct]: module &quot;suffix&quot; returns noop for request 3<br>
modcall: leaving group preacct (returns noop) for request 3<br>
&nbsp;Processing the accounting section of radiusd.conf<br>
modcall: entering group accounting for request 3<br>
rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address =<br>
<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 =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>&quot;,User-Name =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
&quot;'<br>
rlm_acct_unique: Acct-Unique-Session-ID = &quot;5488f64bd8d99c57&quot;.<br>
&nbsp;modcall[accounting]: module &quot;acct_unique&quot; returns ok for request 3<br>
radius_xlat: <br>
'/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606'<br>
rlm_detail:<br>
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d<br>
expands to<br>
/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606<br>
&nbsp;modcall[accounting]: module &quot;detail&quot; returns ok for request 3<br>
&nbsp;modcall[accounting]: module &quot;unix&quot; returns ok for request 3<br>
radius_xlat: &nbsp;'/usr/local/var/log/radius/radutmp'<br>
radius_xlat: &nbsp;'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55
</a>'<br>
&nbsp;modcall[accounting]: module &quot;radutmp&quot; returns ok for request 3<br>
radius_xlat: &nbsp;'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55
</a>'<br>
rlm_sql (sql): sql_set_user escaped user --&gt; '<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>'<br>
radius_xlat: &nbsp;'INSERT into radacct (AcctSessionId, AcctUniqueId,<br>
UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime,<br>
AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,<br>
ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,<br>
CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol,<br>
FramedIPAddress, AcctStartDelay, AcctStopDelay)<br>
values('<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>',<br>
'5488f64bd8d99c57', '<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55
</a>', '', '<a href="http://192.168.2.55">192.168.2.55</a>', '5060', '',<br>
'2006-06-06 18:32:05', '0', '0', '', '', '', '0', '0',<br>
'sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.55'); return false;" target="_blank">555@192.168.2.55</a>
', 'sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
', '', 'Sip-Session', '',<br>
'', '0', '0')'<br>
rlm_sql (sql): Reserving sql socket id: 2<br>
rlm_sql (sql): Released sql socket id: 2<br>
&nbsp;modcall[accounting]: module &quot;sql&quot; returns ok for request 3<br>
modcall: leaving group accounting (returns ok) for request 3<br>
Sending Accounting-Response of id 152 to <a href="http://192.168.2.55">192.168.2.55</a> port 35096<br>
Finished request 3<br>
Going to the next request<br>
--- Walking the entire request list ---<br>
Waking up in 6 seconds...<br>
--- Walking the entire request list ---<br>
Cleaning up request 3 ID 152 with timestamp 44857ccd<br>
Nothing to do. &nbsp;Sleeping until we see a request.<br>
rad_recv: Accounting-Request packet from host <a href="http://192.168.2.55:35097">192.168.2.55:35097</a>,<br>
id=153, length=232<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Status-Type = Stop<br>
&nbsp; &nbsp; &nbsp; &nbsp;Service-Type = Sip-Session<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Response-Code = 200<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Method = BYE<br>
&nbsp; &nbsp; &nbsp; &nbsp;User-Name = &quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Calling-Station-Id = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Called-Station-Id = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.55'); return false;" target="_blank">
555@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Translated-Request-URI = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.21'); return false;" target="_blank">
555@192.168.2.21</a>:5060&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Session-Id =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-To-Tag = &quot;2710541959&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-From-Tag = &quot;757680932&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Cseq = &quot;18236&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;NAS-Port = 5060<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Delay-Time = 0<br>
&nbsp; &nbsp; &nbsp; &nbsp;NAS-IP-Address = <a href="http://192.168.2.55">192.168.2.55</a><br>
&nbsp;Processing the preacct section of radiusd.conf<br>
modcall: entering group preacct for request 4<br>
&nbsp;modcall[preacct]: module &quot;preprocess&quot; returns noop for request 4<br>
&nbsp; &nbsp;rlm_realm: Looking up realm &quot;<a href="http://192.168.2.55">192.168.2.55</a>&quot; for User-Name =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
&quot;<br>
&nbsp; &nbsp;rlm_realm: No such realm &quot;<a href="http://192.168.2.55">192.168.2.55</a>&quot;<br>
&nbsp;modcall[preacct]: module &quot;suffix&quot; returns noop for request 4<br>
modcall: leaving group preacct (returns noop) for request 4<br>
&nbsp;Processing the accounting section of radiusd.conf<br>
modcall: entering group accounting for request 4<br>
rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address =<br>
<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 =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>&quot;,User-Name =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
&quot;'<br>
rlm_acct_unique: Acct-Unique-Session-ID = &quot;5488f64bd8d99c57&quot;.<br>
&nbsp;modcall[accounting]: module &quot;acct_unique&quot; returns ok for request 4<br>
radius_xlat: <br>
'/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606'<br>
rlm_detail:<br>
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d<br>
expands to<br>
/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606<br>
&nbsp;modcall[accounting]: module &quot;detail&quot; returns ok for request 4<br>
&nbsp;modcall[accounting]: module &quot;unix&quot; returns ok for request 4<br>
radius_xlat: &nbsp;'/usr/local/var/log/radius/radutmp'<br>
radius_xlat: &nbsp;'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55
</a>'<br>
&nbsp;modcall[accounting]: module &quot;radutmp&quot; returns ok for request 4<br>
radius_xlat: &nbsp;'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55
</a>'<br>
rlm_sql (sql): sql_set_user escaped user --&gt; '<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>'<br>
radius_xlat: &nbsp;'UPDATE radacct SET AcctStopTime = '2006-06-06 18:34:11',<br>
AcctSessionTime = '', AcctInputOctets = '', AcctOutputOctets = '',<br>
AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = ''<br>
WHERE AcctSessionId =<br>
'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>' AND UserName =<br>
'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>' AND NASIPAddress = '
<a href="http://192.168.2.55">192.168.2.55</a>''<br>
rlm_sql (sql): Reserving sql socket id: 1<br>
radius_xlat: &nbsp;'stop packet with zero session length. [user<br>
'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">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.<br>
[user '<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">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: 1<br>
radius_xlat: &nbsp;'INSERT into radacct (AcctSessionId, AcctUniqueId,<br>
UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime,<br>
AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,<br>
ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,<br>
CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol,<br>
FramedIPAddress, AcctStartDelay, AcctStopDelay)<br>
values('<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>',<br>
'5488f64bd8d99c57', '<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55
</a>', '', '<a href="http://192.168.2.55">192.168.2.55</a>', '5060', '',<br>
DATE_SUB('2006-06-06 18:34:11', INTERVAL (0 + 0) SECOND), '2006-06-06<br>
18:34:11', '', '', '', '', '', '', 'sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.55'); return false;" target="_blank">
555@192.168.2.55</a>',<br>
'sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
', '', 'Sip-Session', '', '', '0', '0')'<br>
rlm_sql (sql): Released sql socket id: 1<br>
&nbsp;modcall[accounting]: module &quot;sql&quot; returns noop for request 4<br>
modcall: leaving group accounting (returns ok) for request 4<br>
Sending Accounting-Response of id 153 to <a href="http://192.168.2.55">192.168.2.55</a> port 35097<br>
Finished request 4<br>
Going to the next request<br>
--- Walking the entire request list ---<br>
Waking up in 6 seconds...<br>
rad_recv: Accounting-Request packet from host <a href="http://192.168.2.55:35098">192.168.2.55:35098</a>,<br>
id=154, length=232<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Status-Type = Stop<br>
&nbsp; &nbsp; &nbsp; &nbsp;Service-Type = Sip-Session<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Response-Code = 200<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Method = BYE<br>
&nbsp; &nbsp; &nbsp; &nbsp;User-Name = &quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Calling-Station-Id = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Called-Station-Id = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.55'); return false;" target="_blank">
555@192.168.2.55</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Translated-Request-URI = &quot;sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.21'); return false;" target="_blank">
555@192.168.2.21</a>:5060&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Session-Id =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-To-Tag = &quot;2710541959&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-From-Tag = &quot;757680932&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;Sip-Cseq = &quot;18236&quot;<br>
&nbsp; &nbsp; &nbsp; &nbsp;NAS-Port = 5060<br>
&nbsp; &nbsp; &nbsp; &nbsp;Acct-Delay-Time = 0<br>
&nbsp; &nbsp; &nbsp; &nbsp;NAS-IP-Address = <a href="http://192.168.2.55">192.168.2.55</a><br>
&nbsp;Processing the preacct section of radiusd.conf<br>
modcall: entering group preacct for request 5<br>
&nbsp;modcall[preacct]: module &quot;preprocess&quot; returns noop for request 5<br>
&nbsp; &nbsp;rlm_realm: Looking up realm &quot;<a href="http://192.168.2.55">192.168.2.55</a>&quot; for User-Name =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
&quot;<br>
&nbsp; &nbsp;rlm_realm: No such realm &quot;<a href="http://192.168.2.55">192.168.2.55</a>&quot;<br>
&nbsp;modcall[preacct]: module &quot;suffix&quot; returns noop for request 5<br>
modcall: leaving group preacct (returns noop) for request 5<br>
&nbsp;Processing the accounting section of radiusd.conf<br>
modcall: entering group accounting for request 5<br>
rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address =<br>
<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 =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>&quot;,User-Name =<br>
&quot;<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
&quot;'<br>
rlm_acct_unique: Acct-Unique-Session-ID = &quot;5488f64bd8d99c57&quot;.<br>
&nbsp;modcall[accounting]: module &quot;acct_unique&quot; returns ok for request 5<br>
radius_xlat: <br>
'/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606'<br>
rlm_detail:<br>
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d<br>
expands to<br>
/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606<br>
&nbsp;modcall[accounting]: module &quot;detail&quot; returns ok for request 5<br>
&nbsp;modcall[accounting]: module &quot;unix&quot; returns ok for request 5<br>
radius_xlat: &nbsp;'/usr/local/var/log/radius/radutmp'<br>
radius_xlat: &nbsp;'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55
</a>'<br>
rlm_radutmp: Logout for NAS radiusdtest port 5060, but no Login record<br>
&nbsp;modcall[accounting]: module &quot;radutmp&quot; returns ok for request 5<br>
radius_xlat: &nbsp;'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55
</a>'<br>
rlm_sql (sql): sql_set_user escaped user --&gt; '<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">
666@192.168.2.55</a>'<br>
radius_xlat: &nbsp;'UPDATE radacct SET AcctStopTime = '2006-06-06 18:34:11',<br>
AcctSessionTime = '', AcctInputOctets = '', AcctOutputOctets = '',<br>
AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = ''<br>
WHERE AcctSessionId =<br>
'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>' AND UserName =<br>
'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>' AND NASIPAddress = '
<a href="http://192.168.2.55">192.168.2.55</a>''<br>
rlm_sql (sql): Reserving sql socket id: 0<br>
radius_xlat: &nbsp;'stop packet with zero session length. [user<br>
'<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">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.<br>
[user '<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">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: 0<br>
radius_xlat: &nbsp;'INSERT into radacct (AcctSessionId, AcctUniqueId,<br>
UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime,<br>
AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,<br>
ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,<br>
CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol,<br>
FramedIPAddress, AcctStartDelay, AcctStopDelay)<br>
values('<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=893D5817-07A7-40D2-B0A8-987237749015%40192.168.2.20'); return false;" target="_blank">
893D5817-07A7-40D2-B0A8-987237749015@192.168.2.20</a>',<br>
'5488f64bd8d99c57', '<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55
</a>', '', '<a href="http://192.168.2.55">192.168.2.55</a>', '5060', '',<br>
DATE_SUB('2006-06-06 18:34:11', INTERVAL (0 + 0) SECOND), '2006-06-06<br>
18:34:11', '', '', '', '', '', '', 'sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=555%40192.168.2.55'); return false;" target="_blank">
555@192.168.2.55</a>',<br>
'sip:<a href="https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&amp;uid=70#Compose" onclick="Popup.composeWindow('pcompose.php?sendto=666%40192.168.2.55'); return false;" target="_blank">666@192.168.2.55</a>
', '', 'Sip-Session', '', '', '0', '0')'<br>
rlm_sql (sql): Released sql socket id: 0<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>&lt;b&gt;