MySQL install from ports

[mcoleman]

Hi,

I have installed PCBSD 1.5 under Virtual PC on Vista. I have installed Apache 2.2 and PHP 5 from ports with no problems. Now trying to install MySql using the mysql51-server port but get build issues.

The port recognises that the client needs to be installed but seems to fail due to some missing files?

An excerpt of the output from "make install clean" is listed below. Any help is appreciated.

Cheers
Mark

=========================
Making all in libmysql_r
gmake[1]: Entering directory `/usr/ports/databases/mysql51-client/work/mysql-5.1.23-rc/libmysql_r'
gmake all-am
gmake[2]: Entering directory `/usr/ports/databases/mysql51-client/work/mysql-5.1.23-rc/libmysql_r'
/usr/local/bin/libtool --preserve-dup-deps --tag=CC --mode=link cc -O2 -fno-strict-aliasing -pipe -o libmysqlclient_r.la -rpath /usr/local/lib/mysql -version-info 16:0:0 -Wl,--version-script=../libmysql/libmysql.ver libmysql.lo password.lo manager.lo get_password.lo errmsg.lo my_init.lo my_static.lo my_malloc.lo my_realloc.lo my_create.lo my_delete.lo mf_tempfile.lo my_open.lo my_file.lo my_read.lo my_write.lo errors.lo my_error.lo my_getwd.lo my_div.lo mf_pack.lo my_messnc.lo mf_dirname.lo mf_fn_ext.lo mf_wcomp.lo typelib.lo safemalloc.lo my_alloc.lo mf_format.lo mf_path.lo mf_unixpath.lo my_fopen.lo my_symlink.lo my_fstream.lo mf_arr_appstr.lo mf_loadpath.lo my_pthread.lo my_thr_init.lo thr_mutex.lo mulalloc.lo string.lo default.lo default_modify.lo my_compress.lo array.lo my_once.lo list.lo my_net.lo charset.lo charset-def.lo hash.lo mf_iocache.lo mf_iocache2.lo my_seek.lo my_sleep.lo my_pread.lo mf_cache.lo md5.lo sha1.lo my_getopt.lo my_gethostbyname.lo my_port.lo my_rename.lo my_chsize.lo my_getsystime.lo my_lib.lo mf_qsort.lo strmov.lo strxmov.lo strxnmov.lo strnmov.lo strmake.lo strend.lo strtod.lo strnlen.lo strfill.lo is_prefix.lo int2str.lo str2int.lo strinstr.lo strcont.lo strcend.lo bcmp.lo ctype-latin1.lo bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo strtoll.lo llstr.lo my_vsnprintf.lo ctype.lo ctype-simple.lo ctype-bin.lo ctype-mb.lo ctype-big5.lo ctype-czech.lo ctype-cp932.lo ctype-eucjpms.lo ctype-euc_kr.lo ctype-win1250ch.lo ctype-utf8.lo ctype-extra.lo ctype-ucs2.lo ctype-gb2312.lo ctype-gbk.lo ctype-sjis.lo ctype-tis620.lo ctype-ujis.lo ctype-uca.lo xml.lo my_strtoll10.lo str_alloc.lo dbug.lo pack.lo client.lo my_time.lo vio.lo viosocket.lo viossl.lo viosslfactories.lo net.lo -pthread -lcrypt -lm -pthread -lz
cc -shared .libs/libmysql.o .libs/password.o .libs/manager.o .libs/get_password.o .libs/errmsg.o .libs/my_init.o .libs/my_static.o .libs/my_malloc.o .libs/my_realloc.o .libs/my_create.o .libs/my_delete.o .libs/mf_tempfile.o .libs/my_open.o .libs/my_file.o .libs/my_read.o .libs/my_write.o .libs/errors.o .libs/my_error.o .libs/my_getwd.o .libs/my_div.o .libs/mf_pack.o .libs/my_messnc.o .libs/mf_dirname.o .libs/mf_fn_ext.o .libs/mf_wcomp.o .libs/typelib.o .libs/safemalloc.o .libs/my_alloc.o .libs/mf_format.o .libs/mf_path.o .libs/mf_unixpath.o .libs/my_fopen.o .libs/my_symlink.o .libs/my_fstream.o .libs/mf_arr_appstr.o .libs/mf_loadpath.o .libs/my_pthread.o .libs/my_thr_init.o .libs/thr_mutex.o .libs/mulalloc.o .libs/string.o .libs/default.o .libs/default_modify.o .libs/my_compress.o .libs/array.o .libs/my_once.o .libs/list.o .libs/my_net.o .libs/charset.o .libs/charset-def.o .libs/hash.o .libs/mf_iocache.o .libs/mf_iocache2.o .libs/my_seek.o .libs/my_sleep.o .libs/my_pread.o .libs/mf_cache.o .libs/md5.o .libs/sha1.o .libs/my_getopt.o .libs/my_gethostbyname.o .libs/my_port.o .libs/my_rename.o .libs/my_chsize.o .libs/my_getsystime.o .libs/my_lib.o .libs/mf_qsort.o .libs/strmov.o .libs/strxmov.o .libs/strxnmov.o .libs/strnmov.o .libs/strmake.o .libs/strend.o .libs/strtod.o .libs/strnlen.o .libs/strfill.o .libs/is_prefix.o .libs/int2str.o .libs/str2int.o .libs/strinstr.o .libs/strcont.o .libs/strcend.o .libs/bcmp.o .libs/ctype-latin1.o .libs/bchange.o .libs/bmove.o .libs/bmove_upp.o .libs/longlong2str.o .libs/strtoull.o .libs/strtoll.o .libs/llstr.o .libs/my_vsnprintf.o .libs/ctype.o .libs/ctype-simple.o .libs/ctype-bin.o .libs/ctype-mb.o .libs/ctype-big5.o .libs/ctype-czech.o .libs/ctype-cp932.o .libs/ctype-eucjpms.o .libs/ctype-euc_kr.o .libs/ctype-win1250ch.o .libs/ctype-utf8.o .libs/ctype-extra.o .libs/ctype-ucs2.o .libs/ctype-gb2312.o .libs/ctype-gbk.o .libs/ctype-sjis.o .libs/ctype-tis620.o .libs/ctype-ujis.o .libs/ctype-uca.o .libs/xml.o .libs/my_strtoll10.o .libs/str_alloc.o .libs/dbug.o .libs/pack.o .libs/client.o .libs/my_time.o .libs/vio.o .libs/viosocket.o .libs/viossl.o .libs/viosslfactories.o .libs/net.o -pthread -lcrypt -lm -pthread -lz -Wl,--version-script=../libmysql/libmysql.ver -pthread -pthread -pthread -pthread -pthread -pthread -Wl,-soname -Wl,libmysqlclient_r.so.16 -o .libs/libmysqlclient_r.so.16
cc: .libs/libmysql.o: No such file or directory
cc: .libs/password.o: No such file or directory
cc: .libs/manager.o: No such file or directory
cc: .libs/get_password.o: No such file or directory
cc: .libs/errmsg.o: No such file or directory
cc: .libs/my_init.o: No such file or directory
cc: .libs/my_static.o: No such file or directory
cc: .libs/my_malloc.o: No such file or directory
cc: .libs/my_realloc.o: No such file or directory
cc: .libs/my_create.o: No such file or directory
cc: .libs/my_delete.o: No such file or directory
cc: .libs/mf_tempfile.o: No such file or directory
cc: .libs/my_open.o: No such file or directory
cc: .libs/my_file.o: No such file or directory
cc: .libs/my_read.o: No such file or directory
cc: .libs/my_write.o: No such file or directory
cc: .libs/errors.o: No such file or directory
cc: .libs/my_error.o: No such file or directory
cc: .libs/my_getwd.o: No such file or directory
cc: .libs/my_div.o: No such file or directory
cc: .libs/mf_pack.o: No such file or directory
cc: .libs/my_messnc.o: No such file or directory
cc: .libs/mf_dirname.o: No such file or directory
cc: .libs/mf_fn_ext.o: No such file or directory
cc: .libs/mf_wcomp.o: No such file or directory
cc: .libs/typelib.o: No such file or directory
cc: .libs/safemalloc.o: No such file or directory
cc: .libs/my_alloc.o: No such file or directory
cc: .libs/mf_format.o: No such file or directory
cc: .libs/mf_path.o: No such file or directory
cc: .libs/mf_unixpath.o: No such file or directory
cc: .libs/my_fopen.o: No such file or directory
cc: .libs/my_symlink.o: No such file or directory
cc: .libs/my_fstream.o: No such file or directory
cc: .libs/mf_arr_appstr.o: No such file or directory
cc: .libs/mf_loadpath.o: No such file or directory
cc: .libs/my_pthread.o: No such file or directory
cc: .libs/my_thr_init.o: No such file or directory
cc: .libs/thr_mutex.o: No such file or directory
cc: .libs/mulalloc.o: No such file or directory
cc: .libs/string.o: No such file or directory
cc: .libs/default.o: No such file or directory
cc: .libs/default_modify.o: No such file or directory
cc: .libs/my_compress.o: No such file or directory
cc: .libs/array.o: No such file or directory
cc: .libs/my_once.o: No such file or directory
cc: .libs/list.o: No such file or directory
cc: .libs/my_net.o: No such file or directory
cc: .libs/charset.o: No such file or directory
cc: .libs/charset-def.o: No such file or directory
cc: .libs/hash.o: No such file or directory
cc: .libs/mf_iocache.o: No such file or directory
cc: .libs/mf_iocache2.o: No such file or directory
cc: .libs/my_seek.o: No such file or directory
cc: .libs/my_sleep.o: No such file or directory
cc: .libs/my_pread.o: No such file or directory
cc: .libs/mf_cache.o: No such file or directory
cc: .libs/md5.o: No such file or directory
cc: .libs/sha1.o: No such file or directory
cc: .libs/my_getopt.o: No such file or directory
cc: .libs/my_gethostbyname.o: No such file or directory
cc: .libs/my_port.o: No such file or directory
cc: .libs/my_rename.o: No such file or directory
cc: .libs/my_chsize.o: No such file or directory
cc: .libs/my_getsystime.o: No such file or directory
cc: .libs/my_lib.o: No such file or directory
cc: .libs/mf_qsort.o: No such file or directory
cc: .libs/strmov.o: No such file or directory
cc: .libs/strxmov.o: No such file or directory
cc: .libs/strxnmov.o: No such file or directory
cc: .libs/strnmov.o: No such file or directory
cc: .libs/strmake.o: No such file or directory
cc: .libs/strend.o: No such file or directory
cc: .libs/strtod.o: No such file or directory
cc: .libs/strnlen.o: No such file or directory
cc: .libs/strfill.o: No such file or directory
cc: .libs/is_prefix.o: No such file or directory
cc: .libs/int2str.o: No such file or directory
cc: .libs/str2int.o: No such file or directory
cc: .libs/strinstr.o: No such file or directory
cc: .libs/strcont.o: No such file or directory
cc: .libs/strcend.o: No such file or directory
cc: .libs/bcmp.o: No such file or directory
cc: .libs/ctype-latin1.o: No such file or directory
cc: .libs/bchange.o: No such file or directory
cc: .libs/bmove.o: No such file or directory
cc: .libs/bmove_upp.o: No such file or directory
cc: .libs/longlong2str.o: No such file or directory
gmake[2]: *** [libmysqlclient_r.la] Error 1
gmake[2]: Leaving directory `/usr/ports/databases/mysql51-client/work/mysql-5.1.23-rc/libmysql_r'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/usr/ports/databases/mysql51-client/work/mysql-5.1.23-rc/libmysql_r'
gmake: *** [all-recursive] Error 1
*** Error code 2

Stop in /usr/ports/databases/mysql51-client.
*** Error code 1

Stop in /usr/ports/databases/mysql51-server.

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

[putu]

Did you try to up date your ports, and then uninstall and install it again !

update your ports
# portsnap fetch extract

uninstall apache
# cd /usr/ports/www/apache22 ; make deinstall

Install apache
# cd /usr/ports/www/apache22 ; make install clean

Install mysql 50 (my prefered)
# cd /usr/ports/databases/mysql50-server ; make install clean

[TerryP]

Go to `/usr/ports/databases/mysql51-client/work/mysql-5.1.23-rc/libmysql_r' and look for some of the object files that seem to be missing.

You might try cleaning and updating the ports tree:

# (cd /usr/ports/databases/mysql51-client && make distclean)
# portsnap fetch && portsnap update

then remake the port you were building.

You should of course use csup or portsnap as you usually do.


Use portsnap extract rather then portsnap update if you wish to start with a clean unmodified ports tree rather then an updated one.



PS:

If it makes any difference, my PC-BSD system has mysql-client-5.0.x installed as a depend of KOffice (although I pkg_add'd it manually, instead of from cd#2)

[mcoleman]

Thanks guys.

I refreshed my ports tree, retried and it worked fine.

Cheers.