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 FROM schema] , will retry

    I 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.