Maybe an INSERT trigger on the MySQL table can be used to track the database user used by the pmacct instances in order to populate an additional field? A one-to-one mapping between instances and db users could identify the pmacct instance that inserted the record.
Should be tested... -- Pier Carlo Il 21/Ago/2017 17:23, "fboehm" <fbo...@aon.at> ha scritto: > 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