Monthly Archives: October 2008

Shutdown does not power off EeePC

14-Oct-2008 Posted by Sonia Hamilton under ,
2 Comments

I’ve noticed that issuing a sudo halt on my EeePC 701 shuts down the operating system (eeeXubuntu), but doesn’t power down the system. So I’d be watching videos on my way home from work, sudo halt, get home, and pull a red-hot E out of my bag – ouch!

Solution (Bug #239145) – add rmmod snd-hda-intel to the stop section of /etc/init.d/halt.

How to configure central syslog’ing on Solaris

07-Oct-2008 Posted by Sonia Hamilton under
No Comments

Quick notes; see Solaris: Logging to a separate loghost, the easy way.

  • edit /etc/inet/hosts, add in an alias for loghost eg 1.2.3.4 loghost
  • /etc/init.d/syslog restart (Solaris 8), svcadm on later versions

Other useful links for ‘the Solaris way’ (vs Linux):

Ruby on Rails – Foreign Key Constraints in MySQL

01-Oct-2008 Posted by Sonia Hamilton under
5 Comments

As an ex-DBA, one of the things that annoys me about Rails is that migrations don’t have a way of setting up referential integrity (I’m still using Rails 1.2.3, so this may have changed). But apart from that, I lurv Rails :-)

Here’s some code I wrote to for adding and removing foreign key constraints on MySQL (using InnoDB, of course). There’s other code out there to do the same thing, but they didn’t do what I wanted, or required installing a plugin. (more…)