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