SQLIPPOOL/IPPOOL prefix/range format
rsg
ranil.santhish at gmail.com
Tue Apr 1 10:40:03 CEST 2008
Hi,
Can you provide me with some more info to proceed with this?
I'm not quite sure of how to do it with "allocate-find".
How could I define IP Prefixes and have my DB tables filled only with
network prefixes?
Many thanks for your help.
rg
On Mon, Mar 31, 2008 at 12:42 PM, rsg <ranil.santhish at gmail.com> wrote:
> Thanks a lot for the reply and valuable suggestions Phil.
>
> Sorry for the mistyped IP prefix: 10.0.0.0/16 would make sense I
> guess. Could you think of the trouble if we are to have tables with
> different subnets allocated to different networks.
>
> Regards,
> rg
>
>
>
>
> On Mon, Mar 31, 2008 at 12:31 PM, Phil Mayers <p.mayers at imperial.ac.uk> wrote:
> > rsg wrote:
> > > Hi,
> > >
> > > SQLIPPOOL requires, maintenance of an IP address table carrying individual IPs
> > >
> > > Is there a way to handle IP prefixes (prefix/range format) so that in
> > > large networks having many different networks could main and utilze
> > > this effectively.
> >
> > Sure; write an "allocate-find" SQL query that does just that. You'd
> > probably need a stored procedure.
> >
> > There's no native support for it in the module.
> >
> >
> > >
> > > For example it would be cumbersome if it happens to populate a table
> > > with each IP of 10.10.0.0/16.
> >
> > Shrug. It's only 64k rows. I doubt it would be prohibitively expensive.
> >
> >
> > >
> > > The other query is how would it affect the performance if it happens
> > > to scan through the entire table during new ip assignment of a
> >
> > The default SQL schemas for the radippool table are indexed. It won't do
> > a sequential scan, it'll fetch just one row.
> >
> >
> > > client(e.g. mobile device). On the contrary, Perl has Net::IP for
> > > handling ip prefixes which may be better in performance when it comes
> > > to large deployments.
> > >
> > > What is your opinion please ? Is there a way/module to handle this?
> > >
> > > Thanks a lot for your thoughts/assistance.
> > >
> > > rg
> > > -
> > > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> >
> > -
> > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> >
>
More information about the Freeradius-Users
mailing list