Snort mailing list archives
Re: Barnyard2 MySQL DB Error
From: "Matt M." <mr10001 () gmail com>
Date: Wed, 10 Sep 2014 13:47:54 -0500
Bill, Thanks for the tip! I think that did the trick. I just tried using this create_mysql <https://github.com/eldondev/Snort/blob/master/schemas/create_mysql> script I found, which was the same one, after bumping into this post <http://www.andrew.cmu.edu/user/rdanyliw/snort/snortdb/snortdb_install.html> . Now, the question is... To get Snorby running correctly, do I need to do the following in this order? 1. Start the mysql service/daemon 2. Start snort 3. Start barnyard 4. Start snorby Thanks again! On Wed, Sep 10, 2014 at 1:39 PM, Bill Bernsen <bill.bernsen () nyu edu> wrote:
Hi Matt, Did you apply the appropriate database schema found in the schema folder in barnyard2's source? CREATE DATABASE snort; Only creates an empty database named snort, you then need to apply the db application appropriate schema to the database to set up the table structure. Cheers, Bill On Wed, Sep 10, 2014 at 2:21 PM, Matt M. <mr10001 () gmail com> wrote:Hello, Just ran into an error that I cannot seem to resolve and wondering if anyone has any ideas. *Ran*: /usr/local/bin/barnyard2 -c /usr/local/etc/barnyard2.conf -d /private/var/log/snort -f snort.log *ERROR: *[Select()]: Failed to execute query [SELECT vseq FROM `schema`] , will retry Attempted to do the following... mysql> GRANT SELECT ON snort.schema TO snorby@localhost; ERROR 1146 (42S02): Table 'snort.schema' doesn't exist Could this be an indication that my snort database was not setup correctly? iirc the database was setup by running "CREATE DATABASE snort;" Appreciate any ideas on this one. -- M., CISSP, GCFE, GCFA *“*To disagree leads to study, to study leads to understanding, to understand is to appreciate, to appreciate is to love. So maybe I’ll end up loving your theory.*”* -*John Wheeler* ------------------------------------------------------------------------------ Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://sourceforge.net/mailarchive/forum.php?forum_name=snort-users Please visit http://blog.snort.org to stay current on all the latest Snort news!-- Bill Bernsen Network Security Analyst ITS Technology Security Services, New York University http://www.nyu.edu/its/security
-- Matt M., CISSP, GCFE, GCFA *“*To disagree leads to study, to study leads to understanding, to understand is to appreciate, to appreciate is to love. So maybe I’ll end up loving your theory.*”* -*John Wheeler*
------------------------------------------------------------------------------ Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://sourceforge.net/mailarchive/forum.php?forum_name=snort-users Please visit http://blog.snort.org to stay current on all the latest Snort news!
Current thread:
- Barnyard2 MySQL DB Error Matt M. (Sep 10)
- Re: Barnyard2 MySQL DB Error Bill Bernsen (Sep 10)
- Re: Barnyard2 MySQL DB Error Matt M. (Sep 10)
- Re: Barnyard2 MySQL DB Error Bill Bernsen (Sep 11)
- Re: Barnyard2 MySQL DB Error Sharif Uddin (Sep 12)
- Re: Barnyard2 MySQL DB Error Matt M. (Sep 12)
- Re: Barnyard2 MySQL DB Error Matt M. (Sep 10)
- Re: Barnyard2 MySQL DB Error Bill Bernsen (Sep 10)