Re: No Sensors Showing in Snorby

[Sharif Uddin <Sharif.Uddin () spectrumasa com>]

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!