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 08:50] admin |
niota-docs:niota_install_meta_manually [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| To assist you in setting up the meta database several scripts are provided in ..\bin folder of tools.\\ | To assist you in setting up the meta database several scripts are provided in ..\bin folder of tools.\\ | ||
| - | ** ''do_setup_metadb'' ** creates the schemas and all objects needed in these schemas\\ | + | |** ''do_setup_metadb'' ** |creates the schemas and all objects needed in these schemas| |
| - | ** ''do_setup_importdb'' ** creates the schemas and all objects needed for import/export/deploy feature\\ | + | |** ''do_setup_importdb'' ** |creates the schemas and all objects needed for import/export/deploy feature| |
| - | ** ''do_populate_metadb'' ** inserts and updates all entries needed in the config tables\\ | + | |** ''do_populate_metadb'' ** |inserts and updates all entries needed in the config tables| |
| - | ** ''do_configure_application'' ** inserts and updates all entries needed for specific system applications provided with the install\\ | + | |** ''do_configure_application'' ** |inserts and updates all entries needed for specific system applications provided with the install| |
| - | ** ''do_manage_metadb'' ** assists you for backup and restore tasks\\ | + | |** ''do_manage_metadb'' ** |assists you for backup and restore tasks| |
| Please check below how to call and in which order to call. | Please check below how to call and in which order to call. | ||
| Line 20: | Line 20: | ||
| default-character-set=utf8mb4 | default-character-set=utf8mb4 | ||
| </code> | </code> | ||
| + | |||
| + | * Make sure that your local settings are set correctly in ''niota_setenv.bat''. | ||
| ---- | ---- | ||
| Line 26: | Line 28: | ||
| * Edit file ''niota_setenv.bat'' to set your current values for environment variables mentioned below. | * 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.\\ | + | |** ''nMySQLHome'' ** |must be set to your \bin folder of the MySQL tools you need to use.| |
| - | ''nMySQLPort'' must set to your port number\\ | + | |** ''nMySQLPort'' ** |must set to your port number| |
| - | ''nMySQLServer'' must be set to your MySQL server\\ | + | |** ''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.\\ | + | |** ''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 **\\ | ** 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 46: | 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 70: | 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 85: | 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 97: | 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> | ||
| - | == populate the meta database(s) == | + | ==== populate the meta database(s) ==== |
| 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 130: | Line 165: | ||
| Advanced features are contained in application ''spock'' Store Procedures Operations and Configuration Kit. | 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 | + | To install an application into you local meta database you have to run |
| - | "do_configure_application.bat <your metadata db> <mypw> adminpages | + | ''do_configure_application.bat'' <myMetadataDB> <myPW> <myApp> |
| <code> | <code> | ||
| - | ...\bin>do_configure_application niota_meta *** adminpages | + | ...\bin>do_configure_application niota_meta_c100 *** adminpages |
| </code> | </code> | ||
| - | + | ||
| - | "do_configure_application.bat" <your metadata db> <mypw> spock | + | <code> |
| + | ...\bin>do_configure_application niota_meta_c100 *** spock | ||
| + | </code> | ||
| + | |||
| + | After loading the applications please check for further details how to log in via niota web application. | ||
niota-docs/niota_install_meta_manually.1743663003.txt.gz · Last modified: 2025/07/17 14:11 (external edit)