Re: BASE config problem - update

[Luis Torres <al1629608 () yahoo com>]

David,

Actually I jumped to conclusions and setting up a new IDS box I ran into the exact same problem... php-mysql is not 
really the problem here.

The problem is that on version 5 of php they disabled mysql support and ADODB relied on that to be on (I didn't go into 
much detail on the 'why'). If you are running "normal" PHP scripts that use the built in mysql functions then php-mysql 
gives you all that's needed.

So, long story short. You can compile your own version of PHP --with-mysql or you can just install PHP 4.3.9 or your 
favorite php4 binary.

I took the second option because my box is for use only by the IDS and my focus was on getting it up and running, not 
on building my own PHP binary... for now at least  =)

Good luck,

Luis

----- Original Message ----
From: "David.Ryan () Quintiles com" <David.Ryan () Quintiles com>
To: Luis Torres <al1629608 () yahoo com>
Cc: snort-users () lists sourceforge net
Sent: Tuesday, February 6, 2007 10:39:58 AM
Subject: Re: [Snort-users] BASE config problem - update



Luis,



Thanks for the reply.  I have been
away from the machine for a while and am only now getting to run these
commands.



php --version
->

PHP 5.1.6 (cli) (built: Nov  3
2006 07:27:53)

Copyright (c) 1997-2006 The PHP Group

Zend Engine v2.1.0, Copyright (c) 1998-2006
Zend Technologies



rpm -qa | grep -i mysql
->

mysql-5.0.27-1.fc5

mysql-server-5.0.27-1.fc5

perl-DBD-MySQL-3.0007-1.fc5

php-mysql-5.1.6-1.2

snort-mysql+flexresp-2.6.1.1-4.fc5



The output of phpinfo( ) includes the
following. I guess the '- -without-mysql' is the main problem - 

"


magic' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml'
'--with-apxs2=/usr/sbin/apxs'  --without-mysql' '--without-gd' '--without-odbc'
'--disable-dom' '--disable-dba' '--without-unixODBC' '--disable-pdo' '--disable-xmlreader

"



Based on your mail it looks like I'm
not going anywhere until I get mysql support added/included to my php install.
 I originally didn't have php-mysql installed, but I added it before
running the rom query above.  I retried the setup script, but unfortunately
I still get the same errors.



Any other suggestions ?



Thanks,



David

=================================

David Ryan

IT Security Engineer, Global IT Security

Quintiles SIS, QDUB



david.ryan () quintiles com

=================================








Luis Torres <al1629608 () yahoo com>

29/01/2007 14:55





To

David.Ryan () Quintiles com,
snort-users () lists sourceforge net


cc





Subject

Re: [Snort-users] BASE config
problem - update















Hi,



the PHP interpreter generates the errors you see on apache's error_log.
The error is saying your php can't find the mysql_pconnect function so:



1. What version of php do you have? (use php --version)

2. Is it compiled with php support or have php-mysql? (create a script
only with phpinfo() inside and/or run rpm -qa | grep -i mysql if you're
on an rpm based system)

3. what happens if you create a little script just to open a connection
to mysql? does it work? (just call mysql_pconnect, then close)



Good luck



Luis



----- Original Message ----

From: "David.Ryan () Quintiles com" <David.Ryan () Quintiles com>

To: snort-users () lists sourceforge net

Sent: Friday, January 26, 2007 11:12:15 AM

Subject: [Snort-users] BASE config problem - update





Sorry, shortly after posting to the list I did some further research and
found this in the error_log for Apache - 

'PHP Fatal error:  Call to undefined function mysql_pconnect() in
/var/www/html/adodb/drivers/adodb-mysql.inc.php on line 376'




This line is repeated for multiple attempts so I guess this is part of
the problem. 



Any suggestions ?  I am connecting to a mysql database, but it looks
like it is the function calll itself that is the problem rather than the
connection itself. 



Thanks, 



David 

=================================

David Ryan

IT Security Engineer, Global IT Security

Quintiles SIS, QDUB

**********************  IMPORTANT--PLEASE READ  ************************
This electronic message, including its attachments, is COMPANY CONFIDENTIAL
and may contain PROPRIETARY or LEGALLY PRIVILEGED information.  If you are 
not the intended recipient, you are hereby notified that any use, disclosure,
copying, or distribution of this message or any of the information included
in it is unauthorized and strictly prohibited.  If you have received this
message in error, please immediately notify the sender by reply e-mail and
permanently delete this message and its attachments, along with any copies
thereof. If this electronic message contains a zipped attachment and you do
not have a decompression tool, you may download unZIP (free of cost) from:
http://www.mk-net-work.com/us/uz/unzip.htm. Alternatively, you may request
that the attachment be resent in an uncompressed format.        Thank you. 
************************************************************************







 
____________________________________________________________________________________
Now that's room service!  Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
Snort-users mailing list
Snort-users () 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