Lugmoe 10 Jahre - Linux User Group Mönchengladbach

Since Debian excludes the Sun/Oracle Java packages is using of java based software or applets very difficult and the openjdk implementation isn’t an option for me. So, I decided for me to go back to Sun/Oracle Java on Debian.

This example is for a 64-bit Debian system. First, you must download the packages from Sun/Oracle for your system architecture (x86 or amd64). After this step you make your java directory like /opt/java/64.

Next, you must unpacking the tarball in it. Set the right path and index for update-alternatives with these commands:

ln -s /opt/java/64/jre_1.7.xxxx/ /opt/java/64/jre7

update-alternatives –install “/usr/bin/java” “java” “/opt/java/64/jre7/bin/java” 1

update-alternatives –set java /opt/java/64/jre7/bin/java

Now, you can set the right path to the plugin for iceweasel/firefox.

mkdir ~/.mozilla/plugins

ln -s /opt/java/64/jre7/lib/amd64/libnpjp2.so ~/.mozilla/plugins/libnpjp2.so

That’s it! Now you have Sun/Oracle Java running.

After my new start as an systemadministrator on March 1st, I’m looking
back on a short result of my situation.
Now, I’m living and working in Bremen. My darling stays in
Moenchengladbach with our cats and waits for a good chance to follow me
to Bremen. The wedding day moves closer and closer. An important point in my
life, I think…
The company is good. The co-workers are friendly and we have lots of fun
together. I like the working styles, methods and the knowledge exchange
between the different areas (developers, admins, …).
My personal favourite tool or enviroment at work is the combination of
puppet + git + vagrant. I like the process management method calls “kanban”.
Today, I think, that I made the right decision to go back to Bremen
and to work in a company with a good friend.

Thanks Tobias for your headhunter work. *g*

Now, I’m looking for a group in Bremen like the LUG Moenchengladbach, but
the search is not easy. I let you know when I have found the right group.

Yesterday, I was with two friends at “Cinestar Kristallpalast” and we watched the movie “The Avengers”. After it, we talked a long time about the movie. At the end we are all have the same result to say “Yes, this was a good movie!”.
My personal favourite was the product placement on Iron Man (black sabbath) and the funny little things and jokes between the heros (like Hulk and Thor).
Yes, this movie is not a deep story-based movie, but a good comic-based production. I like it!
If you are a Marvel-interested person, go into the cinema and look this movie!

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
}