DevOps Notebook - User contributions [en]

Quickly create folders for database on empty drives

2026-02-28T14:25:16Z

MilosZ: Created page with "For powershell <pre> foreach ($drive in 'A','D','R') { foreach ($folder in 'Data','Log') { New-Item -ItemType Directory -Force -Path "$drive`:\MSSQL\$folder"..."

For powershell 
<pre>
foreach ($drive in 'A','D','R') {
foreach ($folder in 'Data','Log') {
New-Item -ItemType Directory -Force -Path "$drive`:\MSSQL\$folder"
}
}
</pre>

For CMD 
<pre>
for %%d in (A D R) do (
mkdir %%d:\MSSQL\Data
mkdir %%d:\MSSQL\Log
)
</pre>

MSSQL

2026-02-28T14:24:35Z

MilosZ:

==Microsoft SQL Server==

[[Send email using stored procedure in mssql]] 
[[Setup SSL Certificate for MSSQL]] 
[[Setup Microsoft ODBC drivers for use with pyodbc]] 
[[Quickly create folders for database on empty drives]] 

Troubleshooting: 
[[MSSQL Database stuck in restore state]]

Update mysql user password

2025-08-08T09:42:15Z

MilosZ:

<big>Few methods of changing mysql user password</big> 
Method 1: Using ALTER USER (MySQL 5.7.6+)
<syntaxhighlight lang="sql">
ALTER USER 'username'@'hostname' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 2: Using SET PASSWORD
<syntaxhighlight lang="sql">
SET PASSWORD FOR 'username'@'hostname' = PASSWORD('new_password');
FLUSH PRIVILEGES;
</syntaxhighlight>
For MySQL 5.7.6+ you can also use:
<syntaxhighlight lang="sql">
SET PASSWORD FOR 'username'@'hostname' = 'new_password';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 3: Using UPDATE (not recommended)
<syntaxhighlight lang="sql">
UPDATE mysql.user SET Password = PASSWORD('new_password')
WHERE User = 'username' AND Host = 'hostname';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 4: Using mysqladmin (command line)
bashmysqladmin -u username -p password new_password
Method 5: Change your own password
If you're changing your own password:
<syntaxhighlight lang="sql">
SET PASSWORD = PASSWORD('new_password');
</syntaxhighlight>
Or in MySQL 5.7.6+:
<syntaxhighlight lang="sql">
SET PASSWORD = 'new_password';
</syntaxhighlight>

Update mysql user password

2025-08-08T09:42:02Z

MilosZ:

<big>Few methods of changing mysql user password</big> 
Method 1: Using ALTER USER (MySQL 5.7.6+)
<syntaxhighlight lang="sql">
ALTER USER 'username'@'hostname' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 2: Using SET PASSWORD
<syntaxhighlight lang="sql">
SET PASSWORD FOR 'username'@'hostname' = PASSWORD('new_password');
FLUSH PRIVILEGES;
</syntaxhighlight>
For MySQL 5.7.6+ you can also use:
<syntaxhighlight lang="sql">
SET PASSWORD FOR 'username'@'hostname' = 'new_password';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 3: Using UPDATE (not recommended)
<syntaxhighlight lang="sql">
UPDATE mysql.user SET Password = PASSWORD('new_password')
WHERE User = 'username' AND Host = 'hostname';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 4: Using mysqladmin (command line)
bashmysqladmin -u username -p password new_password
Method 5: Change your own password
If you're changing your own password:
<syntaxhighlight lang="sql">
SET PASSWORD = PASSWORD('new_password');
</syntaxhighlight>
Or in MySQL 5.7.6+:
<syntaxhighlight lang="sql">
SET PASSWORD = 'new_password';
</syntaxhighlight>

Update mysql user password

2025-08-08T09:41:35Z

MilosZ:

'''Few methods of changing mysql user password''' 
Method 1: Using ALTER USER (MySQL 5.7.6+)
<syntaxhighlight lang="sql">
ALTER USER 'username'@'hostname' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 2: Using SET PASSWORD
<syntaxhighlight lang="sql">
SET PASSWORD FOR 'username'@'hostname' = PASSWORD('new_password');
FLUSH PRIVILEGES;
</syntaxhighlight>
For MySQL 5.7.6+ you can also use:
<syntaxhighlight lang="sql">
SET PASSWORD FOR 'username'@'hostname' = 'new_password';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 3: Using UPDATE (not recommended)
<syntaxhighlight lang="sql">
UPDATE mysql.user SET Password = PASSWORD('new_password')
WHERE User = 'username' AND Host = 'hostname';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 4: Using mysqladmin (command line)
bashmysqladmin -u username -p password new_password
Method 5: Change your own password
If you're changing your own password:
<syntaxhighlight lang="sql">
SET PASSWORD = PASSWORD('new_password');
</syntaxhighlight>
Or in MySQL 5.7.6+:
<syntaxhighlight lang="sql">
SET PASSWORD = 'new_password';
</syntaxhighlight>

Update mysql user password

2025-08-08T09:41:19Z

MilosZ:

'''Few methods of changing mysql user password'''
Method 1: Using ALTER USER (MySQL 5.7.6+)
<syntaxhighlight lang="sql">
ALTER USER 'username'@'hostname' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 2: Using SET PASSWORD
<syntaxhighlight lang="sql">
SET PASSWORD FOR 'username'@'hostname' = PASSWORD('new_password');
FLUSH PRIVILEGES;
</syntaxhighlight>
For MySQL 5.7.6+ you can also use:
<syntaxhighlight lang="sql">
SET PASSWORD FOR 'username'@'hostname' = 'new_password';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 3: Using UPDATE (not recommended)
<syntaxhighlight lang="sql">
UPDATE mysql.user SET Password = PASSWORD('new_password')
WHERE User = 'username' AND Host = 'hostname';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 4: Using mysqladmin (command line)
bashmysqladmin -u username -p password new_password
Method 5: Change your own password
If you're changing your own password:
<syntaxhighlight lang="sql">
SET PASSWORD = PASSWORD('new_password');
</syntaxhighlight>
Or in MySQL 5.7.6+:
<syntaxhighlight lang="sql">
SET PASSWORD = 'new_password';
</syntaxhighlight>

Update mysql user password

2025-08-08T09:40:34Z

MilosZ:

<syntaxhighlight lang="mysql">
mysql> ALTER USER 'user-name'@'some_host_ip' IDENTIFIED BY 'NEW_USER_PASSWORD';
mysql> FLUSH PRIVILEGES;
</syntaxhighlight>

Method 1: Using ALTER USER (MySQL 5.7.6+)
<syntaxhighlight lang="sql">
ALTER USER 'username'@'hostname' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 2: Using SET PASSWORD
<syntaxhighlight lang="sql">
SET PASSWORD FOR 'username'@'hostname' = PASSWORD('new_password');
FLUSH PRIVILEGES;
</syntaxhighlight>
For MySQL 5.7.6+ you can also use:
<syntaxhighlight lang="sql">
SET PASSWORD FOR 'username'@'hostname' = 'new_password';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 3: Using UPDATE (not recommended)
<syntaxhighlight lang="sql">
UPDATE mysql.user SET Password = PASSWORD('new_password')
WHERE User = 'username' AND Host = 'hostname';
FLUSH PRIVILEGES;
</syntaxhighlight>
Method 4: Using mysqladmin (command line)
bashmysqladmin -u username -p password new_password
Method 5: Change your own password
If you're changing your own password:
<syntaxhighlight lang="sql">
SET PASSWORD = PASSWORD('new_password');
</syntaxhighlight>
Or in MySQL 5.7.6+:
<syntaxhighlight lang="sql">
SET PASSWORD = 'new_password';
</syntaxhighlight>

MSSQL

2025-04-02T19:19:09Z

MilosZ:

==Microsoft SQL Server==

[[Send email using stored procedure in mssql]] 
[[Setup SSL Certificate for MSSQL]] 
[[Setup Microsoft ODBC drivers for use with pyodbc]] 

Troubleshooting: 
[[MSSQL Database stuck in restore state]]

Setup Microsoft ODBC drivers for use with pyodbc

2025-04-02T19:18:44Z

MilosZ:

<pre>
# /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"
# brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
# brew update
# HOMEBREW_ACCEPT_EULA=Y brew install msodbcsql17 mssql-tools
</pre>

Setup Microsoft ODBC drivers for use with pyodbc

2025-04-02T19:17:37Z

MilosZ: Created page with "<syntaxhighlight lang="bash"> /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)" brew tap microsoft/mssql-release https://github..."

<syntaxhighlight lang="bash">
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
HOMEBREW_ACCEPT_EULA=Y brew install msodbcsql17 mssql-tools
</syntaxhighlight>

MacOS

2025-04-02T19:17:00Z

MilosZ:

[[Recover skype chat information from files]] 
[[Setup Microsoft ODBC drivers for use with pyodbc]]

Windows update are stuck on downloading or install

2024-09-15T13:40:16Z

MilosZ:

=== Reset Windows update components. ===

Resetting Windows Update Components will fix corrupt Windows Update Components and help you to install the Windows Updates. Please follow the below steps to reset the Windows Updates Components manually:

Press Windows Key + X on the keyboard and then select “Command Prompt (Admin)” from the menu.
Stop the BITS, Cryptographic, MSI Installer and the Windows Update Services. To do this, type the following commands at a command prompt. Press the “ENTER” key after you type each command.
<pre>
net stop wuauserv
net stop cryptSvc
net stop bits
net stop msiserver
</pre>
Now rename the SoftwareDistribution and Catroot2 folder. You can do this by typing the following commands in the Command Prompt. Press the “ENTER” key after you type each command.
<pre>
ren C:\Windows\SoftwareDistribution SoftwareDistribution.old
ren C:\Windows\System32\catroot2 Catroot2.old
</pre>
Now, let’s restart the BITS, Cryptographic, MSI Installer and the Windows Update Services. Type the following commands in the Command Prompt for this. Press the ENTER key after you type each command.
<pre>
net start wuauserv
net start cryptSvc
net start bits
net start msiserver
</pre>

Type Exit in the Command Prompt to close it.

Now you may try running the Windows Updates and check if the above steps resolve the issue.

For reference: https://support.microsoft.com/en-us/kb/971058

Optionally if update still gets stuck, you can do all steps until start, 
you can download the updates from Microsoft Catalog and update manually. Search for relevant KB in the Catalog.
 
Microsoft Catalog - https://www.catalog.update.microsoft.com/Home.aspx

Windows update are stuck on downloading or install

2024-09-15T13:37:28Z

MilosZ: Created page with " Method 1: Reset Windows update components. Resetting Windows Update Components will fix corrupt Windows Update Components and help you to install the Windows Updates. Please..."

Method 1: Reset Windows update components.

Resetting Windows Update Components will fix corrupt Windows Update Components and help you to install the Windows Updates. Please follow the below steps to reset the Windows Updates Components manually:

Press Windows Key + X on the keyboard and then select “Command Prompt (Admin)” from the menu.
Stop the BITS, Cryptographic, MSI Installer and the Windows Update Services. To do this, type the following commands at a command prompt. Press the “ENTER” key after you type each command.
<pre>
net stop wuauserv
net stop cryptSvc
net stop bits
net stop msiserver
</pre>
Now rename the SoftwareDistribution and Catroot2 folder. You can do this by typing the following commands in the Command Prompt. Press the “ENTER” key after you type each command.
<pre>
ren C:\Windows\SoftwareDistribution SoftwareDistribution.old
ren C:\Windows\System32\catroot2 Catroot2.old
</pre>
Now, let’s restart the BITS, Cryptographic, MSI Installer and the Windows Update Services. Type the following commands in the Command Prompt for this. Press the ENTER key after you type each command.
<pre>
net start wuauserv
net start cryptSvc
net start bits
net start msiserver
</pre>
5. Type Exit in the Command Prompt to close it.

Now you may try running the Windows Updates and check if the above steps resolve the issue.

For reference: https://support.microsoft.com/en-us/kb/971058

Windows troubleshooting

2024-09-15T13:36:51Z

MilosZ: Created page with "Windows update are stuck on downloading or install "

[[Windows update are stuck on downloading or install]]

Windows

2024-09-15T13:36:32Z

MilosZ:

[[Registry]] 
[[PowerShell]] 
[[CMD]] 
[[Windows Group Policy Management]] 
[[Windows troubleshooting]]

Netstat

2024-07-25T09:56:06Z

MilosZ:

=== Get connections per IP sorted ===
<syntaxhighlight lang="bash">
netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n
</syntaxhighlight>

Netstat

2024-07-25T09:55:53Z

MilosZ: Created page with "=== Get connections per IP sorted === <syntaxhighlight lang="bash"> # netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n </syntaxhighlight>"

=== Get connections per IP sorted ===
<syntaxhighlight lang="bash">
# netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n
</syntaxhighlight>

Mysqldump all tables from database in separate files

2024-04-05T10:23:24Z

MilosZ:

<syntaxhighlight lang="bash">
#!/bin/bash
USER=myuser
PASSWORD=mypwd
DATABASE=nameofdb

for i in $(mysql -uUser -pPASSWORD DATABASE -e "show tables;"|grep -v Tables_in_);do mysqldump -u$USER -p$PASSWORD $DATABASE $i > /destination/dir/$i".sql";done

tar -cjvf "backup_mysql_"$(date +'%Y%m%d')".tar.bz2" /destination/dir/*.sql
</syntaxhighlight>

# version 2
<syntaxhighlight lang="bash">
#!/bin/bash

# MySQL credentials and database information
USER="your_mysql_username"
PASSWORD="your_mysql_password"
DATABASE="your_database_name"
HOST="localhost"

# Backup directory
BACKUP_DIR="/path/to/your/backup/directory"

# Date format to append to the filename
DATE=$(date +%Y%m%d%H%M%S)

# MySQL dump command, don't forget to replace mysql with mysqldump if you're using MariaDB
MYSQLDUMP="/usr/bin/mysqldump"

# Check if backup directory exists
if [ ! -d "$BACKUP_DIR" ]; then
mkdir -p "$BACKUP_DIR"
fi

# Get a list of all tables in the database
tables=$(mysql -u $USER -p$PASSWORD -h $HOST $DATABASE -e 'SHOW TABLES;' | awk '{ print $1}' | grep -v '^Tables' )

for table in $tables; do
echo "Dumping $table"
$MYSQLDUMP --user=$USER --password=$PASSWORD --host=$HOST $DATABASE $table > "$BACKUP_DIR/${DATABASE}_${table}_$DATE.sql"
done

echo "Backup completed!"
</syntaxhighlight>

DROP ALL tables in MySQL database

2024-04-05T10:18:52Z

MilosZ: Created page with "<syntaxhighlight lang="mysql"> DECLARE @cmd varchar(4000) DECLARE cmds CURSOR FOR SELECT 'drop table [' + Table_Name + ']' FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name LIK..."

<syntaxhighlight lang="mysql">
DECLARE @cmd varchar(4000)
DECLARE cmds CURSOR FOR
SELECT 'drop table [' + Table_Name + ']'
FROM INFORMATION_SCHEMA.TABLES
WHERE Table_Name LIKE 'postindex_temp%'

OPEN cmds
WHILE 1 = 1
BEGIN
FETCH cmds INTO @cmd
IF @@fetch_status != 0 BREAK
EXEC(@cmd)
END
CLOSE cmds;
DEALLOCATE cmds
</syntaxhighlight>

MySQL

2024-04-05T10:18:15Z

MilosZ:

=== MariaDB ===
[[MaxScale]] 

[[MySQL Commands snippets ]] 
[[Percona XtraBackup]] 
[[Setting up MySQL Master-Slave replication]] 
[[Setting up MySQL Master-Master replication]] 
[[Add MySQL Slave replication delay]] 
[[MySQL issues and solutions]] 
[[DROP ALL databases in MySQL]] 
[[DROP ALL tables in MySQL database]] 
[[List and DROP all table indexes in MySQL]]

List and DROP all table indexes in MySQL

2024-04-05T10:16:27Z

MilosZ:

<syntaxhighlight lang="mysql">
## List all non-unique indexes
SELECT table_name AS `Table`,
index_name AS `Index`,
GROUP_CONCAT(column_name ORDER BY seq_in_index) AS `Columns`
FROM information_schema.statistics
WHERE NON_UNIQUE = 1 AND table_schema = 'mydb_name' AND table_name = 'mytable_name'
GROUP BY 1,2;

## drop all non-unique indexes
SET SESSION group_concat_max_len=10240;

SELECT CONCAT('ALTER TABLE ', `Table`, ' DROP INDEX ', GROUP_CONCAT(`Index` SEPARATOR ', DROP INDEX '),';' )
FROM (
SELECT table_name AS `Table`,
index_name AS `Index`
FROM information_schema.statistics
WHERE NON_UNIQUE = 1 AND table_schema = 'mydb_name' AND table_name = 'mytable_name'
GROUP BY `Table`, `Index`) AS tmp
GROUP BY `Table`;

## add all non-unique indexes , WITHOUT index length spec
SET SESSION group_concat_max_len=10240;
SELECT CONCAT('ALTER TABLE ', `Table`, ' ADD INDEX ', GROUP_CONCAT(CONCAT(`Index`, '(', `Columns`, ')') SEPARATOR ',\n ADD INDEX ') )
FROM (
SELECT table_name AS `Table`,
index_name AS `Index`,
GROUP_CONCAT(column_name ORDER BY seq_in_index) AS `Columns`
FROM information_schema.statistics
WHERE NON_UNIQUE = 1 AND table_schema = 'mydb_name' AND table_name = 'mytable_name'
GROUP BY `Table`, `Index`) AS tmp
GROUP BY `Table`;

</syntaxhighlight>

List and DROP all table indexes in MySQL

2024-04-05T10:15:38Z

MilosZ: Created page with "<syntaxhighlight lang="mysql"> SELECT table_name AS `Table`, index_name AS `Index`, GROUP_CONCAT(column_name ORDER BY seq_in_index) AS `Columns` FROM informati..."

<syntaxhighlight lang="mysql">

SELECT table_name AS `Table`,
index_name AS `Index`,
GROUP_CONCAT(column_name ORDER BY seq_in_index) AS `Columns`
FROM information_schema.statistics
WHERE NON_UNIQUE = 1 AND table_schema = 'mydb_name' AND table_name = 'mytable_name'
GROUP BY 1,2;

-- drop all non-unique indexes
SET SESSION group_concat_max_len=10240;

SELECT CONCAT('ALTER TABLE ', `Table`, ' DROP INDEX ', GROUP_CONCAT(`Index` SEPARATOR ', DROP INDEX '),';' )
FROM (
SELECT table_name AS `Table`,
index_name AS `Index`
FROM information_schema.statistics
WHERE NON_UNIQUE = 1 AND table_schema = 'mydb_name' AND table_name = 'mytable_name'
GROUP BY `Table`, `Index`) AS tmp
GROUP BY `Table`;

-- add all non-unique indexes , WITHOUT index length spec
SET SESSION group_concat_max_len=10240;
SELECT CONCAT('ALTER TABLE ', `Table`, ' ADD INDEX ', GROUP_CONCAT(CONCAT(`Index`, '(', `Columns`, ')') SEPARATOR ',\n ADD INDEX ') )
FROM (
SELECT table_name AS `Table`,
index_name AS `Index`,
GROUP_CONCAT(column_name ORDER BY seq_in_index) AS `Columns`
FROM information_schema.statistics
WHERE NON_UNIQUE = 1 AND table_schema = 'mydb_name' AND table_name = 'mytable_name'
GROUP BY `Table`, `Index`) AS tmp
GROUP BY `Table`;

</syntaxhighlight>

MySQL

2024-04-05T10:15:01Z

MilosZ:

Rsync

2023-10-25T13:48:50Z

MilosZ:

=== Copy files and directories and removed source with rsync ===
<pre>
$ rsync --remove-source-files -rltv --progress /backup/fullbackup-20210524 /mnt/backup/2021/05/24/
</pre>

=== Faster delete (then rm -r) of many small files with rsync ===
<pre>
$ mkdir empty_dir
$ rsync -a --delete empty_dir/ mydirfordeletion/
</pre>

Rsync

2023-10-25T13:48:42Z

MilosZ:

=== Copy files and directories and removed source with rsync ===
<pre>
$ rsync --remove-source-files -rltv --progress /backup/fullbackup-20210524 /mnt/backup/2021/05/24/
</pre>

=== Faster delete (then rm -r) of many small files with rsync ===
<pre>
mkdir empty_dir
# rsync -a --delete empty_dir/ mydirfordeletion/
</pre>

Rsync

2023-10-25T13:48:27Z

MilosZ:

=== Copy files and directories and removed source with rsync ===
<pre>
$ rsync --remove-source-files -rltv --progress /backup/fullbackup-20210524 /mnt/backup/2021/05/24/
</pre>

'''Faster delete (then rm -r) of many small files with rsync
'''
<pre>
mkdir empty_dir
# rsync -a --delete empty_dir/ mydirfordeletion/
</pre>

Rsync

2023-10-25T13:48:08Z

MilosZ:

=== Copy files and directories and removed source with rsync ===
<pre>
$ rsync --remove-source-files -rltv --progress /backup/fullbackup-20210524 /mnt/backup/2021/05/24/
</pre>

### Faster delete (then rm -r) of many small files with rsync ###
<pre>
mkdir empty_dir
# rsync -a --delete empty_dir/ mydirfordeletion/
</pre>

DROP ALL databases in MySQL

2023-06-02T10:28:32Z

MilosZ: Created page with "<pre> SET SESSION group_concat_max_len = 1000000; SELECT GROUP_CONCAT( DISTINCT CONCAT('DROP DATABASE ', table_schema, ';') SEPARATOR '' ) FROM information_schema.tables..."

<pre>
SET SESSION group_concat_max_len = 1000000;

SELECT GROUP_CONCAT(
DISTINCT CONCAT('DROP DATABASE ', table_schema, ';')
SEPARATOR ''
)
FROM information_schema.tables
WHERE table_schema NOT IN ('mysql', 'information_schema');
</pre>

MySQL

2023-06-02T10:28:17Z

MilosZ:

Sed

2023-05-05T14:46:42Z

MilosZ:

== Search and replace string in single file ==
<pre>
$ sudo sed -i -e "s/upload_max_filesize = \"500M\"/upload_max_filesize = \"1200M\"/g" /etc/php7.4/cli/php.ini
</pre>

== Search and replace string in multiple files recursively ==
<pre>
$ find /etc/httpd -type f -name '*.conf' -print0 |xargs -0 sed -i -e 's/192.168.1.2/192.168.1.5/g'
</pre>

Rename multiple files with powershell

2023-01-31T09:38:13Z

MilosZ:

Example: 
Rename files named ''image.1.jpg, image.3.jpg''... into 1.jpg, 3.jpg 

<syntaxhighlight lang="PowerShell">
Get-ChildItem image.*.jpg|ForEach-Object {
$NewName = $_.Name -replace "^(image\.)(.*)",'$2'
$Destination = Join-Path -Path $_.Directory.FullName -ChildPath $NewName
Move-Item -Path $_.FullName -Destination $Destination -Force
}
</syntaxhighlight>

Set DNS with powershell

2023-01-31T09:37:46Z

MilosZ:

===Set primary windows dns with powershell script===
<syntaxhighlight lang="PowerShell">
$dnsserver = (,"1.1.1.1")
Get-WmiObject -Class Win32_NetworkAdapterConfiguration -Filter IPEnabled=TRUE | Invoke-WmiMethod -Name SetDNSServerSearchOrder -ArgumentList (,$dnsserver)
</syntaxhighlight>

Setup SSL Certificate for MSSQL

2023-01-31T09:37:27Z

MilosZ:

1. Generate certificate on windows server
<syntaxhighlight lang="PowerShell">
New-SelfSignedCertificate -Type SSLServerAuthentication -Subject "CN=$env:COMPUTERNAME.$env:USERDNSDOMAIN" -DnsName "$env:COMPUTERNAME.$env:USERDNSDOMAIN",'localhost.' -KeyAlgorithm "RSA" -KeyLength 2048 -Hash "SHA256" -TextExtension "2.5.29.37={text}1.3.6.1.5.5.7.3.1" -NotAfter (Get-Date).AddMonths(120) -KeySpec KeyExchange -Provider "Microsoft RSA SChannel Cryptographic Provider"
</syntaxhighlight>
2. Check user that runs MSSQL from Services and add permissions to '''certlm.msc''' ''/ Personal / Certificates / <newcert> / Manage Private Keys'' 
 
3. Go to '''Sql Server Configuration Manager''' and under ''SQL Server Network Configuration / Protocols for MSSQLSERVER'' add Certificate
 
4. Restart MSSQL service

Setup SSL Certificate for MSSQL

2023-01-31T09:37:16Z

MilosZ:

Setup SSL Certificate for MSSQL

2023-01-31T09:36:21Z

MilosZ: Created page with "1. Generate certificate on windows server <pre> New-SelfSignedCertificate -Type SSLServerAuthentication -Subject "CN=$env:COMPUTERNAME.$env:USERDNSDOMAIN" -DnsName "$env:COMPU..."

1. Generate certificate on windows server
<pre>
New-SelfSignedCertificate -Type SSLServerAuthentication -Subject "CN=$env:COMPUTERNAME.$env:USERDNSDOMAIN" -DnsName "$env:COMPUTERNAME.$env:USERDNSDOMAIN",'localhost.' -KeyAlgorithm "RSA" -KeyLength 2048 -Hash "SHA256" -TextExtension "2.5.29.37={text}1.3.6.1.5.5.7.3.1" -NotAfter (Get-Date).AddMonths(120) -KeySpec KeyExchange -Provider "Microsoft RSA SChannel Cryptographic Provider"
</pre>

2. Check user that runs MSSQL from Services and add permissions to '''certlm.msc''' ''/ Personal / Certificates / <newcert> / Manage Private Keys'' 
 
3. Go to '''Sql Server Configuration Manager''' and under ''SQL Server Network Configuration / Protocols for MSSQLSERVER'' add Certificate
 
4. Restart MSSQL service

MSSQL

2023-01-31T07:32:28Z

MilosZ:

==Microsoft SQL Server==

[[Send email using stored procedure in mssql]] 
[[Setup SSL Certificate for MSSQL]] 

Troubleshooting: 
[[MSSQL Database stuck in restore state]]

Troubleshoot TrueNAS (ex FreeNAS)

2023-01-20T18:39:08Z

MilosZ:

=== External connections fails after upgrading to TrueNAS 13 with no hostkey alg ===
Some may have experienced ssh to TrueNAS 13 fails after upgrade with error :
<pre>
$ ssh xxxxx@yyyyy
no hostkey alg
</pre>
Solution is to add these 2 parameters in ''Auxilary Options'' from SSH ''other options'':
<pre>
PubkeyAcceptedAlgorithms +ssh-rsa
HostKeyAlgorithms +ssh-rsa
</pre>

Troubleshoot TrueNAS (ex FreeNAS)

2023-01-20T18:38:59Z

MilosZ: Created page with "=== External connections fails after upgrading to TrueNAS 13 with no hostkey alg === Some may have experienced ssh to TrueNAS 13 fails after upgrade with error : <pre> $ ssh x..."

=== External connections fails after upgrading to TrueNAS 13 with no hostkey alg ===
Some may have experienced ssh to TrueNAS 13 fails after upgrade with error :
<pre>
$ ssh xxxxx@yyyyy
no hostkey alg
</pre>
 
Solution is to add these 2 parameters in ''Auxilary Options'' from SSH ''other options'':
<pre>
PubkeyAcceptedAlgorithms +ssh-rsa
HostKeyAlgorithms +ssh-rsa
</pre>

TrueNAS

2023-01-20T18:36:25Z

MilosZ: Created page with "Troubleshoot TrueNAS (ex FreeNAS) "

[[Troubleshoot TrueNAS (ex FreeNAS) ]]

Main Page

2023-01-20T18:35:54Z

MilosZ:

Welcome to DevOps notebook

== Topics ==
[[Amazon AWS]] 
[[Dev]] 
[[Docker]] 
[[Linux]] 
[[TrueNAS]] 
[[Windows]] 
[[macOS]] 
[[Proxmox VE]] 
[[QEMU KVM]] 
[[VMWare]] 
[[Database]] 
[[Web Server]] 
[[Mail Server]] 
[[Networking]] 
[[Web development]]

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

List windows drives with powershell and show volume id - Method 2

2022-12-26T11:11:36Z

MilosZ:

<syntaxhighlight lang="powershell">
# List the disks

function Get-EC2InstanceMetadata {
param([string]$Path)
(Invoke-WebRequest -Uri "http://169.254.169.254/latest/$Path").Content
}

function Convert-SCSITargetIdToDeviceName {
param([int]$SCSITargetId)
If ($SCSITargetId -eq 0) {
return "sda1"
}
$deviceName = "xvd"
If ($SCSITargetId -gt 25) {
$deviceName += [char](0x60 + [int]($SCSITargetId / 26))
}
$deviceName += [char](0x61 + $SCSITargetId % 26)
return $deviceName
}

Try {
$InstanceId = Get-EC2InstanceMetadata "meta-data/instance-id"
$AZ = Get-EC2InstanceMetadata "meta-data/placement/availability-zone"
$Region = $AZ.Remove($AZ.Length - 1)
$BlockDeviceMappings = (Get-EC2Instance -Region $Region -Instance $InstanceId).Instances.BlockDeviceMappings
$VirtualDeviceMap = @{}
(Get-EC2InstanceMetadata "meta-data/block-device-mapping").Split("`n") | ForEach-Object {
$VirtualDevice = $_
$BlockDeviceName = Get-EC2InstanceMetadata "meta-data/block-device-mapping/$VirtualDevice"
$VirtualDeviceMap[$BlockDeviceName] = $VirtualDevice
$VirtualDeviceMap[$VirtualDevice] = $BlockDeviceName
}
}
Catch {
Write-Host "Could not access the AWS API, therefore, VolumeId is not available.
Verify that you provided your access keys." -ForegroundColor Yellow
}

Get-disk | ForEach-Object {
$DriveLetter = $null
$VolumeName = $null

$DiskDrive = $_
$Disk = $_.Number
$Partitions = $_.NumberOfPartitions
$EbsVolumeID = $_.SerialNumber -replace "_[^ ]*$" -replace "vol", "vol-"
Get-Partition -DiskId $_.Path | ForEach-Object {
if ($_.DriveLetter -ne "") {
$DriveLetter = $_.DriveLetter
$VolumeName = (Get-PSDrive | Where-Object {$_.Name -eq $DriveLetter}).Description
}
}

If ($DiskDrive.path -like "*PROD_PVDISK*") {
$BlockDeviceName = Convert-SCSITargetIdToDeviceName((Get-WmiObject -Class Win32_Diskdrive | Where-Object {$_.DeviceID -eq ("\\.\PHYSICALDRIVE" + $DiskDrive.Number) }).SCSITargetId)
$BlockDeviceName = "/dev/" + $BlockDeviceName
$BlockDevice = $BlockDeviceMappings | Where-Object { $BlockDeviceName -like "*"+$_.DeviceName+"*" }
$EbsVolumeID = $BlockDevice.Ebs.VolumeId
$VirtualDevice = If ($VirtualDeviceMap.ContainsKey($BlockDeviceName)) { $VirtualDeviceMap[$BlockDeviceName] } Else { $null }
}
ElseIf ($DiskDrive.path -like "*PROD_AMAZON_EC2_NVME*") {
$BlockDeviceName = Get-EC2InstanceMetadata "meta-data/block-device-mapping/ephemeral$((Get-WmiObject -Class Win32_Diskdrive | Where-Object {$_.DeviceID -eq ("\\.\PHYSICALDRIVE"+$DiskDrive.Number) }).SCSIPort - 2)"
$BlockDevice = $null
$VirtualDevice = If ($VirtualDeviceMap.ContainsKey($BlockDeviceName)) { $VirtualDeviceMap[$BlockDeviceName] } Else { $null }
}
ElseIf ($DiskDrive.path -like "*PROD_AMAZON*") {
$BlockDevice = ""
$BlockDeviceName = ($BlockDeviceMappings | Where-Object {$_.ebs.VolumeId -eq $EbsVolumeID}).DeviceName
$VirtualDevice = $null
}
Else {
$BlockDeviceName = $null
$BlockDevice = $null
$VirtualDevice = $null
}
New-Object PSObject -Property @{
Disk = $Disk;
Partitions = $Partitions;
DriveLetter = If ($DriveLetter -eq $null) { "N/A" } Else { $DriveLetter };
EbsVolumeId = If ($EbsVolumeID -eq $null) { "N/A" } Else { $EbsVolumeID };
Device = If ($BlockDeviceName -eq $null) { "N/A" } Else { $BlockDeviceName };
VirtualDevice = If ($VirtualDevice -eq $null) { "N/A" } Else { $VirtualDevice };
VolumeName = If ($VolumeName -eq $null) { "N/A" } Else { $VolumeName };
}
} | Sort-Object Disk | Format-Table -AutoSize -Property Disk, Partitions, DriveLetter, EbsVolumeId, Device, VirtualDevice, VolumeName
</syntaxhighlight>

List windows drives with powershell and show volume id - Method 1

2022-12-26T11:11:19Z

MilosZ:

<syntaxhighlight lang="powershell">
# List the Windows disks

function Get-EC2InstanceMetadata
{
param([string]$Path)Set-ExecutionPolicy RemoteSigned
(Invoke-WebRequest -Uri "http://169.254.169.254/latest/$Path").Content
}

function Convert-SCSITargetIdToDeviceName
{
param([int]$SCSITargetId)
If ($SCSITargetId -eq 0) {
return "/dev/sda1"
}
$deviceName = "xvd"
If ($SCSITargetId -gt 25) {
$deviceName += [char](0x60 + [int]($SCSITargetId / 26))
}
$deviceName += [char](0x61 + $SCSITargetId % 26)
return $deviceName
}

Try {
$InstanceId = Get-EC2InstanceMetadata "meta-data/instance-id"
$AZ = Get-EC2InstanceMetadata "meta-data/placement/availability-zone"
$Region = $AZ.Remove($AZ.Length - 1)
$BlockDeviceMappings = (Get-EC2Instance -Region $Region -Instance $InstanceId).Instances.BlockDeviceMappings
$VirtualDeviceMap = @{}
(Get-EC2InstanceMetadata "meta-data/block-device-mapping").Split("`n") | ForEach-Object {
$VirtualDevice = $_
$BlockDeviceName = Get-EC2InstanceMetadata "meta-data/block-device-mapping/$VirtualDevice"
$VirtualDeviceMap[$BlockDeviceName] = $VirtualDevice
$VirtualDeviceMap[$VirtualDevice] = $BlockDeviceName
}
}
Catch {
Write-Host "Could not access the AWS API, therefore, VolumeId is not available.
Verify that you provided your access keys." -ForegroundColor Yellow
}

Get-WmiObject -Class Win32_DiskDrive | ForEach-Object {
$DiskDrive = $_
$Volumes = Get-WmiObject -Query "ASSOCIATORS OF {Win32_DiskDrive.DeviceID='$($DiskDrive.DeviceID)'} WHERE AssocClass=Win32_DiskDriveToDiskPartition" | ForEach-Object {
$DiskPartition = $_
Get-WmiObject -Query "ASSOCIATORS OF {Win32_DiskPartition.DeviceID='$($DiskPartition.DeviceID)'} WHERE AssocClass=Win32_LogicalDiskToPartition"
}
If ($DiskDrive.PNPDeviceID -like "*PROD_PVDISK*") {
$BlockDeviceName = Convert-SCSITargetIdToDeviceName($DiskDrive.SCSITargetId)
$BlockDevice = $BlockDeviceMappings | Where-Object { $_.DeviceName -eq $BlockDeviceName }
$VirtualDevice = If ($VirtualDeviceMap.ContainsKey($BlockDeviceName)) { $VirtualDeviceMap[$BlockDeviceName] } Else { $null }
} ElseIf ($DiskDrive.PNPDeviceID -like "*PROD_AMAZON_EC2_NVME*") {
$BlockDeviceName = Get-EC2InstanceMetadata "meta-data/block-device-mapping/ephemeral$($DiskDrive.SCSIPort - 2)"
$BlockDevice = $null
$VirtualDevice = If ($VirtualDeviceMap.ContainsKey($BlockDeviceName)) { $VirtualDeviceMap[$BlockDeviceName] } Else { $null }
} Else {
$BlockDeviceName = $null
$BlockDevice = $null
$VirtualDevice = $null
}
New-Object PSObject -Property @{
Disk = $DiskDrive.Index;
Partitions = $DiskDrive.Partitions;
DriveLetter = If ($Volumes -eq $null) { "N/A" } Else { $Volumes.DeviceID };
EbsVolumeId = If ($BlockDevice -eq $null) { "N/A" } Else { $BlockDevice.Ebs.VolumeId };
Device = If ($BlockDeviceName -eq $null) { "N/A" } Else { $BlockDeviceName };
VirtualDevice = If ($VirtualDevice -eq $null) { "N/A" } Else { $VirtualDevice };
VolumeName = If ($Volumes -eq $null) { "N/A" } Else { $Volumes.VolumeName };
}
} | Sort-Object Disk | Format-Table -
</syntaxhighlight>

Amazon EC2

2022-12-26T10:42:33Z

MilosZ:

=== Initialize disks in Amazon EC2 in Windows ===
<pre>
PS C:\> C:\ProgramData\Amazon\EC2-Windows\Launch\Scripts\InitializeDisks.ps1
</pre>

=== Check if instance returns meta-data info and fix routes on windows server ===
<pre>
ps> Invoke-RestMethod -uri http://169.254.169.254/latest/meta-data/
ps> Import-Module c:\ProgramData\Amazon\EC2-Windows\Launch\Module\Ec2Launch.psm1 ; Add-Routes
</pre>

=== Unable to resolve package source 'https://www.powershellgallery.com/api/v2' ===
<pre>
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
</pre>

=== List windows drives with powershell and show volume id ===
[[List windows drives with powershell and show volume id - Method 1]] 
[[List windows drives with powershell and show volume id - Method 2]]

List windows drives with powershell and show volume id - Method 2

2022-12-26T10:42:16Z

MilosZ: Created page with "<pre> # List the disks function Get-EC2InstanceMetadata { param([string]$Path) (Invoke-WebRequest -Uri "http://169.254.169.254/latest/$Path").Content } function Conver..."

<pre>
# List the disks

function Get-EC2InstanceMetadata {
param([string]$Path)
(Invoke-WebRequest -Uri "http://169.254.169.254/latest/$Path").Content
}

function Convert-SCSITargetIdToDeviceName {
param([int]$SCSITargetId)
If ($SCSITargetId -eq 0) {
return "sda1"
}
$deviceName = "xvd"
If ($SCSITargetId -gt 25) {
$deviceName += [char](0x60 + [int]($SCSITargetId / 26))
}
$deviceName += [char](0x61 + $SCSITargetId % 26)
return $deviceName
}

Try {
$InstanceId = Get-EC2InstanceMetadata "meta-data/instance-id"
$AZ = Get-EC2InstanceMetadata "meta-data/placement/availability-zone"
$Region = $AZ.Remove($AZ.Length - 1)
$BlockDeviceMappings = (Get-EC2Instance -Region $Region -Instance $InstanceId).Instances.BlockDeviceMappings
$VirtualDeviceMap = @{}
(Get-EC2InstanceMetadata "meta-data/block-device-mapping").Split("`n") | ForEach-Object {
$VirtualDevice = $_
$BlockDeviceName = Get-EC2InstanceMetadata "meta-data/block-device-mapping/$VirtualDevice"
$VirtualDeviceMap[$BlockDeviceName] = $VirtualDevice
$VirtualDeviceMap[$VirtualDevice] = $BlockDeviceName
}
}
Catch {
Write-Host "Could not access the AWS API, therefore, VolumeId is not available.
Verify that you provided your access keys." -ForegroundColor Yellow
}

Get-disk | ForEach-Object {
$DriveLetter = $null
$VolumeName = $null

$DiskDrive = $_
$Disk = $_.Number
$Partitions = $_.NumberOfPartitions
$EbsVolumeID = $_.SerialNumber -replace "_[^ ]*$" -replace "vol", "vol-"
Get-Partition -DiskId $_.Path | ForEach-Object {
if ($_.DriveLetter -ne "") {
$DriveLetter = $_.DriveLetter
$VolumeName = (Get-PSDrive | Where-Object {$_.Name -eq $DriveLetter}).Description
}
}

If ($DiskDrive.path -like "*PROD_PVDISK*") {
$BlockDeviceName = Convert-SCSITargetIdToDeviceName((Get-WmiObject -Class Win32_Diskdrive | Where-Object {$_.DeviceID -eq ("\\.\PHYSICALDRIVE" + $DiskDrive.Number) }).SCSITargetId)
$BlockDeviceName = "/dev/" + $BlockDeviceName
$BlockDevice = $BlockDeviceMappings | Where-Object { $BlockDeviceName -like "*"+$_.DeviceName+"*" }
$EbsVolumeID = $BlockDevice.Ebs.VolumeId
$VirtualDevice = If ($VirtualDeviceMap.ContainsKey($BlockDeviceName)) { $VirtualDeviceMap[$BlockDeviceName] } Else { $null }
}
ElseIf ($DiskDrive.path -like "*PROD_AMAZON_EC2_NVME*") {
$BlockDeviceName = Get-EC2InstanceMetadata "meta-data/block-device-mapping/ephemeral$((Get-WmiObject -Class Win32_Diskdrive | Where-Object {$_.DeviceID -eq ("\\.\PHYSICALDRIVE"+$DiskDrive.Number) }).SCSIPort - 2)"
$BlockDevice = $null
$VirtualDevice = If ($VirtualDeviceMap.ContainsKey($BlockDeviceName)) { $VirtualDeviceMap[$BlockDeviceName] } Else { $null }
}
ElseIf ($DiskDrive.path -like "*PROD_AMAZON*") {
$BlockDevice = ""
$BlockDeviceName = ($BlockDeviceMappings | Where-Object {$_.ebs.VolumeId -eq $EbsVolumeID}).DeviceName
$VirtualDevice = $null
}
Else {
$BlockDeviceName = $null
$BlockDevice = $null
$VirtualDevice = $null
}
New-Object PSObject -Property @{
Disk = $Disk;
Partitions = $Partitions;
DriveLetter = If ($DriveLetter -eq $null) { "N/A" } Else { $DriveLetter };
EbsVolumeId = If ($EbsVolumeID -eq $null) { "N/A" } Else { $EbsVolumeID };
Device = If ($BlockDeviceName -eq $null) { "N/A" } Else { $BlockDeviceName };
VirtualDevice = If ($VirtualDevice -eq $null) { "N/A" } Else { $VirtualDevice };
VolumeName = If ($VolumeName -eq $null) { "N/A" } Else { $VolumeName };
}
} | Sort-Object Disk | Format-Table -AutoSize -Property Disk, Partitions, DriveLetter, EbsVolumeId, Device, VirtualDevice, VolumeName
</pre>

Amazon EC2

2022-12-26T10:41:43Z

MilosZ:

=== Initialize disks in Amazon EC2 in Windows ===
<pre>
PS C:\> C:\ProgramData\Amazon\EC2-Windows\Launch\Scripts\InitializeDisks.ps1
</pre>

=== Check if instance returns meta-data info and fix routes on windows server ===
<pre>
ps> Invoke-RestMethod -uri http://169.254.169.254/latest/meta-data/
ps> Import-Module c:\ProgramData\Amazon\EC2-Windows\Launch\Module\Ec2Launch.psm1 ; Add-Routes
</pre>

=== Unable to resolve package source 'https://www.powershellgallery.com/api/v2' ===
<pre>
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
</pre>

=== List windows drives with powershell and show volume id ===
[[List windows drives with powershell and show volume id - Method 1]]
[[List windows drives with powershell and show volume id - Method 2]]

List windows drives with powershell and show volume id - Method 1

2022-12-26T10:41:14Z

MilosZ: Created page with "<pre> # List the Windows disks function Get-EC2InstanceMetadata { param([string]$Path)Set-ExecutionPolicy RemoteSigned (Invoke-WebRequest -Uri "http://169.254.169.254/late..."

<pre>
# List the Windows disks

function Get-EC2InstanceMetadata
{
param([string]$Path)Set-ExecutionPolicy RemoteSigned
(Invoke-WebRequest -Uri "http://169.254.169.254/latest/$Path").Content
}

function Convert-SCSITargetIdToDeviceName
{
param([int]$SCSITargetId)
If ($SCSITargetId -eq 0) {
return "/dev/sda1"
}
$deviceName = "xvd"
If ($SCSITargetId -gt 25) {
$deviceName += [char](0x60 + [int]($SCSITargetId / 26))
}
$deviceName += [char](0x61 + $SCSITargetId % 26)
return $deviceName
}

Try {
$InstanceId = Get-EC2InstanceMetadata "meta-data/instance-id"
$AZ = Get-EC2InstanceMetadata "meta-data/placement/availability-zone"
$Region = $AZ.Remove($AZ.Length - 1)
$BlockDeviceMappings = (Get-EC2Instance -Region $Region -Instance $InstanceId).Instances.BlockDeviceMappings
$VirtualDeviceMap = @{}
(Get-EC2InstanceMetadata "meta-data/block-device-mapping").Split("`n") | ForEach-Object {
$VirtualDevice = $_
$BlockDeviceName = Get-EC2InstanceMetadata "meta-data/block-device-mapping/$VirtualDevice"
$VirtualDeviceMap[$BlockDeviceName] = $VirtualDevice
$VirtualDeviceMap[$VirtualDevice] = $BlockDeviceName
}
}
Catch {
Write-Host "Could not access the AWS API, therefore, VolumeId is not available.
Verify that you provided your access keys." -ForegroundColor Yellow
}

Get-WmiObject -Class Win32_DiskDrive | ForEach-Object {
$DiskDrive = $_
$Volumes = Get-WmiObject -Query "ASSOCIATORS OF {Win32_DiskDrive.DeviceID='$($DiskDrive.DeviceID)'} WHERE AssocClass=Win32_DiskDriveToDiskPartition" | ForEach-Object {
$DiskPartition = $_
Get-WmiObject -Query "ASSOCIATORS OF {Win32_DiskPartition.DeviceID='$($DiskPartition.DeviceID)'} WHERE AssocClass=Win32_LogicalDiskToPartition"
}
If ($DiskDrive.PNPDeviceID -like "*PROD_PVDISK*") {
$BlockDeviceName = Convert-SCSITargetIdToDeviceName($DiskDrive.SCSITargetId)
$BlockDevice = $BlockDeviceMappings | Where-Object { $_.DeviceName -eq $BlockDeviceName }
$VirtualDevice = If ($VirtualDeviceMap.ContainsKey($BlockDeviceName)) { $VirtualDeviceMap[$BlockDeviceName] } Else { $null }
} ElseIf ($DiskDrive.PNPDeviceID -like "*PROD_AMAZON_EC2_NVME*") {
$BlockDeviceName = Get-EC2InstanceMetadata "meta-data/block-device-mapping/ephemeral$($DiskDrive.SCSIPort - 2)"
$BlockDevice = $null
$VirtualDevice = If ($VirtualDeviceMap.ContainsKey($BlockDeviceName)) { $VirtualDeviceMap[$BlockDeviceName] } Else { $null }
} Else {
$BlockDeviceName = $null
$BlockDevice = $null
$VirtualDevice = $null
}
New-Object PSObject -Property @{
Disk = $DiskDrive.Index;
Partitions = $DiskDrive.Partitions;
DriveLetter = If ($Volumes -eq $null) { "N/A" } Else { $Volumes.DeviceID };
EbsVolumeId = If ($BlockDevice -eq $null) { "N/A" } Else { $BlockDevice.Ebs.VolumeId };
Device = If ($BlockDeviceName -eq $null) { "N/A" } Else { $BlockDeviceName };
VirtualDevice = If ($VirtualDevice -eq $null) { "N/A" } Else { $VirtualDevice };
VolumeName = If ($Volumes -eq $null) { "N/A" } Else { $Volumes.VolumeName };
}
} | Sort-Object Disk | Format-Table -
</pre>

Amazon EC2

2022-12-26T10:40:58Z

MilosZ:

Regex

2022-11-20T10:51:09Z

MilosZ: Created page with "=== IP Address regex === <pre> (\d{1,3}\.){3}\d{1,3} </pre>"

=== IP Address regex ===
<pre>
(\d{1,3}\.){3}\d{1,3}
</pre>

Dev

2022-11-20T10:50:41Z

MilosZ:

[[Python]] 
[[Git]] 
[[Regex]]

Linux cli snippets

2022-09-14T11:49:38Z

MilosZ:

== Linux command line snippets ==

=== Get website SSL certificate details using CLI ===
<pre>
$ echo | openssl s_client -showcerts -servername sendfileto.net -connect sendfileto.net:443 2>/dev/null | openssl x509 -inform pem -noout -text
</pre>

=== Temporary stop bash history ===
Turn off:
<pre>
$ set +o history
</pre>
Turn on:
<pre>
$ set -o history
</pre>
Alternative is to add '''HISTCONTROL="ignorespace"''' into ''.bashrc'' file and all things
written with space in front wont be recorded in history

=== Check ssl expiry date on file from cli ===
<pre>
# openssl x509 -noout -dates -in /path/to/cert.crt
</pre>

=== Check ssl expiry date from linux cli ===
<pre>
# echo | openssl s_client -showcerts -servername devopsnotebook.com -connect devopsnotebook.com:443 2>/dev/null | openssl x509 -inform pem -noout -text |grep 'Not After'
</pre>

=== Start all vm's with autostart set with virsh ===
<pre>
# for i in $(virsh list --name --autostart); do virsh start $i; done
</pre>

=== Sort files by size with ls ===
<pre>
# ls -l -S | sort -k 5 -n
</pre>

=== Change different permissions to files and folders in one run recursively ===
<pre>
# find /path/to/dir -type f -exec chmod 664 {} + -o -type d -exec chmod 775 {} +
</pre>

=== Search and replace string in all files recursively in given folder ===
<pre>
# find ./ -type f -exec sed -i -e 's/tomato/potato/g' {} \;
</pre>

=== Destroy all partitions table and data on drive ===
<pre>
# sgdisk --zap-all /dev/nvme0n1
</pre>

=== Push dns changes to secondary ===
<pre>
# rndc retransfer domain.com
</pre>

=== Delete 5 lines after a pattern with sed (including the line with the pattern) ===
<pre>
# sed -e '/pattern/,+5d' file.txt
</pre>
=== Delete 5 lines after a pattern with sed (excluding the line with the pattern) ===
<pre>
# sed -e '/pattern/{n;N;N;N;N;d}' file.txt
</pre>

=== User iperf to test real bandwidth speed ===
<pre>
# iperf -s # run on first machine
# iperf -c <IP of server> # run on second with ip of first one
</pre>

=== Get only first exact result from grep ===
<pre>
# grep -o -a -m 1 -h -r "string" <filename.txt>
</pre>