Re: MonetDB problem with mserver.exe

10 Jun 2014


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