[Snort-users] Barnyard2 MySQL DB Error

Bill Bernsen bill.bernsen at ...6823...
Wed Sep 10 14:39:17 EDT 2014

Hi Matt,

Did you apply the appropriate database schema found in the schema folder in
barnyard2's source?


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



On Wed, Sep 10, 2014 at 2:21 PM, Matt M. <mr10001 at ...11827...> 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 at ...274...;
> 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.
> --
> *“*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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.snort.org/pipermail/snort-users/attachments/20140910/981d630f/attachment.html>

More information about the Snort-users mailing list