beginning with monetdb on windows
Hi,
I'm new to the MonetDB, and trying MonetDB on Windows.
At first, I have installed MonetDB on Windows with using MonetDB5-SQL-Installer-x86_64-20130227.msi. http://dev.monetdb.org/downloads/Windows/Feb2013-SP1/
Then, I attempted to follow the Getting Started guide. http://www.monetdb.org/Documentation/Tutorial
However, I couldn't find monetdb.exe(bat?) and monetdbd.exe(bat?) in my monetdb installed directory.
What can I do for the first step? Any comments?
Regards,
Hi,
as the text at http://www.monetdb.org/Documentation/Tutorial says, monedbd & monetdb are only available on Linux (and other Unix-like systems), but not on Windows. As the test at http://www.monetdb.org/Documentation/Tutorial says, Windows-specific instructions are available at the end of that page in the section titled "WINDOWS".
Best, Stefan
----- Original Message -----
Hi,
I'm new to the MonetDB, and trying MonetDB on Windows.
At first, I have installed MonetDB on Windows with using MonetDB5-SQL-Installer-x86_64-20130227.msi. http://dev.monetdb.org/downloads/Windows/Feb2013-SP1/
Then, I attempted to follow the Getting Started guide. http://www.monetdb.org/Documentation/Tutorial
However, I couldn't find monetdb.exe(bat?) and monetdbd.exe(bat?) in my monetdb installed directory.
What can I do for the first step? Any comments?
Regards,
Satoshi Nagayasu snaga@uptime.jp Uptime Technologies, LLC. http://www.uptime.jp _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
(2013/04/07 21:49), Stefan Manegold wrote:
as the text at http://www.monetdb.org/Documentation/Tutorial says, monedbd & monetdb are only available on Linux (and other Unix-like systems), but not on Windows. As the test at http://www.monetdb.org/Documentation/Tutorial says, Windows-specific instructions are available at the end of that page in the section titled "WINDOWS".
Agh, I'm not sure why I couldn't catch that when reading the tutorial. Thanks.
I have another question here.
When I launch the client after the server is loaded, the client window shows only blank screen with no message.
And then (after 1 minute, maybe), the client tells me "Connection terminated".
What's wrong with this? Any suggestion?
Regards,
On Apr 08, 2013, at 07:03, Satoshi Nagayasu wrote:
(2013/04/07 21:49), Stefan Manegold wrote:
as the text at http://www.monetdb.org/Documentation/Tutorial says, monedbd & monetdb are only available on Linux (and other Unix-like systems), but not on Windows. As the test at http://www.monetdb.org/Documentation/Tutorial says, Windows-specific instructions are available at the end of that page in the section titled "WINDOWS".
Agh, I'm not sure why I couldn't catch that when reading the tutorial. Thanks.
I have another question here.
When I launch the client after the server is loaded, the client window shows only blank screen with no message.
And then (after 1 minute, maybe), the client tells me "Connection terminated".
Hello Satoshi,
This message usually indicate the server has crashed (segmentation fault). It feels like the client connection has triggered the server to do something, but crashed during the execution. How did you start the server and the client? Did you start the .EXE files directly or via the Start menu shortcuts? Do you happen to have a 'dbfarm' that was created by a much older version of MonetDB?
With kind regards,
Jennie
What's wrong with this? Any suggestion?
Regards,
Satoshi Nagayasu snaga@uptime.jp Uptime Technologies, LLC. http://www.uptime.jp _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Hi Ying,
Thanks for the suggestion.
(2013/04/09 2:06), Ying Zhang wrote:
On Apr 08, 2013, at 07:03, Satoshi Nagayasu wrote:
(2013/04/07 21:49), Stefan Manegold wrote:
as the text at http://www.monetdb.org/Documentation/Tutorial says, monedbd & monetdb are only available on Linux (and other Unix-like systems), but not on Windows. As the test at http://www.monetdb.org/Documentation/Tutorial says, Windows-specific instructions are available at the end of that page in the section titled "WINDOWS".
Agh, I'm not sure why I couldn't catch that when reading the tutorial. Thanks.
I have another question here.
When I launch the client after the server is loaded, the client window shows only blank screen with no message.
And then (after 1 minute, maybe), the client tells me "Connection terminated".
Hello Satoshi,
This message usually indicate the server has crashed (segmentation fault). It feels like the client connection has triggered the server to do something, but crashed during the execution. How did you start the server and the client? Did you start the .EXE files directly or via the Start menu shortcuts?
I started the server (and then, the client) with the shortcuts in Windows Start menu, as described in the tutorial.
The server seems starting correctly, but the client seems not being able to connect to the server.
BTW, is this a correct output on starting the server? ------------------------------------------------- # MonetDB 5 server v11.15.3 "Feb2013-SP1" # Serving database 'demo', using 4 threads # Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked # Found 5.800 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/JAQL module loaded # MonetDB/SQL module loaded
-------------------------------------------------
Do you happen to have a 'dbfarm' that was created by a much older version of MonetDB?
I guess no, because it's my first installation of MonetDB.
I removed the existing dbfarm directory from C:\Users\snaga\AppData\Roaming\MonetDB5, and started the server again. But the client still does not respond, and the server (mserver5.exe) seems running (or just waiting).
Also I tried to turn off my personal firewall, but it didn't help me...
Regards,
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
The client by default tries to connect to a server on a host called "localhost" which then needs to be resolved to the correct IP address. Many Windows systems are not configured properly, so can you check yours to see that "localhost" can get resolved to 127.0.0.1? You can also try to edit the file C:\Program Files\MonetDB\MonetDB5\mclient.bat and add the option - -h 127.0.0.1 to the invocation of mclient.exe to see if that helps.
On 2013-04-09 07:50, Satoshi Nagayasu wrote:
Hi Ying,
Thanks for the suggestion.
(2013/04/09 2:06), Ying Zhang wrote:
On Apr 08, 2013, at 07:03, Satoshi Nagayasu wrote:
(2013/04/07 21:49), Stefan Manegold wrote:
as the text at http://www.monetdb.org/Documentation/Tutorial says, monedbd & monetdb are only available on Linux (and other Unix-like systems), but not on Windows. As the test at http://www.monetdb.org/Documentation/Tutorial says, Windows-specific instructions are available at the end of that page in the section titled "WINDOWS".
Agh, I'm not sure why I couldn't catch that when reading the tutorial. Thanks.
I have another question here.
When I launch the client after the server is loaded, the client window shows only blank screen with no message.
And then (after 1 minute, maybe), the client tells me "Connection terminated".
Hello Satoshi,
This message usually indicate the server has crashed (segmentation fault). It feels like the client connection has triggered the server to do something, but crashed during the execution. How did you start the server and the client? Did you start the .EXE files directly or via the Start menu shortcuts?
I started the server (and then, the client) with the shortcuts in Windows Start menu, as described in the tutorial.
The server seems starting correctly, but the client seems not being able to connect to the server.
BTW, is this a correct output on starting the server? ------------------------------------------------- # MonetDB 5 server v11.15.3 "Feb2013-SP1" # Serving database 'demo', using 4 threads # Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked # Found 5.800 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/JAQL module loaded # MonetDB/SQL module loaded
Do you happen to have a 'dbfarm' that was created by a much older version of MonetDB?
I guess no, because it's my first installation of MonetDB.
I removed the existing dbfarm directory from C:\Users\snaga\AppData\Roaming\MonetDB5, and started the server again. But the client still does not respond, and the server (mserver5.exe) seems running (or just waiting).
Also I tried to turn off my personal firewall, but it didn't help me...
Regards,
- -- Sjoerd Mullender
Hi Sjoerd,
(2013/04/09 17:10), Sjoerd Mullender wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
The client by default tries to connect to a server on a host called "localhost" which then needs to be resolved to the correct IP address. Many Windows systems are not configured properly, so can you check yours to see that "localhost" can get resolved to 127.0.0.1? You can also try to edit the file C:\Program Files\MonetDB\MonetDB5\mclient.bat and add the option
- -h 127.0.0.1
to the invocation of mclient.exe to see if that helps.
Yeah, that's it! Finally, I have succeeded to connect to the server. Thanks!
I've been working on Linux for most of my database tasks, but I'm trying to deliver MonetDB on Windows for non-tech people.
BTW, I tried MonetDB on Linux yesterday, and my initial tests (several DSS queries) showed an impressive performance. It was extremely faster than traditional RDBMS. Actualy, it's my first experience for the column-store database, and I'm so impressed. :)
Regards,
On 2013-04-09 07:50, Satoshi Nagayasu wrote:
Hi Ying,
Thanks for the suggestion.
(2013/04/09 2:06), Ying Zhang wrote:
On Apr 08, 2013, at 07:03, Satoshi Nagayasu wrote:
(2013/04/07 21:49), Stefan Manegold wrote:
as the text at http://www.monetdb.org/Documentation/Tutorial says, monedbd & monetdb are only available on Linux (and other Unix-like systems), but not on Windows. As the test at http://www.monetdb.org/Documentation/Tutorial says, Windows-specific instructions are available at the end of that page in the section titled "WINDOWS".
Agh, I'm not sure why I couldn't catch that when reading the tutorial. Thanks.
I have another question here.
When I launch the client after the server is loaded, the client window shows only blank screen with no message.
And then (after 1 minute, maybe), the client tells me "Connection terminated".
Hello Satoshi,
This message usually indicate the server has crashed (segmentation fault). It feels like the client connection has triggered the server to do something, but crashed during the execution. How did you start the server and the client? Did you start the .EXE files directly or via the Start menu shortcuts?
I started the server (and then, the client) with the shortcuts in Windows Start menu, as described in the tutorial.
The server seems starting correctly, but the client seems not being able to connect to the server.
BTW, is this a correct output on starting the server? ------------------------------------------------- # MonetDB 5 server v11.15.3 "Feb2013-SP1" # Serving database 'demo', using 4 threads # Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked # Found 5.800 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/JAQL module loaded # MonetDB/SQL module loaded
Do you happen to have a 'dbfarm' that was created by a much older version of MonetDB?
I guess no, because it's my first installation of MonetDB.
I removed the existing dbfarm directory from C:\Users\snaga\AppData\Roaming\MonetDB5, and started the server again. But the client still does not respond, and the server (mserver5.exe) seems running (or just waiting).
Also I tried to turn off my personal firewall, but it didn't help me...
Regards,
Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.13 (GNU/Linux) Comment: Using GnuPG with undefined - http://www.enigmail.net/
iQCVAwUBUWPNBz7g04AjvIQpAQJi7wQAhRZnanq5yxWJyWmUw666MXYeOl1su6ze SZ1WlP7j6ufa34YpWqL+VFm2K8YbmwF2kIIz1zQo1DQ8lZD8dk8x0U5mO5tBGHbr SwNwXmy603MTZnH6wO4OCrnXPFD99mcHmeEOimT/dV4e0nySfFpjJLWH4Bv46kwB uysyUTpgtj4= =3Rff -----END PGP SIGNATURE----- _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (4)
-
Satoshi Nagayasu -
Sjoerd Mullender -
Stefan Manegold -
Ying Zhang