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