Fritz!Box 7050 und Kabel Deutschland

Sorry for another German article:

Also, mein Ziel war es die Fritz!Box 7050 und Kabel Deutschland einzurichten. Dafür muss man ein bisschen tricksen. Das wird im folgenden Dokument recht gut beschrieben:

http://autohotkey.net/file/users/Members/Ace_NoOne/tmp/FRITZBox_und_Kabelmodem.jpg

VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Open Office Writer Spreadsheet Functions

When using spreadsheet functions in OpenOfice Writer application, beware that the syntax differs from the OpenOffice Spreadsheet application. An example is the ROUND function. To round to two decimals

  • OpenOffice Writer wants this syntax: ROUND(3,4567;2)
  • while OpenOffice Spreadsheet requires 3,4567 ROUND 2.
VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

AS400 Printing Din4 Format

So, here are the settings I am using right now for printing stuff in ignorance of a better solution using a printer emulation (sorry this is German as I do not have an English Client Access version):

Datei->Druckerkonfiguration:

  • PDT: nein

Datei->Seite einrichten->Ausrichtung:

  • Oberer Rand: 0 (wird auf 1,27 gesetzt sobald man den Dialog neu aufruft; einfach wieder 0 eintragen)
  • Linker Rand: 0 (wird auf 1,27 gesetzt sobald man den Dialog neu aufruft; einfach wieder 0 eintragen)
  • Autom. Seitenausrichtung: ja
  • Papierzuf. 1 – Ausr.: Druckverkleinerung
  • Papierzuf. 2 – Ausr.: Druckverkleinerung
  • Optimale Anpassung: nein

Datei->Seite einrichten->Seite einrichten: überall nichts ausgewählt

Datei->Seite einrichten->Erweiterte Optionen:

Codepage für Druckerschriftart: 1252

  • Kein CR zwischen Feldern: nein
  • Fett in Normalschrift drucken: nein
  • Druckstatusdialog anzeigen: ja
  • Rasterschriftwart verwenden: nein

Kommunikation->Konfigurieren…->Emulationstyp->Drucker->Konfigurieren…:

Nachrichtenwarteschlange: QSYSOPR (Standardwert)

Bibliothek: *LIBL (Standardwert)

Schriftart für iSeries-Druckdatei: Courier 10 (eine Änderung hier bewirkt gar nichts)

VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Conjugate Latin Verbs

For all of us who need to conjungate Latin verbs every now and then:

http://arts.cuhk.edu.hk/~lha/Latin_vocab/alphabete.html

VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Some fun youtube videos

Axis of Awesome – 4 Four Chord Song (with song titles)

http://www.youtube.com/watch?v=5pidokakU4I

The Best Stewart Ever !!

http://www.youtube.com/watch?v=pOJ40U9nQl0

VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Medical Myths

Here is a nice article about medical myths including:

  • People should drink at least eight glasses of water a day
  • We use only 10% of our brains
  • Hair and fingernails continue to grow after death
  • Shaving hair causes it to grow back faster, darker, or coarser
  • Reading in dim light ruins your eyesight
  • Eating turkey makes people especially drowsy
  • Mobile phones create considerable electromagnetic interference in hospitals.

Well, nice to know:

http://www.bmj.com/cgi/content/short/335/7633/1288

This article adds, that spinach, will not make you strong. Essentially this myth is based on the high amount of iron, which was overestimated by a factor of ten resulting in spinach being on the same level as broccoli. Oh, well:

http://www.sueddeutsche.de/wissen/mythen-in-der-wissenschaft-die-grosse-spinat-verschwoerung-1.985098-3

VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Kabel Deutschland Change IP

This is not tested by me, but according to a friend:

To change the IP-address assigned by Kabel Deutschland for your internet connection do the following:

  1. Unplug the modem from the router and from the cable connection and probably turning it off would be good also
  2. Asign a new MAC-address to your router (some router support this, others might not, sorry)
  3. Plug in the modem again

This should work according to a friend. I will test this if I have time.

VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Ubuntu: Mouse Buttons

Here is a nice tutorial how to bind mouse buttons to keys. I used this on my V220 Logitech mouse. It works seamlessly.

http://gaarai.com/2009/02/13/navigate-in-ubuntu-nautilus-using-the-mouse/

For more information about mappings look for the “-text” section in the “man xvkbd” manual pages.

VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

AS400 Codepages

OK, as I am from Germany I had trouble finding the right code page when using the iSeries Client Access printer emulation. It turned out that 1252 was the right one. Also the code page for the 5250 emulation would we 273.

VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

How to configure cygwin for sshd

This was needed to setup the ssh server for cygwin (http://mugurel.sumanariu.ro/windows/how-to-configure-cygwin-for-sshd/):

1. Download cygwin from http://cygwin.com/. Run the setup program and select the packages you want. The simplest thing to do is to get the default packages that are selected for you by the installer, plus “cygrunsrv” from the admin category and “openssh” from the net category. I found installing cygwin to be the easiest part of the process, and if you get stuck there’s lot’s of great help out there…

2. Edit C:cygwincygwin.bat. Make sure it contains the following setting for the CYGWIN environmental variable:

set CYGWIN=binmode tty ntsec

2. Start a cygwin bash shell. If cygwin installed correctly, you should be able to find it in start->programs->cygwin.

3. Make sure cygrunsrv is installed by typing “cygrunsrv -S sshd”. This is the command that will start the sshd server, but that’s not installed yet. If you get an error from cygrunsrv like “service does not exist” then you’re on the right track. If you get “command cygrunsrv not found” then go back over your install and make sure you get cygrunsrv.

4. Again from the bash shell, run ssh-host-config. Answer yes to the key generation questions. I found it easier not to use privilege separation. Answer yes to install as a service.

5. Start sshd with “cygrunsrv -S sshd” (“cygrunsrv -E sshd” shuts it down). At this point you should also have “Cygwin sshd” available as a service that you can start and stop from start->control panel->administrative tools->computer management – go to the services and applications->services list.

6. If all that went well, you should be able to ssh to the server(“ssh localhost -l loginName”). At this point only user accounts that existed before your cygwin install and had administrator access will work. This and the next step were the biggest gotchas for me in this whole game.

7. To enable a user to log in via ssh: You should know that sshd looks for information in the comments field of /etc/passwd and coordinates it with NT permissions. This was mentioned but not explained in the howtos I read.

Here’s how make it work: First, create the NT user and make them part of the administrators group.

Next, use the mkpasswd command to format a special passwd entry for that user. You can look at the output with the command “mkpasswd -l”. Then either cut and paste the info you need into your /etc/passwd file, or use the command “mkpasswd -l > /etc/passwd”.

This second will overwrite your existing passwd file. No matter what you do, make a copy of /etc/passwd before making any changes.

Create home directories for your users with the following commands:
“mkdir /home/userLogin”
“chown userLogin /home/userLogin”

Sshd only reads /etc/passwd once when it starts, so stop and start the server after you make changes to /etc/passwd.

I take it the mkgroup command does the same thing for /etc/group as mkpasswd does for /etc/passwd; I never needed to use it.

VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)