BiTel

#./radius_status.sh
version 5.2 build 376 from 13.03.2013 15:12:10
26.04.2013 14:53:34     3238    3164    74      0
Request accounts per minute start: 14; stop: 16; update: 226
Request auths per minute accept: 14; reject: 14
Netfow packets per minute: 5937
Ignore per minute auth: 0; update: 0
Antispam ban count: 5; used per minute: 26
FlowListener: queue_size: 0; threads_active: 0; largest: 20; core: 20; pool_size: 20; ru.bitel.bgbilling.modules.dialup.radius.DialUpFlowListener$3@4c9e4e2a [recv_socket_buf_size: 131 071; recv_buf_size: 8 388 608]; packets: 10911383
Started: 08.04.2013 19:02:35    Uptime: 17 d 19:50:59
Memory total: 295 567 360; max: 954 466 304; free: 28 624 136
Memory pools:
  Non-heap memory[Code Cache]: max: 50 331 648; used: 13 512 320; peek: 13 513 728
  Heap memory[PS Eden Space]: max: 355 074 048; used: 9 355 760; peek: 348 061 696
  Heap memory[PS Survivor Space]: max: 1 376 256; used: 1 097 824; peek: 31 046 104
  Heap memory[PS Old Gen]: max: 715 849 728; used: 256 492 912; peek: 310 900 760
  Non-heap memory[PS Perm Gen]: max: 88 080 384; used: 33 863 056; peek: 37 525 024
Thread count: 520
Trees in cache: 28
Connections pool to Master status Idle: 15; Active: 0; maxActive: 100; maxIdle: 15

26.04.2013 14:53:34     3238    3164    74      0

 # ./accounting_status.sh
Java Runtime: Sun Microsystems Inc. Java HotSpot(TM) 64-Bit Server VM [1.6.0_22] /opt/sun-jdk-1.6.0.22/jre
  Runtime name: 17653@bg.local
  Java endorsed dirs: /lib/endorsed:/etc/java-config-2/current-system-vm/lib/endorsed
  OS: Linux 2.6.33-gentoo [amd64], file.encoding: UTF-8, user.name: root
  Heap sizes: current=245248k  free=243967k  max=3639104k
Kernel version 5.2 build 1474 from 08.04.2013 14:44:23
Inet version 5.2 build 1141 from 08.04.2013 14:44:22
Radius:
  accounting-requests per minute start: 0; stop: 0; update: 0
  access-requests per minute accept: 0; reject: 0
  ignore per minute access-request: 0; accounting-update: 0

Started: 23.04.2013 11:40:45    Uptime: 3 d 03:32:55
Memory total: 138 346 496; max: 477 233 152; free: 33 717 840
Memory pools:
  Non-heap memory[Code Cache]: max: 50 331 648; used: 4 945 984; peek: 4 963 008
  Heap memory[PS Eden Space]: max: 178 126 848; used: 2 729 248; peek: 130 547 712
  Heap memory[PS Survivor Space]: max: 393 216; used: 327 680; peek: 36 211 408
  Heap memory[PS Old Gen]: max: 357 957 632; used: 101 575 224; peek: 184 408 592
  Non-heap memory[PS Perm Gen]: max: 88 080 384; used: 36 542 104; peek: 42 649 416
Thread count: 46
Trees in cache: 0
Connections pool to Master status Idle: 4; Active: 0; maxActive: 300; maxIdle: 20
Connections pool to Slave "1" status Idle: 2; Active: 0; maxActive: 100; maxIdle: 10

#!/bin/sh

# настройки MySQL сервера
db_host='81.30.195.156'
db_port='3306'
db_name='bgbilling'
db_user='dimOn'
db_pass='^_^'

# настройки MySQL клиента
mysql_bin='/usr/local/bin/mysql'
mysql_cmd="-h $db_host -P $db_port -u $db_user -p$db_pass -D $db_name -B -e"
mysql="$mysql_bin $mysql_cmd"

# корневой OID, который будем запрашивать
oid='.1.3.6.1.4.1.2021.255'

if [ "$1" = "-g" ]; then
    case "$2" in
        $oid.2.1)
            # приход за месяц
            res=`$mysql "SELECT ROUND(SUM(summa2)) AS cnt FROM contract_balance WHERE yy = YEAR(CURDATE()) AND mm = MONTH(CURDATE());" | sed s/cnt//g`
            echo $2
            echo 'integer'
            echo $res
            exit 0
            ;;
        $oid.2.2)
            # затраты (наработка + расходы) за месяц
            res=`$mysql "SELECT ROUND(SUM(summa3) + SUM(summa4)) AS cnt FROM contract_balance WHERE yy = YEAR(CURDATE()) AND mm = MONTH(CURDATE());" | sed s/cnt//g`
            echo $2
            echo 'integer'
            echo $res
            exit 0
            ;;
        $oid.3.1)
            # кол-во online логинов (не договоров!)
            tbl_date=`date +%Y%m`
            res=`$mysql "SELECT COUNT(DISTINCT(lid)) AS cnt FROM log_session_1_$tbl_date WHERE status = 0 AND fake != 1;" | sed s/cnt//g`
            echo $2
            echo 'integer'
            echo $res
            exit 0
            ;;
        $oid.10)
            # общее кол-во юзеров (логинов а не договоров!)
            res=`$mysql "SELECT COUNT(id) AS cnt FROM user_login_1;" | sed s/cnt//g`
            echo $2
            echo 'integer'
            echo $res
            exit 0
            ;;
        *)
            echo $2
            exit 0
            ;;
    esac
fi

# grep .1.3.6.1.4.1.2021.255 /usr/local/etc/snmp/snmpd.conf
pass .1.3.6.1.4.1.2021.255 /bin/sh /usr/local/etc/snmp/bgb_info.sh

radius.realm.default.attributes=cisco-SSG-Account-Info=ADEFAULT;
radius.realm.nat.attributes=cisco-SSG-Account-Info=ADEFAULT;cisco-SSG-Account-Info=AINET100M_NAT;

radius.inetOption.1.template=cisco-SSG-Account-Info=A$optionTitle
radius.inetOption.1.nat.template=cisco-SSG-Account-Info=A$optionTitle_NAT

serv.radius.realm.default.attributes=