MonetDB problem with mserver.exe
Hello,
I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...
1) ...I went to https://www.monetdb.org/downloads/Windows/Jan2014-SP2/
2) ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver)
3) ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program Files\MonetDB\MonetDB ODBC Driver)
4) ...and finally I installed the MonetDB SQL server and client, 64 bit (to C:\Program Files\MonetDB\MonetDB5).
When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?
I would appreciate any hint. Thanks in advance.
Kaspar Burger
On 09/06/14 16:28, Kaspar Burger wrote:
Hello,
I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...
Most likely, you need only 1 ODBC driver. Otherwise causing a clash.
- ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program
Files (x86)\MonetDB\MonetDB ODBC Driver)
- ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program
Files\MonetDB\MonetDB ODBC Driver)
- ...and finally I installed the MonetDB SQL server and client, 64 bit
(to C:\Program Files\MonetDB\MonetDB5).
When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?
I would appreciate any hint. Thanks in advance.
Kaspar Burger
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
On 09/06/14 16:28, Kaspar Burger wrote:
Hello,
I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...
Most likely, you need only 1 ODBC driver. Otherwise causing a clash.
For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)
Stefan
- ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program
Files (x86)\MonetDB\MonetDB ODBC Driver)
- ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program
Files\MonetDB\MonetDB ODBC Driver)
- ...and finally I installed the MonetDB SQL server and client, 64 bit
(to C:\Program Files\MonetDB\MonetDB5).
When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?
I would appreciate any hint. Thanks in advance.
Kaspar Burger
users-list mailing list 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
On 2014-06-10 00:06, Stefan Manegold wrote:
On 09/06/14 16:28, Kaspar Burger wrote:
Hello,
I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...
Most likely, you need only 1 ODBC driver. Otherwise causing a clash.
For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)
You need both in order to support both 32 and 64 bit applications. That's the only reason to install both.
Stefan
- ...and first installed the MonetDB ODBC driver, 32 bit (to C:\Program
Files (x86)\MonetDB\MonetDB ODBC Driver)
- ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program
Files\MonetDB\MonetDB ODBC Driver)
- ...and finally I installed the MonetDB SQL server and client, 64 bit
(to C:\Program Files\MonetDB\MonetDB5).
When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?
Did you start the server using the start menu? That actually runs a cmd script to set a bunch of environment variables before starting the actual server mserver5.exe.
I would appreciate any hint. Thanks in advance.
Kaspar Burger
users-list mailing list 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
Thanks.
I am working in R, configuring a MonetDB test database and trying to access MonetDB with the following code:
batfile <- "C:/Users/Kaspar Burger/MonetDB/test.bat" pid <- monetdb.server.start( batfile ) dbname <- "test" dbport <- 50000 monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname ) db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE )
When I run the pid <- monetdb.server.start( batfile ) line, the mserver5.exe opens briefly but shuts down immediately afterwards (for a more extensive description of the R code, see: https://raw.githubusercontent.com/ajdamico/usgsd/master/MonetDB/monetdb%20da...). By contrast, running the batch file from C:\Program Files\MonetDB\MonetDB5\M5server.bat or from the Start menu works fine. I tried when both drivers were installed as well as when only one driver was installed. Could that problem be related to R or to my code?
Kaspar
On 2014-06-10 00:06, Stefan Manegold wrote:
On 09/06/14 16:28, Kaspar Burger wrote:
Hello,
I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...
- ...I went to
Most likely, you need only 1 ODBC driver. Otherwise causing a clash.
For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)
You need both in order to support both 32 and 64 bit applications. That's the only reason to install both.
Stefan
- ...and first installed the MonetDB ODBC driver, 32 bit (to
C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver)
- ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program
Files\MonetDB\MonetDB ODBC Driver)
- ...and finally I installed the MonetDB SQL server and client, 64
bit (to C:\Program Files\MonetDB\MonetDB5).
When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?
Did you start the server using the start menu? That actually runs a cmd script to set a bunch of environment variables before starting the actual server mserver5.exe.
I would appreciate any hint. Thanks in advance.
Kaspar Burger
users-list mailing list 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
-- Sjoerd Mullender
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
This seems to fall into my backyard...
On 10.06.2014, at 08:32, Kaspar Burger kaspar.burger@iukb.ch wrote:
I am working in R, configuring a MonetDB test database and trying to access MonetDB with the following code:
batfile <- "C:/Users/Kaspar Burger/MonetDB/test.bat" pid <- monetdb.server.start( batfile ) dbname <- "test" dbport <- 50000 monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname ) db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE )
When I run the “pid <- monetdb.server.start( batfile )” line, the mserver5.exe opens briefly but shuts down immediately afterwards (for a more extensive description of the R code, see: https://raw.githubusercontent.com/ajdamico/usgsd/master/MonetDB/monetdb%20da...). By contrast, running the batch file from C:\Program Files\MonetDB\MonetDB5\M5server.bat or from the Start menu works fine. I tried when both drivers were installed as well as when only one driver was installed. Could that problem be related to R or to my code?
Would not be surprised if the space in the batfile path causes the problem. Try setting up the DB into another directory without a space in it and try again.
Best,
Hannes
On 2014-06-10 00:06, Stefan Manegold wrote:
On 09/06/14 16:28, Kaspar Burger wrote:
Hello,
I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...
- ...I went to
Most likely, you need only 1 ODBC driver. Otherwise causing a clash.
For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)
You need both in order to support both 32 and 64 bit applications. That's the only reason to install both.
Stefan
- ...and first installed the MonetDB ODBC driver, 32 bit (to
C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver)
- ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program
Files\MonetDB\MonetDB ODBC Driver)
- ...and finally I installed the MonetDB SQL server and client, 64
bit (to C:\Program Files\MonetDB\MonetDB5).
When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?
Did you start the server using the start menu? That actually runs a cmd script to set a bunch of environment variables before starting the actual server mserver5.exe.
I would appreciate any hint. Thanks in advance.
Kaspar Burger
users-list mailing list 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
-- Sjoerd Mullender
users-list mailing list 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
kaspar has something changed? when you and i screenshared to try to resolve this issue, mserver.exe was shutting down immediately before R ever came into the picture?
what happens when you run this file independent of R?
C:\Users\Kaspar Burger\MonetDB\test.bat
On Tue, Jun 10, 2014 at 2:42 AM, Hannes Mühleisen Hannes.Muehleisen@cwi.nl wrote:
This seems to fall into my backyard...
On 10.06.2014, at 08:32, Kaspar Burger kaspar.burger@iukb.ch wrote:
I am working in R, configuring a MonetDB test database and trying to access MonetDB with the following code:
batfile <- "C:/Users/Kaspar Burger/MonetDB/test.bat" pid <- monetdb.server.start( batfile ) dbname <- "test" dbport <- 50000 monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname ) db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE )
When I run the “pid <- monetdb.server.start( batfile )” line, the mserver5.exe opens briefly but shuts down immediately afterwards (for a more extensive description of the R code, see:
https://raw.githubusercontent.com/ajdamico/usgsd/master/MonetDB/monetdb%20da... ).
By contrast, running the batch file from C:\Program Files\MonetDB\MonetDB5\M5server.bat or from the Start menu works fine. I tried when both drivers were installed as well as when only one driver
was
installed. Could that problem be related to R or to my code?
Would not be surprised if the space in the batfile path causes the problem. Try setting up the DB into another directory without a space in it and try again.
Best,
Hannes
On 2014-06-10 00:06, Stefan Manegold wrote:
On 09/06/14 16:28, Kaspar Burger wrote:
Hello,
I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...
- ...I went to
Most likely, you need only 1 ODBC driver. Otherwise causing a clash.
For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)
You need both in order to support both 32 and 64 bit applications. That's the only reason to install both.
Stefan
- ...and first installed the MonetDB ODBC driver, 32 bit (to
C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver)
- ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program
Files\MonetDB\MonetDB ODBC Driver)
- ...and finally I installed the MonetDB SQL server and client, 64
bit (to C:\Program Files\MonetDB\MonetDB5).
When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?
Did you start the server using the start menu? That actually runs a cmd script to set a bunch of environment variables before starting the actual server mserver5.exe.
I would appreciate any hint. Thanks in advance.
Kaspar Burger
users-list mailing list 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
-- Sjoerd Mullender
users-list mailing list 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
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
You are right, Anthony, when I run the file independent of R, mserver.exe shuts down immediately.
De : users-list [mailto:users-list-bounces+kaspar.burger=iukb.ch@monetdb.org] De la part de Anthony Damico Envoyé : mardi 10 juin 2014 08:51 À : Communication channel for MonetDB users Objet : Re: MonetDB problem with mserver.exe
kaspar has something changed? when you and i screenshared to try to resolve this issue, mserver.exe was shutting down immediately before R ever came into the picture?
what happens when you run this file independent of R?
C:\Users\Kaspar Burger\MonetDB\test.bat
On Tue, Jun 10, 2014 at 2:42 AM, Hannes Mühleisen Hannes.Muehleisen@cwi.nl wrote:
This seems to fall into my backyard...
On 10.06.2014, at 08:32, Kaspar Burger kaspar.burger@iukb.ch wrote:
I am working in R, configuring a MonetDB test database and trying to access MonetDB with the following code:
batfile <- "C:/Users/Kaspar Burger/MonetDB/test.bat" pid <- monetdb.server.start( batfile ) dbname <- "test" dbport <- 50000 monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname ) db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE )
When I run the “pid <- monetdb.server.start( batfile )” line, the mserver5.exe opens briefly but shuts down immediately afterwards (for a more extensive description of the R code, see: https://raw.githubusercontent.com/ajdamico/usgsd/master/MonetDB/monetdb%20da...). By contrast, running the batch file from C:\Program Files\MonetDB\MonetDB5\M5server.bat or from the Start menu works fine. I tried when both drivers were installed as well as when only one driver was installed. Could that problem be related to R or to my code?
Would not be surprised if the space in the batfile path causes the problem. Try setting up the DB into another directory without a space in it and try again.
Best,
Hannes
On 2014-06-10 00:06, Stefan Manegold wrote:
On 09/06/14 16:28, Kaspar Burger wrote:
Hello,
I seem to have difficulties with mserver.exe. I would like to use MonetDB on a Windows 64 bit computer, so...
- ...I went to
Most likely, you need only 1 ODBC driver. Otherwise causing a clash.
For the records, as by our own documentation, on a 64-bit Windows system, both the 32-bit and the 64-bit ODBC driver *must* be installed. (As far as I understand, this is required to support both 32-bit and 64-bit applications, or simply because Windows requires it.)
You need both in order to support both 32 and 64 bit applications. That's the only reason to install both.
Stefan
- ...and first installed the MonetDB ODBC driver, 32 bit (to
C:\Program Files (x86)\MonetDB\MonetDB ODBC Driver)
- ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program
Files\MonetDB\MonetDB ODBC Driver)
- ...and finally I installed the MonetDB SQL server and client, 64
bit (to C:\Program Files\MonetDB\MonetDB5).
When I open up mserver.exe, it shuts down immediately. Does anyone know what could have gone wrong?
Did you start the server using the start menu? That actually runs a cmd script to set a bunch of environment variables before starting the actual server mserver5.exe.
I would appreciate any hint. Thanks in advance.
Kaspar Burger
users-list mailing list 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
-- Sjoerd Mullender
users-list mailing list 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
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
When I open up mserver.exe, it shuts down immediately. Does anyone know
what could have gone wrong?
How exactly are you running mserver5.exe? Are you running the batch file C:\Program Files\MonetDB\MonetDB5\M5server.bat (assuming that you used the default installation paths), are you running C:\Program Files\MonetDB\MonetDB5\bin\mserver5.exe with your own arguments, or are you starting the server by clicking Start --> MonetDB5 --> MonetDB SQL Server?
participants (7)
-
Anthony Damico
-
Hannes Mühleisen
-
Kaspar Burger
-
Kostis Kyzirakos
-
Martin Kersten
-
Sjoerd Mullender
-
Stefan Manegold