For instance, simply replace the "@echo off" by an "@echo on" in your script, run the script, and provide us with the entire output it produces. Stefan ----- Original Message -----

Hi Kaspar,

are there any error messages?

What is the entire console output of your script?

What is the exact actual mserver5.exe command line, i.e., with all variables expanded?

Thanks. Stefan

----- Original Message -----

...

See attached.

...

On 06/10/2014 09:04 AM, Kaspar Burger wrote:

...

You are right, Anthony, when I run the file independent of R, mserver.exe shuts down immediately.

Could you please share your test.bat file?

...

*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 mailto:Hannes.Muehleisen@cwi.nl> wrote:

This seems to fall into my backyard...

On 10.06.2014, at 08:32, Kaspar Burger mailto: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... >>> >>> 1) ...I went to >>> https://www.monetdb.org/downloads/Windows/Jan2014-SP2/ >>> >> 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 > >>> 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?

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 mailto:users-list@monetdb.org >>> 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 >> >

-- Sjoerd Mullender

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org 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

_______________________________________________ users-list mailing list users-list@monetdb.org mailto: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

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

Hi again, Thanks so much for your help. In the meantime, I identified the problem. In the "set MONETDB=C:\Program Files\MonetDB\MonetDB5\" line and in the "set MONETDBDIR=C:\Users\Kaspar Burger\MonetDB\" line I had a backslash at the end which caused trouble. When I removed the backslash, the mserver5.exe did no longer exit on startup (see the attached file for the version that works). Thanks to everyone who took the time to think about and try to solve this problem. Kaspar

To avoid ambiguity, I'm talking about your "C:\Users\Kaspar Burger\MonetDB\test.bat" script.

Stefan

----- Original Message -----

...

For instance, simply replace the "@echo off" by an "@echo on" in your script, run the script, and provide us with the entire output it produces.

Stefan

...

Hi Kaspar,

are there any error messages?

What is the entire console output of your script?

What is the exact actual mserver5.exe command line, i.e., with all variables expanded?

Thanks. Stefan

----- Original Message -----

...

See attached.

...

On 06/10/2014 09:04 AM, Kaspar Burger wrote:

...

You are right, Anthony, when I run the file independent of R, mserver.exe shuts down immediately.

Could you please share your test.bat file?

...

*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 mailto:Hannes.Muehleisen@cwi.nl> wrote:

This seems to fall into my backyard...

On 10.06.2014, at 08:32, Kaspar Burger mailto:kaspar.burger@iukb.ch> wrote: > I am working in R, configuring a MonetDB test database and

...

...

...

...

> 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,

...

...

...

...

> 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

----- Original Message ----- trying the 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... >>>>> >>>>> 1) ...I went to >>>>> https://www.monetdb.org/downloads/Windows/Jan2014-SP2/ >>>>> >>>> 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 >>> >>>>> 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? >> >> 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 mailto:users-list@monetdb.org >>>>> 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 >>>> >>> >> >> -- >> Sjoerd Mullender >> >> _______________________________________________ >> users-list mailing list >> users-list@monetdb.org mailto:users-list@monetdb.org >> 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

_______________________________________________ users-list mailing list users-list@monetdb.org mailto: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

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list