dijeesh

root@db-001:~# mygrants $@ mygrants()
{
    mysql -BN $@ -e "SELECT DISTINCT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') AS query FROM mysql.user" | \
    mysql $@ | \
    sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/## \1 ##/;/##/{x;p;x;}'
}


This will generate GRANTS for each user in your MySQL database server.  

dijeesh

Tunnel 1 
===================================

set security ike proposal ike-prop-vpn-to-aws-1 authentication-method pre-shared-keys 
set security ike proposal ike-prop-vpn-to-aws-1 authentication-algorithm sha1
set security ike proposal ike-prop-vpn-to-aws-1 encryption-algorithm aes-128-cbc
set security ike proposal ike-prop-vpn-to-aws-1 lifetime-seconds 28800
set security ike proposal ike-prop-vpn-to-aws-1 dh-group group2

set security ike policy ike-pol-vpn-to-aws-1 mode main 

dijeesh

#! /bin/bash
# XenServer Pool Patching Script

set -euo pipefail
readonly PATCHFILE=$1
pushd /root/hotfix >/dev/null || exit 1
readonly HOSTS=$(xe host-list --minimal |tr , ' ')

UUID=$(xe patch-upload file-name="$PATCHFILE")