Heating fixed

So last December a plumber came over and noticed that the tubes going to the radiators of the central heating were connected the wrong way. I was very pissed, mostly because we didn’t notice it earlier. Today, finally, it got fixed. Luckily, the fix was not as expensive as I expected, but still not very cheap. I had to borrow the money from my dad, which I really do not like.

However, it’s fixed now and I expect the result noticable on my monthly statement for gas.

Tags: fix, heating, house, maintenance

MySQL on Lenny and permissions

Ok, had something strange that I think is worth a share. I just upgraded a virtual machine to Lenny and installed MySQL and phpMyAdmin and apache and the like. Created a user for a Django project I’m working on and it couldn’t connect. I tried resetting the password several times, didn’t help. Then, out of frustration, I tried connecting without a password and… it worked!

Apparantly, by default, the MySQL in Lenny created access rules that allow all local users to access the database without a password. These have priority over the specific user controls. A bit unexpected and I suspect others to run into this. Could make you search for a problem if you’re installing a shared webhosting machine with a local MySQL database.

Solution:
delete from mysql.user where User='';

Tags: a_bit_strange, credentials, debian, fix, lenny, mysql, permissions