MYSQL error even though I used --with-mysql

["William Fitzgerald" <wfitzgerald () tssg org>]

Hi all,

I am getting error
database: compiled support for ( )
database: configured to use mysql
database: 'mysql' support is not compiled into this build of snort

BUT I configured the snort version 2.1.1 as follows:
./configure --prefix=/opt/snort --with-mysql  --enable-wireless
make
make install

I then start mysql which i have aready installed the snort database tables.

I then run snort as follows:
/opt/snort/bin/snort -c /opt/snort/etc/snort.conf -i ath0
and I get the above error.

in a book called "intrusion detection systems with snort" by Rafeeq Ur
Rehman it is stated inorder to support mysql you need to configure as
follows:
./configure --prefix=/opt/snort --with-mysql=/usr/include/mysql (chaper 4
page 151)
his book uses --with-mysql=/usr/lib/mysql but on this debian release the
files are in include directory.

however when I pass this command in the config log shows:
checking for mysql... No
but if i just use the
/configure --prefix=/opt/snort --with-mysql  --enable-wireless command
(chapter 2 page 34)
then support is built in.
checking for mysql... Yes

has anyone out there got any ideas?

additional info: i installed mysql in /usr/local/mysql
i ran apt-get install libmysqlclient12-dev from within the /usr/lib
directory
and the mysql.h file is stored in /usr/include/mysql
mysql version is: mysql-standard-4.1.9-pc-linux-gnu-i686

regards,
Will.


William M. Fitzgerald (MSc,BSc),
Applied Researcher,
Telecommunications Software & Systems Group,
Waterford Institute of Technology,
Cork Rd.
Waterford.
Office Ph: +353 51 302937
Mobile Ph: +353 87 9527083




-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
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