...
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) |