db schema

8 views
Skip to first unread message

Nerijus Krukauskas

unread,
Jun 19, 2010, 6:35:39 AM6/19/10
to snortreport-users
I see that SnortReport 2 is using db for its own data. It would be
nice if SnortReport tables could be put in a separate db. That way I
can use more than one tool for the same snort data set. Developers of
that other tool will also be asked for this feature. :)

Thomas Rader

unread,
Jun 19, 2010, 7:21:25 AM6/19/10
to snortrep...@googlegroups.com
Hello,

You are more than welcome to use the "table prefix" when doing the
installation to avoid potential name conflicts.

If you wish to do this manually, you will need to modify the file "./
app/config/database.php". You can find documentation for CakePHP
config files at http://book.cakephp.org

We followed the model that ACID and BASE took, by installing the
tables to the core db, to keep things contained.

Thanks,
Tom

On Jun 19, 2010, at 4:35 AM, Nerijus Krukauskas

Nerijus Krukauskas

unread,
Jun 22, 2010, 3:18:20 AM6/22/10
to snortreport-users


Thomas Rader wrote:
> Hello,
>
> You are more than welcome to use the "table prefix" when doing the
> installation to avoid potential name conflicts.

This "table prefix" is used for snort tables not snortreport, right?
Or
did I misunderstood the snortreport setup page?

Thomas Rader

unread,
Jun 22, 2010, 8:14:14 AM6/22/10
to snortrep...@googlegroups.com, snortreport-users
The table prefix applies to the Snort Report application. It will prefix all related tables created by Snort Report install and will add the instruction to the config for later CRUD operations.

Sent from my iPhone

Nerijus Krukauskas

unread,
Jun 19, 2010, 7:46:49 AM6/19/10
to snortrep...@googlegroups.com

On Sat, June 19, 2010 14:21, Thomas Rader wrote:
> Hello,
>
> You are more than welcome to use the "table prefix" when doing the
> installation to avoid potential name conflicts.

This "table prefix" is used for snort tables not snortreport, right? Or


did I misunderstood the snortreport setup page?

--
http://nk99.org/

Nerijus Krukauskas

unread,
Jun 23, 2010, 7:39:16 AM6/23/10
to snortreport-users


Thomas Rader wrote:
> The table prefix applies to the Snort Report application. It will prefix all related tables created by Snort Report install and will add the instruction to the config for later CRUD operations.

I did enter the Prefix in setup page, but seems that snortpreport is
not using it. The tables in database are created w/o prefix.
Oh, and the file app/config/database.php you've mentioned before does
not exist.

Thomas Rader

unread,
Jun 23, 2010, 10:12:57 AM6/23/10
to snortrep...@googlegroups.com, snortreport-users
Are you making it all the way through the install process? The database.php file is created directly after the step of entering your connection information. If the file is not there you most likely have a permissions problem.

What distro are you using? Did you follow the install guide?

Sent from my iPhone

Reply all
Reply to author
Forward
0 new messages