HELP!!!!! Compiling Snort with MYSQL

[dlambeth () starmountain com]

I am using gentoo and tried emerging SNORT but it will not work with MYSQL.
I unmerged SNORT and downloaded a newer version of snort and compiled it
--with-mysql=/usr/lib/mysql but when I try to start snort I get the
following message:

Jan  6 09:26:41 ids snort: rpc_decode arguments:
Jan  6 09:26:41 ids snort:     Ports to decode RPC on: 111 32771
Jan  6 09:26:41 ids snort:     alert_fragments: INACTIVE
Jan  6 09:26:41 ids snort:     alert_large_fragments: ACTIVE
Jan  6 09:26:41 ids snort:     alert_incomplete: ACTIVE
Jan  6 09:26:41 ids snort:     alert_multiple_requests: ACTIVE
Jan  6 09:26:41 ids snort: telnet_decode arguments:
Jan  6 09:26:41 ids snort:     Ports to decode telnet on: 21 23 25 119
Jan  6 09:26:41 ids snort: database: 'mssql' support is not compiled into
this build of snort
Jan  6 09:26:41 ids snort: FATAL ERROR: If this build of snort was obtained
as a binary distribution (e.g., rpm, or Windows), then check for alternate
builds that contains the necessary 'mssql' support.  If this build of snort
was compiled by you, then re-run the the ./configure script using the
'--with-mssql' switch. For non-standard installations of a database, the
'--with-mssql=DIR' syntax may need to be used to specify the base directory
of the DB install.  See the database documentation for cursory details
(doc/README.database). and the URL to the most recent database plugin
documentation.

My compile messages look like this:

./configure --with-mysql
checking for a BSD-compatible install... /bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets ${MAKE}... yes
checking for style of include used by make... GNU
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking dependency style of gcc... gcc3
checking for gcc option to accept ANSI C... none needed
checking for ranlib... ranlib
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking dependency style of gcc... (cached) gcc3
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking whether byte ordering is bigendian... no
checking for sparc alignment... no
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for strings.h... (cached) yes
checking for string.h... (cached) yes
checking for stdlib.h... (cached) yes
checking for unistd.h... (cached) yes
checking sys/sockio.h usability... no
checking sys/sockio.h presence... no
checking for sys/sockio.h... no
checking paths.h usability... yes
checking paths.h presence... yes
checking for paths.h... yes
checking for inet_ntoa in -lnsl... yes
checking for socket in -lsocket... no
checking whether printf must be declared... no
checking whether fprintf must be declared... no
checking whether syslog must be declared... no
checking whether puts must be declared... no
checking whether fputs must be declared... no
checking whether fputc must be declared... no
checking whether fopen must be declared... no
checking whether fclose must be declared... no
checking whether fwrite must be declared... no
checking whether fflush must be declared... no
checking whether getopt must be declared... no
checking whether bzero must be declared... no
checking whether bcopy must be declared... no
checking whether memset must be declared... no
checking whether strtol must be declared... no
checking whether strcasecmp must be declared... no
checking whether strncasecmp must be declared... no
checking whether strerror must be declared... no
checking whether perror must be declared... no
checking whether socket must be declared... no
checking whether sendto must be declared... no
checking whether vsnprintf must be declared... no
checking whether snprintf must be declared... no
checking whether strtoul must be declared... no
checking for snprintf... yes
checking for strlcpy... no
checking for strlcat... no
checking for strerror... yes
checking for __FUNCTION__... yes
checking for floor in -lm... yes
checking for pcap_datalink in -lpcap... yes
checking pcre.h usability... yes
checking pcre.h presence... yes
checking for pcre.h... yes
checking for pcre_compile in -lpcre... yes
checking for mysql... yes
checking for compress in -lz... yes
checking for u_int8_t... yes
checking for u_int16_t... yes
checking for u_int32_t... yes
checking for a BSD-compatible install... /bin/install -c
configure: creating ./config.status
config.status: creating Makefile
config.status: creating src/Makefile
config.status: creating src/sfutil/Makefile
config.status: creating src/detection-plugins/Makefile
config.status: creating src/output-plugins/Makefile
config.status: creating src/preprocessors/Makefile
config.status: creating src/preprocessors/HttpInspect/Makefile
config.status: creating src/preprocessors/HttpInspect/include/Makefile
config.status: creating src/preprocessors/HttpInspect/utils/Makefile
config.status: creating
src/preprocessors/HttpInspect/anomaly_detection/Makefile
config.status: creating src/preprocessors/HttpInspect/client/Makefile
config.status: creating src/preprocessors/HttpInspect/event_output/Makefile
config.status: creating
src/preprocessors/HttpInspect/mode_inspection/Makefile
config.status: creating src/preprocessors/HttpInspect/normalization/Makefile
config.status: creating src/preprocessors/HttpInspect/server/Makefile
config.status: creating
src/preprocessors/HttpInspect/session_inspection/Makefile
config.status: creating
src/preprocessors/HttpInspect/user_interface/Makefile
config.status: creating src/preprocessors/flow/Makefile
config.status: creating src/preprocessors/flow/int-snort/Makefile
config.status: creating src/preprocessors/flow/portscan/Makefile
config.status: creating src/parser/Makefile
config.status: creating doc/Makefile
config.status: creating contrib/Makefile
config.status: creating etc/Makefile
config.status: creating rules/Makefile
config.status: creating templates/Makefile
config.status: creating src/win32/Makefile
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing depfiles commands

I have tried several different option which do not work. Has anyone run into
this problem?

Thanks ahead

Darwin L. Lambeth
Network Administrator
FPMI/Star Mountain
dlambeth () starmountain com
210-822-0770 EXT 246