My Note: 2015

Public key authentication using Cygwin

Overview

Enabling public key authentication allows us to seamlessly, without having to interactively enter credentials, perform the following tasks...

scp files from one host to another
Execute commands on remote host
Log on to remote host

The Cygwin sshd server runs as a Windows service under the Local SYSTEM account created with special privileges to run the service. For a Windows 2003 Server, sshd runs under local account, sshd_server. The sshd server authenticates user logins using a public/private key-pair.

Configure Cygwin sshd

In this example, we configure password-less public key authentication to a remote Worklight host. We will leverage a user named "WorklightAdmin"

Install Cygwin.During installation, select the following packages...
- Admin --> cygrunsrv
- Net --> openssh
After installation, edit...
...add the following line...
For example...
Start a Cygwin terminal using "Run as Administrator"
Verify Cygwin is installed property...
All Cygwin help options should display on the screen.
From a bash shell, configure SSH...
You are prompted to answer the following questions:
At this point, for our example, we enter yes, and then plug in our WorklightAdmin user name and password...
If the configuration is successful, you will see the following message:
If you ever want to change the login ID of the Cygwin sshd service afterwards...
1. Open the Services panel
2. Stop the sshd service.
3. Next, select the Log on tab. Under the Log on as section or prompt, clear the Local System account radio button, and select This account.
4. Type .\WorklightAdmin as the ID and type the password for the account. Click Apply.
Grant additional rights to the WorklightAdmin account. Ensure that the account has the required privileges in addition to membership to the Administrators group.
1. From the Windows Start menu, click...
2. Verify the WorklightAdmin account has the following four rights:
  - Adjust memory quotas for a process
  - Create a token object
  - Log on as a service
  - Replace a process level token
  If not, add WorklightAdmin as a user with the four rights.
Close the Local Security Settings window.
From a Cygwin console panel, change ownership of the following directories and files to WorklightAdmin:
- chown WorklightAdmin /var/log/sshd.log
- chown -R WorklightAdmin /var/empty
- chown WorklightAdmin /etc/ssh*
Restart the Cygwin sshd service.
...or...
To achieve a password-less login from HostA --> remoteWLhost
1. Login to HostA as user WorklightAdmin
2. Copy contents of...
  If .ssh/id_rsa.pub does not exist, run..
  Leave passphrase blank.
3. Log on to remote host (remoteWLhost) and paste the public key to...
  If the directory and/or file do not exist, create them.
4. Set permissions...
You can now run commands such on HostA such as...

Non-admin userID

If you try to connect to the Windows workstation using a non-administrator user ID, you might get error...

...add the user account to the Administrators group...

Go to...
Add the Administrators group to the list of groups that this account belongs to.
From the admin console, click...

Change public location in sshd_Config

# The default is to check both .ssh/authorized_keys and .ssh/authorized_keys2

# but this is overridden so installations will only check .ssh/authorized_keys

AuthorizedKeysFile /home/.ssh/authorized_keys

Post your JSON in http://json2csharp.com/. Take the resulting classes and merge duplicates, and you get:

public class AddressComponent
{
    public string long_name { get; set; }
    public string short_name { get; set; }
    public List<string> types { get; set; }
}

public class Bounds
{
    public Location northeast { get; set; }
    public Location southwest { get; set; }
}

public class Location
{
    public double lat { get; set; }
    public double lng { get; set; }
}

public class Geometry
{
    public Bounds bounds { get; set; }
    public Location location { get; set; }
    public string location_type { get; set; }
    public Bounds viewport { get; set; }
}

public class Result
{
    public List<AddressComponent> address_components { get; set; }
    public string formatted_address { get; set; }
    public Geometry geometry { get; set; }
    public bool partial_match { get; set; }
    public List<string> types { get; set; }
}

public class RootObject
{
    public List<Result> results { get; set; }
    public string status { get; set; }
}

Deserialize your JSON with Json.NET like so:

    var root = JsonConvert.DeserializeObject<RootObject>(result);

There are multiple results returned for your query, so you need to loop through the locations returned like so:

    foreach (var singleResult in root.results)
    {
        var location = singleResult.geometry.location;
        var latitude = location.lat;
        var longitude = location.lng;
        // Do whatever you want with them.
    }

My Note

Excel data export to SQL database

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine Error

Public key authentication using Cygwin

Public key authentication using Cygwin

Overview

Configure Cygwin sshd

Non-admin userID

Database cannot attached because it is already existed in MVC 5

Parse JSON in C#

About Me