- Created by Anonymous, last modified by user-43d90 on Apr 14, 2020
Just another Linux/Server blog.. with some other stuff thrown in - 100% NOT FOR PROFIT
Android
- Android Downloads
- Flashing Files on Android
- General Android
- LG V40 - Custom Rom - Root - Unlock Bootloader - LG405UA - Sprint/ATT
- Pixel XL Marlin
- Root - Android
API - Application programming interface
- Express API - Javascript - NodeJS
- KrakenD - API Gateway
- NGinX - API Proxy - CORs
- POST to API via CURL JSON File
- Test API CORs via HTML
Atlassian Software
- Backup Atlassian Software with Script - DB Dump - TGZ
- Bamboo
- Confluence
- confluence[####]: Existing PID file found during start.
- Confluence HTTPS SSL Reverse Proxy via NginX
- Copy {noformat} code from Jira to Confluence - Wiki Markup
- Enable Custom Backup Locations
- Error Importing Confluence Site - duplicate key value violates unique constraint "unq_lwr_username"
- Normalize Confluence Download URLS for WGET
- Redirect ALL HTTP 404 Error Pages in Confluence to Custom URL
- Default Confluence Folder Locations
- Install Atlassian Software - Confluence - Jira - Linux Script
- Install Confluence - Docker-Compose
- Jira Software
Caddy - WebServer
CentOS - RHEL - SL - SHMZ
- CentOS 5
- CentOS 6
- CentOS 7
- CentOS 7 General
- Add User to Sudoers in CentOS 7
- Change CentOS 7 eno back to eth0
- Create Virtual - Alias - NICs - CentOS
- Enable-Install IFConfig CentOS 7
- Install Apache2 - CentOS 7
- Install IPTables CentOS 7
- Install LAMP CentOS 7
- Install MySQL - CentOS 7
- Install UFW CentOS 7
- NTP Not Enabled according to TimeDateCTL - CentOS 7
- Set default text editor to Nano - Edit Crontab with Nano - CentOS 7
- sudo: sorry, you must have a tty to run sudo - CentOS 7
- High-Availability (HA) - CentOS 7
- 3rd Party Guides for HA CentOS 7
- Add Asterisk LSB Resource to HA - Pacemaker Cluster - CentOS 7
- Add FOP2 LSB Resource to HA - Pacemaker Cluster - CentOS 7
- Add Init.d LSB Script to PaceMaker - Corosync Cluster - PCS
- Asterisk DRBD - HA with Pacemaker - Setup
- Commands And Alias's
- Destroy Cluster - Start Fresh
- Enable PaceMaker - Corosync Cluster on Boot
- If Service isn't running - Stop Cluster - Script
- PCS Cluster Auth Fails - Error: Username and/or password is incorrect
- PCS - Tips n Tricks - Constraints - Delete Resources
- Setup HA Cluster Pacemaker - Corosync - DRBD - MySQL (MariaDB) - Apache (HTTPD) - Data Partition
- Cluster Master Layout
- Configure ClusterMon - Cluster Status HTML Page - SMTP Notifications
- Configure ClusterMon - Event Notifications
- Configure Group Start - Stop Order and Colocations
- Create SQL-Group Pacemaker Resource - DRBD Clone - SQL Service
- Create Virtual_IP or Floating_IP resource
- Explore RHEL Management Web-Interface
- Initalize DRBD - Migrate SQL Databases - MariaDB - CentOS 7
- Initalize DRBD - Migrate Web-Data - Apache (HTTPD) - CentOS 7
- Initialize Partitons for DRBD - CentOS 7
- Initiate Apache Resource Group
- Initiate HA Cluster - CentOS 7
- Install DRBD 8.4 - CentOS 7
- Using CIB to backup-import and examine the Cluster as an XML/CIB File
- View Available PCS Resources
- VoIP (Voice over IP)
- CentOS 7 General
- CentOS General
- Cockpit - Server Management WebUI
- Fedora Server
- FreePBX Distro 7 (Based of RHEL 7 - SL 7)
- Yum Package Manager
Code Version Control
- Git
Conda - PIP
- Backup and Restore - Migrate - Conda ENVs
- Install and Update PIP and Conda
- Install PIP Tar
- PYTorch - Cuda - Torch - MMDET - MMCV
Custom Grub Entries
- CloneZilla Grub Entry
- Create Grub2 config w Partition /dev/ vs UUID - CentOS
- Parted Magic Custom Grub Entry - 2013 - 2015 - 2016 - Ubuntu - CentOS
- Reinstall Grub 2 - CentOS
- Ubuntu Custom Grub
Customize LiveISO's
- Basics of Creating a LiveISO
- Customize CloneZilla LiveISO
- Customize Parted Magic LiveISO
- Customizing Ubuntu LiveISO
DBA - Structured Query Language (SQL)
- General SQL
- .my.cnf variables
- Allow Remote Access MySQL - MariaDB
- Check for locked tables - Show Process list - MySQL
- Create SuperUser MySQL
- Dump All Databases - MySQL
- Duplicate entry '0' for key 'PRIMARY' - MySQL
- Fake MySQL Test Data
- Find if Table has Primary Key
- Find Last Update Time for MySQL Table
- Find Size of All Databases in MySQL in MB
- Insert CSV into MySQL Table
- Migrate Users and Permissions - MySQL - MariaDB
- Monitor MySQL Import after it starts
- MySQL Check if Field is NOT NULL or EMPTY
- Select Field by length MySQL
- Select from where daterange relative to now() in MySQL
- Set and Select 'max_allowed_packets' via CLI
- Set mysql root PWD to Blank
- User Permissions MySQL Queries
- MariaDB
- MySQL
- PostgreSQL
- SQL - GUIs
DD-WRT
- General DD-WRT
- Backup or Restore DD-WRT NVRAM.Bin over SSH
- Change Country Code in DD-WRT Router - Unlock ALL Channels
- Create Samba/SMB Share - DD-WRT V3
- Custom DDNS - DD-WRT - CRON - WGET
- Edit DNSMasq.conf from DD-WRT Command Line - CLI
- Enable SSH to DD-WRT with RSA Key
- Find Kernel and GCC version - DD-WRT
- Increase Wireless Signal Strength in DD-WRT Router
- Resolve Internal Domain Name on DD-WRT Router
- Restart DNSMasq DD-WRT Command Line
- Set Static IP in DD-WRT Router
- Set up OpenVPN on DD-WRT using Ubuntu Server OpenVPN keys
- Unmasq DD-WRT Sys-Info MAC Address
- View All Network Interfaces DD-WRT CLI
- Wireless Repeater Bridge - DD-WRT
- Linksys EA-6500
Docker
- Access Docker Container As Root
- Autostart Docker Container - SystemD Service Unit Example
- Docker Bind Container and Host Dir
- Docker Container IP to Variable
- Docker - Copy Files to and From Host
- Docker - Dont Auto Start Service - Profiles
- Docker Execute Script in Container
- DockerFile - Custom Containers
- Docker General Commands
- Docker - Installation
- Docker Logging
- Docker Port Mapping
- Docker Random Scripts
- Docker Volume Mapping
- Generate Docker-Compose from Running Container
- Install Portainer - A Docker WebUI - via Docker
- Setup Self-Hosted Docker Registry using Docker-Compose - SSL
E-Mail - Linux
- Configure G-Mail to send E-Mail from Linux
- MSMTP - Ubuntu - CentOS
- PostFix - Ubuntu - CentOS
- Send E-Mail via Command Line CLI - Linux
- SSMTP - Ubuntu - CentOS
Emulators
Filesystems
- MDADM
- MergerFS
- MHDDFS - Multi-Hard Drive Disk Filesystem
- SyncThings
- ZFS
- Check if ZFS Pool is Mirror or Stripe
- Create RAID-Z Pool with 3 Drives
- Create ZFS Raid Mirror with One Disk - Degraded - Missing
- Disable ZFS at Boot
- Grow or ReSize - ZFS Partition - Pool
- Rename ZFS Pool
- Use ZFS Inside Docker Container - FileServer Container with SMB and NFS
- ZFS Convert or Change from /dev/sdb to /dev/disk/by- Unique Identifier
- ZFS Notes
- ZFS Remove Device
- ZFS - Two Mirrors - One Pool
- ZPool - ZFS - Set - Check Properties
Guacamole - Clientless Web Based Remote Desktop
- Connecting to Windows via RDP - Guacamole
- Remote Desktop - Linux - HTML5 - Guacamole - Docker-Compose
Home-Security
- Agent DVR - iSpy - Docker
- Motion and MotionEye - Docker Install Guide
- Shinobi - Home-Security - Docker Install
- Wyze
- ZoneMinder
- Camera Configuration - ZoneMinder
- Install ZMNinja inside Browser - ZoneMinder WebUI
- Install ZoneMinder - Ubuntu
- ZoneMinder Configuration
- Check ZoneMinder Camera State via CLI
- Configure E-Mail notifications from ZoneMinder with MP4 Attachments
- Enable Control Tab ZoneMinder
- Event trigger on Camera A triggers Event on Camera B - Linked Monitors ZoneMinder
- Fix - "Config mismatch, expected 225 items, read 224. Try running 'zmupdate.pl -f' to reload config." - ZoneMinder
- General ZoneMinder Zone Configurations
- Ping Cell IP and Set ZoneMinder Mode - Bash Script
- Preferred RTSP method in ZoneMinder - Force TCP - Stop Smearing/Tearing
- Schedule MoDect with ZoneMinder for Daytime/Nighttime and Weekday/Weekend
- Setup Events and Images locations - ZoneMinder
- ZoneMinder default storage location for events & images
- ZoneMinder default web folder location
- ZoneMinder Functions Explained
- ZoneMinder - TimeStamp Label Format
- Install ZM - ZoneMinder via Docker
HyperVisors
- Hyper-V
- KVM - Kernel-based Virtual Machine
- CentOS- KVM
- Fedora
- General KVM
- Add Qemu Command Line Args to Domain XML LibVirt - Virsh
- CPU Pinning on KVM for Windows 10 Gaming Guest
- Find IP of KVM Guest attached to br0 Bridged NIC
- Find Qemu CLI Commands used to Start Guest
- Hide the fact Windows is running in a VM - Virtual Machine - with KVM
- KVM Passthrough BluRay drive directly to VM
- Prep Linux OS for GPU Passthrough - Blacklist nouveau and use vfio-pci drivers script
- Setup Linux for HugePages for use with KVM Guest
- Virsh Pool Management Commands
- MacOS X - Qemu
- VAGRANT
- `create_volume_xml': Call to virStorageVolCreateXML failed: storage volume 'foo.img' exists already
- Error while activating network: Call to virNetworkCreate failed: internal error: Network is already in use by interface virbr1. - Call to virDomainCreateWithFlags failed: Cannot get interface MTU on 'virbr1': No such device (Libvirt::Error)
- Install Vagrant Box Offline
- Install Vagrant - Deb
- Name `_default` of domain about to create is already taken.
- There was error while creating Libvirt storage pool: Call to virStoragePoolDefineXML failed: operation failed: pool 'default' already
- vagrant-libvirt/action/forward_ports.rb:134:in `spawn': No such file or directory - ssh (Errno::ENOENT)
- VirtualBox
- VirtualBox Headless Linux Server
- AutoStart VirtualBox VM Headless with Upstart (init.d) Script - Ubuntu Server and Vbox 5.*
- Install and Uninstall VirtualBox Guest Additions - Ubuntu VM - Command Line
- Install PhPVirtualBox 5 on Ubuntu Server 14.04 x64
- Install VirtualBox 5 + Extension Pack + DL Guest Additions ISO - Ubuntu 14
- Install Virtualbox Extension Pack Script to match installed Version - Server
- Move VirtualBox VM's from headless server with SCP
- Recompile VirtualBox Kernel - Server
- Unable to Register VM due to DvD Image - VirtualBox CommandLine
- Uninstall VirtualBox Extension Pack - Ubuntu Server
- VirtualBox - VBoxManage - Useful Command Line Arguments
- VirtualBox Windows
- VirtualBox Headless Linux Server
- VMWare
- ESXI
- 3rd Party Tools - Drivers
- Create Custom ESXI ISO
- ESXI Host
- Add ISO from Datastore to Guest VM - ESXI
- Add License to VMWare ESXI Host from VSphere Client
- Clone Any Version VMWare Virtual Machine _ VMWare 6.* Version 11 _ Without Server Center ESXI
- Correct CD-ROM state pre-export of ESXi VM
- Deploy VM from ESXi Datastore - NFS
- Enable NTP ESXi 6
- Enable RSA Key Authentication with ESXI 6.0 - One Command
- Enable SSH in ESXI Host
- esXi 6.0 default web document root location
- ESXi 6 - Locked out of Root User
- ESXi Deployment Checklist
- ESXI HTML5 Web-Client for HOST - No VCenter
- esXi Password Requirements
- Expose local disk to VMWare ESXI Guest - GPT MBR Greater then 2TB
- Fix All Invalid esXi VM's in one line of code
- Installing esXi with less then 4GB Ram
- List Network Cards and Driver Versions and Find All Nic Compatible Params - ESXi
- Mounting or Troubleshooting NFS mount ESXi 6 CLI
- Pass Through NVidia GT 1050 to VMWare ESXi Windows Guest - VT-D - IOMMU - DirectPath IO
- Recover broken esXi - Reinstall esXi without wiping Datastore and re-register VMs
- SSL Certs - ESXI
- Unsupported hardware family 'virtualbox-2.2' - Migrate VBox OVA to VMware ESXi
- Upload ISO to datastore ESXi Host
- VMWare ESXI 6.0 - Failed to dploy OVF package: The task was cancelled by a user.
- Linux Guests - ESXI
- vCenter Linux Appliance
- vCLI - vSphere SKD for Perl
- VMWare ESXi CPU Virtual Sockets, Virtual Cores and Advanced Settings Explained
- Windows Server Guests
- ESXi Backup Solutions
- VM Guest Template Checklists - VMWare
- VMWare Install Error 29141
- VMWare Workstation
- ESXI
Jenkins
- Deploy Known_Hosts to Servers
- Deploy VM_INFO Tag to XYMon via Jenkins - Monitor VM-Stats via py-vminfo.py
- Disable Jenkins Security - Locked out of Jenkins
- Install Jenkins Ubuntu
- Use Jenkins as CRON with Daily E-Mail for Console Output - Logs
Linux - Generic
- Add SSH Host Key to Known_Hosts
- Automatically reboot server with high CPU Load - Linux
- Bash - Pass Command Line Argument to Script
- Bashrc Aliases
- Bash Script - Check if SystemD service is Running
- Bash Scripting - General
- Bash - While Loop
- Bash - While Loop - Output of Command
- BINDing directories
- Cannot accept non-LF line endings in 'svn:log' property - SVN Migration
- Cat Text to File - EOL - Without opening text editor
- Clone SSH Host Key to new Server
- Continuous Ping Check Script - If Then - Bash
- Create Custom UPStart Init.D Script
- Cron Troubleshooting
- cURL
- Date Variables - Bash
- Dirty Cow
- Disable Laptop Sleep Lid Close - Server - SystemD
- Disable StrictHostKeyChecking SSH
- Doing Math in Bash Variable
- Download Entire YouTube Playlists - Extract Audio - Linux
- echo Alias to BashRC
- Find All Local Users
- Find Grub Version - Grub2 vs Legacy
- Find is Linux System in BIOS or UEFI
- Find Offending line in Known_Hosts - buffer_get_string_ret: buffer_get failed key_from_blob: can't read key type
- Find Server SSH Fingerprint via CLI
- Fix Gparted Stuck Searching Partitions - New Disk
- Fix PhP date.timezone is not set
- Generate Entropy - Ubuntu
- Grant Passwordless Shutdown to a User
- If service isn't running do - Script
- Installing Linux on BIOS Raid doesn't boot - Cant find root/boot partition
- Install NMap - Ubuntu - CentOS
- Keep VGA Console Always Alive - Grub Param
- Mount Disks in FSTAB
- Parted CLI - GTP - EXT 4 - Properly Alligned
- Pass MYSQL Username and Password via CLI in a FILE - NO USER INTERACTION
- Passwordless Sudo
- Pause Script - Wait for KeyPress - Linux
- Port Forward Vyatta
- Ports and Commands to Open or Close them - FirewallD
- Ports and Commands to Open or Close them - UFW
- PowerPanel PWRSTATD - Confirugations
- Random GREP - SED - AWK - CAT - FIND - XARGS
- Replace drive in MDADM Software Raid
- RSync - Common Flags
- RSync Entire FileSystem and Restore on New Server
- Run Command after Boot - RC.Local & Cron
- Send E-Mail via BusyBox v1.19.4 - CLI - G-Mail and Comcast
- Set Hostname via HostnameCTL
- Unpack - Unzip - OVA - Linux CLI
- Vaildate IP and run script or set static IP via dhclient.conf - IP issues Check
- While Loop that Never Ends - Bash
Mac OS
- Auto Login Mac
- Dual Boot Windows 10 and Mac OS High Sierra without BootCamp
- MacOS Startup Keyboard Shortcuts
Media Servers - Kodi - Jellyfin - Emby - Plex
- Emby - Media Server
- Jellyfin - Open Source Media Player
- Kodi - Formerly XBMC
- Delete Kodi SQL Databases and Start Fresh
- Disable Controller Input - Xbox 360
- Install and Connect Emby - Jellyfin - Server with Kodi
- Install Kodi 16 on Ubuntu 16.04
- Install KodiPlexConnect on Kodi 17.6 Krypton
- Install PlexBMC on Kodi Jarvis
- Kodi - Connect SMB Share
- Kodi - Download Old Release
- Kodi Log Locations - Windows - Mac - Linux
- Kodi - Make Kodi Use External Player MPC or VLC x64
- Kodi - My Upgrade Notes - Still on Jarvis 2022
- Kodi - Remove Annoying "Mouse Not Supported" Stupid Icon Dev's use
- Manually Delete Kodi TV / Movie DataBase Windows
- My Ultimate HTCP - Plex + Kodi + VLC-MPC + More
- Run Kodi in Portable Mode with Relative Paths
- Setup Kodi to use (MariaDB) SQL Database running in Docker Container
- Plex - Media Server
Microsoft Office - VBA - Macros - Add-Ins - JavaScript/TypeScript
- Customize Ribbon Microsoft Office
- Distributing Macros
- Excel - Non-VBA
- Manage Office via Group Policy - ADMX Files - Central Store
- Outlook - Non VBA
- VBA
- Add Date Header and Page Number Footer - VBA
- Add Keyboard Shortcut to Custom Ribbon - OfficeUI
- Add String with Quotes in VBA
- Assign Keyboard Shortcuts to Macros via Macro in VBA
- Backup VBA Files - Source Control
- Calling Batch file or CMD via VBA
- Certificate Signing of VBA Macro's/Projects
- General VBA
- Check if Directory Exists and If Not Create It - VBA
- Check if Variable is NULL - VBA
- Check or Add Reference Library - VBA
- Check Variable for Special Characters - VBA
- Compile Error: Expected variable or procedure, not module - Macros - Microsoft Office
- Copy Text to ClipBoard - Macro
- Copy to Clipboard via VBA
- Create Input Box with Default Setting - Office VBA
- Creating an Update MsgBox that only runs once with VBA
- Date Variables - VBA
- Declaring Function for Different Versions of Microsoft Office - 32 vs 64 - 2007 vs 2010
- Decode or Encode URLs via VBA
- Delete File VBA
- Display Variable in MsgBox - VBA
- Error: DataObject:GetText Invalid FORMATETC structure - Clipboard Gets Cleared During Macro Execution - VBA
- Folder Picker - VBA
- Forcing or Changing Value to Capital Letters in VBA
- Global Variables in VBA
- Input Box - VBA
- Install Font via VBA Without Admin Privileges
- Method 'Run' of object IWshShell3 failed - VBA
- Multi-Line MsgBox in VBA
- ObjArgs - VBA - For Each ObjArg - Named Args
- Random VBA API Windows Functions
- Remove Non-ASCII Characters - VBA
- Save Document - Microsoft Office - Macro
- Search AKA Grep for String in Text File with VBA
- Search String for SubString via LEFT - VBA
- SendKeys - VBA
- Set Value everything after or before = Symbol - VBA
- Simple VBA Template
- Sleep - Wait - Delay - VBS
- Split String by NewLine in Array - VBA
- Use Windows Environment Variables like %APPDATA% in VBA
- Using "Case" Statements with VBA
- Using Dates with VBA
- Using Functions in VBA to get Result
- Using GoTo with VBA
- Using Shell in VBS VBScript
- VBA - 1 Hour From Current Time - DateAdd
- VBA Data Types
- Working With Files - VBA - Does File Exist - Write - Read - To Text File
- Yes or No Input Box - VBA
- Images - VBA
- JSON - VBA
- Microsoft Excel - VBA
- ActiveSheet Name - Excel VBA
- Advanced Filter - Excel VBA - Unique Values
- Apply Conditional Formatting - Excel VBA
- Arrays - VBA
- AutoFilter - Excel VBA
- BarCodes - Excel VBA
- Call Sub from Seperate Excel Add-In - VBA
- Check if Cell in Range - Excel VBA
- Check if Cell IsEmpty with VBA
- Check if Column Has Header by Comparing A1 to A2 - Excel VBA
- Check if Integer is Even or Odd via Function - Excel VBA
- Check if Range Is Empty - VBA
- Check if Value is Numeric - Excel VBA
- Class Modules - Excel VBA
- Close Open Workbook in Excel VBA
- Close Open Workbook via Batch - WindowTitle
- Combine Two Columns - Excel VBA
- Compare Two Columns - Excel VBA
- Convert ActiveCell or Range to Column Letter in Variable - Excel VBA
- Convert Column Number to Letter - Excel VBA
- Copy Range - VBA
- Copy Rows and Columns - Excel VBA
- Copy Text to ClipBoard - Excel VBA
- Delete Multiple Columns Simultaneously - Excel VBA
- Delete Rows in Excel VBA
- Dictionaries - Dictionary - Excel VBA
- Disable warning: You copied a large amount of data onto the clipboard - Excel VBA
- Excel DisplayAlerts - VBA
- Excel VBA Color Index
- Excel VBA - Font and Borders Settings Etc
- Excel VBA to use all filled cells in columns
- Extract Alpha or Numeric Portion of String - Excel VBA
- Find ActiveCells Column Header
- Find Duplicates and Copy to New Sheet - Excel VBA
- Finding Last Used Column or Row
- Find Oldest and Newest Dates in Rng - Excel VBA
- Find or Delete Column Letter from Header Name Function - Excel VBA
- Find String in Range - Excel VBA Function
- For Each Cell in Range of Cells - VBA
- Format Integer to X Places with leading 0's
- Formatting Cells - Excel VBA
- Freeze Header Row - Column - Excel VBA
- Full Download Spreadsheet via IE - Save - Open - Copy - Close and Delete File - VBA Macro
- Function to Check if Sheet Exists - VBA
- Function to Check if Two Ranges are the Same Range - Excel VBA
- Get Column Letter from ActiveCell via Sub - Excel VBA
- Get Total Lines of Code in Macro Workbook - VBA Excel
- Have Macro run on Workbook Open - Excel VBA
- Hyperlinks - Excel VBA
- Import CSV - Excel VBA
- Insert Row or Column - Shift - Excel VBA
- Insert Value into cell near selected cell - Excel VBA
- InSTR - Excel VBA
- List Files in Folder without Extension - Excel VBA
- Merge and UnMerge cells - Excel VBA
- Move Columns via VBA
- Number From String or String from Number - VBA
- Open External Workbook and Copy Sheet to Active Workbook - Excel VBA
- Open Sharepoint/Teams Excel Workbook via VBA
- Pass Range as Variable to Sub with Rng Argument - VBA
- Pivot Tables with VBA
- Check if Pivot Table Exists and Delete - VBA
- Collapsing Pivot Tables - Excel VBA
- Create Pivot Table Sub - Check if Exists and Delete
- Create Pivot Table with VBA
- Function to check if Pivot Table Exists - VBA
- Groups and Pivot Tables - Excel VBA
- Pivot Table Settings for Orientation and Function
- Sub to Delete Pivot Table - VBA - By Name - Sheet - Or All
- Print Headers on Each Page - Excel VBA
- QueryTables - Excel - VBA
- Remove $ Cell.Address - VBA
- Remove Duplicate Rows - Excel VBA
- Run Excel Macro from Command Prompt with XLAM - VBA - VBScript
- Save New Workbook - VBA
- Screen Update VBA
- Screen Updating and Refresh - Excel VBA
- Select All Cells with Data - Excel VBA
- Send E-Mail from Excel with VBA
- Set Cell Font to Text White and Background Black - Excel VBA
- Set Range to Empty Space of Last Sheet to be Printed - hpagebreaks
- Setup Print Procedures in Excel VBA
- Sheets and Excel VBA
- Sort Range - Excel VBA
- Swap Columns - Excel VBA
- Test if Workbook is 97-2003 old xls format and upgrade
- Use Column Number in Range - Excel VBA
- Use MsgBox to diplay Range - VBA
- User InputBox for Range - Excel VBA
- Use Row of Active Cell
- VBA - Regex Search
- Worksheets and Workbooks - Excel VBA
- Autofit All Worksheets - Excel VBA
- Check if Worksheet is Protected by PWD via VBA - Excel
- Check if Worksheet Is Protected - Excel VBA
- Copy Data from External Excel Instance - Worksheet to "ThisWorkbook"
- Create Hidden Worksheets in XLAM
- Declaring WorkSheet and WorkBook - Excel VBA
- Filter Worksheet - Table - Query - Excel VBA
- Find Worksheet by Partial Name - For Each Worksheet - Compare Dates - Excel VBA
- Spell Check Protected Worksheet - Excel VBA
- XLStart Locations
- Microsoft Outlook - VBA
- Automatically Open Outlook Attachment - VBA
- Automatically Save Attachments From Specific Sender or Domain or Subject in Outlook with VBA
- Call Sub in ThisOutlookSession from Module
- Create Outlook Event - VBA
- Distribute Outlook Macros - VBA
- Generic Outlook Rules via VBA
- Get List of Custom Folder Names - Outlook VBA Dictionary Function
- Hide Title Bar - Outlook Userform - VBA
- Iterate over all Inbox E-Mails - Outlook VBA
- Mark E-Mail As Read or UnRead in Outlook via VBA
- Monitor Inbox or Custom Folders in Outlook with VBA via ItemAdd Event
- Send E-Mail via Outlook with VBA
- Set Subject - Body - Sender Domain - Sender E-mail - Attachment Filename - To Strings - Outlook VBA
- Microsoft Word - VBA
- Adding Serial Number or Incremental Number to Word Document at Print Time
- Close Word Document via VBA
- Copy Text from Microsoft Word to New Excel Workbook - VBA
- Create Simple Greeting Macro - Word - Microsoft Office
- Disable Small Margins Warning - Microsoft Office - Word - Macro
- Final - Before Print Macro
- Find Index Number of Current Table
- Run Macro Before Printing - Word - Microsoft Office
- Spell Check Protected Word Document - VBA
- Word.OfficeUI Location
- Working with Tables in Microsoft Word VBA
- UserForms - VBA
- VBA - Disable or Enable NumLock
- Windows Registry - VBA
- Working with HTML/XML - Internet Explorer - VBA
Network Monitoring
- GRAFANA
- ICINGA
- NTop
- Security Monitoring
- Fail2Ban - General
- Find all NFS Shares on LAN - NMAP
- Find all SMB Shares on LAN
- Find Windows Hostname - MAC - From Linux CLI
- Grep Netstat for IPs excluding local IP - NFS Example
- Monitor Currently Mounted NFS exports from Server
- Monitor Currently Mounted SMB Shares from Server
- Monitor Outgoing SSH Attempts with IPTables
- XYMon AKA Hobbit AKA Big Brother
- 3rd Party XYMon Custom Scripts
- Compile Latest Source Code - XYMon
- Custom Script Template - XYMon
- Have XYMon Create OpenProject Task via ALERT
- My XYMon Custom Scripts
- Adaptec RAID Monitor - XYMon - Ubuntu
- Asterisk - XYMon - CentOS
- CyberPower - UPS Monitoring
- ESXi 6 - Ram - CPU - Disk Check - NTP - XYMon - Ubuntu
- MariaDB - Galera Cluster - XYMon Check
- MySQL Replication Script - XYMon
- MYSQL - XYMon - Ubuntu - Simple Select Check
- NTop XYMon Monitoring Script
- NTP XYMon Script
- OpenVPN - XYMon - Ubuntu
- PaceMaker - HA XYMon Script
- SmartTools Monitor for XYMon
- TeamViewer - XYMon - Ubuntu
- XYMon - Monitor Git-Daemon Status
- XYMon - Simple Monitor NFS Mount
- Zabbix XYMon Monitoring Script
- ZoneMinder - XYMon - Ubuntu
- Tips and Tricks
- XYMon-Client
- XYMon-Server
- Zabbix
Network Protocols
- BitTorrent (Peer 2 Peer)
- DHCP (Dynamic Host Configuration Protocol)
- DNS (Domain Name Services)
- FTP (File Transfer Protocol)
- HTTP-HTTPS
- Apache
- Allow Apache to write to mounted NFS share
- Apache 2.4.7 ProxyPass with WebSocket and Comodo PositiveSSL SSL w/ Intermediate Certs.
- Create Simple Webpage with Button that runs Bash Script - Apache - PHP
- Redirect all NON-EXISTENT URL's to domain.com - Apache - Error 403
- Redirect Http to HTTPS - Apache2
- Secure Apache2
- Secure Webpage with .htpasswd NO .htaccess
- Simple Apache - Httpd - Web-Server - Docker-Compose
- Simple Apache HTTP VirtualHost
- NginX
- Apache
- LDAP (Lightweight Directory Access Protocol)
- Magic Packets (Wake on LAN)
- NFS (Network File System)
- NTP (Network Time Protocol)
- Protocol - Application - PortMap
- Proxy
- SAMBA (Windows Shares)
- Configure SAMBA - SMB - Docker-Compose - Using SMB.CONF
- Configure SAMBA - SMB - Network Share
- Grant Write Access Based on IP in Samba SMB
- Mount SAMBA SMB Client Installation and CLI Example
- Mount SMB/SAMBA/CIFS Share via FSTAB
- Samba Follow SymLinks
- SMB(D) Samba - Reports falsely there is Not enough disk space - DFREE Ubuntu 14.04
- SMB Samba - Configure blocking range of 192.168.1. network and allow IPs only from static pool of IPs.
- Secure Sockets Layer (SSL)
- SSH (Secure Shell)
- VPN (Virtual Private Network)
- Vyatta - Debian Linux Router
- WebDav (Web Distributed Authoring and Versioning)
NoSQL - Document Based Database
NVidia
OpenProject
- Cannot serve directory /opt/openproject/public/ - OpenProject
- Compile OpenProject 8.2.1 on Ubuntu 18.04
- Failed to restart openproject.service: Unit openproject.service not found.
- Host Other Website on Port 80 with OpenServer
- Install OpenProject - Ubuntu - Debian
- Migrate OpenProject MySQL to PostGRESQL
- mysql2::Error::ConnectionError: Access denied for user 'open project'@'localhost' (using password: YES)
- OpenProject - API
- OpenProject Config Set - Get
- OpenProject - Docker
- OpenProject Installer.dat - Default
- OpenProject Migration Script
- OpenProject - NGinX and Apache - Reverse Proxy
- OpenProject - SSL Configuration
- OpenProject - Troubleshooting
- OpenProject - Unable to verify Cross-Site Request Forgery token Error
- Restore Backup to Server - OpenProject
Password Managers
PHP
- Check File Size - PHP - IF Then
- Create ZIP File without Folder Structure - PHP
- Open New Browser Tab PHP
- PHP Build File Directory structure base on DateTime
- PHP - Check Number of Rows Effected by SQL Select Statement
- PHP - Display URLs for results with Variables
- Set PHP Variables in Bash Script
- Simple download file - PHP Script
- Simple MySQL Query with PDO - PHP Example
Python
Raspberry Pi - Raspbian OS
- BigBox and Raspberry Pi - Launching Custom Software via Moonlight
- Emulate - Virtual - Raspbian OS - Debian Stretch - Qemu
Smart-Home
- Home-Assistant
- Add Mysa to Home-Assistant
- AgentDVR - Home-Assistant
- Binary - Boolean - Sensor from Sensor Value
- Bluetooth Scanning with Home-Assistant in Docker in a VM
- Call Home-Assistant Automation via URL - WebHook
- Change LoveLace UI in Home-Assistant
- Configure HomeAssistant Auth in Configuration.yaml
- Control Kevo via Home-Assistant with Toggle Switch
- Create Basic Toggle Switch to Run Script or Execute Command with Home-Assistant HASS.IO
- Create Delay - Home-Assistant
- Device_Tracking - Home-Assistant
- Home-Assistant and LED Lights
- Home-Assistant - Control Roku TV - Automatically Play YouTube - Turn On or Off
- Home-Assistant - Repeating or Looping Service Calls
- Home-Assistant with NGinX
- Home-Away Automations via Home-Assistant
- IFTT - If This - Then That - Home Asisstant
- Installation of Home-Assistant - HassIO - Supervised or whatever it's called now
- Integrate ZoneMinder with Home Assistant - HASS.IO - LoveLace Card
- Line-Break for Message in Home-Assistant
- My Full Home-Assistant Configuration.YAML
- Person - Home Assistant Presence-Detection
- Push Notifications with Home-Assistant and Android - Send Sensor Status
- Search for iBeacons - BLE - via PowerShell - Home-Assistant Presence Detection - Windows
- Setup E-Mail Notifications via Home-Assistant
- Setup MQTT Bridge - Home Assistant
- Split Scripts into Multiple Files in Directory with Home-Assistant
- Theme Home-Assistant
- XIAOMI_Mijia_LYWSD03MMC
- Zones - Home Assistant
- Logitech Harmony
- Scripting Kevo Unlock - Lock - via Python and Bash
- Wall-Mounted-Table Home-Assistant
Ubuntu-Debian
- Emby
- FFMPEG
- General Ubuntu-Debian
- Debian - Rebuild Default Sources.List - APT
- Download All Package Requirements for Deb - Debian Package - APT-GET
- FIX
- Install
- Bluetooth - Linux
- Install Adaptec Raid Controller ARCConf - Ubuntu
- Install GNOME Desktop - Ubuntu Desktop and Server 14.04
- Install Google Chrome Ubuntu - One Command
- Install Grive2 on Ubuntu Server
- Install LAMP in One Command - Ubuntu Server
- Install NoVNC with Websockify - Ubuntu Server 14.04
- Install PWRSTAT (PowerPanel) - CyberPower Linux CLI Interface - Ubuntu - CentOS
- Install VNCServer - Ubuntu
- Install WebMin - Ubuntu
- Install Specific Version of Software via APT
- Missing Firmware Fix - Debain Ubuntu - isenkram
- Other
- Bash Script - Add User - Ubuntu
- Check SMART status of Hard Drive - Ubuntu
- Convert InstallEMG.dmg to ISO
- Deluge P2P
- Disable - "waiting an additional 60 seconds for network configuration" - Ubuntu Server 14.04 x64
- If Ubuntu or Debian Then - Bash Script
- Purge PostgreSQL via APT
- Recover Files with EXTUNDELETE - MDADM - UBUNTU
- Remove PPA - Ubuntu 14.04 x64 CLI
- Ubuntu Revision into Variable - CLI
- HandBrake
- Networking
- PleX
- Security
- TeamViewer
- Untouched Default Files
Visual Studio
VoIP
- Asterisk VoIP
- Fix - asterisk.ctl: No such device or address
- Fix - This module requires Asterisk chan_motif & res_xmpp to be installed and loaded
- Hangup All Calls Asterisk CLI
- Monitor PJSip Trunk Registration with Bash Script
- Originate Call from Command Line - Asterisk
- Upgrade Asterisk core in Asterisk Now 1.6 > 1.8
- Use Asterisk CLI in Bash Script
- Call Detail Records (CDR)
- Capture VoIP traffic with TCPDUMP and Examine in Wireshark
- Enable TFTPBoot for Hardware SIP Phones
- FOP2
- FreePBX VoIP
- Configure Google Voice Motif + Asterisk SIP for Google Voice - FreePBX 13
- Customize Images on FreePBX
- Disable "If this is correct, press 1'" from VoiceMail Blasting - FreePBX
- Fix FreePBX can't Connect to Asterisk
- Locked out of FreePBX GUI
- PIN conference is no longer optional - FreePBX 12 + Asterisk 1.8
- Pre and Post Backup Hooks to add Database to FreePBX Backup Module
- Remove 0 Second Calls FreePBX - Asterisk
- Set TimeZone for Voicemail in FreePBX - Asterisk
- Install LAME 3.99
- Obi - Google Voice
- PBX In a Flash (PIAF)
- SHMZ 6.6
- VoIP Phones
Web-Browser
- Configure G-Mail Account for IMAP
- Purge Entire Google Voice History - TxTs - Trash Etc
- Purge - Gmail - Verizon - Yahoo - AOL - Comcast - Microsoft - RR/TWC - Inbox (WebMail)
Windows
- CygWin
- Microsoft Office
- Scripts - CMD-BAT-PS1-VBScript
- Batch - CMD
- Access CMD before Login Screen
- Adding or Removing Printers via Batch Files - Windows
- Assign Variable to Output of Command - Batch
- Automatically accept input in batch - cmd - without user hitting Enter
- Batch Loop to check if File Exists
- Call Variable from Another Batch File - CMD
- Change IP Address with .CMD Files
- Check if Executable is Running - Batch
- Check if Network Printer is Installed via Batch Function and Install if Needed
- Check if SubString is in String - Batch - Grep Windows
- Convert RSA Key to PPK via CLI using WinSCP
- Count Arguments - Batch
- Create .CMD that silently executes with no open window
- Create Array - Batch
- Create Placeholder - Empty File In Temp - Batch
- Create Shortcut to File via Batch - CMD
- CSV List of Tasks in Windows - TSKill
- Custom Help Message - Batch
- Detect Office Version - Architecture - Batch CMD
- Embed VBA - VBS VBScript - in Batch/CMD
- Find Executable via Batch - Microsoft Office Example - WINWORD - Find Microsoft Office Path
- Find FilePath with WildCard in Batch
- Find Windows Version via Batch - Function
- Forcing Valid User Input in Batch/CMD
- For Each File in Directory - Batch - CMD
- For Loop Batch
- Get File Extension from Full File Path
- If Var = String - Batch
- In - Then - Else - Windows Batch - Test if Variable is SET
- List Files in Directory - Recursive - Batch
- Make CMD.EXE start in %USERPROFILE%
- Open Multiple Webpages in same Browser Instance via Batch/CMD File
- Output List of WindowTitle via CMD Batch
- Pass Named Arguments to Batch Script - CMD
- Print Files via Batch - Windows
- Print Excel Via Command Line - VBA VBScript - Excel.exe Switches
- Print Files Recursively from Current Directory via Batch CMD
- Print Microsoft Word via Batch - WINWORD.EXE Switches - VBScript Print Specific Pages
- Print PDF Via Batch - AcroRd32.exe Switches - Print Specific Pages
- Print PowerPoint via Batch - POWERPNT.EXE Switches
- Push Current Running Directory inside Batch File - Run VBS in same directory
- Random CMD Batch Stuff
- Reboot to safe mode CMD
- Remove Whitespace Batch
- Reset Local Admin Password Windows
- Return Value after Foo in Batch
- Set Global Variable in Batch CMD
- Simple Enter Yes or No Batch - CMD - Input - Windows
- Strip Numbers from String - Batch CMD
- Stripping down to just User-Folder from %USERPROFILE% - BATCH
- Strip Server and Share from Network Share via Batch For
- Timed Ping Windows - Linux
- Using Functions with Batch - Return Value
- Using Input from External Program in Batch - CMD
- While Loop - Batch
- While Loop that checks for exe process running
- Windows - Disable Certificate Revocation List Check - Batch
- Windows Registry - Batch CMD
- Yes - No - User Input - Batch
- PowerShell
- Arrays in PowerShell
- Call PowerShell Script with Space in Path
- Check if Process is Running and Close - PowerShell Function
- Concatenate - Combine Variables - PowerShell
- Conditional Evaluators - IF THEN ELSE WHILE DO UNTILL - PowerShell
- Configure Remote Desktop - RDP - PowerShell
- Custom Help - PowerShell Script
- Disable or Enable Windows Defender via PowerShell
- E-Mailing with PowerShell
- Embed VBScript in PowerShell - PS1
- ExecutionPolicy - PowerShell
- Find Executable - PowerShell
- Find Windows Version Number via PowerShell
- ForEach-Object - PowerShell
- Functions - PowerShell
- Get Folder or File Path from GUI - PowerShell
- List All Variables and Values - PowerShell Debugging
- Passing Params to Script - PowerShell
- PowerShell - Change network type - Private Public
- PowerShell - ComboBox - DropDown List - User Input to Variable
- PowerShell - Grep
- PowerShell - Integer Counter Increment
- PowerShell - Sed - Find and Replace Text in Files
- PowerShell - SLEEP - Delay
- PowerShell - Switch or Case Statements
- PowerShell - Windows Environment Variables
- Printing via PowerShell
- Redirect Powershell Out to Null
- Registry Query via PowerShell
- Restart BT - Bluetooth Service from PowerShell
- Run PowerShell Job in Parallel - Start-Job - Pass Arguments
- SendKeys - PowerShell
- Setting Variables in Functions - Global Variable - PowerShell
- Start PowerShell Script via Task Scheduler - Windows 10
- Start-Process via PowerShell with Arguments
- String Commands in Single Line - PowerShell
- Temp File - PowerShell
- Using Powershell Variables
- View Network Details - InterfaceAlias - Powershell
- Wildcards and FilePaths - PowerShell
- Yes No Prompt - PowerShell - Read-Host
- VBScript
- Batch - CMD
- Windows Admin Center
- Windows - Docker
- Windows - General
- Create Task to Autostart Executable with Admin Privileges - Export - Import Task
- Fix: We can't verify who created this file - Open File Security Warning - Windows 10 - Not Outside Local Network LAN
- Gaming
- GNS3 - Network Simulation
- MultiBoot ISO-USB
- VLC
- Windows 8.1
- Windows 10
- Add Trusted Site via Group Policy
- Automatically Mount VHDx - VHD - File - Command line - Script - CMD - Mount and Unmount at boot - shutdown - Windows 10
- Block Windows 10 Spying - known IP's and Add Host files to block data mining by Microsoft!
- BlueTooth Stack
- Change Product Key Windows 10 via RUN
- Create Custom Windows 10 ISO
- Convert install.esd to install.wim via PowerShell with dism
- Create custom install.wim with WinPE
- Create WinPE ISO for Windows 10 Custom ISO
- Install Windows 10 ADK for Making Custom Windows 10 ISO
- SysPrep failed to remove apps for the current user 0x80073cf2.
- SysPrep - Windows 10 Custom ISO
- Windows 10 Custom ISO GUI Tools
- Destroy Windows 10 Spying
- Disable Password Expiration - Windows 10
- Disable Windows 10 Education Watermark
- Disable Windows 10 Updates
- Enable Windows Thumbnails
- Install Custom Themes for Windows 10
- Install Second Printer Copy - Windows 10
- Internet Options to add Local Intranet Trusted Site Greyed Out
- Move Windows 10 User Folders to Network Share
- Remove Edge - Windows 10
- Remove OneDrive from Windows 10 - Script
- Remove Windows 8 8.1 10 UAC Completley
- Remove Windows 10 Metro Apps
- Restore Old Windows Calculator - Windows 10
- Restore Windows Photo Viewer in Windows 10
- Share Printer via SMB - Windows 10
- Store Can't Be Opened Using The Built-In Administrator Account - Windows 10
- Uninstall Windows 10 Cortana Completely
- Upgrade from fresh Windows 8.1 x64 to Windows 10
- Windows 10 Built In Screen Recorder
- Windows 10 Optimal Privacy Settings
- Windows 10 - Post Install Checklist
- Windows - Screen Record to GIF
- Windows Personal Generic
- Automatically run script at boot - shutdown - login - logoff - Windows
- Benchmarking - Windows Software
- Check if BIOS is UEFI or Legacy From Windows
- Convert RSA id_rsa OpenSSH key for Putty and Configure Putty
- Create Shortcut to Network Interfaces
- Disable FileBot Update Nag
- Enable Net 3.5 Framework from Install Media - No download or network connection needed
- Enable WebCam - Clevo w230SS
- Force Using Internet Explorer - No Redirect to Edge
- Generating Movie from Photo Album with Sound Track on Windows
- HandBrake (GUI or CLI) Rotate Video
- Launch Windows Program from Keyboard Hotkey
- Make VLC Open on Second Display - Windows 10 - VLC 2.2.6
- Manually Edit Windows Host File
- Remove "Open File - Security Warning" - Windows 10 - Network Share
- Remove new line Characters in GEdit for Windows
- Repair Windows BCD MBR Bootrecord from Command Line with just ISO
- RetroArch won't start - Error the instruction at 0x referenced memory at 0x could not be written or read
- Stop Outlook Calendar asking for PST
- TeamViewer not Staying Signed In
- Windows 10 N - Install Media Feature Pack
- Windows Start Folder Location(s) - (User and AllUsers)
- WinPE ISO with Desktop and WiFi - 500mb Non-Persistent OS - USB Bootable - 7-8.1-10
- WinPE WaikTroubles
- Windows - SSL
- Windows - RDP - Remote Desktop
- Enable RemoteFX USB Redirection - Share USB Devices like Xbox 360 Controller over RDP - Remote Desktop Protocol - Windows 10
- Reboot from inside Remote Desktop
- Remote RDP for Windows - Create Custom Port and Add Rule to Firewall with Command Line
- Secure RDP via Account Lockout Policy - Prevent Brute Force PWD Attack
- Setup Windows Remote Desktop - RDP - To Use SSL Cert
- Windows - Certificate - SSL - File Location
- WinRM - PSRemoting - Setup Remote Management via WinRM and Remote Powershell
- Windows - RegEdits
- Configure Xbox GameBar in Windows 10 via Registry and Powershell
- Disable UNCPatch Check - Windows Batch
- Fix Hyperlink in Microsoft Office - Your organization's policies are preventing us from completing this action
- Hide or Expose Networked Drives in Windows
- Reg Add - Example
- Remove "Folders" from "This PC" - Windows 10 RegEdit
- Windows Server
- Add Servers to Server Manager 2012 R2 without Domain
- Block Specific Metro App With AppLocker - Packaged App Rules
- Create Shortcut(s) on Desktop with Group Policy
- Disable or Enable ICMP Ping Windows Firewall
- Disable Password Expiration Windows Server 2012 R2 + Password Complexity Rules
- Domain Controllers
- Install Desktop Experience with Powershell
- Install OpenSSH - Windows 10
- Redirect Documents folders to Network Share with Group Policy
- Windows Server Core
WordPress
- Backup WordPress Sites with CRON
- Change WordPress URL and Fix broken Images
- Fail2Ban WordPress Installation
- Installing WordPress - Ubuntu
- Install Wordpress - CentOS 7
- Install Wordpress - Docker-Compose
- Migrate Wordpress Site via All-In-One Migration Plugin
- Self Hosted Site Uploading
- Styling Options
XSL
- XSL - Comments
- XSL - If - Else - When - Otherwise - Choose
- XSL - SubString
- XSL - Template - Functions
- XSL - Variables
NodeJS
Xbox
Ruby
- No labels