- Freeradius-Users - lists.freeradius.org

rlm_sql is not updating the record...
by raviprakash sunkara 09 Jun '06

09 Jun '06

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(a)192.168.2.55', nas '192.168.2.55']' rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '666(a)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(a)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(a)192.168.2.20', '63170499b83f412d', ' 666(a)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(a)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(a)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(a)192.168.2.20",User-Name = " 666(a)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(a)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(a)192.168.2.55' modcall[accounting]: module "radutmp" returns ok for request 2 radius_xlat: '666(a)192.168.2.55' rlm_sql (sql): sql_set_user escaped user --> '666(a)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(a)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(a)192.168.2.55', nas '192.168.2.55']' rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '666(a)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(a)192.168.2.20', '63170499b83f412d', ' 666(a)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 -- Thanks and Regards with cheers Sunkara Ravi Prakash (Voip Developer) Hyperion Technology www.hyperion-tech.com <b>

1 0

how to check ldap attrib and take action on accounting start
by Tariq Rashid 09 Jun '06

09 Jun '06

One of our systems uses a fairly basic freeradius system (based on freeradius 1.0.2). A simple LDAP databse is used to check that a password matches the supplied username. What is the recommended way to achieve the following: * upon receipt of accounting start check LDAP to see if an attribute has been set (possibly something like "seenLive"). * if it is set then then take no special action, continue as normal * if it hasn't been set then do the following: - set the attribute so that no special action is taken in future - send a message to a specified server (possibly XML over tcp). this i suspect will be done by calling an executable? or should the python/C modules be used for this? your experience or advice appreciated. tariq

1 0

Re: Freeradius-Users Digest, Vol 14, Issue 39
by Gilbert Lo 09 Jun '06

09 Jun '06

I am on holiday between June 5 to June 9. I will return to my office on June 12. See you soon. Thanks, Gilbert Lo helpdesk at St. George's School

1 0

error: Installed (but unpackaged) files(s) found: on REDHAT Enterprise 4.0 (RHEL4) and FreeRadius 1.1.2
by Alberto Cruz 09 Jun '06

09 Jun '06

Hi I got the following error when I'm trying to build the RPM at RedHat Enterprise 4.0: error: Installed (but unpackaged) files(s) found: /usr/share/doc/freeradius/Acct-Type /usr/share/doc/freeradius/Autz-Type /usr/share/doc/freeradius/CYGWIN /usr/share/doc/freeradius/ChangeLog .... .... etc /usr/share/doc/freeradius/variables.txt I have been searching for a similar post at the archive and I found some related to Release 1.1.1 but I have not clear what to do to fix this behavior. Could anybody help me? Regards Alberto Cruz

2 2

Re: Freeradius-Users Digest, Vol 14, Issue 38
by Gilbert Lo 08 Jun '06

08 Jun '06

I am on holiday between June 5 to June 9. I will return to my office on June 12. See you soon. Thanks, Gilbert Lo helpdesk at St. George's School

1 0

How to rewrite the sql_user_name
by Gunther 08 Jun '06

08 Jun '06

I am trying to rewrite the username (sql_user_name) to always add the realm to the username. I am getting different 'User-Name' and 'Realm' from different NAS units. My db storage format is: user@domain One unit is sending it in this way already (user@domain), the other unit from a different vendor can send the domain in the 'Realm' part: User-Name = user Realm = domain How can I rewrite the User-Name that I always get it in my preferred db format? I tried: sql_user_name = "%{%{Realm:+%{User-Name}@%{Realm}}:-%{User-Name}}" But it seems that the conditional sh syntax :+ does not work, only :- And I do not exactly know if this nested approach could work anyhow. Any hints?

1 0

Need Help!!!!
by Albis Nunez 08 Jun '06

08 Jun '06

Hi, I have a cisco gateway 1750 and Linux redhat 9.0 server with freeradius version 1.1.2. on it. I need help to configure the radius to capture the call record send by the cisco 1750. I installed the radius without a problem on my server I perform a radtest commands from the root terminal and respond back to me, but I configure to get the CDR from the cisco voip gateway and I don't see any activity or record on the radius side. can someone help me. thank you in advance. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

insering the 3 record in radius db my using openser+radius+mysql
by raviprakash sunkara 08 Jun '06

08 Jun '06

Hi I'm using openser and freeradius server . Accounting part in openser and radius by using the mysql. help me ... Below one is radius server in debug mode..... in that is didn't understand what is " unsupported acct-status-type =15 " and " send packet with zero session length " please help me..... rad_recv: Accounting-Request packet from host 192.168.2.55:35094, id=151, length=220 Acct-Status-Type = Failed Service-Type = Sip-Session Sip-Response-Code = 0 Sip-Method = INVITE User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Calling-Station-Id = "sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Called-Station-Id = "sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-Translated-Request-URI = "sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-To-Tag = "n/a" Sip-From-Tag = "757680932" Sip-Cseq = "18235" 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_realm: Looking up realm "192.168.2.55" for User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " rlm_realm: No such realm "192.168.2.55" modcall[preacct]: module "suffix" returns noop for request 2 modcall: leaving group preacct (returns noop) for request 2 Processing the accounting section of radiusd.conf modcall: entering group accounting 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 = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>",User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> "' rlm_acct_unique: Acct-Unique-Session-ID = "5488f64bd8d99c57". modcall[accounting]: module "acct_unique" returns ok for request 2 radius_xlat: '/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606' 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-20060606 modcall[accounting]: module "detail" returns ok for request 2 modcall[accounting]: module "unix" returns noop for request 2 radius_xlat: '/usr/local/var/log/radius/radutmp' rlm_radutmp: NAS radiusdtest port 5060 unknown packet type 15) modcall[accounting]: module "radutmp" returns noop for request 2 rlm_sql (sql): Unsupported Acct-Status-Type = 15 modcall[accounting]: module "sql" returns noop for request 2 modcall: leaving group accounting (returns ok) for request 2 Sending Accounting-Response of id 151 to 192.168.2.55 port 35094 Finished request 2 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... --- Walking the entire request list --- Cleaning up request 2 ID 151 with timestamp 44857cc6 Nothing to do. Sleeping until we see a request. rad_recv: Accounting-Request packet from host 192.168.2.55:35096, id=152, length=232 Acct-Status-Type = Start Service-Type = Sip-Session Sip-Response-Code = 200 Sip-Method = ACK User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Calling-Station-Id = "sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Called-Station-Id = "sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-Translated-Request-URI = "sip:555@192.168.2.21<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> :5060" Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-To-Tag = "2710541959" Sip-From-Tag = "757680932" Sip-Cseq = "18235" 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 3 modcall[preacct]: module "preprocess" returns noop for request 3 rlm_realm: Looking up realm "192.168.2.55" for User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " rlm_realm: No such realm "192.168.2.55" modcall[preacct]: module "suffix" returns noop for request 3 modcall: leaving group preacct (returns noop) for request 3 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 3 rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address = 192.168.2.55,NAS-IP-Address = 192.168.2.55,Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>",User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> "' rlm_acct_unique: Acct-Unique-Session-ID = "5488f64bd8d99c57". modcall[accounting]: module "acct_unique" returns ok for request 3 radius_xlat: '/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606' 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-20060606 modcall[accounting]: module "detail" returns ok for request 3 modcall[accounting]: module "unix" returns ok for request 3 radius_xlat: '/usr/local/var/log/radius/radutmp' radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' modcall[accounting]: module "radutmp" returns ok for request 3 radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' rlm_sql (sql): sql_set_user escaped user --> '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' 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('893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ', '5488f64bd8d99c57', '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', '192.168.2.55', '5060', '', '2006-06-06 18:32:05', '0', '0', '', '', '', '0', '0', 'sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', 'sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', 'Sip-Session', '', '', '0', '0')' rlm_sql (sql): Reserving sql socket id: 2 rlm_sql (sql): Released sql socket id: 2 modcall[accounting]: module "sql" returns ok for request 3 modcall: leaving group accounting (returns ok) for request 3 Sending Accounting-Response of id 152 to 192.168.2.55 port 35096 Finished request 3 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... --- Walking the entire request list --- Cleaning up request 3 ID 152 with timestamp 44857ccd Nothing to do. Sleeping until we see a request. rad_recv: Accounting-Request packet from host 192.168.2.55:35097, id=153, length=232 Acct-Status-Type = Stop Service-Type = Sip-Session Sip-Response-Code = 200 Sip-Method = BYE User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Calling-Station-Id = "sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Called-Station-Id = "sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-Translated-Request-URI = "sip:555@192.168.2.21<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> :5060" Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-To-Tag = "2710541959" Sip-From-Tag = "757680932" Sip-Cseq = "18236" 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 4 modcall[preacct]: module "preprocess" returns noop for request 4 rlm_realm: Looking up realm "192.168.2.55" for User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " rlm_realm: No such realm "192.168.2.55" modcall[preacct]: module "suffix" returns noop for request 4 modcall: leaving group preacct (returns noop) for request 4 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 4 rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address = 192.168.2.55,NAS-IP-Address = 192.168.2.55,Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>",User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> "' rlm_acct_unique: Acct-Unique-Session-ID = "5488f64bd8d99c57". modcall[accounting]: module "acct_unique" returns ok for request 4 radius_xlat: '/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606' 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-20060606 modcall[accounting]: module "detail" returns ok for request 4 modcall[accounting]: module "unix" returns ok for request 4 radius_xlat: '/usr/local/var/log/radius/radutmp' radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' modcall[accounting]: module "radutmp" returns ok for request 4 radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' rlm_sql (sql): sql_set_user escaped user --> '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' radius_xlat: 'UPDATE radacct SET AcctStopTime = '2006-06-06 18:34:11', AcctSessionTime = '', AcctInputOctets = '', AcctOutputOctets = '', AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = '' WHERE AcctSessionId = '893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>' AND UserName = '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>' AND NASIPAddress = '192.168.2.55'' rlm_sql (sql): Reserving sql socket id: 1 radius_xlat: 'stop packet with zero session length. [user '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', nas '192.168.2.55']' rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', nas '192.168.2.55'] rlm_sql (sql): Released sql socket id: 1 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('893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ', '5488f64bd8d99c57', '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', '192.168.2.55', '5060', '', DATE_SUB('2006-06-06 18:34:11', INTERVAL (0 + 0) SECOND), '2006-06-06 18:34:11', '', '', '', '', '', '', 'sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ', 'sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', 'Sip-Session', '', '', '0', '0')' rlm_sql (sql): Released sql socket id: 1 modcall[accounting]: module "sql" returns noop for request 4 modcall: leaving group accounting (returns ok) for request 4 Sending Accounting-Response of id 153 to 192.168.2.55 port 35097 Finished request 4 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... rad_recv: Accounting-Request packet from host 192.168.2.55:35098, id=154, length=232 Acct-Status-Type = Stop Service-Type = Sip-Session Sip-Response-Code = 200 Sip-Method = BYE User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Calling-Station-Id = "sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Called-Station-Id = "sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-Translated-Request-URI = "sip:555@192.168.2.21<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> :5060" Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-To-Tag = "2710541959" Sip-From-Tag = "757680932" Sip-Cseq = "18236" 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 5 modcall[preacct]: module "preprocess" returns noop for request 5 rlm_realm: Looking up realm "192.168.2.55" for User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " rlm_realm: No such realm "192.168.2.55" modcall[preacct]: module "suffix" returns noop for request 5 modcall: leaving group preacct (returns noop) for request 5 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 5 rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address = 192.168.2.55,NAS-IP-Address = 192.168.2.55,Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>",User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> "' rlm_acct_unique: Acct-Unique-Session-ID = "5488f64bd8d99c57". modcall[accounting]: module "acct_unique" returns ok for request 5 radius_xlat: '/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606' 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-20060606 modcall[accounting]: module "detail" returns ok for request 5 modcall[accounting]: module "unix" returns ok for request 5 radius_xlat: '/usr/local/var/log/radius/radutmp' radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' rlm_radutmp: Logout for NAS radiusdtest port 5060, but no Login record modcall[accounting]: module "radutmp" returns ok for request 5 radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' rlm_sql (sql): sql_set_user escaped user --> '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' radius_xlat: 'UPDATE radacct SET AcctStopTime = '2006-06-06 18:34:11', AcctSessionTime = '', AcctInputOctets = '', AcctOutputOctets = '', AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = '' WHERE AcctSessionId = '893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>' AND UserName = '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>' AND NASIPAddress = '192.168.2.55'' rlm_sql (sql): Reserving sql socket id: 0 radius_xlat: 'stop packet with zero session length. [user '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', nas '192.168.2.55']' rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', nas '192.168.2.55'] rlm_sql (sql): Released sql socket id: 0 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('893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ', '5488f64bd8d99c57', '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', '192.168.2.55', '5060', '', DATE_SUB('2006-06-06 18:34:11', INTERVAL (0 + 0) SECOND), '2006-06-06 18:34:11', '', '', '', '', '', '', 'sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ', 'sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', 'Sip-Session', '', '', '0', '0')' rlm_sql (sql): Released sql socket id: 0 -- Thanks and Regards with cheers Sunkara Ravi Prakash (Voip Developer) Hyperion Technology www.hyperion-tech.com <b>

2 1

error: Installed (but unpackaged) files(s) found: on REDHAT Enterprise 4.0 (RHEL4) and FreeRadius 1.1.2
by Alberto Cruz 08 Jun '06

08 Jun '06

Hi I got the following error when I'm trying to build the RPM at RedHat Enterprise 4.0: error: Installed (but unpackaged) files(s) found: /usr/share/doc/freeradius/Acct-Type /usr/share/doc/freeradius/Autz-Type /usr/share/doc/freeradius/CYGWIN /usr/share/doc/freeradius/ChangeLog .... .... etc /usr/share/doc/freeradius/variables.txt I have been searching for a similar post at the archive and I found some related to Release 1.1.1 but I have not clear what to do to fix this behavior. Could anybody help me? Regards Alberto Cruz

1 0

Re: Freeradius-Users Digest, Vol 14, Issue 37
by Gilbert Lo 08 Jun '06

08 Jun '06

I am on holiday between June 5 to June 9. I will return to my office on June 12. See you soon. Thanks, Gilbert Lo helpdesk at St. George's School

1 0