[Snort-users] postgresql

Bryan Irvine bryan.irvine at ...9066...
Thu Jul 3 08:47:18 EDT 2003


That did it.  I guess I've been bangin' my head on a wall for the wrong
reason. oh well, at least now I have updated apache/php.  It's off to go
fix the things I may have broken ;-)

--Bryan

On Thu, 2003-07-03 at 06:36, Jason K. Boykin wrote:
> 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-users at lists.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
> 





More information about the Snort-users mailing list