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

pkg install net-snmp p5-Net-SNMP p5-Net-SNMP-Util p5-Net-Telnet-Cisco p5-Net-Ping p5-Parallel-ForkManager

/usr/local/nodeny]# perl install.pl -w=www
su: perl: command not found

Can't locate /usr/local/nodeny/web/user/lpay.pl at /usr/local/nodeny/web/calls.pm line 1463.
Compilation failed in require at /usr/local/nodeny/web/calls.pm line 1463.
Compilation failed in require at /usr/local/nodeny/web/calls.pm line 1463.

svn: E155007: '/usr/local/nodeny' is not a working copy

Система, при обновленииЮ выдает:

видимо удалил(ись) или повредил(лись) svn файлы. Переименуй /usr/local/nodeny в /usr/local/nodeny.backup, затем заново по svn скачайц биллинг и перениси в новую папку sat.cfg и модули. Затем perl install.pl -x

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

You need to create trigger tr_aft_ins_pon!
Execute in mysql:

DELIMITER $$
CREATE TRIGGER tr_aft_ins_pon AFTER INSERT ON pon_bind FOR EACH ROW
    REPLACE INTO pon_mon(bid, rx, tx, time)
    VALUES (new.id, new.rx, new.tx, new.changed);
$$
CREATE TRIGGER tr_aft_upd_pon AFTER UPDATE ON pon_bind FOR EACH ROW
    BEGIN
        IF (FORMAT(NEW.rx,1) <> FORMAT(OLD.rx,1) OR FORMAT(NEW.tx,1) <> FORMAT(OLD.tx,1)) THEN
            INSERT INTO pon_mon(bid, rx, tx, time) VALUES (NEW.id, NEW.rx, NEW.tx, UNIX_TIMESTAMP());
        END IF;
    END;
$$
DELIMITER ;

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
You need to create function normalize_ippool!
Execute in mysql:

DROP FUNCTION IF EXISTS `normalize_ippool`;
DELIMITER $$
CREATE FUNCTION `normalize_ippool` ( )
    RETURNS TINYINT NO SQL
BEGIN
    DECLARE mid INTEGER UNSIGNED;

    SELECT MAX(id) into mid FROM ip_pool;
    UPDATE ip_pool SET id = id + mid;
    SET @i = 0;
    UPDATE ip_pool SET id = @i:=@i+1 ORDER BY realip, type, tags;

    RETURN 1;
END$$
DELIMITER ;

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!