Michal Čihař - Blog Archives for Life

Playing with numbers and social networks

I'we just launched website (well it's quite pretentious name for few pages), which shows debts for politics when they were in government in Czech Republic. We're still not in situation like in Greece, but it can quite easily happen that we would be in few years and it's good to show some numbers describing what was happening in past.

It took just few hours of coding yesterday evening using Django. Domain has been registered and it is online now.

While doing such thing, I decided to make more fun for me and publish the link just on social networks (Identi.ca, Twitter, Facebook, LinkedIn) and follow if (and how) the link will spread. So no, you will not find link in this blog post :-).

Travel agenda before FOSDEM

In last few days I spent some time with travel agenda. Tomorrow morning I am leaving for FOSDEM, so I'm arranging last minutes things like online checking. Whoever wants to meet me just drop me an email or just check things I want to visit and find me there.

Meanwhile got open registration for Debconf 10, so when I was in travelling mood, I also filled in that one. Right now it looks like it will be quite tough for me to pay this trip, but there is still some time to sort it out :-).

Going to FOSDEM 2010

Some time ago we decided in phpMyAdmin team to create yet another team meeting (after five years) at FOSDEM 2010. It took some time, but now I should have all travel things arranged (thanks to my employer who sends me there).

So if anybody wants to meet there, just drop me an email and I will try to put you on my schedule.

Fun with blacklists

Yes, blacklists are great, especially if wrongly used. Currently I can not renew SSL certificate I used to have from StartSSL, because they somehow use blacklist from Google to block sites with malware. The word somehow is important here, because I am not listed as being suspicious, but they still see me blacklisted.

And the more funny thing seems to be that Google found sometimes some malware on my site, but there is no way to find out what it was. Maybe it is somehow related to the broken antivirus complaining that NSIS binary contains a virus, but who knows...

As the funny story goes on, I get to know that it is because I'm on AS:15685 network. Well I am. And as well are about other thousands of servers hosted in that place. So what?

PS: Just to be sure, I just did full scan of all files on dl.cihar.com and here is the result:

----------- SCAN SUMMARY -----------
Known viruses: 621888
Engine version: 0.95.2
Scanned directories: 133
Scanned files: 3975
Infected files: 0
Data scanned: 14546.95 MB
Data read: 2462.58 MB (ratio 5.91:1)
Time: 1093.524 sec (18 m 13 s)

Back home from Spain

Yesterday I arrived back from Spain and DebConf, so I should be finally back on track to process mails, bug reports and other similar things. If you're waiting for my reply more than month, you should be soon handled ;-).

I really enjoyed DebConf and meeting all the people there. And as well I did enjoy rest of travel through Spain. Except the day when they stole my backpack in Barcelona. But I can hardly do anything about that, it just made my vacation quite expensive because loosing my DSLR camera with lenses.

MySQL way of repairing tables

This is just a small rant about issue which did hit me today. One of MyISAM tables on my database server has been crashed. Well you can expect that kind of thing after a hardware failure. I did start REPAIR TABLE and nothing happened for quite a long time.

Finally I managed to look into the logs and found this jewel:

[ERROR] /usr/sbin/mysqld: Disk is full writing '/tmp/STwW9hIc' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs

Well MySQL, nobody else is not using this vserver and the /tmp is a ram filesystem. So if you filled it up, nobody is going to make space for you there and you will wait for ages.

Maybe continuous waiting is not the right idea...


When some Debian developers set up microblogging for whole Debian project, I decided it's really time to at least try it ;-). So if you are interested in reading my rants, you can follow them on identi.ca or twitter. I'm not really sure how long I will actually use it, but for now it seems to be good way to dump thoughts which are really not worth anything more.

Thought about email footers

Have you ever thought what you send in email footer?

The information contained in this e-mail is private & confidential and may also be legally privileged. If you are not the intended recipient, please notify us, preferably by e-mail, and do not read, copy or disclose the contents of this message to anyone.

If I'm not the intended recipient (supposing I know how to guess this), how am I supposed to notify you, when I should not read the contents, so I should not know about fact that I should notify you?

Fun with software catalogues

Recently, I made available information about Gammu and Wammu in machine readable formats (currently DOAP and PAD). In order to fully use advantage of PAD, I decided to push both Gammu and Wammu to some PAD enabled sites I found. At least it should give it a bit more visibility in Windows world.

When I started looking for these sites, I was surprised that there is so much of them. Yes it is quite easy to setup such site as ASP provides PHP scripts to make such site, but I expected that people would be a bit sane and would not start 1001th software catalogue. But anyway, let's submit my software there to spread the world a bit ;-).

The important site (at least as far as I remember them from times when I was using Windows) like Tucows or cnet downloads, have some lengthy review process, what is okay for me. But more funny are random small sites, where you immediately get 5/5 stars or sticker 100% Vista Compatible. Who cares, let's see if it will really attract some users.

Email easier than Google?

I really do not get, while people rather email somebody to ask question, which Google can answer in few seconds.

Today I got question that some body was not able to find phpMyAdmin demo:

Hello, I ran your phpMyAdmin demo from some link, but I unfortunately do not know where it was. Could you please send me link to this demo.

Is it really that hard to find it? Typing phpMyAdmin demo into Google, does give correct result on first place to me...

PS: I got to reading this email after five days, so that guy definitely did not save much time.