===== Volkszaehler in einer VMware mit OpenWRT installieren =====

<note warning>Diese Anleitung ist lange nicht mehr aktualisiert worden und weicht in wichtigen Punkten von der aktuellen Version ab.\\
This description is out of date, it differs in important steps from the actual version.</note>

keeping to [[http://wiki.openwrt.org/oldwiki/RunningKamikazeOnVMwareHowTo|this howto]] do this:

  * download [[http://downloads.openwrt.org/backfire/10.03.1-rc4/x86/openwrt-x86-generic-combined-ext2.vmdk|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 [[http://volkszaehler.org/sparedisk-1G.vmdk.gz|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:
<code>dd if=/dev/zero of=disk.img bs=1024M count=10</code>
    * create an ext2 file system in that image
<code>mkfs.ext2 sparedisk-1G.img</code>
    * convert the image using qemu-img from the package „qemu“ (Ubuntu/Debian):
<code>qemu-img convert -f raw sparedisk-1G.img -O vmdk sparedisk-1G.vmdk</code>
  * get the [[http://volkszaehler.org/backfire-10.03.1-openwrt-x86-2.6-ext2.vmx|VMware configuration file]]
  * open the vmx file with VMWare Player
  * boot your new vm
  * edit /etc/config/network:
<code>
config 'interface' 'lan'
  option 'ifname' 'eth0'
  option 'proto' 'dhcp'
</code>
  * restart your network using the new settings:
<code>/etc/init.d/network restart</code>
  * set a new root password: 
<code>passwd</code>
  * retrieve current package list:
<code>opkg update</code>
  * mount overlay file system:
<code>mount /dev/sdb1 /overlay</code>
  * move dirs with high disk space requirements to overlay file system:
<code>
mkdir /overlay/mysql
mkdir /mnt/data
ln -s /overlay/mysql/ /mnt/data/
mkdir /overlay/libexec
ln -s /overlay/libexec/ /usr/
</code>
  * install required packages:
<code>opkg install mysql-server php5-mod-mysql lighttpd coreutils-su php5-mod-pdo-mysql php5-mod-json php5-mod-sockets git bash php5-cgi libsqlite3 lighttpd-mod-fastcgi php5-mod-session lighttpd-mod-cgi php5-mod-ctype</code>
      * remarks: bash for install script (temporary) (php -> php-cli)
<code>
mkdir -p /mnt/data/mysql
ln -s /usr/bin/hostname /bin/
mysql_install_db --force (weil: /usr/bin/resolveip ist nicht da)
</code>
     * clone volkszaehler.org:
<code>
cd /overlay
git clone git:\/\/github.com/volkszaehler/volkszaehler.org.git
cd /overlay/volkszaehler.org/volkszaehler.org/middleware/
</code>
    * copy the config template and modify it to your needs:
<code>
cp volkszaehler.conf.template.php volkszaehler.conf.php
volkszaehler.conf.php:
$config['db']['user']                           = '<db-user>';
$config['db']['password']                       = 'demo';
</code>
    * run installer:
<code>bash /overlay/volkszaehler.org/share/tools/install.sh</code>
      * set doctrine path to "/overlay/lib/doctrine"
      * set volkszaehler path to "/overlay/www/vz"
    * stop uhttpd before removing it
<code>/etc/init.d/uhttpd stop</code>
    * now remove uhttpd and all packages that depend on uhttpd:
<code>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-cbi luci-uvl luci-i18n-english luci-uci uhttpd</code>
   * modify /etc/lighttpd/lighttpd.conf:
<code>
server.document-root = "/overlay/www/"
index-file.names = ( "index.html", "index.php", "default.html", "index.htm", "default.htm" )
</code>
   * modify /etc/php.ini:
<code>
doc_root = "/overlay/www"
; Dynamic Extensions               
extension=ctype.so
extension=json.so       
extension=pdo.so 
extension=pdo-mysql.so
extension=session.so               
extension=sockets.so        
</code>

  * enable (normal) cgi modify /etc/lighttpd/lighttpd.conf:
<code>
cgi.assign = ( ".php" => "/usr/bin/php-cgi" )    
</code>
  * or else enable fastcgi modify /etc/lighttpd/lighttpd.conf:
<code>
fastcgi.server = (                             
        ".php" => (            
                "localhost" => (                 
                        "socket" => "/tmp/php-fastcgi.socket",                 
                        "bin-path" => "/usr/bin/php-fcgi"
                )           
        )                                
)                                                           
server.modules = (
        "mod_fastcgi",
)      
</code>

todos:
  * mount /overlay at boot time
  * start mysqld at boot time ("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'
  * start lighttpd at boot time