1 MySQL Server Settings
Consider to adapt the memory settings of the MySQL Server before
importing the data into the new database server. This will correctly set the logfile size among other settings.
MySQL 5.6.12 – Please note that it is mandatory to disable the sql_mode setting. By default NO_ENGINE_SUBSTITUTION and STRICT_TRANS_TABLES are enabled. Gentics Content.Node will not function properly when the STRICT_TRANS_TABLES setting is enabled.
Please note that the my.cnf mysqld setting character-set-server must be set to utf8. It is also highly suggested to set the client default-character-set to utf8.
2 Configuration files
The node.conf file contains the main database settings.
$SETTINGS["dbtype"] = "mysql"; $SETTINGS["db"] = "node_utf8"; // Adapt this url so that it contains the correct port and the socket file path $SETTINGS["server"] = "localhost:3306:/var/run/mysqld/mysqld.sock"; $SETTINGS["login"] = "node"; $SETTINGS["pw"] = "YOURPW"; $SETTINGS["charset"] = "utf8"; $SETTINGS["jdbcparameters"] = "netTimeoutForStreamingResults=900";
The contentrepository connection properties can be changed later on within the Admin Area of Gentics Content.Node. (Administration → Content.Admin → ContentRepositories)
3 Permissions
The following MySQL permssions are needed:
mysql> GRANT usage ON *.* to node_cms@HOSTNAME mysql> GRANT super ON *.* to node_cms@HOSTNAME mysql> GRANT all ON node_utf8.* to node_cms@HOSTNAME mysql> GRANT all ON node_utf8_cr.* to node_cms@HOSTNAME mysql> GRANT all ON node_utf8_todo.* to node_cms@HOSTNAME
4 Changes of the connection settings
The stored procedures/triggers/functions need to be removed when the username and or the used connection ip / hostname changes because those elements contain a reference to the previously used login.
4.1 Dropping of the stored procedures
mysql> USE node_utf8 ; mysql> SHOW PROCEDURE STATUS ;
mysql> DROP PROCEDURE deleteUdate; mysql> DROP PROCEDURE insertGlobalId; mysql> DROP PROCEDURE updateUdate;
4.1.1 Check
mysql> SHOW PROCEDURE STATUS;
4.2 Dropping of functions
mysql> USE node_utf8 ; mysql> SHOW FUNCTION STATUS; mysql> DROP FUNCTION generateMappedGlobalId;
4.2.1 Check
mysql> SHOW FUNCTION STATUS;
4.3 Dropping of triggers
mysql> USE node_utf8; mysql> SHOW TRIGGERS;
mysql> DROP TRIGGER udate_insert_construct_node; mysql> DROP TRIGGER udate_delete_construct_node; mysql> DROP TRIGGER udate_insert_contentrepository; mysql> DROP TRIGGER udate_update_contentrepository; mysql> DROP TRIGGER udate_delete_contentrepository; mysql> DROP TRIGGER udate_insert_dicuser; mysql> DROP TRIGGER udate_update_dicuser; mysql> DROP TRIGGER udate_delete_dicuser; mysql> DROP TRIGGER udate_insert_node_contentgroup; mysql> DROP TRIGGER udate_delete_node_contentgroup; mysql> DROP TRIGGER udate_insert_objprop_node; mysql> DROP TRIGGER udate_delete_objprop_node; mysql> DROP TRIGGER udate_insert_perm; mysql> DROP TRIGGER udate_delete_perm; mysql> DROP TRIGGER udate_insert_tagmap; mysql> DROP TRIGGER udate_update_tagmap; mysql> DROP TRIGGER udate_delete_tagmap; mysql> DROP TRIGGER udate_insert_template_folder; mysql> DROP TRIGGER udate_delete_template_folder; mysql> DROP TRIGGER udate_delete_construct; mysql> DROP TRIGGER udate_delete_construct_category; mysql> DROP TRIGGER udate_delete_content; mysql> DROP TRIGGER udate_delete_contentfile; mysql> DROP TRIGGER udate_delete_contentgroup; mysql> DROP TRIGGER udate_delete_contentset; mysql> DROP TRIGGER udate_delete_contenttag; mysql> DROP TRIGGER udate_delete_datasource; mysql> DROP TRIGGER udate_delete_datasource_value; mysql> DROP TRIGGER udate_delete_ds; mysql> DROP TRIGGER udate_delete_ds_obj; mysql> DROP TRIGGER udate_delete_eventprop; mysql> DROP TRIGGER udate_delete_eventpropeditable; mysql> DROP TRIGGER udate_delete_folder; mysql> DROP TRIGGER udate_delete_job; mysql> DROP TRIGGER udate_delete_node; mysql> DROP TRIGGER udate_delete_objprop; mysql> DROP TRIGGER udate_delete_objprop_category; mysql> DROP TRIGGER udate_delete_objtag; mysql> DROP TRIGGER udate_delete_outputuser; mysql> DROP TRIGGER udate_delete_page; mysql> DROP TRIGGER udate_delete_part; mysql> DROP TRIGGER udate_delete_reaction; mysql> DROP TRIGGER udate_delete_reactionprop; mysql> DROP TRIGGER udate_delete_reactionpropeditable; mysql> DROP TRIGGER udate_delete_task; mysql> DROP TRIGGER udate_delete_taskparam; mysql> DROP TRIGGER udate_delete_tasktemplate; mysql> DROP TRIGGER udate_delete_tasktemplateparam; mysql> DROP TRIGGER udate_delete_template; mysql> DROP TRIGGER udate_delete_templategroup; mysql> DROP TRIGGER udate_delete_templatetag; mysql> DROP TRIGGER udate_delete_TRIGGERevent; mysql> DROP TRIGGER udate_delete_value; mysql> DROP TRIGGER udate_delete_workflowlink; mysql> DROP TRIGGER udate_insert_construct; mysql> DROP TRIGGER udate_insert_construct_category; mysql> DROP TRIGGER udate_insert_content; mysql> DROP TRIGGER udate_insert_contentfile; mysql> DROP TRIGGER udate_insert_contentgroup; mysql> DROP TRIGGER udate_insert_contentset; mysql> DROP TRIGGER udate_insert_contenttag; mysql> DROP TRIGGER udate_insert_datasource; mysql> DROP TRIGGER udate_insert_datasource_value; mysql> DROP TRIGGER udate_insert_ds; mysql> DROP TRIGGER udate_insert_ds_obj; mysql> DROP TRIGGER udate_insert_eventprop; mysql> DROP TRIGGER udate_insert_eventpropeditable; mysql> DROP TRIGGER udate_insert_folder; mysql> DROP TRIGGER udate_insert_job; mysql> DROP TRIGGER udate_insert_node; mysql> DROP TRIGGER udate_insert_objprop; mysql> DROP TRIGGER udate_insert_objprop_category; mysql> DROP TRIGGER udate_insert_objtag; mysql> DROP TRIGGER udate_insert_outputuser; mysql> DROP TRIGGER udate_insert_page; mysql> DROP TRIGGER udate_insert_part; mysql> DROP TRIGGER udate_insert_reaction; mysql> DROP TRIGGER udate_insert_reactionprop; mysql> DROP TRIGGER udate_insert_reactionpropeditable; mysql> DROP TRIGGER udate_insert_task; mysql> DROP TRIGGER udate_insert_taskparam; mysql> DROP TRIGGER udate_insert_tasktemplate; mysql> DROP TRIGGER udate_insert_tasktemplateparam; mysql> DROP TRIGGER udate_insert_template; mysql> DROP TRIGGER udate_insert_templategroup; mysql> DROP TRIGGER udate_insert_templatetag; mysql> DROP TRIGGER udate_insert_TRIGGERevent; mysql> DROP TRIGGER udate_insert_value; mysql> DROP TRIGGER udate_insert_workflowlink; mysql> DROP TRIGGER udate_update_construct; mysql> DROP TRIGGER udate_update_construct_category; mysql> DROP TRIGGER udate_update_content; mysql> DROP TRIGGER udate_update_contentfile; mysql> DROP TRIGGER udate_update_contentgroup; mysql> DROP TRIGGER udate_update_contentset; mysql> DROP TRIGGER udate_update_contenttag; mysql> DROP TRIGGER udate_update_datasource; mysql> DROP TRIGGER udate_update_datasource_value; mysql> DROP TRIGGER udate_update_ds; mysql> DROP TRIGGER udate_update_ds_obj; mysql> DROP TRIGGER udate_update_eventprop; mysql> DROP TRIGGER udate_update_eventpropeditable; mysql> DROP TRIGGER udate_update_folder; mysql> DROP TRIGGER udate_update_job; mysql> DROP TRIGGER udate_update_node; mysql> DROP TRIGGER udate_update_objprop; mysql> DROP TRIGGER udate_update_objprop_category; mysql> DROP TRIGGER udate_update_objtag; mysql> DROP TRIGGER udate_update_outputuser; mysql> DROP TRIGGER udate_update_page; mysql> DROP TRIGGER udate_update_part; mysql> DROP TRIGGER udate_update_reaction; mysql> DROP TRIGGER udate_update_reactionprop; mysql> DROP TRIGGER udate_update_reactionpropeditable; mysql> DROP TRIGGER udate_update_task; mysql> DROP TRIGGER udate_update_taskparam; mysql> DROP TRIGGER udate_update_tasktemplate; mysql> DROP TRIGGER udate_update_tasktemplateparam; mysql> DROP TRIGGER udate_update_template; mysql> DROP TRIGGER udate_update_templategroup; mysql> DROP TRIGGER udate_update_templatetag; mysql> DROP TRIGGER udate_update_TRIGGERevent; mysql> DROP TRIGGER udate_update_value; mysql> DROP TRIGGER udate_update_workflowlink;
4.3.1 Check
mysql> SHOW TRIGGERS;
4.4 Creation of triggers, functions and procedures
The triggers, functions and procedures will be recreated when the user logs in the first time or by invoking the following command.
/Node/bin# curl http://localhost/CNPortletapp/JavaParserInvoker # Expected Output: CM/2 OK
4.4.1 Check
Check that the database triggers were created using the expected definer. (e.g.: ‘node_cms@HOSTNAME’)