SQL DB for Barnyard 2 - Failed to execute query [SELECT vseq FROM `schema`]
-
Hi All,
I have setup a SQL DB for Barnyard 2 which is used by Snort. Everything seems to be working but my system log is filled with the following errors.Oct 15 15:10:31 barnyard2 9303 [Select()]: Failed to execute query [SELECT vseq FROM
schema
] , will retry
Oct 15 15:10:31 barnyard2 81709 [Select()]: Failed to execute query [SELECT vseq FROMschema
] , will retryI used the following cmds to create the DB schema.
mysql -u root -p
create database snort;
use snort;
source /tmp/create_mysql
CREATE USER 'snort'@'localhost' IDENTIFIED BY 'MYPASSWORD';
grant create, insert, select, delete, update on snort.* to snort@localhost;
exit;All other tables of the db are being updated by snort just not vseq in schema.
Any help will be greatly appreciated.
EDIT
I found this bug file https://redmine.pfsense.org/issues/5133
Kind Regards,
Simon -
All good. I restarted the appliance and it's now working.
-
I was bitten by this bug as well: https://forum.netgate.com/topic/145455/barnyard2-can-t-connect-to-remote-mysql
What database do you use? Maria DB or MySQL? I tried both in my Fedora box (outside of pfsense). They both failed.