COMP/CMSDIST/dbs-server.spec

### RPM cms dbs-server DBS_2_1_1_patch1

%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 dbs-libs

%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
# DBS wants to have LibValut attached to DBS top-level dir, required by build.xml file
ln -s $DBS_LIBS_ROOT/lib LibValut
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.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

# compile DBS server code
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
ln -s $DBS_LIBS_ROOT/lib %{i}/LibValut

# 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=scram_arch
export APT_VERSION=apt_version
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 from \$MYAREA area..."
    ps -w -w -f -u\$me | grep mysqld | grep "\$MYAREA" | grep \$MYSQL_PORT | grep -v grep | awk '{print "kill -9 "\$2""}'|/bin/sh
    ps -w -w -f -u\$me | grep tomcat | grep "\$MYAREA" | grep -v grep | 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 "\$MYAREA" | grep \$MYSQL_PORT| grep -v egrep | wc -l\`
    dbs_tomcat=\`ps -w -w -f -u\$me | egrep "tomcat" | grep "\$MYAREA" | grep -v egrep | wc -l\`
    if [ \${dbs_tomcat} -ne 1 ]; then
       echo "Tomcat server is not running"
       break
    fi
    if [ \${dbs_mysqld} -ne 2 ]; then
       echo "MySQL server is not running"
       exit 1
    fi
    ps -w -w -f -u\$me | grep "\$MYAREA" | egrep "mysqld" | grep -v egrep | awk '{print "MySQLd server running, pid="\$2""}'
    ps -w -w -f -u\$me | grep "\$MYAREA" | 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 $DBS_LIBS_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 $DBS_LIBS_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.
export DBS_SCHEMA=`grep "^use " $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql | awk '{print $2}' | sed "s/;//g"`

# check existing DBS installation
old=`mysql --vertical -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK -e "show databases" | grep "Database:" | egrep "^CMS_DBS$" | awk '{print $2}'`
if [ ! -z "$old" ]; then
    # stop both tomcat and mysql servers in order to copy previous DB
    echo "+++ Stop Tomcat & MySQL to perform upgrade ..."
    killall -q tomcat
    $MYSQL_ROOT/bin/mysqladmin -uroot -pcms --socket=$MYSQL_SOCK --port=$MYSQL_PORT shutdown
    # we need to do upgrade, first let's move existing CMS_DBS
    cp -r $MYSQL_ROOT/var/db/mysql/CMS_DBS $MYSQL_ROOT/var/db/mysql/CMS_DBS_$old
    # start mysql since we will upgrade
    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 &
    sleep 10
    # perform upgrade
    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}'`
    upgrade_files=`ls upgrade-mysql-*.sql | sort -u | awk '{if($0 > "upgrade-mysql-"DBSVER".sql") print $0}' DBSVER=$ver`
    for ufile in $upgrade_files; do
       if  [ -f $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/$ufile ]; then
           $MYSQL_ROOT/bin/mysql -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/$ufile
       fi
    done
else
    # we will install fresh DBS
    $MYSQL_ROOT/bin/mysql -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql
    $MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK --port=$MYSQL_PORT -uroot -pcms mysql -e "GRANT ALL ON ${DBS_SCHEMA}.* TO dbs@localhost;"
fi

# 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
cp -f $DBS_LIBS_ROOT/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,scram_arch,$SCRAM_ARCH,g" | \
    sed "s,apt_version,$APT_VERSION,g" | \
    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
#cat $MYSQL_ROOT/mysqldb/mysqld.pid
killall -q tomcat
$MYSQL_ROOT/bin/mysqladmin -uroot -pcms --socket=$MYSQL_SOCK --port=$MYSQL_PORT shutdown

# made correct link to LibValut
rm -f $DBS_SERVER_ROOT/LibValut
ln -s $DBS_LIBS_ROOT/lib $DBS_SERVER_ROOT/LibValut

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.137
Committed:	Tue Aug 24 16:58:35 2010 UTC (14 years, 8 months ago) by afaq
Branch:	MAIN
CVS Tags:	aa20101020-dbs, builder_2010-09-15_18-10-44_dbs-apps, DD_20100824_slc5_amd64_gcc434_v1, aa20100824-dbs
Changes since 1.136:	+1 -1 lines
Log Message:	DBS_2_1_1_patch1
#	User	Rev	Content
1	afaq	1.137	### RPM cms dbs-server DBS_2_1_1_patch1
2	valya	1.61
3	valya	1.48	%define cvstag %{realversion}
4	valya	1.42	# define version of DBS to use, it's schema version
5	valya	1.48	%define dbs_version %{realversion}
6	valya	1.42
7	eulisse	1.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
8	valya	1.52	Requires: apache-ant mysql mysql-deployment oracle apache-tomcat java-jdk dbs-schema dbs-libs
9	eulisse	1.1
10			%prep
11			%setup -n DBS
12	valya	1.23	# kill running mysql\|tomcat under my account since build is over
13	valya	1.24	ps -w -w -f -u`whoami` \| egrep "mysqld\|tomcat" \| grep -v egrep \| awk '{print "kill -9 "$2""}' \|/bin/sh
14	valya	1.20
15	eulisse	1.1	%build
16	valya	1.52	# 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	eulisse	1.4	echo "PWD=$PWD"
19			cd Servers/JavaServer
20	valya	1.49
21	valya	1.50	# retrieve which DBS schema to use
22	valya	1.52	#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	valya	1.49
25	valya	1.21	# fix context.xml file
26	valya	1.55	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	valya	1.21
28	valya	1.54	# compile DBS server code
29	valya	1.20	mkdir -p bin/WEB-INF/lib
30	eulisse	1.4	echo "PWD=$PWD"
31	valya	1.20	source $JAVA_JDK_ROOT/etc/profile.d/init.sh
32			export JAVA_HOME=$JAVA_JDK_ROOT
33	eulisse	1.4	ant --noconfig dist
34			cd ../../
35	eulisse	1.1
36			%install
37	valya	1.20	mkdir -p %{i}/Servers/JavaServer/bin/WEB-INF/lib
38	valya	1.7	cp -r Servers/JavaServer/* %{i}/Servers/JavaServer
39	valya	1.53	ln -s $DBS_LIBS_ROOT/lib %{i}/LibValut
40	eulisse	1.1
41	valya	1.8	# copy war file
42			cp %{i}/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps
43
44	valya	1.24	# 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	valya	1.114	export SCRAM_ARCH=scram_arch
50			export APT_VERSION=apt_version
51	valya	1.40	source \$MYAREA/\$SCRAM_ARCH/external/apt/\$APT_VERSION/etc/profile.d/init.sh
52	valya	1.25	source \$MYAREA/%{pkgrel}/etc/profile.d/init.sh
53	valya	1.24	# 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	valya	1.27	me=\`whoami\`
63	valya	1.123	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	valya	1.24	}
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	valya	1.37	--socket=\$MYSQL_SOCK --log-error=\$MYSQL_ERR --pid-file=\$MYSQL_PID --max_allowed_packet=32M &
72	valya	1.24	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	valya	1.123	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	valya	1.24	if [ \${dbs_tomcat} -ne 1 ]; then
84			echo "Tomcat server is not running"
85	valya	1.101	break
86	valya	1.24	fi
87			if [ \${dbs_mysqld} -ne 2 ]; then
88			echo "MySQL server is not running"
89			exit 1
90			fi
91	valya	1.123	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	valya	1.24	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	valya	1.8	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	valya	1.21	echo "source $MYSQL_DEPLOYMENT_ROOT/etc/profile.d/init.sh"; \
128	valya	1.8	echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.sh"; \
129			echo "source $APACHE_ANT_ROOT/etc/profile.d/init.sh"; \
130	valya	1.21	echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.sh"; \
131	valya	1.52	echo "source $DBS_LIBS_ROOT/etc/profile.d/init.sh"; \
132	valya	1.8	echo "source $JAVA_JDK_ROOT/etc/profile.d/init.sh"; \
133	valya	1.23	echo "export JAVA_HOME=$JAVA_JDK_ROOT"
134			echo "export CATALINA_HOME=$APACHE_TOMCAT_ROOT"
135	valya	1.8	) > %{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	valya	1.21	echo "source $MYSQL_DEPLOYMENT_ROOT/etc/profile.d/init.csh"; \
141	valya	1.8	echo "source $APACHE_TOMCAT_ROOT/etc/profile.d/init.csh"; \
142			echo "source $APACHE_ANT_ROOT/etc/profile.d/init.csh"; \
143	valya	1.21	echo "source $DBS_SCHEMA_ROOT/etc/profile.d/init.csh"; \
144	valya	1.52	echo "source $DBS_LIBS_ROOT/etc/profile.d/init.csh"; \
145	valya	1.8	echo "source $JAVA_JDK_ROOT/etc/profile.d/init.csh"; \
146	valya	1.23	echo "setenv JAVA_HOME $JAVA_JDK_ROOT"
147			echo "setenv CATALINA_HOME $APACHE_TOMCAT_ROOT"
148	valya	1.8	) > %{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	valya	1.9
155	valya	1.21	# 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	valya	1.42	echo "+++ Grand permission to dbs account, DBS schema %{dbs_version} ..."
169	valya	1.26	#echo "$MYSQL_ROOT/bin/mysql -udbs -pcmsdbs --socket=$MYSQL_SOCK"
170	valya	1.44	echo "$DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql"
171	valya	1.21	# DBS uses trigger which requires to have SUPER priveleges, so we'll create DB using root
172			# and delegate this to dbs account.
173	valya	1.52	export DBS_SCHEMA=`grep "^use " $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql \| awk '{print $2}' \| sed "s/;//g"`
174	valya	1.102
175			# check existing DBS installation
176	valya	1.104	old=`mysql --vertical -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK -e "show databases" \| grep "Database:" \| egrep "^CMS_DBS$" \| awk '{print $2}'`
177	valya	1.102	if [ ! -z "$old" ]; then
178	valya	1.107	# 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	valya	1.102	# we need to do upgrade, first let's move existing CMS_DBS
183	valya	1.104	cp -r $MYSQL_ROOT/var/db/mysql/CMS_DBS $MYSQL_ROOT/var/db/mysql/CMS_DBS_$old
184	valya	1.107	# 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	valya	1.102	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	valya	1.22
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	valya	1.38	# Copy mysql jdbc driver to tomcat
207	valya	1.52	cp -f $DBS_LIBS_ROOT/lib/*.jar $APACHE_TOMCAT_ROOT/common/lib
208	valya	1.38
209	valya	1.24	# Fix path in dbs_init.sh file since now we know install area
210	valya	1.114	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	valya	1.24	$DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh.new
215	valya	1.31	/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	valya	1.24	chmod a+x $DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh
218	valya	1.23
219			# time to start up tomcat for user
220	valya	1.24	#$APACHE_TOMCAT_ROOT/bin/catalina.sh start
221	valya	1.23
222	valya	1.24	# kill running mysql\|tomcat under my account since build is over
223	valya	1.31	echo "+++ Clean-up mysqld\|tomcat processes"
224	valya	1.33	#ps -w -w -f -u`whoami` \| egrep "mysqld\|tomcat" \| grep -v egrep \| awk '{print "kill -9 "$2""}'
225	valya	1.32	#ps -w -w -f -u`whoami` \| egrep "mysqld\|tomcat" \| grep -v egrep \| awk '{print "kill -9 "$2""}' \|/bin/sh
226	valya	1.52	#killall -q mysqld
227			#cat $MYSQL_ROOT/mysqldb/mysqld.pid
228	valya	1.107	killall -q tomcat
229	valya	1.74	$MYSQL_ROOT/bin/mysqladmin -uroot -pcms --socket=$MYSQL_SOCK --port=$MYSQL_PORT shutdown
230	valya	1.31
231	valya	1.54	# 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	valya	1.31	echo
236			echo
237			echo "##### IMPORTANT!!! #####"
238	valya	1.33	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	valya	1.31	echo "$DBS_SERVER_ROOT/Servers/JavaServer/bin/dbs_init.sh"
243	valya	1.33	echo "init script file can be placed into /etc/init.d/ to allow auto-startup of DBS service"
244			echo "##########################"
245	valya	1.31	echo
246