WordPress database error: [Got error 28 from table handler]
SELECT DISTINCT ID, category_id, cat_name, category_nicename, category_description, category_parent FROM wp_str8_categories, wp_str8_post2cat, wp_str8_posts WHERE category_id = cat_ID AND post_id = ID AND post_id IN (5422)

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_str8_posts LEFT JOIN wp_str8_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (5422) GROUP BY ID

STR8BLOGGIN » Blog Archive » Secure browser sessions by proxying through SSH

Secure browser sessions by proxying through SSH

  1. Download Putty and Puttygen
  2. Run Puttygen
  3. Create a private key; save it somewhere on your harddrive. Don’t bother with encrypting/passwording it.
  4. Copy the public key (shown in the box) with Ctrl-C
  5. Login to the server you want to proxy through, as normal, with Putty
  6. Edit .ssh/authorized_keys - you may have to create the .ssh folder
  7. Paste your public key on one long line into the file and then log out of the server
  8. Load your Putty settings for the site
  9. On the left, go to Connection -> Data and enter your username where it says “Autologin Username”
  10. On the left, go to Connection -> SSH -> Auth, and select your private key
  11. On the left, go to Connection -> SSH -> Tunnels, type source port 1080 (or whatever you want), “dynamic” remote, and click “Add”
  12. Go back to the main settings panel and be sure to save your settings
  13. Doubleclick the settings; you should login automatically without a password
  14. 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 * FROM wp_str8_comments WHERE comment_post_ID = '5422' AND comment_approved = '1' ORDER BY comment_date

Leave a Reply