[pmacct-discussion] route distinguisher (RD) looks wired when dump the BGP table.

[Alberto Santos]

Hi,

I started playing with pmacct and I noticed that the route distinguisher RD
looks wired when dumping the BGP table in a file. Is there any reason why?

here it is an example:

"rd": "1:40.0.17.10:256

The IP address is inverted, it should be 10.17.0.40 and the 2nd part should
be 1806 instead.
Is this a bug? pls find below the complete output from the file.

[root@hostname]# cat bgp-10_197_1_114-2016_11_29T20_05_00.txt | grep
10.12.95.16
{"timestamp": "2016-11-29 20:05:00", "peer_ip_src": "10.17.1.14",
"event_type": "dump", "ip_prefix": "10.12.95.16/28", "bgp_nexthop":
"10.17.1.14", "as_path": "65346", "comms": "65346:39", "ecomms":
"RT:65432:2", "origin": 0, "local_pref": 100, "rd": "1:40.0.17.10:256"}

BR

Alberto
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

[pmacct-discussion] stamp_inserted

[Jaroslav Jirásek]

Hi, I use this scerario:

sql_refresh_time: 120
sql_history: 2m
sql_history_roundoff: m
sql_dont_try_update: true
nfacctd_pro_rating: true

aggregate[router1.all.in]: 
src_host,dst_host,proto,src_port,dst_port,timestamp_start,timestamp_end
aggregate[router1.all.out]: 
src_host,dst_host,proto,src_port,dst_port,timestamp_start,timestamp_end

aggregate[router1.sums.in]: dst_host
aggregate[router1.sums.out]: src_host

plugins: 
mysql[router1.all.in],mysql[router1.all.out],mysql[router1.sums.in],mysql[router1.sums.out]


sql_table[router1.all.in]: %Y%m%d_router1_in
sql_table[router1.all.out]: %Y%m%d_router1_out
sql_table[router1.sums.in]: %Y_router1_sums_in
sql_table[router1.sums.out]: %Y_router1_sums_out

sql_startup_delay[router1.all.in]: 240
sql_startup_delay[router1.all.out]: 240
sql_startup_delay[router1.sums.in]: 240
sql_startup_delay[router1.sums.out]: 240

in tables %Y%m%d_router1_in and %Y%m%d_router1_out I have columns 
stamp_inserted and stamp_updated,
but I don´t need them, because I aggregate nothing. timestamp_start and 
timestamp_end is enough.
In these tables I need to store everything for best accuracy when 
finding problems.


In sums tables I don´t need column stamp_updated.

Is there any way to not store these columns?

Thank you, Jaroslav


___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists