Need help using SQuirrel or another Windows SQL client
Hi all --
Hopefully someone in this group can help me. :-)
I am new to MonetDB and am having a problem setting up the connection for an SQL client.
Part of me is wondering if the problem is related to using the latest version of MonetDB (Oct 2020) with this MonetDB JDBC driver (monetdb-jdbc-2.29.jre7.jar).
I randomly chose SQuirrel on Windows and am open to alternatives. The connection I am trying to make is to MonetDB on Linux.
I followed the instructions carefully at: https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL
1. From Linux, here is my connection. I have no problems logging in on the host using mclient.
marc@HPZ620A: ip address
inet 10.102.96.66/24 brd 10.102.96.255 scope global dynamic noprefixroute eno1
marc@HPZ620A:~/tmp/mydbfarm$ mclient -u monetdb -d voc
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2020)
Database: MonetDB v11.39.5 (Oct2020), 'mapi:monetdb://HPZ620A:50001/voc'
sql>
2. Still on Linix, here is the Server Running.
marc@HPZ620A: ps -auxw | grep 50001
marc 21727 0.2 0.2 2640864 92616 ? Ssl Nov13 2:50 /usr/bin/mserver5 --dbpath=/home/marc/tmp/mydbfarm/voc --set merovingian_uri mapi:monetdb://HPZ620A:50001/voc --set mapi_listenaddr none --set mapi_usock /home/marc/tmp/mydbfarm/voc/.mapi.sock --set monet_vault_key /home/marc/tmp/mydbfarm/voc/.vaultkey --set gdk_nr_threads 32 --set max_clients 64 --set sql_optimizer default_pipe
3. From Windows, I can ping that server.
C:\Users\Admin>ping 10.102.96.66
Pinging 10.102.96.66 with 32 bytes of data:
Reply from 10.102.96.66: bytes=32 time=59ms TTL=63
Reply from 10.102.96.66: bytes=32 time=55ms TTL=63
Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Ping statistics for 10.102.96.66:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 55ms, Maximum = 59ms, Average = 57ms
4. The Squirrel Setup. Note that I did download the jar file from MonetDB, per the instructions.
5. And finally.. The error message when I try to connect!
Any suggestions on how I could solve this issue with SQuirrel or another Windows SQL client would be greatly appreciated.
Thanks!!
--- Marc
Hai Marc,
Could it be that port 50001 is not accessible from your windows machine? The "ping" msgs don't mean that port number is accessible.
Regards, Jennie
On 16 Nov 2020, at 20:46, marc@scifinsys.com marc@scifinsys.com wrote:
Hi all --
Hopefully someone in this group can help me. :-)
I am new to MonetDB and am having a problem setting up the connection for an SQL client. Part of me is wondering if the problem is related to using the latest version of MonetDB (Oct 2020) with this MonetDB JDBC driver (monetdb-jdbc-2.29.jre7.jar).
I randomly chose SQuirrel on Windows and am open to alternatives. The connection I am trying to make is to MonetDB on Linux. I followed the instructions carefully at: https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL
- From Linux, here is my connection. I have no problems logging in on the host using mclient.
marc@HPZ620A: ip address inet 10.102.96.66/24 brd 10.102.96.255 scope global dynamic noprefixroute eno1
marc@HPZ620A:~/tmp/mydbfarm$ mclient -u monetdb -d voc password: Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2020) Database: MonetDB v11.39.5 (Oct2020), 'mapi:monetdb://HPZ620A:50001/voc' monetdb://HPZ620A:50001/voc' sql>
- Still on Linix, here is the Server Running.
marc@HPZ620A: ps -auxw | grep 50001 marc 21727 0.2 0.2 2640864 92616 ? Ssl Nov13 2:50 /usr/bin/mserver5 --dbpath=/home/marc/tmp/mydbfarm/voc --set merovingian_uri mapi:monetdb://HPZ620A:50001/voc monetdb://HPZ620A:50001/voc --set mapi_listenaddr none --set mapi_usock /home/marc/tmp/mydbfarm/voc/.mapi.sock --set monet_vault_key /home/marc/tmp/mydbfarm/voc/.vaultkey --set gdk_nr_threads 32 --set max_clients 64 --set sql_optimizer default_pipe
- From Windows, I can ping that server.
C:\Users\Admin>ping 10.102.96.66
Pinging 10.102.96.66 with 32 bytes of data: Reply from 10.102.96.66: bytes=32 time=59ms TTL=63 Reply from 10.102.96.66: bytes=32 time=55ms TTL=63 Reply from 10.102.96.66: bytes=32 time=58ms TTL=63 Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Ping statistics for 10.102.96.66: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 55ms, Maximum = 59ms, Average = 57ms
- The Squirrel Setup. Note that I did download the jar file from MonetDB, per the instructions.
<image005.jpg>
- And finally…. The error message when I try to connect!
<image006.jpg>
Any suggestions on how I could solve this issue with SQuirrel or another Windows SQL client would be greatly appreciated.
Thanks!!
--- Marc
users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list
Interesting. I’ll try another port when I get home later and let you know. Thanks so much for replying Jennie.
-- Marc from my iPhone
On Nov 16, 2020, at 4:07 PM, Ying Zhang Y.Zhang@cwi.nl wrote:
Hai Marc,
Could it be that port 50001 is not accessible from your windows machine? The "ping" msgs don't mean that port number is accessible.
Regards, Jennie
On 16 Nov 2020, at 20:46, <marc@scifinsys.commailto:marc@scifinsys.com> <marc@scifinsys.commailto:marc@scifinsys.com> wrote:
Hi all --
Hopefully someone in this group can help me. :-)
I am new to MonetDB and am having a problem setting up the connection for an SQL client. Part of me is wondering if the problem is related to using the latest version of MonetDB (Oct 2020) with this MonetDB JDBC driver (monetdb-jdbc-2.29.jre7.jar).
I randomly chose SQuirrel on Windows and am open to alternatives. The connection I am trying to make is to MonetDB on Linux. I followed the instructions carefully at: https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL
1. From Linux, here is my connection. I have no problems logging in on the host using mclient.
marc@HPZ620A: ip address inet 10.102.96.66/24 brd 10.102.96.255 scope global dynamic noprefixroute eno1
marc@HPZ620A:~/tmp/mydbfarm$ mclient -u monetdb -d voc password: Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2020) Database: MonetDB v11.39.5 (Oct2020), 'mapi:monetdb://HPZ620A:50001/voc' sql>
2. Still on Linix, here is the Server Running.
marc@HPZ620A: ps -auxw | grep 50001 marc 21727 0.2 0.2 2640864 92616 ? Ssl Nov13 2:50 /usr/bin/mserver5 --dbpath=/home/marc/tmp/mydbfarm/voc --set merovingian_uri mapi:monetdb://HPZ620A:50001/voc --set mapi_listenaddr none --set mapi_usock /home/marc/tmp/mydbfarm/voc/.mapi.sock --set monet_vault_key /home/marc/tmp/mydbfarm/voc/.vaultkey --set gdk_nr_threads 32 --set max_clients 64 --set sql_optimizer default_pipe
3. From Windows, I can ping that server.
C:\Users\Admin>ping 10.102.96.66
Pinging 10.102.96.66 with 32 bytes of data: Reply from 10.102.96.66: bytes=32 time=59ms TTL=63 Reply from 10.102.96.66: bytes=32 time=55ms TTL=63 Reply from 10.102.96.66: bytes=32 time=58ms TTL=63 Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Ping statistics for 10.102.96.66: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 55ms, Maximum = 59ms, Average = 57ms
4. The Squirrel Setup. Note that I did download the jar file from MonetDB, per the instructions.
<image005.jpg>
5. And finally…. The error message when I try to connect!
<image006.jpg>
Any suggestions on how I could solve this issue with SQuirrel or another Windows SQL client would be greatly appreciated.
Thanks!!
--- Marc
_______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Possibly a wrong port number specified.
In your example 1. you use mclient without specifying a port number. This implies it is using default port 50000 to connect to mserver5 process, which succeeds. So try connecting with port number 50000 instead of 50001 in the JDBC URL string.
The rest (SQuirreL, MonetDB version, monetdb JDBC jar file, configuration of JDBC Driver, and Alias setup) all looks okay.
Martin
On 16-11-2020 22:26, Marc wrote:
Interesting. I’ll try another port when I get home later and let you know. Thanks so much for replying Jennie.
-- Marc from my iPhone
On Nov 16, 2020, at 4:07 PM, Ying Zhang Y.Zhang@cwi.nl wrote:
Hai Marc,
Could it be that port 50001 is not accessible from your windows machine? The "ping" msgs don't mean that port number is accessible.
Regards, Jennie
On 16 Nov 2020, at 20:46, <marc@scifinsys.com mailto:marc@scifinsys.com> <marc@scifinsys.com mailto:marc@scifinsys.com> wrote:
Hi all -- Hopefully someone in this group can help me. :-) I am new to MonetDB and am having a problem setting up the connection for an SQL client. Part of me is wondering if the problem is related to using the latest version of MonetDB (Oct 2020) with this MonetDB JDBC driver (monetdb-jdbc-2.29.jre7.jar). I randomly chose SQuirrel on Windows and am open to alternatives. The connection I am trying to make is to MonetDB on Linux. I followed the instructions carefully at:https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL
- From Linux, here is my connection. I have no problems logging in
on the host using mclient. marc@HPZ620A:*ip address* inet10.102.96.66/24 brd 10.102.96.255 scope global dynamic noprefixroute eno1 marc@HPZ620A:~/tmp/mydbfarm$ mclient -u monetdb -d voc password: Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2020) Database: MonetDB v11.39.5 (Oct2020),'mapi:monetdb://HPZ620A:50001/voc' monetdb://HPZ620A:50001/voc%27 sql>
- Still on Linix, here is the Server Running.
marc@HPZ620A:*ps -auxw | grep 50001* marc 21727 0.2 0.2 2640864 92616 ? Ssl Nov13 2:50 /usr/bin/mserver5 --dbpath=/home/marc/tmp/mydbfarm/voc --set merovingian_uri*mapi:monetdb://HPZ620A:50001/voc*--set mapi_listenaddr none --set mapi_usock /home/marc/tmp/mydbfarm/voc/.mapi.sock --set monet_vault_key /home/marc/tmp/mydbfarm/voc/.vaultkey --set gdk_nr_threads 32 --set max_clients 64 --set sql_optimizer default_pipe
- From Windows, I can ping that server.
C:\Users\Admin>ping 10.102.96.66 Pinging 10.102.96.66 with 32 bytes of data: Reply from 10.102.96.66: bytes=32 time=59ms TTL=63 Reply from 10.102.96.66: bytes=32 time=55ms TTL=63 Reply from 10.102.96.66: bytes=32 time=58ms TTL=63 Reply from 10.102.96.66: bytes=32 time=58ms TTL=63 Ping statistics for 10.102.96.66: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 55ms, Maximum = 59ms, Average = 57ms
- The Squirrel Setup. Note that I did download the jar file from
MonetDB, per the instructions. <image005.jpg> 5. And finally…. The error message when I try to connect! <image006.jpg> Any suggestions on how I could solve this issue with SQuirrel or another Windows SQL client would be greatly appreciated. Thanks!! --- Marc _______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Possibly a wrong port number specified.
In your example 1. you use mclient without specifying a port number. This implies it is using default port 50000 to connect to mserver5 process, which succeeds. So try connecting with port number 50000 instead of 50001 in the JDBC URL string.
The rest (SQuirreL, MonetDB version, monetdb JDBC jar file, configuration of JDBC Driver, and Alias setup) all looks okay.
Martin
On 16-11-2020 20:46, marc@scifinsys.com wrote:
Hi all --
Hopefully someone in this group can help me. :-)
I am new to MonetDB and am having a problem setting up the connection for an SQL client.
Part of me is wondering if the problem is related to using the latest version of MonetDB (Oct 2020) with this MonetDB JDBC driver (monetdb-jdbc-2.29.jre7.jar).
I randomly chose SQuirrel on Windows and am open to alternatives. The connection I am trying to make is to MonetDB on Linux.
I followed the instructions carefully at: https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL
- From Linux, here is my connection. I have no problems logging in on
the host using mclient.
marc@HPZ620A: *ip address*
inet 10.102.96.66/24 brd 10.102.96.255 scope global dynamic noprefixroute eno1
marc@HPZ620A:~/tmp/mydbfarm$ mclient -u monetdb -d voc
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2020)
Database: MonetDB v11.39.5 (Oct2020), 'mapi:monetdb://HPZ620A:50001/voc'
sql>
- Still on Linix, here is the Server Running.
marc@HPZ620A: *ps -auxw | grep 50001*
marc 21727 0.2 0.2 2640864 92616 ? Ssl Nov13 2:50 /usr/bin/mserver5 --dbpath=/home/marc/tmp/mydbfarm/voc --set merovingian_uri *mapi:monetdb://HPZ620A:50001/voc*--set mapi_listenaddr none --set mapi_usock /home/marc/tmp/mydbfarm/voc/.mapi.sock --set monet_vault_key /home/marc/tmp/mydbfarm/voc/.vaultkey --set gdk_nr_threads 32 --set max_clients 64 --set sql_optimizer default_pipe
- From Windows, I can ping that server.
C:\Users\Admin>ping 10.102.96.66
Pinging 10.102.96.66 with 32 bytes of data:
Reply from 10.102.96.66: bytes=32 time=59ms TTL=63
Reply from 10.102.96.66: bytes=32 time=55ms TTL=63
Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Ping statistics for 10.102.96.66:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 55ms, Maximum = 59ms, Average = 57ms
- The Squirrel Setup. Note that I did download the jar file from
MonetDB, per the instructions.
- And finally…. The error message when I try to connect!
Any suggestions on how I could solve this issue with SQuirrel or another Windows SQL client would be greatly appreciated.
Thanks!!
--- Marc
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi Martin. Thank you so much for your reply. If you look at when I start the mclient, I had put in red that it confirmed the server was using port 50001.
The reason I started the server with that port was because port 50000 was already occupied, though I’m not sure by what.
Any other thoughts on what I can try?
Beat regards,
-- Marc from my iPhone
On Nov 16, 2020, at 6:50 PM, Martin van Dinther dinther@monetdbsolutions.com wrote:
Possibly a wrong port number specified.
In your example 1. you use mclient without specifying a port number. This implies it is using default port 50000 to connect to mserver5 process, which succeeds. So try connecting with port number 50000 instead of 50001 in the JDBC URL string.
The rest (SQuirreL, MonetDB version, monetdb JDBC jar file, configuration of JDBC Driver, and Alias setup) all looks okay.
Martin
On 16-11-2020 20:46, marc@scifinsys.commailto:marc@scifinsys.com wrote:
Hi all --
Hopefully someone in this group can help me. :-)
I am new to MonetDB and am having a problem setting up the connection for an SQL client.
Part of me is wondering if the problem is related to using the latest version of MonetDB (Oct 2020) with this MonetDB JDBC driver (monetdb-jdbc-2.29.jre7.jar).
I randomly chose SQuirrel on Windows and am open to alternatives. The connection I am trying to make is to MonetDB on Linux.
I followed the instructions carefully at: https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL
1. From Linux, here is my connection. I have no problems logging in on the host using mclient.
marc@HPZ620A: ip address
inet 10.102.96.66/24 brd 10.102.96.255 scope global dynamic noprefixroute eno1
marc@HPZ620A:~/tmp/mydbfarm$ mclient -u monetdb -d voc
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2020)
Database: MonetDB v11.39.5 (Oct2020), 'mapi:monetdb://HPZ620A:50001/voc'
sql>
2. Still on Linix, here is the Server Running.
marc@HPZ620A: ps -auxw | grep 50001
marc 21727 0.2 0.2 2640864 92616 ? Ssl Nov13 2:50 /usr/bin/mserver5 --dbpath=/home/marc/tmp/mydbfarm/voc --set merovingian_uri mapi:monetdb://HPZ620A:50001/voc --set mapi_listenaddr none --set mapi_usock /home/marc/tmp/mydbfarm/voc/.mapi.sock --set monet_vault_key /home/marc/tmp/mydbfarm/voc/.vaultkey --set gdk_nr_threads 32 --set max_clients 64 --set sql_optimizer default_pipe
3. From Windows, I can ping that server.
C:\Users\Admin>ping 10.102.96.66
Pinging 10.102.96.66 with 32 bytes of data:
Reply from 10.102.96.66: bytes=32 time=59ms TTL=63
Reply from 10.102.96.66: bytes=32 time=55ms TTL=63
Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Ping statistics for 10.102.96.66:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 55ms, Maximum = 59ms, Average = 57ms
4. The Squirrel Setup. Note that I did download the jar file from MonetDB, per the instructions.
<image005.jpg>
5. And finally…. The error message when I try to connect!
<image006.jpg>
Any suggestions on how I could solve this issue with SQuirrel or another Windows SQL client would be greatly appreciated.
Thanks!!
--- Marc
_______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hai Marc,
On 17 Nov 2020, at 01:48, Marc marc@scifinsys.com wrote:
Hi Martin. Thank you so much for your reply. If you look at when I start the mclient, I had put in red that it confirmed the server was using port 50001.
I saw that and I was a bit surprised
The reason I started the server with that port was because port 50000 was already occupied, though I’m not sure by what.
50000 is the default port MonetDB uses...
Any other thoughts on what I can try?
Your database is probably only accepting connection from the "localhost".
See the first item of the Oct2020 release notes: https://www.monetdb.org/Downloads/ReleaseNotes
You probably need to set "listenaddr" to "all" so that the database will also accept connections from another machine.
If you tell us the exact commands you used to start this database, I can give you some commands to try. Unfortunately, I can't test them myself. SQuirreL doesn't work on my windows machine :(
- Jennie
PS> which Linux distribution? Which Windows and JDK?
Beat regards,
-- Marc from my iPhone
On Nov 16, 2020, at 6:50 PM, Martin van Dinther dinther@monetdbsolutions.com wrote:
Possibly a wrong port number specified.
In your example 1. you use mclient without specifying a port number. This implies it is using default port 50000 to connect to mserver5 process, which succeeds. So try connecting with port number 50000 instead of 50001 in the JDBC URL string.
The rest (SQuirreL, MonetDB version, monetdb JDBC jar file, configuration of JDBC Driver, and Alias setup) all looks okay.
Martin
On 16-11-2020 20:46, marc@scifinsys.com mailto:marc@scifinsys.com wrote:
Hi all --
Hopefully someone in this group can help me. :-)
I am new to MonetDB and am having a problem setting up the connection for an SQL client. Part of me is wondering if the problem is related to using the latest version of MonetDB (Oct 2020) with this MonetDB JDBC driver (monetdb-jdbc-2.29.jre7.jar).
I randomly chose SQuirrel on Windows and am open to alternatives. The connection I am trying to make is to MonetDB on Linux. I followed the instructions carefully at: https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL
- From Linux, here is my connection. I have no problems logging in on the host using mclient.
marc@HPZ620A: ip address inet 10.102.96.66/24 brd 10.102.96.255 scope global dynamic noprefixroute eno1
marc@HPZ620A:~/tmp/mydbfarm$ mclient -u monetdb -d voc password: Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2020) Database: MonetDB v11.39.5 (Oct2020), 'mapi:monetdb://HPZ620A:50001/voc' sql>
- Still on Linix, here is the Server Running.
marc@HPZ620A: ps -auxw | grep 50001 marc 21727 0.2 0.2 2640864 92616 ? Ssl Nov13 2:50 /usr/bin/mserver5 --dbpath=/home/marc/tmp/mydbfarm/voc --set merovingian_urimapi:monetdb://HPZ620A:50001/voc --set mapi_listenaddr none --set mapi_usock /home/marc/tmp/mydbfarm/voc/.mapi.sock --set monet_vault_key /home/marc/tmp/mydbfarm/voc/.vaultkey --set gdk_nr_threads 32 --set max_clients 64 --set sql_optimizer default_pipe
- From Windows, I can ping that server.
C:\Users\Admin>ping 10.102.96.66
Pinging 10.102.96.66 with 32 bytes of data: Reply from 10.102.96.66: bytes=32 time=59ms TTL=63 Reply from 10.102.96.66: bytes=32 time=55ms TTL=63 Reply from 10.102.96.66: bytes=32 time=58ms TTL=63 Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Ping statistics for 10.102.96.66: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 55ms, Maximum = 59ms, Average = 57ms
- The Squirrel Setup. Note that I did download the jar file from MonetDB, per the instructions.
<image005.jpg>
- And finally…. The error message when I try to connect!
<image006.jpg>
Any suggestions on how I could solve this issue with SQuirrel or another Windows SQL client would be greatly appreciated.
Thanks!!
--- Marc
users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
<image006.jpg><image005.jpg>_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list
Thanks Ying! I’m sharing this solution with all users.
My connection with Squirrel is now working. I am embarrassed to say that I didn’t read the Release Notes and the answer was in your suggestion to…
See the first item of the Oct2020 release notes: https://www.monetdb.org/Downloads/ReleaseNotes
Thank you again to everyone who sent me suggestions. I look forward to contributing to this community.
Best regards,
--- Marc
From: users-list users-list-bounces+marc=scifinsys.com@monetdb.org On Behalf Of Ying Zhang Sent: Tuesday, November 17, 2020 4:13 AM To: Communication channel for MonetDB users users-list@monetdb.org Subject: Re: Need help using SQuirrel or another Windows SQL client
Hi Marc,
On 17 Nov 2020, at 01:48, Marc <marc@scifinsys.com mailto:marc@scifinsys.com > wrote:
Hi Martin. Thank you so much for your reply. If you look at when I start the mclient, I had put in red that it confirmed the server was using port 50001.
I saw that and I was a bit surprised
The reason I started the server with that port was because port 50000 was already occupied, though I’m not sure by what.
50000 is the default port MonetDB uses...
Any other thoughts on what I can try?
Your database is probably only accepting connection from the "localhost".
See the first item of the Oct2020 release notes: https://www.monetdb.org/Downloads/ReleaseNotes
You probably need to set "listenaddr" to "all" so that the database will also accept connections from another machine.
If you tell us the exact commands you used to start this database, I can give you some commands to try.
Unfortunately, I can't test them myself. SQuirreL doesn't work on my windows machine :(
- Jennie
PS> which Linux distribution? Which Windows and JDK?
Beat regards,
-- Marc from my iPhone
On Nov 16, 2020, at 6:50 PM, Martin van Dinther <dinther@monetdbsolutions.com mailto:dinther@monetdbsolutions.com > wrote:
Possibly a wrong port number specified.
In your example 1. you use mclient without specifying a port number. This implies it is using default port 50000 to connect to mserver5 process, which succeeds. So try connecting with port number 50000 instead of 50001 in the JDBC URL string.
The rest (SQuirreL, MonetDB version, monetdb JDBC jar file, configuration of JDBC Driver, and Alias setup) all looks okay.
Martin
On 16-11-2020 20:46, mailto:marc@scifinsys.com marc@scifinsys.com wrote:
Hi all --
Hopefully someone in this group can help me. :-)
I am new to MonetDB and am having a problem setting up the connection for an SQL client.
Part of me is wondering if the problem is related to using the latest version of MonetDB (Oct 2020) with this MonetDB JDBC driver (monetdb-jdbc-2.29.jre7.jar).
I randomly chose SQuirrel on Windows and am open to alternatives. The connection I am trying to make is to MonetDB on Linux.
I followed the instructions carefully at: https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL
1. From Linux, here is my connection. I have no problems logging in on the host using mclient.
marc@HPZ620A: ip address
inet 10.102.96.66/24 brd 10.102.96.255 scope global dynamic noprefixroute eno1
marc@HPZ620A:~/tmp/mydbfarm$ mclient -u monetdb -d voc
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2020)
Database: MonetDB v11.39.5 (Oct2020), 'mapi:monetdb://HPZ620A:50001/voc'
sql>
2. Still on Linix, here is the Server Running.
marc@HPZ620A: ps -auxw | grep 50001
marc 21727 0.2 0.2 2640864 92616 ? Ssl Nov13 2:50 /usr/bin/mserver5 --dbpath=/home/marc/tmp/mydbfarm/voc --set merovingian_urimapi:monetdb://HPZ620A:50001/voc --set mapi_listenaddr none --set mapi_usock /home/marc/tmp/mydbfarm/voc/.mapi.sock --set monet_vault_key /home/marc/tmp/mydbfarm/voc/.vaultkey --set gdk_nr_threads 32 --set max_clients 64 --set sql_optimizer default_pipe
3. From Windows, I can ping that server.
C:\Users\Admin>ping 10.102.96.66
Pinging 10.102.96.66 with 32 bytes of data:
Reply from 10.102.96.66: bytes=32 time=59ms TTL=63
Reply from 10.102.96.66: bytes=32 time=55ms TTL=63
Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Ping statistics for 10.102.96.66:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 55ms, Maximum = 59ms, Average = 57ms
4. The Squirrel Setup. Note that I did download the jar file from MonetDB, per the instructions.
<image005.jpg>
5. And finally…. The error message when I try to connect!
<image006.jpg>
Any suggestions on how I could solve this issue with SQuirrel or another Windows SQL client would be greatly appreciated.
Thanks!!
--- Marc
_______________________________________________ users-list mailing list mailto:users-list@monetdb.org users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
<image006.jpg><image005.jpg>_______________________________________________ users-list mailing list mailto:users-list@monetdb.org users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list
Hai Marc,
Glad it helped. Enjoy!
- Jennie
On 18 Nov 2020, at 00:32, marc@scifinsys.com wrote:
Thanks Ying! I’m sharing this solution with all users.
My connection with Squirrel is now working. I am embarrassed to say that I didn’t read the Release Notes and the answer was in your suggestion to… See the first item of the Oct2020 release notes: https://www.monetdb.org/Downloads/ReleaseNotes https://www.monetdb.org/Downloads/ReleaseNotes
Thank you again to everyone who sent me suggestions. I look forward to contributing to this community.
Best regards, --- Marc
From: users-list <users-list-bounces+marc=scifinsys.com@monetdb.org mailto:users-list-bounces+marc=scifinsys.com@monetdb.org> On Behalf Of Ying Zhang Sent: Tuesday, November 17, 2020 4:13 AM To: Communication channel for MonetDB users <users-list@monetdb.org mailto:users-list@monetdb.org> Subject: Re: Need help using SQuirrel or another Windows SQL client
Hi Marc,
On 17 Nov 2020, at 01:48, Marc <marc@scifinsys.com mailto:marc@scifinsys.com> wrote:
Hi Martin. Thank you so much for your reply. If you look at when I start the mclient, I had put in red that it confirmed the server was using port 50001.
I saw that and I was a bit surprised
The reason I started the server with that port was because port 50000 was already occupied, though I’m not sure by what.
50000 is the default port MonetDB uses...
Any other thoughts on what I can try?
Your database is probably only accepting connection from the "localhost".
See the first item of the Oct2020 release notes: https://www.monetdb.org/Downloads/ReleaseNotes https://www.monetdb.org/Downloads/ReleaseNotes
You probably need to set "listenaddr" to "all" so that the database will also accept connections from another machine.
If you tell us the exact commands you used to start this database, I can give you some commands to try. Unfortunately, I can't test them myself. SQuirreL doesn't work on my windows machine :(
- Jennie
PS> which Linux distribution? Which Windows and JDK?
Beat regards,
-- Marc from my iPhone
On Nov 16, 2020, at 6:50 PM, Martin van Dinther <dinther@monetdbsolutions.com mailto:dinther@monetdbsolutions.com> wrote:
Possibly a wrong port number specified. In your example 1. you use mclient without specifying a port number. This implies it is using default port 50000 to connect to mserver5 process, which succeeds. So try connecting with port number 50000 instead of 50001 in the JDBC URL string. The rest (SQuirreL, MonetDB version, monetdb JDBC jar file, configuration of JDBC Driver, and Alias setup) all looks okay. Martin
On 16-11-2020 20:46, marc@scifinsys.com mailto:marc@scifinsys.com wrote:
Hi all --
Hopefully someone in this group can help me. :-)
I am new to MonetDB and am having a problem setting up the connection for an SQL client. Part of me is wondering if the problem is related to using the latest version of MonetDB (Oct 2020) with this MonetDB JDBC driver (monetdb-jdbc-2.29.jre7.jar).
I randomly chose SQuirrel on Windows and am open to alternatives. The connection I am trying to make is to MonetDB on Linux. I followed the instructions carefully at: https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL https://www.monetdb.org/Documentation/ClientInterfaces/SQuirreL
- From Linux, here is my connection. I have no problems logging in on the host using mclient.
marc@HPZ620A: ip address inet 10.102.96.66/24 brd 10.102.96.255 scope global dynamic noprefixroute eno1
marc@HPZ620A:~/tmp/mydbfarm$ mclient -u monetdb -d voc password: Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2020) Database: MonetDB v11.39.5 (Oct2020), 'mapi:monetdb://HPZ620A:50001/voc' monetdb://HPZ620A:50001/voc' sql>
- Still on Linix, here is the Server Running.
marc@HPZ620A: ps -auxw | grep 50001 marc 21727 0.2 0.2 2640864 92616 ? Ssl Nov13 2:50 /usr/bin/mserver5 --dbpath=/home/marc/tmp/mydbfarm/voc --set merovingian_urimapi:monetdb://HPZ620A:50001/voc monetdb://HPZ620A:50001/voc --set mapi_listenaddr none --set mapi_usock /home/marc/tmp/mydbfarm/voc/.mapi.sock --set monet_vault_key /home/marc/tmp/mydbfarm/voc/.vaultkey --set gdk_nr_threads 32 --set max_clients 64 --set sql_optimizer default_pipe
- From Windows, I can ping that server.
C:\Users\Admin>ping 10.102.96.66
Pinging 10.102.96.66 with 32 bytes of data: Reply from 10.102.96.66: bytes=32 time=59ms TTL=63 Reply from 10.102.96.66: bytes=32 time=55ms TTL=63 Reply from 10.102.96.66: bytes=32 time=58ms TTL=63 Reply from 10.102.96.66: bytes=32 time=58ms TTL=63
Ping statistics for 10.102.96.66: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 55ms, Maximum = 59ms, Average = 57ms
- The Squirrel Setup. Note that I did download the jar file from MonetDB, per the instructions.
<image005.jpg>
- And finally…. The error message when I try to connect!
<image006.jpg>
Any suggestions on how I could solve this issue with SQuirrel or another Windows SQL client would be greatly appreciated.
Thanks!!
--- Marc
users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list
<image006.jpg><image005.jpg>_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list
participants (4)
-
Marc -
marc＠scifinsys.com
-
Martin van Dinther -
Ying Zhang