Installation of tomcat in linux

First download package

then extract the package

[bbusschots@honeysuckle ~]$ tar -xzf apache-tomcat-5.5.17.tar.gz
[bbusschots@honeysuckle ~]$ sudo mv apache-tomcat-5.5.17 /usr/local/
[bbusschots@honeysuckle ~]$ cd /usr/local/
[bbusschots@honeysuckle local]$ sudo ln -s apache-tomcat-5.5.17/ tomcat


Perform the above action

setting environment variables
-----------------------------------------


1. JAVA_HOME - needs to point to your Java install. (If you used the latest Sun RPM
that will be /usr/java/jdk1.5.0_6)
2. CATALINA_HOME - should be set to /usr/local/tomcat


BY USING

[root@cit146 bin]# export JAVA_HOME=/usr/java/jdk1.6.0_03/

[root@cit146 bin]# export CATALINA_HOME=/usr/local/tomcat

You are now ready to start Tomcat with the command /usr/local/tomcat/bin/startup.sh and stop Tomcat with the command /usr/local/tomcat/bin/shutdown.sh.

Tomcat will not start automatically at boot though.

Note : [root@cit146 bin]# ./startup.sh
Using CATALINA_BASE: /usr/local/tomcat
Using CATALINA_HOME: /usr/local/tomcat
Using CATALINA_TMPDIR: /usr/local/tomcat/temp
Using JRE_HOME: /usr/java/jdk1.6.0_03/
touch: cannot touch `/usr/local/tomcat/logs/catalina.out': No such file or directory

solution : we make a logs directory in /usr/local/tomcat/

[root@cit146 bin]# ./startup.sh
Using CATALINA_BASE: /usr/local/tomcat
Using CATALINA_HOME: /usr/local/tomcat
Using CATALINA_TMPDIR: /usr/local/tomcat/temp
Using JRE_HOME: /usr/java/jdk1.6.0_03/


show the status
---------------------

[root@cit146 tomcat]# cd logs

[root@cit146 logs]# tail -100f catalina.out


Nov 26, 2008 4:04:50 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/jdk1.6.0_03/jre/lib/i386/server:/usr/java/jdk1.6.0_03/jre/lib/i386:/usr/java/jdk1.6.0_03/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
Nov 26, 2008 4:04:50 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 26, 2008 4:04:50 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1129 ms
Nov 26, 2008 4:04:50 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Nov 26, 2008 4:04:50 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.20
Nov 26, 2008 4:04:50 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Nov 26, 2008 4:04:51 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Nov 26, 2008 4:04:52 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Nov 26, 2008 4:04:52 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/23 config=null
Nov 26, 2008 4:04:52 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Nov 26, 2008 4:04:52 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 1483 ms





Detail available in http://www.bartbusschots.ie/blog/?p=240

mysql dump

how import or export a database from localhost or other host

[ note :

Export

[root@cit146 Desktop]# mysqldump -u root -ppassword -h 192.168.1.88 -P4001 qadb_1 >88_qadb_1.sql

then we create a database in a particular instance......

import

[root@cit146 Desktop]#mysql -u root -ppassword -h 192.168.1.146 -P4001 qadb_2 <88_qadb_1.sql

ERROR 1031 (HY000) at line 4560: Table storage engine for 'event_summary_watchedchapter1' doesn't have this option

debugging
---------------

1) show create table event_summary_watchedchapter1; // to show internal structure

In this stucture Engine =federated table

so go to vim *.sql

delete(double time press d) dump process in the editor

2) second thought is federated table link to the unreachable host or unknown table

it is always known by status or show create table command

install

to show all java version in ur sys


/usr/sbin/alternatives --config java


java -version


-------------------------------------------------
The simplest way to install or uninstall a packages in linux

by using yum tool...

for ex. yum install eclipse

the installation file will be store in /usr/share/eclipse


------------------------------------------------------------------------------------

yum

yum is a software package manager. It is a tool for installing, updating, and removing packages and their dependencies on RPM-based systems.

It automatically computes dependencies and figures out what things should occur to install packages. It makes it easier to maintain groups of machines without having to manually update each one using rpm.


advantage
----------------

** It can change to new mirrors on the fly out of a internet based mirror list.

when your usual mirrors brakes down yum jumps to another one (chosen by chance) which make it very smooth to use the tool even if there are heavy problems with some of the main mirrors. It also balances the load on the servers.

** Package signature tests, the keys can be downloaded from a given internet address

it adds a tiny bit more of security ....

---------------------------------------------------------------------------



to access the shared documents

smb://192.168.1.200/g/shared


------------------------------------------------------------------


mysql version

mysql Ver 14.12 Distrib 5.0.50sp1a, for redhat-linux-gnu (i686) using readline 5.0


rem pts:

paste a mysql folder to /var/lib/mysal3310/..... it contains some of .myd ,.frm files.....

because it is used to create .sock and .pid files

mysql -u demouser -p -h 192.168.1.88 -P 3310

3310 denote the port no..

this instance start by using mysqld_multi start 3310;

running instances show by mysqld_multi report;


squirrel installation:

download a squirrel-sql-2.6.8-install.jar file;

then it is open by java application;

installation is complted;

make mysql server connection:

edit the extra class path /home/cit146/workspace/yumeetl/lib/mysql.jar

class name as com.mysql.jdbc.Driver

Add aliases

select driver as mysqlserver

example url dbc:mysql://192.168.1.88:3309/qa_martdb_2_0

user name root

click---- test