Hi Paolo,
--- On Sat, 5/9/09, Paolo Lucente <pa...@pmacct.net> wrote:
> >
> > If I comment out the sql_preprocess line then the
> > config works and I get correct data being put into my SQL
> > table. When I add the preprocess line I get nothing being
> > put into my table. Am I mis-understanding how to use this
> > option ?
>
> The sql_preprocess directive supports both checks and actions;
> a SQL entry must successfully pass a check in order to undergo
> one of the available actions (adjb being one of those). In your
> case you want a dummy check (ie. minp=1) to be put on the stack
> in order for the action to be evaluated against every SQL entry
> being committed to the database, ie.
>
It wasn't obvious to me from the documentation that this was required. The only
documentation I could find on the "sql_preprocess" command was the reference to
it in the FAQ (for what I am trying to do) and the reference in the list of
config keys, which says the following about sql_preprocess:
======
allows to process aggregates (via a comma-separated list of conditionals and
checks) while purging data to the RDBMS thus resulting in a powerful selection
tier
======
This wasn't obvious to me that it REQUIRED a check to perform an action, just
that you could do both check conditions and actions. Most of the other actions
might make more sense if you had some kind of check on them, but I didn't
really look at them, I only looked at the one I wanted, which I need to apply
to every DB write, not selectively.
> sql_preprocess[abc]: minp=1, adjb=26
>
> Can you give this a try? Perhaps this underlying mechanism is
> not properly documented; it could be the trigger to change the
> way it works: if no checks are specified, then evaluate the
> specified action(s) against the entire queue of committed SQL
> entries.
>
I have tested the above suggested configuration and it is working. There is
data going into the SQL table now! I am going to let it run in parallel with
the unadjusted data (which is going into another table) and then compare the
two of them and also compare to the stats being reported by the packeteer.
Thanks for your assistance, I'll report back in a week/month or two with the
results of the testing with adjusted data.
regards,
Tony.
__________________________________________________________________________________
Get more done like never before with Yahoo!7 Mail.
Learn more: http://au.overview.mail.yahoo.com/
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
