Re: MonetDB problem with mserver.exe

10 Jun 2014


      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
----- 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) |
_______________________________________________
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) |