[Snort-users] Barnyard2 MySQL DB Error
mr10001 at ...11827...
Wed Sep 10 14:47:54 EDT 2014
Thanks for the tip! I think that did the trick.
I just tried using this create_mysql
I found, which was the same one, after bumping into this post
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
On Wed, Sep 10, 2014 at 1:39 PM, Bill Bernsen <bill.bernsen at ...6823...> 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
> On Wed, Sep 10, 2014 at 2:21 PM, Matt M. <mr10001 at ...11827...> wrote:
>> 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
>> 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.
>> Snort-users mailing list
>> Snort-users at lists.sourceforge.net
>> Go to this URL to change user options or unsubscribe:
>> Snort-users list archive:
>> 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
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*
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Snort-users