Tschou zäme (*)
Weblog-Roller
Tuesday, 10. January 2012
Upgrade unison on QNAP NAS TS- 
In order to remember how this was done (again)…
- first you need the QPKG plugin installed, find this in your QNAP admin interface. To check if it's there run: /opt/bin/ipkg
- then upgrade your dusty packages using: /opt/bin/ipkg upgrade
- (unverified step) make sure ocaml is installed, otherwise run: /opt/bin/ipkg install ocaml
- download the unison version of your choice, eg: cd share/HDA_DATA/custom; wget
http://www.seas.upenn.edu/~bcpierce/unison//download/releases/unison-2.27.57/unison-2.27.57.tar.gz
- gunzip unison-2.27.57.tar.gz; tar -xvf unison-2.27.57.tar.gz
- Finally build unison in non-native (no native ocaml compiler or I don't know how to) and text style mode (no need for a GUI on the NAS): cd unison-2.27.57; make NATIVE=false UISTYLE=text

Friday, 28. May 2010
Netcetera CodeCamp 10.05 
To remember:

Friday, 05. March 2010
Felipe, in memoriam 
Today,
Felipe went from us. Deeply moved I am hardly capable to realize what mother nature asks us to accept.
In my eyes he was one of the most prominent open source contributors at Netcetera. But that was just his technical skill - moreover he was an enthusiastic, positive man that carried the sunshine inside him.
Lacking the proper words to describe what has happened I am trying to look forward for the bright memory of Felipe to supersede the sorrow.

Wednesday, 29. October 2008
Certa Fides online 
As a next domain I am happy to announce
http://www.certa-fides.ch and
http://www.certafides.ch to go online.

Thursday, 02. October 2008
MySQL root password - more troubles 
Once again some hickups when trying to update the mysql root password on my vserver.
Prolog :-)
First, mysql service won't restart:
[root@vs /]# service mysql stop
Shutting down MySQL. SUCCESS!
[root@vs confixx]# service mysql start
Starting MySQL................................... ERROR!
Trying to start with the command line shows something more:
[root@vs /]# /usr/sbin/mysqld --skip-grant-tables --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vs.vserver.de.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock
081002 16:40:12 [ERROR] Can't start server : Bind on unix socket: Permission denied
081002 16:40:12 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
081002 16:40:12 [ERROR] Aborting081002 16:40:12 [Note] /usr/sbin/mysqld: Shutdown complete
Took me a minute to find out that there's no mysql user on the system (any more?) and essential files were run with a strange uid up to now:
[root@vs /]# useradd -g mysql mysql
[root@vs /]$ ll /var/lib/mysql/
total 1556
drwxr-xr-x 6 644 mysql 4096 Oct 2 16:46 .
drwxr-xr-x 14 root root 4096 Mar 29 2006 ..
-rw------- 1 644 mysql 455 Oct 26 2007 .bash_history
drwx------ 2 644 mysql 4096 Mar 29 2006 confixx
-rw-rw---- 1 644 mysql 5242880 Oct 2 16:37 ib_logfile0
-rw-rw---- 1 644 mysql 5242880 Oct 26 2007 ib_logfile1
-rw-rw---- 1 644 mysql 10485760 Oct 2 16:37 ibdata1
drwx------ 2 644 mysql 4096 Oct 26 2007 mysql
drwx------ 2 644 mysql 4096 Mar 29 2006 test
drwx------ 2 644 mysql 4096 Feb 4 2008 usr_web1_1
[root@vs mysql]# chown -R mysql *
[root@vs mysql]# chown -R mysql .
Now, this looks better and even starting mysql works:
[root@vs mysql]# ll
total 1556
drwxr-xr-x 6 mysql mysql 4096 Oct 2 16:46 .
drwxr-xr-x 14 root root 4096 Mar 29 2006 ..
-rw------- 1 644 mysql 455 Oct 26 2007 .bash_history
drwx------ 2 mysql mysql 4096 Mar 29 2006 confixx
-rw-rw---- 1 mysql mysql 5242880 Oct 2 16:37 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Oct 26 2007 ib_logfile1
-rw-rw---- 1 mysql mysql 10485760 Oct 2 16:37 ibdata1
drwx------ 2 mysql mysql 4096 Oct 26 2007 mysql
drwx------ 2 mysql mysql 4096 Mar 29 2006 test
drwx------ 2 mysql mysql 4096 Feb 4 2008 usr_web1_1
[root@vs mysql]# service mysql start
Starting MySQL SUCCESS!
Changing MySQL password
Finally, the interesting part, start mysql with the --skip-grant-tables option:
[root@vs /]# service mysql stop
Shutting down MySQL. SUCCESS!
[root@vs /]# /usr/sbin/mysqld --skip-grant-tables --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vs.vserver.de.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock
And (in another shell) change the root password:
[root@vs /]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 3 to server version: 4.1.22-standardType 'help;' or 'h' for help. Type 'c' to clear the buffer.mysql> UPDATE mysql.user SET Password=PASSWORD('xxxx') WHERE User='root';
Query OK, 2 rows affected (0.02 sec)
Rows matched: 2 Changed: 2 Warnings: 0mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)mysql> exit
ByeRestart the mysql service, and see: Login as root works again:
[root@vs /]# mysql -u root --password=xxxx
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 4.1.22-standardType 'help;' or 'h' for help. Type 'c' to clear the buffer.mysql>

Last but not least
This page is maintained in english mainly but you may find some occasional german snips. Even tough this webpage is run by a
Wiki software, the pages are not publicly editable.
(*) "Tschou zäme" is a greeting in Swiss German that says "Hi everyone". It is particularly from the area where my roots are: The
Emmental region near
Berne, Switzerland. And yes, indeed, this is where the famouse
Emmental Cheese has it's origin :-)