On Jul 16, 2016 08:16, "Anderson, David B" <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'
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