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

Filter-Id = 5000/3000

mysql> call radreply('maxinet');
+------+---------+-------------------+-------------+---+
| NULL | login   | Framed-IP-Address | usr_ip      | = |
+------+---------+-------------------+-------------+---+
| NULL | maxinet | Framed-IP-Address | 10.193.0.50 | = |
+------+---------+-------------------+-------------+---+
1 row in set (0.00 sec)

+------+---------+-------------------+-----------------+---+
| NULL | login   | Framed-IP-Netmask | 255.255.255.255 | = |
+------+---------+-------------------+-----------------+---+
| NULL | maxinet | Framed-IP-Netmask | 255.255.255.255 | = |
+------+---------+-------------------+-----------------+---+
1 row in set (0.00 sec)

+------+---------+-----------------+-----+---+
| NULL | login   | Framed-Protocol | PPP | = |
+------+---------+-----------------+-----+---+
| NULL | maxinet | Framed-Protocol | PPP | = |
+------+---------+-----------------+-----+---+
1 row in set (0.00 sec)

Query OK, 1 row affected (0.00 sec)

+------+---------+------------------------+------------------------+---+
| NULL | login   | strSplit(line, '=', 1) | strSplit(line, '=', 2) | = |
+------+---------+------------------------+------------------------+---+
| NULL | maxinet | Filter-Id              | 5000/3000              | = |
+------+---------+------------------------+------------------------+---+
1 row in set (0.00 sec)

Query OK, 1 row affected (0.00 sec)

update users_services set radius_attr='ERX-Service-Activate:1+= "pppoe_local(10m,10m,15m,15m)"' where service_id=id услуги;

PPPD-Upstream-Speed-Limit = 10240
PPPD-Downstream-Speed-Limit = 10240

# radtest 0090273c4ffc '' 127.0.0.1 0 hardpass5
Sending Access-Request of id 42 to 127.0.0.1 port 1812
        User-Name = "0090273c4ffc"
        User-Password = ""
        NAS-IP-Address = *
        NAS-Port = 0
        Message-Authenticator = 0x00000000000000000000000000000000
rad_recv: Access-Accept packet from host 127.0.0.1 port 1812, id=42, length=56
        Framed-IP-Address = 192.168.209.5
        Framed-IP-Netmask = 255.255.255.255
        Session-Timeout = 600
        Framed-Protocol = PPP
        PPPD-Upstream-Speed-Limit = 10240
        PPPD-Downstream-Speed-Limit = 10240

# cat /usr/local/nodeny/services/_inet_unlim.pm | grep attr
    $actions->{set_service}{set_field_radius_attr} = $service_new->{param}{radius_attr} || '' if $service_new->{param}{mode} != 3;

# svn info
Path: .
Working Copy Root Path: /usr/local/nodeny
URL: svn://nodeny-plus.com.ua/release
Relative URL: ^/
Repository Root: svn://nodeny-plus.com.ua/release
Repository UUID: 2dcad6c2-3daf-43f6-9252-ff095f4c085f
Revision: 291
Node Kind: directory
Schedule: normal
Last Changed Author: sv
Last Changed Rev: 291
Last Changed Date: 2014-10-05 12:49:30 +0300 (нд, 05 жов 2014)

            foreach my $f( keys %$p )
            {
                $f =~ /^set_field_(.+)$/ or next;
                $sql .= ",$1=?";
                push @sql_param, $p->{$f};
            }

if( sum_traf() < 50000000 ) { set_speed(11000) }

PPPD-Upstream-Speed-Limit = 2048
PPPD-Downstream-Speed-Limit = 2048

PPPD-Upstream-Speed-Limit = 11000
PPPD-Downstream-Speed-Limit = 11000

grep radius /usr/local/nodeny/web/_o_services.pl

--- Модуль coa ---
Файл create.noserver.coa.pm
  { file=>'noserver/coa.pm',hook=>'new' }
Файл create.cfg.coa.cfg.pm
  { file=>'cfg/coa.cfg.pm',hook=>'new' }

$coa_disconnect = {
    type     => 'coa',
    template => 'Acct-Session-Id={{auth_ses}}, Mikrotik-Rate-Limit=0',
};