About this blog

Just saw that this blog entry was the 6000th in this blog.

Small sins will be punished immediately. For example ruining your CO₂ balance. I'm ill at the moment ... sinusitis again. My head feels a little bit numb at the moment, so don't expect many articles today.

Yet another coffee for local:

Yet another script from the bad-hack-department. I wrote this script to add tags to my articles based on the text in the body of the article. So all articles containing the string "oracle" are tagged with the tag "oracle". It directly accesses the database behind the blog software i'm using for c0t0d0s0.org:

import MySQLdb
import sys

try:
  conn = MySQLdb.connect (host = "localhost",
                          user = "user",
                          passwd = "password",
                          db = "database")
except MySQLdb.Error, e:
  print "Error %d: %s" % (e.args[0], e.args[1])
  sys.exit (1)

if sys.argv[1] == '':
  print "no tag"
  sys.exit(2)

tag2masstag=sys.argv[1]
print tag2masstag
cursor=conn.cursor() 
cursor.execute ("""SELECT id FROM serendipity_entries 
                        WHERE lower(body) REGEXP ' %s '""" % (tag2masstag))
rows = cursor.fetchall()
for row in rows:
  print "found in %s" % (row[0])  
  cursor2=conn.cursor()
  cursor2.execute ("""SELECT * FROM serendipity_entrytags 
                                 WHERE lower(tag)='%s' 
                                 AND entryid=%s""" % (tag2masstag,row[0]))
  if cursor2.rowcount != 0:
    print "Already tagged"
  else:
    print "Not tagged"
    cursor3=conn.cursor()
    cursor3.execute("""INSERT INTO serendipity_entrytags (entryid,tag) 
                                  VALUES(%s,'%s')""" % (row[0],tag2masstag))  
    cursor3.close
  cursor2.close
  
print "----executed"

Yet another coffee for Local:

By the way ... i didn't stop blogging ... i just writing a really long follow-on article to the the DIY-Thumper article at the moment.

I didn't wrote so much in this blog in the last few days not because of a lack of interest. I'm writing a longer chapter about IPMP (IPMP Classic and IPMP New) for the LKSF . Together with my day job this left not so much time for blogging. By the way: I have 3 weeks of vacation soon. Hopefully this will give me some time to translate the LKSF to German and to iron out some LaTex bugs.

Okay Local, we are at six coffee at Starbucks ... c0t0d0s0.org has more than 1600 subscribers. This bet will make me poor:

Oh heck ... I almost missed the date. Five years ago, i´ve started this blog. c0t0d0s0.org celebrates it´s fifth birthday today.

This year was a positive one for the blog. Vastly less technical problems than the year before where i had to reboot my server with a mobile phone from a vacation in London several times. Many new readers. And it´s still an interesting endeavour for me to write here. As i wrote last year, I really thought five years ago, that this blog would be one of my short-lived experiment.

In the last year other services surrounding the blog started like the Twitter feeds for patches (for Solaris x86, Solaris SPARC or other Sun Products) or OpenSolaris code news.

On the other side. It was a rough year and my assumption about the future of Sun wasn´t always correct. But error is human and i´ve learned a thing or two. Let´s wait what will happen in the next time.

Some numbers for the last year: Up to 10.500 visits a day. This day was the 20th of April, 2009. There was an important announcement. 1,573 subscribers at the moment. I owe Local 5 coffees at Starbucks already and the sixth is imminent. Since the first pdf the "Less known Solaris Features" tutorial was downloaded 26454 times. 1.688.997 views. I added Pageviews via Google Analytics and Itemviews via Google Feedburner for this number. There is no Analytics counting in feeds and no feedburner item counting in analytics). 5895 comments and trackbacks. 5615 articles.

The pageviews starting to get less in relation to the itemviews in terms of the numbers. It seems that many people stumbling over my blog subscribe the feed of it. The numbers of subscribers is vastly higher than i´ve expected one year ago.

The numbers hide the most important part of this blog: My readers, or to name it: You. I would like to thank you for reading my blog. It was really fun to write for you and I hope you stay with me and my blog the next years. I´m planing at least 5 additional years of blogging, whatever the future may bring to the industry, Sun and me.

I know ... i didn´t wrote so much in my blog this weekend, but that doesn´t mean, that i didn´t worked for the blog. I wrote a script to convert the .tex source code of the Less known Solaris Features to the syntax of the wikis.sun.com website. There is one problem at the moment: The LKSF wiki version consists out of 108 files and i don´t want to import them manually. But i hope our wiki people can provide me an easier method for the import.

The nice thing about Perl is the point, that there is always someone who has solved the problem you have at the moment. Yesterday i had the idea to put all articles in an addtional category based on their language as this is an bilingual blog. With a article count heading towards 6000, a manual process to do so, was out of question. Thus i´ve searched for an automatic way to do this. After googling for the problem i found the Lingua::Identify module. The usage of the module made the rest easy. The following script puts articles in a Serendipity-based blog in a category based on the English. 41 is the category ID for English articles, 42 is the category for articles in German. Interestingly articles with many HTML tags are frequently identified as written in Danish.


#!/usr/bin/perl

use Lingua::Identify qw(:language_identification);
use DBI;

my $dbh = DBI->connect( "DBI:mysql:databasename","username","password") || die "Database connection not made: $DBI::errstr";

my $sql = qq{SELECT id,body FROM serendipity_entries};
my $sth = $dbh->prepare($sql);
$sth->execute();
whileergebnis=$sth->fetchrow_array)
{
$id=$ergebnis[0];
$body =$ergebnis[1];
$lang =langof($body);
if (($lang ne "en") and ($lang ne "de")) {
next;
}
$cat=41 if $lang eq "en";
$cat=42 if $lang eq "de";
print "INSERT INTO serendipity_entrycat(entryid,categoryid) values($id,$cat);\n";
}

$sth->finish();
$dbh->disconnect();


Dear Local, i owe you five Starbuck coffees now

I´ve just processed all webserver logfiles for c0t0d0s0.org on my server with AWstats. I was a little bit surprised by the numbers: 2.3 million pageviews in this year so far (plus 2.9 million pageviews by robots and search engines). I think you have to substract 1.2 million pageviews from this numbers as they were accesses for comment.php. It´s safe to assume, that the largest amount of those requests were done by spammers. But 1.1 million pageviews is still impressive. But at the end: I´m still thinking Google Analytics or Statcounter is the more correct number. AWstats isn´t known to be an really precise tool for web analytics. But there is an important take-away in this numbers: Without spam-filtering and Akismet, the blog would look pretty much different ... 1.2 million spam comments and trackbacks ... i´m shuddering while thinking about this.

As you have to go with the times and ZFS is the new king in town ... c0t0d0s0.org got an additional alias: rpool.org You can reach my blog under that name, too ...

Due to a database problem c0t0d0s0.org wasn´t available last night. I corrected this problem directly after waking up. Sorry for that outage.

At last ... finalized a longer Green IT presentation. In the mean time my Feedreader count made a nice jump ahead: