Differences

This shows you the differences between two versions of the page.

--- niota-docs:niota_install_meta_manually [2025/04/03 08:54]
admin
+++ niota-docs:niota_install_meta_manually [2025/07/17 14:11] (current)
@@ Line 28: / Line 28: @@
   * 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 **\\
-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.
@@ Line 48: / Line 50: @@
   * meta 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. **
-eg.
-<code>
+<code bat setup_metadb.cmd>
-...\bin>do_setup_metadb sys <mypw> schemas
+...\bin>do_setup_metadb sys ***** schemas
 </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? ====
@@ Line 72: / Line 78: @@
 ''..\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>
 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>
@@ Line 87: / Line 93: @@
 ==== 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
 ** run all at once with option "allobjects" **
@@ Line 99: / Line 107: @@
 in database niota_meta
-<code>
+<code bat setup_metadb_allobjects.cmd>
 ...\bin>do_setup_metadb niota_meta ***** allobjects
 </code>
-== populate the meta database(s) ==
+==== populate the meta database(s) ====
 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>
-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) ====
@@ Line 132: / Line 165: @@
 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>
-...\bin>do_configure_application niota_meta *** adminpages
+...\bin>do_configure_application niota_meta_c100 *** adminpages
 </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

User Tools

Site Tools

Differences

Page Tools