You can translate the question and the replies:

Denodo connect to DSN

Hi Team, Please support on linux (ubuntu 16.04) server error when connecting via dsn (MySQL driver) This is exception {code} Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.8.0_162] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:1.8.0_162] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:1.8.0_162] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:1.8.0_162] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0_162] at java.net.Socket.connect(Socket.java:589) ~[?:1.8.0_162] at java.net.Socket.connect(Socket.java:538) ~[?:1.8.0_162] at java.net.Socket.<init>(Socket.java:434) ~[?:1.8.0_162] at java.net.Socket.<init>(Socket.java:211) ~[?:1.8.0_162] at sun.rmi.transport.proxy.RMIDirectSocketFactory.createSocket(RMIDirectSocketFactory.java:40) ~[?:1.8.0_162] at sun.rmi.transport.proxy.RMIMasterSocketFactory.createSocket(RMIMasterSocketFactory.java:148) ~[?:1.8.0_162] at com.denodo.util.security.DenodoRMISocketFactory.createSocket(DenodoRMISocketFactory.java:145) ~[denodo-commons-util-web.jar:7.0.0] at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:613) ~[?:1.8.0_162] ... 24 more 3111696 [SwingWorker-pool-2-thread-9] ERROR 2018-09-24T06:13:54.437 com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxy [] - Error unmarshaling return header; nested exception is: java.io.EOFException com.denodo.vdb.vdbinterface.common.clientResult.VQLException: Error unmarshaling return header; nested exception is: java.io.EOFException at com.denodo.vdb.vdbinterface.client.printer.GetVDBObjectPrinter.format(Unknown Source) ~[denodo-vdp-client.jar:7.0.0] at com.denodo.vdb.vdbinterface.client.VDBProxy.exec(Unknown Source) ~[denodo-vdp-client.jar:7.0.0] at com.denodo.vdb.vdbinterface.client.VDBProxy.exec(Unknown Source) ~[denodo-vdp-client.jar:7.0.0] at com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxy$4.call(Unknown Source) [denodo-vdp-admintool.jar:7.0.0] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_162] at com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxy.execute(Unknown Source) [denodo-vdp-admintool.jar:7.0.0] at com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxy.execStatement(Unknown Source) [denodo-vdp-admintool.jar:7.0.0] at com.denodo.vdb.admin.model.wrapper.WrapperAdminFacade.testJDBCConnection(Unknown Source) [denodo-vdp-admintool.jar:7.0.0] at com.denodo.vdb.admin.model.introspect.VQLSourceIntrospectionService.testJDBCConnection(Unknown Source) [denodo-vdp-admintool.jar:7.0.0] at com.denodo.vdb.util.introspectionservice.util.jdbc.JDBCAdminUtil.testConnection(Unknown Source) [denodo-vdp-admin.jar:7.0.0] at com.denodo.vdb.util.introspectionservice.util.odbc.ODBCAdminUtil.testConnection(Unknown Source) [denodo-vdp-admin.jar:7.0.0] at com.denodo.vdb.admin.gui.components.dockable.datasources.edition.CreateODBCDataSourceDialog$9.doInBackground(Unknown Source) [denodo-vdp-admintool.jar:7.0.0] at com.denodo.vdb.admin.gui.components.dockable.datasources.edition.CreateODBCDataSourceDialog$9.doInBackground(Unknown Source) [denodo-vdp-admintool.jar:7.0.0] at javax.swing.SwingWorker$1.call(SwingWorker.java:295) [?:1.8.0_162] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_162] at javax.swing.SwingWorker.run(SwingWorker.java:334) [?:1.8.0_162] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_162] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_162] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_162] 3111697 [SwingWorker-pool-2-thread-9] ERROR 2018-09-24T06:13:54.438 com.denodo.vdb.admin.model.introspect.VQLSourceIntrospectionService [] - com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: Error unmarshaling return header; nested exception is: java.io.EOFException {code} And here is the error in console {code} /home/trantuan/denodo/jre/bin/java: symbol lookup error: /home/trantuan/denodo/jre/lib/amd64/libJdbcOdbc.so: undefined symbol: SQLAllocEnv {code} Please note that I can connect successful in window environment. Thank you very much
DSN
user
24-09-2018 06:34:39 -0400
code

1 Answer

Hi, Support for ODBC Sources when Virtual DataPort server runs on Linux is disabled by default. The reason for being disabled by default is that on Linux, depending on the configuration of the host, Virtual DataPort could load the wrong library to connect to ODBC sources. You may refer to [Enabling the Support for ODBC Sources When the Virtual DataPort Server Runs on Linux](https://community.denodo.com/docs/html/browse/7.0/platform/installation/postinstallation_tasks/postinstallation_tasks_in_virtual_dataport/enabling_the_support_for_odbc_sources_when_the_virtual_dataport_server_runs_on_linux) section of Denodo Platform Installation Guide for more information. I would recommend connecting to the MySQL by using JDBC driver. The reason is that in Virtual DataPort, queries involving a JDBC data source run faster than if they involve an ODBC data source, even if the underlying source is the same. Hope this helps! [](http://)
Denodo Team
24-09-2018 21:55:53 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here