I am trying to set up a replication between two databases, e.g. db1 -> db2.
db1 is on Client and db2 is on Server.
The Client and Server are not in the same network environment.
Only one-way ping works.
Client ---ping OK---> Server
Client <---ping NG--- Server
10.1.10.50 10.4.40.40
The master db is also on the Server, which has the definition of all the triggers, node group, etc.
The problem:
The SymmetricDS running on the Client can't get registered with the Server.
The properties file on the Client only has registration.url defined. The sync.url is commmented out. As someone mentioned in another thread saying that the node which has no children doesn't need the sync.url.
registration.url=http://10.4.40.11:8180/sync/mytarget-001
XXXsync.url=XXX
My Question:
1) Is SymmetricDS designed to work in the above network environment (only one-way ping works)?
2) If SymmetricDS can work in such network, how to get it work?
Thanks
Last edit: ZJZ 2016-05-16
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
1) Yes, SymmetricDS should work if the group link is set such that the client initiates communicaiton with the server.
2) You can use tools such as cURL and wget to make sure that the communicaiton is open between the two. You could also paste the URL listed in the log in a browser to see the CSV data.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am trying to set up a replication between two databases, e.g. db1 -> db2.
db1 is on Client and db2 is on Server.
The Client and Server are not in the same network environment.
Only one-way ping works.
Client ---ping OK---> Server
Client <---ping NG--- Server
10.1.10.50 10.4.40.40
The master db is also on the Server, which has the definition of all the triggers, node group, etc.
The problem:
The SymmetricDS running on the Client can't get registered with the Server.
Below is the log:
[testclient-001] - RegistrationService - This node is unregistered. It will attempt to register using the registration.url
[testclient-001] - DataLoaderService - Using registration URL of http://10.4.40.11:8180/sync/mytarget-001/registration?nodeGroupId=testclient&externalId=node001&syncURL=http%3A%2F%2FTESTHOST%3A31415%2Fsync%2Ftestclient-001&schemaVersion=%3F&databaseType=Oracle&databaseVersion=12.1&symmetricVersion=3.7.32&hostName=TESTHOST&ipAddress=10.1.10.50
[testclient-001] - RegistrationService - The request to register failed because the client failed to connect to the server
[testclient-001] - RegistrationService - Could not register. Sleeping before attempting again.
[testclient-001] - RegistrationService - Sleeping for 25000ms
The properties file on the Client only has registration.url defined. The sync.url is commmented out. As someone mentioned in another thread saying that the node which has no children doesn't need the sync.url.
registration.url=http://10.4.40.11:8180/sync/mytarget-001
XXXsync.url=XXX
My Question:
1) Is SymmetricDS designed to work in the above network environment (only one-way ping works)?
2) If SymmetricDS can work in such network, how to get it work?
Thanks
Last edit: ZJZ 2016-05-16
1) Yes, SymmetricDS should work if the group link is set such that the client initiates communicaiton with the server.
2) You can use tools such as cURL and wget to make sure that the communicaiton is open between the two. You could also paste the URL listed in the log in a browser to see the CSV data.