- 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
API - Application programming interface
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
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
- 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 Execute Script in Container
- Docker General Commands
- Docker - Install Template
- Docker Port Mapping
- Docker Volume Mapping
- Install Docker via APT
- Install or Update to Latest Docker-Compose Script
- Install Portainer - A Docker WebUI - via Docker
E-Mail - 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
- 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
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
- 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
Kodi - Formerly XBMC
- Delete Kodi SQL Databases and Start Fresh
- Disable Controller Input - Xbox 360
- Install and Connect Emby Server with Kodi 17 Krypton
- Install Kodi 16 on Ubuntu 16.04
- Install KodiPlexConnect on Kodi 17.6 Krypton
- Install PlexBMC on Kodi Jarvis
- Kodi - Download Old Release
- Kodi Log Locations - Windows - Mac - Linux
- Kodi - Make Kodi Use External Player MPC or VLC x64
- 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
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
- 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
Microsoft Office - VBA - Macros
- 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
- Calling Batch file or CMD via VBA
- Certificate Signing of VBA Macro's/Projects
- Check if Directory Exists and If Not Create It - VBA
- Check if File Exists - VBA
- Check if Variable is NULL - VBA
- Check Variable for Special Characters - VBA
- ComboBoxes - VBA
- Compile Error: Expected variable or procedure, not module - Macros - Microsoft Office
- Copy to Clipboard via VBA
- Create File with VBA
- Create Input Box with Default Setting - Office VBA
- Creating an Update MsgBox that only runs once with VBA
- Date Variables - VBA
- Decode or Encode URLs via VBA
- Delete File VBA
- Display Variable in MsgBox - VBA
- Distributing Macro via Add-In - Customized Ribbon - Via Batch
- 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
- Microsoft Excel - VBA
- ActiveSheet Name - Excel VBA
- Advanced Filter - Excel VBA - Unique Values
- Apply Conditional Formatting - Excel VBA
- AutoFilter - Excel VBA
- Call Sub from Seperate Excel Add-In - 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 Value is Numeric - Excel VBA
- Close Open Workbook in Excel VBA
- Close Open Workbook via Batch - WindowTitle
- Combine Two Columns - Excel VBA
- Compare Two Arrays - Range to Array - Excel VBA
- Convert ActiveCell or Range to Column Letter in Variable - Excel VBA
- Convert Column Number to Letter - Excel VBA
- Copy Data from External Excel Instance - Worksheet to "ThisWorkbook"
- Copy Range - VBA
- Copy Rows and Columns - Excel VBA
- Copy Text to ClipBoard - Excel VBA
- Declaring WorkSheet and WorkBook - Excel VBA
- Delete Multiple Columns Simultaneously - Excel VBA
- Delete Rows in Excel VBA
- Disable warning: You copied a large amount of data onto the clipboard - Excel VBA
- Excel VBA Color Index
- Excel VBA - Font and Borders Settings Etc
- Excel VBA to use all filled cells in columns
- Find ActiveCells Column Header
- Find Duplicates and Copy to New Sheet - Excel VBA
- Finding Last Used Column or Row
- Find or Delete Column Letter from Header Name Function - Excel VBA
- Find Worksheet by Partial Name - For Each Worksheet - Excel VBA
- For Each Cell in Range of Cells - VBA
- Format Integer to X Places with leading 0's
- Formatting Cells - Excel VBA
- Full Download Spreadsheet via IE - Save - Open - Copy - Close and Delete File - VBA Macro
- Function to Check if Sheet Exists - VBA
- Get Column Letter from ActiveCell via Sub - Excel VBA
- Have Macro run on Workbook Open - Excel VBA
- Import CSV - Excel VBA
- Insert Value into cell near selected cell - Excel VBA
- InSTR - Excel VBA
- Merge and UnMerge cells - Excel VBA
- Move Columns 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
- 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
- Spell Check Protected Worksheet - Excel VBA
- 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
- XLStart Locations
- Microsoft Outlook - VBA
- Automatically Open Outlook Attachment - VBA
- Automatically Save Attachments From Specific Sender or Domain in Outlook with VBA
- Create Outlook Event - VBA
- Distribute Outlook Macros - VBA
- Mark E-Mail As Read or UnRead in Outlook via VBA
- Monitor Inbox or Custom Folders in Outlook with VBA via ItemAdd Event
- Search Outlook Mail Subject or Body for String - VBA
- Send E-Mail via Outlook with 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
- Multi-Line MsgBox in VBA
- ObjArgs - VBA - For Each ObjArg - Named Args
- Open External Workbook and Copy Sheet to Active Workbook - Excel VBA
- Open Internet Explorer URL via VBA
- Open Sharepoint/Teams Excel Workbook via VBA
- Populate ComboBox list based on first ComboBox selection
- 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 into Array of Characters - 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
- Write to Existing Text File with VBA
- Yes or No Input Box - VBA
- Visual Studio
My Tech Toys
Network Monitoring
- NTop
- Security Monitoring
- 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 Docker
- 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 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)
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
- 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
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
- 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
- Install Home-Assistant Docker Container
- 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
- 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
- Uninstall HASS.IO
- Scripting Kevo Unlock - Lock - via Python and Bash
Temp
Ubuntu-Debian
- Emby
- FFMPEG
- General Ubuntu-Debian
- Download All Package Requirements for Deb - Debian Package - APT-GET
- FIX
- Install
- 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 WebMin - Ubuntu
- Set up X11 VNC in one command - Ubuntu Desktop or Server 14.04
- Install Specific Version of Software via APT
- 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
- 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
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
- 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
- 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 Network Printer is Installed via Batch Function and Install if Needed
- Check if SubString is in String - Batch - Grep Windows
- Configure Remote Desktop - RDP - PowerShell
- 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
- CSV List of Tasks in Windows - TSKill
- Custom Help Message - Batch
- Disable or Enable Windows Defender via PowerShell
- Embed VBA - VBS VBScript - in Batch/CMD
- Filesystem Object and Expanding Environment Variables in VBScript - Delete File
- Find Executable via Batch - Microsoft Office Example - WINWORD - Find Microsoft Office Path
- Find FilePath with WildCard in Batch
- Find Windows Version Number via PowerShell
- Find Windows Version via Batch - Function
- Fix: We can't verify who created this file - Open File Security Warning - Windows 10 - Not Outside Local Network LAN
- 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
- 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
- PowerShell - Change network type - Private Public
- 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
- Restart BT - Bluetooth Service from PowerShell
- Return Value after Foo in Batch
- Set Global Variable in Batch CMD
- Simple Enter Yes or No Batch - CMD - Input - Windows
- 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
- Using Powershell Variables
- View Network Details - InterfaceAlias - Powershell
- While Loop - Batch
- While Loop that checks for exe process running
- Yes - No - User Input - Batch
- Windows Admin Center
- Windows Personal
- Create Task to Autostart Executable with Admin Privileges
- 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 Optimal Privacy Settings
- Windows 10 - Post Install Checklist
- 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
- 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
- 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 - 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
- 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
- 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
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
- No labels