- Freeradius-Users - lists.freeradius.org

Pb with Mac and EAP auth
by Benoît Bianchi 15 Dec '05

15 Dec '05

Hi, Im using Freeradius for both Mac and WPA authentication (EAP-TTLS) of my WiFi users, and im facing a trouble I have no idea how to solve : In my users file Ive set a list of the mac address like this : # Portable MACHIN "001122334455" Auth-Type := Accept Cisco-AVpair := "ssid=Machin", Cisco-AVpair += "ssid=Machin2" And for users a password crypt file filecrypt DEFAULT Autz-Type := filecrypt The problem is that when doing EAP-TTLS authentication if I set the mac address of one of the allowed card as the login name I am authenticated!!! Is there a way to prevent this somehow? To specify that Auth-Type:=Accept is only for non EAP authentication ??? Thanks for help Benoît Bianchi <mailto:benoit.bianchi@cri.uvsq.fr> .

2 1

Cisco-AVPair SQL accounting (attr. not duplicated)
by James Wakefield (Sunet Sysadmin) 15 Dec '05

15 Dec '05

G'day, Sorry if this has been covered already, as I imagine it's a common issue, but I haven't been able to rustle any working answers up after a long time googling and grepping $FR/src. I've got an AS5300 that sends a few attributes, with accounting stop, encapsulated in Cisco-AVPair eg: Cisco-AVPair = "nas-tx-speed=53300" and the VSA hack doesn't appear to let me refer to that value in my SQL statements with either the %{nas-tx-speed} or %{Cisco-AVPair[index]} syntaxes I've seen suggested for Cisco VSAs in various places. rlm_sql complains of an unknown xlat function or non-existent attribute. Has anyone managed to do this? If so, what is the correct syntax to use these in SQL accounting statements? Cheers, -- James Wakefield Systems Administrator +61 03 5227 6888 We have now moved head office to 8-12 Pakington Street, Geelong West.

3 2

Freeradius as Proxy
by Nicola Iotti 15 Dec '05

15 Dec '05

Hi, I'm using Freeradius 1.0.5 as Proxy , but does anyone knows if freeradius have just to send requests from NAS to Server or also server's replies to the nas ? I mean does the radius serves reply directly to NAS or it communicates always through the freeradius proxy? Regards Ing. Nicola Iotti Network Manager mailto: nicola.iotti(a)guglielmo.biz Guglielmo S.r.l. Sede legale: Via Martiri di Minozzo, 12 Sede operativa: Via Sante Vincenzi , 2 / D 42100 Reggio Emilia ITALIA Tel.: +39-0522 - 40 63 67 Fax: +39-0522 - 54 08 16 Cell: +39-320 61 90 072 internet website: http://www.guglielmo.biz mailto:info@guglielmo.biz

2 1

Help with proxy scenario
by markcapelle＠pcmc.com 15 Dec '05

15 Dec '05

I have a need to proxy users based on either AD group membership or a substring in the username. I am currently using LDAP to AD . AD group membership scenario: If user is in group "x" then proxy to radius server "y". Substring scenario: If username contains string "x", then strip "x" and proxy to server "y". I believe both could work. Which is easiest and what modules are needed? Also, any examples of either would be greatly appreciated. Thanks, Mark CONFIDENTIALITY NOTICE: This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying or distribution of this message in whole or in part is strictly prohibited. Please inform the sender immediately and destroy the original transmittal. Thank you for your cooperation.

1 0

Re: Welcome to the "Freeradius-Users" mailing list (Digest mode)
by yao guoxian 15 Dec '05

15 Dec '05

Hello! EveryOne! Nice to meet you! 2005/12/15, freeradius-users-request(a)lists.freeradius.org < freeradius-users-request(a)lists.freeradius.org>: > > Welcome to the Freeradius-Users(a)lists.freeradius.org mailing list! > > To post to this list, send your email to: > > freeradius-users(a)lists.freeradius.org > > General information about the mailing list is at: > > http://lists.freeradius.org/mailman/listinfo/freeradius-users > > If you ever want to unsubscribe or change your options (eg, switch to > or from digest mode, change your password, etc.), visit your > subscription page at: > > > http://lists.freeradius.org/mailman/options/freeradius-users/yaoguoxian%40g… > > > You can also make such adjustments via email by sending a message to: > > Freeradius-Users-request(a)lists.freeradius.org > > with the word `help' in the subject or body (don't include the > quotes), and you will get back a message with instructions. > > You must know your password to change your options (including changing > the password, itself) or to unsubscribe. It is: > > uvazgi > > Normally, Mailman will remind you of your lists.freeradius.org mailing > list passwords once every month, although you can disable this if you > prefer. This reminder will also include instructions on how to > unsubscribe or change your account options. There is also a button on > your options page that will email your current password to you. >

2 1

Re[4]: how get current TRAFFIC (ACCT) ?
by Andreas Sokov 15 Dec '05

15 Dec '05

Hi. [ You wrote Thursday, December 15, 2005, 2:52:10 PM ] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SE> Well you have set up your pppoe-server to send the accounting information SE> only at the end of the session. If connection is "lost", you will have the SE> accounting data in your database with AcctTerminateCause something like SE> "terminated by server". SE> The session you have sent me is just an open session. SE> As I said - you can set the Acct-Interim-Interval attribute so that your SE> server sends the accouting packets every few minutes for example. i try i insert into radreply : id UserName Attribute op Value 1 test Framed-IP-Address := 192.168.96.10 4 test Acct-Status-Type := Interim-Update 5 test Acct-Interim-Interval := 60 6 test Framed-IP-Netmask := 255.255.252.0 but it is not worked you wrote : add attribute into dictionary file tell me please IN WHAT FILE I NEED ADD IT ? and what will have to line ? into /etc/freeradius folder i c one file ./dictionaty : # # This is the master dictionary file, which references the # pre-defined dictionary files included with the server. # # Any new/changed attributes MUST be placed in this file, as # the pre-defined dictionaries SHOULD NOT be edited. # # $Id: dictionary.in,v 1.4 2004/04/14 15:26:20 aland Exp $ # # # The filename given here should be an absolute path. # $INCLUDE /usr/share/freeradius/dictionary # # Place additional attributes or $INCLUDEs here. They will # over-ride the definitions in the pre-defined dictionaries. # # See the 'man' page for 'dictionary' for information on # the format of the dictionary files. # # If you want to add entries to the dictionary file, # which are NOT going to be placed in a RADIUS packet, # add them here. The numbers you pick should be between # 3000 and 4000. # #ATTRIBUTE My-Local-String 3000 string #ATTRIBUTE My-Local-IPAddr 3001 ipaddr #ATTRIBUTE My-Local-Integer 3002 integer what i need add there ? like this : ATTRIBUTE Acct-Interim-Interval 3003 integer ATTRIBUTE Acct-Status-Type 3004 string ?? SE> -----Original Message----- SE> From: Andreas Sokov [mailto:andre.s@j8.com.ru] SE> Sent: Donnerstag, 15. Dezember 2005 12:42 SE> To: freeradius-users(a)lists.freeradius.org SE> Cc: edvin.seferovic(a)kolp.at SE> Subject: Re[2]: how get current TRAFFIC (ACCT) ? SE> Hi. SE> [ You wrote Thursday, December 15, 2005, 2:14:10 PM ] SE> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SE> =-= SE>> Hi, SE>> for traffic information - look at the RADACCT table in your mysql SE> database SE>> called radius. A simple sql query could be - SE> -) SE> i know what information about traffic collect in that table. SE> But please, look at this : SE> RadAcctId AcctSessionId AcctUniqueId UserName Realm SE> NASIPAddress NASPortId NASPortType AcctStartTime AcctStopTime SE> AcctSessionTime AcctAuthentic ConnectInfo_start SE> ConnectInfo_stop AcctInputOctets AcctOutputOctets SE> CalledStationId CallingStationId AcctTerminateCause SE> ServiceType FramedProtocol FramedIPAddress SE> AcctStartDelay AcctStopDelay SE> 19 43A154E9151B00 835535e0e65d3ace test SE> 213.159.102.146 0 Virtual 2005-12-15 14:35:05 0000-00-00 SE> 00:00:00 0 RADIUS 0 0 SE> Framed-User PPP 192.168.96.10 0 0 SE> 18 43A13CE87DBE00 73e57ea8afc72d3b test SE> 213.159.102.146 0 Virtual 2005-12-15 12:52:40 2005-12-15 SE> 14:10:12 4652 RADIUS 6857793 7229167 SE> User-Request Framed-User PPP 192.168.96.10 0 0 SE> look at id=19 into AcctStopTime and SE> while session OPENS! the value AcctInputOctets AcctOutputOctets == 0 SE> !!! SE> and if session will be open during 20 hourse - we can not know that current SE> value of SE> AcctInputOctets AcctOutputOctets ?! SE> What you think about it ? SE>> SELECT SUM(AcctOutputOctets) as download, SUM(AcctInputOctets) as upload SE>> GROUP BY Username ORDER BY Username ASC; SE>> This should give you a list of your users and their upload and download SE>> traffic ( list is sorted ascending by usernames ). SE>> Regards, SE>> Edvin SE>> -----Original Message----- SE>> From: freeradius-users-bounces(a)lists.freeradius.org SE>> [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of SE> Andreas SE>> Sokov SE>> Sent: Donnerstag, 15. Dezember 2005 11:33 SE>> To: freeradius-users(a)lists.freeradius.org SE>> Subject: how get current TRAFFIC (ACCT) ? SE>> Importance: High SE>> Hi, freeradius-users. SE>> Linux Debian, # uname -a SE>> Linux g48 2.6.14.3-1 #4 Sun Dec 11 05:57:57 MSK 2005 i686 GNU/Linux SE>> #freeradius -v SE>> freeradius: FreeRADIUS Version 1.0.5, for host , built on Oct 16 2005 at SE>> 11:56:56 SE>> # mysql -V SE>> mysql Ver 14.12 Distrib 5.0.13-rc, for pc-linux-gnu (i486) using SE> readline SE>> 5.0 SE>> TELL ME PLEASE : HOW I CAN GET CURRENT TRAFFIC INFORMATION ? SE>> I need to kno how much traffic user eat before it close your session. SE>> Do Know anybody ? SE>> I try radwho, radlast - but they show all but acct information SE>> Try radacct - but it is not show anything info, just run and no SE> information SE>> ... SE>> HELP PLEASE. SE> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SE> =-= SE> -- ------------------------------------- SE> Best Regards, Andreas SE> Thursday, December 15, 2005 2:36:16 PM SE> Web-Media L.t.d. SE> +7 (901) 301-5811 SE> ICQ UIN 177624 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- ------------------------------------- Best Regards, Andreas Thursday, December 15, 2005 2:55:28 PM Web-Media L.t.d. +7 (901) 301-5811 ICQ UIN 177624

2 1

Re[2]: how get current TRAFFIC (ACCT) ?
by Andreas Sokov 15 Dec '05

15 Dec '05

Hi. [ You wrote Thursday, December 15, 2005, 2:14:10 PM ] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SE> Hi, SE> for traffic information - look at the RADACCT table in your mysql database SE> called radius. A simple sql query could be - -) i know what information about traffic collect in that table. But please, look at this : RadAcctId 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 19 43A154E9151B00 835535e0e65d3ace test 213.159.102.146 0 Virtual 2005-12-15 14:35:05 0000-00-00 00:00:00 0 RADIUS 0 0 Framed-User PPP 192.168.96.10 0 0 18 43A13CE87DBE00 73e57ea8afc72d3b test 213.159.102.146 0 Virtual 2005-12-15 12:52:40 2005-12-15 14:10:12 4652 RADIUS 6857793 7229167 User-Request Framed-User PPP 192.168.96.10 0 0 look at id=19 into AcctStopTime and while session OPENS! the value AcctInputOctets AcctOutputOctets == 0 !!! and if session will be open during 20 hourse - we can not know that current value of AcctInputOctets AcctOutputOctets ?! What you think about it ? SE> SELECT SUM(AcctOutputOctets) as download, SUM(AcctInputOctets) as upload SE> GROUP BY Username ORDER BY Username ASC; SE> This should give you a list of your users and their upload and download SE> traffic ( list is sorted ascending by usernames ). SE> Regards, SE> Edvin SE> -----Original Message----- SE> From: freeradius-users-bounces(a)lists.freeradius.org SE> [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Andreas SE> Sokov SE> Sent: Donnerstag, 15. Dezember 2005 11:33 SE> To: freeradius-users(a)lists.freeradius.org SE> Subject: how get current TRAFFIC (ACCT) ? SE> Importance: High SE> Hi, freeradius-users. SE> Linux Debian, # uname -a SE> Linux g48 2.6.14.3-1 #4 Sun Dec 11 05:57:57 MSK 2005 i686 GNU/Linux SE> #freeradius -v SE> freeradius: FreeRADIUS Version 1.0.5, for host , built on Oct 16 2005 at SE> 11:56:56 SE> # mysql -V SE> mysql Ver 14.12 Distrib 5.0.13-rc, for pc-linux-gnu (i486) using readline SE> 5.0 SE> TELL ME PLEASE : HOW I CAN GET CURRENT TRAFFIC INFORMATION ? SE> I need to kno how much traffic user eat before it close your session. SE> Do Know anybody ? SE> I try radwho, radlast - but they show all but acct information SE> Try radacct - but it is not show anything info, just run and no information SE> ... SE> HELP PLEASE. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- ------------------------------------- Best Regards, Andreas Thursday, December 15, 2005 2:36:16 PM Web-Media L.t.d. +7 (901) 301-5811 ICQ UIN 177624

2 1

Re[2]: HELP - Freeradius+mysql - LOST ACCOUNTING
by Andreas Sokov 15 Dec '05

15 Dec '05

Hi. [ You wrote Thursday, December 15, 2005, 2:14:10 PM ] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SE> Hi, SE> use Acct-Interim-Interval attribute I TRY! and no changes Tell me please in that table i need write this attribute ? SE> ( maybe you will need to change your dictionary file ). yes, i had search this attribute and not foubd in any dictionaty Help me please - in what file of dictionalty i need write it ? SE> This also depends on pppoe which is using radclient - I SE> am not sure if it is supported by your server. I am using Poptop with SE> freeradius and it works. TEll me please what is PopTop ? SE> Regards, SE> Edvin SE> -----Original Message----- SE> From: freeradius-users-bounces(a)lists.freeradius.org SE> [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Andreas SE> Sokov SE> Sent: Donnerstag, 15. Dezember 2005 11:29 SE> To: freeradius-users(a)lists.freeradius.org SE> Subject: HELP - Freeradius+mysql - LOST ACCOUNTING SE> Importance: High SE> Hi, freeradius-users-bounces. SE> I use pppoe+ppp+freeradius+mysql on Linux Debian. SE> When user connect by pppoe - into radacct table insertes records, where SE> inOctets & out ==0 SE> If session will be 20 hours - data about acct will be updated after session SE> will be close. SE> But if session will be lost - i lost ALL DATA ABOUT TRAFFIC (ACCT) SE> Tel me please - how i can update with interval current traffic for ever SE> connected users ? =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- ------------------------------------- Best Regards, Andreas Thursday, December 15, 2005 2:42:04 PM Web-Media L.t.d. +7 (901) 301-5811 ICQ UIN 177624

1 0

HELP - Freeradius+mysql - LOST ACCOUNTING
by Andreas Sokov 15 Dec '05

15 Dec '05

Hi, freeradius-users-bounces. I use pppoe+ppp+freeradius+mysql on Linux Debian. When user connect by pppoe - into radacct table insertes records, where inOctets & out ==0 If session will be 20 hours - data about acct will be updated after session will be close. But if session will be lost - i lost ALL DATA ABOUT TRAFFIC (ACCT) Tel me please - how i can update with interval current traffic for ever connected users ? -- Best Regards, Andreas Thursday, December 15, 2005 3:22:10 AM "Do not hesitate to ask me" ICQ UIN 177624 http://ServersLease.net - Offshore Dedicated Servers, Offshore Collocation http://HOST-LUX.RU - Offshore Virtual Hosting, Web Hosting, as low as 5$ per 1Gb HDD/month http://Reg-Master.net - Register`s Master of Domains http://Web-Media.Ru - Web Design studio. http://VEHICLE.RU - автомобили на заказ из США

2 1

how get current TRAFFIC (ACCT) ?
by Andreas Sokov 15 Dec '05

15 Dec '05

Hi, freeradius-users. Linux Debian, # uname -a Linux g48 2.6.14.3-1 #4 Sun Dec 11 05:57:57 MSK 2005 i686 GNU/Linux #freeradius -v freeradius: FreeRADIUS Version 1.0.5, for host , built on Oct 16 2005 at 11:56:56 # mysql -V mysql Ver 14.12 Distrib 5.0.13-rc, for pc-linux-gnu (i486) using readline 5.0 TELL ME PLEASE : HOW I CAN GET CURRENT TRAFFIC INFORMATION ? I need to kno how much traffic user eat before it close your session. Do Know anybody ? I try radwho, radlast - but they show all but acct information Try radacct - but it is not show anything info, just run and no information ... HELP PLEASE. -- Best Regards, Andreas Thursday, December 15, 2005 1:29:42 PM "Do not hesitate to ask me" ICQ UIN 177624 http://ServersLease.net - Offshore Dedicated Servers, Offshore Collocation http://HOST-LUX.RU - Offshore Virtual Hosting, Web Hosting, as low as 5$ per 1Gb HDD/month http://Reg-Master.net - Register`s Master of Domains http://Web-Media.Ru - Web Design studio. http://VEHICLE.RU - автомобили на заказ из США

2 1