| 168 |
|
MYSQL_PID=$MYSQL_PATH/mysqld.pid |
| 169 |
|
MYSQL_ERR=$MYSQL_PATH/error.log |
| 170 |
|
# grant permissions to CMS MySQL DBS account |
| 171 |
< |
echo "+++ Grand permission to dbs account, DBS DB ${DBS_SCHEMA_VERSION} ..." |
| 171 |
> |
echo "+++ Grand permission to dbs account, DBS schema ${ver} ..." |
| 172 |
|
#echo "$MYSQL_ROOT/bin/mysql -udbs -pcmsdbs --socket=$MYSQL_SOCK" |
| 173 |
|
echo "$DBS_SCHEMA_ROOT/lib/DBS-NeXtGen-MySQL_DEPLOYABLE.sql" |
| 174 |
|
# DBS uses trigger which requires to have SUPER priveleges, so we'll create DB using root |
| 175 |
|
# and delegate this to dbs account. |
| 176 |
|
$MYSQL_ROOT/bin/mysql -uroot -pcms --socket=$MYSQL_SOCK < $DBS_SCHEMA_ROOT/lib/DBS-NeXtGen-MySQL_DEPLOYABLE.sql |
| 177 |
< |
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "GRANT ALL ON ${DBS_SCHEMA_VERSION}.* TO dbs@localhost;" |
| 177 |
> |
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "GRANT ALL ON ${ver}.* TO dbs@localhost;" |
| 178 |
|
|
| 179 |
|
# I need to copy/deploy DBS.war file into tomcat area |
| 180 |
|
cp $DBS_SERVER_ROOT/Servers/JavaServer/DBS.war $APACHE_TOMCAT_ROOT/webapps |
