Hello Tom - At 12:17 -0400 01/7/5, Tom Daly wrote: >Hello, >We are currently using Radiator and MySQL for a SessionDB. As a wholesale >provider, we have two ways for our wholesalers to access accounts. > >1. Per Port - An ISP is assigned a unique DNIS to which all radius requested >are directed at thier radius server by proxy. We do this by the following >method. > ><CalledStationId /......3400/> > <AuthBy RADIUS> > Host xxx.xxx.xxx.xxx > Secret VeryVerySecret > AuthPort 1645 > AcctPort 1646 > Retries 5 > RetryTimeout 15 > </AuthBy> > >This method seems to be slow, as we have to search through a few hundred >DNISs for the same provider, if they have multiple DNISs. So I am looking >for a way to use one statement that will search each providers list of >DNISs. Also, when a customer dials in, thier username is just username. It >there a way to make the session database show [EMAIL PROTECTED], but >still pass username to the proxy radius server? If you are using the "CalledStationId.pm" file from the goodies section of the distribution, there is almost no overhead, as the number that is specified in the definition is used as a key to directly access that clause. This is by far the fastest way to process large numbers of phone numbers. For your second question, you can use RewriteUsername(s) and custom queries for the SessionDatabase to do what you require. >2. Per User - An ISP is assigned a Unique REALM via a <Realm> or <Handler >Realm=> Clause. This gets very very complicated, so it there a way to >simplify this? I don't understand the problem, sorry. Can you elaborate? >Also, 1 ISP does not use a realm, so is there a way to make >the session database show [EMAIL PROTECTED] and the radius server check >for just username? See above - RewriteUsername(s) and custom queries. regards Hugh -- NB: I am travelling this week, so there may be delays in our correspondence. Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.