[Snort-users] No Sensors Showing in Snorby

Sharif Uddin Sharif.Uddin at ...16962...
Fri Sep 12 05:32:47 EDT 2014


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 at ...14940...]
Sent: 11 September 2014 21:15
To: snort-users at 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 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!

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.




More information about the Snort-users mailing list