http://www.jober.org/joblog jo's computer science blog Tue, 15 Dec 2009 14:43:50 +0000 http://backend.userland.com/rss092 en To add a unique contraint for two table fileds, simply execute the following command: ALTER TABLE scene_commands ADD UNIQUE (scene_id, command_id); http://www.jober.org/joblog/2008/09/05/add-table-constraint-unique/ Testing a lot on your servers can sometimes lead to the problem, that you receive this error message: 'Received disconnect from Too many authentication failures for root' or of course for other users, try faillog! There are some options to view / reset the authentication failures for the given user(s) This is the man ... http://www.jober.org/joblog/2008/09/01/reset-authentication-failures-on-unix-linux/ Howto redirect the standard input and output of a command shell script: STDERR and STDOUT together: $output = `cmd 2>&1`; To capture a command's STDOUT but discard its STDERR: $output = `cmd 2>/dev/null`; To capture a command's STDERR but discard its STDOUT (ordering is important here): ... http://www.jober.org/joblog/2008/08/05/stdout-stdin-2/