oscarfoley – Page 3 – Another Data Engineer blog

05/02/2015

Function to check if MarkLogic is up

Function to quickly see if MarkLogic is up and running

function PingMarkLogic($server)
{
    $uri = "http://$($server):8001/cluster-status.xqy"
    $adminCredential = new-object -typename System.Management.Automation.PSCredential -argumentlist "admin", $(ConvertTo-SecureString "admin" -Force -AsPlainText)
    try
    {
        $resp1 = Invoke-WebRequest -Uri $Uri -Method "GET" -Credential $adminCredential -ContentType "application/x-www-form-urlencoded" -ErrorAction SilentlyContinue
        return $resp1.StatusCode
    }
    catch [System.Net.WebException] 
    {
        return $resp1.StatusCode
    }

}

function PingMarkLogic($server)

{

$uri = "http://$($server):8001/cluster-status.xqy"

$adminCredential = new-object -typename System.Management.Automation.PSCredential -argumentlist "admin", $(ConvertTo-SecureString "admin" -Force -AsPlainText)

try

{

$resp1 = Invoke-WebRequest -Uri $Uri -Method "GET" -Credential $adminCredential -ContentType "application/x-www-form-urlencoded" -ErrorAction SilentlyContinue

return $resp1.StatusCode

}

catch [System.Net.WebException]

{

return $resp1.StatusCode

}

Taken from my unsuccessful StackOverflow answer 🙂

01/11/2014

Function to SmartCreate Folder in Powershell

Function to create a folder in Powershell if it doesn’t exist or recreate if it exists

function SmartCreateFolder([string] $folder, [bool] $deleteFolderContents = $false )
{
    $hostname= $env:COMPUTERNAME
	if (Test-Path $folder)
    {
        Write-Output "SmartCreateFolder($hostname): Folder detected $folder"
        if ($deleteFolderContents)
        {
            Write-Output "SmartCreateFolder($hostname): Deleting contents in folder $folder"
            Remove-Item $folder -Force -Recurse
        }
        else
        { 
            Write-Output "SmartCreateFolder($hostname): Folder ($folder) already exists, nothing has been done. If you want to delete existing data in $folder use parameter -deleteFolderContents."
            exit 0
        }
    }
    New-Item -ItemType Directory -Force -Path $folder | Out-Null
    Write-Output "SmartCreateFolder($hostname): Folder created $folder"
}

function SmartCreateFolder([string] $folder, [bool] $deleteFolderContents = $false )

{

$hostname= $env:COMPUTERNAME

if (Test-Path $folder)

{

Write-Output "SmartCreateFolder($hostname): Folder detected $folder"

if ($deleteFolderContents)

{

Write-Output "SmartCreateFolder($hostname): Deleting contents in folder $folder"

Remove-Item $folder -Force -Recurse

}

else

{

Write-Output "SmartCreateFolder($hostname): Folder ($folder) already exists, nothing has been done. If you want to delete existing data in $folder use parameter -deleteFolderContents."

exit 0

}

New-Item -ItemType Directory -Force -Path $folder | Out-Null

Write-Output "SmartCreateFolder($hostname): Folder created $folder"

}

29/07/2014

How to improve PUTTY default blue colour?

Category: Window > Colours

ANSI Blue: Red:74 Green:74 Blue:255
ANSI Blue Bold: Red:140: Green:140 Blue:255

Result:

More tips: http://dag.wiee.rs/blog/content/improving-putty-settings-on-windows

14/07/2014

Execute function in remote Computer

This is an example of how to execute PowerShell remote code and pass parameters:

$server="localhost"
$remotingPort=5985

Invoke-Command -Port $remotingPort -ComputerName $server -FilePath "C:\k\remote_functions.ps1" -ArgumentList @("Write5Strings", "apple", "banana", "orange", "pear", "watermelon")

$server="localhost"

$remotingPort=5985

Invoke-Command -Port $remotingPort -ComputerName $server -FilePath "C:\k\remote_functions.ps1" -ArgumentList @("Write5Strings", "apple", "banana", "orange", "pear", "watermelon")

param($command, $param1, $param2, $param3, $param4, $param5)
$ScriptVersion = "1.0"

function Write5Strings($string1, $string2, $string3, $string4, $string5)
{
    Write-Host "String1: $string1"
    Write-Host "String2: $string2"
    Write-Host "String3: $string3"
    Write-Host "String4: $string4"
    Write-Host "String5: $string5"
    throw "ERROR"
}


try
{
    &$command $param1 $param2 $param3 $param4 $param5
}
catch [System.Exception]
{
    Write-Host $_.Exception.ToString()
    exit 1
}

param($command, $param1, $param2, $param3, $param4, $param5)

$ScriptVersion = "1.0"

function Write5Strings($string1, $string2, $string3, $string4, $string5)

{

Write-Host "String1: $string1"

Write-Host "String2: $string2"

Write-Host "String3: $string3"

Write-Host "String4: $string4"

Write-Host "String5: $string5"

throw "ERROR"

}

try

{

&$command $param1 $param2 $param3 $param4 $param5

}

catch [System.Exception]

{

Write-Host $_.Exception.ToString()

exit 1

}

19/05/2014

Git first steps in Windows

This is the software used in Windows to have a GIT Client

Install latest Git version (http://git-scm.com)
Ensure to remove Windows Explorer Integration as we should use TortoiseGit.
Install latest TortoiseGit version (https://code.google.com/p/tortoisegit)
Alternative to TortoiseGit is GitExtensions (No file icons in Windows Explorer, installs kdiff)
Install Beyond Compare 3.0 and configure TortoiseGit to use Beyond Compare
Optionally install Visual Studio Tools for Git. for Visual Studio 2012-SP3 (Visual Studio 2013 includes Git tools by default)
Optionally install PoshGit to have enhanced git coloured shell
Optionally install Attlasian Source Tree

11/05/2014

How to fix PowerShell remoting not working

If Powershell remoting is not working between two servers check this:

Check if winrm service is running. Full name is Windows Remote Management (WS-Management)
Execute winrm quickconfig
Enable-PSRemoting -Force command on server.
Get-ExecutionPolicy -List to check that you can execute…
Check that winrm port is the same as listener port
- Winrm port: winrm get winrm/config
- Listener port: winrm enumerate winrm/config/listener
- Change listener port by (from elevated cmd!!!):
  Winrm set winrm/config/listener?Address=*+Transport=HTTP @{Port=”5985″}
Check Windows Firewall is not blocking port.
Check that choosen port (5985 or 81) is open (Cryping, NMap)
Check TrustedHosts list

PowerShell

Get-Item WSMan:\localhost\Client\TrustedHosts Set-Item WSMan:\localhost\Client\TrustedHosts -value * Restart-Service winrm -Force

1
2
3

Get-Item WSMan:\localhost\Client\TrustedHosts
Set-Item WSMan:\localhost\Client\TrustedHosts -value *
Restart-Service winrm -Force
Test with Invoke-Command -ComputerName SERVER -Port 5985 -ScriptBlock {“C:\Program files” | Get-ChildItem}
Test Invoke-Command with Credentials

$server="xxxx"
$remotingPort=5985
$Username = 'yyyy'
$Password = 'zzzz'
$pass = ConvertTo-SecureString -AsPlainText $Password -Force
$Cred = New-Object System.Management.Automation.PSCredential -ArgumentList $Username,$pass
Invoke-Command -ComputerName $server -Port $remotingPort -ScriptBlock {“C:\Program files” |  Get-ChildItem} -Credential  $Cred

$server="xxxx"

$remotingPort=5985

$Username = 'yyyy'

$Password = 'zzzz'

$pass = ConvertTo-SecureString -AsPlainText $Password -Force

$Cred = New-Object System.Management.Automation.PSCredential -ArgumentList $Username,$pass

Invoke-Command -ComputerName $server -Port $remotingPort -ScriptBlock {“C:\Program files” | Get-ChildItem} -Credential $Cred

13/04/2014

How to fix Visual Studio 2013 default UI?

My preferred actions to fix it.

Change theme (Blue/Dark/Light)
- Menu TOOLS / options / General and choose Color Theme

Change the menus casing from UPPERCASE to SentenceCase (reference)

Menu TOOLS / Library Package Manager / Package Manager Console and enter and run Set-ItemProperty -Path HKCU:\Software\Microsoft\VisualStudio\12.0\General -Name SuppressUppercaseConversion -Type DWord -Value 1

Disable expanding file contents in Solution Explorer (reference)
- Go to HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\12.0 and add a new dword value named UseSolutionNavigatorGraphProvider with a value of 0.

Change Icons
- Follow steps here

12/04/2014

Conway’s Game of Life implementation in C# & Winforms

Here is an old small demo of Conway’s Game of Life developed in C# (.Net 2.0) & Visual Studio 2010

Source code is public in GitHub: https://github.com/cadvga/1-GameOfLife.git