Re: MonetDB problem with mserver.exe

10 Jun 2014

      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