Nothing serious!

Kubuntu 18.04 review - it's FOSS

Solve authentication issue on mariadb

When installing Mariadb on Ubuntu I always have the problem of root password not set and authentication plugin set to unix_socket. The commands below solve the issues.

  • Change to root

sudo -s

  • Stop Mariadb server

systemctl stop mariadb

  • Start Mariadb in safe mode

mysqld_safe --skip-grant-tables --skip-networking &

  • Log into mariadb as root without password

mysql -u root

  • Change to mysql DB

USE mysql;

  • Change the root password

UPDATE user SET password=PASSWORD("new_password_here") WHERE User='root';

  • Set the authentication plugin to default

UPDATE mysql.user SET plugin = '' WHERE user = 'root' AND host = 'localhost';

  • Reset privileges

FLUSH privileges;

  • Exit from Mariadb


  • Restart Mariadb server

systemctl stop mariadb

systemctl start mariadb

After this you should be able to log into mysql with your root password. Tested on Ubuntu 17.10 & 18.04

Bobber Ready!


Bobber work in progress

Custom Bobbers @ swiss-moto 2018

The customized Bobbers seen @ swiss-moto

Bash script to encode all movies in folder

Just a little bash script to encode all movie files in a folder and save them in another folder:



cpulimit -e $HANDBRAKE_CLI -l 80 -b

for FILE in "$SRC"/*
    filename=$(basename "$FILE")
    $HANDBRAKE_CLI -i "$FILE" -o "$DEST"/"$filename".$DEST_EXT "$PRESET"

killall cpulimit

It requires HandBrake CLI and cpulimit.

Adapt the extension, preset, source & destination path to your needs.

I used cpulimit to make sure the VM where I am running this script will not get stuck.

Ruby on Rails, mariadb, RVM on Debian

I am from time to time trying some Ruby on Rails dev on my machine.

Installation of RVM & mariadb is usually straightforward on *buntu systems, it is a liitle bit more tricky on Debian.

For RVM the easiest is to use the instructions from the official RVM page.

The installation script will try to install the dependencies using sudo:

\curl -sSL | bash -s stable --ruby

and it fails as sudo is not install by default on Debian.

# apt install sudo

Will do the trick, after you need to modify the /etc/sudoers file to add your user to the sudoers group. Add the following line to /etc/sudoers and you are done!

myuser  ALL=(ALL:ALL) ALL

RVM will install all dependencies and stable ruby.

Install mariadb is trivial (but sometimes you will need to set or reset the root password => google is your friend)

The mysql gem will require the installation of the default-libmysqlclient-dev package to run correctly.

Lastly execute the following SQL commands to be able to execute mysql without sudo (it will save you time when creating a RoR application based on mysql):

UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';

flush privileges;

And restart mysql service.

Installation of Debian Testing on MacBookPro12,1

After using Ubuntu 17.10 on my mac (MacBookPro12,1) and removed all stuff created by Ubuntu to recover vanilla Gnome, I realized that Debian Testing will bring the same level of comfort without additional irrelevant stuff.

After Downloading & burning on a USB stick the Debian Testing image the installation starts correctly (Press alt key during mac boot to boot from USB stick).

The wifi network card is not installed by default as the proprietary drivers is not there.

After the reboot I connected to internet using my iphone over Bluetooth.

I configured the sources.list file like this:

deb testing main contrib non-free

deb-src testing main contrib non-free

deb testing-updates main contrib non-free
deb-src testing-updates main contrib non-free

deb testing/updates main contrib non-free
deb-src testing/updates main contrib non-free

The installation of the firmware-brcm80211 package from non-free repository & computer reboot I was able to connect to wifi.

Synology DS918+

My previous NAS (Qnap TVS-473) had too many issues since I bought it. I send it back to QNAP under warranty and have been reimbursed.

Looking for a similar model in the same range I chose a Synology DS918+. After one day, I must say it is a very good product. The all plastic box looks less solid than the QNAP but it is well finished.

The interface is good and configuration is really simple.

Even with the basic setup (4 GB RAM) and 4 seagate HDD (3 To) the NAS is performing quite well.

  • Plex media server
  • Virtual machine running a custom web site
  • Logitech Media server application

I have ordered 8GB additional RAM to be comfortable. Synology is proposing only 4GB but I found some nice guys sharing their experience to upgrade RAM (synology forum, Disczone)

Altered Carbon