[ start | index | login ]

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
PermaLink
no comments | post comment

Friday, 28. May 2010

Netcetera CodeCamp 10.05

To remember: PermaLink
no comments | post comment

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. PermaLink

no comments | post comment

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.

PermaLink

no comments | post comment

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] Aborting

081002 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-standard

Type '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: 0

mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec)

mysql> exit Bye

Restart 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-standard

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql>

PermaLink

no comments | post comment


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 :-)

search www.stefanrufer.ch
Google

Content

Me?


Blog Calendar

< May 2012 >
SunMonTueWedThuFriSat
12345
6789101112
13141516171819
20212223242526
2728293031

Weblog summary 2007, 2006, 2005, 2004


Content managed by SnipSnap

M

snipsnap.org | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt