Create UEFI disc

# create disc image
mkfs.msdos -C /tmp/uefi.iso 2880
sudo mount /tmp/uefi.iso /mnt
sudo cp /tmp/your_uefi_files/* /mnt/
sudo umount /mnt
 
# boot to UEFI shell
press F11 on boot
 
# go to UEFI filesystem
fs0:
 
# Links
https://wiki.archlinux.org/index.php/Unified_Extensible_Firmware_Interface#Important_UEFI_Shell_Commands

Debian: Install Cacti

# create container
export CONTAINER=cacti
wget -q --no-check-certificate https://raw.githubusercontent.com/panticz/lxc/master/create.jessie.sh -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

# fix dns
echo nameserver 8.8.8.8 > /var/lib/lxc/${CONTAINER}/rootfs/etc/resolv.conf

# install applications
lxc-attach -n ${CONTAINER} --
LANG=en_US.UTF-8

apt-get update

# server
debconf-set-selections <<\EOF

Install LXD

wget https://raw.githubusercontent.com/panticz/installit/master/install.lxd.sh -O - | bash -

#!/bin/bash

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

# use Ubunut Trusty repository on Utopic
sed -i 's|utopic|trusty|g' /etc/apt/sources.list.d/ubuntu-lxc-ubuntu-lxd-stable-utopic.list

sudo apt-get update
sudo apt-get install -y lxd lxc lxcfs

Links
https://linuxcontainers.org/lxd/getting-started-cli/

Compare zones between two Nameserver

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

PostgreSQL

-- enable formated output
\x on
 
-- show tables
\dt
 
-- exit
\q

Compile lshw

# install required applications
apt-get -y install build-essential
 
# download and extract
wget http://www.ezix.org/software/files/lshw-B.02.17.tar.gz -P /tmp
tar xzf /tmp/lshw-B.02.17.tar.gz -C /tmp/
 
# compile
cd /tmp/lshw-*/
make
 
# install (optional)
make install
 
# test
lshw -version
 
# executable
/tmp/lshw-*/src/lshw
 
# Links
http://www.ezix.org/project/wiki/HardwareLiSter

Debian: Install MariaDB

wget https://raw.githubusercontent.com/panticz/installit/master/install.mariadb.sh -O - | bash -

#!/bin/bash

apt-get install python-software-properties

apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
add-apt-repository 'deb http://mirror.netcologne.de/mariadb/repo/10.1/debian 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 http://packages.dotdeb.org wheezy-php56 all" > /etc/apt/sources.list.d/dotdeb.org.list
echo "deb-src http://packages.dotdeb.org wheezy-php56 all" >> /etc/apt/sources.list.d/dotdeb.org.list
wget http://www.dotdeb.org/dotdeb.gpg -O - | apt-key add -

apt-get update

apt-get install php5

a2enmod php5
service apache2 restart

Links:
http://www.dotdeb.org/instructions/

WordPress

export CONTAINER=wordpress

wget -q --no-check-certificate https://raw.githubusercontent.com/panticz/lxc/master/create.jessie.sh -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

lxc.network.type = veth
lxc.network.flags = up
lxc.network.link = lxcbr0
lxc.network.name = eth0
lxc.network.hwaddr = 00:16:3e:f9:d3:03
lxc.network.mtu = 1500

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

cd /var/www/html
wget http://wordpress.org/latest.tar.gz
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

http://10.0.3.173/wordpress/wp-admin/install.php

http://10.0.3.173/wordpress/wp-admin/plugin-install.php
Jigoshop

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

# configuration
UPDATE wp_options
SET option_value = REPLACE(option_value, 'new.example.com', 'www.example.com')
WHERE option_value LIKE '%new.example.com%'

#UPDATE wp_options SET `option_value` = 'you@example.com' WHERE `wp_options`.`option_id` = 5;
#UPDATE wp_users SET user_email = 'you@example.com' 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, 'new.example.com', 'www.example.com')
WHERE post_content LIKE '%new.example.com%'

UPDATE wp_posts
SET guid = REPLACE(guid, 'new.example.com', 'www.example.com')
WHERE guid LIKE '%new.example.com%'

# Links
https://wiki.debian.org/WordPress
https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-on-ubuntu-12-04
https://www.digitalocean.com/community/tutorials/initial-server-setup-with-ubuntu-12-04
https://wiki.debian.org/WordPress
http://wpde.org/e-commerce/
http://steellounge.de/
https://www.jigoshop.com/getting-started-guide/

DMA (Dragonfly Mail Agent)

# ansible role
https://github.com/panticz/ansible/tree/master/roles/dma

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

# install
apt-get install -y dma

# configure relayhost
echo "foo|mail.example.com:bar" >> /etc/dma/auth.conf

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

Configuration files
# /etc/dma/dma.conf
AUTHPATH /etc/dma/auth.conf
SMARTHOST smtp.strato.de

Syndicate content