insert ips to ippool
i want to ask that i have thousands of ips can you please tell me how to add these ips in ippool table .. it will take big effort and time to add one by one is there another way to add those ips like 175.1.2.0/24 .. regards zubair ayub thanks
On Oct 3, 2016, at 10:18 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:
i want to ask that i have thousands of ips can you please tell me how to add these ips in ippool table .. it will take big effort and time to add one by one is there another way to add those ips like 175.1.2.0/24 ..
You can write a script to insert them. Alan DeKok.
ok means i have to insert all ips one by one there not any way to insert ranges like [175.1.2.0/24] i have to insert like 175.1.2.0, 175.1.2.2, 175.1.2.2 and so on? ________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of Alan DeKok <aland@deployingradius.com> Sent: Monday, October 3, 2016 2:22:34 PM To: FreeRadius users mailing list Subject: Re: insert ips to ippool On Oct 3, 2016, at 10:18 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:
i want to ask that i have thousands of ips can you please tell me how to add these ips in ippool table .. it will take big effort and time to add one by one is there another way to add those ips like 175.1.2.0/24 ..
You can write a script to insert them. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Oct 3, 2016, at 10:28 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:
ok means i have to insert all ips one by one there not any way to insert ranges like [175.1.2.0/24] i have to insert like 175.1.2.0, 175.1.2.2, 175.1.2.2 and so on?
Each row in SQL is one IP. So you need to insert IPs. Not ranges. Alan DeKok.
ok thanks alot :) ________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of Alan DeKok <aland@deployingradius.com> Sent: Monday, October 3, 2016 2:36:40 PM To: FreeRadius users mailing list Subject: Re: insert ips to ippool On Oct 3, 2016, at 10:28 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:
ok means i have to insert all ips one by one there not any way to insert ranges like [175.1.2.0/24] i have to insert like 175.1.2.0, 175.1.2.2, 175.1.2.2 and so on?
Each row in SQL is one IP. So you need to insert IPs. Not ranges. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Create a simple .sql file with all the insert commands for each IP if you want to do it the basic way. You can use eg for, do, done, echo and seq in the right combination to do this trivially for a whole /16 alan
participants (3)
-
Alan Buxey -
Alan DeKok -
Zubair Ayub