Dears,

Just for the archives: this has been solved by this commit:

https://github.com/pmacct/pmacct/commit/0da36b1aba053128532d6c1342e4f777a46b0041

Cheers,
Paolo 

On Sat, Dec 03, 2016 at 01:24:47AM +0200, Сергей Горшков wrote:
> Hi Paolo, thank you for the answer
> 
> root@pmacct:/etc/pmacct# cat bgp_agent.map
> bgp_ip=176.**.**.252          ip=0.0.0.0/0    filter='ip'
> bgp_ip=2001:**:**:1::11      ip=0.0.0.0/0    filter='ip6'
> 
> Unfortunately, it did not help:-(
> Running takes place perfectly
> Dec 03 01:07:22 INFO ( default/core ): Trying to (re)load map:
> /etc/pmacct/bgp_agent.map
> Dec 03 01:07:22 INFO ( default/core ): map
> '/etc/pmacct/bgp_agent.map' successfully (re)loaded.
> Dec 03 01:07:22 INFO ( default/core/BGP ): maximum BGP peers allowed: 4
> Dec 03 01:07:22 INFO ( default/core/BGP ): waiting for BGP data on :::179
> Dec 03 01:07:24 INFO ( default/core/BGP ): BGP peers usage: 1/4
> Dec 03 01:07:24 INFO ( default/core/BGP ): Capability: MultiProtocol
> [1] AFI [1] SAFI [1]
> Dec 03 01:07:24 INFO ( default/core/BGP ): Capability: 4-bytes AS
> [41] ASN [5**81]
> Dec 03 01:07:24 INFO ( default/core/BGP ): [Id: 31.**.**.2]
> BGP_OPEN: Asn: 5**81 HoldTime: 240
> Dec 03 01:07:27 INFO ( default/core ): waiting for sFlow data on :::6343
> Dec 03 01:07:27 INFO ( default/mysql ): cache entries=32771 base
> cache memory=11369224 bytes
> Dec 03 01:08:01 INFO ( default/mysql ): *** Purging cache - START
> (PID: 1239) ***
> Dec 03 01:08:01 INFO ( default/mysql ): *** Purging cache - END
> (PID: 1239, QN: 3618/3618, ET: 0) ***
> Dec 03 01:08:59 INFO ( default/core/BGP ): BGP peers usage: 2/4
> Dec 03 01:08:59 INFO ( default/core/BGP ): Capability: MultiProtocol
> [1] AFI [2] SAFI [1]
> Dec 03 01:08:59 INFO ( default/core/BGP ): Capability: 4-bytes AS
> [41] ASN [5**81]
> Dec 03 01:08:59 INFO ( default/core/BGP ): [Id: 176.**.**.97]
> BGP_OPEN: Asn: 5**81 HoldTime: 180
> 
> But here's the result of a
> +----------+------+--------+--------+---------------------+-------------------+----------+----------+----------+---------+-------+-------+---------------------+---------------------+
> | agent_id | vlan | as_src | as_dst | ip_src              | ip_dst
> | src_port | dst_port | ip_proto | packets | bytes | flows |
> stamp_inserted      | stamp_updated       |
> +----------+------+--------+--------+---------------------+-------------------+----------+----------+----------+---------+-------+-------+---------------------+---------------------+
> |        0 | 3855 |      0 |      0 | 2001:4860::1:0:893c |
> 2001:67c:2d40::47 |        0 |        0 | ipv6-i   |       1 | 214 |
> 0 | 2016-12-03 01:00:00 | 2016-12-03 01:14:01 |
> +----------+------+--------+--------+---------------------+-------------------+----------+----------+----------+---------+-------+-------+---------------------+---------------------+
> and
> |        0 | 3800 |      0 |      0 | 31.43.61.166           |
> 185.38.12.42              |    56911 |       80 | tcp      | 1 |
> 64 |     0 | 2016-12-03 01:00:00 | 2016-12-03 01:08:01 |
> 
> Perhaps this will give a little more information to solve the problem
> Sfacct version
> #sfacctd -V
> sFlow Accounting Daemon, sfacctd 1.5.2 (20150907-00)
>  --build=x86_64-linux-gnu
>  --prefix=/usr '--includedir=${prefix}/include'
> '--mandir=${prefix}/share/man' '--infodir=${prefix}/share/info'
>  --sysconfdir=/etc
>  --localstatedir=/var
>  --disable-silent-rules '--libdir=${prefix}/lib/x86_64-linux-gnu'
> '--libexecdir=${prefix}/lib/x86_64-linux-gnu'
> --disable-maintainer-mode
>  --disable-dependency-tracking
>  --enable-mmap
>  --enable-pgsql
>  --with-pgsql-includes=/usr/include/postgresql
>  --enable-mysql
>  --enable-sqlite3
>  --enable-ipv6
>  --enable-v4-mapped
>  --enable-64bit
>  --enable-threads
>  --enable-jansson
>  --enable-geoip
>  --enable-rabbitmq
> -----------------------------------------------------------
> Database
> create table acct_v6 (
>     agent_id INT(4) UNSIGNED NOT NULL,
>     class_id CHAR(16) NOT NULL,
>     vlan INT(2) UNSIGNED NOT NULL,
>     as_src INT(4) UNSIGNED NOT NULL,
>     as_dst INT(4) UNSIGNED NOT NULL,
>     ip_src CHAR(15) NOT NULL,
>     ip_dst CHAR(15) NOT NULL,
>     src_port INT(2) UNSIGNED NOT NULL,
>     dst_port INT(2) UNSIGNED NOT NULL,
>     ip_proto CHAR(6) NOT NULL,
>     packets INT UNSIGNED NOT NULL,
>     bytes BIGINT UNSIGNED NOT NULL,
>     flows INT UNSIGNED NOT NULL,
>     stamp_inserted DATETIME NOT NULL,
>     stamp_updated DATETIME,
>     PRIMARY KEY (agent_id, class_id, vlan, as_src, as_dst, ip_src,
> ip_dst, src_port, dst_port, ip_proto, stamp_inserted)
> );
> 
> For suggestions, critics, bugs, contact me: Paolo Lucente
> <pa...@pmacct.net>.
> 
> 03.12.2016 0:03, Paolo Lucente пишет:
> >Hi Sergey,
> >
> >I guess what you need is to refine your bgp_agent_map as follows:
> >
> >bgp_ip=176.**.**.252         ip=0.0.0.0/0    filter='ip'
> >bgp_ip=2001:**:**:1::11      ip=0.0.0.0/0    filter='ip6'
> >
> >Let me know if this works for you.
> >
> >Cheers,
> >Paolo
> >
> >On Fri, Dec 02, 2016 at 08:09:07PM +0200, Сергей Горшков wrote:
> >>Hi all.
> >>
> >>I need your help because I am in a deadlock
> >>
> >>My config
> >>
> >>#cat sfacctd.conf
> >>! sfacctd configuration
> >>!
> >>!
> >>!
> >>daemonize:              true
> >>interface:              any
> >>pidfile:                /var/run/sfacctd.pid
> >>syslog:                 daemon
> >>logfile:                /var/log/sfacct.log
> >>!
> >>sfacctd_as_new:         bgp
> >>bgp_daemon:             true
> >>bgp_agent_map:          /etc/pmacct/bgp_agent.map
> >>!
> >>aggregate: tag,vlan,src_as,dst_as,src_host,dst_host,src_port,dst_port,proto
> >>!
> >>plugins:                mysql
> >>sql_db:                 pmacct
> >>sql_table_version:      6
> >>sql_table:              acct_v6
> >>sql_host:               localhost
> >>sql_user:               *****
> >>sql_passwd:             *****
> >>sql_refresh_time:       60
> >>sql_optimize_clauses:   true
> >>sql_history:            1h
> >>sql_history_roundoff:   h
> >>sql_locking_style:      row
> >>------------------------------------------------------
> >>
> >># cat bgp_agent.map
> >>bgp_ip=176.**.**.252          ip=0.0.0.0/0
> >>bgp_ip=2001:**:**:1::11      ip=0.0.0.0/0
> >>------------------------------------------------------
> >>In this configuration, all IP6 addresses obtained AS 0
> >>
> >>select * from acct_v6 where ip_src like '%2001:4860%';
> >>+----------+------+--------+--------+---------------------+-------------------+----------+----------+----------+---------+-------+-------+---------------------+---------------------+
> >>| agent_id | vlan | as_src | as_dst | ip_src              |
> >>ip_dst            | src_port | dst_port | ip_proto | packets | bytes |
> >>flows | stamp_inserted      | stamp_updated       |
> >>+----------+------+--------+--------+---------------------+-------------------+----------+----------+----------+---------+-------+-------+---------------------+---------------------+
> >>|        0 | 3855 |      0 |      0 | 2001:4860::8:0:8f90 |
> >>2001:67c:2d40::47 |        0 |        0 | ipv6-i   |       2 | 428 |
> >>0 | 2016-12-01 11:00:00 | 2016-12-01 11:35:01 |
> >>
> >>IP4 everything is fine
> >>
> >>|        0 | 3905 |  15169 |  50581 | 173.194.21.80   | 31.43.60.150
> >>|      443 |    21668 | tcp      |       2 |  3044 |     0 | 2016-12-01
> >>11:00:00 | 2016-12-01 11:16:01 |
> >>
> >>If BGP neighbors to change their place
> >>
> >># cat bgp_agent.map
> >>bgp_ip=2001:**:**:1::11      ip=0.0.0.0/0
> >>bgp_ip=176.**.**.252          ip=0.0.0.0/0
> >>
> >>Then get IP6 AS number and get IP4 AS0
> >>How to make sFacct collated both IP4 and IP6 addresses with an
> >>autonomous system number??
> >>
> >>
> >>
> >>_______________________________________________
> >>pmacct-discussion mailing list
> >>http://www.pmacct.net/#mailinglists
> >_______________________________________________
> >pmacct-discussion mailing list
> >http://www.pmacct.net/#mailinglists
> 

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

Reply via email to