hello, i am fairly new to freeBSD and sguil assisting my admins with this new NMS and having issues with my install. i am currently using barnyard ver. 0.2.0 and outputting to sguil 0.6.0. when i run barnyard, i get this error:
$ barnyard -c /usr/local/etc/nsm/barnyard.conf -d /nsm/sguilserver -g gen-msg.map -s sid-msg.map -f snort.log -w -waldo.file
Barnyard Version 0.2.0 (Build 32)
Opened spool file '/nsm/sguilserver/snort.log.1172110369'
Error (Table 'sguildb.event' doesn't exist) executing query: SELECT max(cid) FROM event WHERE sid='2'
Fatal Error, Quitting..
a check of the sql database confirms this. any ideas of what the issue might be? any help would be much appreciated. thank you