Search the Community

Hi, I tried to set up Snort by following the instruction on However when I try to verify the Barnyard2 configuration by running d:\winids\activators\by2-test , I saw the following error in postgres log file: 2016-06-24 16:21:57 EDT LOG: statement: SELECT `ref_system_id`, ref_system_name FROM reference_system; 2016-06-24 16:21:57 EDT DEBUG: reaping dead processes 2016-06-24 16:21:57 EDT DEBUG: server process (PID 804) exited with exit code 0 2016-06-24 16:21:57 EDT DEBUG: attempting to remove WAL segments older than log file 000000000000000000000000 2016-06-24 16:21:57 EDT DEBUG: SlruScanDirectory invoking callback on pg_subtrans/0000 2016-06-24 16:21:57 EDT ERROR: operator does not exist: ` integer at character 8 2016-06-24 16:21:57 EDT HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. 2016-06-24 16:21:57 EDT STATEMENT: SELECT `ref_system_id`, ref_system_name FROM reference_system; 2016-06-24 16:21:57 EDT DEBUG: forked new backend, pid=4056 socket=1320 2016-06-24 16:21:57 EDT DEBUG: postgres child[4056]: starting with ( 2016-06-24 16:21:57 EDT DEBUG: postgres 2016-06-24 16:21:57 EDT DEBUG: ) 2016-06-24 16:21:57 EDT DEBUG: InitPostgres 2016-06-24 16:21:57 EDT DEBUG: my backend ID is 3 2016-06-24 16:21:57 EDT DEBUG: StartTransaction 2016-06-24 16:21:57 EDT DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 2016-06-24 16:21:57 EDT DEBUG: shmem_exit(0): 1 before_shmem_exit callbacks to make It looks like it's expecting a column called " `ref_system_id` " in the table reference_system, while the column is just "ref_system_id" based on the script in D:\winids\barnyard2\schemas\create_postgres. Can you please advise what could have gone wrong here? Thanks, Sally