Snort mailing list archives

Re: No Sensors Showing in Snorby


From: "Matt M." <mr10001 () gmail com>
Date: Fri, 12 Sep 2014 14:04:59 -0500

Almost forgot, thank you! =)

On Fri, Sep 12, 2014 at 2:00 PM, Matt M. <mr10001 () gmail com> wrote:

Oh snap! It's working... at least it appears to be.  Now to test it out.

Wewt!  =)

On Fri, Sep 12, 2014 at 4:37 AM, Sharif Uddin <
Sharif.Uddin () spectrumasa com> wrote:

I forgot to mention


To set up the db and schema using snorby

Cd /var/www/html/snorby-2.6.2/
bundle exec rake snorby:setup #will set everything up

-----Original Message-----
From: Sharif Uddin [mailto:Sharif.Uddin () spectrumasa com]
Sent: 12 September 2014 10:33
To: waldo kitty; snort-users () lists sourceforge net
Subject: Re: [Snort-users] No Sensors Showing in Snorby

Set up barnyard2 and snorby to use the same database.

see config files


/etc/snort/barnyard2.conf

output database: log, mysql, user=root password=support dbname=snorby
host=127.0.0.1



/var/www/html/snorby-2.6.2/config/database.yml
snorby: &snorby
  adapter: mysql
  username: root
  password: "support" # Example: password: "s3cr3tsauce"
  host: localhost

development:
  database: snorby
  <<: *snorby

test:
  database: snorby
  <<: *snorby

production:
  database: snorby
  <<: *snorby





Do not create database, start mysql, then start snorby

        Cd /var/www/html/snorby-2.6.2/
        bundle exec rails server -e production -d

This will create database and schema





-----Original Message-----
From: waldo kitty [mailto:wkitty42 () windstream net]
Sent: 11 September 2014 21:15
To: snort-users () lists sourceforge net
Subject: Re: [Snort-users] No Sensors Showing in Snorby

On 9/11/2014 1:23 PM, Matt M. wrote:
*are barnyard and snorby both using the same database?*

This is a good question!  I know barnyard is configured to use the db
I setup "snort".  However, I just realized my snorby database.yml was
not configured correctly.  I did not have it pointing to the snort db.

I just corrected this and now I received this error:

DataObjects::SyntaxError (Table 'snort.users' doesn't exist):

   app/controllers/application_controller.rb:37:in `user_setup'

I checked the database and it does have a number of tables setup, but
I do not see snort.users.  I Googled and found someone suggesting to
run rake snorby:setup  but running that I get an error saying that the
snort database already exists. =).  Is there an easy way to add the
necessary table?  Can I just add an empty snort.users table... I have
a feeling it would not be that easy.  Should I just blow away the
database?  I did run: create_mysql <
https://github.com/eldondev/Snort/blob/master/schemas/create_mysql>
previously.


i'll have to let someone else step in at this point and assist further...
i'm glad that i was able to point you in the proper direction though :)

--
  NOTE: No off-list assistance is given without prior approval.
        Please *keep mailing list traffic on the list* unless
        private contact is specifically requested and granted.


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

IMPORTANT - This message and any attached files contain information
intended for the exclusive use of the party or parties to whom it is
addressed and may contain information that is proprietary, privileged,
confidential and/or exempt from disclosure under applicable law. If you are
not an intended recipient, you are hereby notified that any viewing,
copying, disclosure or distribution of this information may be subject to
legal restriction or sanction. Please notify the sender immediately and
delete the original message without making any copies. Copyright in this
email and any attachments belong to Spectrum Geo Limited.
We cannot guarantee the security or confidentiality of email
communications. We do not accept any liability for losses or damages that
you may suffer as a result of your receipt of this email.
Email communication with Spectrum Geo Ltd., may be monitored as permitted
by UK legislation.
Spectrum Geo Limited, is a limited company registered in England and
Wales. Registered number: 1979422. Registered office: 95 Aldwych, London
WC2B 4JF.


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

IMPORTANT - This message and any attached files contain information
intended for the exclusive use of the party or parties to whom it is
addressed and may contain information that is proprietary, privileged,
confidential and/or exempt from disclosure under applicable law. If you are
not an intended recipient, you are hereby notified that any viewing,
copying, disclosure or distribution of this information may be subject to
legal restriction or sanction. Please notify the sender immediately and
delete the original message without making any copies. Copyright in this
email and any attachments belong to Spectrum Geo Limited.
We cannot guarantee the security or confidentiality of email
communications. We do not accept any liability for losses or damages that
you may suffer as a result of your receipt of this email.
Email communication with Spectrum Geo Ltd., may be monitored as permitted
by UK legislation.
Spectrum Geo Limited, is a limited company registered in England and
Wales. Registered number: 1979422. Registered office: 95 Aldwych, London
WC2B 4JF.


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




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




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

Current thread: