RE: Different user attributes based onNAS-IP-Address?AlsoSuffixwildcards available?

2006-03-31 Thread John Mylchreest
Using the standard schema, no it doesn't. However adding an nshortname field on 
*check/*reply allows us to define either a shortname from the nas table, or a 
null to achieve this.

I was however hoping there was a nicer way.
Regardless, I appreciate the time :)

Cheers,
John

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok
Sent: 31 March 2006 04:03
To: FreeRadius users mailing list
Subject: Re: Different user attributes based 
onNAS-IP-Address?AlsoSuffixwildcards available? 

John Mylchreest [EMAIL PROTECTED] wrote:
 This is a single username, but the return being selective based on NAS.
 
 For example:
 
 Radreply will reply with an IP of 1.2.0.1 if NAS=1 else it will respond with 
 IP of 1.1.0.1 if NAS=2, else it will respond with an IP of 1.3.0.1

  I'm not sure that the SQL module supports this.

  Alan DeKok.
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Communications on or through ioko's computer systems may be monitored or 
recorded to secure effective system operation and for other lawful purposes.

Unless otherwise agreed expressly in writing, this communication is to be 
treated as confidential and the information in it may not be used or disclosed 
except for the purpose for which it has been sent. If you have reason to 
believe that you are not the intended recipient of this communication, please 
contact the sender immediately. No employee is authorised to conclude any 
binding agreement on behalf of ioko with another party by e-mail without prior 
express written confirmation.

ioko365 Ltd.  VAT reg 656 2443 31. Reg no 3048367. All rights reserved.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


frontend for freeradius???

2006-03-31 Thread Olaf Schäfer
@Guy Fraser

Hi,
I read that you've been working 'on some PHP functions to manage
FreeRadius'. I'm goning to do some efforts in the same direction:
extending dialup admin with managing abilities for ip-pools,
simultaneous-use, rlm_counter etc.
Especially I'm interested in your functions to acquire information from
configuration files.

best regards,
Olaf

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: dialup admin ippool administraton

2006-03-31 Thread Olaf Schäfer
  
  But the configuration information like range-start etc. is still
  stored in the radiusd.conf. My idea was to put these configuration
  information for each ippool into the mysql-db.
 
   That may be harder to do.  But if you can create a patch, it will be
 welcome.

I'm afraid this exceeds my abilities :(

Thus I resigned to the fact and have started to parse the radiusd.conf
via PHP.

Olaf Schaefer

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Separate query for authentication and authorization

2006-03-31 Thread vignesh
Hello
I want to have multiple queries in RADIUS (e.g. one for prepaid and one
for postpaid users). can I do this in Free Radius, if yes how do I
specify free radius to execute particular query.

Also the authentication and authorization seems to call the same query.
Can I have different query fro authentication and authorization.

Thanks 
Vignesh

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Two times authorization and/or both proxying and serving

2006-03-31 Thread Mark Supersonik


First of all, thanks for your help !!! We appreciate so much!!
Let me explain that the misunderstanding of the sentence is probably much a 
problem of my poor acaedemichal english semantics.


Well, I will explain the scenario I told again, trying to do it finnest 
possible:


 We have a proxy Radius that must proxy or reject the request depending on 
if the authserver's WISP has quota on our system.
 Inside proxy, we must forward the incoming request from a roaming user to 
a domain authserv ONLY AND ONLY IF we can verify WISP-domain has a prepaid 
quota in proxy's database.
 We want so to programme the pre-proxy block in order to determine if the 
request must be proxied to the final authserv or must be reject by the 
proxy.


How can we implement this functionality from a technical point of view? Can 
we use a module in pre-proxy state? Or we only have the solution of 
programme JRadius handling the incoming request to proxy?  Or maybe the 
logical solution is to use exec module?


We need a little more help...sorry and thanks a lot from all the stuff 
here!!!


   Nets 
Research Group  (Pompeu Fabra University of Barcelona)



From: Alan DeKok [EMAIL PROTECTED]
Reply-To: FreeRadius users mailing list 
freeradius-users@lists.freeradius.org

To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Subject: Re: Two times authorization and/or both proxying and serving Date: 
Thu, 30 Mar 2006 13:19:30 -0500


Mark Supersonik [EMAIL PROTECTED] wrote:
 My doubt is: can a freeradius server do first an authorization of a
 request throught a DB (i.e MySQL) and proxy then if so or reject it
 (if all isn't in rule)?

  Yes.

 We want only to accept access if each one of the two
 servers process  the authentication successfully.

  MySQL doesn't do authentication.  Your statement is incorrect.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See 
http://www.freeradius.org/list/users.html


_
Grandes éxitos, superhéroes, imitaciones, cine y TV... 
http://es.msn.kiwee.com/ Lo mejor para tu móvil.


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


multiple attribute instaces and radius variables (xlat)

2006-03-31 Thread Andriy Gapon
 Andriy Gapon avg at icyb.net.ua wrote:
 Is it possible to add something like %{Attr-Name[*]} that would expand
 to all values of an attribute and something like %{Attr-Name[#]} that
 would expand to number of attribute instances ?
 
   This works in the CVS head.  I'm not sure why it isn't in 1.1.1.

Alan,

thanks a lot for the information, I've pulled the latest version of
xlat.c from CVS.
It seems that the current version of xlat.c in HEAD is 1.107 2006/03/16,
but 1.1.1 release has xlat.c 1.72.2.7.2.1 2005/12/08.

BTW, I'd really love to see the delimiter for [*] and %Z be
configurable, but I am not sure how hard to implement it (especially
provide an interface) and if anybody besides me would use it.

-- 
Andriy Gapon
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Freeradius log

2006-03-31 Thread fvt3
Not sure which table to add == to the op field ??

--- Alan DeKok [EMAIL PROTECTED] wrote:

 fvt3 [EMAIL PROTECTED] wrote:
  Anyone know what it is and how to resolve it ? 
 
   Add a value in the op field, like the error
 messages suggest?
 
   Alan DeKok.
 - 
 List info/subscribe/unsubscribe? See
 http://www.freeradius.org/list/users.html
 


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Problem with FreeRadius EAP/TLS and 3com OfficeConnect WirelessAP

2006-03-31 Thread Eugenio Pasquariello

we've solved the problem,
thank you for support

- Original Message - 
From: Alan DeKok [EMAIL PROTECTED]

To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Thursday, March 30, 2006 4:55 PM
Subject: Re: Problem with FreeRadius EAP/TLS and 3com OfficeConnect 
WirelessAP




Eugenio Pasquariello [EMAIL PROTECTED] wrote:

The client start the EAP transaction, start TLS and receive the server
certifcate, we have used WinXp as client and then WIN requests to the 
user

the client certificate. After the choice of the certificate, the client
remain blocked.


 You do not have the extended key usage attributes in the server
certificate.  See the scripts/CA.certs script for examples, and the
xpextensions file.

 Alan DeKok.
-
List info/subscribe/unsubscribe? See 
http://www.freeradius.org/list/users.html 



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: openssl/des.h error

2006-03-31 Thread Alan DeKok
Christoforos Ntantogian [EMAIL PROTECTED] wrote:
 However, i have to install the older version.

  Why?

  Alan DeKok.
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Freeradius log

2006-03-31 Thread Alan DeKok
fvt3 [EMAIL PROTECTED] wrote:
 Not sure which table to add == to the op field ??

  The one that's being queried?  The one that's referenced in the
example schema?  The one that's referenced in the examples saying how
 what to insert in the tables?

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Separate query for authentication and authorization

2006-03-31 Thread Alan DeKok
vignesh [EMAIL PROTECTED] wrote:
 I want to have multiple queries in RADIUS (e.g. one for prepaid and one
 for postpaid users). can I do this in Free Radius, if yes how do I
 specify free radius to execute particular query.

  Not really.

 Also the authentication and authorization seems to call the same query.

  There is no authentication query.

  Alan DeKok.
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: We need help

2006-03-31 Thread Alan DeKok
Sam Sein Muan Tie [EMAIL PROTECTED] wrote:
 Got it to work before then copy the config to different server, it doenst
 work anymore.

  The debug log you posted shows that no one tried to authenticate.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Version 1.1.1 stops responding

2006-03-31 Thread Alan DeKok
Stefan Winter [EMAIL PROTECTED] wrote:
 When I did it in -X mode, it segfaulted. The end of the -X output is:
...

  Could you do the same, but with core dumps enabled (ulimit -c
unlimited) and symbols?

  That would help a lot in tracking down the problem.

  Also, what OS you're running on, etc.

  Alan DeKok.
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Radrelay and detail file permissions

2006-03-31 Thread Ben Plimpton
I have setup radius to log detail files for radrelay to use.  I think
that I followed the documentation exactly except for the name of the
detail file.

detail detail-combined {
detailfile = ${radacctdir}/detail-combined
detailperm = 0600
dirperm = 0755
locking = yes
}

accounting {
detail
detail-combined
}

FreeRadius logs to this file properly if I don't startup radrelay and
the permissions remain as I would expect they should:

-rw---  1 radiusd radiusd 1166 Mar 31 12:02 detail-combined

But when I start radrelay the permissions change:

[EMAIL PROTECTED] radacct]# radrelay -a /var/log/radius/radacct \
-d /etc/raddb -n ns2-new detail-combined

[EMAIL PROTECTED] radacct]# ls -la total 44
drwx--  9 radiusd radiusd 4096 Mar 31 12:08 .
drwx--  3 radiusd radiusd 4096 Mar 31 12:02 ..
drwxr-xr-x  2 radiusd radiusd 4096 Mar 31 11:42 127.0.0.1
drwxr-xr-x  2 radiusd radiusd 4096 Mar 17 16:17 216.17.128.39
drwxr-xr-x  2 radiusd radiusd 4096 Feb  7 00:30 216.237.65.2
drwxr-xr-x  2 radiusd radiusd 4096 Mar 31 00:00 216.237.67.198
drwxr-xr-x  2 radiusd radiusd 4096 Mar 31 09:34 216.237.67.217
drwxr-xr-x  2 radiusd radiusd 4096 Feb 14 09:49 216.237.72.66
drwxr-xr-x  2 radiusd radiusd 4096 Mar 31 10:39 216.237.77.3
-rw---  1 rootroot   0 Mar 31 12:08 detail-combined
[EMAIL PROTECTED] radacct]#

I start getting error like this in my radius.log which I would expect
with the file permissions the way they are and radiusd cannot log to the
detail file properly and as a result, radrelay cannot send the
accounting request to the remote server:

Fri Mar 31 12:11:13 2006 : Error: rlm_detail: Couldn't open
file /var/log/radius/radacct/detail-combined: Permission denied

Am I missing something with the way I am starting up radrelay?  Or are
there permissions that I need to check somewhere else?  

Should radrelay be run as user radiusd?  If so, how would I do that?

Also.  My system is running Fedora Core 4 - FreeRadius Ver 1.0.4

Any help is greatly appreciated. Thanks


-- 
Microsoft is not the answer, it's the question.  NO is the answer.

Ben Plimpton
Network Engineer
[EMAIL PROTECTED]
970-963-SURF(7873) ext 5174
www.sopris.com
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Radrelay and detail file permissions

2006-03-31 Thread Zoltan Ori
On Friday 31 March 2006 14:17, Ben Plimpton wrote:

 But when I start radrelay the permissions change:

 [EMAIL PROTECTED] radacct]# radrelay -a /var/log/radius/radacct \
 -d /etc/raddb -n ns2-new detail-combined

 [EMAIL PROTECTED] radacct]# ls -la total 44
 drwx--  9 radiusd radiusd 4096 Mar 31 12:08 .
 drwx--  3 radiusd radiusd 4096 Mar 31 12:02 ..
 drwxr-xr-x  2 radiusd radiusd 4096 Mar 31 11:42 127.0.0.1
 drwxr-xr-x  2 radiusd radiusd 4096 Mar 17 16:17 216.17.128.39
 drwxr-xr-x  2 radiusd radiusd 4096 Feb  7 00:30 216.237.65.2
 drwxr-xr-x  2 radiusd radiusd 4096 Mar 31 00:00 216.237.67.198
 drwxr-xr-x  2 radiusd radiusd 4096 Mar 31 09:34 216.237.67.217
 drwxr-xr-x  2 radiusd radiusd 4096 Feb 14 09:49 216.237.72.66
 drwxr-xr-x  2 radiusd radiusd 4096 Mar 31 10:39 216.237.77.3
 -rw---  1 rootroot   0 Mar 31 12:08 detail-combined
 [EMAIL PROTECTED] radacct]#


 Am I missing something with the way I am starting up radrelay?  Or are
 there permissions that I need to check somewhere else?  

Don't start radrelay as root. Start it as the same user you use to start 
RADIUS. In this case, radiusd.

Zoltan Ori

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


sql_postauth does not exec on failed logins

2006-03-31 Thread Duane Cox
List, Hello:

I've got the sql postauth working for Valid Logins, but rlm_sql does not
even call sql_postauth if the login fails.

Is this by design, or do I have a configuration error?


PROCESSES SQL_POSTAUTH:
Login OK: [intermapper] (from client intermapper port 0)
  Processing the post-auth section of radiusd.conf
modcall: entering group post-auth for request 14
rlm_sql (sql): Processing sql_postauth
radius_xlat:  'intermapper'
rlm_sql (sql): sql_set_user escaped user -- 'intermapper'
radius_xlat:  'insert into radauth (UserName, Password, RadReply,
NASIPAddress, NASIdentifier, NASPort, CalledStationId, CallingStationId)
values ('intermapper', 'password', 'Access-Accept', '10.15.1.15', '', '',
'', '')'
rlm_sql (sql) in sql_postauth: query is insert into radauth (UserName,
Password, RadReply, NASIPAddress, NASIdentifier, NASPort, CalledStationId,
CallingStationId) values ('intermapper', 'password', 'Access-Accept',
'10.15.1.15', '', '', '', '')
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): Released sql socket id: 4


DOESNT PROCESS SQL_POSTAUTH:
rlm_sql (sql): sql_set_user escaped user -- '00111AE0D100'
radius_xlat:  'select id, username, attribute, value, op from radcheck where
username = '00111AE0D100' order by id'
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql (sql): User 00111AE0D100 not found in radcheck
radius_xlat:  ''
radius_xlat:  'select radgroupreply.id, radgroupreply.groupname,
radgroupreply.attribute, radgroupreply.value, radgroupreply.op from
radgroupreply, usergroup where usergroup.username = '00111AE0D100' and
usergroup.groupname = radgroupreply.groupname order by radgroupreply.id'
rlm_sql (sql): Released sql socket id: 0
  modcall[authorize]: module sql returns ok for request 6
  modcall[authorize]: module files returns notfound for request 6
modcall: leaving group authorize (returns ok) for request 6
auth: No authenticate method (Auth-Type) configuration found for the
request: Rejecting the user
auth: Failed to validate the user.
Login incorrect: [00111AE0D100/12810341630068900201] (from client ubr7223
port 6)
Sending Access-Reject of id 222 to 63.252.228.2 port 21745
Finished request 6
Going to the next request
--- Walking the entire request list ---
Waking up in 5 seconds...

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: sql_postauth does not exec on failed logins

2006-03-31 Thread Alan DeKok
Duane Cox [EMAIL PROTECTED] wrote:
 I've got the sql postauth working for Valid Logins, but rlm_sql does not
 even call sql_postauth if the login fails.

  You must list sql in the reject subsection of postauth.  See the
default configs.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: special characters in passwords + FR + ldap

2006-03-31 Thread Natalia Escalera
Hi,

Thank you for the support, we will try it out in that way. 

Natalia
On 3/30/06, Alan DeKok [EMAIL PROTECTED] wrote:
Natalia Escalera [EMAIL PROTECTED] wrote:
 Command: /usr/local/bin/radtest username test$2006 x.x.x.x 1 test123 Output: Sending Access-Request of id 215 to x.x.x.x port 1812 User-Name = username User-Password = test006#- No dollar sign, no number 2
$2 is a Unix shell variable.This has nothing to do with FreeRADIUS./usr/local/bin/radtest username 'test$2006' x.x.x.x 1 test123will work.Note SINGLE quotes, not DOUBLE quotes.Alan DeKok.
-List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html