React .Vs. Respond

Suddenly, a cockroach flew from somewhere and sat on a lady. I

wondered if this was the cockroach’s response to all the glory that

was spoken about it! She started screaming out of fear. With panic

stricken face and trembling voice, she started jumping, with both her

hands desperately trying to get rid of the cockroach. Her reaction was

contagious, as everyone in her group got cranky to what was happening.

The lady finally managed to push the cockroach to another lady in the

group. Now, it was the turn of the other lady in the group to continue

the drama. The waiter rushed forward to their rescue. In the relay of

throwing, the cockroach next fell upon the waiter. The waiter stood

firm, composed himself and observed the behaviour of the cockroach on

his shirt. When he was confident enough, he grabbed and threw it out

with his fingers.

Sipping my coffee and watching the amusement, the antenna of my mind

picked up a few thoughts and started wondering, was the cockroach

responsible for their histrionic behaviour? If so, then why was the

waiter not disturbed? He handled it near to perfection, without any

chaos. It is not the cockroach, but the inability of the ladies to

handle the disturbance caused by the cockroach that disturbed the

ladies.

I realized even in my case then , it is not the shouting of my father

or my boss that disturbs me, but it’s my inability to handle the

disturbances caused by their shouting that disturbs me. It’s not the

traffic jams on the road that disturbs me, but my inability to handle

the disturbance caused by the traffic jam that disturbs me. More than

the problem, it’s my reaction to the problem that hurts me.

The Take-Away

The women reacted, whereas the waiter responded. We should not react

in life, we should always respond.

Reactions are always instinctive whereas responses are always intellectual.

Postgis 1.4.* with postgresql 8.4 Ubuntu 9.10 /9.04

apt-get update

apt-get install vim

#The sources are still not available on the regular package servers... edit the sources

vim /etc/apt/sources.list

deb http://ppa.launchpad.net/pitti/postgresql/ubuntu jaunty main

deb-src http://ppa.launchpad.net/pitti/postgresql/ubuntu jaunty main

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 8683D8A2

sudo apt-get update

sudo apt-get install postgresql-8.4

#This changes the port from 5433 to 5432

sudo sed -i.bak -e 's/port = 5433/port = 5432/' /etc/postgresql/8.4/main/postgresql.conf

sudo /etc/init.d/postgresql-8.4 stop

sudo /etc/init.d/postgresql-8.4 start

apt-get install postgresql-server-dev-8.4 libpq-dev

apt-get install libgeos-dev

wget http://postgis.refractions.net/download/postgis-1.4.0.tar.gz

apt-get install proj

tar xvfz postgis-1.4.0.tar.gz

cd postgis-1.4.0

./configure

make

make install

sudo su postgres

#change the postgres password to "atlas" so that you can later login

psql -c"ALTER user postgres WITH PASSWORD 'atlas'"

createdb geodb (with password atlas)

createlang -dgeodb plpgsql

psql -dgeodb -f /usr/share/postgresql/8.4/contrib/postgis.sql

psql -dgeodb -f /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql

psql -dgeodb -c"select postgis_lib_version();"

#This should return 1.4.0

exit

P.S: Note these contents are borrowed from http://biodivertido.blogspot.com/2009/10/install-postgresql-84-and-postgis-140.html

Configure Oracle from PHP on Centos 5

1) install apache, php …

yum install httpd php php-mysql php-pear php-devel zlib zlib-devel
yum groupinstall « Development Tools »

2) Download and install oracle instant client (basic and devel) from there:

http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html

rpm -Uvh oracle-instantclient-basic-.i386.rpm
rpm -Uvh oracle-instantclient-devel-.i386.rpm

3) Add the Oracle instant client to dynamic linker

echo /usr/include/oracle//client/lib/ > /etc/ld.so.conf.d/oracle_client.conf
ldconfig -v

4) Untar the PECL package and prepare it for compiling. You may download it from http://pecl.php.net/package/oci8

tar -xzvf oci-.tgz
cd oci-
phpize

5) Configure the PECL package as a shared object using the instant client and specifying where the Oracle client libraries are. Then build and install it.

./configure –with-oci8=shared,instantclient,/usr/lib/oracle//client/lib
make
make install

6) Add the library shared object for PHP

echo extension=oci8.so > /etc/php.d/oci8.ini

7) Start Apache

‘service httpd start’ _or_ ‘/etc/init.d/httpd restart’

Create a PHP info page and checked to see if the Oracle (oci8) driver is listed:

echo > /var/www/html/phpinfo.php

I hope this helps.

PS: These contents are borrows from url http://bigjim-network.be/2009/06/02/oracle-from-php-on-centos-5/

Install fussystrmatch package on postgresql

Step 1: Install package postgresql-contrib-8.*

You may use command sudo apt-get or may use GUI tool like Synaptic package manager.

Note * points to version like 8.3,8.4 etc

Step 2: go to directory where you will find sql files

cd usr/share/postgresql/8.*/contrib

Note * points to version like 8.3,8.4 etc

and execute following command

psql -d indiainfo -U postgres -W -f fuzzystrmatch.sql

this will create all functions like metaphone, soundex etc for you.

Hope this helps you

Regards
Rahul Teni
Cynosure Software Solution

Postgresql Single quotes!

Dear All,

Just wanted to share how we can incorporate single quote in postgresql plpgsql.

Say i want dynamic query like select id from emp where empname ilike 'Rahul Teni' and age > 25

name:='Rahul Teni'

query:= 'select id from emp where empname ilike' ||''''||name||''''||'and age >25'

I hope this helps and saves your lot's of time.

org.codehaus.groovy.grails.orm.hibernate.exceptions.CouldNotDetermineHibernateDialectException: Could not determine Hibernate dialect - oracle

Hi,

If you are getting following exception,

org.codehaus.groovy.grails.orm.hibernate.exceptions.CouldNotDetermineHibernateDialectException: Could not determine Hibernate dialect for database name [Oracle]!

at org.grails.tomcat.TomcatServer.start(TomcatServer.groovy:135)

at grails.web.container.EmbeddableServer$start.call(Unknown Source)

at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy:158)

at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy)

at _GrailsSettings_groovy$_run_closure10.doCall(_GrailsSettings_groovy:287)

at _GrailsSettings_groovy$_run_closure10.call(_GrailsSettings_groovy)

at _GrailsRun_groovy$_run_closure5.doCall(_GrailsRun_groovy:149)

at _GrailsRun_groovy$_run_closure5.call(_GrailsRun_groovy)

at _GrailsRun_groovy.runInline(_GrailsRun_groovy:115)

at _GrailsRun_groovy.this$4$runInline(_GrailsRun_groovy)

at _GrailsRun_groovy$_run_closure1.doCall(_GrailsRun_groovy:59)

at RunApp$_run_closure1.doCall(RunApp.groovy:33)

at gant.Gant$_dispatch_closure4.doCall(Gant.groovy:324)

at gant.Gant$_dispatch_closure6.doCall(Gant.groovy:334)

at gant.Gant$_dispatch_closure6.doCall(Gant.groovy)

at gant.Gant.withBuildListeners(Gant.groovy:344)

at gant.Gant.this$2$withBuildListeners(Gant.groovy)

at gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)

at gant.Gant.dispatch(Gant.groovy:334)

at gant.Gant.this$2$dispatch(Gant.groovy)

at gant.Gant.invokeMethod(Gant.groovy)

at gant.Gant.processTargets(Gant.groovy:495)

at gant.Gant.processTargets(Gant.groovy:480)

It might be becuase your hibernate dialect for database oracle is not set properly.

You need to add this line dialect='org.hibernate.dialect.Oracle10gDialect' in your database configuration file for your grail application in datasource part.

Please take a note it must be added to datasource part not hibernate part.

I hope this helps.

Regards

Rahul Teni

Lighttpd Installation

Steps to Lighttpd Installation

Edit file /etc/lighttpd/lighttpd.conf file for any configuration related changes.

Go to system -> Administration -> Synaptic Package Manager and select lighttpd

Click apply changes