-----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