Hi Robert, It may be possible that the bgp_agent_map is not crafted correctly so nfacctd is unable to map NetFlow to BGP data correctly. Also, you can add the following to your config to check that BGP data is arriving correctly to the daemon:
bgp_table_dump_file: /path/to/spool/bgp-$peer_src_ip-%H%M.log bgp_table_dump_refresh_time: 120 If all BGP data is there, then it's definitely a bgp_agent_map issue. Cheers, Paolo On Tue, Jul 12, 2016 at 11:20:05AM +0200, Robert Kaelin wrote: > Good Day, > > This is my first time writing to a Mailing List and I'm trying my > best, so please bear with me. > > I have a Question regarding the BGP Daemon inside pmacct, my goal is > to aggregate Traffic by Prefix / Network. > > I have my (currently 2) PE's exporting NetFlow and also BGP Peering > with my Server. > > The BGP works and starts and I see that Information is beeing > exported (on the PE's). > > The Writing to the database also works, but the Fields: > net_dst, net_src, peer_as_src, peer_as_dst, peer_ip_dst > are always either "0" or "0.0.0.0" respectively. > > Can anybody help me with this Problem? > Or maybe has done something similiar? > > I have set up a custom Database: > net_dst > net_src > port_src > port_dst > comms > comms_src > as_src > as_dst > peer_as_src > peer_as_dst > peer_ip_dst > > packets > bytes > stamp_inserted > stamp_updated > > > > And created following configuration: > > ! > ! General Settings > ! > interface: eth1 > daemonize: false > aggregate: src_net, dst_net, src_port, dst_port, ext_comm, > src_ext_comm, src_as, dst_as, peer_src_as, peer_dst_as, peer_dst_ip > plugins: mysql > > ! > ! NetFlow Settings > ! > nfacctd_time_new: false > nfacctd_account_options: true > > nfacctd_net: bgp > pmacctd_as: bgp > pmacctd_net: bgp > nfacctd_as_new: bgp > > ! > ! MySQL Settings > ! > sql_user: X > sql_passwd: X > sql_db: X > sql_table: X > sql_table_type: bgp > sql_table_version: 9 > sql_refresh_time: 300 > sql_history: 5m > sql_history_roundoff: m > sql_dont_try_update: true > sql_num_hosts: false > sql_optimize_clauses: true > > ! > ! BGP Settings > ! > bgp_daemon: true > bgp_daemon_ip: X.X.X.X > bgp_daemon_port: X > bgp_agent_map: X > ! Inside the Map: > ! bgp_ip=1.1.1.1 ip=1.1.1.1 > ! bgp_ip=2.2.2.2 ip=2.2.2.2 > > > > > Thank you, > Robert Kaelin > ___________________________________________________________________________ > Network Engineer @ Network Engineering and Operations > > ___________________________________________________________________________ > Bitlabs AG > Switzerland > > https://bitlabs.ch > > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
