Make error libmysqlclient.so: undefined reference to `mkstemp64@GLIBC_2.2' collect2: ld returned 1 exit status

["Jorge Reyes" <jreyes () talaris com>]

The configure I ran is
 
LIBS="-ldl" ./configure --with-openssl="/usr/local"
--with-mysql="$DBHOME"

And it finishes ok
 
I have openssl version
openssl-engine-0.9.6b 
 
I have snort version
snort-1.8p1. 
 
I have mysql version
mysql-3.23.36-1
mysql-server-3.23.36-1
 
Any ideas ?
Jorge
[dev.local$] make
gcc  -g -O2 -Wall -L/usr/lib/mysql -L/usr/local/lib -o snort  snort.o
log.o decode.o mstring.o rules.o plugbase.o sp_pattern_match.o
sp_tcp_flag_check.o sp_icmp_type_check.o sp_icmp_code_check.o
sp_ttl_check.o sp_ip_id_check.o sp_tcp_ack_check.o sp_tcp_seq_check.o
sp_dsize_check.o spp_http_decode.o spp_portscan.o sp_ipoption_check.o
sp_rpc_check.o sp_icmp_id_check.o sp_icmp_seq_check.o sp_respond.o
spo_alert_syslog.o spo_log_tcpdump.o spo_database.o sp_session.o
spp_defrag.o parser.o spo_alert_fast.o spo_alert_full.o spo_alert_smb.o
spo_alert_unixsock.o sp_react.o spo_xml.o sp_ip_tos_check.o snprintf.o
checksum.o spp_tcp_stream2.o sp_reference.o sp_ip_fragbits.o
spp_anomsensor.o tag.o spp_unidecode.o codes.o strlcpyu.o strlcatu.o
debug.o sp_tcp_win_check.o spp_rpc_decode.o spp_bo.o
spp_telnet_negotiation.o spo_csv.o sp_ip_same_check.o sp_priority.o
sp_ip_proto.o ubi_BinTree.o ubi_SplayTree.o spo_unified.o spp_stream4.o
spp_frag2.o spp_arpspoof.o  -lpcap -lm -lnsl -ldl -lmysqlclient -lssl
-lcrypto
/usr/lib/mysql/libmysqlclient.so: undefined reference to
`mkstemp64@GLIBC_2.2' <mailto:`mkstemp64@GLIBC_2.2&apos;> 
collect2: ld returned 1 exit status
make: *** [snort] Error 1