Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    SQL DB for Barnyard 2 - Failed to execute query [SELECT vseq FROM `schema`]

    Scheduled Pinned Locked Moved IDS/IPS
    3 Posts 2 Posters 1.1k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • brezlordB
      brezlord
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • brezlordB
        brezlord
        last edited by

        All good. I restarted the appliance and it's now working.

        1 Reply Last reply Reply Quote 0
        • R
          rickyzhang
          last edited by

          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.

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.