Биллинговая система Nodeny

[root@testbox /usr/local/nodeny]# perl noserver.pl -v
Start. Flag -h for help

loading /usr/local/nodeny/sat.cfg

Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.057517 sec

loading noserver::nofire.pm

loading noserver::shapes.pm

SELECT SQL_BUFFER_RESULT * FROM nets WHERE priority>0 ORDER BY priority
Строк: 2. Время выполнения sql: 0.0029 сек

Добавление в фаервол сети 10.0.0.0/8 направления 4

Добавление в фаервол сети 0.0.0.0/0 направления 1

 SELECT u.id, a.ip FROM ( SELECT INET_NTOA(i.ip) AS ip FROM users u JOIN ip_pool i ON i.uid=u.id WHERE u.lstate=1 UNION SELECT ip FROM auth_now ) a JOIN ip_pool i ON INET_ATON(a.ip)=i.ip JOIN users u ON i.uid=u.id WHERE u.state='on' AND EXISTS (SELECT uid FROM v_services WHERE tags LIKE '%,inet,%' AND uid=u.id)
Строк: 1. Время выполнения sql: 0.0030 сек

SELECT uid, param FROM v_services WHERE tags LIKE '%,speed,%'
Строк: 1. Время выполнения sql: 0.0013 сек

SELECT SQL_BUFFER_RESULT *,SUM(in1+in2+in3+in4) AS traf_in, SUM(out1+out2+out3+out4) AS traf_out FROM users_trf GROUP BY uid
Строк: 1. Время выполнения sql: 0.0010 сек

Fw On uid: 1, ip: 10.0.0.2, вх.скор: 1024 КБит/с

add 18500 deny ip from any to any
add 46500 deny ip from any to any
add 60000 deny ip from any to any
add 32000 deny ip from any to any
table 14 flush
table 24 flush
add 5000 skipto 18501 ip from table(24) to table(14)
add 18501 pipe tablearg ip from table(24) to any
table 34 flush
add 33000 skipto 46501 ip from table(14) to table(34)
add 46501 pipe tablearg ip from any to table(34)
table 14 add 10.0.0.0/8
table 11 flush
table 21 flush
add 5001 skipto 18502 ip from table(21) to table(11)
add 18502 pipe tablearg ip from table(21) to any
table 31 flush
add 33001 skipto 46502 ip from table(11) to table(31)
add 46502 pipe tablearg ip from any to table(31)
table 11 add 0.0.0.0/0
pipe 1001 config bw 1024000bit/s
pipe 1006 config bw 1024000bit/s
table 31 add 10.0.0.2 1006
table 21 add 10.0.0.2 1001