Re: Barnyard2 MySQL DB Error

[Bill Bernsen <bill.bernsen () nyu edu>]

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

------------------------------------------------------------------------------
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!