Computer Tips and Tricks

Install Sun Java on Ubuntu 11.04

2011-06-20T08:41:00.004-04:00

1. sudo add-apt-repository "deb http://archive.canonical.com/ lucid partner"

2. sudo apt-get update

3. sudo apt-get install sun-java6-bin sun-java6-jre sun-java6-jdk

4. set JAVA_HOME=/usr/lib/jvm/java-6-sun

5. set PATH=$JAVA_HOME/bin:$PATH

6. java -version

Mount NTFS disk to CentOS 5.5

2011-04-24T12:36:00.003-04:00

1. Find out the hardware platform:
uname -i

2. Download the rpmforge-release package.

i386 - http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm
x86_64 - http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm

3. Install GPG key:
rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt

4. Install the package.
rpm -i rpmforge-release-0.5.2-2.el5.rf.*.rpm

5. Install fuse-ntfs-3g packages.
yum install fuse fuse-ntfs-3g

6. Check the NTFS partition.
fdisk -l

7. Create the mount point.
mkdir /mnt/windows

8. Mount the NTFS disk.
mount /dev/sdb1 /mnt/windows

Use At to run repeated task

2011-04-16T06:18:00.014-04:00

Following is an example, schedule.sh, to run check_process.sh script at /home/pwong every 3 minutes within 12 hours period.

WorkDir=/home/pwong

if [ ! -f off_time ]; then
date --date="+12 hours" +"%k" > off_time
fi

if [ `date +%k` -eq `cat off_time` ]; then
rm off_time
exit 1
fi

sleep 60

cd $WorkDir

at -f schedule.sh +3 minutes

check_process.sh

exit 0

Install and Test SNMP on CentOS 5.5

2011-04-16T00:32:00.016-04:00

1. Install net-net-snmp and net-snmp-utils
# yum install net-snmp-utils

2. Create /etc/snmp/snmpd.conf. Following is a very simple example for the testing.

rocommunity public
syslocation "ABC, ABC Inc."
syscontact me@abc.com

3. Startup snmpd server
# /etc/init.c/snmpd start

4. Ues snmpwalk to test SNMP setup.
# snmpwalk -v 1 -c public -O e 127.0.0

Or
# snmpwalk -v 1 -c public localhost system

If something similar to the following show up on the screen, the SNMP is working.

SNMPv2-MIB::sysDescr.0 = STRING: Linux localhost.localdomain 2.6.18-194.el5 #1 SMP Fri Apr 2 14:58:35 EDT 2010 i686
SNMPv2-MIB::sysObjectID.0 = OID: NET-SNMP-MIB::netSnmpAgentOIDs.10
DISMAN-EVENT-MIB::sysUpTimeInstance = Timeticks: (977) 0:00:09.77
SNMPv2-MIB::sysContact.0 = STRING: me@abc.com
SNMPv2-MIB::sysName.0 = STRING: localhost.localdomain
SNMPv2-MIB::sysLocation.0 = STRING: "ABC, ABC Inc."
...

5. If someting is wrong, check /etc/snmpd/snmpd.conf for error. Following commands can be used for troubleshooting as well. If everything is fine, then firewall settings should be checked.
# /etc/init.d/snmpd status
# snmpd -f -Le

6. Enable the snmpd starts up when the system reboot.
# chkconfig snmpd on

Mysqldump Performance Issue

2011-04-15T20:18:00.003-04:00

When dumping really big tables, mysqldump was using up large amounts of memory, so it may cause no-response problem. To overcome this, --quick and --single-transaction options can used. Following are the sections for these options in the mysqldump man page.

--quick, -q
This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out.

--single-transaction
To dump big tables, you should combine this option with --quick.

Use Remote Variables with Rsh or Ssh

2011-04-03T18:43:00.008-04:00

Followng are the difference between local and remote variables. $PWD is the local variable passed to remote system, but \$PWD is the variable defined in the remote system.

/home/patrickw/tools $ sudo ssh host "echo $PWD"
/home/patrickw/tools

/home/patrickw/tools $ sudo ssh host "echo \$PWD"
/root

Therefore, backslashes in the following example is necessary. Without the backslashes, awk will complain syntax error since the variables are blank.

sudo ssh host "top -b -n 1 | egrep sudo\|ssh\|xinet | awk '{print \$1, \$9, \$10, \$12}'"

Install OpenNMS with postgreSQL 9 on CentOS 5.5

2011-02-28T23:55:00.008-05:00

yum install yum-fastestmirror
rpm -Uvh http://yum.opennms.org/repofiles/opennms-repo-stable-rhel5.noarch.rpm
wget http://www.pgrpms.org/9.0/redhat/rhel-5-x86_64/pgdg-centos-9.0-2.noarch.rpm
rpm -i pgdg-centos-9.0-2.noarch.rpm
yum install postgresql90-server postgresql90-devel
/etc/init.d/postgresql-9.0 initdb
vi /var/lib/pgsql/9.0/data/pg_hba.conf, to change ident to trust for all local, IPv4, and IPv6.
vi /var/lib/pgsql/9.0/data/postgresql.conf to modify work_mem, vacuum_cost_delay, wal_buffer, checkpoint_segment, etc to meet your need.
/etc/init.d/postgresql-9.0 restart
createdb -U postgres opennms
wget http://sourceforge.net/projects/opennms/files/IPLIKE/stable-2.0/iplike-2.0.0.tar.gz
tar xfz iplike-2.0.0.tar.gz
cd iplike-2.0.0
./configure --with-pgsql=/usr/pgsql-9.0/bin/pg_config
make
make install
/usr/local/sbin/install_iplike.sh
psql -U postgres -h localhost -d opennms -c '\df+ iplike|head'
yum install opennms --nogpgcheck
/opt/opennms/bin/runjava -s
/opt/opennms/bin/install -dis
/etc/init.d/opennms start

The OpenNMS page is at http://localhost:8980/opennms/login.jsp. Both initial user name and password are admin.

Add local disk to Xenserver 5.5 running under VMware

2011-01-28T22:35:00.010-05:00

1. Find the new disk name.

fdisk -l

2. Create physical volume.

pvcreate /dev/hdb

3. Find out the name of the disk.

ll /dev/disk/by-id/

...

lrwxrwxrwx 1 root root 9 Jan 28 22:18 ata-VMware_Virtual_IDE_Hard_Drive_01000000000000000001 -> ../../hdb

4. Create SR.

xe sr-create type=lvm content-type=user device-config:device=/dev/disk/by-id/ata-VMware_Virtual_IDE_Hard_Drive_01000000000000000001 name-label=”LOCAL DISK”

After the running above command, the LOCAL DISK will be in Xenserver's Storage Repositories.

Note: You can name your own name-label.

Install Lighttpd With PHP5/MySQL on Ubuntu 10.10

2011-01-04T10:38:00.001-05:00

The following link has detailed instructions:

http://www.howtoforge.com/installing-lighttpd-with-php5-and-mysql-support-on-ubuntu-10.10

Fix vSphere problem on Windows 7

2011-01-04T09:06:00.001-05:00

Following link has a detailed explanation:

http://www.techhead.co.uk/running-vmware-vsphere-client-on-windows-7

Reset root password on Rad Hat Enterrpise 5

2010-12-24T16:17:00.004-05:00

Insert install CD #1 into the CD drive, then reboot system.
At boot: prompt, enter linux rescue, then wait until Choose a Language screen shows up.
Select the language, press tab to highlight OK, then press enter.
Select the keyboard type, press tab to highlight OK, then press enter.
Select Yes or No for Setup Networkign screen, then press enter. Press enter again for Continue.
Press enter at Your system has been mounted under /mnt/sysimage screen.
At command prompt sh-3.2#, type in chroot /mnt/sysimage, then passwd to reset the root pass word.
Enter the the same password twice at New UNIX password and Retype new UNIX password prompts.
Type reboot at the command prompt to restart the server.

Use PSP to play You Tube videos

2010-11-15T22:44:00.005-05:00

PSP can be used to watch You Tube video when you travel with train or bus. For a student, this can be a great tool for study. Following is how to do it in a few steps.

1. Download and install Free You Tube to iPod Converter from http://www.dvdvideosoft.com/guides/free-youtube-to-ipod-converter.htm.

2. Start the program and set the Devices to Sony PSP and the output folder, then paste the URL of video file from You Tube one by one. Down load file or files to the your PC.

2. Connect USB cable between PSP and your PC, and select USB connection in settings. The PSP will be named as Memory Stick on you PC like a hard drive.

3. Copy the video file to Video folder at Memory Stick.

4. Select Video->Memory Stick, then select the video to watch.

Change Windows XP to a Multi Language System

2010-11-13T22:31:00.002-05:00

Download Windows XP Multilingual User Interface Pack (Multi-Language) which has 5 CDs. This demo installs Traditional Chinese from the first CD which contains Chinese, Korean, Japanese, French, and German.

1. Double click mui_wxm_cd1.exe to extract all files for installation.

2. Double click muisetup.exe.

3. Accept the license agreement, then select the languages (Traditional Chinese) to install.

4. Reboot the system once the installation is completed, then start the Control Panel->Regional and Language Options. Select Hong Kong for location. Select Traditional Chinese for Language Used in Menus and Dialogs under the Language tab, then click OK.

5. Log off then log in again, the user interface has been changed from English to Traditional Chinese.

NAnt with Windows 7

2010-10-19T22:28:00.002-04:00

In order to use either NAnt 0.85-cr2 or 0.91-alpha2 on Windows 7, you need to download and install Microsoft .NET Framework 4, dotNetFx40_Full_setup.exe, from Microsoft at

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=9cfb2d51-5ff4-4491-b0e5-b386f32c0992&displaylang=en.

IIS 7.0 Configuration Backup

2010-10-18T16:54:00.002-04:00

The configurations of IIS on Windows 2008 server or Windows 7 can be backup/restored with appcmd.exe.

1. Backup

C:\Windows\system32\inetsrv\appcmd add backup my-backup

It will create C:\Windows\system32\inetsrv\backup\my-backup with following files:

2010-10-06 11:17 PM 18,258 administration.config

2010-10-18 02:50 PM 62,750 applicationHost.config

2010-10-06 11:16 PM 490 redirection.config

2010-10-18 10:44 PM <DIR> schema

Please note that if no backup name is given, a name with date and time is used for the backup object as show below:

C:\Windows\system32\inetsrv\appcmd add backup

BACKUP object "20101018T224909" added

2. Delete

C:\Windows\system32\inetsrv\appcmd delete backup my-backup

3. Restore

C:\Windows\system32\inetsrv\appcmd restore backup my-backup

4. List

C:\Windows\system32\inetsrv\appcmd list backup

Install Broadcom driver for VMware ESXi

2010-06-21T18:41:00.005-04:00

1. Download Broadcom NetXtreme II Ethernet network card driver CD from http://www.vmware.com/support/vsphere4/doc/drivercd/esx40-net-bnx2x_400.1.48.107-1.0.4.html. Burn a CD from the file just downloaded.

2. Because the Perl script vihostupdate.pl is used for the installation, download vSphere client CLI from VMware site http://www.vmware.com/downloads/eula.do.

3. Install the vSphere client CLI which is a bundle of Active Perl and some admin tools on the administration PC. It is better to include the tools in the %PATH% before using the them.

4. Switch the host to the maintenance mode before the installation. Key in the following one by one from the console:
press alt+F1, type: unsupported, enter the root password. Run following command to switch to the maintenance mode.

vim-cmd /hostsvc/maintenance_mode_enter

Please note that enable ssh login is alternative way to run above command remotely.

5. After the host is in the maintenance mode, following command can be used to install the driver from vSphere client command line.

vihostupdate.pl --server 192.168.1.100 --install --bundle E:\offline-bundle\BCM-bnx2x-1.48.107.v40.2-offline_bundle-181332.zip

6. Reboot ESXi.

Run VMware ESXi 4.0 on USB devices

2010-06-20T07:25:00.002-04:00

There are many posts in how to run VMware ESXi on USB flash in the Internet. However, the method can be applied to the USB portable disk as well.

This is one of the links for running ESXi 3.5 on USB flash drive, http://www.atomicsub.net/2009/01/vmware-esxi-usb-flash/. Be very careful to select the correct disk. The image uses entire disk space, so all data on the disk will be wiped out.

The steps to run ESXi 4.0 are the same as the above except the image dd file is in image.tgz instead of install.tgz.

Install VirtualBox Guest Addition for Backtrack 4

2010-05-01T01:10:00.002-04:00

1. mount /dev/hdc /mnt

2. cd /mnt

3. ./VBoxLinuxAddition-x86.run

Simple Debug tips for PHP&MySQL Program

2010-04-01T08:53:00.020-04:00

1. Use PHP command to check if there is any syntax error. If no complains, an html file created by the script should be dumped to the screen. Because the script is check from the command line, it is quick and handy.

php -l report.php

2. Always use <?php codes... ?> instead of <? codes... ?> to make sure the PHP code will run in different environment. Especially for those whom cannot modify the file php.ini to enable the short tags for PHP codes.

3. In the php script, always check the return value of a function such as sql_connect or sql_query with "or die(sql_error())" to make sure the function is executed as expected. Following are examples:

mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_query($sql) or die(mysql_error());

4. Check web server error log such as error_log for Apache server. For example, the Apache error log is /var/log/httpd/error_log for RedHatd, CentOS, and Fedora.

Use iSCSI disk on Windows 2008

2009-12-22T14:11:00.003-05:00

The iSCSI Initiator is part of Windows 2008, and it is located in the Control Panel. To

1. From iSCSI Initiator Properties, select Discovery tab, Click Add Portal, then enter the IP address with the default port number 3260 unchanged and click OK.

2. Select Target tab, click Log on, the target name has been picked up, so just select automatically restore this connection when the computer starts, then click OK. If the configuration is right, the status of the Properties should indicate Connected. Click OK to exit the properties.

3. From the Administrative Tools-> Computer Management->Disk Management. There should be a new disk without a drive letter. From the property of the new disk it displays something like OPENFILER VIRTUAL-DISK SCSI Disk Device on my system.

4. To use the new disk, right click on the disk, highlight Convert to Dynamic Disk, select the disk number, and then click OK. Select a drive letter, and then format the disk. After the format is completed, the new disk can be used as a normal disk for the system.

Don't use test as the name of your program in Unix/Linux

2009-12-16T13:05:00.005-05:00

Remember, test itself is the internal shell command in Unix/Linux OS.

When you type in test, the name of the program you just wrote, you may realize your program doesn't work at all. You may spend lots of time in your program for debugging or struggle with your environment. Please don't waste your time; the puzzle is not in your program or your environment but the name, test.

The trick is that when test is entered from the command prompt, shell always run its test command instead. The only way you can start up your program is either to start your program with the full path "/PATH/test" or "bash test" if it is in the current directory.

The simple solution for this problem is NOT to use test as your program name.

Connect Ubuntu 9.10 to Remote systems with Window XP SP2 VPN Server

2009-12-16T11:12:00.006-05:00

1. Setup Windows VPN server.

Open Network and Internet Connections in the Control panel. In the open window, click Network connections. Under Network Tasks, click Create New Connection to bring up the New Connection Wizard. Click Next, select Set up an advanced connection, and then click Next. Select Accept incoming connections, and then click Next then Next. Select Allow virtual private connection, then Next. From the User Permissions window, select or add the users allow to make the connections, and then click Next. At the Networking Software, highlight Internet Protocol (TCP/IP), and then click Properties. Either select Specify TCP/IP address, enter the address range or select to use DHCP, then click OK.Finally click Next and Finish completing the setup.

2. Enable Remote desktop Access. Forget this; Ubuntu won't be able to make connection to Windows XP system.

From Control panel, click Performance and Maintenance, then System. Select Remote tab, Select Allow users to connect remotely to this computer, and then click OK.

3. Setup VPN client on Ubuntu.

From Applications-> Ubuntu Software Centre, enter pptp in the search box, select and install PPTP VPN Connection Manager package. Reboot Ubuntu. Click the Network Manager in the system tray, select VPN connection-> Configure VPN… then makeup a connection name and enter the IP address of the VPN server with user name and pass word, then click Apply and Close.

To make VPN connection, from the Network Manager-> VPN Connections, then double click the connection name just created. When a lock logo showed at the upper-left corner of the Network manager, the Windows XP VPN server is connected.

4. Startup remote desktop

Bring up Application->Internet->Terminal Server Client. Enter the Computer IP address or hostname, select Protocol to RDP, and then click Connect. The Terminal Server Client will display the Windows XP login screen. Enter the user name and pass word to start the remote desktop session on the Windows system.

Setup CruiseControl on CentOS 5.4

2009-12-04T23:26:00.004-05:00

1. Install Java:

yum install java java-1.6.0-openjdk-devel

2. Install Junit:

yum install junit

3. Install CVS

yum install cvs

4. Install CruiseControl/ANT

Download the current CruiseControl, cruisecontrol-bin-2.8.2.zip, from http://cruisecontrol.sourceforge.net/download.html, then unzip the file to /usr/share/cruisecontrol-bin-2.8.2. Set $ANT_HOME to /usr/share/cruisecontrol-bin-2.8.2/apache-ant-1.7.0, and PATH to include $ANT_HOME/bin and /usr/share/cruisecontrol-bin-2.8.2. Run 'ant -diagnostics' to make sure ANT is installed properly.

After above software get installed, follow the step-by-step instructions in http://cruisecontrol.sourceforge.net/download.html to create a simple CruiseControl build environment should be pretty easy.

Remove the CR character with sed or tr

2009-12-04T12:50:00.009-05:00

Following command will redirect the content of dosfile except the CR characters to newfile:

sed 's/^V^M//' dosfile > newfile

Note: ^ is the control key.

tr -d '\015' < dosfile > newfile

Solaris Disk Cloning with dd and cpio

2009-12-04T12:05:00.010-05:00

For the disk cloning, power off the system, connect the target disk, then boot the system into single user mode. After the cloning, power off the system, disconnect the target disk which can be used as usual.

A. To clone a similar disk, assume the source disk is at /dev/rdsk/c0t0d0 and the target disk is at /dev/rdsk/c0t3d0 in the following example.

1. Clone the root partitial:

dd if=/dev/rdsk/c0t0d0s0 0f=/dev/rdsk/c0t3d0s0 bs=2048k count=1

dd if=/dev/rdsk/c0t0d0s0 of=/dev/rdsk/c0t3d0s0 bs=2048k

2. Clone the entire disk:

dd if=/dev/rdsk/c0t0d0s2 of=/dev/rdsk/c0t3d0s2 bs=2048k

B. To clone a disimilar disk, assume the source is at /dev/dsk/c1t3d0s0 and the target is at /dev/dsk/c1t0d0s0.

mount /dev/dsk/c1t3d0s0 /mnt/old

mount /dev/dsk/c1t0d0s0 /mnt/new

cd /mnt/old

find . -print | cpio -oac | (cd /mnt/new; cpio -imduc)

Continue to perform the similar operation for the rest of partitions.

If cloning is for the root disk, you may need to run installboot to fix the boot problem. Follow is the example to install the boot block on /dev/rdsk/cotodoso.

installboot /usr/platform/`uname -i`/lib/fs/ufs/bootblk /dev/rdsk/c0t0d0s0

Speed up the Internet connection for Windows XP

2009-10-25T16:20:00.004-04:00

1. From Windows XP, select Start->Run, enter regedit and click OK to start up Registry Editor.

2. At HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings, double click MaxConnectionsPer1_0Server to edit the value. Select Decimal, change it from default 10 to 100, then click OK to save it. Double click MaxConnectionsPerServer to edit the value. Select Decimal, change it from default 10 to 100, then click OK to save it.

Transfer MySQL database

2009-10-20T23:54:00.011-04:00

One way to transfer database from one server to an other is to use dump file created by mysqldump. However, on the new server to restore the dump file, MySQL may complains this:

ERROR 1046 (3D000) at line xx: No database selected

To fix this problem, insert following 2 lines in bold before the "DROP TABLE IF EXISTS 'address'", in following example, of the dump file before restoring the database:

...
CREATE DATABASE databasename;
USE databasename

DROP TABLE IF EXISTS 'address'
...

The modified dump file will create a new database and select it, then restore the dump file to this new database without problem.

The command syntax to backup/restore MySQL database as root are shown below:

Backup: mysqldump -u root -p databasename > dumpfilename

Restore: mysql -u root -p < dumpfilename

Note: the user has to enter the password for above commands.

Install PHP plugin to Eclipse on CentOS 5.3

2009-10-15T13:16:00.003-04:00

To install the the current PHP plugins to Eclipse, downlowd and unzip the file PHPEclipse-1.2.3.200910091456PRD-bin.zip from http://sourceforge.net/projects/phpeclipse to /usr/share/eclipse/plugins, then restart Eclipse.

Update to current PHP on CentOS 5.3

2009-10-14T22:41:00.006-04:00

The default version of PHP installed on CentOS 5.3 is 5.1.6. The command "yum update php" won't update to the current version. The function filter_var() is unavailable at 5.1.6, so this causes the undefined function error. Following steps will update to the current version of PHP to fix this problem.

1. Run following to check the PHP version and it should be 5.1.6:

php -v

2. Create /etc/yum.repos.d/utterramblings.repo to contain following information:

[utterramblings]
name=Jason's Utter Ramblings Repo
baseurl=http://www.jasonlitka.com/media/EL$releasever/$basearch/
enabled=1
gpgcheck=1
gpgkey=http://www.jasonlitka.com/media/RPM-GPG-KEY-jlitka

3. Run following to update PHP as root:

yum update php

4. Run the following to confirm the update of PHP and currently it is 5.2.11:

php -v

5. Restart Apache server to pickup the new version of PHP.

/etc/init.d/httpd restart

6. The error "undefined function filter_var() ..." will be disappeared.

SSL for Apache on Ubuntu

2009-09-08T23:38:00.006-04:00

1. Install curl:

sudo apt-get install curl

2. Enable SSL module:

sudo a2enmod ssl

3. Restart Apache server:

sudo /etc/init.d/apache2 restart

4. Enable site default-ssl:

sudo a2ensite default-ssl

5. Activate new configuration:

sudo /etc/init.d/apache2 reload

6. Test both http and https output with curl:

curl -k http://localhost
curl -k https://localhost

Both commands will have the same output like this:

<html><body><h1>It works!</h1></body></html>

Subversion and Eclipse

2009-09-08T18:03:00.002-04:00

It needs to install subclipse plugin before Eclipse can use Subversion. Please make sure Subversion has been installed on the server and is functional.

1. Start up Eclipse,from Help->Install New Software. Click Add button, type in http://subclipse.tigris.org/update in Location, click OK button. Select subclipse plugin then click Next button twice. Accept license agreement then click Finish button.

2. Restart Eclipse. From Windows->Open Perspective->Other. Highlight the new item SVN Repository Exploring then click OK button. Enter URL with the path of SVN repository, like http://localhost/svn/myproject, then click OK button. The URL just entered will be displayed under SVN Repository. The SVN exploring is ready to use. Multiple Repository can be added through Add SVN Repository button.

Setup Subversion with Apache on Ubuntu

2009-09-07T21:11:00.006-04:00

1. Install subversion and libapache2-svn:

sudo apt-get install subversion libapache2-svn

2. Add new group as subversion, and add www-data and subversion users to this group.

3. Logout and login again to become the member of subversion group.

4. Update/etc/apache2/mods-enabled/dav_svn.conf to something like this for the repository at /var/lib/svn/myporject:

DAV svn
SVNP ath /var/lib/svn

AuthType Basic
AuthName "myproject Subversion Repository"
AuthUserFile /etc/apache2/dav_svn.passwd
Require valid-user

5. Create directory for repository and setup the ownership and permission:

sudo mkdir /var/lib/svn
cd /var/lib/svn
sudo mkdir myproject
sudo chown www-data:subversion myproject
sudo chmod -R g+rws myproject

6. Create the repository:

sudo svnadmin create /var/lib/svn/myproject

7. Restart Apache server:

sudo /etc/init.d/apache2 restart

8. Create user password:

sudo htpasswd -c /etc/subversion/passwd user

9. Test local svn server setup:

svn co http://localhost/svn/myproject --username username

Note: An empty myproject is checkout.

10. Create a project structure named mywork at the current directory then import the directory to the repository:

svn import -m "New import" mywork http://localhost/svn/myproject

To check the repository, and mywork should be shown up:

svn ls http://localhost/svn/myproject

11. To checkout myproject:

svn co http://localhost/svn/myproject/mywork mywork-new

Setup CVS server on Ubuntu

2009-09-06T10:35:00.009-04:00

1. Install CVS client and server:

apt-get install cvs cvsd

With the default installation, the root for cvsd is at /var/lib/cvsd, and the bin, dev, etc, lib, tmp, and usr directories should be created during the install. The default repositories demo and myrepos are defined in the configuration file /etc/cvsd/cvsd.conf.

2. Start the CVS server:

sudo /etc/init.d/cvsd start

It looks like that the command /etc/init.d/cvsd status has problem to display the correct status of the CVS server, run following command to make sure if the server is running:

ps -def | grep cvsd

If the server is not running, modify the line with the word Listen in the configuration file /etc/cvsd/cvsd.conf:

from "Listen * 2401" to "Listen 0.0.0.0 2401".

Restart the server and check again.

3. Create myrepos and CVSROOT directories with following command (Note: the absolute path is needed to initialize the repose):

sudo cvs -d /var/lib/cvsd/myrepos init
sudo chown -R cvsd:cvsd /var/lib/cvsd/myrepos

The basic structures of cvsd and the repository $CVSROOT are ready.

4. Add user to the group cvsd and create the password for users.

From System->Administration->Users and Groups. Click Unlock button and enter the password, then click Manage Groups button. Highlight cvsd then click Properties and select the username from the Group Members list.

Create the user password for CVS login as shown below:

cvsd-passwd /var/lib/cvsd/myrepos username

5. The syntax to login to the local CVS server is shown below:

cvs -d :pserver:username@localhost:/myrepos login

However, if the $CVSROOT is defined just simply enter "cvs login" instead. Add following line in ~/.bashrc is the easiest way to add it to the environment.

export CVSROOT=:pserver:username@localhost:/myrepos

If log in has no problem, CVS should be working fine.

6. Following is the syntax to import an example tools project in the current directory to the repository. Please note that the CVS import function requires $CVSROOT defined.

cd tools
cvs import -m "Initial import into CVS" tools initial start

A new directory, tools, is created at /var/lib/cvsd/myrepos.

7. For any reason to completely uninstall cvsd, enter following command:

apt-get --purge remove cvsd

8. In Eclipse environment, the CVS repository location should be defined as /myrepos instead the full path.

Setup Openfiler 2.3 iSCSI on ESXi 4 for Windows

2009-08-31T16:32:00.007-04:00

1. Upload folder openfiler-2.3-x86 to the datastore through Datastore Browser. Right click openfiler-2.3-x86.vmx in the folder and select Add to Inventory. Enter the name then click Next button twice, and Finish button to complete the process.

2. Click Edit settings for openfiler, the add hard disk from ESXi as the new iSCSI storage device for Openfiler.

3. Power on the Openfiler, and open the console to confirm the URL for web administration. I use https://192.168.1.105:446 as an example.

4. Logon to Openfiler with your web browser at https://192.168.1.105:446 with the openfiler and password as the user name and password respectively.

5. Go to Volumes, a warning "No existing physical volumes were found, or all existing physical volumes are used. You can create new physical volumes" shows up. Click create new physical volumes, the newly added disk, /dev/sdb, has no partition. Select /dev/sdb from the Edit Disk list, then click Create button to use the entire disk space for the single partition.

6. Go to Volume Groups to create a group by entering the Volume group name and select physical volume /dev/sdb1 to add, then click Add volume group button to complete. Click Add volume, enter the volume name, description, select required space, and then select the filesystem/volume type to iSCSI, finally click Create to create the volume.

7. Go to System, in Network Access Configuration section, enter 192.168.1.0 for both Name and Network/Host, select 255.255.255.0 as Netmask, and select Share as Type, then click Update button.

8. Go to Services and enable iSCSI target server.

9. Go to Volumes, click iSCSI targets, select target configuration, the default target name is shown up, if no changes needed, click Add button to add the new target. Select LUN Mapping, then click Map button. Select Network ACL, select Allow from the Access list, and then click Update button.

10. Windows XP is used to test this iSCSI storage. Download the software from http://www.microsoft.com/downloads/details.aspx?familyid=12cb3c1a-15d6-4585-b385-befd1319f825&displaylang=en, and then install it to you PC.

11. On Windows, from All programs, select Microsoft iSCSI Initiator for configuration. Select Discovery then click Add button to add target portal, enter the IP address of the Openfiler, then click OK.

12. Select Targets then click Log On button. Select Automatically restore this connection when the system boots, then click OK button twice to finish the Windows XP setup.

13. From the disk manager, the Initialize and Convert Disk Wizard pops up automatically. Click Next button to continue. Select the correct disk, then click Next button. It reminds you that the disk will be converted to dynamic disk. Reselect the disk, then click Next then Finish button. Right click on the new disk, and then select New Volume to start the Wizard, click Next button to continue. The simple volume is the default for a single disk volume, click Next button to continue. If the entire disk is used, click Next button to continue. Select the drive letter, the click Next button. Select the Volume label, the click Next button. Click Finish button to finish performing the disk format. Finally, the iSCSI disk is created like a local disk to Windows.

Application Menu on Ubuntu 9.04

2009-08-24T17:47:00.003-04:00

To add manually installed Eclipse 3.5 to the Applications->System Tools for easy start up.

1. From System->Preferences->Main Menu to start the menu editing, highlight System Tools, select New Item, the Create Launcher dialog pops up.

2. The default type is Application, Enter "Eclipse 3.5" in the Name field, Browse the executable /usr/local/lib/eclipse/eclipse, click OK, then enter the comment as Java Development Tool. Click OK. The new item Eclipse 3.5 is created and selected at Main Menu dialog. Click Close to finish the Main Menu editing.

3. The item Eclipse 3.5 is the new item in Application->System Tools now.

Tools for Android development on Ubuntu 9.04

2009-08-24T16:24:00.006-04:00

1. Install Sun Java tool kit 6:

sudo apt-get install sun-java6-jdk

2. Verify the Java version:

java -version
javac -version

3. Download Android SDK, android-sdk-linux_x86-1.5_r3.zip, from http://developer.android.com/sdk/1.5_r3/index.html, and extract to /usr/local/lib. Update the ~/.bashrc to append the Android SDK tools to $PATH:

export PATH=$PATH:/usr/local/lib/android-sdk-linux_x86-1.5_r3/tools

4. Download current Eclipse 3.5, eclipse-java-galileo-linux-gtk.tar.gz, from http://www.eclipse.org/downloads/. Extract to /usr/local/lib.

5. Start up Eclipse, select Help->Install New Software. In the Install dialog, click Add..., then enter http://dl-ssl.google.com/android/eclipse/ in the location then click OK. Select Developer Tool which contains Android DDMS and Android Development Tools, click Next, Next. Accept the terms of License agreement, then click Finish. Go ahead at the restart Eclipse prompt.

6.Set up the Android SDK PATH in Eclipse. Select Windows->Preferences->Android. Browse the SDK Location to set the path.

7. Create an Android Virtual Device (AVD):
android create avd --target 2 --name my_avd

8. If Subversion is not on the system, run follwing to install Subversion:
sudo apt-get install subversion

Otherwise, run following command to checkout the example source from Google to learn and start:
svn checkout http://android-examples.googlecode.com/svn/trunk/ android-examples

Gigabit network for VMWare ESXi 4 Server

2009-08-18T22:38:00.005-04:00

A gigabit network is a must for VMWare ESXi 4. Otherwise the slow network will cause lots of problems such as the vSphere Client is extremely slow and some times it complains the server takes to long to respond and the operation can't be completed. In addition, either upload or download from the datastore browser will complain the IO error as well.

If a gigabit connection is established, all of above problems will be resolved.

Transfer files between VMWare ESXi server and your computer

2009-08-11T18:41:00.003-04:00

To enable the ssh at ESXi server, at the server console, press ALT-F1, type "unsupported", press Enter. When the password prompt shows up, enter the root password to log in.

Delete the first character # in the line containing ssh in the file /etc/inetd.conf to make it similar to the line below, then reboot the server.

ssh stream tcp nowait root /sbin/dropbearmulti dropbear ...

After ssh is enabled, putty can ssh to the server from your PC. WinSCP can upload/download files with the server as well.

An other tool can download files from the server is Firefox. Following example URL can browse the files at datastore1 on the server that has the IP address as 192.168.111.222:

https://192.168.111.222/folder?dsName=datastore1

In addition, the ESXi server's datastore browser also can upload and download files between the server and your PC.

VMWare Tools on CentOS

2009-08-10T08:02:00.002-04:00

1. Update the system.
yum update

2. Install gcc and kernel development tools.
yum install gcc kernel-devel

3. Following the instruction at http://www.vmware.com/support/ws5/doc/ws_newguest_tools_linux.html to complete the installation.

Using Flash Drive under VirtualBox

2009-07-14T16:54:00.003-04:00

To use the flash drive on the virtual machine:

1. Enable the USB Controller and USB 2.0 (EHCI) Controller from the Settings menu.
2. Logon to the virtual machine, plug in the flash drive to the system then right click on the USB devices logo at the buttum of the window and select the flash drive just lugged in.
3. After a few seconds, a new file folder started up at the Desktop. The flash drive can be used from now.
4. Folloing is the list of mount point for the flash drive on popular OS.


       CentOS - /dev/sda1
       OpenSolaris - /media
       Ubuntu - /media
       Solaris 10 - /rmdisk

5. The flash drive should be mounted and unmounted like a normal disk.

Assign host name to DHCP Solaris 10 Client

2009-07-13T20:51:00.002-04:00

Put the host name in the file /etc/nodename to assign the host name to Solaris 10 with DHCP network configuration. Otherwise, the system has the "unknown hostname" problem.

Perl DBI interface to MySQL

2009-06-05T15:28:00.011-04:00

The DBI module can be used to work with databases like Oracle, MySQL, and Informix in Perl. Following is an example to query names and phone numbers in the Info table of Supplier database with MySQL database.


#!/usr/bin/perl

use DBI;
use strict;

my $driver = "mysql";
my $database = "Supplier";
my $source = "DBI:$driver:database=$database";
my $userid = "XXX";
my $password = "XXX";
my $dbh = DBI->connect($source, $userid, $password ) 
     or die $DBI::errstr;

my $sth = $dbh->prepare("SELECT Name, Phone FROM Info");
$sth->execute() or die $DBI::errstr;
print "Company, Phone:\n";
while (my @row = $sth->fetchrow_array()) {
   my ($name, $phone ) = @row;
   print "$name, $phone\n";
}
$sth->finish();

Install Guest Addition for OpenSolaris 2009.06 on VirtualBox 2.2.4

2009-06-03T13:40:00.003-04:00

1. Click Devices -> Install Guest Additions to bring up VBOXADDITION 2.2.4 47978 to the Desktop.

2. Start up a terminal then change to the super user. Run "pkgadd -d /media/VBOXADDITION 2.2.4 47978/VBoxSolarisAddition.pkg". Select default and yes to start and continue the installation.

3. Unmount VBOXADDITION 2.2.4 47978 from the desktop.

4. Reboot the system.

Shared Folder in VirtualBox for Windows host/Linux Guest

2009-05-08T22:59:00.005-04:00

Select Devices -> Shared Folders from the virtual machine's menu bar, then click Add New Folder icon, from the Folder Path select the folder at Windows, enter the folder name to use, then click OK. The shared folder should be list at Transient Folders.

Mount the folder from the command line as root:

mount -t vboxsf folder_name mount_point

For example, type in "mount -t vboxsf Music /mnt" to mount Music folder to /mnt.

All files in the Music folder, at Windows, should be available at /mnt now.

CVS Enhancement

2009-04-30T17:24:00.023-04:00

Code Freeze:

Following can be used to prevent developers check in any file by accident when the source tree is ready for a release.

First, create a new directory $CVSROOT/CVSROOT/Freeze to keep the files for tree freeze. Each file is for a either a HEAD (at trunk) or branch. Following function check if the current tree is under freeze policy before perform the commit or import commands. This cvs function can be part of profile, so once the user login the system, it is loaded right away.


cvs ()
{
    # check for code freeze
    if [ "$1" = commit -o "$1" = import ]; then
        if [ ! -f "CVS/Repository" ]; then
            echo "Cannot find CVS/Repository.Please check
you current directory."
            return 1
        fi
        if [ -f CVS/Tag ]; then
            CVSTAG=`cat CVS/Tag | sed -e 's/.//'`
            if [ -f $CVSROOT/CVSROOT/Freeze/$CVSTAG ]; then
                echo "Sorry. Code freeze for the branch
 $CVSTAG."
                return 2
            fi
        elif [ -f $CVSROOT/CVSROOT/Freeze/HEAD ]; then
            echo "Sorry. Code freeze for the main trunk."
            return 3
        fi
    fi
    command cvs "$@"
}

Time Stamp for Tags or Branches

The "cvs log" command displays the tag and branch names with the revision of the file without date information.

To have a clear history for tags, create a tag history file in $CVSROOT/CVSROOT/logs/tags.history. Put following lines in the release script to append the tag to the history with the date information. To create new branch, a similar script can be created.


 HISTORY=$CVSROOT/CVSROOT/logs/tags.history
 cvs tag $1 source database document tools buildlogs
 echo "Tagged $1 source, database, document, tools, and \
 buildlogs at `date`" | tee -a $HISTORY

Powerful Unix find command

2009-04-23T11:13:00.002-04:00

List the files contain the word Unix in the current tree:

find . -type f -exec grep -l Unix {} \;

Set permission to 644 for all files in the current tree:

find . -type f -exec chmod 644 {} \;

The number of files in the current tree:

find . -type f -exec ls -l {} \; | wc -l

All the text type files in the current tree:

find . -type f -exec file {} \; | grep text

Power Schemes problem in Windows XP

2009-04-22T15:38:00.004-04:00

If the Power Schemes of Power Options Properties in Windows XP is set to Portable/Laptop, The system will be switched to standby state say after 20 minutes. However, this is a problem for the systems that provide the services to others, one of the example is the build system. The scheduled build tasks won't be able to start to perform the builds. Once a system could not start up scheduled tasks and stay in standby state, make sure the power schemes is not set to Portable/Laptop.

Extract files from DAA/UIF disc image file with PowerISO

2009-04-16T14:55:00.004-04:00

After download a CD/DVD image file in DAA or UIF format instead of the popular ISO, it's a headache to find a converter to open such image file, or retrieve some files from the image. I have tried daa2iso, MagicISO, and Active@ISO Burner but found various problems.

PowerISO can convert CD/DVD image file formats from BIN, NRG, CDI, DAA, and UIF, etc. to ISO format, extract files from the image to the hard disk, and make image file in ISO, BIN, or DAA formats.

To find out more PowerISO's features, please check http://www.poweriso.com.

Use Expect script with Database and others

2009-03-25T17:15:00.006-04:00

Expect is the tool for automated interactive programming, and it is available for Unix/Linux, Mac, and Windows.

If you are running a command line program and want to insert, modify, or retrieve data in and out with the database, expect is the choice.

It's simple and easy to learn and use. The basic commands are expect and send. Following is a piece of code to access MySQL database with Expect script.

set passwrd something
spawn mysql -u uid -p
expect "password:"
send "$passwrd\r"
expect "mysql>"
send "use CustomerDB\r"
expect "mysql>"
send "show tables;\r"
expect "mysql>"
send "select * from Customers where City = 'New York';\r"
expect "mysql>"
send "quit\r"

However, the expect script also can be used for Oracle but it is not limited to the database application. You can use it in other interactive applications such as ftp, telnet, and software installation, and software testing, etc.

Please check Don Libes' book Exploring Expect from O'Reilly for more details.

Use mkisofs to create data DVD for Unix file system

2009-03-25T16:14:00.006-04:00

The popular DVD burning software for Windows like Nero and Easy Media Creator are not safe to burn the Unix file system directly on CD or DVD. If you burned a disc in this way, try to md5 files on disc and the original files. You may realize that some of the MD5 hashes are not identical!

The older version of mkisofs could not create the image file larger than 2GB. However, the current version fix this problem by using a new -UDF option. Following is the syntax to create a data DVD ISO image file for the entire dirname folder:

mkisofs -o file.iso -UDF -f -a -J -r -v -V "Volume ID" dirname

It's safe to burn the image file with mkisofs because all files on disc will be identical to the original files.

For more detailed options, please look at its man page or run "mkisofs -help".

Unix sort command

2009-03-21T10:23:00.002-04:00

The sort command has -u option for unique. Therefore, the command "sort file | uniq" can be simplified as "sort -u file".

To sort in arithmetic order, use -n option, and -r option is used for reverse order.

Don't forget to redirect standard error for debugging

2009-03-21T10:02:00.006-04:00

Some programs print the error messages to the standard error instead of standard output. The trick is on a computer system, they both show up on the screen.

If you redirect the program's output to a file then examine the file later for troubleshooting, you may not find any error in the file. Most likely you run following from the command line.

cmd > file

The above command line only redirect the standard output to the file. To redirect both standard output and standard error to the file, run the following from the command line.

cmd > file 2>&1

IE blocks the ActiveX component installation

2009-03-20T15:16:00.002-04:00

Some times IE blocks the ActiveX component installation for the security reason. If the component is trusted, you may need to temporary change the security settings of IE, then change the settings back after the component get installed. See the following for details.

From the IE, select Tools->Internet Options->Security. At the Security level for this zone, select Custom level. Look for ActiveX controls and plug-ins section, enable Download unsigned ActiveX controls, and look for Miscellaneous section, enable Installation of desktop items.

After the component gets installed. reverse above settings.

Install VMware View Open Client on CentOS 5.2

2009-03-16T11:16:00.003-04:00

To install the VMware View Open Client, download the current version of rpm file from http://code.google.com/p/vmware-view-open-client/downloads/list, then install it on the system.

1. download VMware-view-open-client-2.1.1-153227.i386.rpm from the above location.

2. Install rdesktop if the package hasn't been installed.

yum install rdesktop

3. Install VMware View Open Client.

rpm -Uvh VMware-view-open-client-2.1.1-153227.i386.rpm

The VMware View Open Client will be in the Internet group.

Install wireshark on CentOS 5.2

2009-03-16T11:13:00.001-04:00

To install wireshark run the following as root:

yum install wireshark

Install Ruby on CentOS 5.2

2009-03-12T18:05:00.003-04:00

To install Ruby and related run the following as root:

yum install -y ruby
yum install -y ruby-devel ruby-docs ruby-ri ruby-irb ruby-rdo

PHP and Form

2009-03-06T11:52:00.005-05:00

PHP handles variable and upload file in HTML form differently.

1. For Variable:

Following is an example form in a HTML page that uses variable.php to process the form.

<FORM method="POST" action="variable.php">
<INPUT type="text" name="variable">
<INPUT type="submit" name="submit" value="Submit Name">
</FORM>

In the PHP script, variable.php, $_POST['variable'] will keep the value of the variable that user entered in the above form.

2. For File:

Following is an example form to upload a file from the HTML page.

<FORM enctype="multipart/form-data" method="POST" action="file.php">
<INPUT type="file" name="file" size="30">
<INPUT type="submit" name="submit" value="Upload File">
</FORM>

In the file.php script $_FILES will keep all information about the file, and details are shown below.

$_FILES['file']['name'] - The file name.
$_FILES['file']['tmp_name'] - The file name with the full path.
$_FILES['file']['size'] - The file size in Byte.
$_FILES['file']['type'] - The Mime type of the file.

Using above information, the PHP script can save the file to the file system or insert the file name with full path or content of the file into the MySQL database.

Install and test Maven on CentOS 5.2

2009-02-03T21:58:00.005-05:00

1. Make sure Java has been installed on the system by running:
java --version

2. Down load the current maven, apache-maven-2.0.9-bin.tar.gz, from http://maven.apache.org/download.html.

3. untar the file to /usr/local/apache-maven-2.0.9, then create symbolic link:
ln -s apache-maven-2.0.9 maven

4. Append following to the end of ~/.bashrc:
export M2_HOME=/usr/local/maven
export PATH=${M2_HOME}/bin:${PATH}

5. Bring in the environment changes:
. ~/.bashrc

6. Check the installation:
mvn --version

7. At a local you pick to create a project that will create my-app directory:
mvn archetype:create -DgroupId=com.mycompany.app -DartifactId=my-app

8. Build and test the project:
cd my-app
mvn package
java -cp target/my-app-1.0-SNAPSHOT.jar com.mycompany.app.App

If the famous "Hello World!" comes up, the package is built correctly.

9. House keeping:
mvn clean dependency:copy-dependencies package

10. Create target:
mvn site

Fix the relogin problem for phpMyadmin CentOS 5.2

2009-02-03T20:47:00.002-05:00

If no activity for 30 minutes, phpMyadmin will log you out for security reason.

To change this, modify a line in /usr/share/phpmyadmin/config.inc.php from cookie to http from "$cfg['Servers'][$i]['auth_type'] = 'cookie';" to "$cfg['Servers'][$i]['auth_type'] = 'http';"

Inatall Eclipse on CentOS 5.2

2009-02-02T20:29:00.002-05:00

To install Eclipse on CentOS, run the following command as root:

yum install eclipse-*

After the installation, Eclipse has been created in the Application->Programming.

Rename database and table for mySQL

2009-02-02T17:00:00.004-05:00

1. Find out the database location on the system. It is at /var/lib/mysql on my CentOS 5.2. Change to that directory:
cd /var/lib/mysql

2. Stop mySQL server:
/etc/init.d/mysql stop

3. Rename the name of the database.
mv mydb.old mydb.new

4. Rename the table files in the new database directory:
cd mydb.new
mv oldtable.frm newtable.frm
mv oldtable.MYD newtable.MYD
mv oldtable.MYI newtable.MYI

5. Start mySQL server:
/etc/init.d/mysql start

Tomcat 6 on CentOS 5.2

2009-01-28T22:22:00.008-05:00

1. Download jdk-6u11-linux-i586-rpm.bin from http://java.sun.com/javase/downloads/index.jsp.

2. cd Desktop; . jdk-6u11-linux-i586-rpm.bin

3. As root, insert following lines in /etc/profile
export JAVA_HOME=/usr/java/default
export PATH=$PATH:$JAVA_HOME/bin
export CLASSPATH=.:$JAVA_HOME/jre/lib:$JAVA_HOME/lib:$JAVA_HOME/lib/tools.jar

4. . /etc/profile

5. mkdir /tmp; cd /tmp

6. wget http://ftp.sh.cvut.cz/MIRRORS/apache/tomcat/tomcat-6/v6.0.18/bin/apache-tomcat-6.0.18.tar.gz

7. tar xvzf apache-tomcat-6.0.18.tar.gz

8. mv -f apache-tomcat-6.0.18 /usr/share/tomcat6

9. chown -R tomcat /usr/share/tomcat6

10. ln -s /usr/share/tomcat6 /usr/share/tomcat

11. useradd -d /usr/share/tomcat -s /sbin/nologin tomcat

12. Create /etc/init.d/tomcat as shown below:

# Tomcat auto-start
#
# description: Auto-starts tomcat
# processname: tomcat
# pidfile: /var/run/tomcat.pid

export JAVA_HOME=/usr/java/default

case $1 in
start)
sh /usr/share/tomcat6/bin/startup.sh
;;
stop)
sh /usr/share/tomcat6/bin/shutdown.sh
;;
restart)
sh /usr/share/tomcat6/bin/shutdown.sh
sh /usr/share/tomcat6/bin/startup.sh
;;
esac
exit 0

13. chmod +x /etc/init.d/tomcat

14. chkconfig tomcat6 on

15. Add following into /usr/share/tomcat/conf/tomcat-users.xml:
<user username="tomcat" password="tomcat" roles="manager,admin">

16. Add $CATALINA_HOME to /etc/profile.
export CATALINA_HOME=/usr/share/tomcat

17. /etc/init.d/tomcat start

18. If the Apache Tomcat page can be found at http://localhost:8080, the installation is correct.

19. Done.

Install Guest Addition for CentOS 5.2 on VirtualBox

2009-01-27T14:52:00.002-05:00

1. Click Devices -> Install Guest Additions to bring up VBOXADDITIONS_x.x.x_xxxxx to the Desktop.

2. Startup a terminal, change to super user, then cd to /media/VBOXADDITIONS_x.x.x_xxxxx.

3. Run "yum install kernel-devel gcc" to install the kernel header files and compiler for building the new modules.

4. Run "VBoxLinuxAdditions.run" to build and install Guest Addition.

5. Eject VBOXADDITIONS_x.x.x_xxxxx from the desktop.

6. For custom screen resolutions, Insert modes in the Screen section in /etc/X11/xorg.conf as show below:

SubSection "Display"
Viewport 0 0
Depth 24
modes "1280x1024" "1272x920" "1024x768"
EndSubSection

6. Reboot the system. From System -> Preferences -> Screen Resolution, select the resolution just added.

Install LAMP on CentOS 5.2

2009-01-27T13:53:00.010-05:00

1. Install CentOS 5.2 on the system.

2. Download http://packages.sw.be/packages/rpmforce-release/rpmforge-release-0.3.6-1.el5.rf.i386.rpm. From a terminal window run "rpm -ivh rpmforge-release-0.3.6-1.el5.rf.i386.rpm".

3. From terminal terminal window, run "yum install httpd php php-mysql php-gd php-mbstring php-mcrypt mysql mysql-server phpmyadmin" as root.

4.To setup Apache server, System-> Administration -> Server Settings -> HTTP, Fill in the server name for the Apache server cwsuch as "localhost" for testing.

5. To setup mysql server System-> Administration -> Server Settings -> Services. Select mysqld, then reboot.

6. To make sure Apache server is up and running, start up Firefox, entre "http://localhost" as URL, the Apache 2 Test Page should be displayed.

7. Modify the line "$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */" in
/usr/share/phpmyadmin/config.inc.php to "$cfg['blowfish_secret'] = 'secret'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */".

8. Create a new file phpinfo.php at /var/www/html with following:
<?php phpinfo(); ?>.

9. From the Firefox, check http://localhost/phpinfo.php. The PHP information page should be displayed if the installation is correct.

10. TO assign the password for root, from the terminal window, run "mysqladmin -u root password "new password".

11. To check phpmyadmin installation, from Firefox, check http://localhost/phpmyadmin. From Welcome to phpMyAdmin page, type in the password for root
login to make sure the phpMyAdmin is installed without problem.

12. Done. LAMP server is up and running.

Search files with file size or day in UNIX

2009-01-16T17:39:00.007-05:00

To find files equal to 10KB in src directory,

find src -size 10k

To find files larger that 10KB in src directory,

find src -size +10k

To find file less than 10KB in src directory,

find src -size -10k

To find file was modified for 2 days in src directory,

find src -mtime 2

To find file was modified for less than 2 days in src directory,

find src -mtime -2

Install tomcat on Ubuntu 8.10

2008-12-16T23:09:00.021-05:00

1. Check if java get installed:
dpkg --get-selections | grep sun-java

2. Install Java:
sudo apt-get install sun-java6-jdk

3. Get tomcat from apache site:
wget http://apache.hoxt.com/tomcat/tomcat-6/v6.0.18/bin/apache-tomcat-6.0.
18.tar.gz
tar xvzf apache-tomcat-6.0.18.tar.gz

4. Move tomcat to the location:
sudo mv apache-tomcat-6.0.18 /usr/local/tomcat

5. Add following line into .bashrc file:
export JAVA_HOME=/usr/lib/jvm/java-6-sun

6. Create /etc/init.d/tomcat
# Tomcat auto-start
#
# description: Auto-starts tomcat
# processname: tomcat
# pidfile: /var/run/tomcat.pid

export JAVA_HOME=/usr/lib/jvm/java-6-sun

case $1 in
start)
sh /usr/local/tomcat/bin/startup.sh
;;
stop)
sh /usr/local/tomcat/bin/shutdown.sh
;;
restart)
sh /usr/local/tomcat/bin/shutdown.sh
sh /usr/local/tomcat/bin/startup.sh
;;
esac
exit 0

7. Change mode to executable.
sudo chmod 755 /etc/init.d/tomcat

8. Create links
sudo ln -s /etc/init.d/tomcat /etc/rc1.d/K99tomcat
sudo ln -s /etc/init.d/tomcat /etc/rc2.d/S99tomcat

9. Start up tomcat:
/etc/init.d/tomcat start

10. Check the tomcat at http://127.0.0.1:8080 with FireFox, it compains the connection rest. The port 8080 has been used by Oracle, so tomcat has to use a different port. Modify "Connector port="8080" to "Connector port="8090" in /usr/local/tomcat/config/server.xml, then restart tomcat. Re-check tomcat at http://127.0.0.1:8090 again, it works.

11. To be able to check Status and Tocat Manager, the manager ID and password have to be setup. Add following lines in /usr/local/tomcat/config/tomcat-users.xml:
<user username="ABC" password="PASSWORD" roles="tomcat,manager,admin">

Install PHP5/MySQL on Ubuntu 8.10

2008-12-10T18:18:00.002-05:00

        sudo apt-get install mysql_server apache2 php5 \
php5_mysql phpmyadmin

Install Oracle 10G EX on Ubuntu 8.10

2008-12-10T18:13:00.005-05:00

1. Add oracle site to the resources.list file

udo vi /etc/apt/sources.list
Appen "deb http://oss.oracle.com/debian unstable \
main non-free"

2.  Get key from Oracle.

wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle \
-O- | sudo apt-key add -

3. Update Oracle

sudo apt-get update

4. Install Oracle

Increase the swap space to 1G.
sudo dd if=/dev/zero of=/swapfile bs=1024 count=700000
sudo mkswap /swapfile
sudo swapon /swapfile
Add following line into /etc/fstab:
/swapfile none  swap sw  0 0

sudo apt-get install oracle-xe

5. Configure Oracle.

sudo /etc/init.d/oracle-xe configure

Install MySQL on Ubuntu 8.10

2008-12-10T18:11:00.004-05:00

1. Get MySQL server and client:

sudo apt-get install mysql-server mysql-client \
mysql-query-browser

2. Comment out bind-address 127.0.0.1 in my.cnf.
gksudo gedit /etc/mysql/my.cnf

3. set password for root:
mysqladmin -u root -p status
then enter the passwd. It still doesn't work.

4. Work around for mysql commands:
mysqladmin|mysqlshow|mysql -u root -p

Then enter the root password.

Install Apache2 on Ubuntu 8.10

2008-12-10T18:06:00.001-05:00

1. Get package and install Apache2
	sudo apt-get install apache2 php5
2. Make public_html at $HOME
	mkdir public_html
3. cd /etc/apache2/mods-enabled/
4. sudo ln -s ../mods-available/userdir.conf userdir.conf
5. sudo ln -s ../mods-available/userdir.load userdir.load
6. sudo /etc/init.d/apache2 restart