Waldo file question

[Ed Stoner]

Hi All,
What is stored in the Waldo File? We have two sets of log and an archive databases. Our barnyards write to all four at once. Today we updated the OS on one of the database servers so one set of log and archive databases were clean before we started letting the barnyards write to them. They appear to have differing sids. So how does barnyard keep track of each database and make sure it doesn't create duplicate sensors and such?

Thanks,
Ed

Sent from a mobile device.

[beenph]

On Thu, Jun 6, 2013 at 3:03 PM, Ed Stoner <snor...@gmail.com> wrote:
> Hi All,
> What is stored in the Waldo File?

Hi Ed, Multiples questions, multiple answers.

The issue described below has nothing to do with the waldo file.

The waldo file contain path to the log direction, information about
the unified2 file barnyard2 is processing (file name and last logged
record position)
so that on startup it can bookmark forward in the unified2 file to
continue processing.

> We have two sets of log and an archive databases. Our barnyards write to all four at once.
> Today we updated the OS on one of the database servers so one set of log and archive databases
> were clean before we started letting the barnyards write to them.
> They appear to have differing sids.
> So how does barnyard keep track of each database and make sure it doesn't create duplicate sensors and such?

If you would to reset your database to clean, and you would like to
keep sensor id, you should either:

1. Copy from a backup a previously used sensor table and update
last_cid column to 0
UPDATE sensor SET last_cid='0';

2. Or start your barnyard2 instances in the same order they created
them self previously.

A barnyard2 instance is identified by the following values :
barnyard2 configured hostname
barnyard2 configured interface
output database detail and encoding and bpf filter if any.

Hope this answer your question

-elz