Recently had to setup readonly access to all databases on a SQL Server, in the past this would have involved assigning roles to a login and that login to all databases, and then repeating for all new databases.
In SQL 2014 a new command allows for this to be simplified.
GRANT CONNECT ANY DATABASE TO [domain\AD-Group] GO GRANT SELECT ALL USER SECURABLES TO [domain\AD-Group]
ref: http://www.sqlservercentral.com/articles/Security/111116/
Recently had to work on sending emails from a powershell script using the office365 smtp server. This means I had to use TLS and also use authentication.
Script below is pretty simple and does not encrypt the password in the script this just a poc.
The script creates an array of users to send the email to ($users), then this is looped through.
This line creates the email object, this is the best way to send email and I believe the only way if you need to enable TLS.
$client = New-Object system.Net.Mail.SmtpClient $smtpserver, $port
Using the new email object this line enables TLS
$client.EnableSsl = $true
This next line creates the user credentials that the object will use to authenticate with office365 system when it tries to send the email.
$client.Credentials = New-Object System.Net.NetworkCredential( $office365User , $office365Password );
I leave in, but its commented out, but you can get it you use the account the script is run under.
#$client.Credentials = [system.Net.CredentialCache]::DefaultNetworkCredentials
Full script
[string]$to = "" [String]$from = "<office365User@office365domain.com>" [String]$subject = "<subject>" [String[]]$users = "<user1@domain.com>, <user2@domain.com>" [String]$smtpserver = "smtp.office365.com" [string]$office365User = '<office365User@office365domain.com>'; [string]$office365Password = '<office365UserPassword>'; [String]$port = 25 foreach ($user in $users) { trap { #$CRLF added because usual `r`n in string doesnot work within trap. [string]$CRLF = [char]13 + [char]10 $script:errorMessage += '"' + $smtpserver + '" : Error: {0}' -f $_.Exception.Message + $CRLF; $Error.Clear(); continue; } $to = $user $output = "<pre>" + "<font color='#800000'>scriptErrors: `r`n" + $script:errorMessage + "</font>`r`n" $output += "<b>" + $outputHeader + "</b><font color='#800000'>" + $outputAlert + "</font>" + "<b>" + $outputSubHeader + "</b>" + $outputAll + "</pre>" # Create mail message $message = New-Object system.net.mail.MailMessage $message.From = $from; foreach ($useremail in $to) { $message.To.Add($useremail); } $message.Subject = $subject; $message.Body = $output; $message.IsBodyHtml = $true; #Create SMTP client $client = New-Object system.Net.Mail.SmtpClient $smtpserver, $port $client.EnableSsl = $true # Credentials are necessary if the server requires the client # to authenticate before it will send e-mail on the client's behalf. #$client.Credentials = [system.Net.CredentialCache]::DefaultNetworkCredentials $client.Credentials = New-Object System.Net.NetworkCredential( $office365User , $office365Password ); # Try to send the message $client.Send($message) # reset variables $body = "" $message.Dispose() $client.Dispose() }
Most of my IIS scripts will be setting the IIS config options in the applicationhost.config file. This is a personal preference, it puts all config in one central location and prevents the web.config files potentially being modified and deleted in code deployments.
Add-PSSnapin WebAdministration -ErrorAction SilentlyContinue Import-Module WebAdministration -ErrorAction SilentlyContinue #<name> is the application pool name --Set the idle time to 0(off) Set-ItemProperty ("IIS:\AppPools\<name>") -Name processModel.idleTimeout -value ( [TimeSpan]::FromMinutes(0)) --disable the regular time of 1740 minutes Set-ItemProperty ("IIS:\AppPools\<name>") -Name Recycling.periodicRestart.time -Value "00:00:00" --Clear any scheduled restart times Clear-ItemProperty ("IIS:\AppPools\<name>") -Name Recycling.periodicRestart.schedule --Set scheduled restart times Set-ItemProperty ("IIS:\AppPools\<name>") -Name Recycling.periodicRestart.schedule -value @{value="05:00:00"}
I include a refernce to the page where I found out how to timestamp each ping request at the bottom of this article.
This code excerpt will timestamp each ping request, redirect it to a log file and then we can use the get-content command to look at the contents of the log file as it is written to (like tail in linux)
filter timestamp {"$(Get-Date -Format o): $_"} ping servername -t | timestamp > c:\temp\logging.txt
#tail log
Get-Content c:\temp\logging.txt -wait
To tail in powershell
Get-Content c:\temp\logging.txt -Tail 10 –Wait
Returns last 10 lines, -wait will then wait for new entries
References:
[string]$userName = 'user1'; [string]$exeName = 'cmd.exe'; Get-WmiObject -Query "Select * from Win32_Process where name = "$exeName" | Select Name, Handle, @{Label='Owner';Expression={$_.GetOwner().User}} | Where-object {$_.Owner -like "$userName"} | Select-object @{Label='Handle';Expression={[int]$_.Handle}} |foreach { stop-process -id $_.Handle -force }
Recently had to add some requestfiltering deny rules to a number of servers. This was because of a detected vunerabiltiy with Coldfusion and its admin portal.
So to achieve this quickly and consistently I developed the following powershell script.
It adds a deny rule at the server level and then an removes the rule for the CF administration portal site.
The first two lines ensure that the web administration tools are imported in all versions of powershell.
I like my config to be in the central applicationhost.config file, which runs less risk of developers overwriting the config in a web.config file. The line
-pspath 'MACHINE/WEBROOT/APPHOST'
ensures the config is saved in the applicationhost.config file.
–location "CFAdminPortal”
This line ensures that the config is applied to the site called CFAdminPortal
Add-PSSnapin WebAdministration Import-Module WebAdministration #Add requestfiltering Add-WebConfigurationProperty -pspath 'MACHINE/WEBROOT/APPHOST' -filter "system.webServer/security/requestFiltering/denyUrlSequences" -name "." -value @{sequence='/CFIDE'} #Remove requestfiltering for the CFIDE site Remove-WebConfigurationProperty -pspath 'MACHINE/WEBROOT/APPHOST' –location "CFAdminPortal" -filter "system.webServer/security/requestFiltering/denyUrlSequences" -name "." -AtElement @{sequence='/CFIDE'}
function Get-ScriptDirectory{ #Determine the folder in which the script lives. $Invocation = (Get-Variable MyInvocation -Scope 1).Value Split-Path $Invocation.MyCommand.Path}#[string]$CRLF#needed to find the location of the script.$scriptPath = Get-ScriptDirectory
[String]$scriptCurrentDateTime = Get-Date -format "yyyyMMddHHmmss"
$headers = @{ 'X-Auth-Key' = '<auth-key>'; 'X-Auth-Email' = '<email>'; 'Content-Type' = 'application/json' }
[string]$urlRequest = 'https://api.smscompanyurl.com/api-adv.php?';[string]$smsUsername = '<username>';[string]$smsPassword = '<password>';[string]$smsNumbers = '<phonenumber1>,<phonenumber2>,<phonenumber3>';[string]$smsFrom = '<Company Name>';[string]$smsMessage = [uri]::EscapeDataString('Office IP Address has changed. Attempting auto update.');
$ZoneRecords = @('temp.contoso.com','tempytemp.contoso.com')
[string]$Zone = 'contoso.com';[string]$cloudFlareApiBaseUrl = 'https://api.cloudflare.com/client/v4';[string]$public_IP='';[string]$public_IP='';
# Get Zone ID from cloudflare try { $request = Invoke-WebRequest -Uri "${cloudFlareApiBaseUrl}/zones/?name=${Zone}" -Method 'GET' -Headers $headers } catch { $MyError = $_ Throw $MyError } $zoneId = $(ConvertFrom-Json $request.Content).result[0].id
#Lookup external ip try { $public_IP = (Invoke-RestMethod https://api.ipify.org?format=json).ip.trim() } catch { $MyError = $_ Throw $MyError }
Foreach ($Element IN $ZoneRecords) {
#GET record info from cloudflare #$RecordVPNweb = Invoke-WebRequest -Uri "${cloudFlareApiBaseUrl}/zones/${ZoneId}/dns_records/?name=${Element}" -Method 'GET' -Headers $headers try { $RecordVPN = Invoke-RestMethod -Uri "${cloudFlareApiBaseUrl}/zones/${ZoneId}/dns_records/?name=${Element}" -Method 'GET' -Headers $headers -ContentType 'application/json' } catch { $MyError = $_ Throw $MyError } #When using webrequest need to convert from jason #$RecordVPN_ID = $(ConvertFrom-Json $RecordVPN.Content).result[0].id #$RecordVPN_IP = $(ConvertFrom-Json $RecordVPN.Content).result[0].content $RecordVPN_ID = $RecordVPN.result[0].id $RecordVPN_IP = $RecordVPN.result[0].content if ($RecordVPN_IP -ne $public_IP) {
$smsMessage = $smsMessage + [uri]::EscapeDataString("Changing from $RecordVPN_IP to new $public_IP"); $queryString = "username=$smsUsername&password=${smsPassword}&to=${smsNumbers}&from=${smsFrom}&message=${smsMessage}"; ${urlRequest}+${queryString} [string]$textfileName = "$scriptPath\IPChanged$scriptCurrentDateTime.txt" try { #send sms [String]$scriptIPChangeDateTime = Get-Date -format "yyyy-MM-dd HHmmss" [string]$textfileContent = "IP Change attempted at $scriptIPChangeDateTime : ${urlRequest}+${queryString}" out-file -filepath $textfileName -inputobject $textfileContent -encoding ASCII Invoke-RestMethod -Uri "${urlRequest}+${queryString}" -Method 'GET'; } catch { $MyError = $_ Throw $MyError }
$Data = @{ 'id' = "${RecordVPN_ID}"; 'type' = 'A'; 'name' = "${Element}"; 'content' = "${public_IP}"; } # If it exists, UPDATE (PUT), if not, CREATE (POST) [string]$method = 'PUT'; if ($RecordVPN.result.Count -eq 0) { $method = 'POST'; $Data.Remove('id'); }
$DataJson = ConvertTo-Json $Data
try { $JSONResponse = Invoke-RestMethod -Uri "${cloudFlareApiBaseUrl}/zones/${ZoneId}/dns_records/${RecordVPN_ID}/" -Headers $Headers -Body $DataJson -Method "${method}" -ContentType 'application/json' -ErrorAction Stop } catch { $MyError = $_ Throw $MyError } }}
Its great news that Live writer has ben made open source by Microsoft. Please see Open Live Writer (OLW)
There is the code plugin for wordpress
https://richhewlett.com/wlwsourcecodeplugin/
this has been updated to work with Open Live Writer. However I am still waiting on a plugin for blogger in OLW. So in the meantime my process is this.
divCodeBlock {
word-wrap: break-word;
width: 95%;
background: #ffffff;
white-space: pre-line;
border-top: black thin solid;
border-right: black thin solid;
border-bottom: black thin solid;
border-left: black thin solid;
padding-bottom: 2px;
padding-top: 2px;
padding-left: 2px;
padding-right: 2px;
margin-left: auto;
margin-right: auto;
line-height: 1;
}div.divCodeBlock pre {
white-space: pre-wrap; /* Since CSS 2.1 */
white-space: -moz-pre-wrap; /* Mozilla, since 1999 */
white-space: -pre-wrap; /* Opera 4-6 */
white-space: -o-pre-wrap; /* Opera 7 */
word-wrap: break-word; /* Internet Explorer 5.5+ */
}
Publish and bang, “Bob's your auntie's live-in lover”
Recently whilst setting up cloudflare DNS, I had to delete a lot of records. With the API you can only do it one at a time. With thousands of records to remove I put together a little script tot do this.
Please ensure you fully test what you are doing with this, as I take no responsibility, but it worked for me.
You will various things to make this work, and I will assume you know how to use the API, by supplying your API key and email etc….
The script below can, with a small change, either read in the records to delete from a file or you can manually create the array in the script.
The script also contains output debugging that I left in.
Hope it helps somebody
The format of the text file is just a flat text file
I have recently purchased a Kosssel Delta printer from aliexpress.
Trying to set this thing up was a lot more involved than I was hoping, and in addition having a family tends to not leave a lot of time to play. And the instructions are in chinglish 
If you are reading this and a kossel delta printer is going to be your first printer I would recommend you purchase a normal 3d printer, they are a lot easier to get up and running.
Anyway, like most of my blog, these are notes really for more myself. So I am assuming some knowledge pronterface/arduino.
Set Max Height
Pronterface:
Click Home (G28)
Current Pos (M114) – Note Z reading (Zmax)
Now get the head down close to the bed using the controls in pronterface put the head near the printer bed. Place a piece of paper between the head and the platform bed, using the controls (0.1mm each step) get the head down onto the paper, until you are unable to move the paper.
Current Pos (M114) – Note Z reading (Zmin)
Now work out the Z range
Zmax – Zmin = Zrange
294.60 – (-5.69) = 300.29
Now disconnect pronterface from the printer.
Fire up arduino software and open the Marlin.ino file, this will open the project. We need to edit the configuration.h file. We need to update MANUAL_Z_HOME_POS
// The position of the homing switches
#define MANUAL_HOME_POSITIONS // If defined, MANUAL_*_HOME_POS below will be used
#define BED_CENTER_AT_0_0 // If defined, the center of the bed is at (X=0, Y=0)
//Manual homing switch locations:
// For deltabots this means top and center of the cartesian print volume.
#define MANUAL_X_HOME_POS 0
#define MANUAL_Y_HOME_POS 0
#define MANUAL_Z_HOME_POS 300.29 // For delta: Distance between nozzle and print surface after homing.
OK, so now the bed height at [X0 Y0] should be 0. So we will call this Zm.
Ok, so we are started. The Z height is set. now lets do some manual leveling… We are going to take the Z readings from various points (X,Y) over the bed.
Using the same method we used to get the Z reading a X=0, Y=0. edge the head down until you unable to move the A4 paper.
Now repeat for
Once you have Za, Zb, Zc readings at 0. Read them all again to ensure they are all still 0, adjust if necessary,
G28 return to home
Now we are going to adjust for the curvature (not sure that is the right term but we are going to be setting the SMOOTH_ROD_OFFSET setting in the configuration.h file.)
Now lets read the Z bed at [G1 X0 Y0] again (using the A4 process). Lets call this Zz. You should find its no longer 0. Now there probably is some scientific way to do this but my manual was just trial and error….
Adjust in the configuration.h file and upload to arduino again.
-0.5 is less than 0, so I need to increase
// Horizontal offset from middle of printer to smooth rod center.
#define DELTA_SMOOTH_ROD_OFFSET 154// mm
So I adjusted to 155
// Horizontal offset from middle of printer to smooth rod center.
#define DELTA_SMOOTH_ROD_OFFSET 155// mm
Now we are just trying to get Za,Zb,Zc,Zz to the same value, so don’t expect Zz to change. You must keep taking measurement of all and adjust the various settings…. Its a pain…
I had to adjust the stops again on the Z Tower roller. Then I retook the readings. Zz was –0.7 and Za,Zb,Zc were –0.5. So increase the ROD offset
// Horizontal offset from middle of printer to smooth rod center.
#define DELTA_SMOOTH_ROD_OFFSET 155.5// mm
With this settings and a few adjusts of the stops on each roller I got all Z values to match at -0.7
Ok, now we need to set the max height again.
Zmax – Zmin = Zrange
300.29 – (-0.7) = 300.99
#define MANUAL_Z_HOME_POS 300.29
Note: In trying to setup my printer I had to go through this process about 15 times (thats no joke). Many failed prints…
Things learnt, don’t adjust the flowrate, i thought some of my jams were being caused by this. But in the end I reckon I just made it worse.
Best result I got was setting temp to 195. I did jump into repetier and adjust the speed in the slicer config. but in the end did that fix anything… who knows….
One thing I did in one of the many hot end rebuids was to push the filament sleeve all the way down inside the hot end. Original I just pushed it into the connector as I thought it was just guiding the filament in. However I now think this provides guidance and some heat protection as it travels down. I think this was a caused of the jams I was having.
Also I believe I had the feed wheels clamped too tight, which was marking/crushing the filament. As such this caused the filament to jam.
In all I think I have spent around 20 –30 hours setting this thing up…
The future is now….
p.s. One other thing when rebuilding the hot end, let it heat up and then tighten again. I did a run without doing this and it leaked out from the screw threads…
