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