User Tools
niota-docs:niota_install_meta_manually
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_install_meta_manually [2025/04/03 09:27] admin |
niota-docs:niota_install_meta_manually [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 34: | Line 34: | ||
| ** please check/set our configuration settings in niota_setenv.bat **\\ | ** please check/set our configuration settings in niota_setenv.bat **\\ | ||
| - | MySQL\bin folder | + | <code> |
| - | MySQL server | + | :: could be valid settings - check your local environment |
| - | MySQL port number | + | set nMySQLHome=C:\mysql-8.0.26-winx64\bin |
| - | MySQL admin user | + | set nMySQLServer=localhost |
| - | + | set nMySQLPort=3366 | |
| - | == create schemas == | + | set nMySQLAdmin=admin_niota |
| + | </code> | ||
| + | ==== create meta database schemas ==== | ||
| Once your environment settings are done correctly you can run the scripts to build up your meta database and populate it with content. | Once your environment settings are done correctly you can run the scripts to build up your meta database and populate it with content. | ||
| Line 48: | Line 50: | ||
| * meta database \\ | * meta database \\ | ||
| * deploy database \\ | * deploy database \\ | ||
| - | * warp (core) database \\ | ||
| + | Mind that there are default names set for schemas. If you must change these defaults for any valid reason, you have to edit ''..\metadata_schemas.sql''. We don't recommend at all to change the default names. | ||
| + | |||
| ** You have to connect to an existing schema to create a new schema. ** | ** You have to connect to an existing schema to create a new schema. ** | ||
| - | eg. | + | |
| - | <code> | + | <code bat setup_metadb.cmd> |
| - | ...\bin>do_setup_metadb sys <mypw> schemas | + | ...\bin>do_setup_metadb sys ***** schemas |
| </code> | </code> | ||
| + | |||
| + | To achieve this, user "admin_niota" has ''ALL PRIVILEGES ON `niota%`.*'' and ''SELECT ON `sys`.*'' | ||
| + | |||
| ==== to have a client or not to have a client? ==== | ==== to have a client or not to have a client? ==== | ||
| Line 72: | Line 78: | ||
| ''..\tools\database\object\clients\client_schemas.sql'' and run script below and run the script | ''..\tools\database\object\clients\client_schemas.sql'' and run script below and run the script | ||
| - | <code> | + | |
| - | eg. | + | <code setup_metadb2.cmd> |
| - | ...\bin>do_setup_metadb sys <mypw> clients | + | ...\bin>do_setup_metadb sys ***** clients |
| </code> | </code> | ||
| or | or | ||
| - | execute ddl directly in your workbench | + | execute DDL directly in your workbench |
| - | <code> | + | <code sql create_db.sql> |
| - | CREATE DATABASE if not exists niota_meta_<myID> CHARACTER SET UTF8MB4 COLLATE UTF8MB4_general_ci; | + | CREATE DATABASE if not exists niota_meta_<myID> CHARACTER SET UTF8MB4 COLLATE UTF8MB4_general_ci; |
| </code> | </code> | ||
| Line 87: | Line 93: | ||
| ==== create database object in meta data database(s) ==== | ==== create database object in meta data database(s) ==== | ||
| - | Now Create tables, ..... | + | Now create tables, ... \\ |
| You can run every part of the setup process separately by setting the proper option or | You can run every part of the setup process separately by setting the proper option or | ||
| + | |||
| ** run all at once with option "allobjects" ** | ** run all at once with option "allobjects" ** | ||
| Line 99: | Line 107: | ||
| in database niota_meta | in database niota_meta | ||
| - | <code> | + | <code bat setup_metadb_allobjects.cmd> |
| ...\bin>do_setup_metadb niota_meta ***** allobjects | ...\bin>do_setup_metadb niota_meta ***** allobjects | ||
| </code> | </code> | ||
| Line 107: | Line 115: | ||
| Now insert values for configuration and formats into the previously created tables. | Now insert values for configuration and formats into the previously created tables. | ||
| - | run do_populate_metadb.bat <your metadata db> <mypw> <myoption> | + | run do_populate_metadb.bat <your metadata db> <mypw> <myoption> |
| - | <code> | + | You can run every part of the setup process separately by setting the proper option or run all at once with option ''allcontent'' |
| - | ...\bin>do_populate_metadb niota_meta ***** config | + | When you run it separately these options are valid: |
| + | * config | ||
| + | * format | ||
| + | |||
| + | <code bat setup_metadb_allcontent.cmd> | ||
| + | ...\bin>do_populate_metadb niota_meta_c100 ***** allcontent | ||
| </code> | </code> | ||
| - | 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: | + | <code bat setup_metadb_config.cmd> |
| - | config | + | ...\bin>do_populate_metadb niota_meta_c100 ***** config |
| - | format | + | </code> |
| + | |||
| + | |||
| + | |||
| + | ==== create import database ===== | ||
| + | In case you want to use deploy/import feature you need an addition import/deploy database on your MySQL server. This database is also mandatory when you use application ''SPOCK''. | ||
| + | |||
| + | |||
| + | <code bat setup_importdb.cmd> | ||
| + | ...\bin>do_setup_importdb information_schema ***** schemas | ||
| + | |||
| + | </code> | ||
| + | |||
| + | ==== create objects in import database ===== | ||
| + | To allow some scripts to copy data from one meta database to another meta database the need to be copied to the corresponding table in the import/deploy database.\\ | ||
| + | ** Tables in import database do not have constraints, therefore it can lead to inconsistencies in case you edit this tables manually ** | ||
| + | |||
| + | |||
| + | <code> | ||
| + | ...\bin>do_setup_importdb niota_deploy ***** allobjects | ||
| + | </code> | ||
| ==== create database users(s) ==== | ==== create database users(s) ==== | ||
| Line 143: | Line 176: | ||
| ...\bin>do_configure_application niota_meta_c100 *** spock | ...\bin>do_configure_application niota_meta_c100 *** spock | ||
| </code> | </code> | ||
| - | + | ||
| + | After loading the applications please check for further details how to log in via niota web application. | ||
niota-docs/niota_install_meta_manually.1743665228.txt.gz · Last modified: 2025/07/17 14:11 (external edit)