Magento: Replace broken Webservicex.net currency exchange with Yahoo finance

# go to your Magento installation
cd /var/www/

# create Yahoofinance.php
mkdir -p ./app/code/local/JT/Directory/Model/Currency/Import/
wget http://www.panticz.de/sites/default/files/magento/CurrencyExchange/Yahoofinance.php -O ./app/code/local/JT/Directory/Model/Currency/Import/Yahoofinance.php

# update configuration
# (TODO): create module configuration xml
# add bevore end of the global node in ./app/etc/local.xml

--- /var/www/app/etc/local.xml.org 2010-07-23 13:07:49.000000000 +0200
+++ /var/www/app/etc/local.xml 2013-04-13 10:01:51.000000000 +0200
@@ -49,6 +49,16 @@

Simple Java currency converter

package Helper;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.net.URL;

public class ExchangeRate {

private double getRate(String from, String to) {
try {
URL url = new URL("http://quote.yahoo.com/d/quotes.csv?f=l1&s=" + from + to + "=X");
BufferedReader reader = new BufferedReader(new InputStreamReader(url.openStream()));
String line = reader.readLine();
if (line.length() > 0) {
return Double.parseDouble(line);
}
read

Install Adobe AIR under Linux

sudo apt-get install ia32-libs

if [ "$(uname -m)" == "x86_64" ]; then
# 64 bit
URL=http://update.devolo.com/linux/apt/pool/main/a/adobeair/adobeair_2.6.0.19170_amd64.deb
else
# 32 bit
URL=http://update.devolo.com/linux/apt/pool/main/a/adobeair/adobeair_2.6.0.19170_i386.deb
fi
wget ${URL} -P /tmp
sudo dpkg -i /tmp/adobeair_*.deb

# install a AIR app
sudo /usr/bin/Adobe\ AIR\ Application\ Installer /PATH/TO/AIR/FILE.air

# Links
http://askubuntu.com/questions/87447/how-can-i-install-adobe-air

Compile smartmontools

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

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

";
?>

check smartctl version
smartctl -V

Links
http://sourceforge.net/projects/smartmontools/files/smartmontools/ - sorce code download
http://sourceforge.net/apps/trac/smartmontools/wiki/Download#Installprecompiledpackage

htaccess

# Redirect http to https
RewriteEngine On

RewriteCond %{HTTP_HOST} !^www\.panticz\.de [NC]
RewriteCond %{HTTP_HOST} !^$
RewriteRule ^(.*) http://www.panticz.de/$1 [L,R=301]

RewriteCond %{SERVER_PORT} !^443$
RewriteRule (.*) https://%{HTTP_HOST}/$1 [L]

RewriteCond %{HTTP_HOST} ^(www.)?YourDomain.com$
RewriteRule ^(/)?$ page [L]

# Allow directory listing
# enable "AllowOverride All" in VHost configuration first
Options +Indexes

# Allow show bash files

Allow from all
AddType text/plain .sh .bash

# Enable PHP5
AddType

Burning iPXE into Intel network adapter

# install required packages
apt-get install -y build-essential liblzma-dev git linux-headers-$(uname -r)

# list controller
#lspci -nn | grep Ethernet

# get device id
lspci -nn | grep Ethernet | cut -d"[" -f3 | cut -d"]" -f1 | tr -d ":"

# v1 (intel 100 mbit, WORKING)

# build ipxe rom
git clone git://git.ipxe.org/ipxe.git /tmp/ipxe

# preconfigure boot server (local, www.panticz.de)
cat < /tmp/ipxe/src/boot.ipxe
#!ipxe

dhcp && chain http://\${next-server}/\${mac} || chain http://preseed.panticz.de/\${mac}
EOF

# compile
cd /tmp/ipxe/src
make bin/80861229.rom EMBE

Install MySql Workbench under Ubuntu

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

";

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $URL);
$result = curl_exec($ch);
curl_close($ch);
htmlspecialchars($result);

echo "

";
?>

# test
. /etc/os-release
cat < /etc/apt/sources.list.d/mysql.list
deb http://repo.mysql.com/apt/${ID}/ $(lsb_release -cs) mysql-apt-config
deb http://repo.mysql.com/apt/${ID}/ $(lsb_release -cs) workbench-6.3
EOF

# fix utopic ?
sed -i 's|utopic|trusty|g' /etc/apt/sources.list.d/mysql.list

apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 5072E1F5

sudo apt-get update

debconf-set-selections <<\EOF
mysql-apt-config mysql-apt-config/select-workbench select workbench-6.2
EOF

sudo apt-get install -y mysql-apt-config

# sudo apt-get install libmysqlclient18
sudo apt-get install -y mysql-workbench-community

# test 2
# dpkg --force-all
# sudo apt-get install libaio1
# sudo apt-get install libcairo2

# cat /etc/apt/sources.list.d/mysql.list
deb http://repo.mysql.com/apt/ubuntu/ trusty mysql-apt-config
deb http://repo.mysql.com/apt/ubuntu/ trusty mysql-5.6
deb http://repo.mysql.com/apt/ubuntu/ trusty workbench-6.2
# deb http://repo.mysql.com/apt/ubuntu/ trusty connector-python-2.0
# deb http://repo.mysql.com/apt/ubuntu/ trusty mysql-utilities-1.5

apt-get update
sudo apt-get install -y mysql-workbench-community

# deb-src http://repo.mysql.com/apt/ubuntu/ trusty mysql-5.6

# ssh tunnl error
http://bugs.mysql.com/bug.php?id=75764

# admin mysql client
#audo apt-get -y install mysql-admin
#audo apt-get -y install mysql-query-browser

Links
http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/
http://dev.mysql.com/downloads/workbench
http://wiki.ubuntuusers.de/MySQL/Werkzeuge

OpenWrt connect to UMTS with Huawei E620 3G USB Modem

# install packages
opkg update
opkg install usbutils
opkg install kmod-usb-serial kmod-usb2 kmod-usb-uhci kmod-usb-ohci
opkg install ppp kmod-ppp
opkg install huaweiaktbbo
opkg install comgt
opkg install usb-modeswitch usb-modeswitch-data

# OPTIONAL, webgui support for 3g
opkg install luci-proto-3g

# list USB devices
lsusb

# OUTPUT:
Bus 001 Device 002: ID 12d1:1520 Huawei Technologies Co., Ltd.

Subscribe to