Tag: command
-
Kubernetes experience – the monitoring
Previously… Overview If you read my previous / first post, you know that by now I have Mini-PC with Proxmox Virtualization and a Kubernetes cluster of 3 nodes. All nice fresh and empty, a diagram of core elements is above. Now, let’s begin. The target for monitoring, at this point, is to have Prometheus for…
-
MySQL / Percona profiler
Hey, this is designed to profiles SQL queries on Percona Cluster, however it would run on normal MySQL without any issues. Log into mysql console and run the following (don’t logout of console until finished profiling, or take note of the changed variables): Wait for some time – 30-60 minutes, allow the queries to be…
-
MS SQL full database search procedure
This is a neat procedure to search for a string in all MS SQL database: After you created this procedure, do a search with the following: exec [dbo].[Find_My_String] ‘searchstring’, 0
-
PowerShell
Run remote commands in powershell Run the following command to authencitate and execute commands remotely
-
Windows system integrity checks
Here are some useful commands to check windows system integrity. First of all, launch a command prompt with privileged permissions: First of all, lets run System File Checker: Next lets run Deployment Image Servicing and Management tool. Let’s check first: Next commands are for repairing. If you have your installation ESD or WIM file –…
-
Windows Licence / Product Key management
View Activation, License, and Expiration Date Information View the License Expiration Date Upgrade Home to Pro Uninstall the Product Key Clear registry Reboot Option 1 – upgrade by removing old and installing new key Set or Change the Product Key Option 2 – upgrade by using Microsoft RTM code Disconnect from the network – you…
-
SSH
Convert OpenSSH key to RSA This command converts it ! in-place !, so make sure to have a copy of original, if you even need one: Bypass strict SSH host key checking An SSH command has two useful parameters: This little workaround came in handy a few times already. It shouldn’t be used always, as…
-
OpenSSL
Just a few commands that helped me a lot while working with SSL certificates and keys. Generate AWS private key’s fingerprint using openssl: Check if certificate and intermediate match each other Execute following and look for “X509v3 Authority Key Identifier” Execute following and look for “X509v3 Subject Key Identifier” Check Certificate agains Private Key This…