Rain water harvesting

Rain water harvesting is the good thing that we are doing to ourself and our children. We make water percolate into earth making water table to raise, you know we also eradicate stagnant water in this process, its not a joke, in our apartment (at Virugambakkam, kaliamman Koil Street) water will get logged during rains and takes days to get drained (literally evaporated and spilled out into gutters). This year one of the apartment owner has taken steps to construct water harvesting pit and connection to central drainage system - which made our lives happier even during the heavy rains.

Go through the attached new article released in The Hindu at 3rd page of 15th Nov, 2010 (courtesy - the Hindu)

Intalling Postgres, Apache and PHP in Kubuntu (Linux)

Download Software's:

Download source archive files of PostgreSQL, Apache and PHP from respective project sites. Currently supported versions are given as reference. Take the latest point release (denoted as x below) from the sites:
1. http://www.postgresql.org/ftp/source/v8.4.4/postgresql-8.4.4.tar.bz2
2. http://httpd.apache.org/download.cgi#apache22
3. http://in2.php.net/get/php-5.3.3.tar.bz2/from/a/mirror (if this download is not found go to http://in2.php.net/downloads.php and click on the latest version to download)

Postgresql

1. tar xvjf postgresql-8.4.4.tar.bz2
2. cd postgresql-8.4.4/
3.a. su (i.e change to super use)
b. apt-get install tcl
c. apt-get install tcl-dev
d. ./configure --with-tcl
4. make
5. make install
6. mkdir /usr/local/pgsql/data
7. chown postgres:postgres /usr/local/pgsql/data/
8. su postgres
9. /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data/
10. /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start&
11. /usr/local/pgsql/bin/psql template1
12. exit (from db)
13. a. /usr/local/pgsql/bin/createuser leatherlink
b. exit as postgres user
14. cp contrib/start-scripts/linux /etc/init.d/postgresql
15. chmod a+x /etc/init.d/postgresql
16. /etc/init.d/postgresql restart
17. nano /home/leatherlink/.bashrc
export PATH=/usr/local/pgsql/bin:$PATH
18. psql template1
CREATE DATABASE leatherlinkdb;
\c leatherlinkdb
CREATE LANGUAGE plpgsql;
CREATE LANGUAGE pltcl;
\q


Apache:

1. cd
2. tar xvjf httpd-2.2.xx.tar.bz2
3. cd httpd-2.2.xx/
4. ./configure –enable-so
5. make
6. a. su
b. make install
7. /usr/local/apache2/bin/apachectl start
8. /usr/local/apache2/bin/apachectl stop
9. cp /usr/local/apache2/bin/apachectl /etc/init.d/httpd
10. /etc/init.d/httpd restart

PHP

1. cd
2. tar xvjf php-5.3.2.tar.bz2
3. cd php-5.3.2/
4. a. apt-get install libxml2-dev
b. apt-get install openssl
apt-get install libcurl4-openssl-dev
(http://linux.goeszen.com/missing-openssl-evp-hmac.html)
c. ./configure –with-pgsql –with-apxs2=/usr/local/apache2/bin/apxs –with-curl=/usr –enable-calendar –with-curl –enable-dba –enable-ftp –with-zlib-dir –enable-soap –with-regex=php –with-openssl –enable-bcmath
5. make
6. a. su
b. make install
7. cp php.ini-development /usr/local/lib/php.ini
8. /usr/local/apache2/conf/httpd.conf

SetHandler application/x-httpd-php


SetHandler application/x-httpd-php-source

AllowOverride All
9. /usr/local/apache2/bin/apachectl restart