Thursday, 13 March 2008

Getting mysql gui tools working on ubuntu 7.10

I had three hurdles to get over to get mysql gui tools to work.

1. My first problem was that I got the error

/bin/sh: bad interpreter: Permission denied

when I tried running mysql-administrator

This was because my mounted directory did not have exec permissions. Adding 'exec to the row in /etc/fstab, then umount & mount solved this.

/dev/hdb1 /media/d_drive auto rw,user,exec 0 0

2. My next problem was the following error:

./mysql-administrator

(mysql-administrator-bin:7476): Gtk-WARNING **: Unable to locate theme engine in module_path: "ubuntulooks",
Fontconfig warning: line 32: unknown element "cachedir"
Fontconfig warning: line 33: unknown element "cachedir"
Fontconfig warning: "/etc/fonts/conf.d/80-delicious.conf", line 18: invalid match target "scan"
./mysql-administrator-bin: symbol lookup error: /usr/lib/libbonoboui-2.so.0: undefined symbol: g_once_init_enter_impl

I eventually found this. The fix is right at the end.
To cut a long story short.

cd to where you have unpacked the gui tools
mv lib lib_
& if
/etc/mysql/conf.d does not exist
mkdir /etc/mysql/conf.d

3. My third and hopefully last problem was that I could not connect to localhost:3306
However I could connect to 127.0.0.1:3306
My /etc/hosts looked like this.

127.0.0.1 localhost
127.0.1.1 billspc

# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
I am not sure if this is a good fix but the cure was to comment out the line

#::1 ip6-localhost ip6-loopback

No comments: