Create new MySQL DB

# BASH
echo "create database ${DB_NAME}" | mysql --user=${DB_USER} --password=${DB_PASS}

# SQL
mysql -u root -p
create database db_name;
create user db_user identified by 'user_pass';
grant all on db_name.* to 'db_user'@'%';
commit;
quit;

Tomcat configuration

<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.tomcat.sh";
echo "wget $URL -O - | bash -";
echo "

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
?>

# start
export JAVA_HOME=/usr/lib/jvm/jdk1.6.0
export JAVA_OPTS="$JAVA_OPTS -Xmx256m"
/usr/local/apache-tomcat-5.5.20/bin/startup.sh

# deploy
/opt/SDK2/bin/asadmin deploy /tmp/Intranet.war

# change defau

Send mail from console

# install
sudo apt-get install -y mailx

# configure postfix
postconf -e 'smtp_generic_maps = hash:/etc/postfix/generic'
cat <> /etc/postfix/generic
root@ubuntu.example.local info@example.com
EOF
service postfix restart
postmap /etc/postfix/generic

# configure smtp
cat < ~/.mailrc
set from="YOU@YOUR_MAIL.COM"
set smtp="YOUR_SMTP_SERVER"
set smtp-auth-user="SMTP_USER"
set smtp-auth-password="SMTP_PASS"
EOF

# test
echo "This is a test message from ${USER}@${HOSTNAME} at $(date)" | mail -s "Test email" YOU@YOUR_MAIL.COM

# v2
sudo apt-get install nullmailer

lts.conf parameter

XSERVER=nsc
LDM_USERNAME=root
LDM_PASSWORD=toor
PRINTER_0_TYPE=U
PRINTER_0_DEVICE=/dev/usb/lp0
SCREEN_02=shell
SCREEN_07=ldm
LDM_REMOTECMD="/usr/sbin/ethtool -s eth0 msglvl 0"
X_COLOR_DEPTH=16
X_VIDEORAM=4096
X_MODE_0=1024x768
X_HORZSYNC=30-70
X_VERTREFRESH=50-150
XKBLAYOUT=de
LDM_USERNAME=service
LDM_PASSWORD=terceS
SCREEN_07=startx-custom
PRINTER_0_TYPE=P
PRINTER_0_DEVICE=/dev/lp0
PRINTER_1_TYPE=U
PRINTER_1_DEVICE=/dev/usb/lp1

[LG]
X_HORZSYNC = "40-83"
X_VERTREFRESH = "55-60"
X_MODE_0 = 1280x1024

[00:33:44:55:66:77