{"id":27,"date":"2008-01-17T08:32:44","date_gmt":"2008-01-17T01:32:44","guid":{"rendered":"http:\/\/josh.staff.ugm.ac.id\/blog\/2008\/01\/17\/mandek-terus-install-mysql-5051-di-freebsd-410-stable\/"},"modified":"2008-01-17T09:58:01","modified_gmt":"2008-01-17T02:58:01","slug":"mandek-terus-install-mysql-5051-di-freebsd-410-stable","status":"publish","type":"post","link":"https:\/\/josh.rootbrain.com\/blog\/2008\/01\/17\/mandek-terus-install-mysql-5051-di-freebsd-410-stable\/","title":{"rendered":"Mandek terus, install mysql-5.0.51 di FreeBSD 4.10 Stable (solved!)"},"content":{"rendered":"

Sejak tadi pagi belum<\/strike> Sudah nemu solusi cara install mysql-5.0.51 (mysql50-client & mysql50-server) via ports di FreeBSD 4.10 Stable. Emang OS servernya sudah agak uzur. Sebelumnya database yang berjalan di server ini adalah mysql-4.0. Berikut informasinya<\/p>\n

\n

-su-2.05b# uname -a
\nFreeBSD papirus.te.ugm.ac.id 4.10-STABLE FreeBSD 4.10-STABLE #0: Tue Feb 27 16:32:40 WIT 2007 root@papirus.te.ugm.ac.id:\/usr\/src\/sys\/compile\/PAPIRUS i386<\/em><\/p>\n

-su-2.05b# cd \/usr\/ports\/databases\/mysql50-client\/
\n-su-2.05b# make
\n===> Vulnerability check disabled, database not found
\n===> Extracting for mysql-client-5.0.51
\n=> MD5 Checksum OK for mysql-5.0.51.tar.gz.
\n===> mysql-client-5.0.51 depends on file: \/usr\/local\/sbin\/pkg_info – found
\n===> Patching for mysql-client-5.0.51
\n===> Applying FreeBSD patches for mysql-client-5.0.51
\n===> mysql-client-5.0.51 depends on file: \/usr\/local\/bin\/libtool – found
\n===> Configuring for mysql-client-5.0.51
\nchecking build system type… i386-portbld-freebsd4.10
\nchecking host system type… i386-portbld-freebsd4.10
\nchecking target system type… i386-portbld-freebsd4.10
\nchecking for a BSD-compatible install… \/usr\/bin\/install -c -o root -g wheel
\nchecking whether build environment is sane… yes
\n<\/em><\/p>\n<\/blockquote>\n

\n

–cut —<\/em><\/p>\n

checking libedit variant of rl_completion_entry_function… no
\nchecking defined rl_compentry_func_t and rl_completion_func_t… no
\nchecking HIST_ENTRY is declared in readline\/readline.h…
\nconfigure: error: Could not find system readline or libedit libraries
\nUse –with-readline or –with-libedit to use the bundled
\nversions of libedit or readline
\n===> Script “configure” failed unexpectedly.
\nPlease report the problem to ale@FreeBSD.org [maintainer] and attach the
\n“\/usr\/ports\/databases\/mysql50-client\/work\/mysql-5.0.51\/config.log” including
\nthe output of the failure of your make command. Also, it might be a good idea
\nto provide an overview of all packages installed on your system (e.g. an `ls
\n\/var\/db\/pkg`).
\n*** Error code 1<\/em><\/p>\n<\/blockquote>\n

Menurut informasi diatas, configure mandek karena tidak menemukan library system readline atau libedit. Saya sudah install kedual library tersebut dari port.<\/p>\n

\n

-su-2.05b# ls -al \/var\/db\/pkg\/
\ntotal 100
\ndrwxr-xr-x 50 root wheel 1536 Jan 17 07:56 .
\n<cut>
\ndrwxr-xr-x 2 root wheel 512 Jan 17 06:40 libedit-2.6.10_1
\ndrwxr-xr-x 2 root wheel 512 Jan 17 06:36 libtool-1.5.24
\ndrwxr-xr-x 2 root wheel 512 Jan 17 06:35 pkg_install-20060113
\ndrwxr-xr-x 2 root wheel 512 Jan 17 07:56 readline-5.2_1
\n<cut><\/em><\/p>\n<\/blockquote>\n

Kemudian saya ikutin petunjuk dengan menambah argument –with-readline di Makefile<\/p>\n

\n

-su-2.05b# vi ..\/mysql50-server\/Makefile<\/em><\/p>\n<\/blockquote>\n

Setelah di eksekusi, sepertinya akan berhasil, karena pesan error saat configure tadi sudah tidak muncul. Setelah melalui proses configure, masuk ke tahap compiling. Nah permasalah kembali muncul, berikut kutipannya<\/p>\n

\n

Making all in extra
\nmake all-recursive
\nsource=’replace.c’ object=’replace.o’ libtool=no DEPDIR=.deps depmode=gcc \/bin\/sh ..\/depcomp cc -DHAVE_CONFIG_H -I. -I. -I..\/include -I..\/include -I..\/include -I..\/sql -DDBUG_OFF -O -pipe -c replace.c
\n\/usr\/local\/bin\/libtool –preserve-dup-deps –tag=CC –mode=link cc -DDBUG_OFF -O -pipe -o replace replace.o ..\/mysys\/libmysys.a ..\/dbug\/libdbug.a ..\/strings\/libmystrings.a ..\/zlib\/libzlt.la -pthread -lcrypt -lm -pthread
\nmkdir .libs
\nlibtool: link: cannot find the library `..\/zlib\/libzlt.la’ or unhandled argument `..\/zlib\/libzlt.la’
\n*** Error code 1<\/em><\/p>\n

Stop in \/usr\/ports\/databases\/mysql50-client\/work\/mysql-5.0.51\/extra.
\n*** Error code 1<\/em><\/p>\n

Stop in \/usr\/ports\/databases\/mysql50-client\/work\/mysql-5.0.51\/extra.
\n*** Error code 1<\/em><\/p>\n

Stop in \/usr\/ports\/databases\/mysql50-client\/work\/mysql-5.0.51\/extra.
\n*** Error code 1<\/em><\/p>\n

Stop in \/usr\/ports\/databases\/mysql50-client\/work\/mysql-5.0.51.
\n*** Error code 1<\/em><\/p>\n

Stop in \/usr\/ports\/databases\/mysql50-client\/work\/mysql-5.0.51.
\n*** Error code 1<\/em><\/p>\n

Stop in \/usr\/ports\/databases\/mysql50-client.<\/em><\/p>\n<\/blockquote>\n

Sampai saat ini saya belum menemukan solusi diatas. Mungkin ada rekan yang tahu ?\u00c2\u00a0<\/strike>\u00c2\u00a0 Solusinya dibawah ini<\/strong><\/p>\n

Berhubung karena servernya akan segera digunakan, maka jika sampai sore nanti belum ketemu juga, maka saya akan upgrade OSnya ke freeBSD6.2 atau malah Ubuntu Gutsy. Soalnya hasil penelusuran di internet OS Freebsd versi 4.10 sudah tidak banyak digunakan sebagai Database Server hiks..<\/p>\n

———————————– solved ——————————<\/p>\n

Akhirnya sudah ketemu solusinya untuk pesan<\/p>\n

\n

libtool: link: cannot find the library `..\/zlib\/libzlt.la’ or unhandled argument `..\/zlib\/libzlt.la’<\/em><\/p>\n<\/blockquote>\n

Itu artinya library zlib belum tercompile dengan baik. Selesaikan dengan cara<\/p>\n

\n

-su-2.05b# find work -name zlib -print
\nwork\/mysql-5.0.51\/zlib
\n-su-2.05b# cd work\/mysql-5.0.51\/zlib\/
\n-su-2.05b# make<\/em><\/p>\n<\/blockquote>\n

Kemudian coba install kembali mysql5.0-client<\/p>\n

\n

-su-2.05b# cd \/usr\/ports\/databases\/mysql50-client\/
\n-su-2.05b# make<\/em><\/p>\n<\/blockquote>\n

Ternyata ketemu lagi problem<\/p>\n

\n

c++ -DDBUG_OFF -O -pipe -O -pipe -felide-constructors -fno-rtti -fno-exceptions -fno-implicit-templates -fno-exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=1000000 -DUSE_PRAGMA_IMPLEMENTATION -o .libs\/mysql mysql.o readline.o sql_string.o completion_hash.o ..\/cmd-line-utils\/readline\/libreadline.a -lncurses ..\/libmysql\/.libs\/libmysqlclient.so ..\/zlib\/.libs\/libzlt.a -lcrypt -lm -Wl,–rpath -Wl,\/usr\/local\/lib\/mysql
\nc++: ..\/cmd-line-utils\/readline\/libreadline.a: No such file or directory
\n*** Error code 1<\/em><\/p>\n

Stop in \/usr\/ports\/databases\/mysql50-client\/work\/mysql-5.0.51\/client.
\n*** Error code 1<\/em><\/p>\n

Stop in \/usr\/ports\/databases\/mysql50-client\/work\/mysql-5.0.51.
\n*** Error code 1<\/em><\/p>\n

Stop in \/usr\/ports\/databases\/mysql50-client\/work\/mysql-5.0.51.
\n*** Error code 1<\/em><\/p>\n

Stop in \/usr\/ports\/databases\/mysql50-client.
\n<\/em><\/p>\n<\/blockquote>\n

Saya coba atasin dengan cara yang sama seperti pada library zlib<\/p>\n

\n

-su-2.05b# find work -name readline -print
\nwork\/mysql-5.0.51\/include\/readline
\nwork\/mysql-5.0.51\/cmd-line-utils\/libedit\/readline
\nwork\/mysql-5.0.51\/cmd-line-utils\/readline
\n-su-2.05b# cd work\/mysql-5.0.51\/cmd-line-utils\/
\n-su-2.05b# make<\/em><\/p>\n<\/blockquote>\n

Setelah library readline tercompile, saya mencoba kembali compiling mysql50-client<\/p>\n

\n

-su-2.05b# cd \/usr\/ports\/databases\/mysql50-client\/
\n-su-2.05b# make<\/em><\/p>\n<\/blockquote>\n

Akhirnya berhasil dengan mulus proses compiling mysql50-client nya, diikuti dengan install ke system<\/p>\n

\n

-su-2.05b# make install<\/em><\/p>\n

===> Compressing manual pages for mysql-client-5.0.51
\n===> Running ldconfig
\n\/sbin\/ldconfig -m \/usr\/local\/lib\/mysql
\n===> Installing ldconfig configuration file
\n===> Registering installation for mysql-client-5.0.51
\n-su-2.05b#<\/em><\/p>\n<\/blockquote>\n

Sekarang tahapan install mysql50-server<\/p>\n

\n

-su-2.05b# cd \/usr\/ports\/databases\/mysql50-server\/
\n-su-2.05b# make<\/em><\/p>\n<\/blockquote>\n

Ternyata muncul permasalahan yang persis sama seperti saat compiling mysql50-client<\/p>\n

\n

libtool: link: cannot find the library `..\/zlib\/libzlt.la’ or unhandled argument `..\/zlib\/libzlt.la’<\/em><\/p>\n<\/blockquote>\n

Karena ternyata working directorynya proses configure dan compilingnya berbeda antara mysql50-client dan mysql50-server. Maka saya ulangi cara diatas untuk mysql50-server, dan ternyata solved untuk masalah tersebut. Sekarang saya mengulangi kembali proses “make”<\/p>\n

\n

-su-2.05b# make<\/em><\/p>\n<\/blockquote>\n

Dan berhasil dengan mulus… Sukses ternyata \ud83d\ude42<\/p>\n

\n

-su-2.05b# make install<\/em><\/p>\n

<cut><\/em><\/p>\n

************************************************************************<\/em><\/p>\n

Remember to run mysql_upgrade (with the optional –datadir=<dbdir> flag)
\nthe first time you start the MySQL server after an upgrade from an
\nearlier version.<\/em><\/p>\n

************************************************************************
\ninstall-info –quiet \/usr\/local\/info\/mysql.info \/usr\/local\/info\/dir
\n===> Installing rc.d startup script(s)
\n===> Compressing manual pages for mysql-server-5.0.51
\n===> Registering installation for mysql-server-5.0.51
\n===> SECURITY REPORT:
\nThis port has installed the following files which may act as network
\nservers and may therefore pose a remote security risk to the system.
\n\/usr\/local\/libexec\/mysqld<\/em><\/p>\n

This port has installed the following startup scripts which may cause
\nthese network services to be started at boot time.
\n\/usr\/local\/etc\/rc.d\/mysql-server.sh<\/em><\/p>\n

If there are vulnerabilities in these programs there may be a security
\nrisk to the system. FreeBSD makes no guarantee about the security of
\nports included in the Ports Collection. Please type ‘make deinstall’
\nto deinstall the port if this is a concern.<\/em><\/p>\n

For more information, and contact details about the security
\nstatus of this software, see the following webpage:
\nhttp:\/\/www.mysql.com\/<\/em><\/p>\n<\/blockquote>\n

Begitu pesan terakhir proses installasi mysql50-server. Akhirnya lega.. \ud83d\ude42<\/p>\n

Sekarang tinggal menyiapkan database untuk aplikasi yang baru. Thanks bagi rekan rekan yang sudah mencoba membantu. Tidak jadi upgrade OS lagi hehehe….<\/p>\n","protected":false},"excerpt":{"rendered":"

Sejak tadi pagi belum Sudah nemu solusi cara install mysql-5.0.51 (mysql50-client & mysql50-server) via ports di FreeBSD 4.10 Stable. Emang OS servernya sudah agak uzur. Sebelumnya database yang berjalan di server ini adalah mysql-4.0. Berikut informasinya -su-2.05b# uname -a FreeBSD papirus.te.ugm.ac.id 4.10-STABLE FreeBSD 4.10-STABLE #0: Tue Feb 27 16:32:40 WIT 2007 root@papirus.te.ugm.ac.id:\/usr\/src\/sys\/compile\/PAPIRUS i386 -su-2.05b# cd […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/josh.rootbrain.com\/blog\/wp-json\/wp\/v2\/posts\/27"}],"collection":[{"href":"https:\/\/josh.rootbrain.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/josh.rootbrain.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/josh.rootbrain.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/josh.rootbrain.com\/blog\/wp-json\/wp\/v2\/comments?post=27"}],"version-history":[{"count":0,"href":"https:\/\/josh.rootbrain.com\/blog\/wp-json\/wp\/v2\/posts\/27\/revisions"}],"wp:attachment":[{"href":"https:\/\/josh.rootbrain.com\/blog\/wp-json\/wp\/v2\/media?parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/josh.rootbrain.com\/blog\/wp-json\/wp\/v2\/categories?post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/josh.rootbrain.com\/blog\/wp-json\/wp\/v2\/tags?post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}