[pmacct-discussion] BGP+VPNv4 Address Family Netflow v5

2013-10-11 Thread Olivier Benghozi
obviously wrong in my parameters? Thanks by advance . -- Olivier Benghozi Wifirst ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists

[pmacct-discussion] New features proposal discussion: BGP sync holdtime AS prepend compression

2013-12-12 Thread Olivier Benghozi
in this direction; what about removing prependings in this field ? Or what about replacing prependings by something like AS[55] for a 55 times prepended AS (something that would be easy to remove at the select)? Feel free to comment. -- Olivier Benghozi Wifirst

[pmacct-discussion] Char vs varchar vs text (Postgresql)

2014-04-17 Thread Olivier Benghozi
Hi all, I just wanted to share our experience with pmacct pushing netflow stuff to a Postgresql DB (9.2). By default the pmacct pgsql schemas use char(xxx) fields (for BGP stuff like AS, AS pathes, etc). After some readings, and some tests, it looks like replacing every char(xx) by text type

Re: [pmacct-discussion] mySQL ATON/NTOA and pmacct performance

2014-09-18 Thread Olivier Benghozi
Hi guys, I just wanted to summarize that: It looks like a fine way to address IPs in a DB seems to be the pgsql way. Fast, and you can easily select data using subnets without relying on regexp. While in mysql you either obtain a int value difficult to handle, or a string very slow to search

Re: [pmacct-discussion] nfacctd problems when using pgsql plugin with as_path and sql_use_copy

2018-02-02 Thread Olivier Benghozi
,ASZ} So this causes the whole update to be rejected. As the default delimiter isn't compatible with the information to record, I suggest it should be changed to something else (here we have good results with # for now). regards, Olivier Benghozi Wifirst > Le 4 déc. 2014 à 19:17, THE MIGHTY V

Re: [pmacct-discussion] pmacct 1.7.4 released !

2020-01-27 Thread Olivier Benghozi
Hi ! oom-killer just killed my instance, so «same here»... Some infos: # src/nfacctd -V NetFlow Accounting Daemon, nfacctd 1.7.4-git (20191126-01+c5) Arguments: '--enable-jansson' '--enable-64bit' '--enable-zmq' '--enable-pgsql' '--enable-l2' '--enable-traffic-bins' '--enable-bgp-bins'