ViewVC Help
View File | Revision Log | Show Annotations | Root Listing
root/cvsroot/COMP/CMSDIST/dbs-server.spec
(Generate patch)

Comparing COMP/CMSDIST/dbs-server.spec (file contents):
Revision 1.43 by valya, Tue May 6 16:40:47 2008 UTC vs.
Revision 1.60 by valya, Fri Oct 31 15:49:47 2008 UTC

# Line 1 | Line 1
1 < ### RPM cms dbs-server DBS_1_0_8
1 > ### RPM cms dbs-server DBS_2_0_3
2  
3 <
4 < %define cvstag %realversion
3 > %define cvstag %{realversion}
4   # define version of DBS to use, it's schema version
5 < %define dbs_version DBS_1_0_8
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
8 > Requires: apache-ant mysql mysql-deployment oracle apache-tomcat java-jdk dbs-schema dbs-libs
9  
10   %prep
11   %setup -n DBS
# Line 14 | Line 13 | Requires: apache-ant mysql mysql-deploym
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 << EOF_CONTEXT
21 < <Context path="/servlet/DBSServlet" docBase="DBSServlet" debug="5" reloadable="true" crossContext="true">
22 <     <SchemaOwner schemaowner="%{dbs_version}" />
23 <     <SupportedSchemaVersion schemaversion="%{dbs_version}" />
24 <     <SupportedClientVersions clientversions="DBS_1_0_1, DBS_1_0_5, DBS_1_0_7, DBS_1_0_8"/>
25 <     <DBSBlockConfig maxBlockSize="2000000000000" maxBlockFiles="100" />
26 <                        
27 <     <Resource name="jdbc/dbs"
28 <              auth="Container"
29 <              type="javax.sql.DataSource"
30 <              maxActive="30"
31 <              maxIdle="10"
32 <              maxWait="10000"
33 <              username="dbs"
34 <              password="cmsdbs"
35 <              driverClassName="org.gjt.mm.mysql.Driver"
36 <              url="jdbc:mysql://localhost:3316/%{dbs_version}?autoReconnect=true"/>
37 < </Context>
38 < EOF_CONTEXT
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
# Line 47 | Line 36 | cd ../../
36   %install
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
# Line 136 | Line 126 | mkdir -p %{i}/etc/profile.d
126   echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.sh"; \
127   echo "source $APACHE_ANT_ROOT/etc/profile.d/init.sh"; \
128   echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.sh"; \
129 + echo "source $DBS_LIBS_ROOT/etc/profile.d/init.sh"; \
130   echo "source $JAVA_JDK_ROOT/etc/profile.d/init.sh"; \
131   echo "export JAVA_HOME=$JAVA_JDK_ROOT"
132   echo "export CATALINA_HOME=$APACHE_TOMCAT_ROOT"
# Line 148 | Line 139 | mkdir -p %{i}/etc/profile.d
139   echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.csh"; \
140   echo "source $APACHE_ANT_ROOT/etc/profile.d/init.csh"; \
141   echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.csh"; \
142 + echo "source $DBS_LIBS_ROOT/etc/profile.d/init.csh"; \
143   echo "source $JAVA_JDK_ROOT/etc/profile.d/init.csh"; \
144   echo "setenv JAVA_HOME $JAVA_JDK_ROOT"
145   echo "setenv CATALINA_HOME $APACHE_TOMCAT_ROOT"
# Line 173 | Line 165 | MYSQL_ERR=$MYSQL_PATH/error.log
165   # grant permissions to CMS MySQL DBS account
166   echo "+++ Grand permission to dbs account, DBS schema %{dbs_version} ..."
167   #echo "$MYSQL_ROOT/bin/mysql -udbs -pcmsdbs --socket=$MYSQL_SOCK"
168 < echo "$DBS_SCHEMA_ROOT/lib/DBS-NeXtGen-MySQL_DEPLOYABLE.sql"
168 > echo "$DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql"
169   # DBS uses trigger which requires to have SUPER priveleges, so we'll create DB using root
170   # and delegate this to dbs account.
171 < $MYSQL_ROOT/bin/mysql -uroot -pcms --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql
172 < $MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "GRANT ALL ON %{dbs_version}.* TO dbs@localhost;"
171 > export DBS_SCHEMA=`grep "^use " $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql | awk '{print $2}' | sed "s/;//g"`
172 > $MYSQL_ROOT/bin/mysql -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql
173 > $MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK --port=$MYSQL_PORT -uroot -pcms mysql -e "GRANT ALL ON ${DBS_SCHEMA}.* TO dbs@localhost;"
174  
175   # I need to copy/deploy DBS.war file into tomcat area
176   cp $DBS_SERVER_ROOT/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps
177  
178   # Copy mysql jdbc driver to tomcat
179 < if [ ! -f $APACHE_TOMCAT_ROOT/common/lib/mysql-connector-java-5.0.5-bin.jar ]; then
187 < cp $DBS_SERVER_ROOT/Servers/JavaServer/lib/mysql-connector-java-5.0.5-bin.jar \
188 <   $APACHE_TOMCAT_ROOT/common/lib
189 < fi
179 > cp -f $DBS_LIBS_ROOT/lib/*.jar $APACHE_TOMCAT_ROOT/common/lib
180  
181   # Fix path in dbs_init.sh file since now we know install area
182   cat $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh | sed "s,rpm_install_area,$RPM_INSTALL_PREFIX,g" > \
# Line 202 | Line 192 | chmod a+x $DBS_SERVER_ROOT/Servers/JavaS
192   echo "+++ Clean-up mysqld|tomcat processes"
193   #ps -w -w -f -u`whoami` | egrep "mysqld|tomcat" | grep -v egrep | awk '{print "kill -9 "$2""}'
194   #ps -w -w -f -u`whoami` | egrep "mysqld|tomcat" | grep -v egrep | awk '{print "kill -9 "$2""}' |/bin/sh
195 < killall -q mysqld
195 > #killall -q mysqld
196 > #cat $MYSQL_ROOT/mysqldb/mysqld.pid
197 > $MYSQL_ROOT/bin/mysqladmin -uroot -pcms --socket=$MYSQL_SOCK --port=3316 shutdown
198   killall -q tomcat
199  
200 + # made correct link to LibValut
201 + rm -f $DBS_SERVER_ROOT/LibValut
202 + ln -s $DBS_LIBS_ROOT/lib $DBS_SERVER_ROOT/LibValut
203 +
204   echo
205   echo
206   echo "#####  IMPORTANT!!!  #####"

Diff Legend

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