zeldor.biz

Linux, programming and more

The Pledge of the Network Admin

by Leave a Comment

Never heard about it:

This is my network.
It is mine
or technically my employer’s,
it is my responsibility
and I care for it with all my heart
there are many other networks a lot like mine,
but none are just like it.

I solemnly swear
that I will not mindlessly paste from HOWTOs.

from Peter N. M. Hansteen

MySQL Error Codes

by 1 Comment

Sometimes you need a good reference, and this is one of those times. MySQL’s perror command returns many error codes, and I’ve provided a listing here. To find errors individually, just run:

1
2

# perror 28
OS error code  28:  No space left on device

[Read more…]

Generate self-signed certificate

by Leave a Comment

Quick and easy – generate self-signed certificate in one line:

1

openssl req -new -newkey rsa:4096 -days 365 -nodes -x509 -keyout ipv6.mysql.idrobot.net.key -out ipv6.mysql.idrobot.net.crt

Country Name (2 letter code) [AU]:DE
State or Province Name (full name) [Some-State]:Niedersachsen
Locality Name (eg, city) []:Hannover
[Internet Widgits Pty Ltd]:ipv6.mysql.idrobot.net
Organizational Unit Name (eg, section) []:
Common Name (eg, YOUR name) []:Igor Drobot
Email Address []:id@drobot.de

Parse kernel.org changelogs

by Leave a Comment

Parsing kernel orgs changelogs can be a pain.

Here’s a handy one-liner to make it easier to read:

1

wget --quiet -O - http://www.kernel.org/pub/linux/kernel/v2.6/ChangeLog-2.6.37 | grep -A 4 ^commit | grep -B 1 "^--" | grep -v "^--"

You should become human readable output like this one:

1
2
3
4
5
6
7

    perf: Remove unused variable
    x86, bios: By default, reserve the low 64K for all BIOSes
    mlx4_en: Fix build warning in mlx4_en_create_rx_ring.
    mlx4_en: updated driver version
    mlx4_en: Moving to work with GRO
    mlx4_en: UDP RSS support
    mlx4_en: reconfiguring mac address.