If you’re using Fedora 10, and are a KDE desktop user, you’ll notice that your latest KDE 4.2 update, requires having a local MySQL server installed. This is due to Akonadi, part of the KDE PIM packages, that now rely on MySQL as a default server, for storing PIM data. Just a few months ago, I mentioned the news that Amarok 2 will also use MySQL as a default database.

Akonadi uses MySQL mainly as a cache, not as a data store. This is something that Debian users will also see. Eventually, anyone with KDE 4.2 will see the requirement to have a MySQL server installed. If you already have a native installation of MySQL

John Lilly, CEO of Mozilla, shares some insights and thoughts on Mozilla, and its a most interesting presentation to go through. The insights are (drizzled with some of my comments):

Recently, I had to futz with an Ubuntu server that was to run mail, web, and database services.

You slowly learn that Ubuntu as a desktop is easy to use, but as a server, its “different”, if you come from a Red Hat based background (especially if you’ve been using Red Hat-based distributions for the last thirteen years or so).

From example, while service httpd start works (well, the equivalent is service apache start), enabling things on boot using chkconfig (I wrote about it a while back) is replaced with update-rc.d.

In fact, if you’re an rpm aficionado, dpkg is a little different. I applaud the Ubuntu folk for creating an article such as

So, you want to compile Workbench for Linux, on Fedora 9. You need to install the following packages:

autoconf automake libtool libzip-devel libxml2-devel libsigc++20-devel libglade2-devel gtkmm24-devel mesa-libGLU-devel mysql-libs mysql mysql-devel uuid-devel lua-devel glitz-devel glitz-glx-devel pixman-devel pcre-devel libgnome-devel gtk+-devel pango-devel cairo

I feel I’m being too liberal with dependencies, but I’m not about to strip it, I just want to get it working first :)

You need to have ctemplate and ctemplate-devel installed from updates-testing-newkey (relevant koji build log).

By default, configure.in in Workbench looks for “google-ctemplate”, as opposed to just “ctemplate” as

As you may know mysql fulltext search is not highly scalable.  One of the options to get around this scalability limitation, which I prefer, is to use Sphinx.  You can use Sphinx with out having to alter your mysql installation.  But, if you would like to use from within mysql and not have to worry about how to pass data between Sphinx and MySQL, you can enable sphinxse (sphinx storage engine).  It is not included with mysql by default so you will have to compile it yourself.

Here are the instructions on how to get sphinxse compiled with your mysql installation on CentOS x64.  I am sure same instructions will work for other flavors but I have not tested it.  I will be compiling the most current version of sphinx (0.9.8) with most current stable version of mysql (5.0.51b) at the time of the writing.  Let’s get the

Red Hat releases Spacewalk. It is described as: “the upstream community project from which the Red Hat Network Satellite product is derived“. Congratulations to all whom have worked on it, especially my friends who tired endlessly over it in the past.

Red Hat, is sticking true to its promise, of open sourcing everything they make. Best of all, they recognise Fedora (they always did, since say, Fedora Core 2 or 3), CentOS (a direct “competitor”/rebuild of RHEL), and Scientific Linux (I know of a certain university’s sysadmin who will be blessing Spacewalk, as her life will now be a lot easier).

There have been a few blogs about it… Matt Asay asks about a community (Red Hat traditionally

The second half of last week I attended the Red Hat Summit and FUDCon which Sun and MySQL were silver sponsors of.  The events were co-located at the Hynes convention center in Boston. 

Although both events featured an impressive list of topics and tracks, other than the keynotes I spent the majority of my time meeting and talking to people.   One of my goals was to figure out how Sun can better work with Fedora to get more of our software into their distro. 

A few key Fedorans: Max Spevak, Dennis Gilmore, Tom "Spot" Callaway, Jeremy Katz, Paul Frields, Jesse

The second half of last week I attended the Red Hat Summit and FUDCon which Sun and MySQL were silver sponsors of.  The events were co-located at the Hynes convention center in Boston. 

Although both events featured an impressive list of topics and tracks, other than the keynotes I spent the majority of my time meeting and talking to people.   One of my goals was to figure out how Sun can better work with Fedora to get more of our software into their distro. 

A few key Fedorans: Max Spevak, Dennis Gilmore, Tom "Spot" Callaway, Jeremy Katz, Paul Frields, Jesse

The second half of last week I attended the Red Hat Summit and FUDCon which Sun and MySQL were silver sponsors of.  The events were co-located at the Hynes convention center in Boston. 

Although both events featured an impressive list of topics and tracks, other than the keynotes I spent the majority of my time meeting and talking to people.   One of my goals was to figure out how Sun can better work with Fedora to get more of our software into their distro. 

A few key Fedorans: Max Spevak, Dennis Gilmore, Tom "Spot" Callaway, Jeremy Katz, Paul Frields, Jesse

As promised, after individual presentations at last week's CommunityOne I brought together the community leaders of three of the top GNU/Linux distros (Zonker Brockmeier, OpenSUSE; Jono Bacon, Ubuntu; Karsten Wade, Fedora), threw in Glynn Foster of OpenSolaris and moderated a no-holds-barred panel.  (It took them three hours to clean up the blood afterwards!!)

Although the panel itself wasn't recorded, immediately after it concluded, the five of us headed to the make-shift podcast studio we had set up at the event and recorded the following

Here are a few pictures from earlier this week taken at CommunityOne and day one of JavaOne. 

Podcasts a comin'

In the next few days I will also be posting a bunch of podcasts I did while in San Francisco including a bunch from key OpenSolaris folks, a post-Distro-smackdown recording,  an interview with the Fedora IcedTea guys and a chat with the JRuby dudes.

Buddy of mine asked me a question over chat today: “how do I show my machines’ IP at login prompt with out logging in?” He is referring to his Virtual Machine in this case. He does not want to have to log in to the server to see what ip it has (since its on dhcp) for him to ssh in or hit it from the browser. I could have answered him with a simple how to but what is the fun in that? So I decided to give some background on how login prompts are done and show what can be done.

When Linux server boots up, it calls a program called mingetty. This program creates that infamous login prompt as show in a screenshot:

You can see how server calls the mingetty program by looking at /etc/inittab. You will see a block like below:

# Run

I was at MODM4 yesterday, and as always, great fun was had. One common recurring theme though, was getting MySQL to start automatically upon a Linux server’s restart, something which I would have thought just came pretty naturally to sys-admin types. Upon further probing, these systems were all generally CentOS or RHEL based, and it wasn’t just MySQL that gave them problems - it was anything they’d installed out of the stock packages (lighttpd was a popular Apache replacement, that suffered from the same fate).

While I didn’t recollect the exact part of the manual it was stored in, I was informing everyone to make use of the chkconfig tool. Its really as

Today I saw an interesting opinion posted on a mailing list. I’ll quote from the fedora-list post:

What folks say here cant be taken as Fedora toting anything. It is just some user opinions.

Some of those “user opinions” came from @redhat.com addresses, I actually don’t take any notice of @anydomain.blah posters, as they are just like I, posting a personal opinion, but when you post with @redhat.com, it is next best thing to an official comment.

And I’m wondering, is this true with all users? Does it matter if the post comes from @projectname.com or not? Are your opinions more valued if you’re employed by an open source company or the project in question?

I personally think its silly. If I make

Don’t know how many of you actually have heard of, or use, Mugshot, but I just started playing with it after a long hiatus, and decided that it’s pretty cool. Something the MySQL community will probably enjoy being part of (currently, to take full advantage, you want to be a Linux or Windows XP user).

By virtue of looking for the next new community hangouts, I figure we create a MySQL Mugshot Group. And before folk wonder what Mugshot’s all about, I suggest reading the feature list. Keep in mind that Mugshot is completely open source, and its a very live social experience, in this “notification era”. Its a whole lot of fun, and from what I can tell, the signups are now open to the public so

So I got to speak to MIlton Ngan right before his closing keynote. I don’t know where we got the idea that they (Weta Digital) ran Fedora, because all they’ve had are a bunch of Red Hat 9 machines as well as a few Debian. They seemingly are moving fully to Ubuntu real soon now. As always, sticking with MySQL.

Oh, and watch out for X-Men 3, out on May 19th…

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

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

As Kaj has mentioned, I’ll be at Linux Asia 2006, from the 8th till the 10th of February 2006. FUDCon Delhi 2006 is happening on the 9th, and I’ll be speaking on MySQL and Fedora: A Developer’s Overview. I think this fits well with the “developer, developer, developer!” theme thats going around these days…

David Axmark is also going to be around at the main conference, both at the Intellectual Property & Open Source panel, and giving us a conference keynote on Friday.

Plan on meeting a lot of people, have a few MySQL-related meetings and am generally excited to see Greg and the rest of the Fedora

Red Hat Magazine this month (well, okay, last month, I’m clearing out my tabs), has a feature on Linux and Asia. Of interest were:

• What does open source mean in India? - an interview with Javed Tapia (Director, Red Hat India), showing why India finds OSS important (software costs too much), how localisation works, and a bit about Red Hat India.
• Asia, the questions we ask - a great read, written by Michael Tiemann about his experiences in Asia. A question of interest: “What will be Singapore’s role in the technology industry of the 21st century?” I think thats the question most countries want the answer to, be it Malaysia or

• alias skedit='open -a skEdit' is highly useful. Now I can do skedit foo.php and it opens it up. What joy with such simple things.
• Great to see Mono go into Rawhide, meaning FC5 Test 2 will have it. Now I can’t hardly wait. On PPC, if we had Xen working (upstream), life would be the ultimate breeze.
• I will not be making it to linux.conf.au 2006 in New Zealand. Despite all good attempts to get a flight leaving KL, I can’t. Well, affordably (hello coach class). Registrations however are still open. There’s a Red Hat/Fedora meetup, and Joshua Wulf would be a useful person to contact if you’re rocking up for it (email discussion still has dates
• Is there a reason Fedora disabled updatedb running by default? Now users actually need to specify yes, in /etc/updatedb.conf. Why? Was this for laptop

Arjen Lentz: King Kong and MySQL…:

Arjen mentions that Weta Digital in New Zealand uses MySQL. For further mention, these folk use Fedora Core for their OS. I have an appointment to talk to their press people sometime in mid-January to discuss their Fedora use; I guess now I’ll aim to find out more about both.

Oh, and Halo, that popular Xbox/Microsoft game, is to be a movie. Powered by Fedora and MySQL :)

Arjen was mentioning about the perks of working at MySQL. It got me interested, so I joined them :) So I guess this is my change in affiliation announcement.

A timely photo from William, that I scanned in… (circa a couple of years back)

I don’t know if I can talk about what I do yet (I’m a Community Engineer). I already have a task on hand, but I guess there are meeting times to work out, and other stuff. I’m rather excited, and my drive (that was lost for a while) is back. I’m not leaving any mentioned project either, in fact I think my Fedora goodness should be stepped up, as will the OOo (db related) stuff.

Arjen was mentioning about the perks of working at MySQL. It got me interested, so I joined them :) So I guess this is my change in affiliation announcement.

A timely photo from William, that I scanned in… (circa a couple of years back)

I don’t know if I can talk about what I do yet (I’m a Community Engineer). I already have a task on hand, but I guess there are meeting times to work out, and other stuff. I’m rather excited, and my drive (that was lost for a while) is back. I’m not leaving any mentioned project either, in fact I think my Fedora goodness should be stepped up, as will the OOo (db related) stuff.