Hello
Once again Paolo you were a great help.
Thank you for best support ever!!!
Now i can move and finalise,all php+mysql stuff for my users.
Peter
PL> Hello Peter,
>>From what i'm able to see, the problem it's in your pmacct configuration.
PL> On Wed, Mar 16, 2005 at 09:13:30PM +0100, Pajlatek wrote:
PL> [ ... ]
>> aggregate: src_host,dst_host
>> plugins: mysql[in], mysql[out]
>> sql_db: bwstat
>> sql_table: acct
PL> [ ... ]
PL> Here you instantiate two plugins, 'in' and 'out', with the 'plugins'
directive.
PL> The subsequent directives ('sql_db', 'sql_table', etc.) apply to all active
PL> plugins (that is, they are global).
PL> This causes both MySQL plugins to write the same table, thus accounting data
PL> twice. The correct configuration should resemble something as follows:
PL> plugins: mysql[in], mysql[out]
PL> sql_db: bwstat
PL> aggregate[in]: dst_host
PL> aggregate[out]: src_host
PL> sql_table[in]: acct_in
PL> sql_table[out]: acct_out
PL> aggregate_filter[in]: <a nice BPF filter: matches traffic to your networks>
PL> aggregate_filter[out]: <another nice BPF filter: matches traffic from your
networks>
PL> The database is common for both plugins; then you use two different tables
to
PL> account, e.g. incoming vs. outcoming, data for your networks. For filtering
PL> purposes you use the 'aggregate_filter' directives, thus you should need no
PL> more the 'networks_file' one.
PL> The remaining directives may continue to be global.
PL> Cheers,
PL> Paolo
PL> _______________________________________________
PL> pmacct-discussion mailing list
PL> [email protected]
PL> http://muffin.area.ba.cnr.it/mailman/listinfo/pmacct-discussion
--
Best regards,
Pajlatek mailto:[EMAIL PROTECTED]
