| 1 |
-----BEGIN PGP SIGNED MESSAGE----- |
| 2 |
Hash: SHA1 |
| 3 |
|
| 4 |
gentuxx wrote: |
| 5 |
|
| 6 |
> Hi All. |
| 7 |
> |
| 8 |
> After a fair amount of effort, I was able to finally get snort/BASE |
| 9 |
> working with postgresql. I followed the instructions at the wiki, |
| 10 |
> here: |
| 11 |
> http://gentoo-wiki.com/HOWTO_Setup_BASE_with_Apache%2C_Snort%2C_and_PostgreSQL |
| 12 |
> |
| 13 |
> I ran into a number of issues with the database, and it seems that |
| 14 |
> there are probably a few different issues relating to this. |
| 15 |
> |
| 16 |
> First of all, I got everything (that I was missing) installed fine as |
| 17 |
> instructed by the wiki-doc. I say everything that I was missing just |
| 18 |
> because I had apache2 and php working fine before hand. Anyhow, the |
| 19 |
> first indication that there was a problem was when I went to do the |
| 20 |
> base_db_setup.php. That seemed to go fine, but when I went to the |
| 21 |
> main page, I got all kinds of fun database errors. I remember, |
| 22 |
> vaguely, when I set up ACID on a FC3 system about a year ago (or |
| 23 |
> longer), that there was a database schema initialization script that |
| 24 |
> came with the snort source. I was using mysql at the time, but I |
| 25 |
> remember there being a postgresql script as well. Now, I was able to |
| 26 |
> solve THAT problem by downloading the snort source, finding the |
| 27 |
> appropriate script and running it through psql. But, then, I still |
| 28 |
> had permissions errors. So, I had to go through the whole process of |
| 29 |
> manually granting permissions to the right user for each table in the |
| 30 |
> snort database. (There was probably a better way to do that part, but |
| 31 |
> I'm not as familiar with PostgreSQL as I am with MySQL [not that I'm |
| 32 |
> familiar with MySQL]). |
| 33 |
> |
| 34 |
> So my question is this: Why aren't the database initialization script |
| 35 |
> in the ebuild? Wouldn't it be prudent to include them? |
| 36 |
> |
| 37 |
> I can edit the wiki to reflect the differences from my own experience, |
| 38 |
> but it seems that there should be a much more streamlined process. |
| 39 |
> That's part of the beauty of gentoo. |
| 40 |
> |
| 41 |
> Thoughts? Comments? Instructions on how to change the permissions on |
| 42 |
> all the tables in a database is PostgreSQL? ;-) |
| 43 |
> |
| 44 |
Looks like the wiki was just broke. When I went to edit it, most/all |
| 45 |
of the missing steps were in there, but they didn't show. Hopefully |
| 46 |
that's fixed now. ;-) |
| 47 |
|
| 48 |
- -- |
| 49 |
gentux |
| 50 |
echo "hfouvyAdpy/ofu" | perl -pe 's/(.)/chr(ord($1)-1)/ge' |
| 51 |
|
| 52 |
gentux's gpg fingerprint ==> 34CE 2E97 40C7 EF6E EC40 9795 2D81 924A |
| 53 |
6996 0993 |
| 54 |
-----BEGIN PGP SIGNATURE----- |
| 55 |
Version: GnuPG v1.4.1 (GNU/Linux) |
| 56 |
|
| 57 |
iD8DBQFDRuqILYGSSmmWCZMRAmXHAKCRBHLOdPF3exxQJ0blVUI1dxr1cwCfUHxP |
| 58 |
KORXJ+ToceqIuqPpT+9Sv5A= |
| 59 |
=O181 |
| 60 |
-----END PGP SIGNATURE----- |
| 61 |
|
| 62 |
-- |
| 63 |
gentoo-user@g.o mailing list |
Archives