[gentoo-user] Snort/BASE/PostgreSQL Config

[gentoo-user] Snort/BASE/PostgreSQL Config

[gentuxx]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi All.

After a fair amount of effort, I was able to finally get snort/BASE
working with postgresql.  I followed the instructions at the wiki,
here:
http://gentoo-wiki.com/HOWTO_Setup_BASE_with_Apache%2C_Snort%2C_and_PostgreSQL

I ran into a number of issues with the database, and it seems that
there are probably a few different issues relating to this.

First of all, I got everything (that I was missing) installed fine as
instructed by the wiki-doc.  I say everything that I was missing just
because I had apache2 and php working fine before hand.  Anyhow, the
first indication that there was a problem was when I went to do the
base_db_setup.php.  That seemed to go fine, but when I went to the
main page, I got all kinds of fun database errors.  I remember,
vaguely, when I set up ACID on a FC3 system about a year ago (or
longer), that there was a database schema initialization script that
came with the snort source.  I was using mysql at the time, but I
remember there being a postgresql script as well.  Now, I was able to
solve THAT problem by downloading the snort source, finding the
appropriate script and running it through psql.  But, then, I still
had permissions errors.  So, I had to go through the whole process of
manually granting permissions to the right user for each table in the
snort database.  (There was probably a better way to do that part, but
I'm not as familiar with PostgreSQL as I am with MySQL [not that I'm
familiar with MySQL]).

So my question is this: Why aren't the database initialization script
in the ebuild?  Wouldn't it be prudent to include them?

I can edit the wiki to reflect the differences from my own experience,
but it seems that there should be a much more streamlined process.
That's part of the beauty of gentoo.

Thoughts?  Comments?  Instructions on how to change the permissions on
all the tables in a database is PostgreSQL?  ;-)

- --
gentux
echo "hfouvyAdpy/ofu" | perl -pe 's/(.)/chr(ord($1)-1)/ge'

gentux's gpg fingerprint ==> 34CE 2E97 40C7 EF6E EC40  9795 2D81 924A
6996 0993
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDRuO/LYGSSmmWCZMRAqWXAKCQxV+yx9CQUc6F11iF78BdHDnT5QCg56eN
Hs0609vqd1fJ1soVxWK/PUY=
=OIR5
-----END PGP SIGNATURE-----

-- 
gentoo-user@gentoo.org mailing list

[gentoo-user] RECALL: Snort/BASE/PostgreSQL Config

[gentuxx]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

gentuxx wrote:

> Hi All.
>
> After a fair amount of effort, I was able to finally get snort/BASE
> working with postgresql. I followed the instructions at the wiki,
> here:
> http://gentoo-wiki.com/HOWTO_Setup_BASE_with_Apache%2C_Snort%2C_and_PostgreSQL
>
> I ran into a number of issues with the database, and it seems that
> there are probably a few different issues relating to this.
>
> First of all, I got everything (that I was missing) installed fine as
> instructed by the wiki-doc. I say everything that I was missing just
> because I had apache2 and php working fine before hand. Anyhow, the
> first indication that there was a problem was when I went to do the
> base_db_setup.php. That seemed to go fine, but when I went to the
> main page, I got all kinds of fun database errors. I remember,
> vaguely, when I set up ACID on a FC3 system about a year ago (or
> longer), that there was a database schema initialization script that
> came with the snort source. I was using mysql at the time, but I
> remember there being a postgresql script as well. Now, I was able to
> solve THAT problem by downloading the snort source, finding the
> appropriate script and running it through psql. But, then, I still
> had permissions errors. So, I had to go through the whole process of
> manually granting permissions to the right user for each table in the
> snort database. (There was probably a better way to do that part, but
> I'm not as familiar with PostgreSQL as I am with MySQL [not that I'm
> familiar with MySQL]).
>
> So my question is this: Why aren't the database initialization script
> in the ebuild? Wouldn't it be prudent to include them?
>
> I can edit the wiki to reflect the differences from my own experience,
> but it seems that there should be a much more streamlined process.
> That's part of the beauty of gentoo.
>
> Thoughts? Comments? Instructions on how to change the permissions on
> all the tables in a database is PostgreSQL? ;-)
>
Looks like the wiki was just broke.  When I went to edit it, most/all
of the missing steps were in there, but they didn't show.  Hopefully
that's fixed now.  ;-)

- --
gentux
echo "hfouvyAdpy/ofu" | perl -pe 's/(.)/chr(ord($1)-1)/ge'

gentux's gpg fingerprint ==> 34CE 2E97 40C7 EF6E EC40  9795 2D81 924A
6996 0993
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDRuqILYGSSmmWCZMRAmXHAKCRBHLOdPF3exxQJ0blVUI1dxr1cwCfUHxP
KORXJ+ToceqIuqPpT+9Sv5A=
=O181
-----END PGP SIGNATURE-----

-- 
gentoo-user@gentoo.org mailing list