I'm trying to make per-as traffic statistics.
sql_table_type[bgpstat]: bgp
sql_optimize_clauses[bgpstat]: true
aggregate[bgpstat]: src_as, dst_as, peer_src_as, peer_dst_as
bgp_daemon: true
bgp_daemon_ip: xx.xx.xx.xx
bgp_daemon_max_peers: 4
bgp_aspath_radius: 3
bgp_follow_default: 1
nfacctd_as_new: bgp
bgp_peer_src_as_type: bgp
>From router (display bgp peer):
xx.xx.xx.xx ASyyyy 4 0 26 119 00:25:03
Established
But in mysql there is nothing about per-AS stat:
mysql> select * from acct_bgp;
+----------+--------+--------+-------------+-------------+-------------+-------------+-------+---------+------------+-----+----------+-------------+---------------------+---------------+
| agent_id | as_src | as_dst | peer_as_src | peer_as_dst | peer_ip_src |
peer_ip_dst | comms | as_path | local_pref | med | packets | bytes |
stamp_inserted | stamp_updated |
+----------+--------+--------+-------------+-------------+-------------+-------------+-------+---------+------------+-----+----------+-------------+---------------------+---------------+
| 0 | 0 | 0 | 0 | 0 | |
| | | 0 | 0 | 83567175 | 52910636865 |
0000-00-00 00:00:00 | NULL |
+----------+--------+--------+-------------+-------------+-------------+-------------+-------+---------+------------+-----+----------+-------------+---------------------+---------------+
--
With best regards, Evgeniy Kozhuhovskiy
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
