I have another problem The inital load is not synced. If the server has some data in the tables, when the client connets this data is not synced. How can I achieve this? Only the configuration is synced now.
Thank you, this helped, I was following the tutorial, and there i couln't see that the source code is in different repo than mvnrepository
Both 'client' and 'server' type node needed the /sync url to be registered. @Bean public ServletRegistrationBean<SymmetricServlet> symServlet() { ServletRegistrationBean<SymmetricServlet> bean = new ServletRegistrationBean<>(new SymmetricServlet(), "/sync/*"); bean.setLoadOnStartup(1); return bean; }
The server is added to the database, when ServerSymmetricEngine starts. reversible I changed to 0, basically I can set it o 0 or 1, does not matter. The problem was that I needed to MANUALLY do the syncTriggers from code. The client created the triggers fine, but the 'server' type deployment not. serverEngine.syncTriggers(); But now I'm facing another issue. The Database is not copied with the after registration. The syncronization workds if i C/I/D rows, but if i insert a row into the database before...
Yes the value was there....i i do not know why but I needed to register the urls manually. The server node was inthe database, otherwise my script would fail because of constraints. @Bean public ServletRegistrationBean<SymmetricServlet> symServlet() { ServletRegistrationBean<SymmetricServlet> bean = new ServletRegistrationBean<>(new SymmetricServlet(), "/sync/*"); bean.setLoadOnStartup(1); return bean; }
No,the auto.reload=true was added to the config. I needed to manually trigger the syncTriggers. ServerSymmetricEngine serverEngine = new ServerSymmetricEngine(new File(url.getPath())); serverEngine.setDeploymentType("server"); serverEngine.setup(); serverEngine.start(); flyway.setLocations("classpath:scripts"); flyway.setValidateOnMigrate(false); flyway.migrate(); ** serverEngine.syncTriggers();**
Ihave spring boot app, what has an embedded symetricds server. When symetricserver start i insert some data to the database (for instance to sync all tables) After this insert SymmetricDs server does not refresh even if i set the autorefresh boolean. the config itself is good, because when the client registers it gets this config and creates the trigger tables. How can i make my server to actupon the changes and create? my main problem is that theae trigger tables are not generated.
Synconization only works from client to-> server , doesn't matter what is configured -- Node Groups insert into sym_node_group (node_group_id) values ('client'); -- Node Group Links -- server sends changes to client when client pulls from server insert into sym_node_group_link (source_node_group_id, target_node_group_id, data_event_action, is_reversible) values ('server', 'client', 'W', 1); -- client sends changes to server when client pushes to server insert into sym_node_group_link (source_node_group_id,...
When the client wan to register I get the following exception: INFO [client-001-job-3] o.j.s.s.impl.DataLoaderService - Using registration URL of http://localhost:8080/sync/server/registration?nodeGroupId=server&externalId=001&syncURL=http%3A%2F%2Flocalhost%3A8081%2Fsync%2Fclient-001&schemaVersion=%3F&databaseType=H2&databaseVersion=1.4&symmetricVersion=3.11.9&deploymentType=client&hostName=XXXX&ipAddress=YYYY ERROR [client-001-job-3] o.j.s.s.impl.RegistrationService - Unexpected error during registration:...
INFO [client-001-job-3] o.j.s.s.impl.DataLoaderService - Using registration URL of http://localhost:8080/sync/server/registration?nodeGroupId=client&externalId=001&syncURL=http%3A%2F%2Flocalhost%3A8081%2Fsync%2Fclient-001&schemaVersion=%3F&databaseType=H2&databaseVersion=1.4&symmetricVersion=3.11.9&deploymentType=client&hostName=XXXXXXX&ipAddress=XX3 ERROR [client-001-job-3] o.j.s.s.impl.RegistrationService - Unexpected error during registration: org.jumpmind.symmetric.transport.AuthenticationException...
Can I somehow ping the server that the url is reachable? Is the url's exposed be default?
Can I somehow ping the server that the url is reachable?
It starts as a client :( INFO [main] o.j.s.AbstractSymmetricEngine - SymmetricDS Node STARTED: nodeId=server groupId=server type=client subType=null name=server softwareVersion=3.11.9 databaseName=H2 databaseVersion=1.4 driverName=H2 JDBC Driver driverVersion=1.4.200 (2019-10-14) uptime=0 sec. URL url = classloader.getResource("server.properties"); ServerSymmetricEngine serverEngine = new ServerSymmetricEngine(new File(url.getPath())); serverEngine.start();
Hi I have Spring boot app with an embedded client and server. When the server is running and the client starts I see the following error. INFO [client-001-job-3] o.j.s.s.impl.DataLoaderService - Using registration URL of http://localhost:8080/sync/server/registration?nodeGroupId=client&externalId=001&syncURL=http%3A%2F%2Flocalhost%3A8081%2Fsync%2Fclient-001&schemaVersion=%3F&databaseType=H2&databaseVersion=1.4&symmetricVersion=3.11.9&deploymentType=client&hostName=..... ERROR [client-001-job-3] o.j.s.s.impl.RegistrationService...
Hi I have Spring boot app with an embedded client and server. When the server is running and the client starts I see the following error. INFO [client-001-job-3] o.j.s.s.impl.DataLoaderService - Using registration URL of http://localhost:8080/sync/server/registration?nodeGroupId=client&externalId=001&syncURL=http%3A%2F%2Flocalhost%3A8081%2Fsync%2Fclient-001&schemaVersion=%3F&databaseType=H2&databaseVersion=1.4&symmetricVersion=3.11.9&deploymentType=client&hostName=..... ERROR [client-001-job-3] o.j.s.s.impl.RegistrationService...
Thank you, now I was able to start the server
That is the latest version in mvnrepository. Do you have dependencies what can be managed by gradle? where can download the new jars(not the zip)?
Hi! I have an embedded Spring boot app. When I start the server ServerSymmetricEngine serverEngine = new ServerSymmetricEngine(new File("server.properties)); It always fails when the ServerSymmetricEngine constructor invokes the ClientSymmetricEngine code . The registerEngine will be always be true . In the 3.5.19 version the registerEngine can can not be set for the ServerSymmetricEngine. (The ClientSymmetricEngine code can set it to false) if (registerEngine) { ctx.setConfigLocations(new String[]...
Same happens with me, with the default config. startup] - SymmetricWebServer - About to start SymmetricDS web server on host:port 0.0.0.0:31415 [server] - AbstractSymmetricEngine - Initializing connection to database [server] - JdbcDatabasePlatformFactory - Detected database 'H2', version '1', protocol 'h2' [server] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpmind.db.platform.h2.H2DatabasePlatform [server] - H2SymmetricDialect - The DbDialect being used is org.jumpmind.symmetric.db.h2.H2SymmetricDialect...
Hi! I added symmetric-server to my dependencies <dependency> <groupid>org.jumpmind.symmetric</groupid> <artifactid>symmetric-server</artifactid> <version>3.5.19</version> </dependency> I wanted to run single line of code, that will start an embedded server, however It thows an error that jetty is not found in the dependencies.....How can i download all the required dependencies? I started to add them to the pom 1 by 1 but after 3 I gave up. Basically the tutorial code is not working. I have symmetricDs...
I have a Spring boot app where I want to have a server and a Client. I want to launch an SymmetricDS in embedded mode and followed the tutorials. I wan to syncronize H2 databases. I added the config files for both the server and the clients. The config files are read perfectly, but I have several errors what looks wery stange to me. My gradle has the following dependencies so basically it should find SymetricDS in the class path: compile group: 'org.jumpmind.symmetric', name: 'symmetric-server',...