ClientListSQL slow solved (was: Re: (RADIATOR) error "No Handler for TTLS inner authentication" using ClientListSQL is this a general problem)

[roel hoek]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



R.H.Hoek wrote on 2006-03-16 10:20:
> 
>>>Hi, I'm concerned about the comment about radiator being slow to
>>>start up when you've got 600+ Access points and using ClientListSql.
>>>I'm planning on rolling out wired dot1x auth over our campus and was
>>>going to use ClientListSQL as a simple way of setting up all our HP
>>>switches as and when we implement dot1X on them. Anyone else using
>>>ClientListSqL with a large number of clients? Alex
> 
> 
> Note: We are using Oracle with a database on a other host. So it is a
> networkbased SQL link.
> I have on experience with ClientListSQL where de database is hosted on
> the same machine as Radiator.

Th problem is solved! With a ClientListSQL and about 625 clients
radiator starts up within 2 seconds!

The problem was caused by a misconfigured LogSQL clause.
So it is not a problem with Radiator nor Oracle.

> 
> BTW: The suggested solution by Hugh Irvine works. (see other message)
> 
> 
>>>
>>>-----Original Message----- From: owner-radiator at xxxxxxxxxxx
>>>[mailto:owner-radiator at xxxxxxxxxxx] On Behalf Of R.H.Hoek Sent: 15
>>>March 2006 16:29 To: radiator at xxxxxxxxxxx Subject: (RADIATOR) error
>>>"No Handler for TTLS inner authentication"
>>>
>>>-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
>>>
>>>Hello,
>>>
>>>We are (also) using Radiator for authenticatien wireless users with 
>>>EAP-TTLS. Because we have al lot of AccessPoints (600+), and
>>>including the clients via ClientListSQL, Radiator takes too lang to
>>>start (5min), I tried the next config. There is a Defaultclient with
>>>a special identifier. In the appropriate Handler this identifier is
>>>checked with the NAS-IP-Address. (in this case the fake range
>>>10.10.108.0 -> 10.10.111.0) This range covers the AccessPoint
>>>IPrange.
>>>
> 
> 
> [...]

- --
Groeten,

Roel H.Hoek,
Dienst Informatietechnologie, Bibliotheek en Educatie (ITBE)
Universiteit Twente,  Postbus 217,  7500 AE  Enschede
kmr SP 422, telefoon: 053 - 489 4598,  fax: 053 - 489 2383
e-mail: R.H.Hoek at UTwente.NL http://www.utwente.nl/itbe
Jabber/Googletalk: rhhoek at gmail.com

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFEJ7FoJwlRSGnYBcYRAj24AKCAKX3Wl5QW9X4ZyqP2BUUviW9I6gCg1de9
KHJYo2z8I1NDaOObqAGz/L4=
=r2d8
-----END PGP SIGNATURE-----

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.