niota

To assist you in setting up the meta database several scripts are provided in ..\bin folder of tools.

Please check below how to call and in which order to call.

important

• In case you want to run these scripts on a windows system the password you use must not contain “!” exclamation mark as this cannot be forwarded through batch scripts in windows
• Make sure that your my.ini file establishes client connection with the proper character set option.

[client]
default-character-set=utf8mb4

• Make sure that your local settings are set correctly in niota_setenv.bat.

—-

• Edit file niota_setenv.bat to set your current values for environment variables mentioned below.

nMySQLHome must be set to your \bin folder of the MySQL tools you need to use.
nMySQLPort must set to your port number
nMySQLServer must be set to your MySQL server
nMySQLAdmin must be set to a user on your MySQL server that has administration rights and is allowed to create databases, tables, views.

please check/set our configuration settings in niota_setenv.bat
MySQL\bin folder MySQL server MySQL port number MySQL admin user

Once your environment settings are done correctly you can run the scripts to build up your meta database and populate it with content.

run script do_setup_metadb with option schemas

This script creates your

• meta database
  
• deploy database
  
• warp (core) database
  

You have to connect to an existing schema to create a new schema.

eg.

...\bin>do_setup_metadb sys <mypw> schemas

You can run niota from system meta db niota_meta or you can define an one meta database for your local clients. We strongly recommend to create your own client specific meta database!

Set up has then later be done for both - the system client in niota_meta and for every own client meta database.

Set desired meta database suffix for your local client. Default name is “niota_meta_c100” – you can change the suffix to your needs e.g. niota_meta_IBM Suffix should match the 5 characters client ID Set your desired client meta database name in

..\tools\database\object\clients\client_schemas.sql and run script below and run the script

 
eg.
...\bin>do_setup_metadb sys <mypw> clients

or execute ddl directly in your workbench

CREATE DATABASE if not exists niota_meta_<myID> CHARACTER SET UTF8MB4  COLLATE UTF8MB4_general_ci; 

Please double check if your database exists now on the desired server.

Now Create tables, ….. You can run every part of the setup process separately by setting the proper option or run all at once with option “allobjects”

allobjects invokes creation of

• tables
• functions
• views
• …

in database niota_meta

...\bin>do_setup_metadb niota_meta ***** allobjects

Now insert values for configuration and formats into the previously created tables.

run do_populate_metadb.bat <your metadata db> <mypw> <myoption>

...\bin>do_populate_metadb niota_meta ***** config

You can run every part of the setup process separately by setting the proper option or run all at once with option “allcontent” When you run it separately these options are valid: config format

We strongly recommend to create dedicated database users to access your meta database via niota web. DO NOT USE root or admin users.

Configure provided scripts in folder user and run the scripts to create users and grant minimum privileges required.

Now you have to install at least one application to be able to configure niota locally. The most basic tool for this is adminpages. Advanced features are contained in application spock Store Procedures Operations and Configuration Kit.

To install an applicatin into you local meta database you have to run

“do_configure_application.bat <your metadata db> <mypw> adminpages

...\bin>do_configure_application niota_meta *** adminpages

“do_configure_application.bat” <your metadata db> <mypw> spock