apt-get install mysql-admin

# create tunel
ssh root@192.168.1.88 -L 3306:localhost:3306

# connect
mysql-admin -u magento -p magento -h 127.0.0.1

# Links
http://gss-konstanz.de/8-kerne-und-nen-typ/2007/10/26/windows-als-gastsystem-in-debian-xen/

# install
apt-get install dnsmasq

# configure
echo 1 > /proc/sys/net/ipv4/ip_forward
iptables -P FORWARD ACCEPT
iptables -t nat -A POSTROUTING -o ! lo -j MASQUERADE

# restart
/etc/init.d/dnsmasq start

# continuation on github
https://github.com/magja/magja

Project Magja on Google Code:
http://code.google.com/p/magja/

Magento Connector for Java, a free wrapper / library to manage Magento informations from a Java application. The latest version (source code) can be downloaded from
https://github.com/panticz/magja
http://code.google.com/p/magja/

If someone is interested in co-development, please contact my over my homepage,
http://www.panticz.de/contact

How to start:
1.

sudo su

DEVICE=/dev/sdb
VOLUME=ctsrv4stick

# mount usb
umount ${DEVICE}1

# create filesystem on usb pen
mkfs.vfat -n ${VOLUME} ${DEVICE}1

# mount usb
mount ${DEVICE}1 /mnt/

# install syslinux and make stick bootable
install-mbr ${DEVICE}
syslinux -f ${DEVICE}1

# unzip support files from ct dvd
unzip /media/ctsw0905/support/stickins.zip -d /mnt/

# create exclude list
cat < /tmp/exclude.lst
/media/ctsw0905/bilder
/media/ctsw0905/html
/media/ctsw0905/scrshots
/media/ctsw0905/software
/media/ctsw0905/tools
/media/ctsw0905/video2brain
EOF

# create iso fro

sudo su

mkdir /boot/iso
wget http://releases.ubuntu.com/18.04/ubuntu-18.04.2-desktop-amd64.iso -O /boot/iso/buntu-18.04.2-desktop-amd64.iso

cat <> /boot/grub/grub.cfg
menuentry "Ubuntu-18.04.2 CLI" {
loopback loop /boot/iso/ubuntu-18.04.2-desktop-amd64.iso
linux (loop)/casper/vmlinuz boot=casper iso-scan/filename=/boot/iso/ubuntu-18.04.2-desktop-amd64.iso toram init 2 --
initrd (loop)/casper/initrd
}

menuentry "Ubuntu-18.04.2 GUI" {
loopback loop /boot/iso/ubuntu-18.04.2-desktop-amd64.iso
linux (loop)/casper/vmlinuz boot=casper iso-scan/filename=/boot/

#!/bin/bash

# check parameter
if [ $# -lt 1 ]; then
echo "USAGE: $0 LIST_NO"
exit
else
LISTID=$1
fi

function create_pdfmark() {
cat < /tmp/pdfmarks
[ /Author (panticz.de)
/Creator (panticz.de)
/Producer (panticz.de)
/Keywords ($1, panticz.de)
/Title (panticz.de ${LISTID} - $1)
/Subject (panticz.de ${LISTID})
/DOCINFO pdfmark
EOF
}

for DIR in *
do
if [ -d "${DIR}" ]; then
# convert to lowercase
OUT=$(echo ${DIR} | tr "[:upper:]" "[:lower:]")

# filter
OUT="${OUT// /_}" # replace " " with "_"
OUT="${OUT//ä/ae}" # replace "ä" with "ae"

public String getSnomSetting(String phoneIp, String field) {
String value = "";

try {
URL url = new URL("http://" + phoneIp + "/settings.htm");
BufferedReader in = new BufferedReader(new InputStreamReader(url.openStream()));

String inputLine;
while ((inputLine = in.readLine()) != null) {
if (inputLine.indexOf(field) == 0) {
value = inputLine.substring(inputLine.indexOf(":") + 1).trim();
}
}

in.close();
} catch (Exception e) {
System.out.println("[!] getSnomSetting:" +

ADMIN BACKEND:
Sales > Tax > Product Tax Classes
rename classes:
default => Umsatzsteuerpfichtige Güter 19%
Shipping => Versand
Taxable Goods => Umsatzsteuerpfichtige Güter 7%
add classes:
Umsatzsteuerfreie Güter

# create tax class
Sales > Tax > Customer Classes
rename:
Retail Customer => inkl.

# view mailqueue
mailq

# view email count in mailqueue
mailq | egrep '^--'

# delete single mail from queue
postsuper -d Queue_ID

# delete all mailqueues
postsuper -d ALL

# send waiting messages
postfix flush

# delete duplicate mail
mailq | awk 'BEGIN { RS = "" } / foo\.bar@example\.com$/ { print $1 }' | tail -1 | postsuper -d -

# statistic
apt-get install pflogsumm
pflogsumm --detail 0 /var/log/mail.log

# view spam
grep "policyd-weight.*action=" /var/log/mail.log | grep -v PREPEND | grep mike

# find mails bigger then 50mb
find /home/ -type f -size +50000k -exe