ViewVC Help

View File | Revision Log | Show Annotations | Root Listing

root/cvsroot/COMP/CMSDIST/dbs-server.spec

Comparing COMP/CMSDIST/dbs-server.spec (file contents):
Revision 1.5 by valya, Wed Feb 28 16:02:33 2007 UTC vs.
Revision 1.119 by valya, Mon Nov 2 16:16:48 2009 UTC

#	Line 1 | Line 1
1	<	### RPM cms dbs-server v00_00_12
1	>	### RPM cms dbs-server DBS_2_0_9_pre6
2	>
3	>	%define cvstag %{realversion}
4	>	# define version of DBS to use, it's schema version
5	>	%define dbs_version %{realversion}
6
3	–	%define cvstag %v
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 oracle apache-tomcat
6	<	#Requires: apache-ant apache-tomcat
8	>	Requires: apache-ant mysql mysql-deployment oracle apache-tomcat java-jdk dbs-schema dbs-libs
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	+	# DBS wants to have LibValut attached to DBS top-level dir, required by build.xml file
17	+	ln -s $DBS_LIBS_ROOT/lib LibValut
18		echo "PWD=$PWD"
19		cd Servers/JavaServer
20	+
21	+	# retrieve which DBS schema to use
22	+	#export DBS_SCHEMA=`grep "^use " $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql | awk '{print $2}' | sed "s/;//g"`
23	+	#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]}'`
24	+
25	+	# fix context.xml file
26	+	cat etc/context.xml.tobe  | sed "s/__insert_username__/dbs/g" | sed "s/__insert_password__/cmsdbs/g" | sed "s/3306/3316/g" | sed "s/maxActive=\"0\"/maxActive=\"100\"/g" > etc/context.xml
27	+
28	+	# compile DBS server code
29	+	mkdir -p bin/WEB-INF/lib
30		echo "PWD=$PWD"
31	+	source $JAVA_JDK_ROOT/etc/profile.d/init.sh
32	+	export JAVA_HOME=$JAVA_JDK_ROOT
33		ant --noconfig dist
34		cd ../../
35
36		%install
37	<	mkdir -p %i/webapps
38	<	cp -r Servers/JavaServer/* %i/webapps
37	>	mkdir -p %{i}/Servers/JavaServer/bin/WEB-INF/lib
38	>	cp -r Servers/JavaServer/* %{i}/Servers/JavaServer
39	>	ln -s $DBS_LIBS_ROOT/lib %{i}/LibValut
40	>
41	>	# copy war file
42	>	cp %{i}/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps
43	>
44	>	# create dbs init script
45	>	mkdir -p %{i}/Servers/JavaServer/bin
46	>	cat > %{i}/Servers/JavaServer/bin/dbs_init.sh << DBS_INIT_EOF
47	>	#!/bin/sh
48	>	export MYAREA=rpm_install_area
49	>	export SCRAM_ARCH=scram_arch
50	>	export APT_VERSION=apt_version
51	>	source \$MYAREA/\$SCRAM_ARCH/external/apt/\$APT_VERSION/etc/profile.d/init.sh
52	>	source \$MYAREA/%{pkgrel}/etc/profile.d/init.sh
53	>	# set DBS DBs
54	>	MYSQL_PORT=3316
55	>	MYSQL_PATH=\$MYSQL_ROOT/mysqldb
56	>	MYSQL_SOCK=\$MYSQL_PATH/mysql.sock
57	>	MYSQL_PID=\$MYSQL_PATH/mysqld.pid
58	>	MYSQL_ERR=\$MYSQL_PATH/error.log
59	>
60	>	function dbs_stop()
61	>	{
62	>	me=\`whoami\`
63	>	echo $"Stop mysqld|tomcat running under \$me account from $MYAREA area..."
64	>	ps -w -w -f -u\$me | grep mysqld | grep $MYAREA | grep \$MYSQL_PORT | grep -v grep | awk '{print "kill -9 "\$2""}'|/bin/sh
65	>	ps -w -w -f -u\$me | grep tomcat | grep $MYAREA | grep -v grep | awk '{print "kill -9 "\$2""}'|/bin/sh
66	>	}
67	>	function dbs_start()
68	>	{
69	>	echo "+++ Start up CMS MySQL daemon on port \${MYSQL_PORT} ..."
70	>	\$MYSQL_ROOT/bin/mysqld_safe --datadir=\$MYSQL_PATH --port=\$MYSQL_PORT \
71	>	--socket=\$MYSQL_SOCK --log-error=\$MYSQL_ERR --pid-file=\$MYSQL_PID --max_allowed_packet=32M &
72	>	echo "+++ Start tomcat server"
73	>	\$APACHE_TOMCAT_ROOT/bin/catalina.sh start
74	>	sleep 2
75	>	echo
76	>	echo "DBS service is ready ..."
77	>	}
78	>	function dbs_status()
79	>	{
80	>	me=\`whoami\`
81	>	dbs_mysqld=\`ps -w -w -f -u\$me | egrep "mysqld" | grep $MYAREA | grep \$MYSQL_PORT| grep -v egrep | wc -l\`
82	>	dbs_tomcat=\`ps -w -w -f -u\$me | egrep "tomcat" | grep $MYAREA | grep -v egrep | wc -l\`
83	>	if [ \${dbs_tomcat} -ne 1 ]; then
84	>	echo "Tomcat server is not running"
85	>	break
86	>	fi
87	>	if [ \${dbs_mysqld} -ne 2 ]; then
88	>	echo "MySQL server is not running"
89	>	exit 1
90	>	fi
91	>	ps -w -w -f -u\$me | grep $MYAREA | egrep "mysqld" | grep -v egrep | awk '{print "MySQLd server running, pid="\$2""}'
92	>	ps -w -w -f -u\$me | grep $MYAREA | egrep "tomcat" | grep -v egrep | awk '{print "Tomcat server running, pid="\$2""}'
93	>	echo "For more information please have a look at tomcat log:"
94	>	echo "\$APACHE_TOMCAT_ROOT/logs/catalina.out"
95	>	}
96	>
97	>	RETVAL=\$?
98	>
99	>	case "\$1" in
100	>	restart)
101	>	dbs_stop
102	>	dbs_start
103	>	;;
104	>	start)
105	>	dbs_start
106	>	;;
107	>	status)
108	>	dbs_status
109	>	;;
110	>	stop)
111	>	dbs_stop
112	>	;;
113	>	*)
114	>	echo \$"Usage: \$0 {start|stop|status|restart}"
115	>	exit 1
116	>	;;
117	>	esac
118	>
119	>	exit \$RETVAL
120	>	DBS_INIT_EOF
121	>	chmod a+x %{i}/Servers/JavaServer/bin/dbs_init.sh
122	>
123	>	mkdir -p %{i}/etc/profile.d
124	>	(echo "#!/bin/sh"; \
125	>	echo "source $ORACLE_ROOT/etc/profile.d/init.sh"; \
126	>	echo "source $MYSQL_ROOT/etc/profile.d/init.sh"; \
127	>	echo "source $MYSQL_DEPLOYMENT_ROOT/etc/profile.d/init.sh"; \
128	>	echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.sh"; \
129	>	echo "source $APACHE_ANT_ROOT/etc/profile.d/init.sh"; \
130	>	echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.sh"; \
131	>	echo "source $DBS_LIBS_ROOT/etc/profile.d/init.sh"; \
132	>	echo "source $JAVA_JDK_ROOT/etc/profile.d/init.sh"; \
133	>	echo "export JAVA_HOME=$JAVA_JDK_ROOT"
134	>	echo "export CATALINA_HOME=$APACHE_TOMCAT_ROOT"
135	>	) > %{i}/etc/profile.d/dependencies-setup.sh
136	>
137	>	(echo "#!/bin/tcsh"; \
138	>	echo "source $ORACLE_ROOT/etc/profile.d/init.csh"; \
139	>	echo "source $MYSQL_ROOT/etc/profile.d/init.csh"; \
140	>	echo "source $MYSQL_DEPLOYMENT_ROOT/etc/profile.d/init.csh"; \
141	>	echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.csh"; \
142	>	echo "source $APACHE_ANT_ROOT/etc/profile.d/init.csh"; \
143	>	echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.csh"; \
144	>	echo "source $DBS_LIBS_ROOT/etc/profile.d/init.csh"; \
145	>	echo "source $JAVA_JDK_ROOT/etc/profile.d/init.csh"; \
146	>	echo "setenv JAVA_HOME $JAVA_JDK_ROOT"
147	>	echo "setenv CATALINA_HOME $APACHE_TOMCAT_ROOT"
148	>	) > %{i}/etc/profile.d/dependencies-setup.csh
149	>
150	>
151	>	%post
152	>	%{relocateConfig}etc/profile.d/dependencies-setup.sh
153	>	%{relocateConfig}etc/profile.d/dependencies-setup.csh
154	>
155	>	# setup MySQL server
156	>	. $RPM_INSTALL_PREFIX/%{pkgrel}/etc/profile.d/init.sh
157	>	VO_CMS_SW_DIR=`echo $DBS_SERVER_ROOT | awk '{split($1,a,SCRAM_ARCH); print a[1]}' SCRAM_ARCH=$SCRAM_ARCH`
158	>	export VO_CMS_SW_DIR
159	>	$MYSQL_DEPLOYMENT_ROOT/bin/mysql-deployment.sh
160	>
161	>	# set DBS DBs
162	>	MYSQL_PORT=3316
163	>	MYSQL_PATH=$MYSQL_ROOT/mysqldb
164	>	MYSQL_SOCK=$MYSQL_PATH/mysql.sock
165	>	MYSQL_PID=$MYSQL_PATH/mysqld.pid
166	>	MYSQL_ERR=$MYSQL_PATH/error.log
167	>	# grant permissions to CMS MySQL DBS account
168	>	echo "+++ Grand permission to dbs account, DBS schema %{dbs_version} ..."
169	>	#echo "$MYSQL_ROOT/bin/mysql -udbs -pcmsdbs --socket=$MYSQL_SOCK"
170	>	echo "$DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql"
171	>	# DBS uses trigger which requires to have SUPER priveleges, so we'll create DB using root
172	>	# and delegate this to dbs account.
173	>	export DBS_SCHEMA=`grep "^use " $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql | awk '{print $2}' | sed "s/;//g"`
174	>
175	>	# check existing DBS installation
176	>	old=`mysql --vertical -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK -e "show databases" | grep "Database:" | egrep "^CMS_DBS$" | awk '{print $2}'`
177	>	if [ ! -z "$old" ]; then
178	>	# stop both tomcat and mysql servers in order to copy previous DB
179	>	echo "+++ Stop Tomcat & MySQL to perform upgrade ..."
180	>	killall -q tomcat
181	>	$MYSQL_ROOT/bin/mysqladmin -uroot -pcms --socket=$MYSQL_SOCK --port=$MYSQL_PORT shutdown
182	>	# we need to do upgrade, first let's move existing CMS_DBS
183	>	cp -r $MYSQL_ROOT/var/db/mysql/CMS_DBS $MYSQL_ROOT/var/db/mysql/CMS_DBS_$old
184	>	# start mysql since we will upgrade
185	>	echo "+++ Start up CMS MySQL daemon on port ${MYSQL_PORT} ..."
186	>	$MYSQL_ROOT/bin/mysqld_safe --datadir=$MYSQL_PATH --port=$MYSQL_PORT \
187	>	--socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --pid-file=$MYSQL_PID &
188	>	sleep 10
189	>	# perform upgrade
190	>	ver=`mysql --vertical -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK -e "select DBS_RELEASE_VERSION from SchemaVersion" CMS_DBS | grep DBS_RELEASE_VERSION | awk '{print $2}'`
191	>	upgrade_files=`ls upgrade-mysql-*.sql | sort -u | awk '{if($0 > "upgrade-mysql-"DBSVER".sql") print $0}' DBSVER=$ver`
192	>	for ufile in $upgrade_files; do
193	>	if  [ -f $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/$ufile ]; then
194	>	$MYSQL_ROOT/bin/mysql -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/$ufile
195	>	fi
196	>	done
197	>	else
198	>	# we will install fresh DBS
199	>	$MYSQL_ROOT/bin/mysql -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql
200	>	$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK --port=$MYSQL_PORT -uroot -pcms mysql -e "GRANT ALL ON ${DBS_SCHEMA}.* TO dbs@localhost;"
201	>	fi
202	>
203	>	# I need to copy/deploy DBS.war file into tomcat area
204	>	cp $DBS_SERVER_ROOT/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps
205	>
206	>	# Copy mysql jdbc driver to tomcat
207	>	cp -f $DBS_LIBS_ROOT/lib/*.jar $APACHE_TOMCAT_ROOT/common/lib
208	>
209	>	# Fix path in dbs_init.sh file since now we know install area
210	>	cat $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh | \
211	>	sed "s,scram_arch,$SCRAM_ARCH,g" | \
212	>	sed "s,apt_version,$APT_VERSION,g" | \
213	>	sed "s,rpm_install_area,$RPM_INSTALL_PREFIX,g" > \
214	>	$DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh.new
215	>	/bin/mv -f $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh.new $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh
216	>	echo "+++ Fix path in dbs_init.sh"
217	>	chmod a+x $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh
218	>
219	>	# time to start up tomcat for user
220	>	#$APACHE_TOMCAT_ROOT/bin/catalina.sh start
221	>
222	>	# kill running mysql|tomcat under my account since build is over
223	>	echo "+++ Clean-up mysqld|tomcat processes"
224	>	#ps -w -w -f -u`whoami` | egrep "mysqld|tomcat" | grep -v egrep | awk '{print "kill -9 "$2""}'
225	>	#ps -w -w -f -u`whoami` | egrep "mysqld|tomcat" | grep -v egrep | awk '{print "kill -9 "$2""}' |/bin/sh
226	>	#killall -q mysqld
227	>	#cat $MYSQL_ROOT/mysqldb/mysqld.pid
228	>	killall -q tomcat
229	>	$MYSQL_ROOT/bin/mysqladmin -uroot -pcms --socket=$MYSQL_SOCK --port=$MYSQL_PORT shutdown
230	>
231	>	# made correct link to LibValut
232	>	rm -f $DBS_SERVER_ROOT/LibValut
233	>	ln -s $DBS_LIBS_ROOT/lib $DBS_SERVER_ROOT/LibValut
234	>
235	>	echo
236	>	echo
237	>	echo "#####  IMPORTANT!!!  #####"
238	>	echo "To work with DBS you need to source init.sh file located at"
239	>	echo "$DBS_SERVER_ROOT/etc/profile.d/init.sh"
240	>	echo
241	>	echo "OR use init script to start|stop|status DBS services:"
242	>	echo "$DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh"
243	>	echo "init script file can be placed into /etc/init.d/ to allow auto-startup of DBS service"
244	>	echo "##########################"
245	>	echo
246

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines