RE: jdbc connection problems

16 Jul 2016

      Hi David!

Have you tried changing the listenaddr?
As per the settings you showed, it is set to localhost, that is why you can
connect locally.
You should change it to 0.0.0.0. But you have to be aware of having monetdb
open to the "world".

Rgds

On Jul 16, 2016 08:16, "Anderson, David B" 
wrote:
...
And these are my settings from monetdbd:
/opt/mr/monetdb/bin$ monetdbd get all /home/da64666/MonetDB
   property            value
hostname         mrsvm1d
dbfarm           /home/da64666/MonetDB
status           monetdbd[2684] 1.7 (unreleased) is serving this dbfarm
mserver          /opt/mr/monetdb/bin/mserver5
logfile          /home/da64666/MonetDB/merovingian.log
pidfile          /home/da64666/MonetDB/merovingian.pid
sockdir          /tmp
listenaddr       localhost
port             50000
exittimeout      60
forward          proxy
discovery        true
discoveryttl     600
control          no
passphrase       <unknown>
mapisock         /tmp/.s.monetdb.50000
controlsock      /tmp/.s.merovingian.50000
-----Original Message-----
From: Anderson, David B [ICG-MKTS]
Sent: Saturday, July 16, 2016 6:10 AM
To: 'users-list@monetdb.org'
Subject: jdbc connection problems
All,
Do I need to start the server with any special options in order to connect
to it via jdbc? I have installed the driver in DBVisualizer v9.1.7 and am
using the URL
jdbc:monetdb://mrsvm1d:50000/pytest
but I keep getting connection refused errors from the driver (included
below). When I connect locally via mclient, I have:
Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
Database: MonetDB v11.24.0 (unreleased),
'mapi:monetdb://mrsvm1d:50000/pytest'
Type \q to quit, \? for a list of available commands auto commit mode: on
sql>
Here is my server command line (do I need to change the mapi items?):
/opt/mr/monetdb/bin/mserver5.bin --set gdk_nr_threads 3
--dbpath=/home/da64666/MonetDB/pytest --set merovingian_uri
mapi:monetdb://mrsvm1d:50000/pytest --set mapi_open false --set mapi_port 0
--set mapi_usock /home/da64666/MonetDB/pytest/.mapi.sock --set
monet_vault_key /home/da64666/MonetDB/pytest/.vaultkey --set gdk_nr_threads
2 --set max_clients 64 --set sql_optimizer default_pipe --set embedded_py
true --set monet_daemon yes
Thanks,
Dave
java.sql.SQLException: Unable to connect (mrsvm1d:50000): Connection
refused: connect
        at
nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:244)
        at nl.cwi.monetdb.jdbc.MonetDriver.connect(MonetDriver.java:166)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.onseven.dbvis.g.B.D.?(Z:1413)
        at com.onseven.dbvis.g.B.F$A.call(Z:1474)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
        at java.lang.Thread.run(Unknown Source)
SQLException: SQLState(08006)
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@130b7ed
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@7e673e
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@115a9a7
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1057d25
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1abd8e3
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@63900c
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1ff6814
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@9a6101
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@74e0a3
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@a0148b
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1070f4
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@9701ad
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1b6da12
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1769a58
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@4ea676
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@2d0f93
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1c2163a
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1056ee7
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1570d7b
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@18b128d
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@fae160
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@17d9594
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@cb361
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@c1f8d
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@8fe97c
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1108377
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@faf9a3
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1c77aba
java.sql.SQLException: Unable to connect (mrsvm1d:50000): Connection
refused: connect
        at
nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:244)
        at nl.cwi.monetdb.jdbc.MonetDriver.connect(MonetDriver.java:166)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.onseven.dbvis.g.B.D.?(Z:1413)
        at com.onseven.dbvis.g.B.F$A.call(Z:1474)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
        at java.lang.Thread.run(Unknown Source)
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list

RE: jdbc connection problems

Ariel Abadi