wiki.volkszaehler.org

keeping to this howto do this:

• download the prebuilt Kamikaze image in vmware disk image format:

(Remark: in case you should wonder why we're using the latest RC of 10.03.1 - it's because that is the first release that sports the mysql-server package)

• download the g'zipped prebuilt 1 GB spare disk image in vmware disk image format and gunzip it or roll your own:
  • create a new file system for the db in an appropiate size - you might want to start with 1 GB:
    • dd if=/dev/zero of=disk.img bs=100M count=10
  • create an ext2 file system in that image
    • mkfs.ext2 sparedisk-1G.img
  • convert the image using qemu-img from the package „qemu“ (Ubuntu/Debian):
    • qemu-img convert -f raw sparedisk-1G.img -O vmdk sparedisk-1G.vmdk
• get the VMware configuration file
• open the vmx file with VMWare Player
• boot your new vm
• edit /etc/config/network:

config 'interface' 'lan'
  option 'ifname' 'eth0'
  option 'proto' 'dhcp'

• restart your network using the new settings:
  • /etc/init.d/network restart
• set a new root password:
  • passwd
• update package list:
  • opkg update
• mount overlay file system:
  • mount /dev/sdb1 /overlay
• move dirs with high disk space requirements to overlay file system:
  • mv /mnt/data/mysql /overlay
  • ln -s /overlay/mysql/ /mnt/data/
  • mv /usr/libexec /overlay
  • ln -s /overlay/libexec/ /usr/
• retrieve current package list:
  • opkg update
• install required packages:
  • opkg install mysql-server php5-mod-mysql lighttpd coreutils-su php5-mod-pdo-mysql php5-mod-json git bash php5-cgi php5-cli libsqlite3 lighttpd-mod-fastcgi php5-mod-session lighttpd-mod-cgi
    • remarks: bash for install script (temporary) (php → php-cli)

mkdir -p /mnt/data/mysql ln -s /usr/bin/hostname /bin/ mysql_install_db –force (weil: /usr/bin/resolveip ist nicht da)

• clone volkszaehler.org:
  • cd /overlay
  • git clone git:github.com/volkszaehler/volkszaehler.org.git * run installer: * bash /overlay/volkszaehler.org/share/tools/install.sh * set doctrine path to „/overlay/lib/doctrine“ * set volkszaehler path to „/overlay/www/vz“ * opkg remove luci-core luci-uci luci-theme-openwrt luci-web luci-sgi-cgi luci-http luci-app-firewall luci-admin-core luci-sys luci-uvl luci-lmo luci-app-initmgr luci-ipkg luci-cbi luci-admin-mini luci-admin-full luci-ipkg luci-admin-core luci-web luci-cbi luci-uvl luci-i18n-english luci-lmo luci-uci uhttpd <code> „To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system“ cd /usr ; /usr/bin/mysqld & (ohne _safe, weil nicht da!) /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h backfire password 'new-password' (benchmark: cd sql-bench ; perl run-all-tests) /etc/lighttpd/lighttpd.conf: server.document-root = „/overlay/www/“ fastcgi.server = ( „.php“ ⇒ ( „localhost“ ⇒ ( „socket“ ⇒ „/tmp/php-fastcgi.socket“, „bin-path“ ⇒ „/usr/bin/php-fcgi“ ) ) ) server.modules = ( „mod_fastcgi“, ) cgi.assign = ( „.php“ ⇒ „/usr/bin/php-cgi“ ) </code>