(RADIATOR) Called-Station-Id via MySQL table

[Hugh Irvine]

Hello Todd -

I agree - use the database in preference.

regards

Hugh


On 13 Jan 2004, at 15:19, Your Own ISP .com wrote:

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

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.