Author: robi

Today I’ve upgraded drupal from 4.7.2 to 5.0. New version, new theme… new new…

Remember my last post? 🙂 Now, check this out:


weasel:~# cat /etc/debian_version
testing/unstable
weasel:~# uname -a
Linux weasel 2.6.17 #2 Wed Nov 1 17:33:07 CET 2006 mips GNU/Linux
weasel:~# cat /proc/cpuinfo
system type : Broadcom BCM47xx
processor : 0
cpu model : Broadcom BCM3302 V0.6
BogoMIPS : 261.63


Thanks to a documentation and some downloads I’ve found here, I have now a debian etch running on my ASUS wireless router. The guy exactly did what I wanted to. I already had debootstrap on my laptop, and OpenWRT dev kit. But he saved me some hard work. I should thank him 🙂 Although I needed to tweak a little bit, but now it works!!! I can now sleep better 😀

Long time, no blog. 🙂

We moved to another flat, w/o internet. Fortunately, within one month we could arrange one. It’s not that good as previously, but it works. I have also bought a wireles router. Not the ASUS WL-500g Deluxe, because I could not find one, but an ASUS WL-500g Premium thanks to one of my colleagues. It’s even better then the one I wanted. 32M RAM, 2x USB 2.0, supported by OpenWRT… yum! I have already an OpenWRT running on it:

.

Of course I’m already planning to replace OpenWRT with Debian mipsel. Crazy me, huh?

The results of my previous action were imminent. However, there was another issue. Check this:

There was an infected machine making connections with a lot of hosts in the university network over port 139. The soulution? Restrict the port in the firewall. 🙂

By the way, I was very busy with moving to another flat and after that we travelled to Erlangen, where I planned to (re)start writing my thesis. Thus I had no time for blogging.

http://www.ibiblio.org/Dave/Dr-Fun/df200601/df20060123.jpg

Since I had some spare time, I checked the Mora dormitory network again, and I’ve found this:

Some remarks:

• There is one or more infected machines on the network: see the high amount of SYN_SENT connections. I suppose it was a single machine being turned off between 23:00 and 7:30.
• Another suspicious thing: the high amount of TIME_WAIT connections. The timeout is 120 secs, that is the average 714 means almost 6 connections are closed each second. Given that it is now summer and only a few machines are in the dormitory, this is an obvious irregularity (nice expression 😉
• The number of ESTABLISHED connections is also high.

My conclusions: there is an infected machine, and there is a large amount of file sharing there. You don’t have to be Sherlock Holmes to find it out in a dormitory. I also think some applications just drop the connection, since the number of the ESTABLISHED entries does not correspond to the active connections shown for example by iptraf. Grrr…

So I decreased the timeout for SYN_SENT (from 120s to 60s), TIME_WAIT (also 120s to 60s) and ESTABLISHED (from 432000s/5days to 43200/12hrs).

By the way, I already have found ideas, how to tweak the router settings such that the network won’t be flooded (up to unsuability):

• The Ultimate Traffic Conditioner: Low Latency, Fast Up & Downloads
• Netfilter extensions: iplimit patch

By the way, perhaps I should test Zabbix to replace Munin. There are debian packages of it. Althouh only the MySQL backend, and not the PostgreSQL. Why??? That was one (the) blocker for me to try Cacti, but fortunately Zabbix can use PostgreSQL as well.

My opinion is that DRM is bad. Very bad. Some more stuff is here: http://defectivebydesign.org/ and here: http://www.eff.org/corrupt/.


I cannot understand this world. By trying to enforce our will, and seeking for our good, the world is converging to a local optimum, as it happens often with greedy algorithms. DRM means extra cost and effor to the content provider, to the manufacturer and mostly to the end user. And what is the profit? The entertainment industry will earn more. But this means only transferring the money from people (ca. 5 billion) to a small minority (1 million?). And what are we paying for??? Yes, it’s an effort to create a content. But what is the difference if I look at it once, or if I make a copy for myself, look at it again, or I share it with friends, and week look at it together. The effort needed to create the content is always the same.

My favourite example is from the bible, just think about it:
Then he took the seven loaves and the fish, and when he had given thanks, he broke them and gave them to the disciples, and they in turn to the people. They all ate and were satisfied. Afterward the disciples picked up seven basketfuls of broken pieces that were left over.
Matthew 15:36-37

I used to have a lot of screenshots. During the time I had several applications to create them. Recently the gnome screenshot panel applet is my favourite since it is simple and reasonably fast. However I was missing a feature: I wanted to add descriptions to my screenshots. So I hacked around a little bit.

In the original version you can only specify the filename:

In the hacked version you can specify a description which is saved as a “tEXt/Description” field into the .png file:

I always had problems with the speed and memory consumption of dpkg. When I’m doing apt-get upgrade, my laptop becomes unusable for several minutes. And I do it every day, since I’m using debian testing. I made a little research, and found out that a huge part of the time is spent in the parsedb function with parsing the text files containing package information. That’s when you see "(Reading database ..."

Therefore I decided to replace the textfile backend with sqlite3. The first step is almost finished: the package information has been imported into an sqlite database. I just wrote a 100 line C++ prog, and it works.

The preliminary results are self explanatory:

Using dpkg as it is now (file backend, 17782 packages):

hikaru:/home/robi/prog/dpkg/trunk/utils# time dpkg -l "gnome-terminal"

[...]
ii gnome-terminal 2.14.2-1 The GNOME 2 terminal emulator application
[...]
real 0m6.817s
user 0m1.360s
sys 0m0.092s


Using an sql query with sqlite (same database, 17782 packages):

hikaru:/home/robi/prog/dpkg/trunk/utils# time echo "SELECT * FROM packages WHERE Package='gnome-terminal';" | sqlite3 available.db
gnome-terminal|optional|gnome|404|Guilherme de S. Pastore |i386||2.14.2-1|b18bd66347ef25707e7b92957142de0b
[...]
real 0m0.851s
user 0m0.004s
sys 0m0.004s


The next step is to fix some bugs (eg. having ‘ in the descriptions is a problem at the moment), and then replace the code in parsedb. But first I have to get some sleep.

Grrr again… I hate pharmaceutical industry and I hate biotech companies. It’s not about healing, it’s not about making people’s life better. It’s all about money. Damm damm diridamm… Read this: Drugs firm blocks cheap blindness cure. Medical research should only be perfomed by non-profit organizations, and the knowledge must be shared. Otherwise we are facing a really sad future.