Fixing mysqltuner ERROR 1054 on Ubuntu Server 16.04

It was only last March that here at work we’ve updated our machines to Ubuntu 16.04 LTS, just a month before the 2018 edition of the server-ready realease of the Linux distribution that has come to be de ‘de-facto’ standard for Bioinformatics.

I am running mysqltuner to see how the server can be most finely tuned. Unfortunately the package still has problems (ie. in two years the updated version has not been back ported) so I am facing the mysqltuner ERROR 1054 on Ubuntu Server 16.04.

Here’s how I solved it, after a quick digging’ on my search engine:

cd /opt
git clone
cd MySQLTuner-perl
sudo mv /usr/bin/mysqltuner /usr/bin/mysqltuner.bak
sudo ln -s /opt/MySQLTuner-perl/ /usr/bin/mysqltuner

Then I’ve successfully ran my script. Enjoy!

via →


Linus Torvalds Explains How Linux Still Surprises and Motivates Him

“When I sat down and wrote Git, a prime principle was that you should be able to fork and go off on your own and do something on your own. If you have forks that are friendly — the type that prove me wrong and do something interesting that improves the kernel — in that situation, someone can come back and say they actually improved the kernel and there are no bad feelings. I’ll take your improved code and merge it back. That’s why you should encourage forks. You also want to make it easy to take back the good ones.”

Linus Torvalds, via →

Keeping ads out of my browsing with Pi-Hole

After discovering this project, I brought a Raspberry Pi 3 Model B from french company Kubii and started configuring it. I’m struggling to make it work, but I fear that the problem is with the wi-fi setting of my Raspbian connection.

Anyway give an eye to the Pi-Hole project

The Pi-hole is an advertising-aware DNS server that prevents ads from being downloaded. Once installed, configure your router to have DHCP clients use the Pi as their DNS server and then any device that connects to your network will have ads blocked without any further configuration. Alternatively, you can manually set each device to use the Raspberry Pi as its DNS server.

Tomcat 7, munin and Ubuntu 14.04

Lately I had to reconfigure an Ubuntu 14.04 server.
Dealing with Tomcat 7 I’ve encountered those two situations:

Enable larger file uploads via Tomcat manager

I had a ~180 war file to deploy. Ubuntu’s Tomcat setting put a limit at 50MB. This has been solved using the tips in this post by skotfred. Unfortunately I haven’t found a more orthodox way of achieving this other than modify the /usr/share/tomcat7-admin/manager/WEB-INF/web.xml in the values max-file-size and max-request-size.

Enable Tomcat monitoring in Munin

Here I’ve followed the tips over this Serverfault discussions.
Adding a [tomcat_ *] was the key.