[Snort-users] Barnyard2 MySQL DB Error

Bill Bernsen 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:

> 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 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
>> structure.
>>
>> Cheers,
>>
>> Bill
>>
>> 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.
>>> --
>>> 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 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
>> 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*
>



-- 
Bill Bernsen                                                    Network
Security Analyst
ITS Technology Security Services, New York University
http://www.nyu.edu/its/security
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.snort.org/pipermail/snort-users/attachments/20140911/eb4f2d2d/attachment.html>


More information about the Snort-users mailing list