I see, thanks for the input. The simplest solution i'd have for you is
to use post_tag (or post_tag2), if you are not using tags for anything
else. Essentially: you add 'tag' to your 'aggregate' line (and modify
your SQL schema to reflect that) and add to your config 'post_tag: X'
where X is a positive integer number different for each pmacct server.
Would that work for you?

Paolo 

On Tue, Aug 22, 2017 at 05:45:22PM +0200, fboehm wrote:
> Am 2017-08-22 um 16:45 schrieb Paolo Lucente:
> >
> >Hi Franz,
> >
> >Are you interested in the pmacct server hostname or the IP address of
> >the NetFlow/IPFIX/sFlow exporter? Would peer_src_ip, the IP address of
> >the flow exporter do it? Or you are collecting via libpcap or NFLOG?
> >
> >Paolo
> >
> >On Mon, Aug 21, 2017 at 05:23:34PM +0200, fboehm wrote:
> >>Hi,
> >>
> >>we use pmacct to purge traffic data to a MySQL database for billing
> >>purposes. We might need to run multiple pmacct instances to monitor
> >>all relevant traffic.
> >>
> >>It would be most convenient for postprocessing if all pmacct
> >>instances could write into the same SQL tables. For example by
> >>adding an additional column with the hostname of the pmacct server.
> >>
> >>Unfortunately I only know how to assign a certain database or table
> >>to each pmacct instance. But not how to modifiy the SQL schema to
> >>support a hostname or other identifier.
> >>
> >>Kind regards,
> >>Franz
> >>
> >>_______________________________________________
> >>pmacct-discussion mailing list
> >>http://www.pmacct.net/#mailinglists
> >
> >_______________________________________________
> >pmacct-discussion mailing list
> >http://www.pmacct.net/#mailinglists
> >
> 
> Hi Paolo,
> 
> At the moment we use libpcap instead of netflow. Those there is
> unfortunately no flow exporter.
> 
> I used netflow for a while but I like to just rely on a mirrored
> switch port. I think it's easier to manage in contrast to networking
> gear with netflow support.
> 
> Franz
> 
> _______________________________________________
> pmacct-discussion mailing list
> http://www.pmacct.net/#mailinglists

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

Reply via email to