Skip to content

Instantly share code, notes, and snippets.

🕶
Hunting bugs....

Alexander Garzon agarzon

  • Zend Certified Engineer
  • Canada, Montreal
View GitHub Profile
@agarzon
agarzon / texture-selector.go
Created Nov 12, 2018
Zibo texture selector for x-plane
View texture-selector.go
// This command line program helps to install 4k or 2k textures in the Zibo's B738
// Author: Alexander Garzon
// Multi-platform. It should work with WIN, OS and Linux. Just be sure the file has execution permisstions.
// Tested with Zibo 3.31
package main
import (
"fmt"
"io"
@agarzon
agarzon / whmcs-export.sql
Created Nov 2, 2018
WHMCS export hosting services
View whmcs-export.sql
SELECT tblhosting.domain, tblservers.name, tblhosting.domainstatus, tblproducts.name , CONCAT(tblclients.firstname, ' ', tblclients.lastname) AS Client, tblclients.status AS Clientstatus
FROM tblhosting
LEFT JOIN tblproducts ON tblhosting.packageid = tblproducts.id
LEFT JOIN tblservers ON tblhosting.server = tblservers.id
LEFT JOIN tblclients ON tblhosting.userid = tblclients.id
WHERE tblhosting.domainstatus IN ('Active', 'Suspended')
ORDER BY tblservers.id ASC
INTO OUTFILE '/tmp/whmcs.csv';
@agarzon
agarzon / shred.sh
Created Oct 4, 2017
Securely erasing all files in folders recursively
View shred.sh
#!/bin/bash
#If you want more "passes" change vzun0 for vzun1 or any other number (process will be slower!)
find /mnt/backup -type f -print0 | xargs -0 shred -vzun0
@agarzon
agarzon / docker-compose.yml
Last active Oct 20, 2018
My docker-compose.yml for development
View docker-compose.yml
gitlab:
image: 'gitlab/gitlab-ce:latest'
container_name: gitlab
restart: always
hostname: 'gitlab.mcu.dc'
environment:
GITLAB_OMNIBUS_CONFIG: |
external_url 'http://gitlab.mcu.dc:8090'
gitlab_rails['gitlab_shell_ssh_port'] = 2290
gitlab_rails['smtp_enable'] = true
@agarzon
agarzon / senderscore.sh
Created Feb 10, 2017
Check Sender Score from IP using command line. bash script
View senderscore.sh
#!/usr/bin/env bash │ject-with tcp-reset
# usage: ./senderscore.sh 74.91.28.11
if [ -z "$1" ]
then
echo "IP is missing as arguemnt."
exit
fi
IP=$1
@agarzon
agarzon / phplint.sh
Last active Oct 4, 2017
Recursive PHP linting
View phplint.sh
find . -name "*.php" -print0 | xargs -0 -n1 -P $(nproc) php -l | grep -v '^No'
@agarzon
agarzon / install-php-tools.sh
Last active Jan 28, 2019
Install globally popular PHP dev tools like composer, phpunit, phpcs, phpmd, phpcpd, deployer, robo, codeception, etc.
View install-php-tools.sh
#!/bin/bash
#To execute it directly: sudo bash <(curl -s https://gist.githubusercontent.com/agarzon/ecb0b92d4c8e1bbde126534c76721a58/raw/install-php-tools.sh)
BIN_PATH=/usr/local/bin/
#COMPOSER
sudo curl -LsS https://getcomposer.org/composer.phar -o ${BIN_PATH}composer
sudo chmod a+x ${BIN_PATH}composer
@agarzon
agarzon / letsencrypt-hostname.sh
Created Jun 3, 2016 — forked from xgin/letsencrypt-hostname.sh
Secure plesk clean installation with hostname certificate by Let's Encrypt
View letsencrypt-hostname.sh
#!/bin/bash -e
### Copyright 1999-2015. Parallels IP Holdings GmbH. All Rights Reserved.
### Secure plesk clean installation with hostname certificate by Let's Encrypt
export PYTHONWARNINGS="ignore:Non-standard path"
LE_HOME=${LE_HOME:-"/usr/local/psa/var/modules/letsencrypt"}
HOSTNAME=$(hostname)
# Use staging server for testing
# --server https://acme-staging.api.letsencrypt.org/directory
@agarzon
agarzon / remove_old_kernels.sh
Last active Feb 2, 2016
ubuntu remove old kernels (fish shell)
View remove_old_kernels.sh
dpkg --list | grep linux-image | awk '{ print $2 }' | sort -V | sed -n '/'(uname -r)'/q;p' | xargs sudo apt-get -y purge
@agarzon
agarzon / mysql_backup.sh
Last active Nov 16, 2017
Mysql Backup ALL databases
View mysql_backup.sh
#!/bin/bash
TIMESTAMP=$(date +'%Y-%m-%d_%Hh%Mm')
BACKUP_FOLDER=/mnt/backup/mysql
MYSQL_USER=admin
MYSQL_PASS=`cat /etc/psa/.psa.shadow`
MAX_DAYS=15
DATABASES=`mysql --user=$MYSQL_USER -p$MYSQL_PASS -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`
mkdir -p "$BACKUP_FOLDER"
You can’t perform that action at this time.