Re: Which is Better LDAP or MySQL?

2003-08-16 Thread Patrick McShane



 
Actually, the answer is a little more 
straightforward when Radius is involved.   No package including Radius 
should be reading from a flat file (cached or not).  In the case of Radius, 
the users file can quickly become a problem after a few thousand 
users.    With SQL, proper indexing can allow lookups to be 
fairly fast but even then after a few hundred thousand users, SQL starts to 
ache.   LDAP used as a general purpose user/information store was 
designed to scale to literally millions of users so it does well as a back-end 
authentication source due to its scalability and speed (far faster than MySQL, 
Postgres, or Oracle for that matter).   SQL (MySQL for example) on the 
other hand is quite nice for storing the Radius accounting data.   

 
Read from LDAP and write to SQL.  
H...   A nice blend of technologies that excel in their 
respective areas.   
 
Our servers have run in this configuration almost 
flawlessly (given a few DOS attacks) and auth users in a few seconds after 
PPP negotiations.
 
 
 


Re: LDAP authent/authorize and CHAP

2003-06-16 Thread Patrick McShane
To all who replied to this message, I found the LDAP/CHAP compatibility
problem.  I had everything correct in the author/authen sections.  In
fact, the answer was in the previously mentioned FAQ by Kostas.  We also
use the "users" file to set defaults after the LDAP authorization and it
was erroneously setting "Authtype := LDAP" which was mentioned as
something that should NOT be done in the
"http://www.freeradius.org/faq/#5.11"; FAQ.  After commenting that out in
the "users" file, all is well.

Thanks to all for the feedback as our CHAP auths are now working in
perfect harmony with LDAP!!

Pat McShane



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


LDAP authent/authorize and CHAP

2003-06-15 Thread Patrick Mcshane
Hello,
 
Can ANYONE suggest ANY WAY that might allow CHAP requests 
to be handled even though we use LDAP to handle authentication 
and authorization?  Our passwords (userpassword attribute)
are stored in cleartext in the latest OpenLDAP so at least
we are prepared for CHAP.  Maybe some sort of hack in the
users file?

We occasionaly see the following error:

Sun Jun 15 13:07:20 2003 : Auth: rlm_ldap: Attribute
"User-Password" is required for authentication. 
Cannot use "CHAP-Password".


Our auth sections look like:

authorize {
preprocess
chap
mschap
daily
attr_filter
suffix
ldap {
notfound = return
}
files
}
authenticate {
authtype PAP {
pap
}
authtype CHAP {
chap
}
authtype MS-CHAP {
mschap
}
authtype LDAP {
ldap
}
}

Thanks,
Pat McShane




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


LDAP/CHAP incompatible?

2003-04-03 Thread Patrick McShane

Please take a look at the FreeRadius v0.9-pre log entry below.  We use
rlm_ldap to handle authentication/authorization and we continue to get
these occasional errors.  I suppose it is someone trying to use CHAP.
The CHAP and LDAP modules are both listed in our radiusd.conf.  Our
passwords are ALL stored in clear text (no headers) in an LDAP attribute
called "unixpassword" which is mapped to User-Password.  Any ideas
anyone?

radius.log output:
Thu Apr  3 21:04:26 2003 : Error: rlm_radutmp: Logout entry for NAS
galaxy port 1093 has wrong ID
Thu Apr  3 20:07:17 2003 : Auth: rlm_ldap: Attribute "User-Password" is
required for authentication. Cannot use "CHAP-Password".

Thanks,
Pat McShane - ICDC.COM



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


Handling crypt OR clear text encryption schemes for the "pap" module

2003-03-28 Thread Patrick McShane

Does anybody know of a way to get FreeRadius to handle either crypt OR
clear text encryption schemes for the "pap" module?

For example in radiusd.conf:

pap {
encryption_scheme = clear
encryption_scheme = crypt
}

We have some passwords stored in the LDAP password attribute as clear
text (to handle CHAP requests!!!) or they have a value like
"{crypt}GHSN<*&SJJD" (previous migration from old UNIX passwords).
Navis Radius currently looks at the preceding text tokens "{crypt}",
"{plain}", or "{SHA}".  For example the LDAP attribute "unixpassword"
might contain:

unixpassword: {SHA}HDSUYD&#*&$*#$   (WEUDJI (Secure Hash Algorithym)
unixpassword: {crypt}HDSUYD&#*&$*   (UNIX crypt)
unixpassword: mypassword(plain text)

Thanks,
Pat McShane - ICDC.COM




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


An accurate FreeRadius build recipe for Solaris 7,8,9 - MySQL for acct, LDAP for auth

2003-03-13 Thread Patrick McShane

Hello,

I was wondering if anyone had a specific recipe for creating a solid
FreeRadius build on Solaris 7, 8, and 9.  We have some big iron 64bit
multi-CPU UltraSparc systems that we would like to try FreeRadius on.
Here's the question:

Given that we would be starting with FreeRadius v0.81, Solaris 7, and
MySQL 3.23.55, and Netscape Directory server v3.1 (or OpenLDAP), what
would be the exact libraries, utilities, tools, headers, and their
respective versions that would be necessary to get a good Solaris build?

A complete recipe if you will.

Consider this a contribution to the Sun platform/architecture that help
to crack the old computer company monopolies and made UNIX a household
name paving the way for Linux.

By the way, the Redhat 8.0 system we're currently testing FreeRAdius
v0.81 on has worked beautifully with our existing LDAP, MySQL, and proxy
realms and all of our NAS equipment (PortMasters, Ascend MAX TNT)!!!  If
we can get this running on Solaris, we MAY eliminate the use of Lucent
Navis Radius (no love lost with Lucent)!!!

Thanks,
Pat McShane - ICDC-WIRELESS.COM



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


Using LDAP and Realms with v0.81

2003-03-09 Thread Patrick McShane

Hello,

We're testing v0.81 against our existing LDAP DB and the searches worked
fine.   Now have LDAP authentication working too.  We also need to pull
different Radius attributes from LDAP depending on Realm name
([EMAIL PROTECTED]).  Are there any examples of how this might be
accomplished in a FreeRadius configuration?  Please advise.

Thanks,
Pat McShane - ICDC.COM

BEGIN:VCARD
VERSION:2.1
N:McShane;Patrick;E;Mr.
FN:Patrick E McShane
NICKNAME:Pat
ORG:eJiva Inc.;Technology
TITLE:Managing Principal Consultant
NOTE;ENCODING=QUOTED-PRINTABLE:=0D=0A=0D=0A
TEL;WORK;VOICE:(925) 227-6504
TEL;HOME;VOICE:925-416-0854
TEL;CELL;VOICE:925-437-0190
TEL;PAGER;VOICE:(800) 652-5887
TEL;WORK;FAX:(603) 947-9172
TEL;HOME;FAX:603-947-9172
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;eJiva Technology Center;5934 Gibraltar Drive=0D=0ASuite 200;Pleasanton;CA;9=
4588;United States of America
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:eJiva Technology Center=0D=0A5934 Gibraltar Drive=0D=0ASuite 200=0D=0APleasa=
nton, CA 94588=0D=0AUnited States of America
ADR;HOME;ENCODING=QUOTED-PRINTABLE:;;3610 Andrews Drive=0D=0A;Pleasanton;CA;94588;USA
LABEL;HOME;ENCODING=QUOTED-PRINTABLE:3610 Andrews Drive=0D=0A=0D=0APleasanton, CA 94588=0D=0AUSA
X-WAB-GENDER:2
URL;HOME:http://www.icdc.com/~pem
URL;WORK:http://www.ejiva.com
ROLE:Computer Consultant
BDAY:19590503
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20020311T232519Z
END:VCARD


Using LDAP and MySQL with v0.81

2003-03-09 Thread Patrick McShane

Hello,

I was testing v0.81 against our existing LDAP DB and the searches worked
fine.   Now have LDAP authentication working too.  Finally, need to
start storing accounting records in MySQL.  Are there any examples of
how this should look in the radiusd.conf accounting{} section?  Please
advise.

Thanks,
Pat McShane - ICDC.COM

BEGIN:VCARD
VERSION:2.1
N:McShane;Patrick;E;Mr.
FN:Patrick E McShane
NICKNAME:Pat
ORG:eJiva Inc.;Technology
TITLE:Managing Principal Consultant
NOTE;ENCODING=QUOTED-PRINTABLE:=0D=0A=0D=0A
TEL;WORK;VOICE:(925) 227-6504
TEL;HOME;VOICE:925-416-0854
TEL;CELL;VOICE:925-437-0190
TEL;PAGER;VOICE:(800) 652-5887
TEL;WORK;FAX:(603) 947-9172
TEL;HOME;FAX:603-947-9172
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;eJiva Technology Center;5934 Gibraltar Drive=0D=0ASuite 200;Pleasanton;CA;9=
4588;United States of America
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:eJiva Technology Center=0D=0A5934 Gibraltar Drive=0D=0ASuite 200=0D=0APleasa=
nton, CA 94588=0D=0AUnited States of America
ADR;HOME;ENCODING=QUOTED-PRINTABLE:;;3610 Andrews Drive=0D=0A;Pleasanton;CA;94588;USA
LABEL;HOME;ENCODING=QUOTED-PRINTABLE:3610 Andrews Drive=0D=0A=0D=0APleasanton, CA 94588=0D=0AUSA
X-WAB-GENDER:2
URL;HOME:http://www.icdc.com/~pem
URL;WORK:http://www.ejiva.com
ROLE:Computer Consultant
BDAY:19590503
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20020311T232519Z
END:VCARD


Using LDAP with v0.81

2003-03-09 Thread Patrick McShane

Hello,

I was testing v0.81 against our existing LDAP DB and the searches worked
fine.   The LDAP module seemed to authenticate the LDAP user but then
somewhere along the line, "Auth-Type System" failed to "validate" the
user.  We only want to validate/authenticate dialin users against LDAP
so does anyone know where our configuration problem might exist?  We
went through the "rlm_ldap" doc and implemented all of the LDAP
configuration options it suggested.  Please advise.

Thanks,
Pat McShane - ICDC.COM

OUTPUT FROM RADTEST

[EMAIL PROTECTED] root]# radtest [EMAIL PROTECTED] ziggy localhost 0 testing123
Sending Access-Request of id 237 to 127.0.0.1:1812
User-Name = "[EMAIL PROTECTED]"
User-Password = "[EMAIL PROTECTED]:\332c_\341z\036\n\004rhS"
NAS-IP-Address = ziggy.icdc.com
NAS-Port = 0
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=237,
length=20
[EMAIL PROTECTED] root]# 


OUTPUT FROM RADIUSD
===
rad_recv: Access-Request packet from host 127.0.0.1:32781, id=237,
length=64
User-Name = "[EMAIL PROTECTED]"
User-Password = "ziggy"
NAS-IP-Address = 255.255.255.255
NAS-Port = 0
modcall: entering group authorize
  modcall[authorize]: module "preprocess" returns ok
rlm_chap: Could not find proper Chap-Password attribute in request
  modcall[authorize]: module "chap" returns noop
rlm_realm: Looking up realm icdc.com for User-Name = "[EMAIL PROTECTED]"
rlm_realm: Found realm icdc.com
rlm_realm: Adding Stripped-User-Name = "pem"
  rlm_realm: Proxying request from user pem to realm icdc.com
rlm_realm: Adding Realm = "icdc.com"
rlm_realm:  Authentication realm is LOCAL.
rlm_realm:  auth_port is not set.  proxy cancelled
  modcall[authorize]: module "suffix" returns noop
users: Matched DEFAULT at 152
  modcall[authorize]: module "files" returns ok
rlm_ldap: - authorize
rlm_ldap: performing user authorization for pem
radius_xlat:  '(uid=pem)'
radius_xlat:  'o=icdc.com'
ldap_get_conn: Got Id: 0
rlm_ldap: attempting LDAP reconnection
rlm_ldap: (re)connect to ns6.icdc.com:389, authentication 0
rlm_ldap: bind as / to ns6.icdc.com:389
rlm_ldap: waiting for bind result ...
rlm_ldap: performing search in o=icdc.com, with filter (uid=pem)
rlm_ldap: checking if remote access for pem is allowed by dialuptemplate
rlm_ldap: Added password ziggy in check items
rlm_ldap: looking for check items in directory...
rlm_ldap: Adding unixpassword as Password, value ziggy & op=21
rlm_ldap: looking for reply items in directory...
rlm_ldap: user pem authorized to use remote access
ldap_release_conn: Release Id: 0
  modcall[authorize]: module "ldap" returns ok
modcall: group authorize returns ok
  rad_check_password:  Found Auth-Type System
auth: type "System"
auth: Failed to validate the user.
Delaying request 0 for 1 seconds
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 1 seconds...
--- Walking the entire request list ---
Waking up in 1 seconds...
--- Walking the entire request list ---
Sending Access-Reject of id 237 to 127.0.0.1:32781
Waking up in 4 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 237 with timestamp 3e6ba8c3
Nothing to do.  Sleeping until we see a request.


BEGIN:VCARD
VERSION:2.1
N:McShane;Patrick;E;Mr.
FN:Patrick E McShane
NICKNAME:Pat
ORG:eJiva Inc.;Technology
TITLE:Managing Principal Consultant
NOTE;ENCODING=QUOTED-PRINTABLE:=0D=0A=0D=0A
TEL;WORK;VOICE:(925) 227-6504
TEL;HOME;VOICE:925-416-0854
TEL;CELL;VOICE:925-437-0190
TEL;PAGER;VOICE:(800) 652-5887
TEL;WORK;FAX:(603) 947-9172
TEL;HOME;FAX:603-947-9172
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;eJiva Technology Center;5934 Gibraltar Drive=0D=0ASuite 200;Pleasanton;CA;9=
4588;United States of America
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:eJiva Technology Center=0D=0A5934 Gibraltar Drive=0D=0ASuite 200=0D=0APleasa=
nton, CA 94588=0D=0AUnited States of America
ADR;HOME;ENCODING=QUOTED-PRINTABLE:;;3610 Andrews Drive=0D=0A;Pleasanton;CA;94588;USA
LABEL;HOME;ENCODING=QUOTED-PRINTABLE:3610 Andrews Drive=0D=0A=0D=0APleasanton, CA 94588=0D=0AUSA
X-WAB-GENDER:2
URL;HOME:http://www.icdc.com/~pem
URL;WORK:http://www.ejiva.com
ROLE:Computer Consultant
BDAY:19590503
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20020311T232519Z
END:VCARD