Enabling InnoDB support in debian (MySQL)

Posted by coldtobi | 17 Mar, 2011, 10:17

InnoDB as storage engine has some advantages: Just one example: it is the backend to use when foreign keys are required.

For a complete picute, read the documenation:  http://dev.mysql.com/doc/refman/5.1/en/innodb-storage-engine.html

 However, on Debian InnoDB is disabled by default: (take a look at /etc/mysql/my.cnf)


However, it's not just uncommeting to enable it: Your mysqldaemon will fail.  This article will explain how you can enable it with Debian

Of course, this assumes that you already setup mysql on your Debian server.


Blog and Website | Comments (3) | Trackbacks (0)

Pollin Net-IO PHP Library

Posted by coldtobi | 9 Feb, 2011, 19:37

Currently I work on a small private home-automation project. The purpose to "control" the heating system at home (heat-pump system) via the Internet. 

Okay, "control" is a too big word for the heat-pump as it has only 3 controlable modes, at least without reverse-engineering effort: "normal", "off" and "night reduction" by an external analog input. The goal is to shift energy consumption to the lower priced off-peak times.

For this project, I'm using a Ethernet Board with an Atmel AVR microcontroller, my Thecus N2100 as control server and PHP.


Electronics and Atmel AVR, Thecus N2100 | Comments (2) | Trackbacks (0)

Link to safe

Posted by coldtobi | 23 Jan, 2011, 10:01

Custom Firmware for a seagat FreeAgent Theater+


Could be the next hacking project.

Blog and Website | Comments (0) | Trackbacks (0)

Linux: Really using hardware random number generators.

Posted by coldtobi | 21 Oct, 2010, 23:16

A HW Random Number generator (HW RNG) helps programms a lot which needs some good entrophy, something especially on server systems is rare. Syntoms are slow key generation (ssl, ssh ... ) and poor performance when reading from /dev/random. 

However, soley having a HW RNG won't improve much -- this is what I learned today: I have a hifn 7955 based crypto accelerator in my NAS, but still poor /dev/random read rates. 

By coincident I learned that I looked at the wrong device -- the randoms by the hardware are available through /dev/hwrng. But how does other programms know that they should use this device instead of /dev/random? 


Linux / Debian | Comments (0) | Trackbacks (0)

Fun with spam

Posted by coldtobi | 21 Sep, 2010, 11:14

A Nigerian 411-type scam mail slipped through spamassassin.

Before moving it to its fate (aka SPAM folder), one line catched my eye:

(ii) Are you truly Dead OR Alive?




Netzfunde | Comments (1) | Trackbacks (0)

Sending a email notification when pusing to git (sourceforge)

Posted by coldtobi | 18 Sep, 2010, 13:12

Whenever I push changes to solarpowerlog, I want that a notification mail is sent to a dedicated mailing list.

However, the documentation on sourceforge just says "you can do this", but finding docs about "how" is hard. 

So this is my try to document the procedure, in case this helps someone... The examples are the one for solarpowerlog, so be sure to edit them before applying.


Linux / Debian, solarpowerlog | Comments (0) | Trackbacks (0)

Configure lighttp to simulate .htaccess rules (Deny From All)

Posted by coldtobi | 19 Jun, 2010, 13:14

Unfortunatly, lighhtpd does not support ".htaccess" rules directly. So if you want to use a script targeted for Apache, you have to implement your own rules.

Luckily, the most needed rule is to forbid the serving of a whole directory, the "Deny From All" rule.

This one can be emulated within the lighttpd.con -- but you have to list every affected directory.  A tedious task to find out every .htaccess contianing the rule and then adding the path to the configuration.

But this can be automated:


Linux / Debian, Tips and Tricks, Thecus N2100 | Comments (0) | Trackbacks (0)