I had an exciting weekend at the FOSDEM Conference in Brussels. Initially I planned on writing a few blog entries while at the event (while memory was still fresh), but the Internet access there was very flaky and it was almost impossible to get a working wireless connection. So here is my (slighly belated) writeup.
Continue reading "FOSDEM writeup"

Later today I will be heading off to the sixth Free and Open source Software Developers' European Meeting in Brussels, Belgium. I look forward to the various sessions and meeting with the members of other Open Source projects, especially the folks from the openSUSE team. I hope this meeting allows me to build closer relations to other OSS projects that use or support MySQL in any way.

See you there! After having checked into my hotel tonight, I'll try to find my way to Le Roy d'Espagne to meet with others that arrived today.

There was a request to take a gander at the $100 Laptop: One Laptop Per Child (OLPC), and reading Fedora People recently made me want to snap up the opportunity to give it a go. Here are my first impressions on the emulator, known as the OLPC SDK, by Daniel Berrange.

Installation, if instructions are followed on FC-4 work fine. There are spec files to rebuild for FC-5. During the bootup sequence, I noticed that LVM was starting up, and finding no volume groups - can’t this be disabled? There doesn’t seem to be a use for LVM on the OLPC.

Once you get past the fairly slow emulator startup (its qemu based), you’ll notice that at the heart of it, you’ve got FC-5 sitting there. Very sexy.

Looking for a terminal? While gnome-terminal isn’t supplied (and probably will never be), xterm …

In the last minute life of Colin, I managed to get a flight on Tuesday to head to Singapore for Mark Shuttleworth’s Ubuntu Asian Business Tour, pretty much in the nick of time. It was a complete rush from getting the tickets, to reaching the hotel, and getting to the Singapore Management University (arrived only five minutes past!). The LUGS meets are large - going by the numbers, it seemed larger than what we have at LUV in Melbourne, and definitely greater than the MYOSS meetups.

Mark is an excellent speaker, who told us about Ubuntu’s place in the market, and all the cool things Canonical is doing to extend its reach. Being on a tight schedule, he didn’t stick around for after-talk discussions, but quite a number of other folk did. Harish Pillay (RH’s CTA in Singapore) had a couple of boxes of Fedora Core 4 giveaways, which a lot were pleased to snap up!

So I stuck around to have some dinner, and realised something …

These are my first impressions of MySQL WorkBench 1.0.1. Rant and rave you may say, but a new user, or an experienced modeller would probably observe these points. Also, given that (with a poll?) I suspect a good number of users will be previous DBDesigner users, some level of functionality that may not be considered initially in a new product, should be considered for this migration path of legacy users.

I’ll take the time to review the Forums adding my points, and review Bug System but for now, just blogging is easier.

Conclusion

Note: Generally a conclusion is at the bottom, but I’d suspect most readers will switch off …

By now, I’m sure you have all heard about Free VMware Player allowing easy and quick access to see, view and use other OS’s easily. For those Windows users out there, now is your chance to trial MySQL under Linux with no impact to your system, why wait.

See the MySQL Virtual Machine details on the VMware site. On closer inspection this effectively pushes you to the VMware Technology Network (VMTN) page within the MySQL website.

The MySQL guys needs to update their site to reflect new reference to the free player, rather then a trial version of Workstation. Even VMware Server is free (could be mentioned). You can read more about the offerings etc at a …

I must admit I’d given up trying to get MySQL Workbench working under Linux. I guess I’d spent at least 4 or 5 days full time at it, and it was just out of my league, with GTK and C++ errors. It had seemed like a loosing battle, I’ve had 3 detailed documented goes at 1.0.0. Last Post 19th Jan, and 2 with 1.0.1 Last Post 31st Jan.

Anyway, the good news is I now have MySQL Worbench working under Linux. I’ve been working with MySQL AB on a number of specific problems and you should expect a release from MySQL AB soon to address these. Here is a summary of my experience.

• 1.0.1 removes the requirements for java dependancies
• 1.0.1 provides a README.linux with configuration requirements, and a subset list of minimum library …

Let’s review the problem. I’ve got this on a number of occasions and different libraries. Here are some typical error conditions.

./mysql-workbench-bin: /usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.5' not found (required by ./mysql-workbench-bin)
Error: Missing Dependency: libstdc++.so.6(GLIBCXX_3.4.6) is needed by package glibmm24

Special thanks to my new Guru friend Alfredo who put me on the path.

$ su -
$ cd /src/rpm
$ wget ftp://rpmfind.net/linux/fedora/extras/4/SRPMS/libsigc++20-2.0.11-1.src.rpm
$ rpmbuild --rebuild libsigc++20-2.0.11-1.src.rpm
$ cd /usr/src/redhat/RPMS/i386/
$ rpm -Uvh libsigc++20*.rpm
Preparing...                ########################################### [100%]
   1:libsigc++20            ########################################### [ 50%]
   2:libsigc++20-devel      ########################################### [100%]

Woot! It was that simple, download the rpm source, …

Following my earlier post of MySQL Workbench 1.0.1 for Linux and logging a MySQL Bug, I’ve had the Bug verified, and the a further update of a compiler success. Details of compile from Bug #16880

Compiled with:

- glibmm-2.8.1
- gtk+-2.8.8
- libsigc++-2.0.11


I’ve got:


libsigc++-2.0.17
glib-2.6.6
glibmm-2.6.1
atk-1.9.0
pango-1.8.2
gtk+-2.6.9
gtkmm-2.6.5
lua-5.0.2


So starting with the obvious downgrading of libsigc++


$ su -
$ cd /src
$ wget http://ftp.gnome.org/pub/GNOME/sources/libsigc++/2.0/libsigc++-2.0.11.tar.gz
$ tar xvfz libsigc++-2.0.11.tar.gz
$ cd libsigc++-2.0.11
$ ./configure …

As requested by Frank, here are the working parts of my earlier Downgrading a MySQL schema from 5 to 4 article.

The Problem

To recap, I received a MySQL Version 5.0 schema via a sql file, however I was unable to upgrade from MySQL 4.0 to MySQL 5.0 on my old RedHat 7.3 production server. As an interim solution, I still wanted the schema and data to allow for initial development (without the 5 specific features including Views,Triggers and Procedures/Functions). However the MySQL 5.0 SQL file would not run in MySQL 4.0.

Sample

Here is a small subset of the MySQL Sakila Sample Database schema to demonstrate the problem.

DROP SCHEMA IF EXISTS sakila;
CREATE …