Hi Sergio,
On Thu, Apr 29, 2010 at 11:23:35AM -0300, Sergio Charpinel Jr. wrote:
> Does anyone know what this mean? I getting a lot of them in pmacctd.log
> Expiring orphan fragment: ip_src=210.197.202.84 ip_dst=200.137.66.1 proto=17
> id=8885
It means some IP fragments have been staying too long into the pmacctd
fragment handler waiting for the missing pieces to come. If not in huge
amounts, this can be sympthom of white noise on the public internet
(scans, attacks, etc.).
> Regarding the topic, when using dynamic tables with postgreSQL, How can I
> verify if a table already exists before trying to create them, to avoid a
> lot of 'Table already exists' messages in nfacctd.log with dynamic table?
I'm not sure there is something already cooked to circumvent that. It
should be possible though with a few lines of PL/PGSQL, ie.:
IF EXISTS (SELECT relname FROM pg_class WHERE relname='<table>')
THEN
...
ELSE
...
ENDIF
The simplest way should be to get the table name as parameter and embed
the actual SQL table schema within the function declaration.
Cheers,
Paolo
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
