Bill's Crappy Tech Blog: September 2010

Tuesday, September 28, 2010

WordPress 3.0 Setup

Install WordPress with Web Platform Installer

Useful WordPress Setting Changes
1. Settings > Writings > Remote Publishing > XML-RPC Checkbox and Save Changes
2. Settings > Discussion > Other comment settings > Automatically close comments older than 14 days Checkbox and Save Changes
3. Settings > Privacy > Site Visibility > I would like to block search engines, but allow normal visitors Select and Save Changes
4. Settings > Permalinks > Custom Settings > Custom Structure > Enter /%postname% in the text box for SEO

Useful WordPress Plugins
1. Plugins > Add New > Enter Configure SMTP and Click Search Plugins > find Configure SMTP and Install Now > Actions: Activate Plugin
  1. Settings > SMTP > Check Send e-mail via GMail? and enter a real gmail address > Save Changes
2. Plugins > Add New > Enter Static Toolbar and Click Search Plugins > find Static Toolbar > Actions: Activate Plugin
3. Plugins > Front-end Editor > Actions: Activate Plugin
4. Plugins > Exclude Pages from Navigation > Actions: Activate Plugin
5. Plugins > Featured Content Gallery > Actions: Activate Plugin (maybe?)
6. Plugins > Add New > Enter WordPress File Monitor and Click Search Plugins > find WordPress File Monitor > Actions: Activate Plugin
7. Plugins > Add New > Enter Sharedaddy and Click Search Plugins > find Sharedaddy > Actions: Activate Plugin
8. Plugins > Add New > Enter Postie - install and activate
  1. configure with email address, ssl imap, imap.gmail.com, only admins will be able to post until further configs are completed

Useful WordPress Widgets to configure
1. SiteMeter
  1. Appearance > Widgets > Drag a Text Box Widget to a Widget Area > Paste appropriate HTML from sitemeter.com
2. Tag Cloud
  1. Appearance > Widgets > Drag a Tag Cloud Widget to a Widget Area > Taxonomy: Categories
3. Twitter
  1. Appearance > Widgets > Drag a RSS Widget to a Widget Area
    1. RSS Feed URL: http://twitter.com/statuses/user_timeline/11893692.rss
    2. Uncheck Display Item Content
    3. Uncheck Display Item Author If Available
    4. Check Display Item Date and Save
4. Links
  1. Appearance > Widgets > Drag a Links Widget to a Widget Area

Thursday, September 23, 2010

WordPress Installed on IIS 7.5 with SQL 2005 or 2008

Here is a quick layout of instructions in installing WordPress on Windows 2008 R2 IIS 7.5 with SQL 2005 or 2008

Download wp-sqlsrv-2.9.2-beta-0.8.8.zip This is a special version of Wordpress that allows you to connect to a SQL server... or cluster... :) why not?!

Unzip files to C:\inetpub\WPOnSQL

Open IIS Mgr -

Open your Web Platform Installer > Web Platform > Database > Customize > Microsoft Drivers for PHP for SQL Server 2.0. Install this thing before you create your site.

Create new site

Enter Site Information
Website: New Web Site
WordPress application name: /
Web Site Name: blog.boneyard.org
Physical Path: c:\inetpub\blog.boneyard.org
IP Address: All Unassigned
Host Name: wponsql.boneyard.org
Click OK

****folder permissions of Modify, Read & Execute, List Folders, Read and Write on the c:\inetpub\SiteName folder to ServerName\IUSR

Go to your SQL box, open SQL Mgmnt studio and create a new database. Then create a SQL user that has dbo privs on that database. Then from your IIS, you can test your connection using ODBC manager.

Open site in a browser

The wp-config file will be missing, so let the site walk you through providing it with the database servername, database, and sql credentials

Create Configuration File > Lets Go >

Database Name: TEST

Username: sqlgod

Database Host: databaseservername\instancename

Database Type: SQL Server Using PHP Driver

Table Prefix: wp_

Click OK - the click Run the Install
Blog Title: Wordpress on SQL Blog
Your E-mail: admin@boneyard.org
Click Install WordPress

Login to Wordpress

Logout and do the following

http://blog.obxbill.com/?p=582

Click Dashboard and then Updates

An updated version of WordPress is available.
Click Update Automatically
After you see "WordPress updated successfully", click Go to Dashboard

Thursday, September 16, 2010

WordPress 3.0 Installed on IIS 7.5 with mySQL

Here is a quick layout of instructions in installing WordPress on Windows 2008 R2 IIS 7.5

From IIS

Web Platform Installer
New Web Application box
Select WordPress
Click Install
Click I Accept at the EULA
Enter Site Information
Website: New Web Site
WordPress application name: /
Web Site Name: blog.boneyard.org
Physical Path: c:\inetpub\blog.boneyard.org
IP Address: All Unassigned
Host Name: blog.boneyard.org
Click Continue

Enter Application information
Choose Your database: MySQL
Create New database
Database Administrator: root
Database Name: blogboneyardorg
Finished
Exit

****folder permissions of Modify, Read & Execute, List Folders, Read and Write on the c:\inetpub\SiteName folder to ServerName\IUSR

Open site in a browser
Site Title: Boneyard Blog
Username: admin
Your E-mail: admin@boneyard.org
Click Install WordPress

Login to Wordpress

Logout and do the following

http://blog.obxbill.com/?p=582

Click Dashboard and then Updates

An updated version of WordPress is available.
Click Update Automatically
After you see "WordPress updated successfully", click Go to Dashboard

Thursday, September 2, 2010

WordPress on Windows 2008 R2 IIS7.5 - FTP update?

Screw that.

I added the folder permissions of Modify, Read & Execute, List Folders, Read and Write on the c:\inetpub\SiteName folder to ServerName\IUSR

tada... :)

RDP - on a different port than 3389

If you want your server(s) to listen on another port than 3389 for RDP access, then you will need to modify the following registry key:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp] Port Number