Syslog-ng and MySQL

June 4th, 2009 6 comments

Just a quick note about Syslog-NG with an mysql backend.

# UDP Syslog Port Listener
source s_udp {
    udp(
        ip('192.168.0.1')
        port(514)
    );
};

# MySQL Destination
destination d_mysql {
    sql(
        type(mysql)
        host("server") username("syslog") password("syslog")
        database("syslog")
        table("logs")
        table("messages_${R_YEAR}${R_MONTH}${R_DAY}")
        columns("datetime", "host", "program", "pid", "message", "facility", "priority")
        values("$R_DATE", "$HOST", "$PROGRAM", "$PID", "$MSGONLY", "$FACILITY", "$LEVEL")
        indexes("datetime", "host", "program", "pid", "message", "facility", "priority")
    );
};

# Log the source to the destination, pretty straightforward
log {
    source(s_udp);
    destination(d_mysql);
};

As you can see it is a pretty easy configuration which turned out working great without any crappy connections like fifo’s. Besides that it creates a new table per day (it will create tables automatically), and thanks to the table per day tables stay fast enough for some more advanced features.

Off course this will work with every distribution (ubuntu, centos, redhat, suse, archlinux) where you can install the binaries of syslog-ng which include the necessary MySQL libraries as you can see in the comments below

Tags: , ,

Time Machine Unsupported Volumes

May 27th, 2009 No comments

Open up a terminal session and enable NAS support for Time Machine: defaults write com.apple.systempreferences TMShowUnsupportedNetworkVolumes 1

See: http://www.naschenweng.info/2008/07/15/os-x-time-machine-backup-to-synology-ds1

Tags: ,

system-config-cluster no fonts

May 13th, 2009 No comments

Just a quick note cause I’m able to constantly forget. When you see the following message when starting system-config-cluster:
No fonts found; this probably means that the fontconfig
library is not correctly configured. You may need to
edit the fonts.conf configuration file. More information
about fontconfig can be found in the fontconfig(3) manual
page and on http://fontconfig.org

Install the following package:
dejavu-lgc-fonts

Toppie! ??? Toppie?

May 8th, 2009 No comments

Het komt weer terug. Radio, TV, en over een tijdje vast weer internet. Ik hoor het overal, en word er nu al moe van. Waar komt het vandaan. Wie heeft het bedacht. Ooit was er Jop (de Bus [sbs6]) die ermee kwam. Er kwam een commercieel succes voor hem. Een leuke eendagsvlieg en het was over.

Maar het is dus terug. Ik waarschuw; het is terug en heftiger dan ooit

Twitter

April 24th, 2009 No comments

Started twittering. Follow me @ http://twitter.com/kerneldump

Tags: ,

Sometimes

April 15th, 2009 No comments

it feels like hanging on to the past because I don’t want to go forward…

Tags:

Vaarwel Paul

March 30th, 2009 No comments

Wohin ich geh’? Ich geh’, ich wandre in die Berge.
Ich suche ruhe für mein einsam Herz.

“Oom” Paul

24-03-1931 – 25-03-2009

Een korte, kleine emotionele uitvaart. Een mooi moment, gekerft voor eeuwig, in mijn hart. Vaarwel Paul, fijn dat jij er was.

Ook al was het geen familie. Kende ik je amper, heb ik toch herinneringen. Laatste was een paar jaar geleden op jouw plekje, in Luxemburg. Een ruimte van rust een man die je niet kan vergeten. Een plek in mijn hart.

Tags:

IT Services on Zabbix #2

March 19th, 2009 No comments

I’ve created a patch file for helping people showing their SLA records per month.

Patch file can be downloaded here and here. Submission on the Zabbix Forums can be found here. Use this when you know what you are doing. I don’t have any guarantees it will work in your environment.

Tags: , ,

IT Services on Zabbix

March 17th, 2009 2 comments

Currently i’m working on an zabbix extension for showing IT service SLA’s per month. I’ve found out some nice functions for this and am currently in the process of creating the PHP scripts necessary for this.

Soon more.

Tags: , ,

Pinkpop tickets

March 7th, 2009 No comments

And since today we have pinkpop tickets for the complete weekend. Tickets for only Saturday (the Bruce Springsteen day) were already sold out after a few hours. I’m curious how long it will take this year before it is completely sold out.

This summer we will be attending 3 festivals at least: Pinkpop (just us two), Sonisphere (us two and a bunch of people), Lowlands (us two and problably even more people).

See ya there!