load ipfw table addresses from file

2010-04-09 Thread Alex Keda

hi!
is there any plans to implement such opportunities?
for large files (we have 60k lines) it's very slow work

srv1# sh -E
# wc -l /root/scripts/db/table.25.txt
   61073 /root/scripts/db/table.25.txt
# date  for i in `cat /root/scripts/db/table.25.txt`; do ipfw table 25 
add $i; done  date

пятница,  9 апреля 2010 г. 10:42:01 (MSD)
пятница,  9 апреля 2010 г. 10:52:43 (MSD)
#
it took more than 10 minutes on busy server =(
___
freebsd-current@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to freebsd-current-unsubscr...@freebsd.org


Re: load ipfw table addresses from file

2010-04-09 Thread Hizel Ildar
В Fri, 09 Apr 2010 10:57:31 +0400
Alex Keda ad...@lissyara.su пишет:

 hi!
 is there any plans to implement such opportunities?
 for large files (we have 60k lines) it's very slow work
 
 srv1# sh -E
 # wc -l /root/scripts/db/table.25.txt
 61073 /root/scripts/db/table.25.txt
 # date  for i in `cat /root/scripts/db/table.25.txt`; do ipfw table
 25 add $i; done  date
 пятница,  9 апреля 2010 г. 10:42:01 (MSD)
 пятница,  9 апреля 2010 г. 10:52:43 (MSD)
 #
 it took more than 10 minutes on busy server =(
 ___
 freebsd-current@freebsd.org mailing list
 http://lists.freebsd.org/mailman/listinfo/freebsd-current
 To unsubscribe, send any mail to
 freebsd-current-unsubscr...@freebsd.org
 

my variant:

s...@serv4 ~ wc -l ip2.txt 
   65536 ip2.txt
s...@serv4 ~ sudo ipfw table 25 flush
s...@serv4 ~ sudo time ipfw /home/se/ip2.txt
0.94 real 0.54 user 0.39 sys
s...@serv4 ~ sudo ipfw table 25 list | wc -l
   65536

but file like:
table 25 add 192.168.0.36
table 25 add 192.168.0.37
table 25 add 192.168.0.38
table 25 add 192.168.0.39
table 25 add 192.168.0.40
table 25 add 192.168.0.41
table 25 add 192.168.0.42
___
freebsd-current@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to freebsd-current-unsubscr...@freebsd.org


Re: load ipfw table addresses from file

2010-04-09 Thread Alex Keda

09.04.2010 11:14, Hizel Ildar пишет:

В Fri, 09 Apr 2010 10:57:31 +0400
Alex Kedaad...@lissyara.su  пишет:

   

hi!
is there any plans to implement such opportunities?
for large files (we have 60k lines) it's very slow work

srv1# sh -E
# wc -l /root/scripts/db/table.25.txt
 61073 /root/scripts/db/table.25.txt
# date  for i in `cat /root/scripts/db/table.25.txt`; do ipfw table
25 add $i; done  date
пятница,  9 апреля 2010 г. 10:42:01 (MSD)
пятница,  9 апреля 2010 г. 10:52:43 (MSD)
#
it took more than 10 minutes on busy server =(
___
freebsd-current@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to
freebsd-current-unsubscr...@freebsd.org

 

my variant:

s...@serv4 ~wc -l ip2.txt
65536 ip2.txt
s...@serv4 ~sudo ipfw table 25 flush
s...@serv4 ~sudo time ipfw /home/se/ip2.txt
 0.94 real 0.54 user 0.39 sys
s...@serv4 ~sudo ipfw table 25 list | wc -l
65536

but file like:
table 25 add 192.168.0.36
table 25 add 192.168.0.37
table 25 add 192.168.0.38
   

thanks, it is faster, but - this is a crutch =)
___
freebsd-current@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to freebsd-current-unsubscr...@freebsd.org


Re: load ipfw table addresses from file

2010-04-09 Thread Julian Elischer

On 4/9/10 1:02 AM, Alex Keda wrote:

09.04.2010 11:14, Hizel Ildar пишет:



# wc -l /root/scripts/db/table.25.txt
61073 /root/scripts/db/table.25.txt
# date for i in `cat /root/scripts/db/table.25.txt`; do ipfw table
25 add $i; done date
пятница, 9 апреля 2010 г. 10:42:01 (MSD)
пятница, 9 апреля 2010 г. 10:52:43 (MSD)
#
it took more than 10 minutes on busy server =(
___

[...]


but file like:
table 25 add 192.168.0.36
table 25 add 192.168.0.37
table 25 add 192.168.0.38

thanks, it is faster, but - this is a crutch =)


yes but it is a crutch that is 600 times faster.



___
freebsd-current@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to freebsd-current-unsubscr...@freebsd.org


Re: load ipfw table addresses from file

2010-04-09 Thread Ivan Voras
On 04/09/10 10:06, Julian Elischer wrote:
 On 4/9/10 1:02 AM, Alex Keda wrote:
 09.04.2010 11:14, Hizel Ildar пишет:
 
 # wc -l /root/scripts/db/table.25.txt
 61073 /root/scripts/db/table.25.txt
 # date for i in `cat /root/scripts/db/table.25.txt`; do ipfw table
 25 add $i; done date
 пятница, 9 апреля 2010 г. 10:42:01 (MSD)
 пятница, 9 апреля 2010 г. 10:52:43 (MSD)
 #
 it took more than 10 minutes on busy server =(
 ___
 [...]
 
 but file like:
 table 25 add 192.168.0.36
 table 25 add 192.168.0.37
 table 25 add 192.168.0.38
 thanks, it is faster, but - this is a crutch =)
 
 yes but it is a crutch that is 600 times faster.

I've never used the feature but ipfw has -p preprocessor argument
which looks like it might be used to process the file containing raw IP
addresses with a simple script that appends table 25 add to each
address before returning it to ipfw.

___
freebsd-current@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to freebsd-current-unsubscr...@freebsd.org