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:
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