Lugmoe 10 Jahre - Linux User Group Mönchengladbach

Yes, 2012 – the year of apocalypse or the year of changes. Changes for me and my lovely girlfriend. We plan to marry at July  7th in Bremen (Germany) (the city where we both been born and grown up in).

After 2 years and 5 months at Moenchengladbach I go back to Bremen and start a new job as a systemadministrator. My new company is near the “Technologie Park Bremen”. A good friend and I will work together in an IT team in this office. My office isn’t the headquarter, but cooler than the other offices (!).

I will live in a furnished arpartment at Bremen for a short time. My girlfriend and I have to live in a long-distance relationship for a half year but after the wedding my girlfriend moves with the cats and stuff to Bremen, too. We are coming back to Bremen earlier than expected.

I hope so to stay in contact with the good guys and friends at “North Rhine-Westfalia” (especially the members of the LUG MOE, ORR and “NiNGs”).

Over a month ago the 28c3 congress closed its doorts. But better a late review than no review. This congress was my first time and my first CCC event.

The 28c3 – codename “behind enemy lines” – was a great journey to Berlin (Germany) and a great experience to me. I traveled by train from Bremen to Berlin city and checked in at the hostel “citystay”. It isn’t very far away from the “Berliner Congress Center” (= BCC).  In the neighboorhood is a super market with “club mate” (the best caffeined tea drink in the world !) and good stuff for fair prices.

On December the 27th the official congress program started in the morning with lots of talks, projects and  workshops. I found a good seat at the cool debian table and link me to the congress network. I was very impressed by the kind of visitors, projects and technical features.

Before I traveled to Berlin, I talked with some people about the congress and the very specific flavour. I heared some interesting stuff and I wanted to see these “features” and cool stuff.

The wired network was very good and the uplink to the internet (www) was very strong (~ 20Gbps). You could see the talks in 3 halls, dvbt or internet media streaming service. The wireless network was ok, but not my favourite.

The international audience was cool and very friendly. You could find any time or any place a talking partner or a listener for your projects. This was the “free open mind” for knowledge exchange. I like this way.

The location was great and a very good infrastructure. But the air conditions was very cold and flawly by the windows.

After 4 days the congress was over and I traveled back by train to Bremen. I gladly remember my 4 days of congress.

I wish I could go again at 2012.

My talk list:

• r0ket++ — http://events.ccc.de/congress/2011/Fahrplan/events/4777.en.html
• Der Staatstrojaner — http://events.ccc.de/congress/2011/Fahrplan/events/4901.en.html
• 802.11 Packets in Packets — http://events.ccc.de/congress/2011/Fahrplan/events/4766.en.html
• Defending mobile phones — http://events.ccc.de/congress/2011/Fahrplan/events/4736.en.html
• Black Ops of TCP/IP 2011 — http://events.ccc.de/congress/2011/Fahrplan/events/4930.en.html
• Effective Denial of Service attacks against web application platforms — http://events.ccc.de/congress/2011/Fahrplan/events/4680.en.html
• How governments have tried to block Tor — http://events.ccc.de/congress/2011/Fahrplan/events/4800.en.html
• Rootkits in your Web application — http://events.ccc.de/congress/2011/Fahrplan/events/4811.en.html
• NPC – Nerds’ Pissing Contest — http://events.ccc.de/congress/2011/Fahrplan/events/4722.en.html
• Security Log Visualization with a Correlation Engine — http://events.ccc.de/congress/2011/Fahrplan/events/4767.en.html
• Cellular protocol stacks for Internet — http://events.ccc.de/congress/2011/Fahrplan/events/4663.en.html
• New Ways I’m Going to Hack Your Web App — http://events.ccc.de/congress/2011/Fahrplan/events/4761.en.html
• Fnord-Jahresrückblick — http://events.ccc.de/congress/2011/Fahrplan/events/4866.en.html
• CCC Camp 2011 Video Impressions — http://events.ccc.de/congress/2011/Fahrplan/events/4932.en.html
• Sovereign Keys — http://events.ccc.de/congress/2011/Fahrplan/events/4798.en.html
• Antiforensik — http://events.ccc.de/congress/2011/Fahrplan/events/4828.en.html
• bup: Git for backups — http://events.ccc.de/congress/2011/Fahrplan/events/4587.en.html
• NOC Review — http://events.ccc.de/congress/2011/Fahrplan/events/4927.en.html
• Security Nightmares — http://events.ccc.de/congress/2011/Fahrplan/events/4898.en.html

I like to share my code and solutions. In this blog post you will see my two mysql bash scripts. The first script dumps all databases in separate dump files [2] and the second restores each database [3]. I like to use a secured config file for the database login like [1].
I use the backup script together with logrotate to make my daily backups on my own servers [4].

[1] Code “mysqlclient.backup”:

[client]
user="backupusermysql"
password="secretpassword"

[2] Code “backup_mysql.sh”:

#!/bin/bash
export PATH=/bin:/usr/bin:/sbin:/usr/sbin
OUTPUTDIR="/backups/mysql"
OPTIONS="--complete-insert --add-drop-table --extended-insert --quote-names"
CONFIG_FILE="/root/mysqlclient.backup"
# check that backup dir exists
if [ ! -d $OUTPUTDIR ]; then
mkdir $OUTPUTDIR
fi
# get list of databases
DATABASES=`echo "SHOW DATABASES" | mysql --defaults-file="$CONFIG_FILE" mysql`
for DATABASE in $DATABASES; do
if [ "$DATABASE" != "Database" ]; then
# backup database
mysqldump --defaults-file="$CONFIG_FILE" $OPTIONS $DATABASE > $OUTPUTDIR/$DATABASE.sql
fi
done
exit 0

[3] Code “import_mysql.sh”:

#!/bin/bash
export PATH=/bin:/usr/bin:/sbin:/usr/sbin
IMPORTDIR="/backups/mysql"
OPTIONS=""
CONFIG_FILE="/root/mysqlclient.backup"
# check that import dir exists
if [ ! -d $IMPORTDIR ]; then
mkdir $IMPORTDIR
fi
# get list of sql dumps
cd $IMPORTDIR
for SQLFILE in $(ls -1 *.sql|sed 's/\.sql//g')
# import the dumps
do
echo $SQLFILE
mysql --defaults-file="$CONFIG_FILE" $OPTIONS $SQLFILE < $SQLFILE".sql"
done
exit 0

[4] Code “logrotate conf”:

/backups/mysql/*.sql {
daily
copy
missingok
rotate 30
compress
notifempty
create 600 root root
sharedscripts
prerotate
/usr/local/sbin/backup_mysql.sh
endscript
}

This weekend is the OpenRheinRuhr [1] event in Oberhausen (Germany). Last year, I was only a “crew member” and helped the organization crew to make this event wonderful. This year I changed the sides and lifted me up to a better position – the organization crew. I’m helping to manage the local network and the cooperation with the “Freifunk Duesseldorf” team [2] to run the wireless network for this event. This is a first for us.
Together with nightraven, yalla (, mgisbers)  - we are the NOC team 2011.

I’m very excited. My hope is to have a good weekend with interesting talks, nice ambience and a lot of fun.

Shortly before the year is over, I caught up a rare 4-day-ticket of the big event at Berlin (Germany) – the “Chaos Communication Congress” [3].
This is my first participation and I hope to have a lot of fun between December 27th and December 30th at Berlin.The title for this congress is “28c3: Behind Enemy Lines”. The typical visitors at this congress are very interested in technology, society and utopia. For more information about it – take the link at the end of my post.

Another, very special event in the year 2012  for me is the marriage with my long-time girl friend Imke. I’m very nervous and happy at the same time. This is a big step… and I’m ready for this. I hope so… *g*

Don’t be afraid… I post more information in the future.

Thanks for reading this post and stay tuned to continue reading my blog.

Bye!

[1] http://www.openrheinruhr.de
[2] http://www.freifunk-duesseldorf.de
[3] http://events.ccc.de/congress/2011/

~