RE: jdbc connection problems

16 Jul 2016

      That did it! Thanks.

Do you know if I can wildcard the IP to restrict to something between localhost and the world?

From: users-list [mailto:users-list-bounces+david.b.anderson=citi.com@monetdb.org] On Behalf Of Ariel Abadi
Sent: Saturday, July 16, 2016 8:10 AM
To: Communication channel for MonetDB users
Subject: RE: jdbc connection problems

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" <david.b.anderson@citi.com<mailto:david.b.anderson@citi.com>> 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<mailto: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<mailto:nl.cwi.monetdb.jdbc.MonetDriver@130b7ed>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@7e673e<mailto:nl.cwi.monetdb.jdbc.MonetDriver@7e673e>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@115a9a7<mailto:nl.cwi.monetdb.jdbc.MonetDriver@115a9a7>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1057d25<mailto:nl.cwi.monetdb.jdbc.MonetDriver@1057d25>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1abd8e3<mailto:nl.cwi.monetdb.jdbc.MonetDriver@1abd8e3>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@63900c<mailto:nl.cwi.monetdb.jdbc.MonetDriver@63900c>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1ff6814<mailto:nl.cwi.monetdb.jdbc.MonetDriver@1ff6814>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@9a6101<mailto:nl.cwi.monetdb.jdbc.MonetDriver@9a6101>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@74e0a3<mailto:nl.cwi.monetdb.jdbc.MonetDriver@74e0a3>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@a0148b<mailto:nl.cwi.monetdb.jdbc.MonetDriver@a0148b>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1070f4<mailto:nl.cwi.monetdb.jdbc.MonetDriver@1070f4>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@9701ad<mailto:nl.cwi.monetdb.jdbc.MonetDriver@9701ad>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1b6da12<mailto:nl.cwi.monetdb.jdbc.MonetDriver@1b6da12>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1769a58<mailto:nl.cwi.monetdb.jdbc.MonetDriver@1769a58>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@4ea676<mailto:nl.cwi.monetdb.jdbc.MonetDriver@4ea676>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@2d0f93<mailto:nl.cwi.monetdb.jdbc.MonetDriver@2d0f93>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1c2163a<mailto:nl.cwi.monetdb.jdbc.MonetDriver@1c2163a>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1056ee7<mailto:nl.cwi.monetdb.jdbc.MonetDriver@1056ee7>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1570d7b<mailto:nl.cwi.monetdb.jdbc.MonetDriver@1570d7b>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@18b128d<mailto:nl.cwi.monetdb.jdbc.MonetDriver@18b128d>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@fae160<mailto:nl.cwi.monetdb.jdbc.MonetDriver@fae160>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@17d9594<mailto:nl.cwi.monetdb.jdbc.MonetDriver@17d9594>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@cb361<mailto:nl.cwi.monetdb.jdbc.MonetDriver@cb361>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@c1f8d<mailto:nl.cwi.monetdb.jdbc.MonetDriver@c1f8d>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@8fe97c<mailto:nl.cwi.monetdb.jdbc.MonetDriver@8fe97c>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1108377<mailto:nl.cwi.monetdb.jdbc.MonetDriver@1108377>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@faf9a3<mailto:nl.cwi.monetdb.jdbc.MonetDriver@faf9a3>
registerDriver: nl.cwi.monetdb.jdbc.MonetDriver@1c77aba<mailto: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<mailto:users-list@monetdb.org>
https://www.monetdb.org/mailman/listinfo/users-list<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.monetdb.org_mailman_listinfo_users-2Dlist&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=OrwiQ-p9MstmY03KxSiWdRVuUR85z5xmL2BKl34OKVU&s=bL8_GUV3jVm043gNieIpCf0t6xTXtX4QPE2rAaU2FZE&e=>