Re: db schema
Nerijus Krukauskas
> 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.
OK, I got the app/config/database.php file. It contains the values I
entered in the setup screen. Yet the tables are created without prefix.
File contents:
<?php
class DATABASE_CONFIG
{
var $default = array('driver' => 'mysql',
'host' => '<sanitized>',
'login' => 'snort',
'password' => '<sanitized>',
'database' => 'snort_test',
'prefix' => 'sr');
}
?>
> What distro are you using? Did you follow the install guide?
Ubuntu 10.04LTS. Yes, I followed the install guide. The only difference is
SnortReport is not the DocumentRoot, but is configured like this:
Alias /sr /var/www/sr
<Directory /var/www/sr>
Order allow,deny
Allow from localhost 127.0.0.0/8 ::1 <sanitized_allowed_hosts>
Options All
AllowOverride AuthConfig FileInfo
</Directory>
BTW, there's a typo in the install guide. The line 'sudo chmod -R 775
/var/www/report' must read 'sudo chmod 775 -R /var/www/report'.
> On Jun 23, 2010, at 5:39 AM, Nerijus Krukauskas <nkruk...@gmail.com>
wrote:
>
>>
>>
>> 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.
>>
>>> On Jun 22, 2010, at 1:18 AM, Nerijus Krukauskas
<nkruk...@gmail.com> wrote:
>>>
>>>>
>>>>
>>>> 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?
>