| 1 |
< |
### RPM cms dbs-server DBS_2_0_7_pre6 |
| 1 |
> |
### RPM cms dbs-server DBS_2_0_8_pre5 |
| 2 |
|
|
| 3 |
|
%define cvstag %{realversion} |
| 4 |
|
# define version of DBS to use, it's schema version |
| 60 |
|
function dbs_stop() |
| 61 |
|
{ |
| 62 |
|
me=\`whoami\` |
| 63 |
< |
echo $"Stop mysqld|tomcat running under \$me account..." |
| 64 |
< |
ps -w -w -f -u\$me | grep mysqld | grep \$MYSQL_PORT | grep -v grep | awk '{print "kill -9 "\$2""}'|/bin/sh |
| 65 |
< |
ps -w -w -f -u\$me | grep tomcat | grep -v grep | 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 \$MYSQL_PORT| 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 |
> |
# we need to do upgrade, first let's move existing CMS_DBS |
| 179 |
> |
cp -r $MYSQL_ROOT/var/db/mysql/CMS_DBS $MYSQL_ROOT/var/db/mysql/CMS_DBS_$old |
| 180 |
> |
while true; do |
| 181 |
> |
ver=`mysql --vertical -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK -e "select SchemaVersion from SchemaVersion" CMS_DBS | grep SchemaVersion | awk '{print $2}'` |
| 182 |
> |
if [ -f $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/upgrade.$ver ]; then |
| 183 |
> |
$MYSQL_ROOT/bin/mysql -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/upgrade.$ver |
| 184 |
> |
else |
| 185 |
> |
break |
| 186 |
> |
fi |
| 187 |
> |
done |
| 188 |
> |
else |
| 189 |
> |
# we will install fresh DBS |
| 190 |
> |
$MYSQL_ROOT/bin/mysql -uroot -pcms --port=$MYSQL_PORT --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/Schema/NeXtGen/DBS-NeXtGen-MySQL_DEPLOYABLE.sql |
| 191 |
> |
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK --port=$MYSQL_PORT -uroot -pcms mysql -e "GRANT ALL ON ${DBS_SCHEMA}.* TO dbs@localhost;" |
| 192 |
> |
fi |
| 193 |
|
|
| 194 |
|
# I need to copy/deploy DBS.war file into tomcat area |
| 195 |
|
cp $DBS_SERVER_ROOT/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps |
