COMP/CMSDIST/dbs-server.spec

### RPM cms dbs-server DBS_1_1_5

%define cvstag %{realversion}
# define version of DBS to use, it's schema version
%define dbs_version %{realversion}

Source: cvs://:pserver:anonymous@cmscvs.cern.ch:2401/cvs_server/repositories/CMSSW?passwd=AA_:yZZ3e&module=DBS/Servers/JavaServer&export=DBS&tag=-r%{cvstag}&output=/dbs-server.tar.gz
Requires: apache-ant mysql mysql-deployment oracle apache-tomcat java-jdk dbs-schema

%prep
%setup -n DBS
# kill running mysql|tomcat under my account since build is over
ps -w -w -f -u`whoami` | egrep "mysqld|tomcat" | grep -v egrep | awk '{print "kill -9 "$2""}' |/bin/sh

%build
echo "PWD=$PWD"
cd Servers/JavaServer

# retrieve which DBS schema to use
export DBS_SCHEMA=`grep "^use " $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql | awk '{print $2}' | sed "s/;//g"`
export DBS_SCHEMA_VERSION=`cat  $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql | grep "INSERT INTO SchemaVersion" | awk '{split($0,a,"\x27"); print a[2]}'`

# fix context.xml file
cat > etc/context.xml << EOF_CONTEXT
<Context path="/servlet/DBSServlet" docBase="DBSServlet" debug="5" reloadable="true" crossContext="true">
     <SchemaOwner schemaowner="${DBS_SCHEMA}" />
     <SupportedSchemaVersion schemaversion="${DBS_SCHEMA_VERSION}" />
     <SupportedClientVersions clientversions="DBS_1_0_1, DBS_1_0_5, DBS_1_0_7, DBS_1_0_8, DBS_1_0_9, DBS_1_1_2, DBS_1_1_3 "/>
     <DBSBlockConfig maxBlockSize="2000000000000" maxBlockFiles="100" />

     <Resource name="jdbc/dbs"
              auth="Container"
              type="javax.sql.DataSource"
              maxActive="30"
              maxIdle="10"
              maxWait="10000"
              username="dbs"
              password="cmsdbs"
              driverClassName="org.gjt.mm.mysql.Driver"
              url="jdbc:mysql://localhost:3316/${DBS_SCHEMA}?autoReconnect=true"/>
</Context>
EOF_CONTEXT

mkdir -p bin/WEB-INF/lib
echo "PWD=$PWD"
source $JAVA_JDK_ROOT/etc/profile.d/init.sh
export JAVA_HOME=$JAVA_JDK_ROOT 
ant --noconfig dist
cd ../../

%install
mkdir -p %{i}/Servers/JavaServer/bin/WEB-INF/lib
cp -r Servers/JavaServer/* %{i}/Servers/JavaServer

# copy war file
cp %{i}/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps

# create dbs init script
mkdir -p %{i}/Servers/JavaServer/bin
cat > %{i}/Servers/JavaServer/bin/dbs_init.sh << DBS_INIT_EOF
#!/bin/sh
export MYAREA=rpm_install_area
export SCRAM_ARCH=slc4_ia32_gcc345
source \$MYAREA/\$SCRAM_ARCH/external/apt/\$APT_VERSION/etc/profile.d/init.sh 
source \$MYAREA/%{pkgrel}/etc/profile.d/init.sh
# set DBS DBs
MYSQL_PORT=3316
MYSQL_PATH=\$MYSQL_ROOT/mysqldb
MYSQL_SOCK=\$MYSQL_PATH/mysql.sock
MYSQL_PID=\$MYSQL_PATH/mysqld.pid
MYSQL_ERR=\$MYSQL_PATH/error.log

function dbs_stop() 
{
    me=\`whoami\`
    echo $"Stop mysqld|tomcat running under \$me account..."
    ps -w -w -f -u\$me | egrep "mysqld|tomcat" | grep -v egrep | awk '{print "kill -9 "\$2""}'|/bin/sh
}
function dbs_start()
{
    echo "+++ Start up CMS MySQL daemon on port \${MYSQL_PORT} ..."
    \$MYSQL_ROOT/bin/mysqld_safe --datadir=\$MYSQL_PATH --port=\$MYSQL_PORT \
    --socket=\$MYSQL_SOCK --log-error=\$MYSQL_ERR --pid-file=\$MYSQL_PID --max_allowed_packet=32M &
    echo "+++ Start tomcat server"
    \$APACHE_TOMCAT_ROOT/bin/catalina.sh start
    sleep 2
    echo
    echo "DBS service is ready ..."
}
function dbs_status() 
{
    me=\`whoami\`
    dbs_mysqld=\`ps -w -w -f -u\$me | egrep "mysqld" | grep -v egrep | wc -l\`
    dbs_tomcat=\`ps -w -w -f -u\$me | egrep "tomcat" | grep -v egrep | wc -l\`
    if [ \${dbs_tomcat} -ne 1 ]; then
       echo "Tomcat server is not running"
       exit 1
    fi
    if [ \${dbs_mysqld} -ne 2 ]; then
       echo "MySQL server is not running"
       exit 1
    fi
    ps -w -w -f -u\$me | egrep "mysqld" | grep -v egrep | awk '{print "MySQLd server running, pid="\$2""}'
    ps -w -w -f -u\$me | egrep "tomcat" | grep -v egrep | awk '{print "Tomcat server running, pid="\$2""}'
    echo "For more information please have a look at tomcat log:"
    echo "\$APACHE_TOMCAT_ROOT/logs/catalina.out"
}

RETVAL=\$?

case "\$1" in
 restart)
        dbs_stop
        dbs_start
        ;;
 start)
        dbs_start
        ;;
 status)
        dbs_status
        ;;
 stop)
        dbs_stop
        ;;
 *)
        echo \$"Usage: \$0 {start|stop|status|restart}"
        exit 1
        ;;
esac

exit \$RETVAL
DBS_INIT_EOF
chmod a+x %{i}/Servers/JavaServer/bin/dbs_init.sh

mkdir -p %{i}/etc/profile.d
(echo "#!/bin/sh"; \
 echo "source $ORACLE_ROOT/etc/profile.d/init.sh"; \
 echo "source $MYSQL_ROOT/etc/profile.d/init.sh"; \
 echo "source $MYSQL_DEPLOYMENT_ROOT/etc/profile.d/init.sh"; \
 echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.sh"; \
 echo "source $APACHE_ANT_ROOT/etc/profile.d/init.sh"; \
 echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.sh"; \
 echo "source $JAVA_JDK_ROOT/etc/profile.d/init.sh"; \
 echo "export JAVA_HOME=$JAVA_JDK_ROOT"
 echo "export CATALINA_HOME=$APACHE_TOMCAT_ROOT"
 ) > %{i}/etc/profile.d/dependencies-setup.sh

(echo "#!/bin/tcsh"; \
 echo "source $ORACLE_ROOT/etc/profile.d/init.csh"; \
 echo "source $MYSQL_ROOT/etc/profile.d/init.csh"; \
 echo "source $MYSQL_DEPLOYMENT_ROOT/etc/profile.d/init.csh"; \
 echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.csh"; \
 echo "source $APACHE_ANT_ROOT/etc/profile.d/init.csh"; \
 echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.csh"; \
 echo "source $JAVA_JDK_ROOT/etc/profile.d/init.csh"; \
 echo "setenv JAVA_HOME $JAVA_JDK_ROOT"
 echo "setenv CATALINA_HOME $APACHE_TOMCAT_ROOT"
 ) > %{i}/etc/profile.d/dependencies-setup.csh

 
%post
%{relocateConfig}etc/profile.d/dependencies-setup.sh
%{relocateConfig}etc/profile.d/dependencies-setup.csh

# setup MySQL server
. $RPM_INSTALL_PREFIX/%{pkgrel}/etc/profile.d/init.sh
VO_CMS_SW_DIR=`echo $DBS_SERVER_ROOT | awk '{split($1,a,SCRAM_ARCH); print a[1]}' SCRAM_ARCH=$SCRAM_ARCH`
export VO_CMS_SW_DIR
$MYSQL_DEPLOYMENT_ROOT/bin/mysql-deployment.sh

# set DBS DBs
MYSQL_PORT=3316
MYSQL_PATH=$MYSQL_ROOT/mysqldb
MYSQL_SOCK=$MYSQL_PATH/mysql.sock
MYSQL_PID=$MYSQL_PATH/mysqld.pid
MYSQL_ERR=$MYSQL_PATH/error.log
# grant permissions to CMS MySQL DBS account
echo "+++ Grand permission to dbs account, DBS schema %{dbs_version} ..."
#echo "$MYSQL_ROOT/bin/mysql -udbs -pcmsdbs --socket=$MYSQL_SOCK"
echo "$DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql"
# DBS uses trigger which requires to have SUPER priveleges, so we'll create DB using root
# and delegate this to dbs account.
$MYSQL_ROOT/bin/mysql -uroot -pcms --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "GRANT ALL ON ${DBS_SCHEMA}.* TO dbs@localhost;"

# I need to copy/deploy DBS.war file into tomcat area
cp $DBS_SERVER_ROOT/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps

# Copy mysql jdbc driver to tomcat
#if [ ! -f $APACHE_TOMCAT_ROOT/common/lib/mysql-connector-java-5.0.5-bin.jar ]; then
#cp $DBS_SERVER_ROOT/Servers/JavaServer/lib/mysql-connector-java-5.0.5-bin.jar \
#   $APACHE_TOMCAT_ROOT/common/lib
#fi
# Copy all jar files from DBS area to tomcat area.
cp -f $DBS_SERVER_ROOT/Servers/JavaServer/lib/*.jar $APACHE_TOMCAT_ROOT/common/lib

# Fix path in dbs_init.sh file since now we know install area
cat $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh | sed "s,rpm_install_area,$RPM_INSTALL_PREFIX,g" > \
    $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh.new
/bin/mv -f $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh.new $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh
echo "+++ Fix path in dbs_init.sh"
chmod a+x $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh

# time to start up tomcat for user
#$APACHE_TOMCAT_ROOT/bin/catalina.sh start

# kill running mysql|tomcat under my account since build is over
echo "+++ Clean-up mysqld|tomcat processes"
#ps -w -w -f -u`whoami` | egrep "mysqld|tomcat" | grep -v egrep | awk '{print "kill -9 "$2""}'
#ps -w -w -f -u`whoami` | egrep "mysqld|tomcat" | grep -v egrep | awk '{print "kill -9 "$2""}' |/bin/sh
killall -q mysqld
killall -q tomcat

echo
echo
echo "#####  IMPORTANT!!!  #####"
echo "To work with DBS you need to source init.sh file located at"
echo "$DBS_SERVER_ROOT/etc/profile.d/init.sh"
echo
echo "OR use init script to start|stop|status DBS services:"
echo "$DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh"
echo "init script file can be placed into /etc/init.d/ to allow auto-startup of DBS service"
echo "##########################"
echo

Revision:	1.51
Committed:	Tue May 27 20:49:20 2008 UTC (16 years, 11 months ago) by valya
Branch:	MAIN
CVS Tags:	SiteDB_300508_1, SiteDB_280508_1, WEBTOOLS-APPS_20080527_2
Changes since 1.50:	+6 -4 lines
Log Message:	Copy all DBS jar file from JavaServer area to TOMCAT one upon installation
#	Content
1	### RPM cms dbs-server DBS_1_1_5
2
3	%define cvstag %{realversion}
4	# define version of DBS to use, it's schema version
5	%define dbs_version %{realversion}
6
7	Source: cvs://:pserver:anonymous@cmscvs.cern.ch:2401/cvs_server/repositories/CMSSW?passwd=AA_:yZZ3e&module=DBS/Servers/JavaServer&export=DBS&tag=-r%{cvstag}&output=/dbs-server.tar.gz
8	Requires: apache-ant mysql mysql-deployment oracle apache-tomcat java-jdk dbs-schema
9
10	%prep
11	%setup -n DBS
12	# kill running mysql\|tomcat under my account since build is over
13	ps -w -w -f -u`whoami` \| egrep "mysqld\|tomcat" \| grep -v egrep \| awk '{print "kill -9 "$2""}' \|/bin/sh
14
15	%build
16	echo "PWD=$PWD"
17	cd Servers/JavaServer
18
19	# retrieve which DBS schema to use
20	export DBS_SCHEMA=`grep "^use " $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql \| awk '{print $2}' \| sed "s/;//g"`
21	export DBS_SCHEMA_VERSION=`cat $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql \| grep "INSERT INTO SchemaVersion" \| awk '{split($0,a,"\x27"); print a[2]}'`
22
23	# fix context.xml file
24	cat > etc/context.xml << EOF_CONTEXT
25	<Context path="/servlet/DBSServlet" docBase="DBSServlet" debug="5" reloadable="true" crossContext="true">
26	<SchemaOwner schemaowner="${DBS_SCHEMA}" />
27	<SupportedSchemaVersion schemaversion="${DBS_SCHEMA_VERSION}" />
28	<SupportedClientVersions clientversions="DBS_1_0_1, DBS_1_0_5, DBS_1_0_7, DBS_1_0_8, DBS_1_0_9, DBS_1_1_2, DBS_1_1_3 "/>
29	<DBSBlockConfig maxBlockSize="2000000000000" maxBlockFiles="100" />
30
31	<Resource name="jdbc/dbs"
32	auth="Container"
33	type="javax.sql.DataSource"
34	maxActive="30"
35	maxIdle="10"
36	maxWait="10000"
37	username="dbs"
38	password="cmsdbs"
39	driverClassName="org.gjt.mm.mysql.Driver"
40	url="jdbc:mysql://localhost:3316/${DBS_SCHEMA}?autoReconnect=true"/>
41	</Context>
42	EOF_CONTEXT
43
44	mkdir -p bin/WEB-INF/lib
45	echo "PWD=$PWD"
46	source $JAVA_JDK_ROOT/etc/profile.d/init.sh
47	export JAVA_HOME=$JAVA_JDK_ROOT
48	ant --noconfig dist
49	cd ../../
50
51	%install
52	mkdir -p %{i}/Servers/JavaServer/bin/WEB-INF/lib
53	cp -r Servers/JavaServer/* %{i}/Servers/JavaServer
54
55	# copy war file
56	cp %{i}/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps
57
58	# create dbs init script
59	mkdir -p %{i}/Servers/JavaServer/bin
60	cat > %{i}/Servers/JavaServer/bin/dbs_init.sh << DBS_INIT_EOF
61	#!/bin/sh
62	export MYAREA=rpm_install_area
63	export SCRAM_ARCH=slc4_ia32_gcc345
64	source \$MYAREA/\$SCRAM_ARCH/external/apt/\$APT_VERSION/etc/profile.d/init.sh
65	source \$MYAREA/%{pkgrel}/etc/profile.d/init.sh
66	# set DBS DBs
67	MYSQL_PORT=3316
68	MYSQL_PATH=\$MYSQL_ROOT/mysqldb
69	MYSQL_SOCK=\$MYSQL_PATH/mysql.sock
70	MYSQL_PID=\$MYSQL_PATH/mysqld.pid
71	MYSQL_ERR=\$MYSQL_PATH/error.log
72
73	function dbs_stop()
74	{
75	me=\`whoami\`
76	echo $"Stop mysqld\|tomcat running under \$me account..."
77	ps -w -w -f -u\$me \| egrep "mysqld\|tomcat" \| grep -v egrep \| awk '{print "kill -9 "\$2""}'\|/bin/sh
78	}
79	function dbs_start()
80	{
81	echo "+++ Start up CMS MySQL daemon on port \${MYSQL_PORT} ..."
82	\$MYSQL_ROOT/bin/mysqld_safe --datadir=\$MYSQL_PATH --port=\$MYSQL_PORT \
83	--socket=\$MYSQL_SOCK --log-error=\$MYSQL_ERR --pid-file=\$MYSQL_PID --max_allowed_packet=32M &
84	echo "+++ Start tomcat server"
85	\$APACHE_TOMCAT_ROOT/bin/catalina.sh start
86	sleep 2
87	echo
88	echo "DBS service is ready ..."
89	}
90	function dbs_status()
91	{
92	me=\`whoami\`
93	dbs_mysqld=\`ps -w -w -f -u\$me \| egrep "mysqld" \| grep -v egrep \| wc -l\`
94	dbs_tomcat=\`ps -w -w -f -u\$me \| egrep "tomcat" \| grep -v egrep \| wc -l\`
95	if [ \${dbs_tomcat} -ne 1 ]; then
96	echo "Tomcat server is not running"
97	exit 1
98	fi
99	if [ \${dbs_mysqld} -ne 2 ]; then
100	echo "MySQL server is not running"
101	exit 1
102	fi
103	ps -w -w -f -u\$me \| egrep "mysqld" \| grep -v egrep \| awk '{print "MySQLd server running, pid="\$2""}'
104	ps -w -w -f -u\$me \| egrep "tomcat" \| grep -v egrep \| awk '{print "Tomcat server running, pid="\$2""}'
105	echo "For more information please have a look at tomcat log:"
106	echo "\$APACHE_TOMCAT_ROOT/logs/catalina.out"
107	}
108
109	RETVAL=\$?
110
111	case "\$1" in
112	restart)
113	dbs_stop
114	dbs_start
115	;;
116	start)
117	dbs_start
118	;;
119	status)
120	dbs_status
121	;;
122	stop)
123	dbs_stop
124	;;
125	*)
126	echo \$"Usage: \$0 {start\|stop\|status\|restart}"
127	exit 1
128	;;
129	esac
130
131	exit \$RETVAL
132	DBS_INIT_EOF
133	chmod a+x %{i}/Servers/JavaServer/bin/dbs_init.sh
134
135	mkdir -p %{i}/etc/profile.d
136	(echo "#!/bin/sh"; \
137	echo "source $ORACLE_ROOT/etc/profile.d/init.sh"; \
138	echo "source $MYSQL_ROOT/etc/profile.d/init.sh"; \
139	echo "source $MYSQL_DEPLOYMENT_ROOT/etc/profile.d/init.sh"; \
140	echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.sh"; \
141	echo "source $APACHE_ANT_ROOT/etc/profile.d/init.sh"; \
142	echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.sh"; \
143	echo "source $JAVA_JDK_ROOT/etc/profile.d/init.sh"; \
144	echo "export JAVA_HOME=$JAVA_JDK_ROOT"
145	echo "export CATALINA_HOME=$APACHE_TOMCAT_ROOT"
146	) > %{i}/etc/profile.d/dependencies-setup.sh
147
148	(echo "#!/bin/tcsh"; \
149	echo "source $ORACLE_ROOT/etc/profile.d/init.csh"; \
150	echo "source $MYSQL_ROOT/etc/profile.d/init.csh"; \
151	echo "source $MYSQL_DEPLOYMENT_ROOT/etc/profile.d/init.csh"; \
152	echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.csh"; \
153	echo "source $APACHE_ANT_ROOT/etc/profile.d/init.csh"; \
154	echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.csh"; \
155	echo "source $JAVA_JDK_ROOT/etc/profile.d/init.csh"; \
156	echo "setenv JAVA_HOME $JAVA_JDK_ROOT"
157	echo "setenv CATALINA_HOME $APACHE_TOMCAT_ROOT"
158	) > %{i}/etc/profile.d/dependencies-setup.csh
159
160
161	%post
162	%{relocateConfig}etc/profile.d/dependencies-setup.sh
163	%{relocateConfig}etc/profile.d/dependencies-setup.csh
164
165	# setup MySQL server
166	. $RPM_INSTALL_PREFIX/%{pkgrel}/etc/profile.d/init.sh
167	VO_CMS_SW_DIR=`echo $DBS_SERVER_ROOT \| awk '{split($1,a,SCRAM_ARCH); print a[1]}' SCRAM_ARCH=$SCRAM_ARCH`
168	export VO_CMS_SW_DIR
169	$MYSQL_DEPLOYMENT_ROOT/bin/mysql-deployment.sh
170
171	# set DBS DBs
172	MYSQL_PORT=3316
173	MYSQL_PATH=$MYSQL_ROOT/mysqldb
174	MYSQL_SOCK=$MYSQL_PATH/mysql.sock
175	MYSQL_PID=$MYSQL_PATH/mysqld.pid
176	MYSQL_ERR=$MYSQL_PATH/error.log
177	# grant permissions to CMS MySQL DBS account
178	echo "+++ Grand permission to dbs account, DBS schema %{dbs_version} ..."
179	#echo "$MYSQL_ROOT/bin/mysql -udbs -pcmsdbs --socket=$MYSQL_SOCK"
180	echo "$DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql"
181	# DBS uses trigger which requires to have SUPER priveleges, so we'll create DB using root
182	# and delegate this to dbs account.
183	$MYSQL_ROOT/bin/mysql -uroot -pcms --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql
184	$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "GRANT ALL ON ${DBS_SCHEMA}.* TO dbs@localhost;"
185
186	# I need to copy/deploy DBS.war file into tomcat area
187	cp $DBS_SERVER_ROOT/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps
188
189	# Copy mysql jdbc driver to tomcat
190	#if [ ! -f $APACHE_TOMCAT_ROOT/common/lib/mysql-connector-java-5.0.5-bin.jar ]; then
191	#cp $DBS_SERVER_ROOT/Servers/JavaServer/lib/mysql-connector-java-5.0.5-bin.jar \
192	# $APACHE_TOMCAT_ROOT/common/lib
193	#fi
194	# Copy all jar files from DBS area to tomcat area.
195	cp -f $DBS_SERVER_ROOT/Servers/JavaServer/lib/*.jar $APACHE_TOMCAT_ROOT/common/lib
196
197	# Fix path in dbs_init.sh file since now we know install area
198	cat $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh \| sed "s,rpm_install_area,$RPM_INSTALL_PREFIX,g" > \
199	$DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh.new
200	/bin/mv -f $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh.new $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh
201	echo "+++ Fix path in dbs_init.sh"
202	chmod a+x $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh
203
204	# time to start up tomcat for user
205	#$APACHE_TOMCAT_ROOT/bin/catalina.sh start
206
207	# kill running mysql\|tomcat under my account since build is over
208	echo "+++ Clean-up mysqld\|tomcat processes"
209	#ps -w -w -f -u`whoami` \| egrep "mysqld\|tomcat" \| grep -v egrep \| awk '{print "kill -9 "$2""}'
210	#ps -w -w -f -u`whoami` \| egrep "mysqld\|tomcat" \| grep -v egrep \| awk '{print "kill -9 "$2""}' \|/bin/sh
211	killall -q mysqld
212	killall -q tomcat
213
214	echo
215	echo
216	echo "##### IMPORTANT!!! #####"
217	echo "To work with DBS you need to source init.sh file located at"
218	echo "$DBS_SERVER_ROOT/etc/profile.d/init.sh"
219	echo
220	echo "OR use init script to start\|stop\|status DBS services:"
221	echo "$DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh"
222	echo "init script file can be placed into /etc/init.d/ to allow auto-startup of DBS service"
223	echo "##########################"
224	echo
225