Zur Krise der Wissenschaften kann man vieles sagen. Dabei wird das eher selten gemacht, denn eigenartigerweise ist Wissenschaft nur wenig selbst reflexiv. Warum mit immer mehr Wissen und immer mehr Bildung, die eigentliche Wissenschaft – Aufstellen von Hypothesen, Überprüfen von Sachverhalt und logischen Folgerungen – in den letzten Jahren immer weiter abgetreten ist? Continue reading Von vertikaler und horizontaler Wissenschaft →

I can’t read anymore what I would like to read — which isn’t unexpected with the doubling of papers in the last 10 years. The current rewarding system has such a focus on impact and publications – an over optimization where negative side effects are now beginning to dominate. Continue reading Science pump in, pump out →

Byung-Chul Han

Mag sein, aber von der Struktur unterscheidet sich diese Gesellschaft nicht vom Feudalismus des Mittelalters. Wir befinden uns in einer Leibeigenschaft. Die digitalen Feudalherren wie Facebook geben uns Land, sagen: Beackert es, ihr bekommt es kostenlos. Und wir beackern es wie verrückt, dieses Land. Am Ende kommen die Lehnsherren und holen die Ernte.

I have been relying for 20 years on analog for reading my webserver logs. But maybe … this is a bit outdated, while some newer systems as awstats, google analytics or piwik are too overloaded for me. My more recent approach with plugins like statpress or slimstat considerably degraded my system performance. So why not setting up an own database as this can be done in 30 minutes?
First, get sqliteadmin.php as we need to build a small database “log.sqlite3”. Create a new table by pasting

CREATE TABLE 'visit' ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'page' TEXT, 'dt' DATETIME DEFAULT CURRENT_TIMESTAMP, 'ip' TEXT, 'name' TEXT);

in the SQL window of sqliteadmin.php and include the following code in the header of all your pages

class MyDB extends SQLite3 { function __construct() { $this->open("log.sqlite3"); } }
$db = new MyDB();
$logpage="http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
$logip = $_SERVER['REMOTE_ADDR'];
$logip = substr($logip, 0, strrpos($logip, ".")) . ".xxx";
isset($_SERVER['PHP_AUTH_USER'])? $logname = $_SERVER['PHP_AUTH_USER'] : $logname = $_SERVER['REMOTE_USER'];
$sql='INSERT INTO visit (page,ip,name) VALUES ("'.$logpage.'","'.$logip.'","'.$logname.'");';
$db->query($sql);
$db->close();

That’s all we need to record. Maybe you want also a statistics page? Here is it, showing all recorded traffic (and in brackets what is going on today).

<pre>Logfile Analysis
<?php
class MyDB extends SQLite3 { function __construct() { $this->open("log.sqlite3"); } }
$db = new MyDB();
$sql = "SELECT page, count(page) AS c FROM visit 
WHERE round(julianday('now') - julianday(dt)) >=0
GROUP BY page ORDER BY c DESC;";
$ret = $db->query($sql);
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
  $pagearray[ $row["page"] ] =  $row["c"];
}
$sql = "SELECT page, count(page) AS c FROM visit 
WHERE round(julianday('now') - julianday(dt)) =0
GROUP BY page ORDER BY c DESC;";
$ret = $db->query($sql);
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
  $pagetoday[ $row["page"] ] = $row["c"];
}
foreach ($pagearray as $key => $page) {
  echo  $page>5 ? "<div class=big>" . $page . "(". $pagetoday[$key] . ")" . "</div>" . $key . "<br>" : FALSE;
}
?>

Looks like we used only 32 lines of code, yea, yea.

I needed to patch an unused Fritz Box with a DHCP and name server for a new project. Running these services from a network server wasn’t really stable.

The freetz websites has all the details for the patch while I can confirm that freetz version 2.0 can power a 10 year old 1und1 branded Fritz Box SL WLAN (also known as 3020 type) running firmware 09.04.34.

I compiled everything under Ubuntu/Luna using the terminal

#!/bin/bash
cat /etc/issue
uname -m
# update system
sudo apt-get -y update
sudo apt-get -y upgrade
sudo apt-get -y dist-upgrade
sudo apt-get -y install imagemagick subversion gcc g++ bzip2 binutils automake patch autoconf libtool pkg-config make libncurses5-dev zlib1g-dev flex bison patch texinfo tofrodos gettext pkg-config ecj fastjar realpath perl libstring-crc32-perl ruby ruby1.8 gawk python libusb-dev unzip intltool libglib2.0-dev xz-utils git-core libacl1-dev libattr1-dev libcap-dev
# do NOT run the following as root
cd /HOME/wjst/Desktop
umask 022
svn checkout http://svn.freetz.org/branches/freetz-stable-2.0
cd freetz-2,.0
make menuconfig
make

The new image may then be uploaded using the standard AVM webinterfaceat  http://fritz.box . The AVM DHCP needs to be switched off.
Freetz can be reached at http://fritz.box:81 where also the dnsmasq hosts file can be programmed to reach my server at a permanent IP address.