[Snort-users] Barnyard2 MySQL DB Error
bill.bernsen at ...6823...
Thu Sep 11 15:09:11 EDT 2014
I assume that's right but I'm not a snorby user. Good luck!
On Wed, Sep 10, 2014 at 2:47 PM, Matt M. <mr10001 at ...11827...> wrote:
> 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
> 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 at ...6823...>
>> 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*
Bill Bernsen Network
ITS Technology Security Services, New York University
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Snort-users