-- delete all tax definitions
DELETE FROM tax_calculation_rule;
DELETE FROM tax_class;
DELETE FROM tax_calculation_rate;
DELETE FROM tax_calculation;
-- create tax_class
INSERT INTO tax_class(class_name, class_type) VALUES
('Umsatzsteuerpfichtige Güter 19%','PRODUCT'),
('Umsatzsteuerpfichtige Güter 7%','PRODUCT'),
('Umsatzsteuerfreie Güter','PRODUCT'),
('inkl.
# preconfigure nullmailer
debconf-set-selections <<\EOF
nullmailer shared/mailname string $(hostname)
nullmailer nullmailer/relayhost string YOUR_SMTP_HOST smtp --auth-login --user=YOUR_SMTP_USER --pass=YOUR_SMTP_PASS
EOF
# install nullmailer
apt-get install -y nullmailer
# configure mailname
echo "YOUR_DOMAIN" > /etc/mailname
# send test email
echo "This is a test message from ${USER}@${HOSTNAME} at $(date)" | sendmail -f SENDER@YOUR_MAIL.COM RECIPIENT@YOUR_MAIL.COM
# change from / sender address
NULLMAILER_USER=info
# broken?
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class MysqlTest {
private final static String dbUser = "dbo_java";
private final static String dbPass = "java_test";
private final static String dbHost = "192.168.1.111";
private final static String dbName = "java";
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://" + dbHos
# ubuntu package
sudo apt-get install -y libmysql-java
path: /usr/share/java/mysql-connector-java.jar
# download
wget http://ftp.gwdg.de/pub/misc/mysql/Downloads/Connector-J/mysql-connector-java-5.1.12.tar.gz -P /tmp
# extract
tar xzf /tmp/mysql-connector-java-5.1.12.tar.gz -C /tmp/
# copy to your classpath
cp /tmp/mysql-connector-java-5.1.12/mysql-connector-java-5.1.12-bin.jar ~/NetBeansProjects/classpath/
# Netbeans
add Library / Jar File
select
~/NetBeansProjects/classpath/mysql-connector-java-5.1.12-bin.jar
# create tatabase
create database java;
Play BlueRay discs with Linux
# new 2
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install build-essential libc6-dev libssl-dev libgl1-mesa-dev libqt4-dev
cd /tmp
wget http://www.makemkv.com/download/makemkv_v1.6.3_bin.tar.gz
wget http://www.makemkv.com/download/makemkv_v1.6.3_oss.tar.gz
tar -xvf makemkv_v1.6.3_bin.tar.gz
tar -xvf makemkv_v1.6.3_oss.tar.gz
cd /tmp
cd makemkv_v1.6.3_oss
sudo make -f makefile.linux
sudo make -f makefile.linux install
cd /tmp
cd makemkv_v1.6.3_bin
sudo make -f makefile.linux
#!/bin/bash
DB_HOST=localhost
DB_NAME=magento
DB_USER=magento
DB_PASS=magento
mysqldump --host=${DB_HOST} --password=${DB_PASS} --user=${DB_USER} ${DB_NAME} > ${DB_NAME}.$(date "+%Y-%m-%d_%H:%M:%S").sql
Download PPD files for kyocera printer
wget http://cdn.kyostatics.net/dlc/de/driver/all/linux_ppd_s_ksl_8.-downloadcenteritem-Single-File.downloadcenteritem.tmp/Linux_PPDs_KSL8_4.zip -P /tmp/
unzip /tmp/Linux_PPDs_KSL8_4.zip -d /tmp
# create new printer
lpadmin -p Kyocera_FS1010 -v socket://192.168.1.11:9100 -E -P "/tmp/PPD's_KSL_8.4/German/Kyocera_Mita_FS-1010_de.ppd"
#-o PageSize=A4
system-config-printer
install
#wget http://dl.dropbox.com/u/4170695/www/Kyocera-FS-1010.ppd -P /tmp
# install gnome-do
sudo add-apt-repository ppa:do-core/ppa
sudo apt-get update
sudo apt-get install gnome-do
# install zeitgeist
sudo add-apt-repository ppa:zeitgeist/ppa
sudo apt-get update
sudo aptitude install zeitgeist
# install gnome-shell
sudo add-apt-repository ppa:ricotz/testing
sudo apt-get install gnome-shell
gnome-shell --replace
# Links
http://wiki.go-docky.com/index.php?title=List_of_helpers
https://addons.mozilla.org/de/thunderbird/addon/72199 - Docky Unread Count (Thunderbird extension)
sudo apt-get install libidn11-dev libssl-dev
wget http://skipfish.googlecode.com/files/skipfish-1.29b.tgz -P /tmp
tar xzf /tmp/skipfish-1.29b.tgz -C /tmp
cd /tmp/skipfish
make
cp dictionaries/default.wl /tmp/skipfish/skipfish.wl
/tmp/skipfish/skipfish -o /tmp/x http://www.panticz.de
echo 'APT::Cache-Limit "50331648";' >> /etc/apt/apt.conf
# add debian sid repository
cat < /etc/apt/sources.list.d/sid.list
deb http://ftp.de.debian.org/debian sid main
EOF
sudo apt-get update -qq
apt-get install -y --force-yes syslinux
rm /etc/apt/sources.list.d/sid.list
sudo apt-get update -qq
# on i386
wget http://ftp.de.debian.org/debian/pool/main/s/syslinux/syslinux-common_4.01+dfsg-1_all.deb -P /tmp
# on amd64
wget http://ftp.de.debian.org/debian/pool/main/s/syslinux/syslinux_3.86+dfsg-1_amd64.deb -P /tmp