dotcloud + Drupal 7.0

*use Ubuntu 11.04
sudo apt-get install python-setuptools
sudo easy_install dotcloud

* create namespace (plz change all of "helloworld" for your application)
dotcloud create helloworld

* create services
dotcloud deploy -t php helloworld.www
dotcloud deploy -t postgresql helloworld.pgsql

********** you need to wait for your server available ****************

* download Drupal 7.0 from http://drupal.org/project/drupal
tar zxf drupal-7.0.tar.gz
cd drupal-7.0
git init
git add .
git commit -am 'drupal 7.0'

* setup postgresql at first
dotcloud ssh helloworld.pgsql
# createuser --pwprompt --encrypted --no-createrole --no-createdb drupal
# createdb --encoding=UTF8 --owner=drupal drupal

* tune some settings on your local drupal-7.0
** 000-nginx.conf
location ~ \.php$ {
fastcgi_index index.php;
}

** fastcgi.conf
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
fastcgi_buffers 256 4k;
fastcgi_intercept_errors on;
## allow 4 hrs - pass timeout responsibility to upstrea
fastcgi_read_timeout 14400;
fastcgi_index index.php;
fastcgi_param PATH_INFO $fastcgi_script_name;

** php.ini
; nginx fix
cgi.fix_pathinfo = 0

** postinstall
#!/bin/sh
[ -d ~/drupal-files ] || mkdir -p ~/drupal-files
ln -sf ~/drupal-files ~/current/sites/default/file

** copy sites/default/settings.php.sample to sites/default/settings.php and modify it with proper settings (not sure if you need to do this)
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'drupal',
'username' => 'drupal',
'password' => 'drupal',
'host' => 'pgsql.helloworld.dotcloud.com',
'port' => '4015',
'driver' => 'pgsql',
'prefix' => '',
),
),
);

* and then push your local drupal-7.0 to server
dotcloud push helloworld.www drupal-7.0

* and then connects http://www.helloworld.dotcloud.com/install.php
re-try it and make sure you see the progress bar during "creating database"

Good Luck...

host android git mirror site with gitosis

* use wildcard support gitosis
https://github.com/mzupan/gitosis

* gitosis-post-update problem
http://blog.binfalse.de/2010/10/lost-my-gitosis-post-update/

* get android in repositories folder android/
repo init -u git://git.android-x86.org/manifest.git --mirror
repo sync
(have a cup...)

* modify writable field with wildcard to restricted users
* get manifest at first
git clone git@<serverip>:android/manifest

* change git server upstream to your server by edit default.xml
fetch=git@"<serverip>:/android/"
* and then push back to server
git commit -am 'update local server'
git push

* create your local copy
repo init -u git@<serverip>:android/manifest.git
repo sync


reference:
http://gregmeiste.com/post/3842942731/mirror-android-repositories-on-a-local-server

Debian on Nextvod

debian-rootfs-20101014
http://goo.gl/w1PD1

sysv-rc: /usr/sbin/update-rc.d
dpkg: /usr/sbin/install-info
dpkg: /usr/bin/dpkg
dpkg: /usr/bin/dpkg-split
dpkg: /usr/bin/dpkg-deb
dpkg: /usr/bin/dpkg-query
debianutils: /bin/run-parts

mkdir -p /var/lib/dpkg
mkdir -p /var/lib/dpkg/updates/
mkdir -p /var/lib/dpkg/info/
touch /var/lib/dpkg/available
touch /var/lib/dpkg/status

/etc/apt/trustdb.gpg
/etc/apt/trusted.gpg

http://ftp.debian-ports.org/debian/pool-sh4/main/a/apt/apt-utils_0.8.12_sh4.deb
http://ftp.debian-ports.org/debian/pool-sh4/main/a/apt/apt_0.8.12_sh4.deb
http://ftp.debian-ports.org/debian/pool-sh4/main/a/apt/libapt-pkg-dev_0.8.12_sh4.deb
http://ftp.debian-ports.org/debian/pool-sh4/main/b/bzip2/libbz2-1.0_1.0.5-6_sh4.deb
http://ftp.debian-ports.org/debian/pool-sh4/main/r/readline6/libreadline6_6.1-3_sh4.deb
http://ftp.debian-ports.org/debian/pool-sh4/main/g/gnupg/gpgv_1.4.11-3_sh4.deb
http://ftp.debian-ports.org/debian/pool-sh4/main/g/gnupg/gnupg_1.4.11-3_sh4.deb
http://ftp.debian-ports.org/debian/pool-sh4/main/libu/libusb/libusb-0.1-4_0.1.12-17_sh4.deb

/usr/lib/libstdc++.so.6.0.12
/usr/lib/libz.so.1.2.3.3

apt-get -f install libgcc1 libc-bin
apt-get -f install libacl1 libattr1
apt-get -f install coreutils
apt-get -f install libc6 libstdc++6 zlib1g debian-archive-keyring libdb5.1 gcc-4.5-base readline-cmmon libncurses5 dpkg install-info xz-utils libselinux1 liblzma2

STLinux (for nextvod usage)

* Install on Ubuntu
http://www.stlinux.com/faq?q=node/361

* STAPI
http://www.hwport.com/wiki.php/STLinuxInstall

* Cross-compile for transmission
http://code.google.com/p/wydevices/wiki/Howto_install_STLinux23
http://code.google.com/p/wydevices/wiki/Howto_crosscompile_transmission2_for_wydevices

* rtorrent
http://libtorrent.rakshasa.no/wiki
http://libtorrent.rakshasa.no/browser/trunk/rtorrent/doc/rtorrent.rc?rev=latest

** STLinux should have
stlinux23-sh4-curl-dev
stlinux23-sh4-openssl
stlinux23-sh4-zlib

** hacks if you cannot find libs
/usb/lib/libstdc++.la
/usb/lib/libstdc++.so
/usb/lib/libcurl.so

** sigc++
./configure --host="sh4-linux" --prefix="/opt/STM/STLinux-2.3/devkit/sh4/target/" --libdir="/opt/STM/STLinux-2.3/devkit/sh4/target/usr/lib" --disable-documentation
make
make install

** libtorrent
./configure --host=sh4-linux --prefix=/opt/STM/STLinux-2.3/devkit/sh4/target/ --enable-aligned --libdir="/opt/STM/STLinux-2.3/devkit/sh4/target/usr/lib"

** xmlrpc-c
*** fix lib/expat/gennmtab/Makefile at first. use host's gcc, instead of sh4-linux-gcc
./configure --host=sh4-linux --prefix=/opt/STM/STLinux-2.3/devkit/sh4/target/ --libdir="/opt/STM/STLinux-2.3/devkit/sh4/target/usr/lib"

** rtorrent
./configure --host=sh4-linux --prefix=/opt/STM/STLinux-2.3/devkit/sh4/target/ --libdir="/opt/STM/STLinux-2.3/devkit/sh4/target/usr/lib" --with-xmlrpc-c=/opt/STM/STLinux-2.3/devkit/sh4/target/bin/xmlrpc-c-config

** lighttpd
./configure --host=sh4-linux --prefix=/opt/STM/STLinux-2.3/devkit/sh4/target/ --libdir="/opt/STM/STLinux-2.3/devkit/sh4/target/usr/lib" --with-openssl

** pack rpms by checkinstall
http://checkinstall.izto.org/
sudo checkinstall -D --install=no --pkgarch=sh4 --maintainer=Harry --nodoc --strip=no

* Nextvod
https://www.nextvod.com.tw/tw/yiwangle/opensource.jsp
http://stevennick.pixnet.net/blog
http://snowwolf725.blogspot.com

ubuntu forward

sudo iptables -A FORWARD -o usb0 -i eth0 -s 10.0.0.0/24 -m conntrack --ctstate NEW -j ACCEPT
sudo iptables -A FORWARD -m conntrack --ctstate ESTABLISHED,RELATED -j ACCEPT
sudo iptables -A POSTROUTING -t nat -j MASQUERADE
sudo iptables-save | sudo tee /etc/iptables.sav


add "iptables-restore < /etc/iptables.sav" in /etc/rc.local

git

Enhanced shell prompt
One specificity of git over something lke subversion is that all your branch stay in the same directory.
Thanks to the git completion extensions available in git-core, you can enhance your shell prompt to display the name of the branch you are working on. For example, if you set:

PS1='\u@\h:\w$(__git_ps1 " (%s)") \$ '

Virtualbox

VBoxManage.exe modifyvm "Ubuntu 10.04 for WRL4" --natpf1 "guestssh,tcp,,22,,22


VBoxManage.exe startvm "Ubuntu 10.04 for WRL4" --type headless