Hi Evgeniy, Is the router exporting NetFlow and BGP peering with the same IP address? If not a mapping (bgp_agent_map) is required.
Cheers, Paolo On Mon, Oct 01, 2012 at 11:22:11AM +0300, Evgeniy Kozhuhovskiy wrote: > 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 _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
