What do these "radius.log" entries mean?

2003-09-22 Thread Mike Hall
Hi all,

We are having minor problems with a cluster of Cisco AP1200 access points.
We use MAC Address Authentication to redundant Freeradius 0.9 servers for
security.  I think the error messages below (from the radius.log file) might
give me a clueCould someone please explain what they mean?

Tue Sep  2 06:02:24 2003 : Error: rlm_radutmp: Logout entry for NAS
NorthGate-D2 port 37 has wrong ID

Tue Sep  2 06:43:48 2003 : Error: rlm_radutmp: Login entry for NAS
NorthGate-D2 port 38 wrong order

Thanks!
Mike Hall



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003


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


Access Point Errors

2003-09-08 Thread Mike Hall
Could someone please tell me what these errors mean:

Tue Sep  2 06:02:24 2003 : Error: rlm_radutmp: Logout entry for NAS
NorthGate-D2 port 37 has wrong ID
Tue Sep  2 06:43:48 2003 : Error: rlm_radutmp: Login entry for NAS
NorthGate-D2 port 38 wrong order

I get them constantly from our Cisco AP1200 access points and would like to
know if this is a problem.

Thanks!
Mike Hall



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003


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


Cisco AP 1200 Errors

2003-09-02 Thread Mike Hall
Hi all,

We are having a problem with a cluster of Cisco AP1200's
which are all on the same subnet.  They all have identical
configurations and are set to do Static WEP and MAC
Authentication to a Freeradius 0.9 server.  When I turn MAC
Auth off they all work finebut when I turn it on,
certain APs will not let clients get an address.  I am
thinking that these errors might give me a clue.  Could
someone please explain what they mean?

Tue Sep  2 06:02:24 2003 : Error: rlm_radutmp: Logout entry
for NAS NorthGate-D2 port 37 has wrong ID
Tue Sep  2 06:43:48 2003 : Error: rlm_radutmp: Login entry
for NAS NorthGate-D2 port 38 wrong order

Thanks!
Mike Hall

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


RE: (no subject) - Cisco AP 1200 MAC Auth works!...now what?

2003-08-14 Thread Mike Hall
Alan, it was not documented...obviously.  Further, we use WEP+
encryption to extend the security of our wireless network (+ is Avaya's
stronger hashing).  I am well aware of the problems with WEP.  If
someone wants access badly enough to
1. Find a MAC that's in our database
2. Spoof their MAC address
3. Crack a 128 bit WEP+ key (have you tried? Its not easy)
4. Risk being caught through accounting reports/logs
they can find plenty of open ethernet ports in one of our buildings
without going through all that trouble.  Our more important networks are
protected by vpn gateways.

As for this comment:
>Huh?  Why?  Managing passwords isn't difficult.  So for one AP, you add
>(by hand) the password which just happens to be the MAC address. For 
>another AP, you add a different password. That is by far and away too 
>complicated.

We have more than 12,000 users and 100's of access points.  Do you think
we could add all the MAC's into each AP?  That's the worst management
nightmare I can imagine.  Modifying one SQL query in the sql.conf file
is hardly complicated.  The only problem is I don't know how to make
radius differentiate between AP requests.  I know there people on this
list who can answer that in their sleep.  I would really appreciate some
help from one of you radius gurus (not Alan).

--
Mike Hall



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


RE: Howto FreeRadius --Cisco350 --client win98/2k/xp

2003-08-14 Thread Mike Hall
The clients give their MAC address and it acts as their Username in
radius.  The password is the radius password sent by the AP.  Is a very
convenient method because the authentication is transparent to the end
user.  I set it up over a year ago so my memory is a little hazy ...Try
google: "freeradius mysql"

-Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kent
Hansen
Sent: Tuesday, August 12, 2003 2:20 PM
To: [EMAIL PROTECTED]
Subject: Howto FreeRadius --Cisco350 --client win98/2k/xp


Yes. I now that howto, but i dont want the clients to install
certificate. 
Only want them to join the wireless network with a simple username and 
password. I dont think that howto is the question i want.

Mike: How to you use the mysql? How have you setup this? With username
and 
passwords when the clients joins the network? Or with certificate on all

clients?

Kent






- 
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: Cisco Aironet - MAC auth logs

2003-08-14 Thread Mike Hall
d,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou
pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
usergroup.Username = '00022d11' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id' SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou
pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
usergroup.Username = '00022d11' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = '00022d11' ORDER BY id' SELECT
id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'00022d11' ORDER BY id
radius_xlat:  'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou
preply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
usergroup.Username = '00022d11' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id' SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou
preply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
usergroup.Username = '00022d11' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql: Pairs do not match [00022d11]
rlm_sql: Released sql socket id: 4
  modcall[authorize]: module "sql" returns notfound
  modcall[authorize]: module "files" returns notfound
modcall: group authorize returns ok
auth: No Auth-Type configuration for the request, rejecting the user
auth: Failed to validate the user.
Delaying request 0 for 1 seconds
Finished request 0



 Output of the CISCO accounting log:

Thu Aug  7 14:36:41 2003
Acct-Status-Type = Start
User-Name = "00022d11"
Acct-Session-Id = "  500001"
Acct-Authentic = Local
NAS-Port = 37
Calling-Station-Id = "00022d11"
NAS-Identifier = "udp001617uds"
NAS-IP-Address = XXX.XX.XX.XX
Cisco-AVPair = "0"
Cisco-AVPair = ""
Cisco-AVPair = "open"
Cisco-AVPair = "northgate_wireless"
Acct-Delay-Time = 0
Client-IP-Address = XXX.XX.XX.XX
Acct-Unique-Session-Id = "2c817f6a9cb3342f"
Timestamp = 1060285001







-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peter
Nixon
Sent: Friday, August 08, 2003 11:17 AM
To: [EMAIL PROTECTED]; Mike Hall
Subject: Re: Cisco Aironet - MAC authentication problems


On Fri August 8 2003 19:01, Mike Hall wrote:
> Hi,
>
> I work for a major University and we have been using Freeradius to do 
> MAC authentication with Orinoco (Avaya,Proxim) based access point for 
> about 2 years.  We have had no problems, and loved our decision to 
> implement Freeradius instead of a commercial package.
>
> Now, many departments want to use the Cisco Aironet line. To our 
> dismay, we have discovered that they do not authenticate in the same 
> way as the Orinoco units.  I think it has something to do with the 
> Cisco-AVPair string which is sent to the radius server and/or the 
> Attribute Value fields.  I also think it has related to the Auth-Type 
> string and/or the dictionary.cisco file.  We use a Mysql database to 
> store the user-names (MAC Addresses).  The little info I have found on

> the internet is very unclear on what I should to fix this.  I have all

> the output of mysql/freeradius, but it has been a nightmare trying to
> decipher it.
>
> Has anyone ran across this problem, and if so, could you please tell 
> what I can do to make Freeradius compatible with Cisco Aironet access 
> points?  I can send you any info/logs about our setup that you need.
> I cannot begin to tell you how much I will appreciate any help you can

> give us.

If you send us the debug output of when an Orinoco unit authenticates
and when 
a cisco tries to authenticate we will try to help you. Maybe others have

cisco AP's and can help you, but I don't unfortunately.

Cheers
-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc


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




- 
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: Cisco Aironet - MAC auth logs

2003-08-14 Thread Mike Hall
I am definitely authenticating against mysql!!  I have been working with
this system for over a year and it has worked great...if the user's MAC
isn't in there then they can't authenticate.Matches "local"
User-Password :: Doesn't that tell you im authenticating?  Please
advise..

Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ulrich
Walcher
Sent: Tuesday, August 12, 2003 3:11 AM
To: [EMAIL PROTECTED]
Subject: RE: Cisco Aironet - MAC auth logs


See the differnece?!

>  Output of the ORINOCO from radiusd -X:
> rlm_sql: Released sql socket id: 4
>   modcall[authorize]: module "sql" returns ok
>   modcall[authorize]: module "files" returns notfound
> modcall: group authorize returns ok
> auth: type Local

Auth-Type := Local

> auth: user supplied User-Password matches local User-Password

Matches "local" User-Password

> Sending Access-Accept of id 31 to XXX.XX.XX.XX:6001
> Finished request 1



>  Output of the CISCO from radiusd -X:
> rlm_sql: Pairs do not match [00022d11]

!


> rlm_sql: Released sql socket id: 4
>   modcall[authorize]: module "sql" returns notfound
>   modcall[authorize]: module "files" returns notfound
> modcall: group authorize returns ok
> auth: No Auth-Type configuration for the request, rejecting the user

No Auth-Type

> auth: Failed to validate the user.
> Delaying request 0 for 1 seconds
> Finished request 0

AFAIS you're not authenticating against mysql... in none of the two
cases!





- 
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: Cisco vs. Orinoco - MAC Authentication

2003-08-14 Thread Mike Hall
Your first suggestion, to duplicate users, is not possible using a sql
database according to the documentation.  

The third suggestion, to use the /etc/passwd file, is not feasible
because of the large ammount of users we have, and because this machine
serves other purposes which might be comprimised.  

The second & fourth suggestions:
>Or, you can update the SQL database, and use User-Password as a key,
adding it to the 
>SQL query.  So user "bob" with password "bob", will be different than
user "bob" with 
>password "hello".  It will mean massively duplicate crap in the DB, but
it will work.
.
>create a new SQL table to hold the shared secrets for each AP, and do:
>DEFAULT User-Password == `%{sql:SELECT stuff by
%{Client-IP-Address}:-%{User-Name}}`
>List the AP's that use the shared secret in the SQL database, and don't
list the others.
>If the SQL query returns nothing, then the password will be set to the
User-Name, 
>which will work for the other AP's.

Sound like a great ideas, though I don't quite understand the last one.
My problem here is I cannot find the sql statement which compares
'Value' field to the User-Password string sent from the AP.  It is not
in the sql.conf file.  

Mike



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok
Sent: Wednesday, August 13, 2003 2:55 PM
To: [EMAIL PROTECTED]
Subject: Re: Cisco vs. Orinoco - MAC Authentication 


"Mike Hall" <[EMAIL PROTECTED]> wrote:
> The two access point authenticate differently.  The Orinoco sends the 
> Value as the SharedSecret & the Cisco sends the Value as the 
> MacAddress.

  You've said that before.

> What can I do to make this work?  I could create two entries like 
> this:
...
> But this just confuses the Radius server and auth fails.

  So edit the SQL table definition & queries, so it selects by
User-Password, too.

>  Please offer some suggestions on what we can do.  Thanks again.

  I thought I had 3 suggestions in my last email.  Did you try any of
them?

  Here's another suggestion: create a new SQL table to hold the shared
secrets for each AP, and do:

DEFAULT  User-Password == `%{sql:SELECT stuff by
%{Client-IP-Address}:-%{User-Name}}`

  List the AP's that use the shared secret in the SQL database, and
don't list the others.  If the SQL query returns nothing, then the
password will be set to the User-Name, which will work for the other
AP's.

  That's 4 solutions.
 
  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


Cisco vs. Orinoco - Authenticating regardless of password

2003-08-14 Thread Mike Hall
I need to authenticate a user if there Username (MAC Address) is in the
radcheck table, regardless of the password that is sent.  The Freeradius
FAQ says this:

5.5 How do I permit access to any user regardless of password?
DEFAULT Auth-Type = Accept

I do not understand where I would put this in mysql.  Is this in the
usergroup table? Could I put it into one of the files and tell radius to
look at that instead of mysql?  Someone please help me here...

Thanks,
Mike Hall


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey C.
Ollie
Sent: Wednesday, August 13, 2003 10:01 PM
To: [EMAIL PROTECTED]
Subject: RE: Cisco vs. Orinoco - MAC Authentication


On Wed, 2003-08-13 at 16:46, Mike Hall wrote:
> What I really need is this:
> 
> A way to make the radius server think the User-Password string (sent 
> from any AP) is our 'shared secret'.  I can make it work if there is a

> way to do this.  Here the Cisco AP will send the MAC as the
> 'User-Password' but radius will change it (before processing) to be 
> our 'shared secret'.  Any Suggestion?  Please...

Why bother with checking the password anyway?

Here's what I use on my Cisco 350's:

 Auth-Type == Accept, NAS-Port-Type == Wireless-802.11

Actually checking the password sent from a Cisco AP during MAC address
authentication is kind of pointless since it's such a weak password.  I
know less about how the Orinoco handles MAC address authentication but
it doesn't sound like Orinoco's scheme is much of an improvement.

Jeff



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




- 
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: Cisco Aironet - MAC auth logs

2003-08-14 Thread Mike Hall
How do I define and Auth-Type for the user? Is it the Attribute field in
my radcheck table?  That has 'User-Password' for everyone in the system.
The Value field also has our 'radius password' for all users.  I have
read some about the hints file...do I need to do something like this:

Default Prefix = "Cisco-AVPair", Strip-User-Name = Yes
Hint = "CISCO"
Auth-Type = Local

...Or am I totally on the wrong track here?  Another idea is to create a
two separate 'radcheck' tables, one for Cisco Aps and one for Orinoco
APs.  What do yall think of that (there must be an easier way)?  When it
say "module sql returns notfound" what does that mean?  Sorry for all
the questions, I really appreciate your help. 

--Mike Hall  



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ulrich
Walcher
Sent: Tuesday, August 12, 2003 1:01 PM
To: [EMAIL PROTECTED]
Subject: RE: Cisco Aironet - MAC auth logs


"auth: user supplied User-Password matches local User-Password" says
that the user matches a password in raddb/users file. You are
authenticating -> yes, but against a password-file. Authorization is
done in this case via sql.

With the Cisco box you get an error message saying: "Pairs do not match
[00022d11]". Unfortunately I can't tell you why...
and:
"auth: No Auth-Type configuration for the request, rejecting the user"
You have not defined an Auth-Type for the user. Uli

Am Die, 2003-08-12 um 15.32 schrieb Mike Hall:
> I am definitely authenticating against mysql!!  I have been working 
> with this system for over a year and it has worked great...if the
user's MAC
> isn't in there then they can't authenticate.  Matches "local"
> User-Password :: Doesn't that tell you im authenticating?  Please 
> advise..
> 
> Mike
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ulrich 
> Walcher
> Sent: Tuesday, August 12, 2003 3:11 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Cisco Aironet - MAC auth logs
> 
> 
> See the differnece?!
> 
> >  Output of the ORINOCO from radiusd -X:
> > rlm_sql: Released sql socket id: 4
> >   modcall[authorize]: module "sql" returns ok
> >   modcall[authorize]: module "files" returns notfound
> > modcall: group authorize returns ok
> > auth: type Local
> 
>   Auth-Type := Local
> 
> > auth: user supplied User-Password matches local User-Password
> 
>   Matches "local" User-Password
> 
> > Sending Access-Accept of id 31 to XXX.XX.XX.XX:6001 Finished request

> > 1
> 
> 
> 
> >  Output of the CISCO from radiusd -X:
> > rlm_sql: Pairs do not match [00022d11]
> 
>   !
> 
> 
> > rlm_sql: Released sql socket id: 4
> >   modcall[authorize]: module "sql" returns notfound
> >   modcall[authorize]: module "files" returns notfound
> > modcall: group authorize returns ok
> > auth: No Auth-Type configuration for the request, rejecting the user
> 
>   No Auth-Type
> 
> > auth: Failed to validate the user.
> > Delaying request 0 for 1 seconds
> > Finished request 0
> 
> AFAIS you're not authenticating against mysql... in none of the two 
> cases!
> 
> 
> 
> 
> 
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> 
> 
> 
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
> 


- 
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: Howto FreeRadius --Cisco350 --client win98/2k/xp

2003-08-14 Thread Mike Hall
I seems that this is a very common problem with Cisco APs.  What about
doing the same using MAC Auth instead of EAP-TLS.  Is there any
documentation out there?  I must use mysql instead of the flat
fileanyone know of a how-to like that?

--
Mike Hall
Telecom Analyst

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Artur
Hecker
Sent: Tuesday, August 12, 2003 1:47 PM
To: [EMAIL PROTECTED]
Subject: Re: Howto FreeRadius --Cisco350 --client win98/2k/xp


www.freeradius.org/doc/EAPTLS.pdf


Kent Hansen wrote:

> Hi
> 
> Is there anyone who can tell me howto setup a freeradius with a cisco 
> 350
> client, and clients on the ap authentication to the wireless network
with a 
> username and password on the freeradius server.
> 
> Example:
> 
> Client with xp, wants to join the wireless network, and they need to 
> type in
> username and password, then OK, and at the end, they are joined the
network.
> 
> How do i setup the freeradius server to do this, and the cisco ap 350.
> 
> Kent



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




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


Cisco vs. Orinoco - MAC Authentication

2003-08-14 Thread Mike Hall
Hello again,

The two access point authenticate differently.  The Orinoco sends the
Value as the SharedSecret & the Cisco sends the Value as the MacAddress.
Example:

    ORINOCO AP  
+-+--+---+--+-+
| id  |  UserName| Attribute |Value | op  |
+-+--+---+--+-+
| 1   |  MacAddress  | User-Password | SharedSecret | ==  |
+-+--+---+--+-+

 CISCO AP  
+-+--+---+-+-+
| id  |  UserName| Attribute |Value| op  |
+-+--+---+-+-+
| 1   |  MacAddress  | User-Password | MacAddress  | ==  |
+-+--+---+-+-+

What can I do to make this work?  I could create two entries like this:
+-+--+---+--+-+
| id  |  UserName| Attribute |Value | op  |
+-+--+---+--+-+
| 1   |  MacAddress  | User-Password | MacAddress   | ==  |
+-+--+---+--+-+
| 2   |  MacAddress  | User-Password | SharedSecret | ==  |
+-+--+---+--+-+
But this just confuses the Radius server and auth fails.  Please offer
some suggestions on what we can do.  Thanks again.

--
Mike Hall



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


RE: Cisco Aironet - MAC auth logs

2003-08-14 Thread Mike Hall
Hi all, sorry I forgot to run the other queries.  The AP is a Cisco
Aironet 1200 (1220b) Here are the queries:


> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 
> '00062541e359' ORDER BY id

+-+--+---+--+--+
| id  | UserName | Attribute | Value| op   |
+-+--+---+--+--+
| 215 | 00062541e359 | User-Password | ourpaswd | ==   |
+-+--+---+--+--+
1 row in set (0.00 sec)

> SELECT 
> radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgr
> ou
> pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
> usergroup.Username = '00062541e359' AND usergroup.GroupName =
> radgroupcheck.GroupName ORDER BY radgroupcheck.id

Empty set (0.00 sec)

> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 
> '00062541e359' ORDER BY id

Empty set (0.00 sec)

> SELECT 
> radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgr
> ou
> pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
> usergroup.Username = '00022d11' AND usergroup.GroupName =
> radgroupcheck.GroupName ORDER BY radgroupcheck.id

Empty set (0.00 sec)

> SELECT 
> radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgr
> ou
> preply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
> usergroup.Username = '00062541e359' AND usergroup.GroupName =
> radgroupreply.GroupName ORDER BY radgroupreply.id

Empty set (0.00 sec)

> SELECT Value,Attribute FROM radcheck WHERE UserName = '00062541e359' 
> AND ( Attribute = 'User-Password' OR Attribute = 'Password' OR 
> Attribute =
> 'Crypt-Password') ORDER BY Attribute DESC

+--+---+
| Value| Attribute |
+--+---+
| ourpaswd | User-Password |
+--+---+
1 row in set (0.00 sec)

> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 
> '00022d11' ORDER BY id

+-+--+---+--+--+
| id  | UserName | Attribute | Value| op   |
+-+--+---+--+--+
| 215 | 00022d11 | User-Password | ourpaswd | ==   |
+-+--+---+--+--+
1 row in set (0.00 sec)

> SELECT 
> radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgr
> ou
> pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
> usergroup.Username = '00022d11' AND usergroup.GroupName =
> radgroupcheck.GroupName ORDER BY radgroupcheck.id

Empty set (0.00 sec)

> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 
> '00022d11' ORDER BY id

Empty set (0.00 sec)

> SELECT 
> radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgr
> ou
> preply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
> usergroup.Username = '00022d11' AND usergroup.GroupName =
> radgroupreply.GroupName ORDER BY radgroupreply.id

Empty set (0.00 sec)



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


RE: Cisco vs. Orinoco - MAC Authentication

2003-08-14 Thread Mike Hall

Do you use mysql or a users file?  Where would I put this:
 Auth-Type == Accept, NAS-Port-Type ==
Wireless-802.11 Into mysql?  If I put it into the radcheck table it will
not authenticate (b/c the Attribute is not Username-Password).  Please
help...

-Mike Hall

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey C.
Ollie
Sent: Wednesday, August 13, 2003 10:01 PM
To: [EMAIL PROTECTED]
Subject: RE: Cisco vs. Orinoco - MAC Authentication


On Wed, 2003-08-13 at 16:46, Mike Hall wrote:
> What I really need is this:
> 
> A way to make the radius server think the User-Password string (sent
> from any AP) is our 'shared secret'.  I can make it work if there is a

> way to do this.  Here the Cisco AP will send the MAC as the 
> 'User-Password' but radius will change it (before processing) to be 
> our 'shared secret'.  Any Suggestion?  Please...

Why bother with checking the password anyway?

Here's what I use on my Cisco 350's:

 Auth-Type == Accept, NAS-Port-Type == Wireless-802.11

Actually checking the password sent from a Cisco AP during MAC address
authentication is kind of pointless since it's such a weak password.  I
know less about how the Orinoco handles MAC address authentication but
it doesn't sound like Orinoco's scheme is much of an improvement.

Jeff



- 
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: (no subject) - Cisco AP 1200 MAC Auth works!...now what?

2003-08-14 Thread Mike Hall
Its alive!!  Using your radcheck configuration the Cisco 1200 APs work
with freeradius .  But of course, I have another
problem...the Orinoco APs don't work with this configuration!  Some
debugging brought me to this conclusion on what will work for the
different access points:

    ORINOCO AP  
+-+--+---+--+-+
| id  |  UserName| Attribute |Value | op  |
+-+--+---+--+-+
| 123 |  MacAddress  | User-Password | SharedSecret | ==  |
+-+--+---+--+-+

 CISCO AP  
+-+--+---+-+-+
| id  |  UserName| Attribute |Value| op  |
+-+--+---+-+-+
| 123 |  MacAddress  | User-Password | MacAddress  | ==  |
+-+--+---+-+-+

So what now?  I could create 2 different tables, then use something
(please help me here, huntgroups?) to tell freeradius which type of AP
is making the request,  then use the correct sql statement to select on
mysql.  Fun, Fun.  Another option is to modify the modcall[authorize]
sql statement to say something like if "Username = MacAddress OR
Username = SharedSecret". The problem is that "Username will never equal
SharedSecret"!  Im almost there...Please Help!

--
Mike Hall
Telecom Analyst



 -Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 
Sent:   Tuesday, August 12, 2003 3:36 PM
To: [EMAIL PROTECTED]
Subject:(no subject)


On a Cisco AP 340 or better, MAC-based Auth. uses the
MAC-address of the client as both the user and password.

In your radcheck table, UserName is MAC-address, Attribute is
'Password', op is '==' and Value is MAC-address.

Works great and you do not have to restart radius when you add
MAC-addresses.

Hope this helps.



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


RE: VSA in freeRadius

2003-08-14 Thread Mike Hall
Title: Message



Sound 
like your having the same problem as me.  We have just purchased Cisco 1200 
APs and I can not get it to work.  Are you using mysql or a flat file 
(users)?
 
--
Mike 
Hall
Telecom Analyst

  
  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Israel 
  Cardenas RomeroSent: Tuesday, August 12, 2003 12:14 
  PMTo: [EMAIL PROTECTED]Subject: VSA in 
  freeRadius
  Hi!
   
  I'm using freeRadius with EAP/TLS to secure my 
  wireless network. It works fine, but now I wan't to use two or more different 
  SSIDs in the network.
   
  I've bought a Cisco 1100 AP, with support 
  wireless VLANs associated with SSIDs. It support a Vender-Specific attribute 
  to get from the Radius Server a list of valid SSID for each user, but I don't 
  know how to get FreeRadius send to AP a Vender-Specific 
attribute.
   
   
  
  


   
    
  
Israel Cárdenas 
Romero SGI - Soluciones Globales Internet Delegación 
Regional Sur EMail: [EMAIL PROTECTED] Tlfno: 954088060 

<>

RE: Cisco Aironet - MAC auth logs

2003-08-14 Thread Mike Hall
d,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou
pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
usergroup.Username = '00022d11' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou
pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
usergroup.Username = '00022d11' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = '00022d11' ORDER BY id'
SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'00022d11' ORDER BY id
radius_xlat:  'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou
preply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
usergroup.Username = '00022d11' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou
preply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
usergroup.Username = '00022d11' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql: Pairs do not match [00022d11]
rlm_sql: Released sql socket id: 4
  modcall[authorize]: module "sql" returns notfound
  modcall[authorize]: module "files" returns notfound
modcall: group authorize returns ok
auth: No Auth-Type configuration for the request, rejecting the user
auth: Failed to validate the user.
Delaying request 0 for 1 seconds
Finished request 0



 Output of the CISCO accounting log:

Thu Aug  7 14:36:41 2003
Acct-Status-Type = Start
User-Name = "00022d11"
Acct-Session-Id = "  500001"
Acct-Authentic = Local
NAS-Port = 37
Calling-Station-Id = "00022d11"
NAS-Identifier = "udp001617uds"
NAS-IP-Address = XXX.XX.XX.XX
Cisco-AVPair = "0"
Cisco-AVPair = ""
Cisco-AVPair = "open"
Cisco-AVPair = "northgate_wireless"
Acct-Delay-Time = 0
Client-IP-Address = XXX.XX.XX.XX
Acct-Unique-Session-Id = "2c817f6a9cb3342f"
Timestamp = 1060285001







-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peter
Nixon
Sent: Friday, August 08, 2003 11:17 AM
To: [EMAIL PROTECTED]; Mike Hall
Subject: Re: Cisco Aironet - MAC authentication problems


On Fri August 8 2003 19:01, Mike Hall wrote:
> Hi,
>
> I work for a major University and we have been using Freeradius to do
> MAC authentication with Orinoco (Avaya,Proxim) based access point for 
> about 2 years.  We have had no problems, and loved our decision to 
> implement Freeradius instead of a commercial package.
>
> Now, many departments want to use the Cisco Aironet line. To our
> dismay, we have discovered that they do not authenticate in the same 
> way as the Orinoco units.  I think it has something to do with the 
> Cisco-AVPair string which is sent to the radius server and/or the 
> Attribute Value fields.  I also think it has related to the Auth-Type 
> string and/or the dictionary.cisco file.  We use a Mysql database to 
> store the user-names (MAC Addresses).  The little info I have found on

> the internet is very unclear on what I should to fix this.  I have all

> the output of mysql/freeradius, but it has been a nightmare trying to 
> decipher it.
>
> Has anyone ran across this problem, and if so, could you please tell
> what I can do to make Freeradius compatible with Cisco Aironet access 
> points?  I can send you any info/logs about our setup that you need.  
> I cannot begin to tell you how much I will appreciate any help you can

> give us.

If you send us the debug output of when an Orinoco unit authenticates
and when 
a cisco tries to authenticate we will try to help you. Maybe others have

cisco AP's and can help you, but I don't unfortunately.

Cheers
-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc


- 
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: Cisco vs. Orinoco - MAC Authentication

2003-08-14 Thread Mike Hall
What I really need is this:

A way to make the radius server think the User-Password string (sent
from any AP) is our 'shared secret'.  I can make it work if there is a
way to do this.  Here the Cisco AP will send the MAC as the
'User-Password' but radius will change it (before processing) to be our
'shared secret'.  Any Suggestion?  Please...  

Thanks, Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok
Sent: Wednesday, August 13, 2003 2:55 PM
To: [EMAIL PROTECTED]
Subject: Re: Cisco vs. Orinoco - MAC Authentication 


"Mike Hall" <[EMAIL PROTECTED]> wrote:
> The two access point authenticate differently.  The Orinoco sends the 
> Value as the SharedSecret & the Cisco sends the Value as the 
> MacAddress.

  You've said that before.

> What can I do to make this work?  I could create two entries like 
> this:
...
> But this just confuses the Radius server and auth fails.

  So edit the SQL table definition & queries, so it selects by
User-Password, too.

>  Please offer some suggestions on what we can do.  Thanks again.

  I thought I had 3 suggestions in my last email.  Did you try any of
them?

  Here's another suggestion: create a new SQL table to hold the shared
secrets for each AP, and do:

DEFAULT  User-Password == `%{sql:SELECT stuff by
%{Client-IP-Address}:-%{User-Name}}`

  List the AP's that use the shared secret in the SQL database, and
don't list the others.  If the SQL query returns nothing, then the
password will be set to the User-Name, which will work for the other
AP's.

  That's 4 solutions.
 
  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: Cisco Aironet - MAC auth logs

2003-08-14 Thread Mike Hall
Hi, Sorry, it comes back with the same thing:

> mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
> Username = '00022d11' ORDER BY id;
> +-+--+---+--+--+
> | id  | UserName | Attribute | Value| op   |
> +-+--+---+--+--+
> | 215 | 00022d11 | User-Password | ourpaswd | ==   |
> +-+--+---+--+--+
> 1 row in set (0.00 sec)

Thanks!!  -Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 9:05 AM
To: [EMAIL PROTECTED]
Subject: Re: Cisco Aironet - MAC auth logs


Hi,
> Here it isThanks for the help!  Please let me know what you find, 
> time is running out!
> 
> mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
> Username = '00062541e359' ORDER BY id;
> +-+--+---+--+--+
> | id  | UserName | Attribute | Value| op   |
> +-+--+---+--+--+
> | 205 | 00062541e359 | User-Password | ourpaswd | ==   |
> +-+--+---+--+--+
> 1 row in set (0.00 sec)

you havent done this for the other one...which is decidedly different!

>SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 
>'00022d11' ORDER BY id

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



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


Cisco Aironet - MAC authentication problems

2003-08-14 Thread Mike Hall
Hi,

I work for a major University and we have been using Freeradius to do
MAC authentication with Orinoco (Avaya,Proxim) based access point for
about 2 years.  We have had no problems, and loved our decision to
implement Freeradius instead of a commercial package.

Now, many departments want to use the Cisco Aironet line. To our dismay,
we have discovered that they do not authenticate in the same way as the
Orinoco units.  I think it has something to do with the Cisco-AVPair
string which is sent to the radius server and/or the Attribute Value
fields.  I also think it has related to the Auth-Type string and/or the
dictionary.cisco file.  We use a Mysql database to store the user-names
(MAC Addresses).  The little info I have found on the internet is very
unclear on what I should to fix this.  I have all the output of
mysql/freeradius, but it has been a nightmare trying to decipher it.

Has anyone ran across this problem, and if so, could you please tell
what I can do to make Freeradius compatible with Cisco Aironet access
points?  I can send you any info/logs about our setup that you need.  I
cannot begin to tell you how much I will appreciate any help you can
give us.

Thanks,
Mike Hall
Telecom Analyst



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


RE: Cisco Aironet - MAC auth logs

2003-08-11 Thread Mike Hall
Here it isThanks for the help!  Please let me know what you find,
time is running out!

mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = '00062541e359' ORDER BY id;
+-+--+---+--+--+
| id  | UserName | Attribute | Value| op   |
+-+--+---+--+--+
| 205 | 00062541e359 | User-Password | ourpaswd | ==   |
+-+--+---+--+--+
1 row in set (0.00 sec)

Ourpaswd is actully the shared for the radius server.  Thank You

-Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey C.
Ollie
Sent: Saturday, August 09, 2003 11:33 PM
To: [EMAIL PROTECTED]
Subject: RE: Cisco Aironet - MAC auth logs


Mike,

Could you run the following queries manually against your MySQL database
and post the results?

> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 
> '00062541e359' ORDER BY id

> SELECT 
> radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgr
> ou
> pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
> usergroup.Username = 'user' AND usergroup.GroupName =
> radgroupcheck.GroupName ORDER BY radgroupcheck.id

> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 
> '00062541e359' ORDER BY id

> SELECT 
> radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgr
> ou
> preply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
> usergroup.Username = '00062541e359' AND usergroup.GroupName =
> radgroupreply.GroupName ORDER BY radgroupreply.id

> SELECT Value,Attribute FROM radcheck WHERE UserName = '00062541e359' 
> AND ( Attribute = 'User-Password' OR Attribute = 'Password' OR 
> Attribute =
> 'Crypt-Password') ORDER BY Attribute DESC

> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 
> '00022d11' ORDER BY id

> SELECT 
> radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgr
> ou
> pcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
> usergroup.Username = '00022d11' AND usergroup.GroupName =
> radgroupcheck.GroupName ORDER BY radgroupcheck.id

> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 
> '00022d11' ORDER BY id

> SELECT 
> radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgr
> ou
> preply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
> usergroup.Username = '00022d11' AND usergroup.GroupName =
> radgroupreply.GroupName ORDER BY radgroupreply.id



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



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