MYSQL

Check for mysql packages install
================================
rpm -qa | grep -i mysql

Remove previous mysql packages
===============================
rpm --nodeps --allmatches -e mysql-3.23.58-16.RHEL3.1

Download & install new packages
===============================
wget http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-server-community-5.0.45-0.rhel3.i386.rpm/from/http://mysql.oss.eznetsols.org/
wget http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-client-community-5.0.45-0.rhel3.i386.rpm/from/http://mysql.oss.eznetsols.org/
wget http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-shared-compat-5.0.45-0.rhel3.i386.rpm/from/http://mysql.oss.eznetsols.org/

rpm -ivh MySQL-client-community-5.0.45-0.rhel3.i386.rpm
rpm -ivh MySQL-shared-compat-5.0.45-0.rhel3.i386.rpm
rpm -ivh MySQL-server-community-5.0.45-0.rhel3.i386.rpm

Installing NSCC
=======================================================
./NSCC_Setup_3.0_35_3.bin -console
chkconfig --add NSCCService

NSCC

Installing the library
=======================================================
rpm -iU compat-db-3.3.11-2.i386.rpm --nodeps
cd /lib
ln -s libdb-4.1.so libdb-3.2.so

Host is resolving to correct ip
=======================================================
[root@cc lib]# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
10.0.0.180 cc.sn.com.sg cc
::1 localhost6.localdomain6 localhost6

[root@cc lib]# hostname -i
10.0.0.180

NSCC Setup
=======================================================
chmod 777 nscc

yum install mysql mysql-devel mysql-server
./nscc.sh

Things learn today

Mount new hdd into centos
mkfs -t ext3 /dev/hdb1
mount -t ext3 /dev/hdb1 /opt

Cacti
============================
Services
mysqld
httpd

/etc/httpd/conf.d/cacti.conf -> permit ip address range

Oasis found

Having lived in the concrete jungle for 27 years, I only came to find this Oasis recently. A 10 minutes slow walk, brings me to this sanctuary called AMK park. Located right besides the AMK MRT, it truly amazing to have an asylum of tress and birds singing in the heart of the concrete jungle that we lived in. Spend 3 hours reading my books, writing some stuff, gathering my thoughts for the future, will do this next week again.

One too many beer?

The drinking session ended last night with 25 bottles of Tiger and 1 bottle of Baron emptied. On a side note, found another nice jap beer - Sapporo.

Remembrances of the past

We are not only worlds apart, time and space also divides us....
How times flies without ones' knowledge...
Holding onto memories of the past or is it illusions?