setelah membaca blognya om Martin, saya jadi tertarik juga untuk mencoba mysql workbench ini. 
dependensinya banyak sangat gan.. untungnya semua kebutuhan terpenuhi dari http://slackbuild.org/ lanjut deh, nge-build paket tgz untuk mysql workbench-nya. laaaaaaaaaaama banget! saya tinggal cuci baju selagi proses berjalan. 
setelah selesai, pada installasi menyisakan sedikit error :
# installpkg /tmp/mysql-workbench-gpl-5.2.31-src-i486-1_SBo.tgz
Verifying package mysql-workbench-gpl-5.2.31-src-i486-1_SBo.tgz.
Installing package mysql-workbench-gpl-5.2.31-src-i486-1_SBo.tgz:
PACKAGE DESCRIPTION:
Executing install script for mysql-workbench-gpl-5.2.31-src-i486-1_SBo.tgz.
install/doinst.sh: line 13: syntax error near unexpected token `('
install/doinst.sh: line 13: `fi( cd usr/lib/mysql-workbench ; rm -rf libwbbase.so.0 )'
Package mysql-workbench-gpl-5.2.31-src-i486-1_SBo.tgz installed.
sebelum dijalankan, ada baiknya kita rename libraries berikut :
# ls /usr/lib/mysql-workbench/ libcdbc.so.0.0.0 libctemplate_wb.so.0.0.0 libgrt.so.0.0.0 liblinux_utilities.so.0.0.0 libmdcanvas.so.0.0.0 libmdcanvasgtk.so.0.0.0 libmforms.so.0.0.0 libsqlide.so.0.0.0 libsqlparser.so.0.0.0 libvsqlitepp.so.0.0.0 libwbbase.so.0.0.0 libwbpublic.so.0.0.0 libwbscintilla.la libwbscintilla.so.0.0.0 mysqlcppconn.so.0.0.0
saya gunakan utilitas mv, ex :
# mv ./libcdbc.so.0.0.0 ./libcdbc.so.0
jika tidak, maka akan didapati error, sebagai berikut :
$ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libmforms.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libmforms.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: liblinux_utilities.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libsqlide.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libwbscintilla.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libwbscintilla.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libwbpublic.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libmdcanvas.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libcdbc.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libvsqlitepp.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libctemplate_wb.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libwbbase.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libgrt.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: libmdcanvasgtk.so.0: cannot open shared object file: No such file or directory $ mysql-workbench /usr/bin/mysql-workbench-bin: error while loading shared libraries: mysqlcppconn.so.0: cannot open shared object file: No such file or directory $ mysql-workbench
splash-screen
oke, saat ini saya telah berhasil masuk, namun disambut pesan error, yaitu kegagalan mysql workbench melakukan eksekusi terhadap tunnel manager,
Mysql-Workbench-SSH-Tunnel-Manager-Error
kemudian kegagalan mysql workbench membuat koneksi ke database server.
Mysql-Workbench-Koneksi-Gagal
saya mencoba melakukan analisa terhadap error log.
$ mysql-workbench
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/wb_utils_grt.py", line 12, in
import mforms
File "/usr/lib/mysql-workbench/modules/mforms.py", line 7, in
import _mforms
ImportError: No module named _mforms
** Message: Failed loading module '/usr/lib/mysql-workbench/modules/wb_utils_grt.py' (python)
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 24, in
from mforms import Utilities, AppView, newSectionBox, App
File "/usr/lib/mysql-workbench/modules/mforms.py", line 7, in
import _mforms
ImportError: No module named _mforms
** Message: Failed loading module '/usr/lib/mysql-workbench/modules/wb_admin_grt.py' (python)
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/text_grt.py", line 6, in
import mforms
File "/usr/lib/mysql-workbench/modules/mforms.py", line 7, in
import _mforms
ImportError: No module named _mforms
** Message: Failed loading module '/usr/lib/mysql-workbench/modules/text_grt.py' (python)
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/wb_doclib_grt.py", line 21, in
from mforms import Utilities, ResultOk, AppView, newWebBrowser, App
File "/usr/lib/mysql-workbench/modules/mforms.py", line 7, in
import _mforms
ImportError: No module named _mforms
** Message: Failed loading module '/usr/lib/mysql-workbench/modules/wb_doclib_grt.py' (python)
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/sqlide_grt.py", line 6, in
import mforms
File "/usr/lib/mysql-workbench/modules/mforms.py", line 7, in
import _mforms
ImportError: No module named _mforms
** Message: Failed loading module '/usr/lib/mysql-workbench/modules/sqlide_grt.py' (python)
Ready.
Traceback (most recent call last):
File "/usr/share/mysql-workbench/sshtunnel.py", line 10, in
import paramiko
ImportError: No module named paramiko
** (mysql-workbench-bin:2712): WARNING **: Tunnel manager could not be executed
** (mysql-workbench-bin:2712): WARNING **: Error starting tunnel manager: Cannot start SSH tunnel manager
mysql-workbench-bin: /usr/include/boost/smart_ptr/shared_ptr.hpp:418: T* boost::shared_ptr< >::operator->() const [with T = Sql_editor]: Assertion `px != 0' failed.
530b527b-ea59-5235-2c15aae8-777755b9 is dumped
** (bug-buddy:2724): WARNING **: Couldn't load /usr/share/applications/openoffice.org3-startcenter.desktop: No such file or directory
oke, permasalahan import error yang pertama, yaitu
ImportError: No module named _mforms
saya mencoba melakukan penggandaan terhadap modul mforms.py pada /usr/lib/mysql-workbench/modules/mforms.py dengan :
cp /usr/lib/mysql-workbench/modules/mforms.py /usr/lib/mysql-workbench/modules/_mforms.py
walau tidak memiliki dasar yang kuat, tetapi dari beberapa script modul yang saya buka, ada yang baris perintah yang melakukan import mforms dan import _mforms. saya rasa ini merujuk kepada satu modul yang sama.
*ketika dicoba eksekusi ulang, menghasilkan error berikut :
AttributeError: ‘module’ object has no attribute ‘delete_PySwigIterator’
hehe, ini yang membuat saya pusing selama berhari-hari. belum ada pencerahan sampai hari ini, oke deh, dilewatin dulu. selanjutnya, kita perlu mencari beberapa modul tambahan, seperti yang tertera pada log error, yaitu paramiko. installasi paramiko membutuhkan pycrypto. untuk paket pycrypto, sayangnya kita tidak dapat mengakses situsnya. sepertinya sudah nggak tersedia lagi, jadi kita menggunakan paket lawas yang ada disini. seperti biasa, untuk installasi kita improve sendiri script slackbuildnya. 
namun, bisa jadi, paket-paket lawas ini memiliki bug, seperti log error yang tertera sebagai berikut :
$ mysql-workbench
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/wb_utils_grt.py", line 12, in
import mforms
File "/usr/lib/mysql-workbench/modules/mforms.py", line 7, in
import _mforms
File "/usr/lib/mysql-workbench/modules/_mforms.py", line 51, in
class PySwigIterator(_object):
File "/usr/lib/mysql-workbench/modules/_mforms.py", line 58, in PySwigIterator
__swig_destroy__ = _mforms.delete_PySwigIterator
AttributeError: 'module' object has no attribute 'delete_PySwigIterator'
** Message: Failed loading module '/usr/lib/mysql-workbench/modules/wb_utils_grt.py' (python)
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 24, in
from mforms import Utilities, AppView, newSectionBox, App
File "/usr/lib/mysql-workbench/modules/mforms.py", line 7, in
import _mforms
File "/usr/lib/mysql-workbench/modules/_mforms.py", line 51, in
class PySwigIterator(_object):
File "/usr/lib/mysql-workbench/modules/_mforms.py", line 58, in PySwigIterator
__swig_destroy__ = _mforms.delete_PySwigIterator
AttributeError: 'module' object has no attribute 'delete_PySwigIterator'
** Message: Failed loading module '/usr/lib/mysql-workbench/modules/wb_admin_grt.py' (python)
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/text_grt.py", line 6, in
import mforms
File "/usr/lib/mysql-workbench/modules/mforms.py", line 7, in
import _mforms
File "/usr/lib/mysql-workbench/modules/_mforms.py", line 51, in
class PySwigIterator(_object):
File "/usr/lib/mysql-workbench/modules/_mforms.py", line 58, in PySwigIterator
__swig_destroy__ = _mforms.delete_PySwigIterator
AttributeError: 'module' object has no attribute 'delete_PySwigIterator'
** Message: Failed loading module '/usr/lib/mysql-workbench/modules/text_grt.py' (python)
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/wb_doclib_grt.py", line 21, in
from mforms import Utilities, ResultOk, AppView, newWebBrowser, App
File "/usr/lib/mysql-workbench/modules/mforms.py", line 7, in
import _mforms
File "/usr/lib/mysql-workbench/modules/_mforms.py", line 51, in
class PySwigIterator(_object):
File "/usr/lib/mysql-workbench/modules/_mforms.py", line 58, in PySwigIterator
__swig_destroy__ = _mforms.delete_PySwigIterator
AttributeError: 'module' object has no attribute 'delete_PySwigIterator'
** Message: Failed loading module '/usr/lib/mysql-workbench/modules/wb_doclib_grt.py' (python)
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/sqlide_grt.py", line 6, in
import mforms
File "/usr/lib/mysql-workbench/modules/mforms.py", line 7, in
import _mforms
File "/usr/lib/mysql-workbench/modules/_mforms.py", line 51, in
class PySwigIterator(_object):
File "/usr/lib/mysql-workbench/modules/_mforms.py", line 58, in PySwigIterator
__swig_destroy__ = _mforms.delete_PySwigIterator
AttributeError: 'module' object has no attribute 'delete_PySwigIterator'
** Message: Failed loading module '/usr/lib/mysql-workbench/modules/sqlide_grt.py' (python)
Ready.
/usr/lib/python2.6/site-packages/Crypto/Hash/SHA.py:6: DeprecationWarning: the sha module is deprecated; use the hashlib module instead
from sha import *
/usr/lib/python2.6/site-packages/Crypto/Hash/MD5.py:6: DeprecationWarning: the md5 module is deprecated; use hashlib instead
from md5 import *
sekarang masalah koneksi SSH Tunnel Manager udah beres, terjadi pengalihan ternyata disana. cuma saya belum bisa melakukan koneksi ke mysql server. masih mencari..
Ping-balik: koneksi mysql melalui mysql workbench « ::Richie's Weblog::