View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003782 | SymmetricDS | Bug | public | 2018-11-02 12:31 | 2018-11-19 18:21 |
| Reporter | achintya.de@uk.daiwacm.com | Assigned To | |||
| Priority | normal | ||||
| Status | closed | Resolution | no change required | ||
| Product Version | 3.9.14 | ||||
| Summary | 0003782: bin/sym throws following errors | ||||
| Description | I've just downloaded 3.9.14 software, extracted in a folder on Windows 7 and run sym from the bin folder as out of the box without changing anything at all I get this: C:\symmetric-server-3.9.14\bin>sym SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/C:/symmetric-server-3.9.14/lib/slf4j-log4j12-1.7.6.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/C:/symmetric-server-3.9.14/web/WEB-INF/lib/slf4j-log4j12-1.7.21.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] Log output will be written to C:\symmetric-server-3.9.14/logs/symmetric.log [startup] - SymmetricUtils - _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ | Copyright (C) 2007-2018 JumpMind, Inc. | | | | Licensed under the GNU General Public License version 3. | | This software comes with ABSOLUTELY NO WARRANTY. | | See http://www.gnu.org/licenses/gpl.html | +-----------------------------------------------------------------+ [startup] - SymmetricWebServer - About to start SymmetricDS web server on host:port 0.0.0.0:31415 [startup] - SymmetricWebServer - Starting JMX HTTP console on port 31416 [startup] - SymmetricWebServer - Joining the web server main thread HttpAdaptor version 3.0.1 started on port 31416 [startup] - HttpParser - Illegal character 0x16 in state=START for buffer HeapByteBuffer@3fdc9569[p=1,l=517,c=8192,r=516]={\x16<<<\x03\x01\x02\x00\x01 \x00\x01\xFc\x03\x03@\xB7\x08\xE9\x01\xC9\x12...\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00>>>\x00\x00\x00\x00\x00\x00\x00\x00\x00\x0 0\x00\x00\x00\x00\x00\x00\x00...\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00} [startup] - HttpParser - Illegal character 0x16 in state=START for buffer HeapByteBuffer@50584739[p=1,l=517,c=8192,r=516]={\x16<<<\x03\x01\x02\x00\x01 \x00\x01\xFc\x03\x03\x86\x95\x9e\x9b\xBd\n\x8d...\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00>>>\x00\x00\x00\x00\x00\x00\x00\x00\x00\x 00\x00\x00\x00\x00\x00\x00\x00...\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00} [startup] - HttpParser - Illegal character 0x16 in state=START for buffer HeapByteBuffer@3fdc9569[p=1,l=186,c=8192,r=185]={\x16<<<\x03\x01\x00\xB5\x01 \x00\x00\xB1\x03\x03\x10\x99\xB2\xA5T\xFc\xC5...\x17\x00\x18\x00\x1b\x00\x03\x02\x00\x02::\x00\x01\x00>>>.1uP\x00\x00\x00\x0b\x00\x02\x01\x00\x003\x00 +\x00...\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00} Terminate batch job (Y/N)? | ||||
| Steps To Reproduce | just run sym from the bin folder | ||||
| Tags | No tags attached. | ||||
|
|
You'll see that logging when someone tries to access https://localhost:31415 instead of http://localhost:31415 |
|
|
thnx Elong but it is my workstation and nobody has access to it and nobody knows abt this website yet just tried again, no that parser error but when i try to use the url, i get this HTTP ERROR 403 Problem accessing /. Reason: Forbidden Powered by Jetty:// 9.4.7.v20170914 The DOS /CMD window is in this state now: /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ | Copyright (C) 2007-2018 JumpMind, Inc. | | | | Licensed under the GNU General Public License version 3. | | This software comes with ABSOLUTELY NO WARRANTY. | | See http://www.gnu.org/licenses/gpl.html | +-----------------------------------------------------------------+ [startup] - SymmetricWebServer - About to start SymmetricDS web server on host:port 0.0.0.0:31415 [startup] - SymmetricWebServer - Starting JMX HTTP console on port 31416 [startup] - SymmetricWebServer - Joining the web server main thread HttpAdaptor version 3.0.1 started on port 31416 |
|
|
What version of Java are you using? Oracle's version 8 of Java is currently recommended. |
|
|
that was the first bottleneck, i had to download n install java 8 to get this running, i had 7 when i first started C:\>java -version java version "1.8.0_191" Java(TM) SE Runtime Environment (build 1.8.0_191-b12) Java HotSpot(TM) 64-Bit Server VM (build 25.191-b12, mixed mode) |
|
|
this was my first case regarding SymmetricDS s/w https://www.symmetricds.org/issues/view.php?id=3771#c1303 |
|
|
It looks like it's working to me. There's no web interface to use. It uses HTTP/HTTPS for syncing data. The 403 error in your web browser is correct, it is expecting another SymmetricDS node to connect and authenticate, not a user to point their browser at it. Take a look at the tutorial for getting setup: http://www.symmetricds.org/doc/3.9/html/tutorials.html If you want a web interface instead, there's SymmetricDS Pro from JumpMind. |
|
|
sorry to nag guys my proof of concept demo is to replicate data from a sybase database to either to another sybase database or to a sql server database i edited the corp-000.properties file to use a sybase db driver but it is failing with error while doing dbimport here are few relevant lines as example of the properties file #db.driver=org.sqlite.JDBC db.driver=com.sybase.jdbc4.jdbc.SybDriver #db.driver=com.nuodb.jdbc.Driver #db.driver=org.h2.Driver #db.url=jdbc:sqlite:corp.sqlite db.url=jdbc:sybase:Tds:<hostname>:<port no>/<dbname> #db.url=jdbc:com.nuodb://localhost/database?schema=database #db.url=jdbc:h2:corp;AUTO_SERVER=TRUE;LOCK_TIMEOUT=60000 I used <hostname>, <port no> and <dbname> as examples but im passing right details I didnt change this group.id and external.id parts as im not fully sure what they are used for # Do not change these for running the demo group.id=corp external.id=000 The error im getting while doing dbimport are: C:\symmetric-server-3.9.14\bin>dbimport --engine corp-000 --format XML --alter-case create_sample1.xml SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/C:/symmetric-server-3.9.14/lib/slf4j-log4j12-1.7.6.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/C:/symmetric-server-3.9.14/web/WEB-INF/lib/slf4j-log4j12-1.7.21.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] Log output will be written to C:\symmetric-server-3.9.14/logs/symmetric.log [] - AbstractCommandLauncher - Option: name=engine, value={corp-000} [] - AbstractCommandLauncher - Option: name=format, value={XML} [] - AbstractCommandLauncher - Option: name=alter-case, value={} ------------------------------------------------------------------------------- An exception occurred. Please see the following for details: ------------------------------------------------------------------------------- java.lang.ClassNotFoundException: com.sybase.jdbc4.jdbc.SybDriver at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at org.jumpmind.db.util.BasicDataSourceFactory.prepareDriver(BasicDataSourceFactory.java:40) at org.jumpmind.db.util.BasicDataSourceFactory.create(BasicDataSourceFactory.java:71) [wrapped] java.lang.IllegalStateException: Had trouble registering the jdbc driver: com.sybase.jdbc4.jdbc.SybDriver at org.jumpmind.db.util.BasicDataSourceFactory.create(BasicDataSourceFactory.java:73) at org.jumpmind.symmetric.ClientSymmetricEngine.createBasicDataSource(ClientSymmetricEngine.java:295) at org.jumpmind.symmetric.AbstractCommandLauncher.testConnection(AbstractCommandLauncher.java:398) [wrapped] java.lang.RuntimeException: java.lang.IllegalStateException: Had trouble registering the jdbc driver: com.sybase.jdbc4.jdbc.SybDriver at org.jumpmind.symmetric.AbstractCommandLauncher.testConnection(AbstractCommandLauncher.java:403) at org.jumpmind.symmetric.AbstractCommandLauncher.getDatabasePlatform(AbstractCommandLauncher.java:410) at org.jumpmind.symmetric.DbImportCommand.executeWithOptions(DbImportCommand.java:113) at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:194) at org.jumpmind.symmetric.DbImportCommand.main(DbImportCommand.java:72) ------------------------------------------------------------------------------- |
|
|
http://www.symmetricds.org/doc/3.9/html/user-guide.html#_sybase_ase 'Sybase Adaptive Server Enterprise (ASE) was tested using the jConnect 7 JDBC driver. The jConnect 7 JDBC driver should be placed in the "lib" folder.' It's probably named jconnect-7.7.jar or something similar, and you'll find it on the database server installation. Copy it to the "lib" folder of SymmetricDS. |
|
|
thank you, thats a step forward but it is complaining about the create_sample1.xml i've deliberately used sample1 rather than sample to make sure it creates a new file but it seems it is looking for the sample.xml file do i need to copy that sample.xml file from the sample folder to bin folder to keep going ? C:\symmetric-server-3.9.14\bin>dbimport --engine corp-000 --format XML --alter-case create_sample1.xml SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/C:/symmetric-server-3.9.14/lib/slf4j-log4j12-1.7.6.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/C:/symmetric-server-3.9.14/web/WEB-INF/lib/slf4j-log4j12-1.7.21.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] Log output will be written to C:\symmetric-server-3.9.14/logs/symmetric.log [] - AbstractCommandLauncher - Option: name=engine, value={corp-000} [] - AbstractCommandLauncher - Option: name=format, value={XML} [] - AbstractCommandLauncher - Option: name=alter-case, value={} [] - AbstractSymmetricEngine - Initializing connection to database [] - JdbcDatabasePlatformFactory - Detected database 'Adaptive Server Enterprise', version '15', protocol 'sybase' [] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpmind.db.platform.ase.AseDatabasePlatform ------------------------------------------------------------------------------- An exception occurred. Please see the following for details: ------------------------------------------------------------------------------- java.lang.RuntimeException: Cannot find file create_sample1.xml at org.jumpmind.symmetric.DbImportCommand.executeWithOptions(DbImportCommand.java:183) at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:194) at org.jumpmind.symmetric.DbImportCommand.main(DbImportCommand.java:72) ------------------------------------------------------------------------------- |
|
|
Either specify where the file is or change directories. For example: C:\symmetric-server-3.9.14\bin>dbimport --engine corp-000 --format XML --alter-case ..\samples\create_sample.xml |
|
|
thank you again for your prompt response, i did a good progress today with your help do i assume that create_sample.xml is a kind of template file or is it the output file will be created by that command ? not totally sure about the parameters eg --alter-case pls comment many thanks |
|
|
i used the create_sample.xml as specified in the guide and i can see it has managed to create 3 empty tables in the database provided in the corp-000.xml |
|
|
4 tables item, item_selling_price, sale_return_line_item and sale_transaction but now confused.com, do i need to run that sysadmin command as it seems it will try to create the tables but the tables are already there as a part of the dbimport command ? |
|
|
Yes, you need to run the symadmin like the tutorial says. It creates runtime tables needed by SymmetricDS, which have names starting with SYM. |
|
|
thanks again i did and it has created 47 sym tables in the database as mentioned in corp-000 file , so now i got 4 user tables and 47 sym tables |
|
|
hello again, in the sample properties file (ie corp, store1, store2), i dont see any driver specified for Microsoft SQL Server, i would like to setup store2 as a SQL server node , i did setup Corp node as an ASE node and also store1 as an ASE node my idea to replicate data from an ASE source to an ASE target and also to a MS-SQL server target As soon as i setup the nodes properly, I'll start sym to test the data flow I;ve completed the steps up until dbimport specified in the SymmetricDS 3.9 tutorial please comment accordingly Many thanks |
|
|
We use the jTDS driver for SQL-Server. It is well tested and good performance. Uncomment these lines: db.driver=net.sourceforge.jtds.jdbc.Driver db.url=jdbc:jtds:sqlserver://localhost:1433;useCursors=true;bufferMaxMemory=10240;lobBuffer=5242880 It is possible to use Microsoft's driver also. It looks like this: db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver db.url=jdbc:sqlserver://localhost;databasename=mydatabase |
|
|
thank you for that but how abt the authentication to the sql server, i would like to use my Windows authentication as a start but please also specify how to provide a sql server auth mode also (ie login/password method) |
|
|
im not sure whether i'll be setup this demo at all, my objective is to data replicate from source ie corp-000 node to store-001 and store-002 nodes corp is an ASE node, store 1 is an ASE node and store 2 is a SQL Server node please have a look into the attached properties file and let me know I get this error while starting sym [corp-000] - RegistrationService - Cannot register a client node unless a node group link exists so the registering node can receive configuration upd ates. Please add a group link where the source group id is corp and the target group id is store [corp-000] - RegistrationUriHandler - store:001:? was not allowed to register. [store-001] - RegistrationService - Waiting for registration to be accepted by the server. Registration is not open. [store-001] - RegistrationService - Could not register. Sleeping for 28000ms before attempting again. [store-001] - RegistrationService - This node is unregistered. It will attempt to register using the registration.url [store-001] - DataLoaderService - Using registration URL of http://localhost:31415/sync/corp-000/registration?nodeGroupId=store&externalId=001&syncURL =http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9. 14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86 [corp-000] - 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 corp and the target group id is store |
|
|
can anybody please let me know what kind of driver do i need to use for setting up a sql server node ? |
|
|
ive now managed to get the SQL server node working but the trouble is im getting a FK constraint failure for channel id in the corp / master node the sym_channel table has the following channel_id config reload monitor heartbeat default dynamic but the insert statement is using the channel_id as 'item' -- Trigger INSERT INTO sym_trigger ( trigger_id, source_table_name, channel_id, last_update_time, create_time ) VALUES ( 'item', 'item', 'item', getdate(), getdate() ) and keep failing please advise thanks |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-11-02 12:31 | achintya.de@uk.daiwacm.com | New Issue | |
| 2018-11-02 12:35 | elong | Note Added: 0001307 | |
| 2018-11-02 12:54 | achintya.de@uk.daiwacm.com | Note Added: 0001308 | |
| 2018-11-02 13:09 | elong | Note Added: 0001309 | |
| 2018-11-02 13:11 | achintya.de@uk.daiwacm.com | Note Added: 0001310 | |
| 2018-11-02 13:17 | achintya.de@uk.daiwacm.com | Note Added: 0001311 | |
| 2018-11-02 13:43 | elong | Note Added: 0001312 | |
| 2018-11-02 16:56 | achintya.de@uk.daiwacm.com | Note Added: 0001313 | |
| 2018-11-02 17:02 | elong | Note Added: 0001314 | |
| 2018-11-02 17:16 | achintya.de@uk.daiwacm.com | Note Added: 0001315 | |
| 2018-11-02 17:20 | elong | Note Added: 0001316 | |
| 2018-11-02 17:22 | achintya.de@uk.daiwacm.com | Note Added: 0001317 | |
| 2018-11-02 17:28 | achintya.de@uk.daiwacm.com | Note Added: 0001318 | |
| 2018-11-02 17:30 | achintya.de@uk.daiwacm.com | Note Added: 0001319 | |
| 2018-11-02 17:37 | elong | Note Added: 0001320 | |
| 2018-11-02 17:41 | achintya.de@uk.daiwacm.com | Note Added: 0001321 | |
| 2018-11-05 12:02 | achintya.de@uk.daiwacm.com | Note Added: 0001322 | |
| 2018-11-05 13:20 | elong | Note Added: 0001323 | |
| 2018-11-05 13:22 | achintya.de@uk.daiwacm.com | Note Added: 0001324 | |
| 2018-11-06 14:01 | achintya.de@uk.daiwacm.com | File Added: corp-000.properties | |
| 2018-11-06 14:01 | achintya.de@uk.daiwacm.com | File Added: store-001.properties | |
| 2018-11-06 14:01 | achintya.de@uk.daiwacm.com | File Added: store-002.properties | |
| 2018-11-06 14:01 | achintya.de@uk.daiwacm.com | Note Added: 0001326 | |
| 2018-11-07 13:21 | achintya.de@uk.daiwacm.com | Note Added: 0001328 | |
| 2018-11-09 12:05 | achintya.de@uk.daiwacm.com | Note Added: 0001329 | |
| 2018-11-19 18:21 | hanes | Status | new => closed |
| 2018-11-19 18:21 | hanes | Resolution | open => no change required |