Compare zones between two Nameserver

for TYPE in A CNAME MX TXT; do
    for i in $(cat /tmp/ | grep ${TYPE} | cut  -f1); do
        OLD=$(dig @${OLD_NS} +short ${TYPE} ${i}
        NEW=$(dig @${NEW_NS} +short ${TYPE} ${i}
        if [ "${NEW}" != "${OLD}" ]; then
            echo ${TYPE} ${i}
            echo OLD: ${OLD}
            echo NEW: ${NEW}


-- enable formated output
\x on
-- show databass
SELECT datname FROM pg_database WHERE datistemplate = false;
-- show tables
SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name;
-- show user
-- drop database
drop database foo;
echo "drop owned by zentras" | psql
-- exit
-- Display tables structure
-- Display tables size
    relname as "table",
    pg_size_pretty(pg_total_relation_size(relid)) as "size",
    pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "ex

Compile lshw

# install required applications
apt-get -y install build-essential
# download and extract
wget -P /tmp
tar xzf /tmp/lshw-B.02.17.tar.gz -C /tmp/
# compile
cd /tmp/lshw-*/
# install (optional)
make install
# test
lshw -version
# executable
# Links

Debian: Install MariaDB

wget -O - | bash -


apt-get install python-software-properties

apt-key adv --recv-keys --keyserver 0xcbcb082a1bb943db
add-apt-repository 'deb wheezy main'
apt-get update

apt-get install -y mariadb-server

Debian Wheezy: Install PHP 5.6

apt-get install -y wget

# install PHP 5.6
echo "deb wheezy-php56 all" > /etc/apt/sources.list.d/
echo "deb-src wheezy-php56 all" >> /etc/apt/sources.list.d/
wget -O - | apt-key add -

apt-get update

apt-get install php5

a2enmod php5
service apache2 restart



export CONTAINER=wordpress

wget -q --no-check-certificate -O - | bash -s -- -f

sudo lxc-attach -n ${CONTAINER} -- sed -i 's|PermitRootLogin without-password|PermitRootLogin yes|' /etc/ssh/sshd_config
sudo lxc-attach -n ${CONTAINER} -- service ssh restart = veth = up = lxcbr0 = eth0 = 00:16:3e:f9:d3:03 = 1500

apt-get install -y apache2 mysql-server php5-mysql wget vi php5
# libapache2-mod-auth-mysql

cd /var/www/html
tar -xzvf latest.tar.gz

# create database
echo "CREATE DATABASE wordpress;" | mysql -u root -proot
echo "CREATE USER wordpressuser@localhost;" | mysql -u root -proot
echo "SET PASSWORD FOR wordpressuser@localhost= PASSWORD('password');" | mysql -u root -proot
echo "GRANT ALL PRIVILEGES ON wordpress.* TO wordpressuser@localhost IDENTIFIED BY 'password';" | mysql -u root -proot
echo "FLUSH PRIVILEGES;" | mysql -u root -proot

cp wordpress/wp-config-sample.php wordpress/wp-config.php

sed -i 's|database_name_here|wordpress|' wordpress/wp-config.php
sed -i 's|username_here|wordpressuser|' wordpress/wp-config.php
sed -i 's|password_here|password|' wordpress/wp-config.php

vi wordpress/wp-config.php

#define('WP_ALLOW_REPAIR', true);
#define('DB_CHARSET', 'utf8');

define('DB_CHARSET', 'latin1');
define('FS_METHOD', 'direct');
define( 'WP_MEMORY_LIMIT', '96M' );
define( 'WP_MAX_MEMORY_LIMIT', '256M' );

chown www-data:www-data /var/www/html/wordpress/ -R

# show errors
# wp-config.php
define('WP_DEBUG', true);

# configuration
UPDATE wp_options
SET option_value = REPLACE(option_value, '', '')
WHERE option_value LIKE ''

#UPDATE wp_options SET `option_value` = '' WHERE `wp_options`.`option_id` = 5;
#UPDATE wp_users SET user_email = '' WHERE ID = 1;

# reset password
UPDATE wp_users SET user_pass = MD5('new_pass') WHERE ID = 1;

# wordpress extract script
# wi.php

# fix URL
UPDATE wp_posts
SET post_content = REPLACE(post_content, '', '')
WHERE post_content LIKE ''

UPDATE wp_posts
SET guid = REPLACE(guid, '', '')
WHERE guid LIKE ''

# set file permissions
system("find . -type d -exec chmod 755 {} \;");
system("find . -type f -exec chmod 644 {} \;");

# Links

DMA (Dragonfly Mail Agent)

# ansible role

# preconfigure
echo "dma dma/relayhost string" | debconf-set-selections
echo "ddm dma/mailname string $(hostname -A)" | debconf-set-selections

# install
apt-get install -y dma

# configure relayhost
echo "user|smarthost:password" >> /etc/dma/auth.conf

# send testmail
echo "This is a test message from ${USER}@${HOSTNAME} at $(date)" | /usr/sbin/sendmail

Configuration files
# /etc/dma/dma.conf
AUTHPATH /etc/dma/auth.conf

Use ecrypted home directory and sshuttle

sudo apt-get install -y ecryptfs-utils

sudo adduser --encrypt-home foo

ecryptfs-mount-private foo

sudo usermod -aG sudo foo

sudo apt-get install -y sshuttle

su - foo
sshuttle --dns -r -x

LXC: Installation under Ubuntu / Debian

wget --no-check-certificate -O - | bash -


# ensure that this script is run by root
if [ $(id -u) -ne 0 ]; then
  sudo $0

# install lxc
apt-get install -y software-properties-common
add-apt-repository -y ppa:ubuntu-lxc/lxd-stable

# fix dist name
for FILE in $(find /etc/apt/sources.list.d/ -name "*lxc*.list"); do
  sed -i 's|jessie|trusty|g;s|utopic|trusty|g' ${FILE}

apt-get update
apt-get install -y lxc lxcfs python-lxc

if [ "$1" == "-b" ]; then
  # install required packages
  apt-get install -y bridge-utils

  # disable auto configuration for eth0
  sed -i 's|auto eth0|#auto eth0|g' /etc/network/interfaces
  sed -i 's|iface eth0 inet dhcp|#iface eth0 inet dhcp|g' /etc/network/interfaces

# create network bridge
cat <<EOF>> /etc/network/interfaces
auto lxcbr0
iface lxcbr0 inet dhcp
  bridge_ports eth0

  # disable auto configuration for network bridge by lxc
  [ -f /etc/default/lxc-net ] && sed -i 's|USE_LXC_BRIDGE="true"|USE_LXC_BRIDGE="false"|g' /etc/default/lxc-net
  # disable network managed by NetworkManager when installed
  [ -f /etc/NetworkManager/NetworkManager.conf ] && sed -i 's|managed=true|managed=false|g' /etc/NetworkManager/NetworkManager.conf

# allow all user to list the containers
[ -d /etc/sudoers.d/ ] && echo "ALL ALL=NOPASSWD: /usr/bin/lxc-ls" >> /etc/sudoers.d/lxc

# install under Debian Jessie
apt-get install bridge-utils
wget -q --no-check-certificate -O - | bash -s -- -b
#wget -P /tmp/
#dpkg -x /tmp/lxc_1.0.7-0ubuntu0.2_amd64.deb /tmp/
#cp -a /tmp/etc/* /etc/

# Check kernel configuration

Syndicate content