User contributions
From DevOps Notebook
- 14:40, 15 September 2024 diff hist +265 Windows update are stuck on downloading or install current
- 14:37, 15 September 2024 diff hist +1,417 N Windows update are stuck on downloading or install 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..."
- 14:36, 15 September 2024 diff hist +58 N Windows troubleshooting Created page with "Windows update are stuck on downloading or install<br>" current
- 14:36, 15 September 2024 diff hist +32 Windows current
- 10:56, 25 July 2024 diff hist -2 Netstat current
- 10:55, 25 July 2024 diff hist +161 N Netstat 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>"
- 11:23, 5 April 2024 diff hist +940 Mysqldump all tables from database in separate files current
- 11:18, 5 April 2024 diff hist +347 N DROP ALL tables in MySQL database 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..." current
- 11:18, 5 April 2024 diff hist +42 MySQL current
- 11:16, 5 April 2024 diff hist +30 List and DROP all table indexes in MySQL current
- 11:15, 5 April 2024 diff hist +1,272 N List and DROP all table indexes in MySQL 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..."
- 11:15, 5 April 2024 diff hist +49 MySQL
- 14:48, 25 October 2023 diff hist +2 Rsync current
- 14:48, 25 October 2023 diff hist 0 Rsync
- 14:48, 25 October 2023 diff hist 0 Rsync
- 14:48, 25 October 2023 diff hist +148 Rsync
- 11:28, 2 June 2023 diff hist +240 N DROP ALL databases in MySQL 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..." current
- 11:28, 2 June 2023 diff hist +32 MySQL
- 15:46, 5 May 2023 diff hist +2 Sed current
- 10:38, 31 January 2023 diff hist +42 Rename multiple files with powershell current
- 10:37, 31 January 2023 diff hist +42 Set DNS with powershell current
- 10:37, 31 January 2023 diff hist +5 Setup SSL Certificate for MSSQL current
- 10:37, 31 January 2023 diff hist +41 Setup SSL Certificate for MSSQL
- 10:36, 31 January 2023 diff hist +767 N Setup SSL Certificate for MSSQL Created page with "1. Generate certificate on windows server <pre> New-SelfSignedCertificate -Type SSLServerAuthentication -Subject "CN=$env:COMPUTERNAME.$env:USERDNSDOMAIN" -DnsName "$env:COMPU..."
- 08:32, 31 January 2023 diff hist +40 MSSQL current
- 19:39, 20 January 2023 diff hist -5 Troubleshoot TrueNAS (ex FreeNAS) current
- 19:38, 20 January 2023 diff hist +376 N Troubleshoot TrueNAS (ex FreeNAS) 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..."
- 19:36, 20 January 2023 diff hist +42 N TrueNAS Created page with "Troubleshoot TrueNAS (ex FreeNAS) <br>" current
- 19:35, 20 January 2023 diff hist +16 Main Page current
- 12:11, 26 December 2022 diff hist +42 List windows drives with powershell and show volume id - Method 2 current
- 12:11, 26 December 2022 diff hist +41 List windows drives with powershell and show volume id - Method 1 current
- 11:42, 26 December 2022 diff hist +5 Amazon EC2 current
- 11:42, 26 December 2022 diff hist +3,691 N List windows drives with powershell and show volume id - Method 2 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..."
- 11:41, 26 December 2022 diff hist +70 Amazon EC2
- 11:41, 26 December 2022 diff hist +3,048 N List windows drives with powershell and show volume id - Method 1 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..."
- 11:40, 26 December 2022 diff hist +134 Amazon EC2
- 11:51, 20 November 2022 diff hist +59 N Regex Created page with "=== IP Address regex === <pre> (\d{1,3}\.){3}\d{1,3} </pre>" current
- 11:50, 20 November 2022 diff hist +14 Dev current
- 12:49, 14 September 2022 diff hist +116 Linux cli snippets current
- 08:41, 7 September 2022 diff hist +134 PowerShell current
- 09:13, 6 September 2022 diff hist +221 MSSQL Database stuck in restore state current
- 17:11, 5 September 2022 diff hist +172 N Redirect www to non-www in nginx Created page with "<syntaxhighlight lang="nginx"> server { listen 80; server_name www.devopsnotebook.com; return 301 $scheme://devopsnotebook.com$request_uri; } </syntaxhighlight>" current
- 17:11, 5 September 2022 diff hist +172 N Redirect non-www to www in nginx Created page with "<syntaxhighlight lang="nginx"> server { listen 80; server_name devopsnotebook.com; return 301 $scheme://www.devopsnotebook.com$request_uri; } </syntaxhighlight>" current
- 17:10, 5 September 2022 diff hist +82 NGINX current
- 09:28, 30 August 2022 diff hist +49 Select server with bash case based on IP subnet current
- 09:28, 30 August 2022 diff hist +243 N Select server with bash case based on IP subnet Created page with "#!/bin/bash server_ip=hostname -I | cut -d' ' -f1 case "$server_ip" in 10.5.15.*) backup_ip=10.5.15.242 ;; 10.8.15.*) backup_ip=10.8.15.242 ;;..."
- 09:28, 30 August 2022 diff hist +56 Linux bash current
- 16:03, 29 August 2022 diff hist +182 Usefull docker commands current
- 10:07, 2 August 2022 diff hist +72 Update mysql user password current
- 10:06, 2 August 2022 diff hist +313 N Update mysql user password Created page with "<pre> mysql> ALTER USER 'user-name'@'some_host_ip' IDENTIFIED BY 'NEW_USER_PASSWORD'; mysql> FLUSH PRIVILEGES; </pre> For earlier versions of mysql (mysql 5.7.6 or MariaDB 10..."
