A quick reminder to myself on the things to do when you decide to upgrade PHP (and subsequently MySQL for a “nasty” php-mysql dependency problem) on a stock, running CentOS / RHEL server.

You can encounter a number of errors like the
ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist
when you do a simple FLUSH PRIVILEGES; command or worst.

The solution that has worked for me, and that you HAVE to do each time you upgrade (manually, via RPM or DEB) the MySQL server is to launch this command BEFORE you do anything else:
/usr/bin/mysql_fix_privilege_tables --password=$your-mysql-root-password.

Another solution could be the one explained here, but on my servers the before mentioned command worked smoothly!

Did you ever find yourself at work with a remote session on your Ubuntu server (or workstation) invoked by ssh -X command and needed to launch users-admin or some similar graphical application that need a sudo (or root) authentication to work?

Did you ever got frustrated of not having the possibility to enter or see accepted your password ?

Well, here’s how to resolve this! All you need to do is invoking this command:
sudo ck-launch-session $command &

For example, when I needed users-admin (to graphically add a new user, modify or delete an old one) giving the aforementioned command, after having inserted my sudo password, I got this window

Ubuntu users-admin, remotely called

P.S. = if you can help me with a shorter or clearer post title I’ll be grateful (remember english isn’t my mother tongue!!!)

centos logo During last weeks I’ve installed and configuread a 64bit RHEL server, paying attention to include the open source java-openJDK and the official Sun’s JRE.

This morning a colleague called me via skype telling me that his Firefox didn’t have a proper Java plugin installed. At first glance I didn’t knew what to do and the first results of a Google’ session were useless refferring to old incompatibility between a 64bit Firefox and 32bit java vitual machine, old releases of both softwares, wrong *.so files to include.

Google and google I found this post, pointing the focus on the libnpjp2.so file which, on my machine, is placed under the /usr/java/jre1.6.0_16/lib/amd64/libnpjp2.so path.

So I went to /usr/lib64/firefox-3.0.14/ folder {ignoring the old ones visible on the directory}, created a sub-directory called plugins (as root) and gave the command:

ln -s /usr/java/jre1.6.0_16/lib/amd64/libnpjp2.so libnpjp2.so

The I restarted Firefox and once loaded went to the Java Test Page to check my virtual machine installation and witnessed the correct, and aspected, result:

Your Java configuration is as follows:
Vendor: Sun Microsystems Inc.
Version: Java 6 Update 16
Operating System: Linux 2.6.18-164.2.1.el5
Architecture: amd64

Hope this will be useful to you too!

mPlayer OSX extended My 2003 post on how to see Matroska encoded videos on Mac OS X in these two years has proven to be on of (if not the) most successfull post of this blog.

Well, two years later I’ve discovered the mPlayer OSX extended project, which updates the mPlayer binary code to an updated code base.

Let’s see together what it’s all about:

MPlayer OSX Extended is an unofficial extension of the MPlayer OSX user interface.

Development on the official MPlayer OSX frontend has been slow in recent years and MPlayer OSX Extended tries to change that.

… [CUT] …

Additions to the original project include:

* Fullscreen controls
* More video filter options (Postprocessing, Deinterlace etc)
* Support for styled ASS subtitles
* Audio and video equalizers (not yet interactive)
* Taking Screenshots
* Stream selection
* Automatic updates
* Up-to-date compiled versions of MPlayer
* Many interface improvements
* Many bug fixes

So, what you’re waiting for? Point your browser and download your copy

Hi!
Today I’d like to spend some words on a particular Open Source project which aims to make know, test and finally use the available tools for molecolar biology, bio-technologies and bio-informatics in general.

This world is overwhelmed by a number of “tools” divided in an ocean of productors, licences, repositories and kind of package (rpm, deb, Z, tar.gz, plain code…).

Enter Bio-Linux.

The Bio-Linux project starts from a branch of UK’s NERC (National Environment Research Council) dealing with biology.

This NEBC proudly has took in hand this shattered cosmo of open source software for bioinformatics under his own “umbrella” and then has gone further … has created a full GNU/Linux distribution, building over the solid core of Ubuntu (on it’s Long Term Support 8.04 release).

Today Bio-Linux 5 is:

  • a LiveCD operating system;
  • a fully functional operating system running on desktop and servers alike;
  • a bioinformatics repository for Ubuntu

and all this is fully supported and given the news on the NEBC and NERC there’s money to guarrantee that for the expectable future.

Personally at work I’ve had chance to appreciate this distro in all the flavours listed above and also as a VMware’s appliance.

If you’ve already running an Ubuntu 8.04 box in this wiki page you’ll find how-to add the biolinux repository to your sources.list. There it’s also stated that there’s some kind of compatibility with Debian and also with the latest 9.04 release, even if for a couple of software there are occasional bugs.

But, on the workplace, expecially when the user has to USE his desktop and not work to make it run, Ubuntu 8.04 (with an updated copy of OpenOffice and a couple of backports) it THE way go, at least for me.

As a personal, final note, I must regret on the strickt control of the repository … I’ve witnessed a similar Biolinux project, focused on the RPM world being abandoned in 2007 supporting ancient distros like Fedora6 and RedHat 9 … I’d prefer a strong team in the Ubuntu (or $distro) community claiming “we will take care of all things bioinformatics, like it’s done for Compitz or other focused projects in the past.

A change of menthality is needed so, when the Public Administration (or a private) invests on an open source technology the RoI must be seen in the product itself (and/or on how it facilitates works or makes you make more money increasing the productivity) and not in a self-owned fancy site claiming “I MADE IT, I AM BIG, GIMME MORE MONEY”.

Don’t you think so?

Next Page »