Tschou zäme (*)
Weblog-Roller
Friday, 28. May 2010
Netcetera CodeCamp 10.05 
To remember:
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.
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. 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!
[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
[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 .[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
[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
Bye[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>no comments | post comment
Friday, 19. September 2008
DLink DIR-301
Our old WLAN router seems to have passed out after about five years. Just shopped a new DIR-301 without knowing too much.Internet requests were slow, slow, slow especially when sent the first time to a new URL. Only some tweaking allowed me to work reasonably fast:
- Disable DHCP rely (didn't help that much)
- Switch off UPnP, WAN Ping Respond, GAMING Mode, Multicast Stream
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 aWiki 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
Content managed by SnipSnapM
Content
- Stefan Rufer
- Gabi Rufer
- Leon Rufer
- Finn Rufer
- Projects
- Do It!
- Virtual Brain
- Bücher
- Motorrad
- Kochen
- Photos
- Links
- CV
Blog Calendar
Weblog summary 2007, 2006, 2005, 2004Content managed by SnipSnapM