Where communities thrive

Join over 1.5M+ people
Join over 100K+ communities
Free without limits
Create your own community

Explore more communities

SymmetricDS/Lobby

People

Repo info

Activity

Jun 23 19:57

evan-miller-jumpmind on 4943-vaadin-14

0004943: Added add-ons for Twin… (compare)
Jun 23 12:31

erilong on 3.12

0005000: Turn on Jetty access l… (compare)
Jun 22 20:46

erilong on 3.12

0004717: Client ack rejected wi… (compare)
Jun 22 19:09

erilong on 3.12

0005034: Initial load shows up … (compare)
Jun 22 15:18

joshahicks on 3.11

0005035: Big Query support for … Merge branch '3.11' of https://… (compare)
Jun 21 19:56

erilong on bugfix_purge_initial_load_createtable

(compare)
Jun 21 19:56

erilong on 3.12

fix inserting create table even… (compare)
Jun 21 19:56

erilong closed #161
Jun 21 18:20

erilong on 3.12

0005036: Outgoing batch panel r… (compare)
Jun 17 19:04

evan-miller-jumpmind on 4943-vaadin-14

0004943: Continued Vaadin 14 up… (compare)
Jun 16 17:27

erilong on 3.12

add logging of jdbc type (compare)
Jun 16 15:11

rudiejd on fix_purge_initialload_create_table

(compare)
Jun 16 15:11

rudiejd opened #161
Jun 16 15:10

rudiejd on bugfix_purge_initial_load_createtable

fix inserting create table even… (compare)
Jun 16 15:03

rudiejd on fix_purge_initialload_create_table

5018: add permission check for … 5018: add permission check for … fix inserting create table even… (compare)
Jun 16 15:02

rudiejd closed #160
Jun 16 14:59

rudiejd opened #160
Jun 14 20:21

philipmarzullo64 on 3.12

0005030: Load Filter documentat… (compare)
Jun 14 20:02

joshahicks on 3.12

0005029: Push acknowledgements … (compare)
Jun 14 19:04

philipmarzullo64 on 3.13

0003897: Cleanly exit all job t… (compare)

joshahicks

@joshahicks

@Thwipp it depends on the platform if triggers are fired as part of your snapshot process. I do not believe they are so you should be good

Thwipp

@Thwipp

Thanks @joshahicks!

tjp1955

@tjp1955

Does symmetric support Oracle 12 CLOB's that contain a large amount of data? e.g. 12 MB string?

joshahicks

@joshahicks

yes

hariharan.thyagarajan

@hariharanthyagu_twitter

Hi morning all, I am configuring Symmetric DS between Oracle DB 11.2 source and Oracle DB 11.2 target.

PushService - Could not communicate with dest:001:001 at http://11.11.11.2:31415/sync/dest-001 because: org.jumpmind.exception.IoException: java.net.NoRouteToHostException: No route to host (Host unreachable) org.jumpmind.exception.IoException: java.net.NoRouteToHostException: No route to host (Host unreachable)

i am getting this above error while configuring the replication between source & Target.

source & Target Oracle VM's @ CLoud.

we are able to ping source & target VM's

hariharan.thyagarajan

@hariharanthyagu_twitter

[source-000] - PushService - Could not communicate with dest:001:001 at http://11.11.11.2:31415/sync/dest-001 because it returned HTTP code 400
-bash: [source-000]: command not found

joshahicks

@joshahicks

@hariharanthyagu_twitter this is a networking issue. You need to make sure your firewalls and ports are all setup correctly.

Kathy Marshall-Procope

@kprocope_gitlab

good day everyone...I want to backup my sql databases for Autosol Communication Manager and i am using SymmetricDS to sync the tables

does it have steps to show me how to stop symmetricDS from syncing the tables before i backup?

joshahicks

@joshahicks

You can disable sym_trigger_router and run the sync triggers and the capture triggers will be removed. Then you can flip the flag back when your ready to capture again

Akash K Roy

@akashkroy

Hi everyone

RegistrationService - Cannot register a client node unless a node group link exists so the registering node can receive configuration updates. Please add a group link where the source group id is centralNode and the target group id is clientNode

I am getting this error while running bin/sym . I searched everywhere but couldn't find any reference to what source group id and target group id is ?

I have added group.id=centralNode and group.id=clientNode in the respective properties file

but not entirely sure why I am getting this error

joshahicks

@joshahicks

@akashkroy you need to create an engine (node) for each of these groups which is sounds like you have done. But now you need to add a group link to the database of the centralNode in sym_node_group_link table. See below docs.

https://www.symmetricds.org/doc/3.12/html/user-guide.html#_group_links

The group link defines how information will pass between these nodes and which node initiates communication via a push or pull

Akash K Roy

@akashkroy

@joshahicks ahhh okay but doesnt it automatically takes care of that ?

also in that example in the link that you posted, why is the source_node_group_id set to store instead of corp ( Assuming store is a client node)

Akash K Roy

@akashkroy

ahh there's data_event_action got it

Also does symmetricds supports mssql ?

hariharan.thyagarajan

@hariharanthyagu_twitter

Hi Experts,

i'm using SYMETTRIC DS to replicate data from Oracle to Oracle DB, How to replicate multiple multiple schemas from one DB to another DB via symmetric DB

for an example SCOTT & SCOTT1 has to be replicated from source to target DB so my understanding it to run multiple instances on the same machine

? please getback.

@hariharanthyagu_twitter this is a networking issue. You need to make sure your firewalls and ports are all setup correctly.

Thanks we are able to resolve and move forward.

joshahicks

@joshahicks

You can replicate multiple schemas through a single node/engine if the user can access those schemas. In the triggers you can specify the source schema and you can specify target schemas in the routers (or transforms)

hariharan.thyagarajan

@hariharanthyagu_twitter

ok thanks for the answers, if my SCOTT schema doesn't have access to SCOTT1 schema objects in such case we can't replicate the table data of SCOTT1 from source to target right ?

In a single node /engine we cant replicate multiple users/schemas objects from source to target right ! is my understanding right..

joshahicks

@joshahicks

You can replicate multiple source and target schemas if the jdbc connection and your database vendor supports it. It is not a SymmetricDS limitation it would be based on each database and how you setup your permissions. If you can connect into SCOTT with user abc and can still access SCOTT1 then your set if your database does not allow that then you can not. SymmetricDS does not limit it is only based on what is allowed by your database

Akash K Roy

@akashkroy

Hi :-D

How can I setup a trigger that will detect a change in schema in the CentralNode and update the clientNode before syncing the data ?
Another question related to this : Can it just detect change in schema for a table or db when there is no change in the actual data ? ( I hope this makes sense )

joshahicks

@joshahicks

@akashkroy only on MSSQL can you capture and sync schema changes

you can use the bin/symadmin send-schema to send schema defintions of tables from source to target and they will be altered on target to match source

Akash K Roy

@akashkroy

but I have to run bin/symadmin send-schema everytime, before running bin/sym ?

joshahicks

@joshahicks

Just when your table definitions change

bin/sym just starts SymmetricDS the bin/send-schema is independent and can be run anytime

Akash K Roy

@akashkroy

if I run it as a service as bin/sym_service , then if there if a change in schema and new data is added to CentralNode, it will detect the change in new data for sure, but it will automatically detect the change in schema as well before syncing the new data ? ( in MSSQL that is) I tested it with mysql it doesnt ( in my tests)

joshahicks

@joshahicks

That is correct for MSSQL it will not capture new date until you run sync triggers in other platforms to rebuild the trigger

hariharan.thyagarajan

@hariharanthyagu_twitter

You can replicate multiple source and target schemas if the jdbc connection and your database vendor supports it. It is not a SymmetricDS limitation it would be based on each database and how you setup your permissions. If you can connect into SCOTT with user abc and can still access SCOTT1 then your set if your database does not allow that then you can not. SymmetricDS does not limit it is only based on what is allowed by your database

Thanks Josh So kind of you for helping us with our clarifications.

Akash K Roy

@akashkroy

Thanks @joshahicks , Much Appreciated !

Akash K Roy

@akashkroy

Hi, me again :-)

I noticed that in mssql it created the sym_* tables in master db of Central Node by default , if there a way to change that ?
because bin/sym errors out after I do a bin/symadmin send-schema
error : references invalid table 'master.dbo.sym_node_group_link'

in clientNode sym_* tables are in a different db

joshahicks

@joshahicks

It will create sym_* tables in the default location based on your db.url and connection. So you just need to setup a database for SDS and connect to that and give that user proper permissions to see your application database.

https://www.jumpmind.com/downloads/symmetricds/doc/3.12/html/user-guide.html#_sql_server_permissions

Akash K Roy

@akashkroy

Yeah Thats what I observed in mysql but in Mssql it defaults to the master db for some reason. Here's my server.properties file: https://pastebin.com/brt0fkC0

Akash K Roy

@akashkroy

Edit: updated the pastebin link there was a typo.

Chat via Matrix