...
Before compiling the code, make sure you can create db schema and that you can access it as user. You can create DB schema following way
| Code Block |
|---|
> cd docs/dbschema
> mysql -h $HOST_NAME -u $UAL_USER itmcatalog -p < create_db.sql
# You have to alter table where some config info is stored make sure to call
> cat alter_00.sql | \
sed 's|@FULL_PATH_FOR_STORAGE@|/this/is/the/location/where/all/users/can/write|' > \
alter_00_modified.sql
mysql -h itmmysql1 -u ual_user_s itmcatalog -p < alter_00_modified.sql
# /this/is/the/location/where/all/users/can/write - is a place on your machine (where users are calling
# scheduler application). Each user has to have write
# access there.
> mysql -h $HOST_NAME -u $UAL_USER itmcatalog -p < alter_00_modified.sql
# make sure to create list of variables that are stored inside DB
> xsltproc ./getFieldsIMAS.xsl \
$IMAS_HOME/core/installer/src/$IMAS_VERSION/ual/$UAL_VERSION/xml/IDSDef.xml | \
grep "summary" > \
variables.sql
> mysql -h $HOST_NAME -u $UAL_USER itmcatalog -p < variables.sql
# double check that all tables are in proper place
> mysql -h $HOST_NAME -u $UAL_USER itmcatalog -p
> ...
> mysql> show tables;
+----------------------+
| Tables_in_itmcatalog |
+----------------------+
| annotations |
| catalog_parameters |
| entry |
| entry_data |
| intervals |
| machines |
| outcome |
| scheduler |
| users |
| variables |
+----------------------+
10 rows in set (0.00 sec) |