gavincampbell

{
    "variables": {
        "build_location": "uksouth",
        "build_vm_size": "Standard_DS2_v2",
        "sp_client_id": "{{env `PACKER_CLIENT_ID`}}",
        "sp_client_secret":  "{{env `PACKER_CLIENT_SECRET`}}",
        "sp_tenant_id":  "{{env `PACKER_TENANT_ID`}}",
        "sp_subscription_id": "{{env `PACKER_SUBSCRIPTION_ID`}}",
        "output_resource_group" : "packer-vm-images",
        "output_image_name_prefix" : "sql-2019-win-2019"

gavincampbell

By Other People

Using Pester for Infrastructure Tests

Blog Entry by Rob Sewell with link to conference talk

Azure RM Templates

Cheat sheet for retrieving output values from ARM Resources by Justin Yoo

Azure DevOps Extensions

• ARM Outputs

gavincampbell

Write-Output "Disabling WinRM over HTTP..."
Disable-NetFirewallRule -Name "WINRM-HTTP-In-TCP"
Disable-NetFirewallRule -Name "WINRM-HTTP-In-TCP-PUBLIC"
Get-ChildItem WSMan:\Localhost\listener | Remove-Item -Recurse

Write-Output "Configuring WinRM for HTTPS..."
Set-Item -Path WSMan:\LocalHost\MaxTimeoutms -Value '1800000'
Set-Item -Path WSMan:\LocalHost\Shell\MaxMemoryPerShellMB -Value '1024'
Set-Item -Path WSMan:\LocalHost\Service\AllowUnencrypted -Value 'false'
Set-Item -Path WSMan:\LocalHost\Service\Auth\Basic -Value 'true'

gavincampbell

#!/bin/bash

### VARIABLES ###
PRE_PACK="openssl-devel pcre-devel make gcc"
VER="1.8.14"

# Setup Colours
black='\E[30;40m'
red='\E[31;40m'
green='\E[32;40m'

gavincampbell

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "VisualEditor0",
            "Effect": "Allow",
            "Action": [
                "ec2:AttachVolume",
                "ec2:AuthorizeSecurityGroupIngress",
                "ec2:DeregisterImage",

gavincampbell

#Creating a pscredential from a username:password pair in a single line:
$Creds = New-Object System.Management.Automation.PSCredential ($User, $(ConvertTo-SecureString $Password -AsPlainText -Force))
#Self signed wildcard certificate
New-SelfSignedCertificate -Subject *.my.domain -DnsName my.domain, *.my.domain -CertStoreLocation Cert:\LocalMachine\My -NotAfter (Get-Date).AddYears(10)
# trusting the PS gallery so we can install packages unattended, e.g. for DSC
Install-PackageProvider NuGet -Force -Scope CurrentUser
Import-PackageProvider NuGet -Force 
Set-PSRepository -Name PSGallery -InstallationPolicy Trusted

gavincampbell

[CmdletBinding()]
param([object]$WebhookData)


if ($WebhookData){

    $requestBody = (ConvertFrom-Json -InputObject $WebhookData.RequestBody)
    $refspec =  $requestBody.resource.SourceRefName

    $branchName = $requestBody.resource.SourceRefName.Split("/")[-1]

gavincampbell

Vagrant.configure("2") do |config|
  config.vm.box = "centos/7"
  config.vm.network "forwarded_port", guest:1433, host:1433
 
  config.vm.provider :libvirt do |libvirt|
	    libvirt.memory = "4096"
    end
  
    config.vm.provision "shell", 
     inline: <<-SHELL

gavincampbell

node{
    
    checkout scm
    def the_one_to_run
     if (env.BRANCH_NAME == "master"){
        the_one_to_run = load 'master.groovy'
     }
         else{
        the_one_to_run = load 'not-master.groovy'
         }

gavincampbell

IF NOT EXISTS (SELECT * FROM testIMAGE where ID = 2)
BEGIN
INSERT INTO testIMage VALUES
(2, 
0x89504E470D0A1A0A0000000D49484452000001480000014808060000003214673300000006624B474400FF00FF00FFA0BDA793000000097048597300000048000000480046C96B3E000038034944415478DAED9D779C5D55B9B09F5DCE39FBF439D36B32E93D19121242092D14814B0B28E5A2A05CAEE2FDB8D8BB5851E4AAD7AE572F227A45400101E98890400209E999F4C964D233BD9CDEF6F7C749A4972453CEDEFB7D7E3FFF904C3267AFBDD673DEB5D6BBDEA59BA66922088220BC095D9A4010044104290882208214044110410A822088200541104490822008224841100411A4200882085210044104290882208214044110410A822008224841100411A4200882085210044104290882208214044110410A822088200541104490822008224841100411A4200882085210044110410A822088200541104490822008224841100411A4200882085210044104290882208214044110410A82208820054110449082200882085210044104290882208214044110410A822088200541104490822008224841100411A4200882085210044104290882208214044110449023409E54324F3C6792CE9B28AFF913435308E92AB85578DD9FD88B64264B2A9B239DCD9248675194B77956D304452168B