View Issue Details

IDProjectCategoryView StatusLast Update
0003782SymmetricDSBugpublic2018-11-09 07:05
Reporterachintya.de@uk.daiwacm.comAssigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.9.14 
Target VersionFixed in Version 
Summary0003782: bin/sym throws following errors
DescriptionI'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 Reproducejust run sym from the bin folder

Activities

elong

2018-11-02 08:35

developer   ~0001307

You'll see that logging when someone tries to access https://localhost:31415 instead of http://localhost:31415

achintya.de@uk.daiwacm.com

2018-11-02 08:54

reporter   ~0001308

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

elong

2018-11-02 09:09

developer   ~0001309

What version of Java are you using? Oracle's version 8 of Java is currently recommended.

achintya.de@uk.daiwacm.com

2018-11-02 09:11

reporter   ~0001310

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)

achintya.de@uk.daiwacm.com

2018-11-02 09:17

reporter   ~0001311

this was my first case regarding SymmetricDS s/w

https://www.symmetricds.org/issues/view.php?id=3771#c1303

elong

2018-11-02 09:43

developer   ~0001312

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.

achintya.de@uk.daiwacm.com

2018-11-02 12:56

reporter   ~0001313

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

elong

2018-11-02 13:02

developer   ~0001314

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.

achintya.de@uk.daiwacm.com

2018-11-02 13:16

reporter   ~0001315

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

elong

2018-11-02 13:20

developer   ~0001316

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

achintya.de@uk.daiwacm.com

2018-11-02 13:22

reporter   ~0001317

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

achintya.de@uk.daiwacm.com

2018-11-02 13:28

reporter   ~0001318

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

achintya.de@uk.daiwacm.com

2018-11-02 13:30

reporter   ~0001319

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 ?

elong

2018-11-02 13:37

developer   ~0001320

Yes, you need to run the symadmin like the tutorial says. It creates runtime tables needed by SymmetricDS, which have names starting with SYM.

achintya.de@uk.daiwacm.com

2018-11-02 13:41

reporter   ~0001321

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

achintya.de@uk.daiwacm.com

2018-11-05 07:02

reporter   ~0001322

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

elong

2018-11-05 08:20

developer   ~0001323

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

achintya.de@uk.daiwacm.com

2018-11-05 08:22

reporter   ~0001324

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)

achintya.de@uk.daiwacm.com

2018-11-06 09:01

reporter   ~0001326

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

corp-000.properties (3,010 bytes)
store-001.properties (3,016 bytes)
store-002.properties (3,148 bytes)

achintya.de@uk.daiwacm.com

2018-11-07 08:21

reporter   ~0001328

can anybody please let me know what kind of driver do i need to use for setting up a sql server node ?

achintya.de@uk.daiwacm.com

2018-11-09 07:05

reporter   ~0001329

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

Issue History

Date Modified Username Field Change
2018-11-02 08:31 achintya.de@uk.daiwacm.com New Issue
2018-11-02 08:35 elong Note Added: 0001307
2018-11-02 08:54 achintya.de@uk.daiwacm.com Note Added: 0001308
2018-11-02 09:09 elong Note Added: 0001309
2018-11-02 09:11 achintya.de@uk.daiwacm.com Note Added: 0001310
2018-11-02 09:17 achintya.de@uk.daiwacm.com Note Added: 0001311
2018-11-02 09:43 elong Note Added: 0001312
2018-11-02 12:56 achintya.de@uk.daiwacm.com Note Added: 0001313
2018-11-02 13:02 elong Note Added: 0001314
2018-11-02 13:16 achintya.de@uk.daiwacm.com Note Added: 0001315
2018-11-02 13:20 elong Note Added: 0001316
2018-11-02 13:22 achintya.de@uk.daiwacm.com Note Added: 0001317
2018-11-02 13:28 achintya.de@uk.daiwacm.com Note Added: 0001318
2018-11-02 13:30 achintya.de@uk.daiwacm.com Note Added: 0001319
2018-11-02 13:37 elong Note Added: 0001320
2018-11-02 13:41 achintya.de@uk.daiwacm.com Note Added: 0001321
2018-11-05 07:02 achintya.de@uk.daiwacm.com Note Added: 0001322
2018-11-05 08:20 elong Note Added: 0001323
2018-11-05 08:22 achintya.de@uk.daiwacm.com Note Added: 0001324
2018-11-06 09:01 achintya.de@uk.daiwacm.com File Added: corp-000.properties
2018-11-06 09:01 achintya.de@uk.daiwacm.com File Added: store-001.properties
2018-11-06 09:01 achintya.de@uk.daiwacm.com File Added: store-002.properties
2018-11-06 09:01 achintya.de@uk.daiwacm.com Note Added: 0001326
2018-11-07 08:21 achintya.de@uk.daiwacm.com Note Added: 0001328
2018-11-09 07:05 achintya.de@uk.daiwacm.com Note Added: 0001329