Create a MySQL instance in a docker container that's bound to the hosts standard MySQL ports. This is useful if you're developing locally without a docker-compose enviornment and don't want to run MySQL on your local or virtual machine.
sudo docker run --name mysql5 -e MYSQL_ROOT_PASSWORD=toor -P 3306:3306 -d mysql:5
You should be able to connect to the server using root and toor as credentials.
sudo nano /etc/fail2ban/filter.d/nextcloud.conf
[Definition]
failregex=^{"reqId":".*","remoteAddr":".*","app":"core","message":"Login failed: '.*' \(Remote IP: '<HOST>'\)","level":2,"time":".*"}$
^{"reqId":".*","level":2,"time":".*","remoteAddr":".*","app":"core".*","message":"Login failed: '.*' \(Remote IP: '<HOST>'\)".*}$
^.*\"remoteAddr\":\"<HOST>\".*Trusted domain error.*$
| `sudo nano /etc/fail2ban/filter.d/nextcloud.conf` | |
| ``` | |
| [Definition] | |
| failregex=^{"reqId":".*","remoteAddr":".*","app":"core","message":"Login failed: '.*' \(Remote IP: '<HOST>'\)","level":2,"time":".*"}$ | |
| ^{"reqId":".*","level":2,"time":".*","remoteAddr":".*","app":"core".*","message":"Login failed: '.*' \(Remote IP: '<HOST>'\)".*}$ | |
| ^.*\"remoteAddr\":\"<HOST>\".*Trusted domain error.*$ | |
| ``` | |
Note that this guide assumes an "All in one" server setup, where the Zabbix Server and supporting database are all on one machine. It also asusmes Zabbix Proxy is not used, or will be setup later.
NOTE: content based on https://www.zabbix.com/documentation/4.0/manual/installation/install_from_packages/debian_ubuntu
For trouble shooting, review the Zabbix logs located at /var/log/zabbix/zabbix_server.log
| # Find duplicate filenames | |
| ## Find everything in the Pictures directory with the same file name excluding extension. | |
| ls -1 ~/Pictures/ | sed 's/\(.*\)\..*/\1/' | sort | uniq -c | grep -v " 1 " | |
| # Find unique filenames | |
| ## Find everything in the Pictures directory without the same file name excluding extension. | |
| ls -1 ~/Pictures/ | sed 's/\(.*\)\..*/\1/' | sort | uniq -c | grep -v " 2 " |
| # --------------------------------------- | |
| # Git Commands | |
| # --------------------------------------- | |
| alias gits="git status" | |
| alias gitp="git push" | |
| alias gita="git add -A" | |
| alias gitc="git commit" | |
| alias gitcr="git remote set-url origin" | |
| alias gitdiff="git difftool --tool=meld --dir-diff" |
I've needed to work with imagick for some projects and found a need for extracting the actual image from a transparent png using both PHP and bash under different circumstances. This file servers as notes on intersting articules/search results that have aided me.
| #!/bin/bash | |
| # ----------------------------------------------- # | |
| # Install an AMP environment on Ubuntu 16.04 | |
| # ----------------------------------------------- # | |
| # Update the system's repositories | |
| sudo apt-get update | |
| # Install apache2, mysql-server and PHP5 | |
| sudo apt-get install apache2 mysql-server php7.0-mysql php7.0-curl php7.0-json php7.0-cgi php7.0 libapache2-mod-php7 |
| #!/bin/bash | |
| # Move a Source set of files to a Destination folder with a ".png" extension. | |
| # Note that by default this script looks for any file with a name ending in "_IMAGE" but you can change this as you see fit. | |
| # It also limits the depth to 1, so it doesn't search subfolders. | |
| # The original purpose of this script was to move artwork loaded into an SFTP area by a client and place it somewhere else for automated processing, keeping their SFTP jail clear from old files. | |
| # One Liner for Crontab | |
| #cd /path/to/source; find . -name '*_IMAGE' -maxdepth 1 -exec mv '{}' /path/to/destination/'{}'.png \; ; | |
| # We move to the source directory of the files, so during the find there's less work to to extracting the file name from the path in the mv command. |