| 1 |
< |
### RPM cms dbs-server DBS_1_1_6_pre2 |
| 1 |
> |
### RPM cms dbs-server DBS_2_0_9_pre5 |
| 2 |
|
|
| 3 |
|
%define cvstag %{realversion} |
| 4 |
|
# define version of DBS to use, it's schema version |
| 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" > etc/context.xml |
| 27 |
< |
#cat > etc/context.xml << EOF_CONTEXT |
| 28 |
< |
#<Context path="/servlet/DBSServlet" docBase="DBSServlet" debug="5" reloadable="true" crossContext="true"> |
| 29 |
< |
# <SchemaOwner schemaowner="${DBS_SCHEMA}" /> |
| 30 |
< |
# <SupportedSchemaVersion schemaversion="${DBS_SCHEMA_VERSION}" /> |
| 31 |
< |
# <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 "/> |
| 32 |
< |
# <DBSBlockConfig maxBlockSize="2000000000000" maxBlockFiles="100" /> |
| 33 |
< |
# <Resource name="jdbc/dbs" |
| 34 |
< |
# auth="Container" |
| 35 |
< |
# type="javax.sql.DataSource" |
| 36 |
< |
# maxActive="30" |
| 37 |
< |
# maxIdle="10" |
| 38 |
< |
# maxWait="10000" |
| 39 |
< |
# username="dbs" |
| 40 |
< |
# password="cmsdbs" |
| 41 |
< |
# driverClassName="org.gjt.mm.mysql.Driver" |
| 42 |
< |
# url="jdbc:mysql://localhost:3316/${DBS_SCHEMA}?autoReconnect=true"/> |
| 43 |
< |
#</Context> |
| 44 |
< |
#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 |
| 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 |
| 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=slc4_ia32_gcc345 |
| 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 |
| 60 |
|
function dbs_stop() |
| 61 |
|
{ |
| 62 |
|
me=\`whoami\` |
| 63 |
< |
echo $"Stop mysqld|tomcat running under \$me account..." |
| 64 |
< |
ps -w -w -f -u\$me | egrep "mysqld|tomcat" | grep -v egrep | awk '{print "kill -9 "\$2""}'|/bin/sh |
| 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 |
|
{ |
| 78 |
|
function dbs_status() |
| 79 |
|
{ |
| 80 |
|
me=\`whoami\` |
| 81 |
< |
dbs_mysqld=\`ps -w -w -f -u\$me | egrep "mysqld" | grep -v egrep | wc -l\` |
| 82 |
< |
dbs_tomcat=\`ps -w -w -f -u\$me | egrep "tomcat" | grep -v egrep | wc -l\` |
| 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 |
< |
exit 1 |
| 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 | egrep "mysqld" | grep -v egrep | awk '{print "MySQLd server running, pid="\$2""}' |
| 92 |
< |
ps -w -w -f -u\$me | egrep "tomcat" | grep -v egrep | awk '{print "Tomcat server running, pid="\$2""}' |
| 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 |
|
} |
| 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 |
< |
$MYSQL_ROOT/bin/mysql -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql |
| 175 |
< |
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK --port=$MYSQL_PORT -uroot -pcms mysql -e "GRANT ALL ON ${DBS_SCHEMA}.* TO dbs@localhost;" |
| 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 |
| 195 |
– |
#if [ ! -f $APACHE_TOMCAT_ROOT/common/lib/mysql-connector-java-5.0.5-bin.jar ]; then |
| 196 |
– |
#cp $DBS_SERVER_ROOT/Servers/JavaServer/lib/mysql-connector-java-5.0.5-bin.jar \ |
| 197 |
– |
# $APACHE_TOMCAT_ROOT/common/lib |
| 198 |
– |
#fi |
| 199 |
– |
# Copy all jar files from DBS area to tomcat area. |
| 200 |
– |
#cp -f $DBS_SERVER_ROOT/Servers/JavaServer/lib/*.jar $APACHE_TOMCAT_ROOT/common/lib |
| 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 | sed "s,rpm_install_area,$RPM_INSTALL_PREFIX,g" > \ |
| 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" |
| 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 |
| 219 |
– |
$MYSQL_ROOT/bin/mysqladmin -uroot -pcms --socket=$MYSQL_SOCK --port=3316 shutdown |
| 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 |
