.
--
(aidworld) chris wilson | chief engineer (http://www.aidworld.org)
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
concerned about the performance of the MySQL plugin with
threading, so I'm considering providing an option to disable the extra
threads, and run updates synchronously.
I'd be very interested to hear your comments on these ideas. Thanks in
advance.
Cheers, Chris.
--
(aidworld) chris wilson | chief
working on it.
Cheers, Chris.
--
(aidworld) chris wilson | chief engineer (http://www.aidworld.org)
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
); and your pmacct client software needs to be modified to take
advantage of the new table.
Cheers, Chris.
--
(aidworld) chris wilson | chief engineer ([EMAIL PROTECTED])
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
Hi Ahmed,
On Tue, 10 Jun 2008, Ahmed Kamal wrote:
I have setup pmacct with your help, and it's been running like a champ. I
have also installed darkstat for comparison. I am seeing a big error (around
30%) between the 2 tools!
...
Here's what I am seeing:
IP START
Hi Sebastien,
Sébastien CRAMATTE wrote:
I'm running pmacctd on a natted network.
pmacctd account properply local traffic. My problem is that when I visit
a website o any other thing that is after the nat router (I'm
connected with cable modem) traffic is never accounted !
Does this is
Hi anil,
Anil wrote:
( default/mysql ) *** Purging cache - START ***
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Access denied for user
'admin'@'%.domain.com' to database 'bandwidth_db'
( default/mysql ) *** Purging cache - END
Hi Dennis,
Dennis Kempin wrote:
I am currently trying to set up pmacct to account traffic between my host and
the internet.
I account src and dst hosts without any filtering.
aggregate[out]: dst_host,src_host
aggregate[in]: dst_host,src_host
Looking at the results i wondered how
Hi all,
I always get a lot of errors like this when using pmacct on a MySQL
database:
Oct 2 06:26:01 fen-fw pmacctd[16237]: ERROR ( default/mysql ): Duplicate
entry
'00-0-0-217.160.76.21-10.0.156.226-4949-33730-tcp-0-2008-10-0' for key
1
Oct 2 06:26:01 fen-fw pmacctd[16239]: ERROR (
Hi Paolo,
On Wed, 8 Oct 2008, Paolo Lucente wrote:
Also, i see two different PIDs logging the duplication issue in your
email; whereas disabling the primary key the same tuple is written three
times; is it possible that there are multiple (3) concurrent pmacctd
instances running by
Hi Gregory,
On Tue, 21 Oct 2008, Gregory Machin wrote:
Im trying to configure pmacctd to graph traffic passing through the
public interface of a firewall .. The public interface is connected to
an adsl router .. they share a dedicated private lan . The firewall's ip
is 192.168.42.1 and
Hi Anil and Juan,
On Wed, 7 Jan 2009, Juan Rivera wrote:
My understanding is that any one instance of the daemon can only bind to
a single interface. I think that a workaround would be to run more than
one instance of the daemon, one per interface, and use a different
configuration file
Hi Mariano,
On Fri, 23 Jan 2009, Mariano Spadaccini wrote:
Now the problem is only on the tagged port. But I have tried others
probe, with the same error (only unidirectional flows).
However I have resolved with one pmacctd/one interface (untagged port).
Have you tried using any as the
Hi all,
On Wed, 18 Feb 2009, Paolo Lucente wrote:
In concept, and as documentation says, what you want to achieve is
feasible and your understanding of the classifier() is correct - you
only have to write down your own patterns: re-phrased, regular
expressions are typically employed to
Hi Paolo,
I'm running pmacctd 0.11.5 on a small network for traffic accounting.
Generally it's behaving well, but occasionally I can see weird data being
inserted:
17190 Query INSERT INTO `acct_v7` (stamp_updated, stamp_inserted, vlan,
ip_dst, as_src, as_dst, src_port, dst_port, tcp_flags,
Hi Karl,
On Sat, 14 Mar 2009, Karl O. Pinc wrote:
Do you have any ideas what might be going on here?
Have you bound to an interface with 'interface'?
Could be you're picking up, say, a file transfer to your gateway.
You'd want to monitor your external interface, or filter out traffic to
Hi Paolo,
On Sat, 14 Mar 2009, Paolo Lucente wrote:
About the SQL INSERT conflict, are you by any chance making use of the
sql_dont_try_update directive in your configuration?
Yes I am, because it's much more efficient.
And are you using 32bit counters?
I think so, yes. I compiled with
Hi Karl,
On Sat, 14 Mar 2009, Karl O. Pinc wrote:
Sorry, what is an aggregate on sum_net? I'm aggregating on ip_src and
ip_dst respectively in two different plugins.
sum_net gets you a all the traffic to and from each network you list in
your networks file, plus to and from anywhere else.
Hi Karl,
On Sat, 14 Mar 2009, Chris Wilson wrote:
sum_net gets you a all the traffic to and from each network you list in
your networks file, plus to and from anywhere else. The cross product.
In your case, if you put only 192.168.0.0/24 in your networks file you
get out totals
Hi Paolo,
On Sat, 14 Mar 2009, Paolo Lucente wrote:
Any signs of massive packet drops on any port throughout your switches?
I ask because the traffic reported might not have been actually
delivered to the end host.
The switch has been up for 12.25 days, and in that time has recorded
Hi Johannes,
On Mon, 13 Apr 2009, Johannes Formann wrote:
Apr 13 15:27:15 server kernel: pmacctd[1341]: segfault at f7002991 ip
f7bfa9ca sp ffb88334 error 4 in
libpthread-2.3.6.so[f7bf2000+e000]
I think I got it (using a written coredump):
Yes, that's it, thanks. I'm
Hi Johannes,
On Mon, 13 Apr 2009, Johannes Formann wrote:
I'm not sure why flows is in your aggregate set since flows are
already aggregated into flows in all cases by pmacctd, as far as I
know (please correct me if I'm wrong).
flow isn't in the primary key.
I didn't say it was, but it
Hi Johannes,
On Mon, 13 Apr 2009, Johannes Formann wrote:
Paolo, this looks weird to me. pthread_getspecific() should not crash,
that makes me think that the heap has been trashed (stack looks
generally OK as the backtrace is OK). Perhaps a Valgrind is in order?
Any static or fixed-size
Hi Johannes,
On Mon, 13 Apr 2009, Johannes Formann wrote:
Apr 13 17:20:01 server1 pmacctd[12419]: ERROR ( default/mysql ):
Duplicate entry
'0-00:1b:8f:61:55:c9-00:1c:c0:ab:8a:48-0-91.22.172.35-84.38.74.24' for
key 1
As this crash is so early, perhaps the thread isn't initialised properly?
Hi Paolo,
On Sun, 19 Apr 2009, Karl O. Pinc wrote:
what makes sense to me is to collect timestamps in UTC, store them in
UTC when storing them in a database, and let whatever's pulling the data
out of the db present the data to the user in whatever fashion makes
sense. Any other approach,
Hi all,
Has anyone heard of Aguri?
Aguri is an aggregation-based traffic profiler targeted for near
real-time, long-term, and wide-area traffic monitoring. Aguri adapts
itself to spatial traffic distribution by aggregating small volume flows
into aggregates, and achieves temporal aggregation
Hi Paolo,
On Sat, 13 Jun 2009, Paolo Lucente wrote:
Good pointer. From a brief scan of the Aguri homepage, please feel free
to correct whether i'm wrong, i see many similarities between pmacct and
Aguri.
I guess so; I was thinking that Aguri seems to store its output in text
files rather
Hi Paolo,
On Sat, 13 Jun 2009, Paolo Lucente wrote:
minb = 1, zero_dstip, minb = 1, zero_dstport, minb = 1,
zero_srcport, minb = 1, zero_srcip
Then any flows which together do not add up to enough bytes to pass
the minb filters, even after aggregation, end up in a
Hi Paolo and Karl,
On Sat, 13 Jun 2009, Paolo Lucente wrote:
On Sat, Jun 13, 2009 at 03:07:01PM -0500, Karl O. Pinc wrote:
We are only interested in a single table.
Why can't two separate sql plugins write to the same table?
What Karl is proposing here might really result in a
Hi Paolo,
On Mon, 3 Aug 2009, Paolo Lucente wrote:
Didn't act on it yet, being focused on some new features. My goal is to
do something about it in 0.12.0rc2. Basically it would be a fix for who
doesn't use an UTC clock on the system running pmacct. If there is
general interest around
Hi JF,
On Thu, 12 Nov 2009, JF Cliche wrote:
I am behind two NAT routers (Linksys running DD-WRT) with port
forwarding up to the machine running pmacct, and yet pmacct reports SSH
traffic to the forwarded port with the public (external, non-NATed)
addresses. I thought all traffic should
Hi Paolo and Daniel,
(please allow me to jump in as I may be able to help here, despite
currently being in country working on a project.)
On Fri, 19 Feb 2010, Paolo Lucente wrote:
I also wonder: how does the primary key of the 1 min table look like? Is
it any different from the 1 hour
Hi Karl,
On Fri, 19 Feb 2010, Karl O. Pinc wrote:
On 02/19/2010 07:42:08 AM, Chris Wilson wrote:
I deleted the primary key from that table because it should not be
necessary (there should not be any duplicates if everything is
configured correctly) and it makes inserts extremely slow
Hi all,
We just had a bug report in pmGraph because it assumed that the source
port database column was called src_port always, as it is in MySQL. The
user is using a postgres database, and it appears that the column is
called port_src there instead:
if (!strcmp(config.type, mysql) ||
Hi Paolo,
On Tue, 14 Sep 2010, Paolo Lucente wrote:
Agree. I seem to reckon this legacy issue is limited to the TCP/UDP
ports only and i'm thinking perhaps the best way to approach it is to
issue a true/false config switch, ie. sql_table_compat, for the purpose.
But for consistency with
Hi Paolo,
On Wed, 15 Sep 2010, Paolo Lucente wrote:
On Tue, Sep 14, 2010 at 09:16:37AM +0200, Chris Wilson wrote:
I'm not sure about adding a new config switch, do we actually need it?
Funnily enough, and that was my perspective, in this case a configuration
switch only adds two
Hi Paolo,
On Wed, 6 Oct 2010, Paolo Lucente wrote:
To say this work (as agreed in the shape of sql table version 8) has
been just committed to the CVS. Please give it a try and let me know if
it seems to work to your eyes.
Thanks for this. I haven't compiled it yet, but I noticed this line:
Hi Paolo,
On Wed, 6 Oct 2010, Paolo Lucente wrote:
Yes, that's intended for a couple of reasons: 1) don't expect to release
any more table versions: you see that already happening with recently
introduced primitives; idea is to stick to a table version (or style
nowadays) and then customize
Hi Lockywolf,
On Thu, 11 Nov 2010, Lockywolf __ wrote:
aggregate[in]: dst_host
aggregate[out]: src_host
aggregate_filter[in]: dst net 192.168.88.0/16
aggregate_filter[out]: src net 192.168.88.0/16
plugins: mysql[in], mysql[out]
Still, in MySQL i have (a lot of) lines like the following:
|
Hi Bernd,
On Thu, 9 Jun 2011, Bernd Bornkessel wrote:
It works if I use:
vlan and ((vlan 365 or vlan 1337) and (dst net 192.76.141.0/24 or dst
net 194.55.246.0/23 or dst net 195.246.160/19 or dst net 88.215.224.0/19
or dst net 62.93.212.0/23 or dst net 62.93.246.0/23 or dst net
Hi Bernd,
On Thu, 9 Jun 2011, Bernd Bornkessel wrote:
The working filter is:
vlan and (dst net 192.76.141.0/24 or dst net 194.55.246.0/23 or dst net
195.246.160/19 or dst net 88.215.224.0/19 or dst net 62.93.212.0/23 or
dst net 62.93.246.0/23 or dst net 88.215.192.0/19)
The non-working
Hi Paolo,
On Mon, 28 Nov 2011, Paolo Lucente wrote:
Would be great if: 1) you can upgrade to something more recent than that,
ie. issue could be related to timestamps and fix might well be in some
other parts of the code (pkt_handlers.c pops to mind)
I will probably do this soon as I'm
Hi Johan,
On Thu, 2 Feb 2012, johan lotter wrote:
Yet when I configure and run with mysql plugin I get no data...
Does that mean that you get nothing in the database, or nothing graphed? I
notice that you mentioned pmgraph later, which is a different project
(that uses pmacct).
If you
Hi Johan, your nfacctd is compiled without mysql support, so it's not logging
to the database, only the memory plugin. Please fix that and try again. Cheers,
Chris.
-Original Message-
From: johan lotter jlct...@gmail.com
Sender: Chris Wilson ch...@aptivate.orgDate: Sun, 1 Apr 2012 16
Hi all,
We get many of these errors in our system logs:
Jun 12 10:01:01 fen-fw2 pmacctd[2153]: ERROR ( short/mysql ): Duplicate
entry '72.232.223.58-82.68.244.70-80-46802-tcp-2012-06-12 09:56:00' for
key 1
They usually happen in batches. E.g. we had a few hundred at 07:27, then
another few
Hi Paolo,
On Wed, 20 Jun 2012, Paolo Lucente wrote:
I'm thinking to the possibility that given the aggregation method the
SQL cache configured by default is not sufficient to keep all the
aggregates over the time period - although the time period is very
short. Can you as matter of test add
Hi Paolo,
On Fri, 29 Jun 2012, Paolo Lucente wrote:
On Tue, Jun 26, 2012 at 10:13:30AM +0100, Chris Wilson wrote:
OK, testing now. Would it be possible for pmacctd to log a warning if
it exceeds any of these thresholds, to help with tuning without wasting
memory?
In a way you reckon things
Hi Paolo,
On Wed, 18 Jul 2012, Paolo Lucente wrote:
On an unrelated note, how hard would it be to get the log message from
ULOG stored in the database, for example in the classification field? I
had a look through the code but I couldn't see any way to store this
field from the received
Hi Paolo,
Configure fails to find /usr/lib64/mysql/libmysqlclient.so on 64-bit
CentOS. You might want to add that to the list of search directories in
configure.in?
Cheers, Chris.
--
Aptivate | http://www.aptivate.org | Phone: +44 1223 967 838
Citylife House, Sturton Street, Cambridge, CB1
Hi Paolo,
On Tue, 25 Jun 2013, Paolo Lucente wrote:
Sure, thanks for the tip: makes sense, will do.
Also please find attached an RPM spec file to help build rpms for pmacct.
It would be great if you could include this in the tarball.
Cheers, Chris.
--
Aptivate | http://www.aptivate.org |
Hi all,
I tried to enable the sql_multi_values option, but setting it to a
reasonable number of rows to insert at once (100) to avoid hitting the
MySQL packet size limit. But I get these errors in the logs:
Sep 2 17:59:01 microserver pmacctd[17603]: ERROR ( summary/mysql ):
Hi Edward,
On Tue, 3 Sep 2013, Edward van Kuik wrote:
Sep 2 17:59:01 microserver pmacctd[17603]: ERROR ( summary/mysql ):
'sql_multi_values' is too small (100). Try with a larger value.
I set mine to 1000.
OK, so 1000 might work for you now. But it seems that pmacct can't split
the
On Tue, 3 Sep 2013, Edward van Kuik wrote:
No, it should definitely batch the data into inserts of 1000 values
each.
Then why would it give me this error message? The error doesn't make sense
if pmacct does break inserts into smaller batches.
Sep 2 17:59:01 microserver
Hi Paolo,
On Tue, 3 Sep 2013, Paolo Lucente wrote:
Maybe a bug in documentation in the release you are using? CONFIG-KEYS
says: The value of the directive is intended to be the size (in bytes)
of the multi-values buffer.. So 100 bytes is on the low side, and by
default MySQL comes with a 1MB
Hi all,
On Sat, 22 Mar 2014, Viacheslav Dubrovskyi wrote:
22.03.2014 21:20, Stathis Gkotsis пишет:
First, I would like to thank you for the great product, pmacct has
proven very useful to me, which brings me to my question :) I see that
it is possible to enable traffic classification, which
Hi Karl,
On Mon, 24 Mar 2014, Karl O. Pinc wrote:
On 03/24/2014 06:31:30 AM, Stathis Gkotsis wrote:
Concerning HTTP: I guess the thing to output would be hostname, since
you can have multiple HTTP requests to different URLs inside one TCP
Session.About DNS, what should be outputted? I guess
Hi Mike,
On Sat, 5 Apr 2014, Mike Hammett wrote:
The OfficialConfigKeys is very verbose and no doubt holds the key (no
pun intended) to every possible configuration, but all config examples
I've found seem drastically simplistic or seemingly incomplete.
Try this one:
daemonize: false
Hi Paolo,
On Tue, 3 Jun 2014, Paolo Lucente wrote:
What you describe for timestamps seems a good match for NetFlow, ie.
cast packets into flows and handle these via a flow-aware cache (so
active/passive expiration timers, max lifetime, etc.). All described is
already part of the nfprobe
58 matches
Mail list logo