|
ru.unix.bsd
- RU.UNIX.BSD ------------------------------------------------------------------
From : Alex Ivanov 2:5020/400 27 Jun 2005 12:37:19
To : Andrey Ostanovsky
Subject : скрипт и crontab
--------------------------------------------------------------------------------
Mon Jun 27 2005 10:20, Andrey Ostanovsky wrote to Alex Ivanov:
AO> Hу, когда-то делал для сбора трафика.
AO> #!/usr/bin/perl -w
AO> # $Header$
AO> #
AO> # Simple script for input ipacctctl statistics data in verbose
AO> # mode from ng_acct_tee device to my_sql table. Written by aost
AO> #
AO> # Example:
AO> #
AO> # 1. Create ipacct netgraph devices(see ng_ipacct_init.sh)
AO> #
AO> # 2. Check: #ngctl list
AO> #
AO> # Name: rl1_ip_acct Type: ipacct ID:
AO> # Name: rl1_acct_tee Type: tee ID:
AO> #
AO> # 3. Usage: traf_to_base rl1 # where "rl1" - network interface name
AO> #
AO> #
AO> # Table structure for table 'traffic0_test'
AO> #
AO> # CREATE TABLE `traffic0_test`
AO> # ( `id` int(12) unsigned NOT NULL auto_increment,
AO> # `ip_from` int(15) default NULL,
AO> # `ip_to` int(15) default NULL,
AO> # `sport` int(6) default NULL,
AO> # `dport` int(6) default NULL,
AO> # `proto` int(4) default NULL,
AO> # `bytes` int(15) unsigned default NULL,
AO> # `packets` int(15) default NULL,
AO> # `ftime` int(14) default NULL,
AO> # PRIMARY KEY (`id`)) TYPE=MyISAM;
AO> #
AO> # Select example:
AO> #
AO> # select INET_NTOA(ip_to),
AO> # sum(bytes),
AO> # FROM_UNIXTIME(max(ftime)) as ftime
AO> # from traffic0_test
AO> # where INET_NTOA(ip_to) like "192.168.%"
AO> # group by ip_to
AO> # order by ftime
AO> #
AO> ##################################
AO> #
О! А как бы на него целиком глянуть?
--- ifmail v.2.15dev5.3
* Origin: FidoNet Online - http://www.fido-online.com (2:5020/400)
Вернуться к списку тем, сортированных по: возрастание даты уменьшение даты тема автор
|
