Masao Kitamura

/sbin/hdparm -tT /dev/sda

If your SSH public key authentication is failing with errors like this:

$ ssh -vvv myhost.com
debug3: authmethod_is_enabled publickey
debug1: Next authentication method: publickey
debug1: Offering public key: /home/kitamura/.ssh/id_dsa
debug3: send_pubkey_test
debug2: we sent a publickey packet, wait for reply

…try these permissions on the server:

server$ chmod go-w ~/    (same as 755)
server$ chmod 700 ~/.ssh
server$ chmod 600 ~/.ssh/authorized_keys

more troubleshooting tips

1. Use UNSIGNED INT or BIGINT for primary key, since you don’t need negative primary keys.
2. Don’t use ON DELETE CASCADE, since you might delete rows you wanted to keep.  Explicitly delete rows in your code.
3. Don’t use ON UPDATE CASCADE, since you might want to change the ID in the parent table of the row being referenced, without changing the ID of the child row.
4. Always use foreign keys to constrain your data and require that foreign keys reference rows that actually exist.
5. Use UNIQUE KEYS where necessary and where they conceptually make sense.  All fields in the UNIQUE KEY must be NOT NULL for the key to be effective.
6. Use singular table names, unless a row represents a plural object.  (A table of chairs would be called “chair”, unless a row represented a set of “chairs”).  This makes code generation easier.

Thanks Damien.

How to Automatically Install CPAN Dependencies without having to answer “yes” to each question:

export PERL_MM_USE_DEFAULT=1

# rpm -ql mysql-devel
/usr/include/mysql
/usr/include/mysql/chardefs.h
/usr/include/mysql/decimal.h
/usr/include/mysql/errmsg.h
...

Here’s how to monitor multiple cores on Linux:

# mpstat -P ALL

Example:

Monitor all CPU’s in 1 second intervals forever

# mpstat -P ALL 1

If Synergy fails for you with this error: “Server refused client with name XXX”, then your IP might conflict with another machine on the same network.

Here’s how to renew your IP on Linux:

### Release your current IP
$ sudo dhclient -r

### Request a new IP
$ sudo dhclient

1. Go through the usual setup at Samba.org or use YUM (yum install -y samba)
2. By default, the smb.conf allows sharing of home directories.
3. Add a Samba user (smbpasswd -a myusername)
4. On Fedora, run SELinux Administration
5. On the left menu, click “Boolean”.
6. Scroll down to “samba”, and check the box next to “Allow samba to share users home directories”.
7. Also on Fedora, make sure your Firewall allows the Samba ports 139 and 445.
8. On Windows Vista, now map the network drive.

Sample smb.conf:

[homes]
        comment = Home Directories
        browseable = no
        writable = yes
;       valid users = %S
;       valid users = MYDOMAIN\%S

After installing Roxio Creator, you might have a system tray icon that you can’t seem to get rid of. Here’s how to do it:

1. Start Roxio Creator
2. On the left side, click Audio.
3. Then click Audio CD
4. On the left bottom, click Settings
5. Uncheck Watch Folders at Startup
6. Then click OK

Add this to LocalSettings.php:

$wgGroupPermissions['*']['edit'] = false;


# Yesterday in epoch seconds
$ yesterday=$((`date +'%s'` - 86400))

# Same thing in YY-MM-DD
$ date -d "1970-01-01 $yesterday sec" +"%Y-%m-%d"
2009-02-17


1. Create a label in Google Bookmarks with all the bookmarks you want to centralize.
2. Then, create a live bookmark in Firefox with the following URL, replacing the label name with the one you created:

http://www.google.com/bookmarks/lookup?hl=en&sort=title&output=rss&q=label:live

Instead of:


ALTER TABLE my_table ADD KEY `key1` (`apple`);
ALTER TABLE my_table ADD KEY `key2` (`banana`);


do this:


ALTER TABLE my_table
ADD KEY `key1` (`apple`),
ADD KEY `key2` (`banana`);


On the destination server, remove the known_hosts file:

rm ~/.ssh/known_hosts

Also, try this in your /etc/hosts.allow file

/etc/hosts.allow:
SSHD: ALL


The mapping:

<map name="pressMap">
<area href="/weekly" coords="10,6,232,79">
<area href="/store" coords="245,6,469,79">
<area href="/yelp" coords="481,6,705,79">
<area href="/press" coords="718,6,941,79">
</map>


The image:

<img src="hpAdsStatic.png" usemap="#pressMap" />

1. Go to System -> Administration -> Network
2. Select your “eth0″ device.
3. Activate it.
4. Click “Edit”.
5. Check the box next to “Controlled by Network Manager”.
6. Save and exit.

Your connection should now work.

“c:\program files\putty\pageant.exe” “c:\documents and settings\esumbar\pka-putty\mykey.ppk”

http://ocw.mit.edu

http://see.stanford.edu

In Firefox, “about:config”, set

browser.sessionstore.resume_from_crash = false

For example, the “kill” manpage shows:

SEE ALSO
bash(1), tcsh(1), kill(2), sigvec(2), signal(7)

This is how to view section 7 of the “signal” manpage:

man 7 signal