error when trying to install mysql 4.1.12

[Jason Taylor]

Christian Astrup Bakke wrote:
> hi,
> 
> i'm having problems trying to install mysql41-server from ports since 
> 4.1.12 was made available, using freebsd 4.11:
> 
> //
> 
> [11:06:51] [root at thoth:/usr/ports/databases/mysql41-server] # make 
> install clean
> 
> <snip>
> 
> Making all in client
> source='mysql.cc' object='mysql.o' libtool=no  depfile='.deps/mysql.Po' 
> tmpdepfile='.deps/mysql.TPo'  depmode=gcc /bin/sh ../depcomp  cc 
> -DUNDEF_THREADS_HACK -I. -I. -I.. -I../include -I../regex -DDBUG_OFF  -O 
> -pipe  -D_THREAD_SAFE -I/usr/local/include -O -pipe -D_THREAD_SAFE 
> -I/usr/local/include -felide-constructors -fno-rtti -fno-exceptions   
> -fno-implicit-templates -fno-exceptions -fno-rtti 
> -DMYSQLD_NET_RETRY_COUNT=1000000 -c -o mysql.o mysql.cc
> source='readline.cc' object='readline.o' libtool=no 
> depfile='.deps/readline.Po' tmpdepfile='.deps/readline.TPo'  depmode=gcc 
> /bin/sh ../depcomp  cc -DUNDEF_THREADS_HACK -I. -I. -I.. -I../include 
> -I../regex       -DDBUG_OFF  -O -pipe  -D_THREAD_SAFE 
> -I/usr/local/include -O -pipe  -D_THREAD_SAFE -I/usr/local/include 
> -felide-constructors -fno-rtti -fno-exceptions   -fno-implicit-templates 
> -fno-exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=1000000 -c -o 
> readline.o readline.cc
> source='sql_string.cc' object='sql_string.o' libtool=no 
> depfile='.deps/sql_string.Po' tmpdepfile='.deps/sql_string.TPo' 
> depmode=gcc /bin/sh ../depcomp  cc -DUNDEF_THREADS_HACK -I. -I. -I.. 
> -I../include -I../regex       -DDBUG_OFF  -O -pipe  -D_THREAD_SAFE 
> -I/usr/local/include -O -pipe  -D_THREAD_SAFE -I/usr/local/include 
> -felide-constructors -fno-rtti -fno-exceptions   -fno-implicit-templates 
> -fno-exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=1000000 -c -o 
> sql_string.o sql_string.cc
> source='completion_hash.cc' object='completion_hash.o' libtool=no 
> depfile='.deps/completion_hash.Po' 
> tmpdepfile='.deps/completion_hash.TPo'  depmode=gcc /bin/sh ../depcomp 
> cc -DUNDEF_THREADS_HACK -I. -I. -I.. -I../include -I../regex -DDBUG_OFF  
> -O -pipe  -D_THREAD_SAFE -I/usr/local/include -O -pipe -D_THREAD_SAFE 
> -I/usr/local/include -felide-constructors -fno-rtti -fno-exceptions   
> -fno-implicit-templates -fno-exceptions -fno-rtti 
> -DMYSQLD_NET_RETRY_COUNT=1000000 -c -o completion_hash.o completion_hash.cc
> /usr/local/bin/libtool15 --preserve-dup-deps --mode=link cc  -DDBUG_OFF 
>  -O -pipe  -D_THREAD_SAFE -I/usr/local/include -O -pipe  -D_THREAD_SAFE 
> -I/usr/local/include -felide-constructors -fno-rtti -fno-exceptions 
> -fno-implicit-templates -fno-exceptions -fno-rtti 
> -DMYSQLD_NET_RETRY_COUNT=1000000    -o mysql  mysql.o readline.o 
> sql_string.o completion_hash.o -lreadline -lncurses 
> ../libmysql/libmysqlclient.la  -lcrypt -lm   -lz
> mkdir .libs
> cc -DDBUG_OFF -O -pipe -D_THREAD_SAFE -I/usr/local/include -O -pipe 
> -D_THREAD_SAFE -I/usr/local/include -felide-constructors -fno-rtti 
> -fno-exceptions -fno-implicit-templates -fno-exceptions -fno-rtti 
> -DMYSQLD_NET_RETRY_COUNT=1000000 -o .libs/mysql mysql.o readline.o 
> sql_string.o completion_hash.o  -lreadline -lncurses 
> ../libmysql/.libs/libmysqlclient.so -lcrypt -lm -lz -Wl,--rpath 
> -Wl,/usr/local/lib/mysql
> mysql.o: In function `new_mysql_completion(char const *, int, int)':
> mysql.o(.text+0x18b0): undefined reference to `rl_completion_matches'
> *** Error code 1
> 
> Stop in /usr/ports/databases/mysql41-client/work/mysql-4.1.12/client.
> *** Error code 1
> 
> Stop in /usr/ports/databases/mysql41-client/work/mysql-4.1.12.
> *** Error code 1
> 
> Stop in /usr/ports/databases/mysql41-client/work/mysql-4.1.12.
> *** Error code 1
> 
> Stop in /usr/ports/databases/mysql41-client.
> *** Error code 1
> 
> Stop in /usr/ports/databases/mysql41-server.
> 
> //
> 
> before this, i had the 4.1.11 version which installed correctly just a 
> couple of days ago. today i uninstalled 4.1.11 after trying to run 
> 'portupgrade -arv' (which gave me the same error as the one above), ran 
> a 'make clean' in the mysql41-server directory just to make sure that 
> the old files were cleaned out and used 'make install clean' which led 
> me to the error above.
> 
> all ports are updated via cvsup as of today (10:00 norwegian time).
> 
> any ideas? thanks in advance.
> 
> 
> -- christian at asba dot no

I had this same problem also on 4.11 and then discovered that the 
options from pkgtools.conf weren't being picked up (I'd mistyped 
mysql41-* as mysq41-*).  Anyway, using the following options made it 
work: USE_LINUXTHREADS, BUILD_OPTIMIZED, WITH_OPENSSL.  I haven't 
investigated and have no direct proof, but my guess is that 
USE_LINUXTHREADS is the key.