(RADIATOR) Called-Station-Id via MySQL table

Your Own ISP .com mylist at lightwavetech.com
Mon Jan 12 22:19:27 CST 2004


Sorry Hugh, meant to respond to the list instead of you directly.

Thanks for your info.. Now I am not sure which way to go I guess..

I do need the server to perform well so I am leaning towards the text file
but.. I have all the numbers already in list that I maintain in MySQL tables
so it seems awful convenient to use the MySQL method.

I think I will go MySQL unless I have performance problems.

Thanks again for your help and look forward to completing my testing and
purchasing Radiator soon.

Thanks,
Todd Routhier
Lightwave Technologies, LLC.

--
Start Your Own Internet Service!
http://www.YourOwnISP.com

ISP Information Exchange
http://www.ISPboard.com

----- Original Message ----- 
From: "Hugh Irvine" <hugh at open.com.au>
To: "Your Own ISP .com" <mylist at lightwavetech.com>
Cc: <radiator at open.com.au>
Sent: Monday, January 12, 2004 10:03 PM
Subject: Re: (RADIATOR) Called-Station-Id via MySQL table


>
> Hello Todd -
>
> Answers to your questions.
>
> 1. Yes you can use MySQL instead of a file. Note that the file
> referenced by an AuthBy FILE is read into memory and cached, so all
> lookups are done in memory. The modification time of the file is
> checked before every lookup and the file is re-read if necessary.
>
> 2. See above for a file. For MySQL it shouldn't be a problem as long as
> you have good indexes and a fast database server.
>
> 3. Accessing a database will be slower than accessing a cached flat
> file. This is not usually a problem though and it is usually *much*
> easier to maintain an SQL database especially if you are doing other
> things with it.
>
> BTW - you might also check your NAS vendor's support for
> "pre-authentication" which sends a radius request with the
> Calling-Station-Id and the Called-Station-Id *before* it answers the
> phone. You can then cause a call to get a busy tone if you don't want
> to accept it.
>
> regards
>
> Hugh
>
>
>
> On 13 Jan 2004, at 14:41, Your Own ISP .com wrote:
>
> > Have set this up using MySQL and it all works except for a few tweaks..
> > Still could use answers to questions 2 and 3 below..
> >
> > Thanks for your help Hugh, I do search and look through the list pretty
> > thoroughly before asking my questions as well as reading the docs..
> >
> > Thanks,
> > Todd Routhier
> > Lightwave Technologies, LLC.
> >
> > --
> > Start Your Own Internet Service!
> > http://www.YourOwnISP.com
> >
> > ISP Information Exchange
> > http://www.ISPboard.com
> >
> >
> >
> > ----- Original Message -----
> > From: "Your Own ISP .com" <mylist at lightwavetech.com>
> > To: <radiator at open.com.au>
> > Sent: Monday, January 12, 2004 1:36 AM
> > Subject: (RADIATOR) Called-Station-Id via MySQL table
> >
> >
> >> OK, I have setup and tested this
> >> http://www.open.com.au/archives/radiator/2003-02/msg00123.html with
> >> good
> >> results.
> >>
> >> The way I want to use this is to have a list of numbers in the file
> >> which
> >> our dialup users are allowed to dial into. If the number is not on the
> > list
> >> then they will be rejected. We need this to control which wholesale
> > networks
> >> our users are allowed to dial in from.
> >>
> >> Problem is our list of numbers are huge line anywhere from 4000
> >> numbers to
> >> as much as 20,000  or so.
> >>
> >> My questions are:
> >>
> >> 1- Can I do this same setup while having the number list in a MySQL
> >> table
> >> instead of the text file?
> >>
> >> 2- Will having a list this big allow Radiator to run and respond to
> > request
> >> in a timely manner or make it unusable?
> >>
> >> 3- Will having the list in MySQL make Radiator run faster or slower in
> > this
> >> scenario?
> >>
> >> Thanks,
> >> Todd Routhier
> >> Lightwave Technologies, LLC.
> >>
> >> --
> >> Start Your Own Internet Service!
> >> http://www.YourOwnISP.com
> >>
> >> ISP Information Exchange
> >> http://www.ISPboard.com
> >>
> >> ===
> >> 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.
> >>
> >
> > ===
> > 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.
> >
> >
>
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> -- 
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
> -
> CATool: Private Certificate Authority for Unix and Unix-like systems.
>
>

===
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.


More information about the radiator mailing list