Lost Application Window!

If you are having pain and have lost your application window to a monitor that doesnt exist, try this!  From the task bar: 1. Press and hold the Shift key, right click or press and hold on the taskbar app icon and release the Shift key. 2. Click/tap on Move. (as per screen grab)   3. Using your up-down-left-right keys on your keyboard, hold[…]

Certbot WWW and Non-WWW

For Apache To use certbot for both a http://domain and http://www.domain use the following command:  

  Without specifying both domains, you will get a certificate error for the domain not specified during creation.

Reverse Proxy into Linux via SSH

Instructions to establish a reverse SSH proxy on server startup. Useful for setting up a server behind gateways/firewalls.   Install SSH keys on the remote and local server. Note the command should work independently before setting up as a service.

On the remote server you can login via the tunnel

  Create a service[…]

Setup WIFI on Ubuntu Beaver with Netgear A6210

Ensure the Netgear dongle is seen by the OS

  Installing Netgear A6210

  Command line setup on Ubuntu Beaver.. Install the network manager package

Start the network manager service

Run the network manager UI

    These can be useful

Ubuntu Server 18.04 (Bionic Beaver) – Set Static IP Address

The latest version of Ubuntu server has moved management of IP information from /etc/network/interfaces into a YAML file located here: /etc/netplan/ Example static IP address set below: Step 1: Edit the file: /etc/netplan/50-cloud-init.yaml  Set the IP to: 192.168.100.201

Step 2: Apply the change, run the command: netplan apply  

Block IPs by country – Apache

Step 1 If you are using debian or ubuntu, install the mod-geoip package. sudo apt-get install libapache2-mod-geoip   Step 2 Enable GeoIPEnable, edit geoip.conf

  Step 3 Find Country Code Lookup: https://en.wikipedia.org/wiki/ISO_3166-1 In Apache vhosts file, outside of the </Directory> tags:

Step 4 service apache2 restart  

Certbot New Cert for Apache

  https://certbot.eff.org/

Excel – Ping List and Return Status

Code snippet to return IP and Hostname lookup in excel. Change the sheet name and ranges as needed. Can take some time to run on big lists!  

Count tables MYSQL

Count tables within a DB, nice and easy..