- Freeradius-Users - lists.freeradius.org

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

Another RPM build issue with version 1.1.1
by Sandworm 08 Jun '06

08 Jun '06

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello There appears to be a conflict with the Makefiles in the doc directories and the behaviour of RPM. With version 1.1.0, this was OK as they were both consistent, but are not with version 1.1.1. Now when the RPMs are built (on RHEL3 U6), the build bombs out with: RPM build errors: Installed (but unpackaged) file(s) found: /usr/share/doc/freeradius/Acct-Type /usr/share/doc/freeradius/Autz-Type /usr/share/doc/freeradius/CYGWIN /usr/share/doc/freeradius/ChangeLog /usr/share/doc/freeradius/DIFFS /usr/share/doc/freeradius/MACOSX etc... This is because the Makefiles in the doc directories have lines like this: $(INSTALL) -d -m 755 $(R)$(datadir)/doc/freeradius whereas version 1.1.0 had lines like: $(INSTALL) -d -m 755 $(R)$(datadir)/doc/freeradius- $(RADIUSD_VERSION) RPMs %doc macro, however (AFAIK), uses the version in the path, and the documentation seems to say this too (from http://www.rpm.org/max-rpm-snapshot/s1-rpm-inside-files-list- directives.html, "When the package is installed, RPM creates a directory in the documentation directory named the same as the package (ie, <software>-<version>-<release>)"). This is what I am seeing during the RPM build - a relevant extract: Processing files: freeradius-1.1.1-0 Executing(%doc): /bin/sh -e /var/tmp/rpm-tmp.18818 + umask 022 + cd /usr/src/redhat/BUILD + cd freeradius-1.1.1 + DOCDIR=/var/tmp/freeradius-root/usr/share/doc/freeradius-1.1.1 + export DOCDIR Incidentally, apart from this, even if the Makefile/RPM conflict were resolved, not all files get copied into the doc directory, I think, and this was true with version 1.1.0 as well. The only files seen there are: ls /usr/share/doc/freeradius-1.1.0 ChangeLog COPYRIGHT INSTALL README todo To get the other files there, it would unfortunately need a more detailed list in the %files section of the SPEC file as shown below: %files %defattr(-,root,root) %doc doc/Acct-Type doc/Autz-Type doc/CYGWIN doc/ChangeLog doc/DIFFS doc/MACOSX %doc doc/OS2 doc/Post-Auth-Type doc/RADIUS-LDAP-eDirectory doc/RADIUS-SQL.schema %doc doc/README doc/Session-Type doc/Simultaneous-Use doc/aaa.txt doc/ascend %doc doc/bay doc/bugs doc/cisco doc/coding-methods.txt doc/configurable_failover %doc doc/duplicate-users doc/ldap_howto.txt doc/load-balance.txt doc/misc-nas %doc doc/module_interface doc/mssql doc/performance-testing doc/processing_users_file %doc doc/proxy doc/radrelay doc/release-method.txt doc/rfc/ doc/rlm* doc/supervise-radiusd.txt %doc doc/tuning_guide doc/variables.txt todo/ COPYRIGHT INSTALL Regards SW -----BEGIN PGP SIGNATURE----- Note: This signature can be verified at https://www.hushtools.com/verify Version: Hush 2.5 wkYEARECAAYFAkQp19gACgkQmw4BJyaatJ3xhgCgsjwbq8mP6XhQpsqSTLCBFena9fUA nAvGkYPRHnlRzCnV+FMt5R6F5lOm =jS3p -----END PGP SIGNATURE-----

4 3

FW: Install - Freeradius can't connect to MySQL
by Cliff Hayes 08 Jun '06

08 Jun '06

Here's even more light: When I start freeradius by just typing radiusd on the command line, it connects to MySQL ok. But if I start it like I'm supposed to: service radiusd start, it doesn't. I'm using Fedora 5 with the latest freeradius.i386, freeradius-unixODBC.i386, and freeradius-mysql.i386. Cliff -----Original Message----- From: freeradius-users-bounces+chayes=afo.net(a)lists.freeradius.org [mailto:freeradius-users-bounces+chayes=afo.net@lists.freeradius.org]On Behalf Of Cliff Hayes Sent: Wednesday, June 07, 2006 4:03 PM To: freeradius-users(a)lists.freeradius.org Subject: FW: Install - Freeradius can't connect to MySQL Hello again, This may shed some light on the situation. When I run in debug mode with -x option, it looks like it may be connecting. Am I interpreting the output correctly? If so, is it normal to connect 5 times? Cliff Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 rlm_sql_mysql: Starting connect to MySQL server for #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 rlm_sql_mysql: Starting connect to MySQL server for #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 rlm_sql_mysql: Starting connect to MySQL server for #4 rlm_sql (sql): Connected new DB handle, #4 Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id Module: Instantiated acct_unique (acct_unique) Module: Loaded files Module: Instantiated files (files) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. -----Original Message----- From: freeradius-users-bounces+chayes=afo.net(a)lists.freeradius.org [mailto:freeradius-users-bounces+chayes=afo.net@lists.freeradius.org]On Behalf Of Cliff Hayes Sent: Wednesday, June 07, 2006 2:28 PM To: freeradius-users(a)lists.freeradius.org Subject: Install - Freeradius can't connect to MySQL Hello, Warning - newbie installing Freeradius. I get this in the radius.log even though the sql.conf has the correct host/user/password (and I can access MySQL from the command line using the same login criteria): Wed Jun 7 14:01:52 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Wed Jun 7 14:01:52 2006 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:radius Wed Jun 7 14:01:52 2006 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)' Wed Jun 7 14:01:52 2006 : Error: rlm_sql (sql): Failed to connect DB handle #0 Wed Jun 7 14:01:52 2006 : Info: Ready to process requests. Thanks, Cliff - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

3 3

Re: Freeradius-Users Digest, Vol 14, Issue 36
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

Re: Freeradius-Users Digest, Vol 14, Issue 35
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