[pmacct-discussion] peer-AS calculation (plus netflow v9 sampling) questions

2009-10-27 Thread Zenon Mousmoulas
Hi, I am exporting netflow data to nfacctd from a source configured for origin-as, so I am trying to figure out how to calculate peer src/dst AS, probably by using bgp_peer_src_as_map. Here are some questions: 1. Does bgp_peer_src_as_map apply both to src and dst AS or only the first? In

Re: [pmacct-discussion] peer-AS calculation (plus netflow v9 sampling) questions

2009-10-27 Thread Paolo Lucente
Hi Zenon, On Tue, Oct 27, 2009 at 01:16:06PM +0200, Zenon Mousmoulas wrote: 1. Does bgp_peer_src_as_map apply both to src and dst AS or only the first? In any case, I don't understand how bgp_nexthop can be used for calculating the peer src AS, since that field applies to the destination

[pmacct-discussion] why is PostgreSQL - timestamp without time zone

2009-10-27 Thread Charlie Allom
Hi Paolo, Why is postgresql set to having the timestamps set to timestamp without time zone? I am having issues doing some queries and wonder what might be a nfacctd problem if I move the table to use timestamp WITH time zone. as an aside: here is an SQL issue I'm having problems with..

Re: [pmacct-discussion] why is PostgreSQL - timestamp without time zone

2009-10-27 Thread Karl O. Pinc
On 10/27/2009 08:31:45 AM, Charlie Allom wrote: as an aside: here is an SQL issue I'm having problems with.. pmacct= SELECT step.date,CAST(step.date as int),foo.mb FROM (SELECT acct_v6.stamp_inserted,SUM(acct_v6.bytes) AS mb FROM acct_v6 WHERE as_src = '714' GROUP BY stamp_inserted) AS

Re: [pmacct-discussion] why is PostgreSQL - timestamp without time zone

2009-10-27 Thread Charlie Allom
On Tue, Oct 27, 2009 at 10:13:57AM -0500, Karl O. Pinc wrote: On 10/27/2009 08:31:45 AM, Charlie Allom wrote: as an aside: here is an SQL issue I'm having problems with.. pmacct= SELECT step.date,CAST(step.date as int),foo.mb FROM (SELECT acct_v6.stamp_inserted,SUM(acct_v6.bytes) AS

Re: [pmacct-discussion] peer-AS calculation (plus netflow v9 sampling) questions

2009-10-27 Thread Zenon Mousmoulas
Hi Paolo, On 27 Οκτ 2009, at 2:04 ΜΜ, Paolo Lucente wrote: 1. Does bgp_peer_src_as_map apply both to src and dst AS or only the first? In any case, I don't understand how bgp_nexthop can be used for calculating the peer src AS, since that field applies to the destination recorded in the flow