Hi Derrick, Excellent capturing of information of yours.
>From the SQL inserts you posted it's only evident that the src_as_path is not working properly - ie. does not say anything about as_path: you sure you did verify the same problem with that primitive? If yes, can you post something about it? About src_as_path, i see you miss the following statement in the config: bgp_src_as_path_type: bgp Can you please add it and let me know if then it appears to work OK? Cheers, Paolo On Mon, Oct 28, 2013 at 04:19:07PM -0700, Derrick Sawyer wrote: > Hi, > I am using pmacct 1.5.0rc1 and running into a issue in which the as-path > lookup via BGP is not being inserted into postgres. > > *Configuration:* > ! Defaults > debug: true > daemonize: false > plugins: pgsql[5mins], pgsql[hourly] > nfacctd_port: 7000 > nfacctd_time_new: true > interface: eth0 > nfacctd_as_new: bgp > nfacctd_net: bgp > nfacctd_peer_as: true > nfacctd_renormalize: true > plugin_buffer_size: 10240 > plugin_pipe_size: 1024000 > geoip_ipv4_file: /usr/share/GeoIP/GeoIP.dat > geoip_ipv6_file: /usr/share/GeoIP/GeoIPv6.dat > pkt_len_distrib_bins: > 0-199,200-399,400-599,600-799,800-999,1000-1499,1500-9000 > > !BGP > bgp_daemon: true > bgp_daemon_ip: x.x.x.x > bgp_daemon_max_peers: 100 > bgp_aspath_radius: 15 > bgp_peer_src_as_type: bgp > bgp_agent_map: /opt/src/pmacctd/etc/pmacct-agent_bgp.map > pre_tag_map: /opt/src/pmacctd/etc/pretag.map > bgp_daemon_msglog: true > > !SQL > sql_user: pmacctd > sql_passwd: xxxxxxxx > sql_optimize_clauses: true > sql_dont_try_update: true > sql_table_type: bgp > > aggregate: src_mac, dst_mac, src_host, dst_host, src_net, dst_net, > src_mask, dst_mask, src_as, dst_as, src_port, dst_port, tos, proto, flows, > tag, tcpflags, in_iface, out_iface, as_path, sampling_rate, > src_host_country, dst_host_country, pkt_len_distrib, timestamp_start, > timestamp_end, > src_as_path > > !5 min > sql_refresh_time[5mins]: 60 > sql_history[5mins]: 1m > sql_history_roundoff[5mins]: m > sql_table[5mins]: acct_5mins > > !1 hour > sql_refresh_time[hourly]: 3600 > sql_history[hourly]: 1h > sql_history_roundoff[hourly]: h > sql_table[hourly]: acct_hourly > > > *BGP msglog:* > INFO ( default/core/BGP ): [Id: x.x.x.x] u Prefix: '198.206.8.0/21' Path: > '65501 1299 3257 4436 29761 36352' Comms: '' EComms: '' LP: '100' MED: '0' > Nexthop: 'x.x.x.x' > INFO ( default/core/BGP ): [Id: x.x.x.x] w Prefix: '8.20.2.0/24' Path: > '65501 2914 174 35873' Comms: '' EComms: '' > INFO ( default/core/BGP ): [Id: x.x.x.x] u Prefix: '192.58.232.0/24' Path: > '65501 2914 209 6629' Comms: '' EComms: '' LP: '100' MED: '0' Nexthop: > 'x.x.x.x' > INFO ( default/core/BGP ): [Id: x.x.x.x] u Prefix: '198.206.8.0/21' Path: > '65501 2914 4436 29761 36352' Comms: '' EComms: '' LP: '100' MED: '0' > Nexthop: 'x.x.x.x' > INFO ( default/core/BGP ): [Id: x.x.x.x] u Prefix: '192.58.232.0/24' Path: > '65501 2914 3356 6629 6629 6629 6629 6629' Comms: '' EComms: '' LP: '100' > MED: '0' Nexthop: 'x.x.x.x' > INFO ( default/core/BGP ): [Id: x.x.x.x] u Prefix: '80.67.188.0/24' Path: > '65501 1299 3257 42456 60197' Comms: '' EComms: '' LP: '100' MED: '0' > Nexthop: 'x.x.x.x' > INFO ( default/core/BGP ): [Id: x.x.x.x] u Prefix: '89.234.141.0/24' Path: > '65501 1299 42456 60630' Comms: '' EComms: '' LP: '100' MED: '0' Nexthop: > 'x.x.x.x' > INFO ( default/core/BGP ): [Id: x.x.x.x] u Prefix: '80.67.188.0/24' Path: > '65501 1299 42456 60197' Comms: '' EComms: '' LP: '100' MED: '0' Nexthop: > 'x.x.x.x' > INFO ( default/core/BGP ): [Id: x.x.x.x] w Prefix: '186.235.48.0/21' Path: > '65501 1299 701 7738 263096' Comms: '' EComms: '' > INFO ( default/core/BGP ): [Id: x.x.x.x] u Prefix: '186.235.48.0/21' Path: > '65501 1299 701 7738 263096' Comms: '' EComms: '' LP: '100' MED: '0' > Nexthop: 'x.x.x.x' > INFO ( default/core/BGP ): [Id: x.x.x.x] w Prefix: '186.235.48.0/21' Path: > '65501 1299 701 7738 263096' Comms: '' EComms: '' > DEBUG ( default/core/BGP ): [Id: x.x.x.x] BGP_KEEPALIVE received > DEBUG ( default/core/BGP ): [Id: x.x.x.x] BGP_KEEPALIVE sent > > *SQL insert:* > INFO ( 5mins/pgsql ): *** Purging cache - START *** > DEBUG ( 5mins/pgsql ): INSERT INTO acct_5mins (stamp_updated, > stamp_inserted, mac_src, mac_dst, ip_src, ip_dst, as_src, iface_in, > iface_out, mask_src, mask_dst, as_dst, as_path, as_path_src, port_src, > port_dst, tcp_flags, tos, ip_proto, country_ip_src, country_ip_dst, > sampling_rate, pkt_len_distrib, timestamp_start, timestamp_start_residual, > timestamp_end, timestamp_end_residual, agent_id, packets, bytes, flows) > VALUES (ABSTIME(1383000001)::Timestamp, ABSTIME(1382999700)::Timestamp, > '00:00:00:00:00:00', '00:00:00:00:00:00', '199.7.69.0', 'x.x.x.x', 12008, > 564, 698, 24, 27, 0, '', '', 53, 50346, 0, 0, 17, 'US', '--', 1, '0-199', > ABSTIME(1383000342)::Timestamp, 179000000, ABSTIME(1383000342)::Timestamp, > 179000000, 1, 1, 62, 1) > > DEBUG ( 5mins/pgsql ): INSERT INTO acct_5mins (stamp_updated, > stamp_inserted, mac_src, mac_dst, ip_src, ip_dst, as_src, iface_in, > iface_out, mask_src, mask_dst, as_dst, as_path, as_path_src, port_src, > port_dst, tcp_flags, tos, ip_proto, country_ip_src, country_ip_dst, > sampling_rate, pkt_len_distrib, timestamp_start, timestamp_start_residual, > timestamp_end, timestamp_end_residual, agent_id, packets, bytes, flows) > VALUES (ABSTIME(1383000001)::Timestamp, ABSTIME(1382999700)::Timestamp, > '00:00:00:00:00:00', '00:00:00:00:00:00', '64.34.160.0', 'x.x.x.x', 13768, > 564, 698, 20, 27, 0, '', '', 53, 44730, 0, 0, 17, 'US', '--', 1, '0-199', > ABSTIME(1383000347)::Timestamp, 532000000, ABSTIME(1383000347)::Timestamp, > 532000000, 1, 1, 182, 1) > > DEBUG ( 5mins/pgsql ): INSERT INTO acct_5mins (stamp_updated, > stamp_inserted, mac_src, mac_dst, ip_src, ip_dst, as_src, iface_in, > iface_out, mask_src, mask_dst, as_dst, as_path, as_path_src, port_src, > port_dst, tcp_flags, tos, ip_proto, country_ip_src, country_ip_dst, > sampling_rate, pkt_len_distrib, timestamp_start, timestamp_start_residual, > timestamp_end, timestamp_end_residual, agent_id, packets, bytes, flows) > VALUES (ABSTIME(1383000001)::Timestamp, ABSTIME(1382999700)::Timestamp, > '00:00:00:00:00:00', '00:00:00:00:00:00', '208.78.71.0', 'x.x.x.x', 33517, > 564, 698, 24, 27, 0, '', '', 53, 30283, 0, 0, 17, 'US', '--', 1, '0-199', > ABSTIME(1383000347)::Timestamp, 153000000, ABSTIME(1383000347)::Timestamp, > 153000000, 1, 1, 180, 1) > > > I have looked at it for a few days but have not been able to figure it out. > Any help would be most appreciated. > > Thanks, > --Derrick > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists