How to: WordPress & Windows Live Writer

For my blog posts, I spend more time in formatting the post than coming up with the actual content. I’m not very comfortable with the built-in WordPress editor mainly because it is browser based. I prefer writing in an desktop version of any editor and copy paste the content to the built-in editor before publishing.

I tried simple editors like notepad & notepad++ but the obvious issue is formatting the whole thing in WordPress editor. I tried typing my content in Evernote. It worked well for normal texts but it screwed up the bullets. Then I tried Microsoft Word. It completely messed up the html code and reformatting was a headache. I googled a litlte bit and learnt that Windows Live Writer is a WYSIWYG (What You See Is What You Get) editor for WordPress. So I decided to give it a shot. The link below neatly explains the steps to configured WordPress with Windows Live Writer and some common issues.

http://www.wpbeginner.com/wp-tutorials/how-to-publish-to-wordpress-remotely-using-windows-live-writer/

The setup was fairly easy and it was up and running in less than a couple of minutes. Here are my observations:

1. Once you configure WLW with your blog, it downloads the theme and adjusts the settings accordingly. If you change the theme, you can update the latest theme by going to Blog Account –> Update theme.

2. You can configure multiple blog accounts.

3. It gives you an option to either post a draft to the blog which you can check in browser or publish directly.

4. Once it downloads the theme settings, it will not allow to change the font size/fonts. I guess you have to customize the fonts in theme settings in WordPress.

5. It allows you to choose the categories and tags.

6. It even has an option to schedule the posts.

WLW_Settings

7. You can insert picture, hyperlinks, videos, Maps, tables etc

8. It has a preview tab at the bottom where you can preview how your blog will look like when you post it. In the preview, it looks like the fonts are too small, but when you post it looks okay.

image

9. It shows the html source as well.

Which editor or tool do you use for blogging? Is there any feature that stands-out?

PS: This is my first post to be published directly from WLW using a schedule. Hope it gets posted well. Fingers crossed!

Configuring SSH server on Windows with password-less key file authentication

[ This is my first technical post in my blog. The reasons behind posting this are (1) I have put quite an effort on getting this work (2) Help others who might be looking to get this work & (3) Showing off 🙂 .

This is my first ever experience with Unix/ssh and i am sure there are other ways to overcome the problem defined below. I did not explore much due to time constraints. I welcome any suggestion/comment regarding any other alternative that would have worked well in this case. ]

Problem:

Currently, our app is running on Windows server. As a part of the app, we would invoke batch scripts that in turn call Hyperion Essbase command line utilities to extract plans from the Hyperion Essbase. The proposed architectural change of moving the app to Linux server posed two challenges with respect to this app:

1. Installing Hyperion Essbase Client on the Linux box

2. Converting all the Windows batch script to Linux format.

This was a challenge majorly because of the tight deadlines and very less experience in installing Hyperion Essbase clients on Linux.

Solution:

As a temporary solution, it was decided to let the batch scripts stay in the Windows box (where it is already running fine) and call the batch scripts from the Linux. Please note that setting up Samba directory and then calling the batch script from Linux will not help. Because the batch file will still be invoked on the Linux box that calls the script and not on the Windows where it is present. So the best way to do it is to set up SSH server on Windows that would allow a login from the Linux box and invoke the batch script. This way the batch script will run on the Windows box where it is invoked and not on the Linux box where it is called from.

There are variety of SSH servers available on the internet like OpenSSH, FreeSSHD etc.,. Here I am listing the steps involved in configuring  SSH on Windows using FreeSSHD and setting up of password less key file authentication.

Installation and Configuration Steps for FreeSSHD:

1. Download FreeSSHD software from http://www.freesshd.com/?ctt=download

2. Install the Software on the Windows box (say, Win1) where the batch scripts are running currently. [Please make sure this is installed with Administrator privileges. Else, it will not complain about anything but will fail to work without throwing any error ]

3. In freeSSHd settings, make sure SSH Server is running in the Server Status Tab

4. In freeSSHd settings, go to Users tab and add the windows logon user (eg., anon). This is the user that will be used to logon to this Windows box using SSH and invoke the scripts.

5. Set the Authorization to Public Key (SSH Only)

6. In freeSSHd settings, go to Authentication tab and

a. Set Password Authentication to Disabled

b. Set Public key Authentication to Required

This is for setting up Password less key file authentication

7. Download and run puttygen utility that will generate private-public key pairs.

8. Once the key is generated in the puttygen, go to Conversions -> Export OpenSSH key and export the public key to Openssh format. Copy it to notepad

9. In the windows box (Win1) where freeSSHd is installed, browse to c:\program files(x86)\freesshd\, create a file with the same name as the user (anon) without any extension and paste the public key generated by step 8 above.

10. In the Linux box (say Linux1), cd into $HOME/.ssh folder. If .ssh folder is not there, create the folder using mkdir command

11. Create a file called id_rsa.pub in this $HOME/.ssh folder and copy the key generated by step 8 above.

12.  Save the private key from puttygen and copy it the linux box as $HOME/.ssh/id_rsa . This can be either FTP-ed or the contents of the private key can be copied from the saved file and then pasted to id_rsa file. Note that private key file does not have any extension. And this file should not be shared with anyone else.

13. Set the permission levels to 600 on the .ssh folder by the below command:

chmod –R 600 .ssh

Now it should be possible to login to the Windows box from linux through SSH without having to give any password. Below is the ssh command:

ssh <username>@<Windowsservername>

(eg.)   ssh anon@Win1

A shell script with this command clubbed with the commands to run the batch script can be created and called from any other app to run the batch scripts.