Код: Выделить всё
inet ipn # /usr/abills/libexec/traffic2sql 1 flowdir=/usr/abills/var/log/ipn/ debug=1
Debug mode on
/usr/abills/var/log/ipn//ft-v05.2008-01-29.192501+0300
1| 172.16.1.17| 0| 0| 0| 0| 0|
GT: 0.10247/Query: 1/ Stats Rows: 0 Unknown: 229
Код: Выделить всё
mysql> select * from ipn_log;
+-----+---------------------+---------------------+---------------+------------+-------------+--------+------------+-------------+----------+------------+
| uid | start | stop | traffic_class | traffic_in | traffic_out | nas_id | ip | interval_id | sum | session_id |
+-----+---------------------+---------------------+---------------+------------+-------------+--------+------------+-------------+----------+------------+
| 1 | 2008-01-29 20:05:01 | 2008-01-29 20:10:00 | 0 | 0 | 229 | 0 | 2886730001 | 1 | 0.000000 | |
+-----+---------------------+---------------------+---------------+------------+-------------+--------+------------+-------------+----------+------------+
1 row in set (0.00 sec)
mysql> select * from ipn_traf_detail;
+------------+------------+----------+----------+----------+------+---------------------+---------------------+--------+-----+
| src_addr | dst_addr | src_port | dst_port | protocol | size | f_time | s_time | nas_id | uid |
+------------+------------+----------+----------+----------+------+---------------------+---------------------+--------+-----+
| 2886730001 | 2886730239 | 0 | 0 | 0 | 229 | 2008-01-29 20:12:44 | 2008-01-29 20:12:44 | 0 | 1 |
+------------+------------+----------+----------+----------+------+---------------------+---------------------+--------+-----+