All public logs

Combined display of all available logs of DevOps Notebook. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)

• 14:37, 15 September 2024 MilosZ talk contribs created page 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 MilosZ talk contribs created page Windows troubleshooting (Created page with "Windows update are stuck on downloading or install<br>")
• 10:55, 25 July 2024 MilosZ talk contribs created page 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:18, 5 April 2024 MilosZ talk contribs created page 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...")
• 11:15, 5 April 2024 MilosZ talk contribs created page 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:28, 2 June 2023 MilosZ talk contribs created page 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...")
• 10:36, 31 January 2023 MilosZ talk contribs created page 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...")
• 19:38, 20 January 2023 MilosZ talk contribs created page 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 MilosZ talk contribs created page TrueNAS (Created page with "Troubleshoot TrueNAS (ex FreeNAS) <br>")
• 11:42, 26 December 2022 MilosZ talk contribs created page 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 MilosZ talk contribs created page 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:51, 20 November 2022 MilosZ talk contribs created page Regex (Created page with "=== IP Address regex === <pre> (\d{1,3}\.){3}\d{1,3} </pre>")
• 17:11, 5 September 2022 MilosZ talk contribs created page 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>")
• 17:11, 5 September 2022 MilosZ talk contribs created page 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>")
• 09:28, 30 August 2022 MilosZ talk contribs created page 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 ;;...")
• 10:06, 2 August 2022 MilosZ talk contribs created page 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...")
• 13:19, 5 February 2022 MilosZ talk contribs created page Set date and time manually in linux shell (Created page with "<pre> # date -s "28 JUN 1984 09:30:00" # date +%Y%m%d -s "19830628" # date +%T -s "09:30:00" # timedatectl set-ntp no # timedatectl set-time '1983-06-28' # timedatectl set-tim...")
• 18:16, 27 January 2022 MilosZ talk contribs created page Check ttfb (time to first byte) with bash script (Created page with "<syntaxhighlight lang="bash"> #!/bin/bash # file: ttfb.sh # curl command to check the time to first byte # ** usage ** # 1. ./ttfb.sh "https://google.com" # 2. seq 10 | xargs...")
• 17:50, 27 January 2022 MilosZ talk contribs created page Get cpu count with bash script (Created page with "<syntaxhighlight lang="bash"> #!/bin/bash CPUCOUNT=`cat /proc/cpuinfo |grep processor |wc -l` echo "CPU COUNT IS: " $CPUCOUNT if [ $CPUCOUNT -lt "5" ] then MAXSES...")
• 17:48, 27 January 2022 MilosZ talk contribs created page Linux bash (Created page with "Get cpu count with bash script<br>")
• 12:26, 26 January 2022 MilosZ talk contribs created page Port forward mysql on local network with SSH (Created page with "Run from server you wanna access to MySQL that is on private network<br> that is not in same network as we are. <pre> $ ssh -v -4 -N -L 3307:<sql_server_private_ip>:3306 root@...")
• 10:55, 19 January 2022 MilosZ talk contribs created page Usefull docker commands (Created page with "=== Clean up overlay folder === <pre> # docker system prune -a -f </pre> or <pre> # docker rm -v $(sudo docker ps -a -q -f status=exited) # docker rmi -f $(sudo docker images...")
• 10:54, 19 January 2022 MilosZ talk contribs created page Docker (Created page with "Usefull docker commands<br>")
• 23:54, 16 December 2021 MilosZ talk contribs created page "Cannot execute /bin/bash: Permission denied" - solved! (Created page with "This happens when selinux is not disabled or configured. <br><br> Easiest way to fix it is login via console and in ``/etc/selinux/config`` set '''selinux=disabled'''")
• 09:59, 14 December 2021 MilosZ talk contribs created page Basic iptables firewall template (Created page with "<pre> # Flush INPUT/OUTPUT/FORWARD chains iptables -F INPUT iptables -F OUTPUT iptables -F FORWARD # Drop invalid packets iptables -A INPUT -m conntrack --ctstate INVALID -j...")
• 12:59, 11 December 2021 MilosZ talk contribs created page SSH login without key auth (force password authentication) (Created page with "<pre> ssh -o PasswordAuthentication=yes -o PreferredAuthentications=keyboard-interactive,password -o PubkeyAuthentication=no host.devopsnotebook.com </pre>")
• 22:00, 2 December 2021 MilosZ talk contribs created page Update windows active directory password complexity (Created page with "# Open the group policy management console (Type gpmc.msc in Search or Run) # Expand Domains, your domain, then group policy objects # Right click the default domain policy...")
• 21:58, 2 December 2021 MilosZ talk contribs created page Windows Group Policy Management (Created page with "Update windows active directory password complexity")
• 10:09, 29 October 2021 MilosZ talk contribs created page Test MariaDB MaxScale readwrite (Created page with "Check if you are getting always Slave servers id in maxscale '''SELECT''': <syntaxhighlight lang="MySQL"> > SELECT @@server_id AS "Server ID"; </syntaxhighlight> 1. Create te...")
• 10:02, 29 October 2021 MilosZ talk contribs created page MaxScale (Created page with "== Tests == Test MariaDB MaxScale readwrite<br>")
• 09:58, 25 August 2021 MilosZ talk contribs created page Setup ftp server on linux with VSFTPD (Created page with "Depending on distro, install it first: CentOS: <pre> # yum install vsftpd # OR # dnf install vsftpd </pre> Debian: <pre> # apt install vsftpd </pre> Edit /etc/vsftpd/vsftpd.c...")
• 10:11, 16 July 2021 MilosZ talk contribs created page Nf conntrack: table full, dropping packet (Created page with "<pre> # sysctl -w net.netfilter.nf_conntrack_max=1000000 </pre>")
• 10:52, 15 July 2021 MilosZ talk contribs created page Mount LVM on new system (Created page with "<pre> # vgscan # vgchange -ay nameof_lvm_found # lvs # mount /dev/lvm-path/root /mnt/root </pre>")
• 14:59, 13 July 2021 MilosZ talk contribs created page Redirect entire website to new url, except few directories (Created page with "<pre> RewriteEngine on RewriteCond %{HTTP_HOST} ^myoldwebsite.com$ RewriteCond %{REQUEST_URI}!^/something/ RewriteCond %{REQUEST_URI}!^/some-folder/ RewriteRule (.*) https://w...")
• 11:27, 13 July 2021 MilosZ talk contribs created page Incrase upload size in apache (Created page with "<pre> <Directory "/var/www/example.com/wp-uploads"> LimitRequestBody 5242880 </Directory> </pre>")
• 14:29, 12 July 2021 MilosZ talk contribs created page Mount a qcow2 disk image (Created page with "<pre> # modprobe nbd max_part=8 # qemu-nbd --connect=/dev/nbd0 /var/lib/vz/images/100/vm-100-disk-1.qcow2 # fdisk /dev/nbd0 -l # mount /dev/nbd0p1 /mnt/somepoint/ # umount /...")
• 13:50, 12 July 2021 MilosZ talk contribs created page SSHFS (Created page with "== Add sshfs to fstab == Simple: <pre> sshfs#[email protected]:/pathremote /mnt/pathlocal </pre> Advanced: <pre> sshfs#[email protected]:/pathremote /mnt/pathlocal fuse def...")
• 11:38, 6 July 2021 MilosZ talk contribs created page Convert VMWare vmdk to qcow2 (Created page with "<pre> # qemu-img convert -f vmdk disk-0.vmdk -O qcow2 disk-0.qcow2 </pre>")
• 11:37, 6 July 2021 MilosZ talk contribs created page QEMU KVM (Created page with "Convert VMWare vmdk to qcow2<br>")
• 11:14, 6 July 2021 MilosZ talk contribs created page MSSQL Database stuck in restore state (Created page with "<syntaxhighlight lang="sql"> USE [master] RESTORE DATABASE [SportifierDB_Restore] FROM DISK = N'D:\BackupFromPRD\AutoRestore\AutoRestoreSpotifierDBFresh.bak' WITH RECOVERY...")
• 09:34, 17 June 2021 MilosZ talk contribs created page Load ssh agent on linux boot (Created page with "Add to .bash_profile <br> <pre> SSH_ENV="$HOME/.ssh/agent-environment" function start_agent { echo "Initialising new SSH agent..." /usr/bin/ssh-agent | sed 's/^echo/#...")
• 11:42, 28 May 2021 MilosZ talk contribs created page Linux proxmox commands (Created page with "=== Restart Proxmox services in correct order === <pre> # service pve-cluster restart && service pvedaemon restart && service pvestatd restart && service pveproxy restart </pre>")
• 11:41, 28 May 2021 MilosZ talk contribs created page Proxmox VE (Created page with "Linux proxmox commands")
• 11:23, 25 May 2021 MilosZ talk contribs created page Rsync (Created page with "=== 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>")
• 11:05, 5 May 2021 MilosZ talk contribs created page Sed (Created page with "== 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>")
• 12:08, 16 February 2021 MilosZ talk contribs created page Error : warning: TLS library problem: 2023 (Created page with "PHP fails to verify peer certificate because unknown CA.<br> This can be fixed by adding correct certificate or <br> by removing verify in config.inc.php of roundcoube <br> <...")
• 12:05, 16 February 2021 MilosZ talk contribs created page Mail Server (Created page with "==Postix, Dovecot and Roundcube setup== === Troubleshooting Roundcube === [Error : warning: TLS library problem: 2023]")
• 11:20, 25 January 2021 MilosZ talk contribs created page Load ssh-agent upon login so key doesn't ask for passphrase everytime (Created page with "Add to ~/.bashrc or /etc/profile for all users <pre> eval $(ssh-agent) </pre> Then just: <pre> $ ssh-add .ssh/id_rsa </pre>")
• 11:02, 16 December 2020 MilosZ talk contribs created page VMWare (Created page with "== ESXi configuration ==")
• 10:50, 14 December 2020 MilosZ talk contribs created page Grep (Created page with "=== Search for multiple IP addresses with one grep line === <pre> # grep -iP '2\.2.\2\.2|1\.1\.1\.1' * </pre>")

(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)