COMP/CMSDIST/dbs-server.spec

### RPM cms dbs-server DBS_1_0_9

%define cvstag %v
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
# fix context.xml file
cat > etc/context.xml << EOF_CONTEXT
<Context path="/servlet/DBSServlet" docBase="DBSServlet" debug="5" reloadable="true" crossContext="true">
     <SupportedSchemaVersion schemaversion="DBS_1_0_8" />
     <SupportedClientVersions clientversions="DBS_1_0_1, DBS_1_0_5, DBS_1_0_7, DBS_1_0_8, DBS_1_0_9"/>
     <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/%{cvstag}?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/0.5.15lorg3.2-CMS3/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 &
    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 DB ${DBS_SCHEMA_VERSION} ..."
#echo "$MYSQL_ROOT/bin/mysql -udbs -pcmsdbs --socket=$MYSQL_SOCK"
echo "$DBS_SCHEMA_ROOT/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/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "GRANT ALL ON ${DBS_SCHEMA_VERSION}.* 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

echo
echo
echo "#####  IMPORTANT!!!  #####"
echo "For your convinience we created"
echo "$DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh"
echo "init script file which can be placed into /etc/init.d/ to allow auto-startup of DBS service"
echo "##### END OF README  #####"
echo
# 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
mv  $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh.new $DBS_SERVER_ROOT/Servers/JavaServer/bin/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
ps -w -w -f -u`whoami` | egrep "mysqld|tomcat" | grep -v egrep | awk '{print "kill -9 "$2""}' |/bin/sh
Revision:	1.29
Committed:	Wed Feb 6 20:38:27 2008 UTC (17 years, 2 months ago) by valya
Branch:	MAIN
CVS Tags:	CRABSERVER_1_1_3_pre2_BUILD_SLC5, CRABSERVER_1_1_3_pre1_BUILD_SLC5, CRABSERVER_1_1_2_py26_BUILD_SLC5, CRABSERVER_1_1_2_BUILD_SLC5, CRABSERVER_1_1_2_pre1_BUILD_SLC5, CRABSERVER_1_1_2_beta_BUILD_SLC5, CRABSERVER_1_1_2_beta_BUILD_SLC4, CRABSERVER_1_1_1_BUILD_SLC4, CRABSERVER_1_1_1_BUILD_SLC5, dg20100323-prodagent, CRABSERVER_1_1_1_pre12_BUILD_SLC5, CRABSERVER_1_1_1_pre10_BUILD_SLC5, CRABSERVER_1_1_1_pre9_BUILD_SLC4, CRABSERVER_1_1_1_pre9_BUILD_SLC5, CRABSERVER_1_1_1_pre8_BUILD_SLC5, CRABSERVER_1_1_1_pre7_BUILD_SLC5, CRABSERVER_1_1_1_pre7_BUILD_SLC4, CRABSERVER_1_1_1_pre6_BUILD_SLC4, CRABSERVER_1_1_1_pre6_BUILD_SLC5, CMSSW_3_3_6_patch6, sm100215, CRABSERVER_1_1_1_pre5_BUILD_SLC5, CRABSERVER_1_1_1_pre5_BUILD_SLC4, CMSSW_3_3_6_patch5, apFor336p5v1, DQMGUI_5_1_6, CMSSW_3_3_6_patch4, apFor336p5v0, for336patch4, CRABSERVER_1_1_1_pre4_BUILD_SLC5, CRABSERVER_1_1_1_pre4_BUILD_SLC4, CRABSERVER_1_1_1_pre3_BUILD_SLC5_1, CRABSERVER_1_1_1_pre3_BUILD_SLC4, CRABSERVER_1_1_1_pre3_BUILD_SLC5, CRABSERVER_1_1_1_pre3_BUILD_OK, CS_1_1_1_slc4_1_BUILD, CMSSW_3_3_3_TSG, CS_1_1_1_test1_SLC4_BUILD, CS_1_1_1_test1_BUILD, CS_1_1_1_slc5_BUILD, CS_1_1_1_slc4_BUILD, ds20100115_cs_SLC5_workOK, sm100115-333tsg, CS_SLC5_test_4, CRABSERVER_CS_SLC5_test_3_BUILD, dg20091218c-crabserver, dg20091215c-crabserver, dg20091218b-crabserver, dg20091218-crabserver, CMSSW_3_3_6_patch3, apFor336p3v0, CRABSERVER_1_1_1_pre3_BUILD, CRABSERVER_1_1_1_pre2_BUILD, dg20091215b-crabserver, dg20091215-crabserver, CMSSW_3_3_6_patch1, eskFor336ptch1, DQMGUI_5_1_5, CMSSW_3_3_6, apFor336v0, CMSSW_3_3_5_patch4, apFor335p4v0, CMSSW_3_3_5_patch3, apFor335p3v0, CMSSW_3_3_5_patch2, CRABSERVER_1_1_1_pre1_BUILD, apFor335p2v0, CMSSW_3_3_5_patch1, apFor335pat1v2, apFor335pat1v1, apFor335pat1v0, lsFor335patch1, lsFOR335patch1v0, CMSSW_3_3_5, apFor335v0, pe20091126a-for33X-slc4-gcc345, CMSSW_3_1_6, bhFor316v0, DQMGUI_5_1_5_pre1, DQMGUI_5_1_4, CMSSW_3_3_4, apFor334v0, CMSSW_3_3_3_DQM, apFor333dqmv0, CRABSERVER_1_1_0_BUILD, CMSSW_3_3_3_patch1, lmFor333pat1v0, ap20091114a, ap20091114, CMSSW_3_3_3, CMSSW_3_1_5, pe20091113a-for33X-slc4-gcc345, apFor333v1, apFor333v0, bhFor315v0, bhFor314v0, pe20091110c-for33X-slc4-gcc345, pe20091110b-for33X-slc4-gcc345, pe20091110a-for33X-slc4-gcc345, CRABSERVER_1_1_0_pre7_BUILD, pe20091109a-for33X-slc4-gcc345, DQMGUI_5_1_3, DQMGUI_5_1_2, pe20091103a-for34X, DQMGUI_5_1_1, CRABSERVER_1_1_0_pre6_BUILD, ge20091102-qt-conf, apFor332fwlv1, CMSSW_3_3_2, DQMGUI_5_1_0, pe20091031a-for34X, apFor332v0, pe20091030a-for34X, apFor331fwlv1, apFor331fwlv0, CMSSW_3_3_1, pe20091022a-for33X, pe20091021a-for33X, CMSSW_3_4_0_pre2, CRABSERVER_1_1_0_pre5_BUILD, sm340p2, CMSSW_3_2_8, CMSSW_3_3_0, eskFor328, apFor330v0, pe20091009a-for33X, pe20091008d-for33X, CMSSW_3_4_0_pre1, CRABSERVER_1_1_0_pre4_BUILD, pe20091006a-for33X, CMSSW_3_1_4, CRABSERVER_1_1_0_pre3_BUILD, CMSSW_3_3_0_pre6, apFor330pre6v0, CRABSERVER_1_0_10_BUILD, pe20090929a-for33X, ap20090929a-for33X, ap20090929-for33X, CMSSW_3_3_0_pre5, apFor330pre5v0, pe20090925a-for33X, pe20090924b-for33X, CRABSERVER_1_0_10_pre1_BUILD, pe20090924a-for33X, CMSSW_3_1_3, pe20090923b-for33X, pe20090923a-for33X, pe20090922e-for33X, pe20090922c-for33X, pe20090922a-for33X, CMSSW_3_2_7, pe20090921d-for33X, pe20090921c-for33X, pe20090921b-for33X, pe20090921a-ports, CMSSW_3_3_0_pre4, apFor330pre4v0, eskFor327, pe20090918a-ports, CRABSERVER_1_1_0_pre2_BUILD, CMSSW_3_3_0_pre3, apFor330pre3v0, pe20090907a-for33X, CMSSW_3_3_0_pre2, apFor330pre2v1, CMSSW_3_2_6, CRABSERVER_1_1_0_pre1_BUILD, pe20090904a-for33X, pe20090903b-for33X, eskFor326, pe20090903-for33X, CMSSW_3_3_0_pre1, esk090827, pe20090827a-33X, pe20090826a-33X, CMSSW_3_2_5, smFor325v0, eskFor325, CMSSW_3_2_4_patch1, CMSSW_3_2_4, sm324p1a, CMSSW_3_2_3, apFor323v1, apFor323v0, DQMGUI_5_0_2, DQMGUI_5_0_1, DQMGUI_5_0_0, CMSSW_3_2_2_patch2, apFor322patch2v0, CRABSERVER_1_0_9_BUILD, CMSSW_3_2_2_patch1, apFor322pa1v0, CMSSW_3_2_2, CMSSW_3_1_2, apFor322v0, dl090723, CRABSERVER_1_0_9_pre3_BUILD, CRABSERVER_1_0_9_pre2_BUILD, CRABSERVER_1_0_9_pre1_BUILD, CRABSERVER_1_0_9_pre1, CMSSW_3_2_1, apFor321v0, apFor320onlv0, CMSSW_3_2_0, apFor320v1, apFor320v0, CMSSW_3_1_1_patch1, sm090716a_off, CMSSW_3_1_1_reallyThisTime, CMSSW_3_1_1, dl090707, CMSSW_2_2_13_offpatch1, apFor2213offpatch1v0, CMSSW_3_1_0_patch1, CMSSW_3_1_0, CMSSW_3_1_0_pre11, CMSSW_2_2_13_FWLITE, apFor2213fwlitev0, CRABSERVER_1_0_8_BUILD, CRABSERVER_1_0_8_pre7_BUILD, dl090623, CRABSERVER_1_0_8_pre6_BUILD, CRABSERVER_1_0_8_pre5_BUILD, CMSSW_3_1_0_pre10, dl090611, CMSSW_3_1_0_pre9, CRABSERVER_1_0_8_pre4_BUILD, CMSSW_2_2_13_HLT, apFor2213hltv0, CMSSW_2_2_13, apFor2213v0, CMSSW_2_2_12_HLT, CMSSW_2_2_12, apFor2212hltv0, CMSSW_3_1_0_pre8, apFor2212v2, apFor2212v1, apFor2212v0, apFor2211off1v0, CMSSW_2_2_11_offpatch1, CRABSERVER_1_0_8_pre3_BUILD, condcore306, dl090520t2, dl090520, CMSSW_2_2_11, CMSSW_2_2_11_HLT, apFor2211v1, apFor2211hltv0, apFor2211v0, CMSSW_3_1_0_pre7, dl090514t3, dl090514t2, dl090514, CMSSW_2_2_10_HLT, apFor2210hltv0, CRABSERVER_1_0_8_pre2_BUILD, CMSSW_2_2_10, dl090509, apFor2210v0, dl090504gcc41, dl090504, CMSSW_3_1_0_pre6, dl090425, CMSSW_2_2_9, apFor229v2, apFor229v1, apFor229v0, dl090421, apFor2119v1, apFor2119v0, CMSSW_2_2_8, apFor228v0, CMSSW_3_1_0_pre5, dl090416, dl090410, dl090409t2, dl090409, dl090406t2, dl090406, dl090403, dl090401t2, dl090401, dl090330, dl090329, dl0903029, CMSSW_2_2_7, apFor227v2, CMSSW_3_1_0_pre4, CMSSW_2_2_6_HLT_ONLINE1, nr090319_for226hltonl1, pe20090318b-for31X-412, pe20090318b-for31X, pe20090318-for31X, CMSSW_2_2_6_HLT_ONLINE, apFor227v1, dl090317t2, dl090317, apFor227v0, CMSSW_2_2_6_onlpatch1_ONLINE, CMSSW_2_2_6_ONLINE, CMSSW_2_2_6_HLT, apFor226HLTv0, CRABSERVER_1_0_8_pre1_BUILD, CMSSW_2_2_6, nr090307for226_onlpatch1, CMSSW_3_1_0_pre3, apFor226v3, nr090306onl226_tkonlsw_too_new, pe20090304-for31X-412, pe20090304-for31X, pe20090304b-30Xports-432, pe20090304a-30Xports-432, dl090304_cmsswtoolconf9cms_gcc412, dl090304_cmsswtoolconf9cms, apFor226v2, apFor226v1, dl090302_cmsswtoolconf9gcc412, dl090302_cmsswtoolconf9, dl090301, apFor226v0, apFor226, pe20090226b-30Xports-432, pe20090226a-30Xports-432, CMSSW_3_1_0_pre2, pe20090225d-for30XIB-412, pe20090225d-for30XIB, pe20090225c-for30XIB, pe20090225b-for30XIB-412, pe20090225b-for30XIB, pe20090225a-for30XIB, nr20090224_for226, CMSSW_3_1_0_pre1, pe20090224b-30Xports-432, pe20090224a-30Xports-432, pe20090224c-for30XIB-412, pe20090224c-for30XIB, pe20090224b-for30XIB-412, pe20090224b-for30XIB, pe20090224a-for30XIB-412, pe20090224a-for30XIB, CMSSW_3_0_0_pre10, sm080219a, pe20090218a-30Xports-432, pe20090216b-30Xports-432, pe20090216a-30Xports-432, CMSSW_3_0_0_pre9, pe20090213b-for30X-412, pe20090213b-for30X, pe20090213-for30X-412, pe20090213-for30X, CMSSW_2_2_5, apFor225v0, condcore305, CRABSERVER_1_0_7_BUILD, CRABSERVER_1_0_7_pre4_BUILD, condcore304, CRABSERVER_1_0_7_pre3_BUILD, condcore303, pe20090205-for30X, CMSSW_2_2_4, apFor224v4, apFor224v3, pe20090202-for30X, dl090131-412, dl090131, apFor224v2, apFor224v1, apFor224v0, CRABSERVER_1_0_7_pre2_BUILD, smFor224v0, pe20090127c-30Xports-432, pe20090127b-30Xports-432, pe20090127a-30Xports-432, CRABSERVER_1_0_7_pre1_BUILD, pe20090125a-30Xports-432, CMSSW_3_0_0_pre8, pe20090124b-for30X-root522-412, pe20090124b-for30X-root522, pe20090124a-for30X-root522-412, pe20090124a-for30X-root522, pe20090123b-for30X-root522-412, pe20090123b-for30X-root522, pe20090123a-for30X-root522, CMSSW_3_0_0_pre7, pe20090116a-for30X-root522, pe20090115a-for30X-root522, pe20090114c-ports, pe20090114b-ports, pe20090114a-ports, pe20090109b-for30XIB-412, pe20090109b-for30XIB, pe20090109a-for30XIB-412, pe20090109a-for30XIB, sw_20090108, CMSSW_3_0_0_pre6, CMSSW_3_0_0_pre5, pe20090107a-for30XIB-412, pe20090107a-for30XIB, CMSSW_2_2_3_FWLITE, CMSSW_3_0_0_pre4, pe20090105a-for30XIB-412, pe20090105a-for30XIB, pe20090101a-for30XIB-412, pe20090101a-for30XIB, nr081230_fwlite223, pe20081230a-for30XIB, pe20081230-for30X-newcoralpool, pe20081229-for30X-G492, PRODAGENT_0_12_9_patch1_20081219, PRODAGENT_0_12_10_20081219, PRODAGENT_0_12_9_20081218, pe20081218b-for30XIB-412, pe20081218b-for30XIB, pe20081218-for30XIB-412, pe20081218-for30XIB, pe20081216-for30XIB-412, pe20081216-for30XIB, pe20081216c-for30X, pe20081216b-for30X, pe20081216a-for30X, CMSSW_2_2_3, apFor223v0, pe20081214a-for30X, CMSSW_2_2_2, CMSSW_3_0_0_pre3, apFor222v0, PRODAGENT_0_12_8_20081211, CRABSERVER_1_0_6_BUILD, pe20081209a-for30X-412, pe20081209a-for30X, CRABSERVER_1_0_6_pre6_BUILD, CRABSERVER_1_0_6_pre5_BUILD, smFor221v1, pe20081204a-for30X-412, pe20081204a-for30X, pe20081104a-for30X, CRABSERVER_1_0_6_pre4_BUILD, apFor221v0, PRODAGENT_0_12_8_pre1_20081129, CRABSERVER_1_0_6_pre3_BUILD, pe20081125d-30Xports-432, pe20081125d-30Xports, pe20081125c-30Xports-432, pe20081125c-30Xports, pe20081125b-30Xports, pe20081125b-30Xports-432, pe20081125a-30Xports, pe20081124d-30Xports, pe20081124a-for30X-412, pe20081124a-for30X, pe20081124c-30Xports, pe20081124b-30Xports, pe20081124a-30Xports, pe20081121a-for30X-412, pe20081121a-for30X, CMSSW_2_2_0, pe20081121b-30Xports, pe20081121a-30Xports, apFor220v0, PRODAGENT_BUILD_TEST_0_0_5_20081120, PRODAGENT_BUILD_TEST_0_0_4_20081120, PRODAGENT_BUILD_TEST_0_0_3_20081120_V1, PRODAGENT_BUILD_TEST_0_0_3_20081120, CRABSERVER_1_0_6_pre2_BUILD, CMSSW_2_1_17, PRODAGENT_0_12_7_20081118_V3, PRODAGENT_0_12_7_20081118_V2, PRODAGENT_0_12_7_20081118_V1, PRODAGENT_0_12_7_20081118, apFor2117v1, apFor2117v0, pe20081117a-for30X-412, pe20081117a-for30X, CRABSERVER_1_0_6_pre1_BUILD, CRABSERVER_1_0_5_BUILD, CRABSERVER_1_0_5_pre5_BUILD, CMSSW_3_0_0_pre2, PRODAGENT_0_12_7_pre2_20081110, pe20081110a-for30X, pe20081108a-for30X-412, pe20081108a-for30X, CRABSERVER_1_0_5_pre4_BUILD, CMSSW_2_2_0_pre1, apFor220p1v1, apFor220p1v0, pe20081107a-for30X-412, pe20081107a-for30X, pe20081105-noseal, CRABSERVER_1_0_5_TEST_2_BUILD, CRABSERVER_1_0_5_TEST_1_BUILD, CRABSERVER_1_0_5_TEST_BUILD, pe20081031b-for30X-412, pe20081031b-for30X, pe20081031-for30X-412, pe20081031-for30X, PRODAGENT_0_12_6_20081030, CMSSW_2_1_12, apFor2112v0, CMSSW_3_0_0_pre1, CMSSW_2_1_10_patch2, DQMGUI_4_2_6c, DQMGUI_4_2_6b, CMSSW_2_1_10_patch1, PRODAGENT_0_12_5_20081016, CRABSERVER_104_BUILD, CRABSERVER_TEST_BUILD_V14, CRABSERVER_TEST_BUILD_V13, CMSSW_2_1_10, CRABSERVER_TEST_BUILD_V12, PRODAGENT_0_12_4_20081009, apFor2110v2-gcc412, apFor2110v2, apFor2110v1-gcc412, apFor2110v1, PRODAGENT_0_12_3_20081009, CRABSERVER_TEST_BUILD_V11, DQMGUI_4_2_6, apFor2110v0-gcc412, apFor2110v0, PRODAGENT_0_12_2_20081001_V3, PRODAGENT_0_12_2_20081001_V2, PRODAGENT_0_12_2_20081001_V1, PRODAGENT_0_12_2_20081001, CMSSW_2_1_9_ONLINE, CRABSERVER_TEST_BUILD_V10, CRABSERVER_TEST_BUILD_V9, CRABSERVER_TEST_BUILD_V8, CMSSW_2_1_7_FWLITE, CMSSW_2_1_9, apFor219v0, PRODAGENT_0_12_1_20090916, PRODAGENT_0_12_0_20090915_V2, PRODAGENT_0_12_0_20090915, CMSSW_2_1_8, apFor218v0, apFor217patch1v1, DQMGUI_4_2_4, DQMGUI_4_2_3, PRODAGENT_BUILD_TEST_0_0_2_20090912, CRABSERVER_TEST_BUILD_V7, CRABSERVER_TEST_BUILD_V6, CRABSERVER_TEST_BUILD_V5, apFor217patch1v0, DQMGUI_4_2_2c, DQMGUI_4_2_2, DQMGUI_4_2_1d, DQMGUI_4_2_1c, DQMGUI_4_2_1b, DQMGUI_4_2_1, DQMGUI_4_2_0, CMSSW_2_1_7, CMSSW_2_1_, apFor217v1, apFor217v0, CMSSW_2_1_6, apFor216v0, PRODAGENT_0_11_8_20080901, CMSSW_2_1_5, PRODAGENT_0_12_0_pre3_20080828, apFor215v1, apFor215v0, T0Mon_080826_1, CMSSW_2_1_4_FWLITE, T0Mon_080825_1, CMSSW_2_0_10_FWLITE, PRODAGENT_TEST_BUILD_20080822_V3, PRODAGENT_TEST_BUILD_20080822_V2, PRODAGENT_TEST_BUILD_20080822_V1, CMSSW_2_1_4_ONLINE1, CMSSW_2_1_4, apFor214v1, apFor214v0, CMSSW_2_1_3, PRODAGENT_0_11_7_20080813_V1, apFor213v0, CMSSW_2_1_2, CMSSW_2_1_1, CMSSW_2_1_1_ONLINE1, apFor212v0, apFor211v0, CMSSW_2_1_0_ONLINE1, apTestv0, PRODAGENT_0_11_6_20080807_V1, PRODAGENT_0_11_5_20080807_V4, PRODAGENT_0_11_5_20080807_V3, PRODAGENT_0_11_5_20080807_V2, PRODAGENT_0_11_5_20080807_V1, nr080806_for210onl, PRODAGENT_0_12_0_pre1_20080806_V2, PRODAGENT_0_12_0_pre1_20080805_V1, PRODAGENT_0_11_4_20080805_V4, PRODAGENT_0_11_4_20080805_V3, PRODAGENT_0_11_4_20080805_V2, PRODAGENT_0_11_4_20080805_V1, CMSSW_2_1_0, apFor210v0, CMSSW_2_1_0_pre11, apFor210p11v0, dl080727_bootstrap, CMSSW_2_0_11, CMSSW_2_1_0_pre10, apFor210p10v1, apFor210p10v0, pe20080723a-for21X-412, pe20080723a-for21X, CMSSW_2_1_0_pre9, apFor210p9v0, PRODAGENT_0_11_0_20080717, PRODAGENT_0_11_0_20080716, PRODAGENT_0_0_13_V2, PRODAGENT_0_0_13, CMSSW_2_0_10_ONLINE1, PRODAGENT_0_10_12_V18, PRODAGENT_0_10_12_V17, PRODAGENT_0_10_12_V16, PRODAGENT_0_10_12_V15, PRODAGENT_0_10_12_V14, PRODAGENT_0_10_12_V13, CMSSW_2_1_0_pre8, PRODAGENT_0_10_12_V12, PRODAGENT_0_10_12_V11, apFor210p8v1, apFor210p8v0, dl080710_apt0_5_15lorg3_2, CMSSW_2_1_0_pre7, apFor210p7v1, apFor210pre7v1, CMSSW_2_0_10, apFor210p7v0, pe20080702b-for21X-412, pe20080702b-for21X, pe20080702a-for21X-412, pe20080702a-for21X, pe20080627a-for21X-412, pe20080627a-for21X, pe20080626a-for21X-412, pe20080626a-for21X, CMSSW_2_0_9, nr080624_for21x, pe20080624a-for21X-412, pe20080624a-for21X, nr080623_for21x, pe20080623b-for21X-gp-412, pe20080623b-for21X-gp, pe20080623-for21X-gp, CMSSW_2_1_0_pre6, apFor210p6v0, pe20080616-for21X-412, pe20080616-for21X, pe20080611-for21X-412, pe20080611-for21X, CMSSW_2_0_8_ONLINE1-cms2, pe20080610-for21X, pe20080610-for21X-412, pe20080609-for21X-412, pe20080609-for21X, sw_20080509, pe20080607-21X-gendict, sm080606a, CMSSW_2_1_0_pre5g491p02, CMSSW_2_0_8_ONLINE1, pe20080604-for21X-g491p02, CMSSW_2_0_8, CMSSW_2_1_0_pre5, pe20080531-for210p5, nr080529_onl_cmsBuild, nr080528_onl_cmsBuild, CMSSW_2_0_7_FWLITE, sm080520a, pe20080518b-ports-from210p4, pe20080518a-ports-from210p4, CMSSW_2_1_0_pre4, CMSSW_2_0_7, nr080514_206fwlite_no_trajectory, nr080514_206fwlite_alldicts, pe20080512-for21X, dl080507, CMSSW_2_0_6, apFor210p4v1, apFor210p4v0, pe20080507-for21X, dl080506, dl080505t2, CMSSW_2_0_5, CMSSW_2_0_4_ONLINE1, dl080425, nr080425for204onl1, CMSSW_2_0_0_ONLINE2, CMSSW_2_1_0_pre3, nrnr080424for200onl2, CMSSW_2_0_3_ONLINE1, nr080326fwl200p7, CMSSW_2_0_4, dl080422, nr080421for203onl, CMSSW_2_0_3, apFor210p3v1, apFor210p3v0, dl080419for202, CMSSW_2_0_1, dl080418, CMSSW_2_1_0_pre2, CMSSW_2_0_0_ONLINE1, apFor210p2v2, dl080415t2, dl080415, apFor210p2v1, apFor210p2v0, zx20080415-comp, webconddb_1_1_1, nr080413, CMSSW_2_0_0, dl080408cand200t1, dl080408t1, WEBTOOLS-APPS_20080408, nr080408for200p9, dl080407t3, dl080407t2, CMSSW_2_1_0_pre1, CMSSW_2_0_0_pre7_ONLINE1, WEBTOOLS-APPS_20080407, dl080407, apFor210p1, CMSSW_2_0_0_pre9, dl080405, WEBTOOLS-APPS_20080404_2, WEBTOOLS-APPS_20080404_1, WEBTOOLS-APPS_20080404, WEBTOOLS-APPS_20080403_4, WEBTOOLS-APPS_20080403_3, WEBTOOLS-APPS_20080403_2, WEBTOOLS-APPS_20080403_1, WEBTOOLS-APPS_20080403, nr080331for200p7onl1, CMSSW_2_0_0_pre8, sm080328a, WEBTOOLS-APPS_20080328, WEBTOOLS-APPS_20080327_1, WEBTOOLS-APPS_20080327, CMSSW_2_0_0_pre7, WEBTOOLS-APPS_20080326_6, WEBTOOLS-APPS_20080326_5, WEBTOOLS-APPS_20080326_4, WEBTOOLS-APPS_20080326_3, WEBTOOLS-APPS_20080326_2, WEBTOOLS-APPS_20080326, DBSweb_260308_1, DBSweb_260308, CMSSW_2_0_0_pre6, forPHEDEX262_cmsbuild3, sw_20080319, sw20080319, DBSweb_180308_2, DBSweb_180308_1, DBSweb_180308, DBSweb_170308_8, DBSweb_170308_7, DBSweb_170308_6, DBSweb_170308_5, DBSweb_170308_4, DBSweb_170308_3, DBSweb_170308_2, DBSweb_170308, SiteDB_170308, CMSSW_2_0_0_pre5, SiteDB_1_2_1-160308_2, SiteDB_1_2_1-160308, SM_150308_DBSDisc_9, SM_150308_DBSDisc_8, SM_150308_DBSDisc_7, SM_150308_DBSDisc_6, SM_150308_DBSDisc_5, SM_150308_DBSDisc_4, SM_150308_DBSDisc_3, SM_150308_DBSDisc_2, SM_150308_DBSDisc_1, SM_150308_DBSDisc, SiteDB_140308, SiteDB_130308, CMSSW_2_0_0_pre4, dl080312, dl080308, dl080307cmsswtoolconf2cms5, dl080307, dl080307cmsswtoolconf2cms4, dl080304t4, dl080304t3, dl080304t2, dl080304, ge20080304-comp, dl080229, pe20080229-ports, dl080228t2, dl080228, CMSSW_2_0_0_pre3, SiteDB_080227, dl080227, ge20080226, dl080226t2, dl080226, dl080224t3, SiteDB_SM_Nightly_150208
Changes since 1.28:	+1 -1 lines
Log Message:	new tag DBS_1_0_9
#	Content
1	### RPM cms dbs-server DBS_1_0_9
2
3	%define cvstag %v
4	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
5	Requires: apache-ant mysql mysql-deployment oracle apache-tomcat java-jdk dbs-schema
6
7	%prep
8	%setup -n DBS
9	# kill running mysql\|tomcat under my account since build is over
10	ps -w -w -f -u`whoami` \| egrep "mysqld\|tomcat" \| grep -v egrep \| awk '{print "kill -9 "$2""}' \|/bin/sh
11
12	%build
13	echo "PWD=$PWD"
14	cd Servers/JavaServer
15	# fix context.xml file
16	cat > etc/context.xml << EOF_CONTEXT
17	<Context path="/servlet/DBSServlet" docBase="DBSServlet" debug="5" reloadable="true" crossContext="true">
18	<SupportedSchemaVersion schemaversion="DBS_1_0_8" />
19	<SupportedClientVersions clientversions="DBS_1_0_1, DBS_1_0_5, DBS_1_0_7, DBS_1_0_8, DBS_1_0_9"/>
20	<DBSBlockConfig maxBlockSize="2000000000000" maxBlockFiles="100" />
21
22	<Resource name="jdbc/dbs"
23	auth="Container"
24	type="javax.sql.DataSource"
25	maxActive="30"
26	maxIdle="10"
27	maxWait="10000"
28	username="dbs"
29	password="cmsdbs"
30	driverClassName="org.gjt.mm.mysql.Driver"
31	url="jdbc:mysql://localhost:3316/%{cvstag}?autoReconnect=true"/>
32	</Context>
33	EOF_CONTEXT
34
35	mkdir -p bin/WEB-INF/lib
36	echo "PWD=$PWD"
37	source $JAVA_JDK_ROOT/etc/profile.d/init.sh
38	export JAVA_HOME=$JAVA_JDK_ROOT
39	ant --noconfig dist
40	cd ../../
41
42	%install
43	mkdir -p %{i}/Servers/JavaServer/bin/WEB-INF/lib
44	cp -r Servers/JavaServer/* %{i}/Servers/JavaServer
45
46	# copy war file
47	cp %{i}/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps
48
49	# create dbs init script
50	mkdir -p %{i}/Servers/JavaServer/bin
51	cat > %{i}/Servers/JavaServer/bin/dbs_init.sh << DBS_INIT_EOF
52	#!/bin/sh
53	export MYAREA=rpm_install_area
54	export SCRAM_ARCH=slc4_ia32_gcc345
55	source \$MYAREA/\$SCRAM_ARCH/external/apt/0.5.15lorg3.2-CMS3/etc/profile.d/init.sh
56	source \$MYAREA/%{pkgrel}/etc/profile.d/init.sh
57	# set DBS DBs
58	MYSQL_PORT=3316
59	MYSQL_PATH=\$MYSQL_ROOT/mysqldb
60	MYSQL_SOCK=\$MYSQL_PATH/mysql.sock
61	MYSQL_PID=\$MYSQL_PATH/mysqld.pid
62	MYSQL_ERR=\$MYSQL_PATH/error.log
63
64	function dbs_stop()
65	{
66	me=\`whoami\`
67	echo $"Stop mysqld\|tomcat running under \$me account..."
68	ps -w -w -f -u\$me \| egrep "mysqld\|tomcat" \| grep -v egrep \| awk '{print "kill -9 "\$2""}'\|/bin/sh
69	}
70	function dbs_start()
71	{
72	echo "+++ Start up CMS MySQL daemon on port \${MYSQL_PORT} ..."
73	\$MYSQL_ROOT/bin/mysqld_safe --datadir=\$MYSQL_PATH --port=\$MYSQL_PORT \
74	--socket=\$MYSQL_SOCK --log-error=\$MYSQL_ERR --pid-file=\$MYSQL_PID &
75	echo "+++ Start tomcat server"
76	\$APACHE_TOMCAT_ROOT/bin/catalina.sh start
77	sleep 2
78	echo
79	echo "DBS service is ready ..."
80	}
81	function dbs_status()
82	{
83	me=\`whoami\`
84	dbs_mysqld=\`ps -w -w -f -u\$me \| egrep "mysqld" \| grep -v egrep \| wc -l\`
85	dbs_tomcat=\`ps -w -w -f -u\$me \| egrep "tomcat" \| grep -v egrep \| wc -l\`
86	if [ \${dbs_tomcat} -ne 1 ]; then
87	echo "Tomcat server is not running"
88	exit 1
89	fi
90	if [ \${dbs_mysqld} -ne 2 ]; then
91	echo "MySQL server is not running"
92	exit 1
93	fi
94	ps -w -w -f -u\$me \| egrep "mysqld" \| grep -v egrep \| awk '{print "MySQLd server running, pid="\$2""}'
95	ps -w -w -f -u\$me \| egrep "tomcat" \| grep -v egrep \| awk '{print "Tomcat server running, pid="\$2""}'
96	echo "For more information please have a look at tomcat log:"
97	echo "\$APACHE_TOMCAT_ROOT/logs/catalina.out"
98	}
99
100	RETVAL=\$?
101
102	case "\$1" in
103	restart)
104	dbs_stop
105	dbs_start
106	;;
107	start)
108	dbs_start
109	;;
110	status)
111	dbs_status
112	;;
113	stop)
114	dbs_stop
115	;;
116	*)
117	echo \$"Usage: \$0 {start\|stop\|status\|restart}"
118	exit 1
119	;;
120	esac
121
122	exit \$RETVAL
123	DBS_INIT_EOF
124	chmod a+x %{i}/Servers/JavaServer/bin/dbs_init.sh
125
126	mkdir -p %{i}/etc/profile.d
127	(echo "#!/bin/sh"; \
128	echo "source $ORACLE_ROOT/etc/profile.d/init.sh"; \
129	echo "source $MYSQL_ROOT/etc/profile.d/init.sh"; \
130	echo "source $MYSQL_DEPLOYMENT_ROOT/etc/profile.d/init.sh"; \
131	echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.sh"; \
132	echo "source $APACHE_ANT_ROOT/etc/profile.d/init.sh"; \
133	echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.sh"; \
134	echo "source $JAVA_JDK_ROOT/etc/profile.d/init.sh"; \
135	echo "export JAVA_HOME=$JAVA_JDK_ROOT"
136	echo "export CATALINA_HOME=$APACHE_TOMCAT_ROOT"
137	) > %{i}/etc/profile.d/dependencies-setup.sh
138
139	(echo "#!/bin/tcsh"; \
140	echo "source $ORACLE_ROOT/etc/profile.d/init.csh"; \
141	echo "source $MYSQL_ROOT/etc/profile.d/init.csh"; \
142	echo "source $MYSQL_DEPLOYMENT_ROOT/etc/profile.d/init.csh"; \
143	echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.csh"; \
144	echo "source $APACHE_ANT_ROOT/etc/profile.d/init.csh"; \
145	echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.csh"; \
146	echo "source $JAVA_JDK_ROOT/etc/profile.d/init.csh"; \
147	echo "setenv JAVA_HOME $JAVA_JDK_ROOT"
148	echo "setenv CATALINA_HOME $APACHE_TOMCAT_ROOT"
149	) > %{i}/etc/profile.d/dependencies-setup.csh
150
151
152	%post
153	%{relocateConfig}etc/profile.d/dependencies-setup.sh
154	%{relocateConfig}etc/profile.d/dependencies-setup.csh
155
156	# setup MySQL server
157	. $RPM_INSTALL_PREFIX/%{pkgrel}/etc/profile.d/init.sh
158	VO_CMS_SW_DIR=`echo $DBS_SERVER_ROOT \| awk '{split($1,a,SCRAM_ARCH); print a[1]}' SCRAM_ARCH=$SCRAM_ARCH`
159	export VO_CMS_SW_DIR
160	$MYSQL_DEPLOYMENT_ROOT/bin/mysql-deployment.sh
161
162	# set DBS DBs
163	MYSQL_PORT=3316
164	MYSQL_PATH=$MYSQL_ROOT/mysqldb
165	MYSQL_SOCK=$MYSQL_PATH/mysql.sock
166	MYSQL_PID=$MYSQL_PATH/mysqld.pid
167	MYSQL_ERR=$MYSQL_PATH/error.log
168	# grant permissions to CMS MySQL DBS account
169	echo "+++ Grand permission to dbs account, DBS DB ${DBS_SCHEMA_VERSION} ..."
170	#echo "$MYSQL_ROOT/bin/mysql -udbs -pcmsdbs --socket=$MYSQL_SOCK"
171	echo "$DBS_SCHEMA_ROOT/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql"
172	# DBS uses trigger which requires to have SUPER priveleges, so we'll create DB using root
173	# and delegate this to dbs account.
174	$MYSQL_ROOT/bin/mysql -uroot -pcms --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql
175	$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "GRANT ALL ON ${DBS_SCHEMA_VERSION}.* TO dbs@localhost;"
176
177	# I need to copy/deploy DBS.war file into tomcat area
178	cp $DBS_SERVER_ROOT/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps
179
180	echo
181	echo
182	echo "##### IMPORTANT!!! #####"
183	echo "For your convinience we created"
184	echo "$DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh"
185	echo "init script file which can be placed into /etc/init.d/ to allow auto-startup of DBS service"
186	echo "##### END OF README #####"
187	echo
188	# Fix path in dbs_init.sh file since now we know install area
189	cat $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh \| sed "s,rpm_install_area,$RPM_INSTALL_PREFIX,g" > \
190	$DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh.new
191	mv $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh.new $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh
192	chmod a+x $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh
193
194	# time to start up tomcat for user
195	#$APACHE_TOMCAT_ROOT/bin/catalina.sh start
196
197	# kill running mysql\|tomcat under my account since build is over
198	ps -w -w -f -u`whoami` \| egrep "mysqld\|tomcat" \| grep -v egrep \| awk '{print "kill -9 "$2""}' \|/bin/sh