OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: [Snort-users] postgresql

From: Jason K. Boykin (jboykinsummit-research-corp.com)
Date: Thu Jul 03 2003 - 08:36:23 CDT


On Wednesday 02 July 2003 06:34 pm, Bryan Irvine wrote:
> I'm getting close. I've been trying and trying to get ACID running.
>
> I keep getting this:
> PHP ERROR: PHP build incomplete: the prerequisite PostgreSQL support
> required to read the alert database was not built into PHP. Please
> recompile PHP with the necessary library (--with-pgsql)
>
> Which I have done according to the php install instructions. I've even
> uninstalled apache and php and did it again via urpmi with php-pgsql.
>
> Any ideas?
>
> --Bryan

I dont remember much about when I built PHP (its too early in the morn!) so
Ill go through the acid_conf.php because Im bored.

Make sure you have adodb installed in a place your apache server can access
it. I have mine right in my www directory.
$DBlib_path = "/blah/blah/blah/www/adodb";

Self explanitory.
$DBtype = "postgres";

$alert_dbname = "snort"; <--self explanitory
$alert_host = "localhost"; <--ip of your postgres server
$alert_port = ""; <--would not work for me unless I left this part blank
$alert_user = "snort"; <--user you use to read/write to the database
$alert_password = "xxx"; <---password to the snort database you created

/* Use referential integrity
 * 1 : use
 * 0 : ignore (not installed)
 *
 * Note: Only PostgreSQL and MS-SQL Server databases support
 * referential integrity. Use the associated
 * create_acid_tbls_?_extra.sql script to add this
 * functionality to the database.
 *
 * Referential integrity will greatly improve the
 * speed of record deletion, but also slow record
 * insertion.
 */
$use_referential_integrity = 1; <--I turned it on...

I believe jpgraph really needs to be under your htdocs/www/what ever
directory. You either need to move the contents of the src directory to the
previous one or point acid to the src directory.
$ChartLib_path = "/blah/blah/blah/www/jpgraph/src";

Lemme know if this doesnt help and Ill scrounge up my php --with-postgres
stuffs or what ever it was I did.

-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
_______________________________________________
Snort-users mailing list
Snort-userslists.sourceforge.net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users