Tim Gent - 2016-02-03

When starting the symmetric ds service for the first time I get the following error:
"This node is configured as a registration server, but it is missing its node_identity. It probably needs configured." I had thought all of the below steps would have provided it with a node_identity, but it seems not! Any help massively appreciated :)

So far I have:
- In the engines directory got a file: oracleron.properties containing the following configuration:
engine.name=oracleron
group.id=oracleron
external.id=oracleron
sync.url=http://127.0.0.1:31415/sync/oracleron
db.driver=oracle.jdbc.driver.OracleDriver
db.url=jdbc:oracle:thin:@127.0.0.1:1521/XX
db.user=xxxxx
db.password=xxxxx

  • Created the SYM tables:
    ./symmetric-server-3.7.28/bin/symadmin --engine oracleron create-sym-tables

  • Inserted the following data into the Oracle database referrred to:

insert into SYM_NODE (node_id, node_group_id, external_id, sync_enabled, created_at_node_id)
values ('oracleron', 'oracleron', 'oracleron', 1, 'oracleron');

insert into SYM_NODE_IDENTITY values ('oracleron');

insert into SYM_NODE_SECURITY (node_id,node_password,registration_enabled,registration_time,initial_load_enabled,initial_load_time,created_at_node_id)
values ('oracleron','xxxxx',1,current_timestamp,0,current_timestamp,'oracleron');

insert into SYM_NODE_GROUP
(node_group_id, description)
values ('oracleron', 'Oracle master node');

insert into SYM_NODE_GROUP
(node_group_id, description)
values ('mysqlron', 'MySQL slave node');

insert into SYM_NODE_GROUP_LINK
(source_node_group_id, target_node_group_id, data_event_action)
values ('oracleron', 'mysqlron', 'P');

insert into SYM_ROUTER (router_id, source_node_group_id, target_node_group_id,
create_time, last_update_time)
values ('master-to-slave','oracleron', 'mysqlron',
current_timestamp, current_timestamp);

insert into SYM_TRIGGER (trigger_id, source_table_name,
channel_id, last_update_time, create_time)
values ('MY_TABLE', 'MY_TABLE', 'default', current_timestamp, current_timestamp);

insert into SYM_TRIGGER_ROUTER
(trigger_id, router_id, initial_load_order, create_time,
last_update_time) values ('MY_TABLE', 'master-to-slave', 1, current_timestamp,
current_timestamp);

 

Last edit: Tim Gent 2016-02-03