Secure browser sessions by proxying through SSH
May 8th, 2007- Download Putty and Puttygen
- Run Puttygen
- Create a private key; save it somewhere on your harddrive. Don’t bother with encrypting/passwording it.
- Copy the public key (shown in the box) with Ctrl-C
- Login to the server you want to proxy through, as normal, with Putty
- Edit .ssh/authorized_keys - you may have to create the .ssh folder
- Paste your public key on one long line into the file and then log out of the server
- Load your Putty settings for the site
- On the left, go to Connection -> Data and enter your username where it says “Autologin Username”
- On the left, go to Connection -> SSH -> Auth, and select your private key
- On the left, go to Connection -> SSH -> Tunnels, type source port 1080 (or whatever you want), “dynamic” remote, and click “Add”
- Go back to the main settings panel and be sure to save your settings
- Doubleclick the settings; you should login automatically without a password
- Go into your Firefox and select localhost:1080 as the SOCKS proxy for all your connections.
WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_str8_comments WHERE comment_post_ID = 5422 AND comment_approved = '1';
WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(*) FROM wp_str8_comments WHERE comment_post_ID = '5422' AND comment_approved = '1'